Quiz 2: Calculations In Excel

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Enzanblaze
E
Enzanblaze
Community Contributor
Quizzes Created: 3 | Total Attempts: 14,656
| Attempts: 321 | Questions: 10
Please wait...
Question 1 / 10
0 %
0/100
Score 0/100
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.

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. )

Submit
Please wait...
About This Quiz
Quiz 2: Calculations In Excel - Quiz

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.

2. 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.

Explanation

Excel does provide an average function.

Example: =AVERAGE(A2:A5)

Submit
3. Functions do not have to start with an = sign, it is just used to make spreadsheets easier to read.

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.

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

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)

Submit
5. =B3 is a cell reference to cell B3.

Explanation

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

Submit
6. The Math Function Shown above is going to give what result?

Explanation

=A2+C2+C2+F2
= 0 + 1 + 1 + 30

The correct answer is 32.

Submit
7. 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.

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"

Submit
8. The function =B2*B3+B4/B5 will give what answer?

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.

Submit
9. Select all the ways you can add cells B1 through 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)

Submit
10. Select all of the following that are functions that Excel features:

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.

Submit
View My Results

Quiz Review Timeline (Updated): Mar 17, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 17, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • May 01, 2011
    Quiz Created by
    Enzanblaze
Cancel
  • All
    All (10)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
In Excel, if you want to add up an entire column you have to use a...
Excel does not provide an average function, to get around this a user...
Functions do not have to start with an = sign, it is just used to make...
If you want to add up up the cells from A1 through A10, you would use...
=B3 is a cell reference to cell B3.
The Math Function Shown above is going to give what result?
If you have 100 responses and you want to type in the data from the...
The function =B2*B3+B4/B5 will give what answer?
Select all the ways you can add cells B1 through B10.
Select all of the following that are functions that Excel features:
Alert!

Advertisement