Modifying a Worksheet

Question 1

When would you most likely use the Merge and Center option?

Revolt · Accepted Answer

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

Question 2

Then, he should right-click the to change the font of the whole worksheet at once.

Revolt · Accepted Answer

Font drop-down choices

Question 3

Release the cursor and select the to change the color of the font.

Revolt · Accepted Answer

Color drop-down choices

Question 4

Live Preview, found in the Font group, uses which method for seeing different font sizes without committing to them?

Revolt · Accepted Answer

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

Question 5

Which tab should be selected to add a hyperlink within a cell?

Revolt · Accepted Answer

Insert tab

Question 6

Which icon is used for the Format Painter option?

Revolt · Accepted Answer

a paintbrush

Question 7

First, he should select all of the worksheet at once by clicking the .

Revolt · Accepted Answer

top left corner of worksheet

Question 8

Which categories format cells? Check all that apply.currencypercentagedatamonthdatetext

Revolt · Accepted Answer

currency; percentage; date; text

Question 9

What does the currency formatting look like within the cell if the original number was 62453?

Revolt · Accepted Answer

$62,453.00

Question 10

Seamus has too much text in one cell but wants all the information to be visible at once in the same cell. What should he do?

Revolt · Accepted Answer

force the text to wrap

Modifying a Worksheet Answers