NEW
Font size
S
M
L
XL
WorksheetsExcel 2013
Total questions: 15
Worksheet time: 5mins
Name
Class
Date
1.
All capital letters must be used when entering formulas.
a)
TRUE
b)
FALSE
2.
How many worksheets are contained in a new blank workbook?
a)
1
b)
2
c)
3
d)
4
3.
How do you make a cell the active cell?
a)
Click the ACTIVE button
b)
Click INSERT CELL
c)
Click on the cell
d)
Cells are always active
4.
Which symbol must you use to begin a formula?
a)
+
b)
=
c)
/
d)
*
5.
Which button/icon do you click on to center a group of cells across a range?
a)
Merge and Center
b)
Merge and Combine
c)
Center
d)
Justify
6.
Which view should you be in to view headers and footers?
a)
Normal
b)
Page Layout
c)
Master
d)
Worksheet
7.
In Backstage View, what option do you click on to be able to save your file as a PDF?
a)
Save and Send
b)
New
c)
Open
d)
Export
8.
Which formula appears when you click the AUTOSUM button?
a)
=SUM
b)
=AUTOSUM()
c)
=SUM()
d)
=AUTOSUM
9.
What is the shortcut used to toggle your formulas on and off?
a)
CTRL + ~
b)
CTRL + !
c)
CTRL + -
d)
CTRL + *
10.
What can you apply to a range of cells to show a condition (such as cells with a value greater than 50) has been met?
a)
Fill Color
b)
Conditional Formatting
c)
Sparkline Chart
d)
Formulas
11.
A chart must contain a legend.
a)
TRUE
b)
FALSE
12.
What is a group of worksheets in the same file called?
a)
Workset
b)
Workbook
c)
Notebook
d)
Chart
13.
Which dialog box should you use to display your comments "as seen on sheet."
a)
File
b)
Page Setup
c)
Formulas
d)
Insert
14.
In an Excel workbook, you can have multiple worksheets open at one time.
a)
TRUE
b)
FALSE
15.
Once you create a table in an Excel worksheet, you can add or remove rows and/or columns as needed.
a)
TRUE
b)
FALSE
Reset
