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,570
| Attempts: 321
SettingsSettings
Please wait...
  • 1/10 Questions

    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.

    • 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.
Please wait...
Quiz 2: Calculations In Excel - Quiz
About This 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.

Quiz Preview

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

    • True

    • False

    Correct Answer
    A. False
    Explanation
    Excel does provide an average function.

    Example: =AVERAGE(A2:A5)

    Rate this question:

  • 3. 

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

    • True

    • False

    Correct Answer
    A. 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:

  • 4. 

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

    • =AVERAGE(A1:A10)

    • =SUM(A1:A11)

    • =ADDITION(A1:A10)

    • =SUM(A1:A10)

    • =ADD(A1:A10)

    Correct Answer
    A. =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:

  • 5. 

    =B3 is a cell reference to cell B3.

    • 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

    Correct Answer
    A. 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:

  • 6. 
    The Math Function Shown above is going to give what result? - ProProfs

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

    • 66

    • 32

    • 31

    • 51

    • N/A

    Correct Answer
    A. 32
    Explanation
    =A2+C2+C2+F2
    = 0 + 1 + 1 + 30

    The correct answer is 32.

    Rate this question:

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

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

    Correct Answer
    A. 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:

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

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

    • 1.25

    • 2.75

    • 5

    • 2.8

    • 3

    Correct Answer
    A. 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:

  • 9. 

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

    • =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)

    Correct Answer(s)
    A. =SUM(B1:B10)
    A. =B1+B2+B3+B4+B5+B6+B7+B8+B9+B10
    A. =SUM(B1:B8)+B9+B10
    A. =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:

  • 10. 

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

    • =SUM

    • =MODE

    • =MOD

    • =TOTAL

    • =MAX

    • =AVG

    Correct Answer(s)
    A. =SUM
    A. =MODE
    A. =MOD
    A. =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:

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
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.