0
In order to use the Format Painter to replicate formatting over multiple non-adjacent cells what additional step do you need to take?
Wiki User
∙ 6y agoWant this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
What is an additional Common multiple?
A common multiple of 4 and 6 is 12. An additional common multiple of 4 and 6 is 24. It just means "another one."
Which word view can be helpful for editing and formatting longer document that include multiple headings?
Outline
Which word view be helpful for editing and formatting longer documents that include multiple headings?
Outline
Do animal cells have mitosis more than once?
Depends on the cell. If the cell needs to replicate multiple times to produce more cells, then yes, it will. The cells will replicate until maximum capacity is reached.
How do you deselect format painter?
If you click it once and then apply formatting, it will turn itself off automatically. If you double click it, it will turn it on and allow you to do multiple formatting, pasting formatting onto anything you click. If you click the Format Painter again, it will turn it off.
What allows you to enter custom criteria such as multiple options or ranges of numbers?
Conditional formatting I do believe. -N.P.
Which views allows you to rearrange delete and apply multiple formatting to slides?
Slide Sorter view.
What is the difference between partitioning and formatting?
disk partitioning is the act of dividing a hard disk into multiple logical storage units referred to mas part ions to treat one disk as if it were multiple disks. disk formatting is the process of preparing a data storage disk for initial use.
Why are multiples of 2 and 4 not also a multiple of 8?
Because 2 is a factor of 4. If a number is a multiple of four, when you add that it is a multiple of 2 there is no extra information, no additional factor.
What additional benefit is there to setting up a paging file on multiple hard drives?
Windows can handle multiple I/O requests more quickly.
How can you format multiple hard drives with one machine?
Yes, I am formatting two ipod hard drives right not, connected via usb in disk mode.
How do you use multiple IFs in Excel?
It really depends on what it is you are trying to do. If you have a combined set of multiple conditions, using IF functions may work. IF functions may be nested, meaning that another IF function could form part of the True or False values. As an overall example, if in the cell B3 you had a value which must be multiplied by 10 if it is over 100 or else multiplied by 5 if greater than 50 or by 3 if less than or equal to 50, we will then as part of the False one IF value have to evaluate if B3 is over 50 or not, having already discovered that it is less than 100. The function will include a nested IF function as its False value which must include the same 3 component parts as any IF function: =IF(B3>100, B3*10, IF(B3>50, B3*5, B3*3) ) Our Condition and True values are the same as a normal IF, but our False value is itself an IF function having a Condition, True and False values. Note that we also have 2 brackets at the end to close the 2 IF functions. The final bracket corresponds to the opening of the first IF. When using multiple IF functions you will always have one less IF than the amount of conditions. In the example given we had 3 possible categories, but the formula only required 2 IF functions. Every IF eliminates one possibility. When the second last possibility has been eliminated, as there is only 1 remaining possibility left, it does not need a further IF function to test if it is True. The final possibility never needs to be tested for. In our example we had 3 possibilities. If our value is not over 100 and not over 50 then it must be less than 50, so we do not need to check for that possibility. IF functions may be nested quite deeply at times and require careful thought at all times. It is easy to make a mistake, so they should be thoroughly tested. It is not a good idea to nest too many IF functions. In some cases, using another method might be more appropriate, such as using VLOOKUP. It really depends on what it is that you are trying to achieve, so each case is different.
