# COMPUTERS QUIZ - EXCEL

## Quiz by Lauren Ramos

Feel free to use or edit a copy

includes Teacher and Student dashboards

### Measure skillsfrom any curriculum

Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.

- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet

- 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 textType an Answer30s - Q4
4. Compare and contrast the SUM and AVERAGE functions in Excel.

Users enter free textType an Answer30s - 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 textType an Answer30s - Q7
Do you like to use Excel? Write your answer with your own words

Users enter free textType an Answer30s