MCQ Quiz: Microsoft Excel Functions! Trivia

1. A function or formulae in Excel begins with a __

*

/

=

= sign indicates that the text following it is a function or a formula.

Explanation

= sign indicates that the text following it is a function or a formula.

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

Average ()

Sum ()

Sumif ()

Sumif calculates the total provided a criterion is satisfied. Average finds the average.

Explanation

Sumif calculates the total provided a criterion is satisfied. Average finds the average.

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

True

False

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.

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.

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

-

;

:

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.

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.

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

True

False

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.

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.

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

True

False

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.

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.

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

True

False

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.

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.

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

Count ()

Sum ()

Total ()

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.

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.

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

= Average (B1:B5)

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

= Average ( B1:B5 / 5)

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.

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.

Submit