The Ultimate Microsoft Excel Trivia Knowledge! Quiz
This is what is known by many as the ultimate excel trivia. A lot of people have a hard time understanding how this feature works when compared to the other Microsoft applications. Take an exam to see how well you know some Excel basics. Content in this quiz was excerpted from Training on Microsoft Office Online. All the best, and be sure to take more quizzes like it!
Questions and Answers
- 1.
A fast way to add up a column of numbers is to click in the cell below the numbers and then:
- A.
Click Subtotals on the Data menu.
- B.
View the sum in the formula bar.
- C.
Click the AutoSum button on the Standard toolbar, then press ENTER.
Correct Answer
C. Click the AutoSum button on the Standard toolbar, then press ENTER.Explanation
To add up a column of numbers quickly, you can use the AutoSum button on the Standard toolbar. This button automatically selects the range of cells above it and inserts the SUM function in the formula bar, which calculates the sum of those numbers. Pressing ENTER then gives you the sum of the column. This method saves time and eliminates the need to manually enter the SUM function.Rate this question:
-
- 2.
Say that you want to paste a formula result — but not the underlying formula — to another cell. You would copy the cell with the formula, then place the insertion point in the cell you want to copy to. What next?
- A.
Click the Paste button on the Standard toolbar.
- B.
Click the arrow on the Paste button on the Standard toolbar, then click Formulas.
- C.
Click the arrow on the Paste button on the Standard toolbar, then click Values.
Correct Answer
C. Click the arrow on the Paste button on the Standard toolbar, then click Values.Explanation
To paste only the result of a formula to another cell, you need to first copy the cell with the formula. Then, place the insertion point in the cell where you want to paste the result. Next, click the arrow on the Paste button on the Standard toolbar, and from the options that appear, select "Values". This will paste only the calculated value of the formula into the desired cell, without including the underlying formula itself.Rate this question:
-
- 3.
How do you change column width to fit the contents?
- A.
Single-click the boundary to the left of the column heading.
- B.
Double-click the boundary to the right of the column heading.
- C.
Press ALT and single-click anywhere in the column.
Correct Answer
B. Double-click the boundary to the right of the column heading.Explanation
To change the column width to fit the contents, you need to double-click the boundary to the right of the column heading. This action will automatically adjust the column width to fit the widest content in that column.Rate this question:
-
- 4.
There are three worksheets with every new workbook. You can change that automatic number if you want to.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The given statement is true. When you create a new workbook in certain software applications, such as Microsoft Excel, it typically comes with three default worksheets. However, if you prefer to have a different number of worksheets, you have the option to change the automatic number and customize it according to your needs.Rate this question:
-
- 5.
###### means:
- A.
You've entered a number wrong.
- B.
You've misspelled something.
- C.
The cell is not wide enough.
Correct Answer
C. The cell is not wide enough.Explanation
This answer suggests that the meaning of "######" in this context is that the cell is not wide enough. This means that when a number or text is entered into the cell, it is displayed as "######" because the cell does not have enough width to show the entire content. This is a common issue in spreadsheet programs where the width of the cell needs to be adjusted to properly display the data.Rate this question:
-
- 6.
To add a new row, click a cell in the row immediately above where you want the new row.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
To add a new row in a table, you need to click on a cell in the row immediately below where you want the new row to be inserted. Therefore, the statement "To add a new row, click a cell in the row immediately above where you want the new row" is false.Rate this question:
-
- 7.
Which key do you press to group two or more nonadjacent worksheets?
- A.
CTRL.
- B.
SHIFT
- C.
ALT
Correct Answer
B. SHIFTExplanation
To group two or more nonadjacent worksheets in Excel, you need to press the SHIFT key. This allows you to select multiple worksheets that are not next to each other in the worksheet tab bar. Once grouped, any changes made to one worksheet will be applied to all the grouped worksheets simultaneously.Rate this question:
-
- 8.
To copy an entire worksheet and all its data, you should click the worksheet tab of the sheet that you want to copy, hold down SHIFT, and then drag the selected sheet along the row of sheet tabs.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
To copy an entire worksheet and all its data, you should click the worksheet tab of the sheet that you want to copy, hold down CTRL, and then drag the selected sheet along the row of sheet tabs.Rate this question:
-
- 9.
A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this ?
- A.
Go to FILE - SAVE AS - SAVE AS TYPE - Excel 4.0 Work Sheet
- B.
Right click on the spreadsheet tab and select DELETE
- C.
Right click on the spreadsheet and select INSERT - ENTIRE COLUMN
Correct Answer
A. Go to FILE - SAVE AS - SAVE AS TYPE - Excel 4.0 Work SheetExplanation
The correct sequence of events to remove a spreadsheet from a workbook is to go to FILE, then select SAVE AS, then choose SAVE AS TYPE, and finally select Excel 4.0 Work Sheet. This will save the spreadsheet as a different file type, effectively removing it from the current workbook. The other options mentioned, such as right-clicking on the spreadsheet tab and selecting DELETE or right-clicking on the spreadsheet and selecting INSERT - ENTIRE COLUMN, do not pertain to removing the spreadsheet from the workbook.Rate this question:
-
- 10.
Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell ?
- A.
Count
- B.
Average
- C.
Sum
Correct Answer
C. SumExplanation
The Sum formula can add all the numeric values in a range of cells and place the result in a different cell. It ignores any non-numeric values present in the range.Rate this question:
-
- 11.
Is it possible to insert an image from a file into an Excel spreadsheet ?
- A.
Yes
- B.
No
Correct Answer
A. YesExplanation
It is possible to insert an image from a file into an Excel spreadsheet. Excel provides the option to insert pictures or images from various file formats such as JPEG, PNG, GIF, etc. This feature allows users to enhance their spreadsheets by adding visual elements like charts, graphs, logos, or any other image relevant to the data being presented.Rate this question:
-
- 12.
Can an Excel spreadsheet be used as the "data source" for a Word Mail Merge ?
- A.
Yes
- B.
No
Correct Answer
A. YesExplanation
Yes, an Excel spreadsheet can be used as the "data source" for a Word Mail Merge. This is because Word has the capability to connect to external data sources, such as Excel, and merge the data into a document. By using the Mail Merge feature in Word, users can easily import data from an Excel spreadsheet and merge it with a Word document to create personalized letters, labels, or envelopes. This allows for efficient and automated mass mailings using the data stored in Excel.Rate this question:
-
- 13.
On an Excel sheet the active cell is indicated by ____.
- A.
A dark wide border
- B.
A dotted border
- C.
A blinking border
- D.
None of the above
Correct Answer
A. A dark wide borderExplanation
The active cell on an Excel sheet is indicated by a dark wide border. This border helps users identify which cell they are currently working on or editing. It stands out from the other cells and provides a visual cue for the user's reference. This is especially useful when working with large spreadsheets or when navigating through multiple cells. The dark wide border helps improve efficiency and accuracy when inputting or manipulating data in Excel.Rate this question:
-
- 14.
A Formula and a function are the same things.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
A formula and a function are not the same things. A formula is a mathematical expression used to perform calculations, while a function is a predefined operation that can be used in a formula to perform specific tasks. Functions can take input arguments and return a result, while formulas do not have this capability. Therefore, the given answer is incorrect.Rate this question:
-
- 15.
In order to multiply items in Excel you would use:
- A.
^
- B.
@
- C.
*
- D.
#
Correct Answer
C. *Explanation
To multiply items in Excel, you would use the asterisk symbol (*). The asterisk is the multiplication operator in Excel and is used to perform mathematical calculations. By using the asterisk, you can multiply numbers, cells, or ranges of cells in Excel.Rate this question:
-
- 16.
The formula = ((A2+B5)*5% is valid
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The given formula is not valid because it is missing a closing parenthesis. The correct formula should be ((A2+B5)*5%).Rate this question:
-
- 17.
If cells: A1=90 A2=85 A3=80 A4=75 A5=75 What will be your formula if you are going to get the average?
Correct Answer
=AVERAGE(A1:A5)
=(A1+A2+A3+A4+A5)/5
=average(a1:a5)
=(a1+a2+a3+a4+a5)/5Explanation
The formula to calculate the average of the given cells is =AVERAGE(A1:A5) or =(A1+A2+A3+A4+A5)/5 or =average(a1:a5) or =(a1+a2+a3+a4+a5)/5.Rate this question:
- 18.
If cells: A1=90 A2=85 A3=80 A4=75 A5=75 What will be your formula if you are going to get the total?
Correct Answer
=SUM(A1:A5)
=A1+A2+A3+A4+A5
=sum(a1:a5)
=a1+a2+a3+a4+a5Explanation
The correct formula to get the total of the given cells is =SUM(A1:A5) or =A1+A2+A3+A4+A5 or =sum(a1:a5) or =a1+a2+a3+a4+a5. These formulas will add up the values in cells A1 to A5 and give the total sum.Rate this question:
- 19.
Get the remarks in cell E10 that valued 75 which noted, if the remarks will be higher than 74, the remarks will be "PASSED" or else "FAILED".
Correct Answer
=IF(E10>74,"PASSED","FAILED")Explanation
The given answer is a formula in Excel that uses the IF function. It checks if the value in cell E10 is greater than 74. If it is, the formula returns "PASSED". If it is not, the formula returns "FAILED". This formula is used to determine whether a student has passed or failed based on their remarks.Rate this question:
- 20.
Get the remarks in cell A1 that valued 75 which noted, if the remarks will be higher than 74, the remarks will be "PASSED" or else "FAILED".
Correct Answer
=IF(A1>74,"PASSED","FAILED")Explanation
The correct answer is the formula =IF(A1>74,"PASSED","FAILED"). This formula uses the IF function to check if the value in cell A1 is greater than 74. If it is, the formula returns "PASSED". If it is not, the formula returns "FAILED". This formula is used to determine whether the remarks should be "PASSED" or "FAILED" based on the value in cell A1.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 21, 2023Quiz Edited by
ProProfs Editorial Team -
Jul 29, 2019Quiz Created by
Anna Kourouniotis
Back to top