MCQ Quiz: Microsoft Excel Functions! Trivia

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Rutwija
R
Rutwija
Community Contributor
Quizzes Created: 1 | Total Attempts: 258
Questions: 9 | Attempts: 258

SettingsSettingsSettings
MCQ Quiz: Microsoft Excel Functions! Trivia - Quiz


Do you have a strong knowledge of Microsoft Excel functions? Microsoft Excel is said to be the most challenging Microsoft tool for people to understand because of its ability to handle different types of data. In this quiz, you will get to test out just how much you know the tool and its many features. Give it a shot and see if you might need a refresher course to polish up your skills when done.


Questions and Answers
  • 1. 

    A function or formulae in Excel begins with a __

    • A.

      *

    • B.

      /

    • C.

      =

    Correct Answer
    C. =
    Explanation
    = sign indicates that the text following it is a function or a formula.

    Rate this question:

  • 2. 

    _______ function is used to find the total of given values.

    • A.

      Average ()

    • B.

      Sum ()

    • C.

      Sumif ()

    Correct Answer
    B. Sum ()
    Explanation
    Sumif calculates the total provided a criterion is satisfied. Average finds the average.

    Rate this question:

  • 3. 

    To know the total number of records can be found by ______ function.

    • A.

      Count ()

    • B.

      Sum ()

    • C.

      Total ()

    Correct Answer
    A. Count ()
    Explanation
    The correct answer is Count(). The Count() function is used to calculate the total number of records in a dataset. It counts the number of rows or records in a table or a specific column. By using the Count() function, we can easily determine the total count of records without the need for any additional calculations or manipulations.

    Rate this question:

  • 4. 

    Excel automatically updates the calculated values if Formula and Functions are used.

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    Excel automatically updates the calculated values if formulas and functions are used because it has a feature called "automatic calculation". This means that whenever a change is made to a cell that is referenced in a formula or function, Excel will automatically recalculate the result based on the updated values. This ensures that the calculated values are always up to date and accurate. Therefore, the answer "True" is correct.

    Rate this question:

  • 5. 

    Which of the following will give the average of data from B1 to B5 ?

    • A.

      = Average (B1:B5)

    • B.

      = (B1+B2+B3+B4+B5) / 5

    • C.

      = Average ( B1:B5 / 5)

    Correct Answer(s)
    A. = Average (B1:B5)
    B. = (B1+B2+B3+B4+B5) / 5
    Explanation
    The correct answer is "= Average (B1:B5)" and "= (B1+B2+B3+B4+B5) / 5". Both of these options will give the average of the data from B1 to B5. The first option uses the AVERAGE function to calculate the average directly from the range B1:B5. The second option manually adds up the values in B1, B2, B3, B4, and B5, and then divides the sum by 5 to get the average. Both methods will yield the same result.

    Rate this question:

  • 6. 

    A student wrote =Sum(B1B5) to find the total. ______ is missing from the function?

    • A.

      -

    • B.

      ;

    • C.

      :

    Correct Answer
    C. :
    Explanation
    The student is missing a colon (:) in the function. The correct function should be =Sum(B1:B5) to find the total. The colon is used to specify a range of cells, in this case, from cell B1 to B5.

    Rate this question:

  • 7. 

    We have to enter the formula or function for each cell. It cannot be copied.

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    The statement contradicts the typical functionality of spreadsheets, where formulas and functions can be easily copied and applied to multiple cells. In spreadsheets, users can enter a formula or function in one cell and then copy and paste it to other cells to apply the same calculation. Therefore, the correct answer is False.

    Rate this question:

  • 8. 

    A row is indicated by a number and a column by a letter.

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    This statement is true because in a grid or table, rows are typically identified by numbers and columns are identified by letters. This convention allows for easy referencing and organization of data within the grid or table.

    Rate this question:

  • 9. 

    We can display the formula or function used in a cell instead of values.

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    We can display the formula or function used in a cell instead of values by using the formula bar in Excel. This allows us to see the actual formula or function that was used to calculate the value in the cell. This can be helpful for troubleshooting or understanding how a particular value was derived. By selecting the cell and looking at the formula bar, we can easily view and edit the formula or function.

    Rate this question:

Quiz Review Timeline +

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
  • Oct 03, 2011
    Quiz Created by
    Rutwija
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.