Exam 4: Excel Lesson 2: Formatting and Editing Worksheets

A selected cell or range is indicated by a(n) ____.

To copy a selection using the drag-and-drop method, you press and hold ____ while you drag and drop the selection.

Calibri is the default ____ used in all Excel workbooks.

When cells are merged, the content from the ____ cell in the range is preserved and becomes the cell reference for the merged cells.

FIGURE EX 2-1 In Figure EX 2-1 above, the ScreenTip is displaying ____.

You will not typically need to use Column Width commands because Excel changes the column width automatically to accommodate the data and font size.

Clicking the Spelling button in the Proofing group on the ____ tab on the Ribbon opens the Spelling dialog box.

A(n) ____________________ is a set of predesigned formatting elements--including colors, fonts, and effects--that can be applied to an entire workbook.

You can use the ____________________ method to move or copy a selection using the mouse.

When you paste data in a cell or range, Excel replaces any existing data.

Font sizes are measured in ____.

You can create a new workbook from Backstage view at any time by clicking Create on the File tab.

Case EX 2-2 Iris has created an invoice using Excel. Now she needs to alter the structure of the worksheet by making changes to the rows and columns. When Iris double-clicks the right border of a column heading on the invoice worksheet, what happens?

When you format data as a table, a contextual Table Tools Design tab is displayed on the Ribbon.

The commands in the Theme group are located on the ____ tab on the Ribbon.

Case EX 2-1 Yogi has used Excel to create a sales report. He would like to format it attractively before printing it out for an upcoming sales meeting. Which button would Yogi use to display text in a cell on multiple lines so it is all visible?

The ____ dialog box opens when you click the Insert Cells command.

If you wanted to use Excel to create a new monthly budget workbook, what would you need to do in the planning process? After creating it, what could you do to format or edit the worksheet?

The Rotate button in the Alignment group on the Home tab allows you to rotate text in a cell.