Question 1

In a spreadsheet, what is the function used to add up a range of cells?

Accepted Answer

SUM

Question 2

What is the function used to find the highest value in a range of cells in a spreadsheet?

Accepted Answer

=MAX

Question 3

What does the function 'AVERAGE' do in a spreadsheet?

Accepted Answer

Calculates the mean value of a range of cells

Answer

Counts the number of cells with data in a range

Answer

Finds the smallest value in a range of cells

Answer

Multiplies the values of a range of cells

Question 4

What is the function used to count the number of values with data in a specified range in a spreadsheet?

Accepted Answer

=COUNT

Question 5

What symbol is commonly used to represent multiplication in a spreadsheet formula?

Accepted Answer

*

Question 6

In spreadsheets, what does the 'MIN' function do?

Accepted Answer

Finds the lowest value in a range of cells

Question 7

In spreadsheets, what symbol is used to start a formula?

Accepted Answer

=

Answer

-

Answer

@

Answer

+

Question 8

What does the formula '=SUM(A1:A5)' do in Excel?

Accepted Answer

Adds all numbers in cells A1 through A5

Answer

Finds the average of numbers in cells A1 through A5

Answer

Counts all numbers in cells A1 through A5

Answer

Multiplies all numbers in cells A1 through A5

Question 9

In a spreadsheet, what is a range of cells?

Accepted Answer

A group of adjacent cells

Answer

A formula in a cell

Answer

A single cell

Answer

A chart in a cell

Question 10

What is the purpose of merging cells in a spreadsheet?

Accepted Answer

To combine multiple cells into one larger cell

Answer

To delete cells permanently

Answer

To change the font color of cells

Answer

To insert a new row in the spreadsheet

Question 11

What does the term 'cell reference' refer to in a spreadsheet?

Accepted Answer

A way to identify a specific cell by its column and row

Answer

A chart embedded in a cell

Answer

A function that calculates values in cells

Answer

A way to delete cells in bulk

Question 12

Which spreadsheet operator is used to divide one value by another?

Accepted Answer

/

Question 13

What is an ARGUMENT  a spreadsheet?

Accepted Answer

A cell reference, text  or numbers that may be used in a formula

Question 14

Enter the operator used for SUBTRACTION

Accepted Answer

-

Question 15

Enter the operator used for exponentiation:

Accepted Answer

^

Related quizzes

Related quizzes