Question 1

What function in a spreadsheet can be used to sum a range of cells?

Accepted Answer

SUM

Answer

COUNT

Answer

MAX

Answer

AVERAGE

Question 2

What is the purpose of a spreadsheet function?

Accepted Answer

To perform specific calculations or operations on data in a spreadsheet.

Answer

To create charts and graphs.

Answer

To format cells with different styles.

Answer

To sort data in ascending order.

Question 3

Which feature allows you to join multiple cells in a spreadsheet?

Accepted Answer

Merging

Answer

Formatting

Answer

Calculating

Answer

Sorting

Question 4

Which feature in a spreadsheet allows you to apply mathematical operations to a range of cells in a single step?

Accepted Answer

AutoSum

Answer

Sorting

Answer

Formatting

Answer

Filtering

Question 5

What is the purpose of a cell reference in a spreadsheet formula?

Accepted Answer

To specify the location of data

Answer

To apply formatting to cells

Answer

To calculate mathematical operations

Answer

To sort data based on criteria

Question 6

What feature in a spreadsheet allows you to copy a formula to multiple cells?

Accepted Answer

AutoFill

Answer

Calculating

Answer

Formatting

Answer

Sorting

Question 7

Write the range of the area in green

Accepted Answer

A6:C8

Question 8

Write the range of the area in yellow

Accepted Answer

E5:E8

Question 9

How many different formatting options are used in the area in magenta? Write a number

Accepted Answer

5

Question 10

According to the BODMAS rule what operation in mathematics is performed second (2)

Accepted Answer

Exponential

Answer

<P>Division</P>

Answer

Multiplication

Answer

<P>Brackets</P>

Related quizzes