Exam 8: Excel 3: Formatting a Worksheet

How do you format a cell or range?

Cells and ranges in a worksheet can be formatted ____.

You can apply formatting before or after you enter data in a cell or range.

To remove all formatting for a selected range, click the _____ button in the Editing group on the Home tab.​

After inserting or deleting rows or columns in a worksheet, be sure to proof formulas that contain relative cell references. _________________________

Table styles are organized in four categories: Black & White, Light, Medium, and Dark.​

What is meant by the format of a cell?

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 word in the worksheet that appears to be misspelled in a given instance, but she would like it to be ignored in this one instance. Which option do you tell her to select?

You can use colors, patterns, and borders to enhance the overall appearance of a worksheet and to make it easier to read. One of the ways of adding these enhancements is to use the Borders, Font Colors, and Fill Color buttons in the Font group on the ____ tab of the Ribbon.

The default Accounting number format adds dollar signs and ____ decimal places to the data.

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 word in the worksheet, the spelling of which she would like to change in this one instance. Which option do you tell her to select?

It is acceptable for dates to have a currency format.

You can change the ____ of labels and values in cells to be left, right, or center.

The Spelling button is found in the Proofing group on the ____ tab on the Ribbon.