MCQ Quiz: Microsoft Excel Functions! Trivia
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. TrueExplanation
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) / 5Explanation
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. FalseExplanation
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. TrueExplanation
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. TrueExplanation
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, 2023Quiz Edited by
ProProfs Editorial Team -
Oct 03, 2011Quiz Created by
Rutwija
Back to top