FREE! Click here to Join FunTrivia. Thousands of games, quizzes, and lots more!

Quiz about Microsoft Excel Functions and Formulas

Microsoft Excel Functions and Formulas Quiz

Test your knowledge on Microsoft Excel

Excel is a very versatile application, so what do you know about it? This quiz will test your knowledge. All questions should be answerable with any Excel version from 2010 forward.

A multiple-choice quiz by Flukey. Estimated time: 2 mins.

Author
Flukey

Time
2 mins

Type
Multiple Choice

Quiz #
417,441

Updated
Sep 23 24

# Qns
10

Difficulty
Average

Avg Score
6 / 10

Plays
104

Last 3 plays: stephedm (10/10), mungojerry (6/10), TAKROM (2/10).

One at a Time - Single Page - Timed Game

Question 1 of 10

1. Which of these is NOT a function that belongs to the category of Logical functions? Hint

XOR

NOT

MEDIAN

NEXT>

Question 2 of 10

2. MODE is classified as what type of function? Hint

Financial

Statistical

Date & Time

Logical

NEXT>

Question 3 of 10

3. Which keyboard shortcut will do the opposite of what Ctrl Z does? Hint

Ctrl W

Ctrl Y

Ctrl X

Ctrl V

NEXT>

Question 4 of 10

4. Which of these functions does not exist? Hint

LOOKUP

VLOOKUP

HLOOKUP

RLOOKUP

NEXT>

Question 5 of 10

5. If you use the @ sign at the start of a function, like @SUM, it will cause an error

True

False

NEXT>

Question 6 of 10

6. In Microsoft Excel what does the F8 function key do? Hint

Allows you to start selecting cells using the keyboard

Bolds the content of the current cell

Inserts the SUM function into the current cell

Copies the content of the current cell to the cell below it

NEXT>

Question 7 of 10

7. Pressing Shift and Delete does the same as which of these keyboard shortcuts? Hint

Ctrl Y

Ctrl C

Ctrl X

Ctrl V

NEXT>

Question 8 of 10

8. In Microsoft Excel a Bubble is Hint

None of these

A function for calculation the volume of a sphere

An error caused by having too many values in a formula

A kind of chart

NEXT>

Question 9 of 10

9. If there is a time (without a date) in cell B9, what will the following formula do?

=HOUR(B9)*60+MINUTE(B9) Hint

Show what time it will be 60 hours after that time

Display the time again

Give the total amount of minutes the time represents

Give 60 times the amount of hours in the time

NEXT>

Question 10 of 10

10. In Microsoft Excel a Slicer is used for doing what kind of activity? Hint

Charting data

Filtering data

Decreasing the value of data

Sorting data

(Optional) Create a Free FunTrivia ID to save the points you are about to earn:

Select a User ID:

Choose a Password:

Your Email:

Most Recent Scores

Nov 22 2024 : stephedm: 10/10
Nov 01 2024 : mungojerry: 6/10
Oct 19 2024 : TAKROM: 2/10
Oct 15 2024 : clevercatz: 7/10
Oct 12 2024 : zorba_scank: 4/10
Oct 10 2024 : MargW: 5/10
Oct 07 2024 : Guest 71: 8/10
Oct 07 2024 : DeepHistory: 10/10
Oct 05 2024 : Guest 174: 2/10

Quiz Answer Key and Fun Facts

1. Which of these is NOT a function that belongs to the category of Logical functions?

Answer: MEDIAN

MEDIAN is a statistical function, used to get the middle value of a set.

2. MODE is classified as what type of function?

Answer: Statistical

MODE is a statistical function. It returns the most commonly occurring value in a set.

3. Which keyboard shortcut will do the opposite of what Ctrl Z does?

Answer: Ctrl Y

Ctrl Z is the Undo keyboard shortcut. Ctrl Y is the Redo keyboard shortcut, effectively reverting the previous Ctrl Z, but it can also be used to repeat a command (such as formatting).

4. Which of these functions does not exist?

Answer: RLOOKUP

Excel has a number of functions which allow you to search your data for specific values. LOOKUP searches for a piece of data in a row or column and returns a corresponding piece of data in another row or column. VLOOKUP searches for data vertically by columns. HLOOKUP searches for data horizontally by rows.

5. If you use the @ sign at the start of a function, like @SUM, it will cause an error

Answer: False

In Microsoft Excel, all formulas begin with the equals sign. An older spreadsheet application called Lotus123 used the @ symbol before the names of functions. To make it easier for users of Lotus123 to use Excel, this facility was left in and is still there today. If you start with the @ it will change it to the equals sign after you press Enter. Try it yourself and see.

6. In Microsoft Excel what does the F8 function key do?

Answer: Allows you to start selecting cells using the keyboard

If you press F8 and then use the arrow keys, you can start to select cells. It locks the start point at the cell you were at, like clicking from one cell to highlight with a mouse. This is handy if your mouse is not working properly. Pressing F8 again will stop the process.

7. Pressing Shift and Delete does the same as which of these keyboard shortcuts?

Answer: Ctrl X

Shift and Delete allows you to cut something in Excel, so is the same as Ctrl X. Unlike Ctrl X, however, it does not mean "Cut" in all Windows software - be particularly careful in Windows Explorer here (It does mean "delete and do not recycle" there)

8. In Microsoft Excel a Bubble is

Answer: A kind of chart

A bubble chart is a type of scatter chart that shows points on the chart area and indicates values by showing bubbles of different sizes.

9. If there is a time (without a date) in cell B9, what will the following formula do? =HOUR(B9)*60+MINUTE(B9)

Answer: Give the total amount of minutes the time represents

The formula will convert the time into a total of minutes. It multiples the hour by 60 and adds the amount of minutes. So if the time was 2 hours and 40 minutes, it was multiply the 2 by 60, giving 120 minutes and add 40 to give 160. There are 160 minutes in two hours and 40 minutes.

10. In Microsoft Excel a Slicer is used for doing what kind of activity?

Answer: Filtering data

A Slicer is a visual way of allowing you to filter data that you have in a regular table or a pivot table.

Source: Author Flukey

This quiz was reviewed by FunTrivia editor WesleyCrusher before going online.
Any errors found in FunTrivia content are routinely corrected through our feedback system.