Excel Test Questions Lesson 1-3

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 command among the window control buttons is used to close an open file and completely exit the Microsoft Excel program?

• Close

• Save As

• Exit

• Quit

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

• Workbook

• Worksheet

• Notepad

• Folder

Sharon’s spreadsheet contains information about the number of music downloads in F25. In this address, ‘25’ identifies the:

• Cell

• Column

• Range

• Row

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 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

What command will arrange Microsoft Excel windows so that they appear side-by-side on the screen?

• Zoom to Selection

• New Window

• Arrange All

• Freeze Panes

John wants to be able to view multiple areas of his spreadsheet at the same time. What would be his best option?

• Freeze Panes

• Split

• Hide

• Unhide

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

• Exit

• Open

• Save

• Save As