This quiz was made to go along with the Learning Excel website for Cal Poly Pomona. This quiz will test students on how to make calculations in excel.
False, in Excel you can use the SUM function to add up an entire column.
True, Microsoft should really add an addition feature.
False, in Excel you can use the ADDITION function to add up an entire column.
False, in Excel you can use the AVERAGE function to add up an entire column.
Rate this question:
=AVERAGE(A1:A10)
=SUM(A1:A11)
=ADDITION(A1:A10)
=SUM(A1:A10)
=ADD(A1:A10)
Rate this question:
=SUM(B1:B10)
=B1+B2+B3+B4+B5+B6+B7+B8+B9+B10
=SUM(B1:B8)+B9+B10
=SUM(B1:B5)+SUM(B6:B10)
=B1*B10
=SUM(B1-B10)
Rate this question:
False, it is a reference to all cells except B3.
False, it is just a calculation.
False, it refers to all cells before B3.
False, it refers to cells that are equal to B3.
True
Rate this question:
66
32
31
51
N/A
Rate this question:
True
False
Rate this question:
True
False
Rate this question:
False, you only have to type in 1 through 50 and then Excel will generate the rest.
True, Excel should really add a feature to handle this tiresome work.
False, you can just write =NUMBERS(1:100)
False, you only have to type in 1 and then use the Auto-Fill feature to get to 100 quickly.
Rate this question:
1.25
2.75
5
2.8
3
Rate this question:
=SUM
=MODE
=MOD
=TOTAL
=MAX
=AVG
Rate this question:
Wait!
Here's an interesting quiz for you.