![placeholder image to represent content](/_next/image?url=%2Fassets%2Fquiz_default_logo.jpg&w=256&q=75)
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