Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Spreadsheets Formulas & Functions

Total questions: 137

Worksheet time: 2hrs 7mins

Name
Class
Date
1.
an excel file with one or more worksheets
a)
workbook
b)
worksheet
c)
formula
d)
row
2.
What is the cell in the worksheet in which you can type data?
a)
Main Cell
b)
Open Cell
c)
Active Cell
d)
Absolute Cell
3.
A grid of rows and columns in which you enter text, numbers, and the results of calculations.
a)
worksheet
b)
range
c)
spreadsheet
d)
Chart
4.
The horizontal placement of cells in a table or worksheet.
a)
range
b)
row
c)
column
d)
cell
5.
An equation that calculates a new value from values currently in a worksheet.
a)
Formula Bar
b)
column
c)
cell
d)
formula
6.
Identify this cell (highlighted)
a)
C2
b)
A5
c)
B3
d)
E1
7.

Study the picture and answer the question below.


What is the number in C3?

a)

2

b)

96

c)

54

8.

What is the cell reference of the cell with value WAND inside?

a)

B5

b)

C6

c)

D9

d)

A8

9.
A row is a vertical reference in a spreadsheet.
a)
True
b)
False
10.

What is the cell reference of the active cell?

a)

A1

b)

4B

c)

BB8

d)

B4

11.
Which symbol means to multiply?
a)
/
b)
*
c)
SUM
d)
(  )
12.
1) Study the highlighted cells in the image below and identify which of the following represents the correct cell address for these cells:  
a)
a) The cell reference for the selected cells is B:21, C:28, D:22, E:26 and F:25.
b)
b) The cell reference for the selected cells is row 15, column F 
c)
c) The cell reference for the selected cells is F4:F5 
d)
 d) The cell reference for the selected cells is B15:F15 
13.
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)
14.
A combination of numbers and symbols used to express a calculation. Always begins with an = sign.
a)
Cell address
b)
Worksheet
c)
Formula
15.
Which is an example of a cell address?
a)
126
b)
A9
c)
=SUM
d)
75/65
16.
What is a file which contains one or more spreadsheets?
a)
spreadsheet
b)
workbook
c)
cell 
d)
cell range
17.

In a spreadsheet program, "C3" would be an example of this.

a)

worksheet

b)

cell address

c)

row

d)

column

18.

What is the spreadsheet symbol for division

a)

+

b)

-

c)

*

d)

/

19.

cells in a spreadsheet are highlighted. Can you identify them? use the format B7:B10

(a)  

20.

What cell is being identified here

a)

D2

b)

B4

c)

C2

d)

A5

21.

What cell is being identified here

a)

D2

b)

B4

c)

C2

d)

A5

22.

What cell is being identified here

a)

D2

b)

B4

c)

C2

d)

A5

23.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
24.

Which are the three essential elements to enter a function?

a)

Equal sign, function name and cell reference.

b)

Equal sign, cell reference and formula.

c)

Function name, data and cell reference.

d)

Function name and cell reference.

25.

What is the result of

=C4 + C5

a)

32

b)

12

c)

17

d)

15

26.

Which function is correct for adding up a selection of numbers?

a)

sum(A1+A10)

b)

=sum(A1+A10)

c)

sum(A1:A10)

d)

=sum(A1:A10)

27.

What two operations does the AVERAGE function perform?

a)

Addition and Multiplication

b)

Multiplication and Division

c)

Addition and Subtraction

d)

Addition and Division

28.

What function should be entered to calculate the total budget?

a)

=AVERAGE(B3:B6)

b)

=SUM(B3:B6)

c)

=SUM(B3-B6)

d)

=TOTAL(B3:B6)

29.

What is a spreadsheet function?

a)

A type of software used for creating and editing spreadsheets.

b)

A feature that allows you to change the appearance of cells in a spreadsheet.

c)

A built-in formula that performs calculations and manipulates data in a spreadsheet program.

d)

A tool that allows you to import and export data from a spreadsheet program.

30.

Which of the following is a function used to analyze data in a spreadsheet?

a)

AVERAGE

b)

COUNT

c)

SUM

d)

all of the above

31.

Which of the following functions can be used to find the mean of a range of cells in a spreadsheet?

a)

SUM

b)

AVERAGE

c)

MAX

d)

MIN

32.

Which of the following functions can be used to find the highest value in a range of cells in a spreadsheet?

a)

MIN

b)

MAX

c)

SUM

d)

AVERAGE

33.

What is the purpose of the MIN function

a)

Add the numerical values in a range of cells

b)

Find the lowest number in a range of cells

c)

Find the highest number in the range of cells

d)

Finds the average from a range of cells

34.

What is the purpose of the COUNT function?

a)

Adds the values of a range of cells

b)

Counts how many cells in a range contain anything

c)

Counts how many cells in a range contain numbers

d)

Counts how many cells have been selected

35.

What is the purpose of the COUNTA function?

a)

Adds the values of a range of cells

b)

Counts how many cells in a range contain anything

c)

Counts how many cells in a range contain numbers

d)

Counts how many cells have been selected

36.

Is the below a function or formula?


=SUM(A1:A5)

a)

Function

b)

Formula

37.

Is the below a function or formula?


=(A1+A5)-(A5*A7)

a)

Function

b)

Formula

38.

Is the following a valid function?


=SUM(12+56)

a)

Yes

b)

No

39.

Is the following function valid?


=counta(A1:A6)

a)

Yes

b)

No

40.

Which formula would be used to calculate average?

a)

=MAX(B5:B10)

b)

=SUM(B5:B10)

c)

=AVERAGE(B5:B10)

d)

=SUM(B5*B10)

41.

What is the correct syntax for the SUM Function?

a)

=SUM(value1,value2...)

b)

SUM(value1+value2

c)

=value1+value2

d)

SUM=(value1:value2)

42.

Which function can be used to find the highest grade in a grades list?

a)

AVERAGE

b)

MIN

c)

MAX

d)

COUNTA

43.

The VLOOKUP Functions helps us find a value in table and return a corresponding value.

a)

True

b)

False

44.

Which function counts textual values in a spreadsheet?

a)

COUNT

b)

COUNTA

c)

SUM

d)

AVERAGE

45.

Which function finds the lowest value in a table?

a)

MAX

b)

IF

c)

COUNT

d)

MIN

46.

Which function finds the mean within a list of numbers?

a)

SUM

b)

COUNT

c)

AVERAGE

d)

COUNTA

47.

Which function counts only numeric values?

a)

COUNTA

b)

MAX

c)

SUM

d)

COUNT

48.

Which symbol is used to join two text strings?

a)

#

b)

&

c)

+

d)

=

49.

What symbol is used to lock on cell references?

a)

$

b)

@

c)

#

d)

&

50.

What symbol is the union operator, which combines multiple references into one reference?

a)

.

b)

*

c)

&

d)

,

51.

=IF(B2>=70,"Passed","Failed")

Which statement is true for this function?

a)

If B2 is more than 70, Passed is output.

b)

If B2 is less than 70, Passed is output.

c)

If B2 is False, then an error message is output.

d)

All numbers greater than 70 are passing marks.

52.

A1 = 100

=IF(A1<>100,"Correct","Wrong")

What is the result of this Function?

a)

Correct

b)

Wrong

c)

False

d)

1

53.

H3 = 42

=IF(H3=40,"Match","No match")

What is the result of this Function?

a)

No match

b)

Match

c)

True

d)

False

54.

E4 = 10

=IF(E4<>100,"True","False)

What is the result of this function?

a)

False

b)

True

c)

10

d)

100

55.

Refer to your practice spreadsheet. This image here has an error in Column A. Which cell has the error? Remember cells are written this way A1 (a)   A9 etc.

56.
=A1*B1
a)
2
b)
3
c)
4
d)
Error
57.

Refer to your practice spreadsheet. Same one as in this image. What was the lowest you spent on an item in Cost #2.

a)

$5

b)

$3

c)

$4

d)

$15

58.

What is the active cell in excel

a)

The bottom cell in a worksheet

b)

The top cell in a worksheet

c)

The Past cell in a worksheet

d)

The current cell in a worksheet

59.

Which of the statement is NOT TRUE about the spreadsheet?

a)

The user bought three different items

b)

The average cost for Cost#1 is in B6

c)

The total for Cost#1 is less than Cost#2

d)

$15 is the total for Cost#2

60.

Which key should be used to move to the left of the cell

a)

Tab key

b)

Enter key

c)

Shift+ Enter key

d)

Shift+ Tab key

61.

Name of the workbook is displayed in the

a)

Menu bar

b)

Title bar

c)

Tool bar

d)

Option bar

62.

9. This function returns the sum of the products of corresponding ranges or arrays.

a)

A. SUMIF

b)

B. MOD

c)

C. SUMPRODUCT

d)

D. SUMSQ

63.
Which career(s) or places of employment involve the use of a spreadsheet at work?
a)
Accountant
b)
Hospital
c)
All Choices
d)
Shop Keeper
64.

Refer to your practice spreadsheet. Same one as in this image. Which of the following would you use to calculate answer in C8?

a)

=MIN(B2:C4)

b)

=MIN(D2:C4)

c)

=MIN(C2:C4)

d)

=MAX(B2:B4)

65.

Refer to your practice spreadsheet. Same one as in this image. What was the most you spent on an item in Cost #1.

a)

$5

b)

$3

c)

$18

d)

$7

66.

5. This function returns the remainder after a number is divided by a divisor.

a)

A. SUMPRODUCT

b)

B. MOD

c)

C. SUMIF

d)

D. SUMSQ

67.

To apply formatting on cells, select the option "Cells" from _________ menu

a)

Edit

b)

Format

c)

Home

d)

Allignment

68.

10. It is an application program designed to perform basic mathematical and arithmetic operations.

a)

A. Electronic spreadsheet

b)

B. Slide Presentation

c)

C. Word Document

d)

D. Publisher

69.

Write a function to find the average of the cells A1, A2 and A3

(a)  

70.

Which symbol means divide

a)

+

b)

-

c)

*

d)

/

71.

Which of these functions could be used to add values together?

a)

AVG()

b)

+

c)

*

d)

SUM()

72.

What is the name of a location that stores a single item of data?

a)

Row

b)

Function

c)

Cell

d)

Column

73.

Louis wants to calculate his average income over 4 weeks. Which of these functions could he use?

a)

AVG()

b)

+

c)

COUNT()

d)

SUM()

74.

Look at this screenshot. What is the cell reference of the yellow cell?

(a)  

75.

In a spreadsheet, what is labelled using letters?

a)

Rows

b)

Columns

c)

Cells

d)

Calculations

76.

What does the * symbol mean?

a)

Add

b)

Subtract

c)

Multiply

d)

Divide

77.

Which function can tell us how many cells have been filled in

a)

COUNT()

b)

AVG()

c)

SUM()

d)

*

78.

Write a function that can divide the value of cell C5 by 2.

(a)  

79.

What is a "cell" in a spreadsheet?

a)

A set of cells

b)

A single block in a spreadsheet

c)

A true or false statement

d)

A function

80.

What is a "range" in a spreadsheet?

a)

A single block in a spreadsheet

b)

A set of cells

c)

A true or false statement

d)

A function

81.

What is the purpose of the `=MAX()` function in a spreadsheet?

a)

To find the minimum value

b)

To find the average value

c)

To find the highest value

d)

To sum all values

82.

If you have a list of 10 numbers in cells E1 to E10, what does the function `=COUNT(E1:E10)` do?

a)

Sums all the numbers

b)

Counts how many numbers are in the range

c)

Finds the maximum number

d)

Finds the average of the numbers

83.

What does the function `=SUM(A1:A10)` do?

a)

Counts the number of cells in A1 to A10

b)

Finds the average of the values in A1 to A10

c)

Adds all the values in A1 to A10

d)

Finds the maximum value in A1 to A10

84.

Which function would you use to find the highest value in the range B1:B5?

a)

MIN(B1:B5)

b)

AVERAGE(B1:B5)

c)

MAX(B1:B5)

d)

SUM(B1:B5)

85.

What will the formula `=MIN(3, 7, 2, 5)` return?

a)

3

b)

2

c)

5

d)

7

86.

What is the result of the formula `=SUM(10, 20, 30)` in a spreadsheet?

a)

50

b)

60

c)

70

d)

40

87.

If you want to calculate the average of the numbers in cells D1 through D4, which formula would you use?

a)

=SUM(D1:D4)

b)

=AVERAGE(D1:D4)

c)

=MAX(D1:D4)

d)

=MIN(D1:D4)

88.

If you have the numbers 5, 10, and 15 in cells A1, A2, and A3 respectively, what will the formula `=AVERAGE(A1:A3)` return?

a)

10

b)

15

c)

5

d)

20

89.

If the values in cells C1, C2, and C3 are 8, 12, and 20, what will `=AVERAGE(C1:C3)` yield?

a)

10

b)

12

c)

15

d)

20

90.

Using the `=SUM()` function, what will be the output of `=SUM(1, 2, 3, 4, 5)`?

a)

10

b)

15

c)

20

d)

25

91.

What does BIDMAS stand for?

a)

Brackets, Indices, Division, Multiplication, Addition, Subtraction

b)

Brackets, Integers, Division, Multiplication, Addition, Subtraction

c)

Brackets, Indices, Division, Multiplication, Addition, Sum

d)

Brackets, Integers, Division, Modulus, Addition, Subtraction

92.

What is a relative cell reference?

a)

A reference that remains constant when copied to another cell

b)

A reference that changes based on the position of the cell it is copied to

c)

A reference that refers to a specific value in a different worksheet

d)

A reference that is only used in functions

93.

Which of the following functions can be used to sum a range of cells?

a)

AVERAGE()

b)

COUNT()

c)

SUM()

d)

MAX()

94.

If cell A1 contains the value 10 and cell A2 contains the value 5, what will the formula =A1+A2 return?

a)

15

b)

10

c)

5

d)

50

95.

What is the result of the formula =SUM(A1) if A1=2, A2=3, and A3=4?

a)

9

b)

2

c)

6

d)

5

96.

Which of the following is an absolute cell reference?

a)

A1

b)

$A$1

c)

A$1

d)

$A1

97.

What is the result of the formula =A1*B1 if A1=3 and B1=4?

a)

7

b)

12

c)

34

d)

43

98.

If you want to ensure that a formula always refers to a specific cell, you should use:

a)

Relative cell reference

b)

Absolute cell reference

c)

Named range

d)

Circular reference

99.
Select ___________________ from the functions menu to find the smallest value in a group.
a)
max
b)
min
c)
sum
d)
average
100.
Select ______________ from the functions drop-down menu to ADD a set of numbers. 
a)
average
b)
count
c)
max
d)
sum
101.

Mr. Esker wanted to see how the class did as a whole on the most recent test. Using spreadsheets he used the ______________ function to calculate the classes score as a whole.

a)

Sum

b)

Average

c)

Count

d)

Max

e)

Min

102.

Mr. Tone wanted to see which student received the highest score on the last Quizizz. In his spread sheet he used the ______________ function to identify the highest score.Mi

a)

Sum

b)

Average

c)

Count

d)

Max

e)

Min

103.

Betty has a spreadsheet of sales for her bakery for a month. In one column she lists the amount of donuts sold each day. If she wanted to find out what day she sold the LEAST amount of donuts she would use the _________________ function.

a)

Sum

b)

Average

c)

Count

d)

Max

e)

Min

104.
What function should be entered to calculate the total budget?
a)
=AVERAGE(B3:B6)
b)
=SUM(B3:B6)
c)
=SUM(B3-B6)
d)
=TOTAL(B3:B6)
105.

What is the role of functions in spreadsheet formulas?

a)

Functions are used to format text in spreadsheets.

b)

Functions enable calculations and data manipulation in spreadsheet formulas.

c)

Functions only serve to display data without calculations.

d)

Functions are primarily for creating charts and graphs.

106.

What is the function used to add a range of cells in a spreadsheet?

a)

AVERAGE

b)

SUM

c)

PRODUCT

d)

DIVIDE

107.

Which function would you use to find the largest number in a set of values?

a)

MIN

b)

MAX

c)

AVERAGE

d)

COUNT

108.

If you want to calculate the average of numbers in cells A1 through A5, which function would you use?

a)

SUM(A1:A5)

b)

AVERAGE(A1:A5)

c)

MAX(A1:A5)

d)

MIN(A1:A5)

109.

What is the result of the function =SUM(2,3,5)=SUM(2, 3, 5) ?

a)

8

b)

10

c)

15

d)

20

110.

Which function would you use to multiply all the numbers in a range of cells?

a)

SUM

b)

PRODUCT

c)

DIVIDE

d)

AVERAGE

111.

What is the result of the function =PRODUCT(2,3,4)=PRODUCT(2, 3, 4) ?

a)

9

b)

12

c)

24

d)

30

112.

Which function returns the smallest number in a set of values?

a)

MAX

b)

MIN

c)

AVERAGE

d)

SUM

113.

If you want to divide the value in cell A1 by the value in cell B1, which formula would you use?

a)

=A1*B1

b)

=A1+B1

c)

=A1-B1

d)

=A1/B1

114.

Which of the statement is TRUE about the spreadsheet?

a)

Cost #1 eggs is for $5

b)

Cost#2 bread is for$7

c)

Cost #1 fruits is less than cost#2

d)

Cost#1 Bread is less than Cost#2

115.

Which of the statement is TRUE about the cell C8?

a)

The answer is $5.00

b)

It is the maximum for cost#1

c)

It is the minimum for cost#2

d)

It is the average for Cost#!

116.

Which of the statement is NOT TRUE about the spreadsheet?

a)

The user bought three different items

b)

The average cost for Cost#1 is in B6

c)

The total for Cost#1 is less than Cost#2

d)

$15 is the total for Cost#2

117.

Refer to your practice spreadsheet. Same one as in this image. What was the lowest you spent on an item in Cost #2.

a)

$5

b)

$3

c)

$4

d)

$15

118.

If you want to know how many items you bought you will need to use this FUNCTION

a)

AVERAGE

b)

MAX

c)

COUNT

d)

SUM

119.

Which FUNCTION is used to find the largest number in a column?

a)

MIN

b)

MAX

c)

GREATER THAN

d)

SUM

120.

Which of the following is NOT a spreadsheet function?

a)

MIN

b)

MAX

c)

COUNT

d)

TOTAL

121.

A spreadsheet program is used to store data in:

a)

a database.

b)

a text document.

c)

rows and columns.

d)

letters and numbers.

122.

Spreadsheet rows are easily identified by:

a)

Numbers.

b)

Letters.

c)

Roman numerals.

d)

Colours.

123.

Spreadsheet columns are easily identified by:

a)

Roman numerals.

b)

numbers.

c)

letters.

d)

colors.

124.

Sum, average, count, maximum value, and minimum value are examples of what?

a)

Formulas

b)

Calculations

c)

Functions

d)

Spreadsheet data

125.

Addition, subtraction, multiplication, division are examples of what?

a)

Formulas

b)

Conditional formatting

c)

Functions

d)

Spreadsheet data

126.

Which formula would be used to calculate a total?

a)

=MAX(B5:B10)

b)

=SUM(B5:B10)

c)

=AVGERAGE(B5:B10)

d)

=SUM(B5*B10)

127.

Which formula would be used to calculate average?

a)

=MAX(B5:B10)

b)

=SUM(B5:B10)

c)

=AVGERAGE(B5:B10)

d)

=SUM(B5*B10)

128.

Which formula would be used to calculate the largest number?

a)

=MAX(B5:B10)

b)

=SUM(B5:B10)

c)

=AVGERAGE(B5:B10)

d)

=SUM(B5*B10)

129.

What data type is shown here: £34.50

a)

Currency

b)

Number

c)

Text

d)

Date

130.

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

131.

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)

132.
What is the correct example of a range?
a)
3B:7C
b)
B3:C7
c)
B3-C7
d)
B:3:C:7
133.
Which of the following is a valid formula?
a)
=C7*C8
b)
=(C7\C8)
c)
=(C7xC8)
d)
=AVERAGE(C7*C8)
134.
Which of the following is a valid formula?
a)
=sum(A1:A6)
b)
sum=(A1:A6)
c)
=sum[A1:A6]
d)
=sum(A1,A6)
135.

Which formula will find the minimum value in the range C1 to C4 if the values are 7, 2, 9, and 5?

a)

=MINIMUM(C1:C4)=MINIMUM(C1:C4)

b)

=MIN(C1:C4)=MIN(C1:C4)

c)

=LOWEST(C1:C4)=LOWEST(C1:C4)

d)

=MINIMUMVALUE(C1:C4)=MINIMUMVALUE(C1:C4)

136.

If the values in cells D1, D2, and D3 are 15, 25, and 10 respectively, which formula will find the maximum value?

a)

=MAXIMUM(D1:D3)=MAXIMUM(D1:D3)

b)

=MAX(D1:D3)=MAX(D1:D3)

c)

=HIGHEST(D1:D3)=HIGHEST(D1:D3)

d)

=MAXVALUE(D1:D3)=MAXVALUE(D1:D3)

137.

Which of the following formulas correctly calculates the average of the values in cells F1 through F3?

a)

=AVERAGE(F1:F3)=AVERAGE(F1:F3)

b)

=MEAN(F1:F3)=MEAN(F1:F3)

c)

=AVG(F1:F3)=AVG(F1:F3)

d)

=AVERAGEVALUE(F1:F3)=AVERAGEVALUE(F1:F3)