# COMPUTERS QUIZ - EXCEL

## Quiz by Lauren Ramos

### Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

7 questions
• Q1

1.    What is the function used in Excel to add up a range of cells?

The function used in Excel to add a range of cells is the "MULTIPLICATION" function.

All the above

none of the above

The function used in Excel to add a range of cells is the "SUBTRACT" function.

In Excel, the function used to add up a range of cells is the SUM function, =SUM(A1:A10).

30s
• Q2

2.    Can you name a formula in Excel for finding the average of a set of numbers?

The formula in Excel for finding the average of a set of numbers is the "IF" function.

The formula in Excel for finding the average of a set of numbers is the "MIN" function.

The formula in Excel for finding the average of a set of numbers is the "COUNT" function.

One formula in Excel for finding the average of a set of numbers is the AVERAGE function, =AVERAGE(A1:A10).

30s
• Q3

3.    Definewhat a cell reference is in Excel.

Users enter free text
30s
• Q4

4.    Compare and contrast the SUM and AVERAGE functions in Excel.

Users enter free text
30s
• Q5

5. Explain why using the formulas in Excel is important.

All the above are correct

Flexibility

Consistency

Accuracy

Efficiency

30s
• Q6

6.    Can you list two different ways to paste images in Excel?

Users enter free text