Excel Lesson 1 and 2

Joyce needs to access a spreadsheet she saved yesterday. Which command would she select?

• exit

• open

• save

• save as

Joan has a table that includes demographic information about her employees. What does all the information about one employee represent?

• entry

• workbook

• row

• column

Sharon's spreadsheet contains information about the number of music downloads in F25. "25" identifies the:

• cell

• column

• range

• row

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

• quick access toolbar

• status bar

• formula bar

• title bar

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 command do you use to close an open file and completely exit the Microsoft Excel program?

• close

• save as

• exit

• quit

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

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

• workbook

• row

• column

Which tab do you use to display the area that contains the print command?

• home

• page layout

• view

• file

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 workbook is selected