Exam 3: Excel Lesson 1: Understanding Excel Fundamentals

You can add as many as 255 worksheets to a workbook.

You can select ranges or cells that are nonadjacent by pressing ____ while you click.

The defined print area will be ____ when you save the worksheet.

Case EX 1-1 Clyde is using Excel to create a client invoice for the event-planning business that he operates from his home office. When Clyde enters a combination of numbers and text into a cell, the contents will be ____.

You can view a folder's contents or open the folder from the ____ in the Open dialog box.

You can undo any action you take in Excel by clicking the Undo button on the Ribbon.

You can use the ____________________ button on the Quick Access Toolbar to reverse an undo action.

The cell that is selected is called the active cell, which means it is ready for data entry.

When you drag the vertical scroll box, a ScreenTip displays the topmost ____ that is visible in the workbook window.

The Freeze Panes button is located on the ____ tab in the Window group.

FIGURE EX 1-1 Which of the following identifies the range shown in Figure EX 1-1?

Which of the following correctly identifies a range?

The rectangle where a column and row intersect is called a Name box .

To remove all the data from a cell, you can use the ____ button located in the Editing group of the Home tab on the Ribbon.

The formula bar next to the ____ displays the value or formula of the active cell.

The Go To command is helpful when you want to move to a part of the worksheet that is not visible in the worksheet window.

You can use the Freeze Panes menu to freeze the top row, the first column, or an area that you select.

You can deselect a cell or range by pressing an arrow key or clicking any cell in the worksheet.

____ in a worksheet are displayed vertically and labeled with headings from left to right.

When you ____________________, you lock specified rows or columns into place.