NEW
Font size
S
M
L
XL
WorksheetsExcel Quiz
Total questions: 25
Worksheet time: 14mins
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.
Which of the following operators do you use to begin typing a formula?
a)
*
b)
+
c)
=
d)
/
4.
Rows are which of the following:
a)
vertical
b)
horizontal
5.
Columns are vertical.
a)
True
b)
False
6.
What does every formula or function start with?
a)
!
b)
@
c)
#
d)
=
7.
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)
8.
What instructs the software to perform a calculation?
a)
value
b)
label
c)
formula
9.
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
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.
The quickest way to find a total in Excel is by using __________.
a)
AutoTotal
b)
AutoSum
c)
AutoAdd
d)
AutoPlus
13.
_________ allows you to perform calculations on data entered into a spreadsheet?
a)
Formulas
b)
Data
c)
Cell
d)
Cell reference
14.
Excel allows you to
a)
read stories
b)
work with data
c)
invent ideas
d)
create presentations
15.
In a worksheet, the vertical spaces with letter headings.
a)
Rows
b)
Cell addresses
c)
Columns
16.
A command line above the worksheet where text, numbers, and formulas are entered into a worksheet.
a)
Insert
b)
Formula bar
c)
Tables
17.
In a worksheet, the horizontal spaces with the headings 1,2,3, and so on.
a)
Rows
b)
Columns
c)
Bold
d)
Italics
18.
How is the COLUMN in a MS Excel Spreadsheet named?
a)
Numbers
b)
Letters
c)
Cells
d)
Columns
19.
How are ROWS in MS EXCEL spreadsheet named?
a)
numbers
b)
letters
c)
cells
d)
columns
20.
What is a rectangular box in a MS EXCEL Spreadsheet called?
a)
row
b)
column
c)
cell
21.
What is the name of the cell that is colored blue?
a)
A
b)
B
c)
2B
d)
B2
22.
Which is a formula using MS Excel using addition.
a)
2 + 3 =
b)
= A + B
c)
=A2+B3
d)
A2+B3
23.
What function do you press to center a title in 5 cells in one row?
a)
Title YES
b)
Merge and Center
c)
A1+B1+C1+D1+E1
d)
Center
24.
What is an example of a RANGE in MS Excel.
a)
B2-F5
b)
F5:B2
c)
B2:5F
d)
(B2:F5)
25.
Which Formula is written correctly for multiplying cell A1 and A7?
a)
=A1+A7
b)
=A1*A7
c)
A1+A7
d)
A1*A7
Reset
