The Ultimate Microsoft Excel Trivia Knowledge! Quiz
By Anna Kourouniotis
Anna Kourouniotis, Database analysis|
Anna, an experienced data professional, provides essential data to support student success. With international experience in e-business, logistics, and higher education, she has focused on higher education administration since 2011.
Quizzes Created: 1|Total Attempts: 540
, Database analysis
Approved & Edited byProProfs 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.
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. True
Explanation 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. False
Explanation 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. SHIFT
Explanation 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. False
Explanation 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 Sheet
Explanation 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. Sum
Explanation 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. Yes
Explanation 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. Yes
Explanation 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 border
Explanation 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. True
Explanation 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. False
Explanation 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?
Explanation 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?
Explanation 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:
Anna Kourouniotis |Database analysis|
Anna, an experienced data professional, provides essential data to support student success. With international experience in e-business, logistics, and higher education, she has focused on higher education administration since 2011.