Formatting a Worksheet (Excel 2016)

Which icon is used for the Format Painter option? A.) a paintbrush B.) a pencil C.) a paint bucket D.) the letter P

A.) a paintbrush

Seamus has too much text in one cell but wants all the information to be visible at once. What should he do? A.) force the text to wrap B.) force the text to spill-over C.) truncate the text D.) force the text to be inserted to next cell

A.) force the text to wrap

Live Preview, found in the Font group, uses which method for seeing different font sizes without committing to them? A.) double-clicking the sizes on the Size drop-down list B.) pointing the mouse pointer to the sizes on the Size drop-down list C.) right-clicking the cell and clicking Preview Size on the drop-down list D.) clicking the sizes on the Size drop-down list

B.) pointing the mouse pointer to the sizes on the Size drop-down list

Which tab should be selected to add a hyperlink within a cell? A.) Home tab B.) Review tab C.) Insert tab D.) Formula tab

C.) Insert tab

What does the currency formatting look like within the cell if the original number was 62453? A.) $62,453 B.) 62,453.00 C.) $62,453 D.) $62,453.00

D.) $62,453.00

Which categories format cells? Check all that apply. currency percentage data month date text

currency percentage date text

Samantha wants to create a custom font color for her headers. Put the steps in order from first to last (1-4) 1. Select more colors 2. Select Custom tab 3. Select the cell 4. Select the color drop-down

1. Select the Cell 2. Select the color drop-down 3. Select more colors 4. Select Custom tab

When would you most likely use the Merge and Center option? A.) when you want to add the cell numbers together B.) when you want to know the percentage of an amount C.) when only one cell has data but you want to center that information D.) when you want to multiply all available cells

C.) when only one cell has data but you want to center that information

Nico needs to change the font and color of his worksheet at once. Use the drop-down menu to determine what he should do. First, he should select all of the worksheet at once by clicking the (Tell Me bar, top left corner of worksheet, top right corner of worksheet). Then, he should right-click the (font drop-down choices, color drop-down choices, paintbrush) to change the font of the whole worksheet at once. Release the cursor and select the (font drop-down choices, color drop-down choices, paintbrush) to change the color of the font Release the cursor and both font and color should be changed.

Top left corner of worksheet Font drop-down choices Color drop-down choices