wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Excel Projects 1-5 Review

Total questions: 30

Worksheet time: 15mins

Name
Class
Date
1.
 A spreadsheet program is used to store data in: 
a)
a. a database.
b)
b. a text document.
c)
c. rows and columns.
d)
d. letters and numbers.
2.
Spreadsheet rows are easily identified by:
a)
a. numbers.
b)
b. letters.
c)
c. Roman numerals.
d)
d. colors.
3.
Spreadsheet columns are easily identified by:
a)
a. Roman numerals.
b)
b. numbers.
c)
c. letters.
d)
d. colors.
4.
Which of the following is an example of a cell reference?
a)
a. Column C
b)
b. =SUM
c)
c. Row 1
d)
d. A5
5.
Which of these are not an example of how MS Excel can be used?
a)
a. Budget
b)
b. Research Paper
c)
c. Track sales
d)
d. Track Inventory
6.
What is the purpose of spreadsheets?
a)
a. To present information on different engaging slides
b)
b. To deliver a speech to a crowd
c)
c. To perform basic and complex math computations in an organized way
d)
d. To excel your research papers and citations
7.
What does this symbol represent in MS Excel?
a)
a. Subtract
b)
b. AutoSum
c)
c. Formula
d)
d.    Average
8.

If I wanted to know the total amount of bonuses given to the employees I would write the following formula in cell D12:

a)

=sum(C2:C11)

b)

=sum(D2,D3,D4,D5,D7,D8,D9,D10,D11)

c)

=sum(D2:D11)

d)

$13,442.90

9.

If I wanted to know the average annual salary earned by the employees I would write the following formula in cell C12:

a)

=sum(C2:C11)

b)

=average(C2,C11)

c)

=average(C2:C11)

d)

=average(B2:B11)

10.

When you sort data...

a)

You change the values of the cells.

b)

You choose how the data will be displayed.

c)

You remove values that don't fit in your data set.

11.

Every formula needs to begin with...

a)

=

b)

()

c)

;

d)

FORMULA

12.
One way to make sure the header row always displays when scrolling the worksheet is to
a)
Freeze the Row
b)
Split the worksheet
13.
What can be used to narrow down the data in your worksheet?
a)
Filter
b)
Sort
14.
What value would you get if you put in the formula: =A1*B1
a)
2
b)
3
c)
4
d)
Error
15.
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)
16.
Which formula gets the biggest value of a range of cells?
a)
MAX
b)
MIN
c)
LARGE
d)
SUM
17.
Which formula gets the smallest value of a range of cells?
a)
MAX
b)
MIN
c)
SMALL
d)
SUM
18.

Which formula would you use to calculate how many sales are over $20 from a series.

a)

sum

b)

sumif

c)

count

d)

countif

19.

Which tool is used to add a graphic representation of data based on a condition within a cell? For example, adding green data bars to a column of data.

a)

format cell

b)

conditional formatting

c)

fill color

d)

magic cell

20.
_____ are vertical. 
a)
Rows
b)
Columns
21.
________ are horizontal
a)
Rows
b)
Columns
22.
What allow quickly apply the content for one cell to another cell?
a)
Active cell
b)
Autocell
c)
Auto sum
d)
Auto Fill
23.
How do you select an entire column?
a)
Select Edit > Select > Column from the menu
b)
Click the column heading letter
c)
Hold down the shift key as you click anywhere in the column.
d)
Hold down the Ctrl key as you click anywhere in the column
24.

Which symbol do you use to create an absolute cell reference?

a)

$

b)

=

c)

#

d)

/

e)

-

25.
This function can be written to carry out an action and is a conditional operator. 
a)
If Statements
b)
List Functions
c)
Count Functions
d)
Lookup Functions
26.
Returns the number of cells in a range that contains numbers
a)
Count
b)
CountA
c)
CountIf
d)
List
27.
Returns the number of cells in a range that contain any value/label
a)
Count
b)
CountA
c)
CountIf
d)
List
28.
Returns the number of cells that meet a condition set forth in a formula
a)
Count 
b)
CountA
c)
CountIf
d)
List
29.
Where rows and columns meet are referred to as
a)
Blocks
b)
Cells
c)
Boxes
30.
If you see a series of "######" in a cell, that means the following:
a)
You keyed in an incorrect number
b)
The row height is too high
c)
The text is incorrectly spelled
d)
The column width is not wide enough

Similar Resources on Wayground

OCR Business - Influences on a business

25 questions

OCR Business - Influences on a business

quiz

Worksheet

•

10th - 11th Grade

9 EMS - Economic Sectors

25 questions

9 EMS - Economic Sectors

quiz

Worksheet

•

9th Grade

Forms of Business Test

25 questions

Forms of Business Test

quiz

Worksheet

•

9th - 12th Grade

GCSE Business 2.4.1 Business Calculations

25 questions

GCSE Business 2.4.1 Business Calculations

quiz

Worksheet

•

9th Grade

Personal Finance Review

25 questions

Personal Finance Review

quiz

Worksheet

•

10th - 12th Grade

Business Essentials Vocabulary

26 questions

Business Essentials Vocabulary

quiz

Worksheet

•

9th - 12th Grade

Taglines

25 questions

Taglines

quiz

Worksheet

•

KG - Professional Dev...