NEW
Font size
S
M
L
XL
WorksheetsExcel Time Pass 2
Total questions: 20
Worksheet time: 12mins
Name
Class
Date
1.
The feature to center text across several cells is called:
a)
Wrap Text
b)
Merge and Center
c)
Shrink to Fit
d)
Number Formatting
2.
Microsoft Excel is what type of software?
a)
Word Processing
b)
Spreadsheet
c)
Presentation
d)
Drawing
3.
This icon is called the what?
a)
Arrow
b)
Fill handle
c)
Pointer
4.
For which of the following tasks would you use the fill handle?
a)
to apply shading
b)
to apply a border
c)
to copy a formula from cell A2 to cell A3
5.
Which of the following operators do you use to begin typing a formula?
a)
*
b)
+
c)
=
d)
/
6.
Excel allows you to
a)
read stories
b)
work with data
c)
invent ideas
d)
create presentations
7.
_________ allows you to perform calculations on data entered into a spreadsheet?
a)
Formulas
b)
Data
c)
Cell
d)
Cell reference
8.
Place where you can rename each worksheet. Located at the bottom of the worksheet window.
a)
Sheet tab
b)
Formula
c)
Name Box
d)
Chart
9.
An excel file with one or more worksheets
a)
Workbook
b)
Worksheet
c)
Formula
d)
Row
10.
What does this symbol do:
/
/
a)
Multiply
b)
Add
c)
Divide
d)
Minus
11.
What does this symbol do:
*
*
a)
Multiply
b)
Add
c)
Divide
d)
Minus
12.
Rows are which of the following:
a)
vertical
b)
horizontal
13.
Columns are vertical.
a)
True
b)
False
14.
What does every formula or function start with?
a)
!
b)
@
c)
#
d)
=
15.
What is the formula to find the lowest number in cells C1:C4?
a)
=average(C1:C4)
b)
=max(C1:C4)
c)
=min(C1:C4)
d)
=sum(C1:C4)
16.
What instructs the software to perform a calculation?
a)
value
b)
label
c)
formula
17.
What is the Order of Operations?
a)
PEDMAS
b)
PSMADE
c)
PMSADE
d)
PEMDAS
18.
The quickest way to find a total in Excel is by using __________.
a)
AutoTotal
b)
AutoSum
c)
AutoAdd
d)
AutoPlus
19.
Which feature would allow you to change the formatting of any cells that are less than $100.00?
a)
Cell Formatting
b)
Easy Formatting
c)
Auto Formatting
d)
Conditional Formatting
20.
Which option shows the fill handle?
a)
A
b)
B
c)
C
d)
D
Reset
