Exam 8: Excel 3: Formatting a Worksheet

Which of the following removes only the contents of a selected row or column?

The ____ size is the physical size of the text.

When you change a theme, cell styles are automatically updated.​

The Format Painter button copies both the cell's content and formatting.

You can change colors, patterns, and borders of cells by using the Fill tab and the Border tab in the ____ dialog box.

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. After you have helped Sara fix the spelling mistakes in the workbook, she wants to send it to a business colleague. To send it as an email message attachment, you tell her to open it, click the FILE tab, and then click ____ on the navigation bar.

You can apply font styles and alignment options using the ____ tab of the Ribbon.

The default format for cells that meet a condition with conditional formatting is ____.

With Excel, you can adjust the width of one or more columns by using the mouse.

You insert a comment in a worksheet by using a command on the ____ tab on the Ribbon.

Once you have formatted a range as a table, you can use Live Preview to view the table​ in other styles. ____________________

The Increase Decimal button automatically adds dollar signs and two decimal places to your data.

The ____________________ heading is the box at the top of each column containing a letter.

Double-clicking the column line to the right of a column activates the ____ feature for the column.

It can be difficult to see a(n) ___________________ when a cell is selected.

You can search for online pictures in Office.com, through the Bing search engine, or on OneDrive by typing one or more ____________________, which are words related to your subject.

A ____ is an individual media file, such as art, sound, animation, or a movie.