Loading...
COMPUTERS QUIZ - EXCEL
Quiz by Lauren Ramos
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
​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).
​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).
1.   What is the function used in Excel to add up a range of cells?
2.   Can you name a formula in Excel for finding the average of a set of numbers?
3.  Definewhat a cell reference is in Excel.
4.  Compare and contrast the SUM and AVERAGE functions in Excel.
5. Explain why using the formulas in Excel is important.
6.   Can you list two different ways to paste images in Excel?
Do you like to use Excel? Write your answer with your own words