WorksheetsExcel Basics Quiz
Total questions: 20
Worksheet time: 40mins
Name
Class
Date
1.
A ___________ conveys a visual representation of data.
a)
chart
b)
picture
c)
text box
d)
style
2.
________ are horizontal
a)
Rows
b)
Columns
3.
A(n) _________ is a prewritten formula that is built into EXCEL.
a)
function
b)
problem
c)
equation
d)
equal sign
4.
A combination of numbers and symbols used to express a calculation. Always begins with an = sign.
a)
Cell address
b)
Worksheet
c)
Formula
5.
Excel allows you to
a)
read stories
b)
work with data
c)
invent ideas
6.
A3 is an example of a cell's address
a)
true
b)
false
7.
To create a formula, you first:
a)
Select the cell you want to place the formula into
b)
Type the equals sign (=) to tell Excel that you're about to enter a formula
c)
Enter the formula using any input values and the appropriate mathematical operators that make up your formula
d)
Choose the new command from the file menu
8.
What do you call the blank boxes on a spreadsheet?
a)
cells
b)
info
c)
squares
d)
spots
9.
Which tab in Excel has charts and tables?
a)
review
b)
home
c)
file
d)
insert
10.
The feature to center text across several cells is called:
a)
Wrap Text
b)
Merge and Center
c)
Shrink to Fit
d)
Number Formatting
11.
Which of the following operators do you use to begin typing a formula?
a)
*
b)
+
c)
=
d)
/
12.
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)
13.
What does this symbol do:
*
*
a)
Multiply
b)
Add
c)
Divide
d)
Minus
14.
What does this symbol do:
/
/
a)
Multiply
b)
Add
c)
Divide
d)
Minus
15.
Which formula gets the biggest value of a range of cells?
a)
MAX
b)
MIN
c)
LARGE
d)
SUM
16.
What is adjusted to fit the longest entry?
a)
cell address
b)
cell range
c)
workbook
d)
column width
17.
You can add, subtract, multiply and divide in excel.
a)
true
b)
false
18.
The area within the red box is called_______?
a)
Fill Handle
b)
Active Cell
c)
Cell
d)
Row
19.
Name the active cell______?
a)
C5
b)
B4
c)
C6
d)
D6
20.
Microsoft Excel is what type of software?
a)
Spreadsheet
b)
Drawing
c)
Word Processing
d)
Presentation
100 %
