WorksheetsExcel Lesson 1 Quiz
Total questions: 19
Worksheet time: 19mins
Which notebook-like feature organizes the sheets for use in Excel?
Workbook
Worksheet
Notepad
Folder
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 Microsoft Office object would you use for quick, convenient, oneclick access to frequently used Excel commands?
Quick Access Toolbar
Title bar
Status bar
Formula Bar
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
Joyce needs to access a spreadsheet she saved yesterday. Which command would she select?
Exit
Open
Save
Save As
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?
Magnify Area
Enlarge Selected Area
Amplify Range
Zoom to Selection
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 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 ribbon option opens a related dialog box?
Ellipse
Drop-down Arrow
Launcher
Slider
Which tab is used to display the area that contains the print command?
Home
Page Layout
View
File
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 is the default view used in Microsoft Excel?
Page Layout
Normal
Web
Which view enables a user to create or modify a worksheet while seeing how it will look in printed format?
Page Layout
Normal
Web
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
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.
Sharon’s spreadsheet contains information about the number of music downloads in F25. In this address, ‘25’ identifies the:
cell
column
range
row
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
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
. 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
