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.
- 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.
In Microsoft Excel, what function can you use to find the average of a range of cells?
- A.
AVG()
- B.
AVERAGE()
- C.
MEAN()
- D.
SUM()
Correct Answer
B. AVERAGE()Explanation
The AVERAGE() function in Excel calculates the arithmetic mean of a range of cells. You provide the function with a range of cells, and it adds up all the numerical values in those cells and then divides by the number of cells to give you the average.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.
Which of the following Excel functions can be used to calculate the average of a range of numbers?
- A.
SUM()
- B.
COUNT()
- C.
AVERAGE()
- D.
MAX()
Correct Answer
C. AVERAGE()Explanation
In Microsoft Excel, the AVERAGE() function calculates the mean of a set of numbers. For example, =AVERAGE(A1:A10) computes the average of values in cells A1 through A10. In contrast, SUM() adds up values, COUNT() counts the number of cells with numbers, and MAX() identifies the highest value. Using AVERAGE() helps quickly determine the central tendency of data.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)Explanation
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.
In Microsoft Excel, a ______ is an expression that performs calculations on data in a worksheet.
Correct Answer
formula, FormulaExplanation
Formulas are the backbone of Excel's computational capabilities. They allow you to perform a wide range of calculations, from simple arithmetic to complex statistical analysis, by combining operators, cell references, and functions. Formulas enable you to automate calculations, analyze data, and create dynamic spreadsheets that update automatically when data changes.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 13, 2025Quiz Edited by
ProProfs Editorial Team
Expert Reviewed by
Godwin Iheuwa -
Mar 26, 2009Quiz Created by
Lorie
Back to top