Excel Chapter 1 Test

Which is the shortcut key for accessing Microsoft Office Word Help from the Word window?

• Open
• exit
• save
• save as

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 of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel?

• Workbook
• Worksheet
• Notepad
• Folder

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 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 view is the default view used in Microsoft Excel?

• Page Layout
• Print
• Normal 
• Web

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

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

• cell
• column
• range
• row

Which ribbon option opens a related dialog box?

• Ellipse
• Drop down Arrow
• Launcher
• Slider

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