NEW
Font size
S
M
L
XL
WorksheetsExcel-lent Quiz
Total questions: 15
Worksheet time: 6mins
Name
Class
Date
1.
What is Microsoft Excel?
a)
Spreadsheet Software
b)
Word Processing Software
c)
Audio Editing Software
d)
Presentation Software
2.
What is the purpose of a spreadsheet?
a)
Store large amount of data
b)
Process and manipulate data
c)
perform calculation
d)
All of the above
3.
Where in a spreadsheet do we enter data?
a)
Search bar
b)
Form
c)
Word Document
d)
Cell
4.
What is a cell reference?
a)
Identify the location of a cell in a spreadsheet.
b)
The name of a formula
c)
Name of a spreadsheet
d)
Used to descibe columns
5.
What is an example of a cell reference.
a)
8B
b)
B8
c)
BB
d)
88
6.
What is a formula?
a)
Perform calculations in a spreadsheet.
b)
Is a predefined calculation.
c)
a tool to create a graph
d)
a tool to create a table
7.
What must we do first to tell the computer to perform any calculation?
a)
Put an = at the beginning
b)
Write SUM
c)
Write AVERAGE
d)
Perform an IF Statement
8.
Which one is not a function?
a)
SUM
b)
AVERAGE
c)
MIN
d)
DIVIDE
9.
An IF statement is used in Excel to check if a condition is True or False and then provides a result.
a)
True
b)
False
10.
Petra placed all of her grades from her science class into a worksheet. She wants to highlight all of the failing grades with red. Which of the following is quick way for her to do this?
a)
Conditional Formatting
b)
Page Layout
c)
Quick Format
d)
Cell Alignment
11.
Alex needs to add three cells and then divide the sum by 4. Which of the following is an example of the correct formula to do this?
a)
=(A1+A2+A3)/4
b)
A1+A2+A3/4
c)
=A1+A2+A3^4
d)
(A1+A2) + A3/4
12.
What would be a correct formula for sum in excel?
a)
=SUM(B3:B9)
b)
=SUMB3+B9
c)
SUM(B3:B9)
d)
=ADD(B3:B9)
13.
You can increase and decrease the amount of decimal places shown in a cell.
a)
True
b)
False
14.
You want to add a range of cells and then divide by the number of cell entries, determining the mean value of all values in the range. Which function should be used?
a)
MIN
b)
AVERAGE
c)
COUNT
d)
MAX
15.
How is a cell reference in a formula and its corresponding location in a worksheet identified?
a)
Arrows pointing from the formula to
the location
b)
Cell reference and cell location
are circled
c)
Cell reference and cell location are
outlined in matching colors
d)
Lines connect from the formula to
the location
Reset
