Exam 8: Excel 3: Formatting a Worksheet

Normally, you don't need to adjust row heights manually because row heights adjust automatically to accommodate font size changes.

The Format Painter button is found in the ____ group on the Home tab of the Ribbon.

To add an image to a worksheet, click Pictures in the Illustrations group on the Home tab. _________________________

When you insert a new column, the contents of the worksheet shift to the left from the point of the new column.

To hide a selected column, click the _____ button in the Cells group on the Home tab.​

The color of a tab changes depending on whether it is the ____________________ tab.

Critical Thinking Questions Case1-1 Sara is the owner of a specialty goods store. To keep a record of the goods that she has in stock and their prices, she has created a very large worksheet. She is not the best speller in the world, however, so she would like to use the spell checker to ensure that her worksheet does not have any spelling mistakes. Sara is not familiar with this feature of Excel and has asked you for help. Sara wants to indicate to Excel that a given flagged word should not be marked as a misspelling in the future. Which option do you tell her to select?

Cell templates are sets of cell formats based on themes; they are automatically updated if you change a theme. _________________________

The Find & Select button is found in the Editing group on the ____ tab on the Ribbon.

Explain why you would add colors, patterns, and borders to a worksheet.

Critical Thinking Questions Case1-1 Sara is the owner of a specialty goods store. To keep a record of the goods that she has in stock and their prices, she has created a very large worksheet. She is not the best speller in the world, however, so she would like to use the spell checker to ensure that her worksheet does not have any spelling mistakes. Sara is not familiar with this feature of Excel and has asked you for help. If Sara adds words to the dictionary using any of the following EXCEPT ____, you tell her that the words will also available in Excel.

You must apply borders to all the cells in a worksheet; you cannot apply them only to selected cells.

The ____________________ number format adds dollar signs and two decimal places to the data.

Cell ____ are predesigned combinations of formats.

Critical Thinking Questions Case1-1 Sara is the owner of a specialty goods store. To keep a record of the goods that she has in stock and their prices, she has created a very large worksheet. She is not the best speller in the world, however, so she would like to use the spell checker to ensure that her worksheet does not have any spelling mistakes. Sara is not familiar with this feature of Excel and has asked you for help. Excel has flagged a spelling mistake and Sara has decided that she would like to adjust the spelling of all instances of this misspelling. Which option do you tell her to select?

You can apply font styles and alignment options using the ____ dialog box.

If you create a conditional formatting rule you can modify it using the Conditional Formatting ____.

You can add words to the dictionary of the spelling checker.

Critical Thinking Questions Case1-1 Sara is the owner of a specialty goods store. To keep a record of the goods that she has in stock and their prices, she has created a very large worksheet. She is not the best speller in the world, however, so she would like to use the spell checker to ensure that her worksheet does not have any spelling mistakes. Sara is not familiar with this feature of Excel and has asked you for help. Sara has a proper name in the worksheet, all instances of which she would like the spell checker to skip over. What option do you tell her to select?

The font size is measured in units called pixels . _________________________