Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Excel Review Quiz

Total questions: 21

Worksheet time: 18mins

Name
Class
Date
1.

In the picture, why is D2 through D5 placed in paranthesis?

a)

So Excel knows to total the cells before performing the next operation.

b)

So the total of the cells can be multiplied rather than added.

c)

So the calculation will be done last.

2.

Which response best completes the following statement: A formula is used to

a)

perform calculations or other actions.

b)

find averages.

c)

Look Up data

3.

The discount formula can be explained by saying the _______ minus 10% of the ___________ or multiplying the ________ times 90%.

a)

total

b)

Sum

c)

percentage

4.
Excel follows the ___________________ and first adds the values inside the parentheses.
a)
Order of Operations
b)
Formula Guidelines
5.
___________ are often the best way to define which calculations will be performed first in Excel.
a)
Parentheses
b)
Forumlas
6.
Unlike _________ references, _________ references do not change when copied or filled. 
a)
Absolute, Relative
b)
Relative, Absolute
7.

An absolute reference is designated in a formula by the addition of a _______ sign before and after the cell reference letter.

a)

%

b)

$

c)

&

d)

#

8.
If you don't want a cell reference to change when copied to other cells, use _________ references
a)
Absolute
b)
relative
9.

The most common way to identify an Absolute cell reference is 

a)

$D2#

b)
$D$2
c)

D$2#

d)
D2$
10.
Each cell's name is based on its _______ and _______.
a)
column, row
b)
column, cell
11.
When you use _______ _____, choose a different name and/or location for the copied version.
a)
Auto Fill
b)
Auto Sum
c)
Save As
d)
Save
12.
If you frequently work with the same workbook, you can ______ it to Backstage view for faster access.
a)
Save
b)
Pin
13.
When you open workbooks created with older versions of Excel, they will appear in _________ ______.
a)
BackStage View
b)
Compatibility Mode
14.
The ______ is a small green square in the lower-right corner that copies one cell to another.
a)
Paste Command
b)
Copy Command
c)
Drag and Drop Command
d)
Fill Handler
15.
Which predesigned file already has a significant amount of formatting, and other features? 
a)
Template
b)
Blank Workbook
16.
Which of the following statements describes how to increase or decrease a column’s width?
a)
Right-click anywhere in the column and select Format Cells.
b)

Use your mouse to drag the boundary next to the column heading.

17.

In most cases, its easier and faster to select multiple cells before using the _____ _______.

a)
Auto Fill
b)
Active Cell
18.
By default, all cell references are _________ references. 
a)
Absolute
b)
Relative
19.

Cell value references should always be used when possible to avoid having to make multiple updates when one cell refence value changes.

a)
True
b)
False
20.
There are _______ ways to view a worksheet. Simply click a command to select the desired view. 
a)
One
b)
Two
c)
Three
d)
Four
21.

Excel uses a ______ Ribbon system instead of traditional menus. Each _____ will have one or more groups of commands.

a)
Tabbed, Tab
b)
Quick Access, Ribbon

Similar Resources on Wayground

School Mangement System ICT 0417 IGCSE

18 questions

School Mangement System ICT 0417 IGCSE

quiz

Worksheet

•

10th - 12th Grade

Latihan Soal Administrasi Infrastruktur Jaringan XII TKJ

20 questions

Latihan Soal Administrasi Infrastruktur Jaringan XII TKJ

quiz

Worksheet

•

10th - 12th Grade

ULANGAN HARIAN KELAS TIK 9

20 questions

ULANGAN HARIAN KELAS TIK 9

quiz

Worksheet

•

12th Grade

Quiz on Excel

20 questions

Quiz on Excel

quiz

Worksheet

•

12th Grade

Database&Relation

20 questions

Database&Relation

quiz

Worksheet

•

12th Grade

Data structure test1

20 questions

Data structure test1

quiz

Worksheet

•

12th Grade