Question 1

What is the result of the formula =A1+B1 when A1 contains 5 and B1 contains 3?

Accepted Answer

8

Answer

53

Answer

2

Answer

15

Question 2

Which mathematical operator is used to multiply values in a spreadsheet formula?

Accepted Answer

*

Answer

/

Answer

-

Answer

+

Question 3

If you have a cell named 'Total' that contains the value 20, what will be the result of the formula =Total/4?

Accepted Answer

5

Answer

15

Answer

10

Answer

25

Question 4

What does the formula =A2-A1 do in a spreadsheet?

Accepted Answer

Subtracts the value in A1 from the value in A2

Answer

Divides A2 by A1

Answer

Multiplies A1 and A2

Answer

Adds A1 and A2

Question 5

If cell B3 contains the value 10 and cell B4 contains the value 2, what is the result of the formula =B3*B4?

Accepted Answer

20

Answer

8

Answer

12

Answer

5

Question 6

In a spreadsheet, what happens if you use the formula =SUM(A1:A3)?

Accepted Answer

It adds the values in cells A1, A2, and A3

Answer

It subtracts A3 from A1

Answer

It multiplies the values in A1, A2, and A3

Answer

It finds the average of A1, A2, and A3

Question 7

What does the formula =AVERAGE(C1:C5) calculate?

Accepted Answer

The average of the values in cells C1 to C5

Answer

The minimum value in C1 to C5

Answer

The sum of the values in C1 to C5

Answer

The maximum value in C1 to C5

Question 8

If you input the formula =B1/B2 in a spreadsheet and B1 has the value 50 while B2 has the value 5, what will be the result?

Accepted Answer

10

Answer

2

Answer

55

Answer

25

Question 9

What is the correct operator for subtracting values in a spreadsheet formula?

Accepted Answer

-

Answer

+

Answer

/

Answer

*

Question 10

What does the formula =B3+B4+B5 do in a spreadsheet?

Accepted Answer

It adds the values in cells B3, B4, and B5

Answer

It finds the minimum value in B3, B4, and B5

Answer

It calculates the product of B3, B4, and B5

Answer

It subtracts B4 and B5 from B3

Question 11

Which of the following can you use a spreadsheet for?

Accepted Answer

Creating a budget plan

Answer

Playing a video game

Answer

Drawing a picture

Answer

Writing a story

Question 12

Which feature of a spreadsheet allows you to create a visual representation of data?

Accepted Answer

Chart

Answer

Cell

Answer

Header

Answer

Font

Question 13

Which of the following is a common way to organize data in a spreadsheet?

Accepted Answer

Using rows and columns

Answer

As a story

Answer

In a circle

Answer

By colors only

Question 14

In a spreadsheet, what does the term 'cell' refer to?

Accepted Answer

An individual box in the grid where data can be entered

Answer

A color in the spreadsheet

Answer

A type of formula

Answer

A chart that displays data

Related quizzes

Related quizzes