NEW
Font size
S
M
L
XL
WorksheetsExcel Test
Total questions: 32
Worksheet time: 15mins
Name
Class
Date
1.
Which of these symbols can be used for IF Statements?
a)
=
b)
>
c)
<
d)
All of These
2.
PV and FV formulas are under which category of functions?
a)
Logical
b)
Financial
c)
Date & Time
d)
Math & Trig
3.
There is a chart called a Bubble chart
a)
True
b)
False
4.
The symbol for AutoSum is ______.
a)
Ω
b)
∑
c)
=
d)
None of these
5.
One way to have text in a cell take up 2 lines is to use _____________________.
a)
Merge & Center
b)
AutoWrap
c)
Wrap Text
d)
Sort & Filter
6.
Which key allows you to remove a section of a chart that is not needed?
a)
Escape
b)
Delete
c)
Enter
d)
Control
7.
The quickest way to find a total in Excel is by using __________.
a)
AutoTotal
b)
AutoSum
c)
AutoAdd
d)
AutoPlus
8.
To estimate how much you would owe on a new car each month, you should use the PMT formula.
a)
True
b)
False
9.
The __________ section in the Home tab allows you to format numbers as currency.
a)
Font
b)
Currency
c)
Styles
d)
Number
10.
When inserting a chart, which tool from the Layout tab allows you to see the ways it can be formatted?
a)
Quick Layout
b)
Fast Layout
c)
Quick Feature
d)
Fast Feature
11.
An “IF Statement” is which type of formula?
a)
Logical
b)
Situational
c)
Financial
d)
Choice
12.
What is the symbol for Mongolian (Cyrillic) currency?
a)
₮
b)
₡
c)
Ҩ
d)
₪
13.
Paste Special options include: Formulas, Column widths, Comments, and __________.
a)
Colors
b)
Values
c)
Tables
d)
Data
14.
When trying to format a specific section of a chart, one way is to ___________ on the section you want to change.
a)
Alt-Click
b)
Shift-Click
c)
Right-Click
d)
Function-Click
15.
Exchange rates compare one country’s currency in terms of another country’s currency.
a)
True
b)
False
16.
To insert a Column graph, go to the Insert Tab and then to the ____________ section?
a)
Tables
b)
Illustrations
c)
Charts
d)
Text
17.
Which tab allows you to “Change Chart Type”?
a)
Layout - Contextual Tab
b)
Design - Contextual Tab
c)
Insert - Contextual Tab
d)
Format - Contextual Tab
18.
Columns in Excel are identified in which of the following ways?
a)
By letter
b)
By color
c)
By number
d)
By location
19.
Which formula would be helpful in predicting an amount saved for college?
a)
PV
b)
PMT
c)
IRR
d)
FV
20.
All of these options are under the Design – Contextual Tab for charts except?
a)
Quick Layouts
b)
Background
c)
Change Chart Type
d)
Select Data
21.
The keyboard shortcut for Wrap Text is ___________.
a)
Control + Enter
b)
Control + Space
c)
Alt + Enter
d)
Alt + Space
22.
Which currency is NOT one of the main countries when clicking the “$” dropdown?
a)
English (UK)
b)
Euro
c)
Chinese
d)
Canadian
23.
Which of these is not a type of chart?
a)
Pie
b)
Line
c)
Angle
d)
Bar
24.
Excel is the only Office program that lets you insert charts & graphs.
a)
True
b)
False
25.
To add a title to your chart, one option is found under what symbol?
a)
Green Plus Sign
b)
Red Minus Sign
c)
Green Smiley Face
d)
Yellow Paint Brush
26.
The ______________ section in the home tab allows you to increase or decrease the number of decimal places.
a)
Number
b)
Styles
c)
Alignment
d)
Font
27.
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
28.
Once you have inserted a chart, what tab allows you to change the Chart Style?
a)
Design - Contextual Tab
b)
Page Layout
c)
Home
d)
Insert
29.
Which section of the Home tab allows you to change the formatting to different currencies?
a)
Font
b)
Alignment
c)
Number
d)
Cells
30.
Which formula would allow you to answer a basic Yes or No question?
a)
PMT
b)
Count
c)
FV
d)
IF
31.
Which option shows the fill handle?
a)
A
b)
B
c)
C
d)
D
32.
What formula would calculate how much money you need now to reach your goal for retirement?
a)
PV
b)
FV
c)
PMT
d)
IF
Reset
