wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Microsoft Excel - Formulae

Total questions: 32

Worksheet time: 14mins

Name
Class
Date
1.

The function that lets you add up a range of cells or values

a)

SUM

b)

AVERAGE

c)

MIN

d)

MAX

2.

What function was used to find the lowest grade?

a)

average

b)

sum

c)

min

d)

max

3.

What function was used to find the highest grade?

a)

average

b)

min

c)

sum

d)

max

4.

The Count column found on the Grade Count table, can be computed by this function.

a)

counta

b)

countif

c)

count

d)

countblank

5.

SUM, AVERAGE, IF, MIN and MAX are examples of _______.

a)

user-defined functions

b)

online functions

c)

table functions

d)

predefined functions

6.

All formulas used within the table are seen on the __________

a)

cells

b)

cell reference

c)

name box

d)

formula bar

7.

The function COUNT is specific for ___________

a)

counting cells

b)

counting numbers

c)

counting text

d)

counting tables

8.

To sort names in a worksheet, we can use this button.

a)
b)
c)
d)
9.

To display the Letter Grade Equivalent, we can use the ___ function.

a)

if

b)

count

c)

average

d)

sum

10.

In the picture, why is D2 through D5 placed in ( paranthesis/Brackets )?

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.

11.

If the (parenthesis/brackets) are removed, what will 9.5% be multiplied by?

a)

D2 +D3+D4+D5

b)

D5

c)

D2

d)

None

12.
Which response best completes the following statement: A formula is used to 
a)
perform calculations or other actions.
b)
find averages.
13.
Cell value references should always be used when possible to avoid having to make multiple updates when one key value changes.
a)
True
b)
False
14.
By default, all cell references are _________ references. 
a)
Absolute
b)
Relative
15.
Unlike _________ references, _________ references do not change when copied or filled. 
a)
Absolute, Relative
b)
Relative, Absolute
16.
An absolute reference is designated in a formula by the addition of a _______ sign. 
a)
%
b)
$
c)
&
d)
#
17.
If you don't want a cell reference to change when copied to other cells, use _________ references
a)
Absolute
b)
relative
18.
If you want a cell reference to change when copied to other cells, use _________ references
a)
Absolute
b)
Relative
19.

The most common format of an absolute cell reference is

a)

$D2

b)

$D$2

c)

D$2

d)

D2$

20.
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)
21.
Which button can you click to add up a series of numbers?
a)
The autosum button
b)
The Formula button
c)
The quicktotal button
d)
The total button
22.
Which formula gets the biggest value of a range of cells?
a)
MAX
b)
MIN
c)
LARGE
d)
SUM
23.
Which formula gets the smallest value of a range of cells?
a)
MAX
b)
MIN
c)
SMALL
d)
SUM
24.
Which symbol must all formula begin with?
a)
=
b)
+
c)
(
d)
@
25.

Which formula will calculate the average based on a condition? (return the average of sales if over $20)

a)

average

b)

countif

c)

averageif

d)

sumif

26.

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

a)

sum

b)

sumif

c)

count

d)

countif

27.

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

28.
A ___________ conveys a visual representation of data.
a)
chart
b)
picture
c)
text box
d)
style
29.
A(n) _________ is a prewritten formula that is built into EXCEL. 
a)
function
b)
problem
c)
equation
d)
equal sign
30.
A combination of numbers and symbols used to express a calculation. Always begins with an = sign.
a)
Cell address
b)
Worksheet
c)
Formula
31.
Excel allows you to
a)
read stories
b)
work with data
c)
invent ideas
32.
A command line above the worksheet where text, numbers, and formulas are entered into a worksheet.
a)
Insert
b)
Formula bar
c)
Tables

Similar Resources on Wayground

Y9 Binary Quiz

29 questions

Y9 Binary Quiz

quiz

Worksheet

•

9th Grade

Entrepreneurship Honors 1 Unit 4

30 questions

Entrepreneurship Honors 1 Unit 4

quiz

Worksheet

•

9th - 12th Grade

4QICT12 - Current and Future Trends of Media and Information

28 questions

4QICT12 - Current and Future Trends of Media and Information

quiz

Worksheet

•

11th - 12th Grade

Adapter Cards

30 questions

Adapter Cards

quiz

Worksheet

•

University

Google Sheets Fundamentals

29 questions

Google Sheets Fundamentals

quiz

Worksheet

•

9th - 12th Grade

Empowerment Technology

27 questions

Empowerment Technology

quiz

Worksheet

•

11th Grade

PowerPoint Ch. 4

27 questions

PowerPoint Ch. 4

quiz

Worksheet

•

9th - 12th Grade