Excel Lesson 1&2 Pt 2

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

• The row is selected.
• The cell is selected.
• The column is selected.
• The worksheet is selected.

Joan has a table that includes demographic information about her employees. If the demographic information is listed across the top and employee names down the left side of the table, what does all the information about one employee represent?

• Entry
• Workbook
• Row
• Column

Joan wants to add a new entry at the bottom of her spreadsheet. What is the shortcut that will take her to the last record on her spreadsheet?

• Ctrl + Home
• Ctrl + End
• Ctrl + Up Arrow
• Ctrl + 1

Which software program is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data?

• Microsoft Word
• Microsoft Publisher
• Microsoft Excel
• Microsoft PowerPoint

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

• Cell box
• Address box
• Name box
• Formula box

Which view is the default view used in Microsoft Excel?

• Page Layout
• Print
• Normal
• Web

What feature was created for users who prefer to use the keyboard rather than the mouse, and provides keyboard code icons that may be used in conjunction with the ALT key?

• Quick Access Toolbar
• Hot Keys
• Mini Toolbar
• Key Tips

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

• Workbook views
• Show
• Zoom
• Window

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

• Page Layout
• Print
• Normal
• Web

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

• Quick Access Toolbar
• Title bar
• Status bar
• Formula Bar