# Quiz 2: Calculations In Excel

Approved & Edited by ProProfs Editorial Team
At ProProfs Quizzes, our dedicated in-house team of experts takes pride in their work. With a sharp eye for detail, they meticulously review each quiz. This ensures that every quiz, taken by over 100 million users, meets our standards of accuracy, clarity, and engagement.
| Written by Enzanblaze
E
Enzanblaze
Community Contributor
Quizzes Created: 3 | Total Attempts: 11,841
Questions: 10 | Attempts: 276  Settings  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.

• 1.

### In Excel, if you want to add up an entire column you have to use a calculator and add up the entire column yourself and then write the answer in one of the cells.

• A.

False, in Excel you can use the SUM function to add up an entire column.

• B.

• C.

False, in Excel you can use the ADDITION function to add up an entire column.

• D.

False, in Excel you can use the AVERAGE function to add up an entire column.

A. False, in Excel you can use the SUM function to add up an entire column.
Explanation
In Excel, you can use the SUM function to add up entire columns, rows, or individual cells as you please. It is not practical to do the calculations yourself unless you are checking your spreadsheet for accuracy. It is most effective to allow excel to do the calculations with the SUM function because if you edit any of the cells that are being used with the SUM function, the total will be changed accordingly. (For example: 1 + 1 = 2. If you decide to change the first number to a 2, Excel will calculate 2 + 1 and give you 3. )

Rate this question:

• 2.

### If you want to add up up the cells from A1 through A10, you would use the following function in Excel.

• A.

=AVERAGE(A1:A10)

• B.

=SUM(A1:A11)

• C.

• D.

=SUM(A1:A10)

• E.

D. =SUM(A1:A10)
Explanation
The AVERAGE function will only get the average of the cells selected. The SUM function will get the total from the cells selected. There is no ADDITION or ADD function.

=SUM(A1:A11) is incorrect because it is adding the cells from A1 through A11, and the question asks for the addition of cells A1 through A10 which would be =SUM(A1:A10)

Rate this question:

• 3.

### Select all the ways you can add cells B1 through B10.

• A.

=SUM(B1:B10)

• B.

=B1+B2+B3+B4+B5+B6+B7+B8+B9+B10

• C.

=SUM(B1:B8)+B9+B10

• D.

=SUM(B1:B5)+SUM(B6:B10)

• E.

=B1*B10

• F.

=SUM(B1-B10)

A. =SUM(B1:B10)
B. =B1+B2+B3+B4+B5+B6+B7+B8+B9+B10
C. =SUM(B1:B8)+B9+B10
D. =SUM(B1:B5)+SUM(B6:B10)
Explanation
=SUM(B1:B10)
=B1+B2+B3+B4+B5+B6+B7+B8+B9+B10
=SUM(B1:B8)+B9+B10
=SUM(B1:B5)+SUM(B6:B10)
Will all give you the same answer. =SUM(B1:B10) is the same as writing out =B1+B2+B3+B4+B5+B6+B7+B8+B9+B10 except shorter.

=SUM(B1:B8)+B9+B10 is simply adding the cells between B1 and B8 and then also adds B9 and B10

=SUM(B1:B5)+SUM(B6:B10) is adding the cells between B1 and B5, and adds that to the total of the cells B6 through B10.

=B1*B10 is incorrect because this will multiply the contents inside B1 and B10

=SUM(B1-B10) is incorrect, it will subtract the cells B1 and B10 even though it is inside a SUM function. (It will make B10 act as a negative)

Rate this question:

• 4.

### =B3 is a cell reference to cell B3.

• A.

False, it is a reference to all cells except B3.

• B.

False, it is just a calculation.

• C.

False, it refers to all cells before B3.

• D.

False, it refers to cells that are equal to B3.

• E.

True

E. True
Explanation
Users can reference other cells by typing in =A1 (Replace A1 with any cell that the user wants to reference).

Rate this question:

• 5.

### The Math Function Shown above is going to give what result?

• A.

66

• B.

32

• C.

31

• D.

51

• E.

N/A

B. 32
Explanation
=A2+C2+C2+F2
= 0 + 1 + 1 + 30

Rate this question:

• 6.

### Excel does not provide an average function, to get around this a user MUST add up all the required cells and then divide by the appropriate amount.

• A.

True

• B.

False

B. False
Explanation
Excel does provide an average function.

Example: =AVERAGE(A2:A5)

Rate this question:

• 7.

• A.

True

• B.

False

B. False
Explanation
Functions will not work without an = sign at the beginning. If you do not put an = sign, the cell will merely display whatever you typed in it.

Rate this question:

• 8.

### If you have 100 responses and you want to type in the data from the responses into excel and give each response an ID starting from 1 and going up to 100, you will have to manually type in the numbers 1 through 100 in excel.

• A.

False, you only have to type in 1 through 50 and then Excel will generate the rest.

• B.

True, Excel should really add a feature to handle this tiresome work.

• C.

False, you can just write =NUMBERS(1:100)

• D.

False, you only have to type in 1 and then use the Auto-Fill feature to get to 100 quickly.

D. False, you only have to type in 1 and then use the Auto-Fill feature to get to 100 quickly.
Explanation
Excel has an auto-fill feature which can generate the numbers 1 through 100 in cells really quickly. To do this you simply type in 1 in the first cell and then using the auto-fill feature (go to the bottom right of the cell until the cursor turns into a + sign and then drag whichever way you want to go until you get to 100). If the auto-fill feature is only filling in 1s and not counting up, simple click on the auto-fill properties and apply "Fill Series" instead of "Copy Cells"

Rate this question:

• 9.

### The function =B2*B3+B4/B5 will give what answer?

• A.

1.25

• B.

2.75

• C.

5

• D.

2.8

• E.

3

B. 2.75
Explanation
=B2*B3+B4/B5
would be the same as
1 * 2 + 3 / 4

Excel follows order operations, so Excel would calculate it was
1 * 2 = 2
3 / 4 = .75
2 + .75 = 2.75

Note that even though the cell B5 has a value of 5 in it, it was not included in the function.

Rate this question:

• 10.

### Select all of the following that are functions that Excel features:

• A.

=SUM

• B.

=MODE

• C.

=MOD

• D.

=TOTAL

• E.

=MAX

• F.

=AVG

A. =SUM
B. =MODE
C. =MOD
E. =MAX
Explanation
=SUM is a math function in excel which adds all the indicated cells together.
=MODE is a math function in excel which obtains the mode selected cells.
=MOD is a math function for modulus (the remainder in division)
=TOTAL is NOT a math function. For totaling, =SUM would be used.
=MAX is a math function used to obtain the highest number from a selected range.
=AVG is NOT a math function, however, =AVERAGE is a math function which gets the average of selected cells.

Rate this question:

Related Topics Back to top
×

Wait!
Here's an interesting quiz for you.