Excel 2016 - Lesson 1

Joan has entered her name in the First Name field in cell B2 of her table. What does her First Name represent in the table?

• Entry

• Row

Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel?

• Workbook

• Worksheet

Which view enables a user to create or modify a worksheet while seeing how it will look in printed format?

• Page Layout

• Normal

What command do you use to increase or decrease the view of a selected cell or range of cells to fill the Excel Window area for better visibility?

• Zoom to selection

• Magnify area

What occurs when the cursor is moved over a cell and a user clicks?

• The cell is selected

• The row is selected

Which group on the View Ribbon enables a user to show or hide the rule, gridlines, Formula Bar, or headings?

• Show

• Window

Which ribbon option opens a related dialog box?

• Launcher

• Drop-down arrow

Which Microsoft Office object would you use for quick, convenient, one-click access to frequently used Excel commands?

• Quick Access Toolbar

• Status bar

Which command among the window control buttons is used to close an open file and completely exit the Microsoft Excel program?

• Close

• Exit

Which area on the left side of the formula bar indicates the cell address of the selected cell?

• Name box

• Address box