Microsoft Excel Quiz
(61).jpg "Microsoft Excel Quiz - Quiz")
Do you think you know the basics of Microsoft Excel very well? Take is Microsoft Excel quiz and test your knowledge! Have you just finished your training in Microsoft Excel and are looking to test out your understanding? The practice test below is set to test how well you can use excel effectively. Give it a try and ensure you read up on the parts you don't get correctly. Along with practice, you will learn new things too. If you find this quiz a good one and informative, share it with others also.
Questions and Answers
- 1.
A fast way to add up the column of numbers is to click on 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.
- D.
Click the Sum button on the Standard toolbar.
Correct Answer
C. Click the AutoSum button on the Standard toolbar, then press ENTER.Explanation
The fastest way to add up the column of numbers is by clicking the AutoSum button on the Standard toolbar and then pressing ENTER. This button automatically selects the range of cells above it and adds them up, providing the sum in the selected cell. This method eliminates the need to manually select the range or go through additional steps, making it the most efficient option.Rate this question:
-
- 2.
If 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.
- D.
Click the arrow on the Copy button on the Standard toolbar.
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 copy the cell with the formula and then place the insertion point in the destination cell. Next, you should click the arrow on the Paste button on the Standard toolbar and select "Values" from the options. This will paste only the calculated result of the formula into the new cell, without including the underlying formula itself.Rate this question:
-
- 3.
How do you change the 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.
- D.
Press Fn and double-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 automatically adjusts the column width to accommodate the widest content within it.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
By default, every new workbook in Excel comes with three worksheets. However, it is possible to change this automatic number of worksheets if desired.Rate this question:
-
- 5.
###### means:
- A.
You've entered a number wrong.
- B.
You've misspelled something.
- C.
The cell is not wide enough.
- D.
The cell has the wrong data.
Correct Answer
C. The cell is not wide enough.Explanation
The given answer suggests that the reason behind the issue is that the cell is not wide enough. This means that when entering the number, it exceeds the width of the cell, causing it to display incorrectly. The other options, such as entering a wrong number or misspelling something, are not applicable in this case. The answer implies that the width of the cell needs to be adjusted to properly display the entered number.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
In most spreadsheet applications, to add a new row, you usually click on the row number on the left-hand side of the screen (which corresponds to the row immediately below where you want the new row) and then insert a new row. Clicking a cell in the row immediately above where you want the new row typically does not directly add a new row.Rate this question:
-
- 7.
Which key do you press to group two or more nonadjacent worksheets?
- A.
CTRL
- B.
SHIFT
- C.
ALT
- D.
TAB
Correct Answer
A. CTRLExplanation
To group two or more nonadjacent worksheets in Microsoft Excel, you typically use the CTRL key. Here's how you can do it:
Click on the first worksheet tab that you want to include in the group.
Hold down the CTRL key on your keyboard.
While holding down the CTRL key, click on the other worksheet tabs you want to include in the group. Each clicked worksheet tab will be added to the selection group.
Release the CTRL key when you've selected all the desired worksheets.
The worksheets you selected will now be grouped together, and any action you perform on one of them will also apply to the others in the group.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 SHIFT, and then drag the selected sheet along the row of sheet tabs. This statement is false because to copy a worksheet, you should right-click on the worksheet tab, select "Move or Copy," choose the location where you want to copy the worksheet, and then click OK.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.
- D.
Left-click on the spreadsheet and select SAVE.
Correct Answer
B. Right-click on the spreadsheet tab and select DELETE.Explanation
The correct sequence of events to remove a spreadsheet from a workbook in Microsoft Excel is to right-click on the spreadsheet tab.
Select DELETE.
So, the correct answer is: "Right-click on the spreadsheet tab and select DELETE."Rate this question:
-
- 10.
Which formula can add 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
- D.
Addition
Correct Answer
C. SumExplanation
The formula that can add all the numeric values in a range of cells, excluding non-numeric values, and place the result in a different cell is the "Sum" formula. This formula calculates the sum of all the numbers in the specified range and ignores any non-numeric values, providing the total sum as the result.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
Yes, it is possible to insert an image from a file into an Excel spreadsheet. Excel allows users to add images to a worksheet by using the 'Insert' tab and selecting the 'Picture' option. This enables users to browse their computer for the desired image file and insert it directly into the spreadsheet.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. Excel allows users to store and organize data in a tabular format, making it a suitable source for merging data with Word documents. By linking the Excel spreadsheet to a Word document, users can easily import and merge the data from specific columns into the desired locations within the Word document, saving time and effort in creating personalized documents.Rate this question:
-
- 13.
On an Excel sheet, the active cell is indicated by ____.
- A.
A wide dark border
- B.
A dotted border
- C.
A blinking border
- D.
None of the above
Correct Answer
A. A wide dark borderExplanation
The active cell on an Excel sheet is indicated by a wide dark border. This border helps to visually distinguish the currently selected cell from the rest. It is wider and darker compared to the borders of other cells, making it easier to identify. The wide dark border serves as a visual cue for users to know which cell they are currently working on, allowing them to input or edit data accurately.Rate this question:
-
- 14.
Formula and function are the same things.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
Formulas and functions are not the same things. In Excel, a formula is an expression that performs calculations using cell references, values, and operators. A function, on the other hand, is a predefined formula that performs specific calculations. Functions are built-in to Excel and are used to simplify common calculations.Rate this question:
-
- 15.
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 (*). This symbol is used as the multiplication operator in Excel formulas. By placing the asterisk between two or more cell references or numbers, Excel will perform the multiplication operation and provide the result.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 would be =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 formula to calculate the total of the cells A1 to A5 is =SUM(A1:A5) or =A1+A2+A3+A4+A5 or =sum(a1:a5) or =a1+a2+a3+a4+a5.Rate this question:
- 19.
Get the remarks in cell E10 that valued 75, which noted that if the remarks are higher than 74, the remarks will be "PASSED" or else "FAILED."
Correct Answer
=IF(E10>74,"PASSED","FAILED")Explanation
The given correct answer is "=IF(E10>74,"PASSED","FAILED")". This formula is used to determine the remarks for a value in cell E10. If the value in E10 is greater than 74, the formula will return "PASSED". Otherwise, it will return "FAILED". This formula is a simple way to assign a pass or fail status based on a specific condition.Rate this question:
- 20.
Get the remarks in cell A1 that valued 75, which noted that if the remarks are higher than 74, the remarks will be "PASSED" or else "FAILED".
Correct Answer
=IF(A1>74,"PASSED","FAILED")Explanation
The given answer is a formula that uses the IF function in Excel. It checks 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 if the remarks for a certain value are either "PASSED" or "FAILED" based on the condition given.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
-
Jan 22, 2024Quiz Edited by
ProProfs Editorial Team
Expert Reviewed by
Godwin Iheuwa -
Mar 26, 2009Quiz Created by
Lorie
Back to top