Take This Basic MS Excel Skills Quiz!
(90).jpg "Take This Basic MS Excel Skills Quiz! - Quiz")
Think you are an expert in MS Excel? It's time to showcase your skills with this Basic MS Excel Skills Quiz. Microsoft Excel is a spreadsheet program used for calculations, making charts, and recording data about all sorts of business processes. Most companies with their staff have adequate knowledge of how to use this application. Take this quiz to see how well you know some Excel basics. All the best! Try to get a perfect score here! If you find the quiz informative, share it with others for their knowledge enhancement.
Questions and Answers
- 1.
A fast way to add up a column of numbers is to click 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.
All of the above
Correct Answer
C. Click the AutoSum button on the Standard toolbar, then press ENTER.Explanation
The correct answer is "Click the AutoSum button on the Standard toolbar, then press ENTER." This option suggests using the AutoSum feature in the software to quickly add up the column of numbers. By clicking the AutoSum button and pressing ENTER, the software will automatically calculate the sum of the selected range of cells and display the result. This method saves time and effort compared to manually entering the formula or using other options mentioned in the question.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.
- D.
None of the above
Correct Answer
C. Click the arrow on the Paste button on the Standard toolbar, then click Values.Explanation
To paste a formula result without the underlying formula to another cell, you would first copy the cell with the formula. Then, you would place the insertion point in the cell where you want to paste the result. Next, you would click the arrow on the Paste button on the Standard toolbar. From the options that appear, you would select "Values". This will paste only the calculated result of the formula into the selected cell, without including the actual 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.
None of the above
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 width of the column to accommodate the widest content within it. Single-clicking the boundary to the left of the column heading or pressing ALT and single-clicking anywhere in the column will not achieve the desired result. Therefore, the correct option is to double-click the boundary to the right of the column heading.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, new workbooks created in Excel contain one worksheet. However, you can change the number of worksheets available by default in new workbooks with a simple setting. So, it’s true that you can change the automatic number of worksheets in a new workbook. It’s also worth noting that there are some sources stating that by default, there are three worksheets in Excel whenever you open or create a new Excel workbook. This discrepancy might be due to different versions of Excel having different default settings. Regardless, the number of worksheets can be changed according to your preference.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.
None of the above
Correct Answer
C. The cell is not wide enough.Explanation
The correct answer is "The cell is not wide enough." This means that when entering a number or text into a cell, if the cell is not wide enough to display the entire content, it will show only a portion of it. This can lead to confusion or incorrect interpretation of the data. To ensure that all the content is visible, the cell width should be adjusted accordingly.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
A. TrueExplanation
To add a new row in Excel, you can click a cell in the row immediately above where you want the new row, then right-click and select 'Insert’. This will insert a new row above the selected cell. You can also use keyboard shortcuts to achieve the same result. For example, with a single cell selected, you can hit Ctrl + Shift + + to insert a new row. So, it’s true that you can add a new row by clicking a cell in the row immediately above where you want the new row.Rate this question:
-
- 7.
Which key do you press to group two or more non-adjacent worksheets?
- A.
CTRL
- B.
SHIFT
- C.
ALT
- D.
CAPS LOCK
Correct Answer
A. CTRLExplanation
To group two or more non-adjacent worksheets in Microsoft Excel, you typically hold down the Ctrl key while selecting the individual worksheet tabs. So, the correct answer is Ctrl. Here are the steps:
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 Ctrl, click on the other worksheet tabs you want to include in the group.
Release the Ctrl key once you've selected all the desired worksheet tabs.
This action will group the selected worksheets together, and any changes you make to one of them will apply to all worksheets 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 CTRL, and then drag the selected sheet along the row of sheet tabs.Rate this question:
-
- 9.
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.
Subtract
Correct Answer
C. SumExplanation
The correct answer is "Sum" because the SUM formula in Excel can add all the numeric values in a range of cells. It ignores any non-numeric values and only adds the numeric ones. The result of the sum can be placed in a different cell by specifying the range of cells to be summed as the argument of the SUM formula, and then referencing the cell where the sum should be displayed.Rate this question:
-
- 10.
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. This can be done by selecting the "Insert" tab, clicking on "Pictures" and then choosing the desired image file from the file explorer. The image will then be inserted into the spreadsheet and can be resized or positioned as needed.Rate this question:
-
- 11.
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 can import data from Excel and use it to populate fields in a mail merge document. By linking the Excel spreadsheet as the data source, Word can easily merge the data into the desired document, such as letters, labels, or envelopes, saving time and effort in manually entering the data.Rate this question:
-
- 12.
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 the user identify which cell is currently selected and ready for data input or manipulation. The dark wide border stands out from the other cells, making it easy to locate and work with the active cell.Rate this question:
-
- 13.
A Formula and a function are the same things.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
A formula and a function are not the same things. A formula is a mathematical expression that performs calculations, while a function is a predefined set of instructions that performs a specific task. A function can be used within a formula to carry out a specific operation, but they are distinct concepts.Rate this question:
-
- 14.
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 multiplication calculations between two or more cells or values. By using the asterisk symbol, you can easily multiply numbers, formulas, or cell references in Excel.Rate this question:
-
- 15.
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:
-
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 16, 2024Quiz Edited by
ProProfs Editorial Team
Expert Reviewed by
Godwin Iheuwa -
Apr 27, 2012Quiz Created by
Easagun
Back to top