The Ultimate Microsoft Excel Trivia Knowledge! Quiz

1. In order to multiply items in Excel you would use:

^

@

*

#

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.

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.

2. Can an Excel spreadsheet be used as the "data source" for a Word Mail Merge ?

Yes

No

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.

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.

3. Is it possible to insert an image from a file into an Excel spreadsheet ?

Yes

No

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.

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.

4. A fast way to add up a column of numbers is to click in the cell below the numbers and then:

Click Subtotals on the Data menu.

View the sum in the formula bar.

Click the AutoSum button on the Standard toolbar, then press ENTER.

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.

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.

5. ###### means:

You've entered a number wrong.

You've misspelled something.

The cell is not wide enough.

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.

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.

6. How do you change column width to fit the contents?

Single-click the boundary to the left of the column heading.

Double-click the boundary to the right of the column heading.

Press ALT and single-click anywhere in the column.

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.

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.

7. There are three worksheets with every new workbook. You can change that automatic number if you want to.

True

False

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.

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.

8. The formula = ((A2+B5)*5% is valid

True

False

The given formula is not valid because it is missing a closing parenthesis. The correct formula should be ((A2+B5)*5%).

Explanation

The given formula is not valid because it is missing a closing parenthesis. The correct formula should be ((A2+B5)*5%).

9. 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?

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.

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.

Submit

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 ?

Count

Average

Sum

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.

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.

11. On an Excel sheet the active cell is indicated by ____.

A dark wide border

A dotted border

A blinking border

None of the above

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.

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.

12. To add a new row, click a cell in the row immediately above where you want the new row.

True

False

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.

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.

13. 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?

Click the Paste button on the Standard toolbar.

Click the arrow on the Paste button on the Standard toolbar, then click Formulas.

Click the arrow on the Paste button on the Standard toolbar, then click Values.

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.

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.

14. 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.

True

False

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.

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.

15. A Formula and a function are the same things.

True

False

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.

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.

16. Which key do you press to group two or more nonadjacent worksheets?

CTRL.

SHIFT

ALT

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.

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.

Submit

18. A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this ?

Go to FILE - SAVE AS - SAVE AS TYPE - Excel 4.0 Work Sheet

Right click on the spreadsheet tab and select DELETE

Right click on the spreadsheet and select INSERT - ENTIRE COLUMN

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.

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.

19. 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".

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.

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.

Submit

20. 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".

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.

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.

Submit