WorksheetsExcel Basics and More
Total questions: 22
Worksheet time: 15mins
Name
Class
Date
1.
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
2.
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)
3.
Which formula gets the smallest value of a range of cells?
a)
MAX
b)
MIN
c)
SMALL
d)
SUM
4.
Which symbol must all formula begin with?
a)
=
b)
+
c)
(
d)
@
5.
Columns go...
a)
Across
b)
Down
6.
Rows go...
a)
Across
b)
Down
7.
In a cell reference, for example A1, what does the letter refer to?
a)
The column
b)
The cell
c)
The row
8.
Which of these symbols is used for divide on a computer?
a)
\
b)
*
c)
/
d)
|
9.
Which symbol means to multiply?
a)
/
b)
*
c)
SUM
d)
( )
10.
Which of these would correctly calculate the average of some data?
a)
Average = B3 - B8
b)
B3:B8(AVERAGE)
c)
=AVERAGE(B3:B8)
d)
=B3:B8
11.
When adding more than two cells together you can use the following . . .
a)
=SUM(B1:B4)
b)
=ADD(B1:B4)
c)
=TOTAL(B1:B4)
12.
To put names into alphabetical order use ...
a)
Filter
b)
Format
c)
Define
d)
Sort
13.
Combining two cells together is called:
a)
Filtering
b)
Merging
c)
Wrapping
d)
Filling
14.
The IF function on excel . . .
a)
returns one value if a condition is true and another value if it's false
b)
calculates the average of some data
c)
Searches the worksheet for a name
d)
Identifies and mistakes in formula
15.
Tadre would like to print only the cell range A1:F20. What page setup option should he change?
a)
Orientation
b)
Page Break
c)
Print Area
d)
Print Titles
16.
A mathematical equation that will calculate a result.
a)
Active cell
b)
Formula
c)
Function
d)
Numbers/Values
17.
Stored in the individual cells of a worksheet.
a)
Labels
b)
Stuff
c)
Values
d)
Data
18.
Used to specify an absolute reference in a formula.
a)
$
b)
?
c)
%
d)
!
19.
one page in a spreadsheet
a)
sheet
b)
cell
20.
multiple spreadsheets in one set
a)
group
b)
workbook
21.
horizontal references in a spreadsheet: identified by a number
a)
column
b)
row
22.
The cell you are currently working in
a)
workbook
b)
active cell
100 %
