NEW
Font size
S
M
L
XL
WorksheetsExcel Lessons 1 & 2
Total questions: 20
Worksheet time: 10mins
Name
Class
Date
1.
What command will arrange Microsoft Excel windows so that they appear side-by-side on the screen?
a)
Zoom to Selection
b)
New Window
c)
Arrange All
d)
Freeze Panes
2.
Joyce needs to access a spreadsheet she saved yesterday. Which command would she select?
a)
Exit
b)
Open
c)
Save
d)
Save As
3.
Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel?
a)
Workbook
b)
Worksheet
c)
Notepad
d)
Folder
4.
Which Microsoft Office object would you use for quick, convenient, one-click access to frequently used Excel commands?
a)
Formula Bar
b)
Title Bar
c)
Status Bar
d)
Quick Access Toolbar
5.
Sharon’s spreadsheet contains information about the number of music downloads in F25. In this address, ‘25’ identifies the:
a)
cell
b)
column
c)
row
d)
range
6.
John wants to be able to view multiple areas of his spreadsheet at the same time. What would be his best option?
a)
Freeze Panes
b)
Split
c)
Hide
d)
Unhide
7.
Which command among the window control buttons is used to close an open file and completely exit the Microsoft Excel program?
a)
Close
b)
Save As
c)
Exit
d)
Quit
8.
Which ribbon option opens a related dialog box?
a)
Ellipse
b)
Drop-down Arrow
c)
Launcher
d)
Slider
9.
Which area on the left side of the formula bar indicates the cell address of a selected cell?
a)
Cell Box
b)
Address Box
c)
Name Box
d)
Formula Box
10.
Which tab is used to display the area that contains the print command?
a)
Home
b)
Page Layout
c)
View
d)
File
11.
Joan is creating a table that will include demographic information about her employees. What is each header in her table considered?
a)
Label
b)
Value
c)
Formula
d)
Function
12.
Joyce has updated the data in an existing spreadsheet. Which command would she select to preserve the data for future use?
a)
Exit
b)
Open
c)
Save
d)
Save As
13.
In a Microsoft Excel worksheet, how do you change the width of a column so that the widest entry will fit?
a)
Smart Fit
b)
Auto Fit
c)
Best Fit
d)
True Fit
14.
Which command on the Fill options dialog box is the default option if a month or day is entered?
a)
Copy Cells
b)
Fill Formatting Only
c)
Fill without Formatting
d)
Fill Series
15.
Sharon’s spreadsheet contains information about the number of music downloads in F1:F25. F1:F25 represents a:
a)
cell
b)
column
c)
range
d)
row
16.
In Microsoft Excel, which feature makes an exact replica of the cell data and format while keeping the original cell intact?
a)
Paste
b)
Move
c)
Cut
d)
Copy
17.
David wants to key the numbers 1 to 1,000 in Column A of his spreadsheet. What command should he use to complete this task?
a)
Auto Fill
b)
Filter
c)
Find and Replace
d)
Sort
18.
What is the name of the list of frequently used Excel commands available when a user right-clicks an item in the worksheet?
a)
Mini Toolbar
b)
Quick Access toolbar
c)
Shortcut Menu
d)
Shortcut Toolbar
19.
Alicia needs to move the data in cell B5 to cell E5. Which command would she select?
a)
Clear
b)
Copy
c)
Cut
d)
Format Painter
20.
Which term refers to a group of selected cells that may be formatted, moved, copied or deleted as a group?
a)
Segment
b)
Set
c)
Range
d)
Cluster
Reset
