MS Excel Basics Trivia Quiz: Practice Test!
(16).jpg "MS Excel Basics Trivia Quiz: Practice Test! - Quiz")
How much do you know about MS Excel Basics? Would you be willing to give this quiz a shot? This quiz entails recognizing a fast way to add up a column of numbers, how to paste another formula result to another cell, how do you change column width to fit the contents, how to insert an image from a file into an Excel sheet, etc. You should take this outstanding quiz and ensure a successful career.
Questions and Answers
- 1.
A fast way to add up this 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
The AutoSum button on the Standard toolbar is a quick and convenient way to add up a column of numbers. By clicking on this button and then pressing ENTER, the sum of the numbers in the column will be calculated and displayed in the selected cell. This eliminates the need to manually enter a formula or use other functions to calculate the sum.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 formula result to another cell without the underlying formula, 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. Finally, you would select "Values" from the options that appear. This will paste only the calculated value of the formula to the desired cell.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 automatically adjusts the width of the column 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
The statement is true because when you create a new workbook in Excel, it automatically comes with three worksheets. However, if you want to change the number of worksheets, you have the option to do so.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
The given correct answer suggests that the meaning of "######" in this context is that the cell is not wide enough. This means that the cell in a spreadsheet or table does not have enough width to display the entire content, resulting in the appearance of "######" to indicate that the content is truncated. This commonly occurs when the content is longer than the width of the cell or when the cell formatting is not adjusted properly.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
To add a new row in a table, you need to click a cell in the row immediately below where you want the new row. Clicking a cell in the row above where you want the new row will not add a new row. 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. SHIFTExplanation
To group two or more nonadjacent worksheets, you would press the SHIFT key. By holding down the SHIFT key and clicking on the worksheet tabs you want to group, you can select multiple nonadjacent worksheets at once. This allows you to perform actions on all the selected worksheets simultaneously, such as formatting, entering data, or applying formulas.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.
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 -
- 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. SumExplanation
The Sum formula can be used to add all the numeric values in a range of cells and place the result in a different cell. It ignores any non-numeric values in the range and only adds the numeric values.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
It is possible to insert an image from a file into an Excel spreadsheet. This can be done by selecting the "Insert" tab in Excel, clicking on the "Pictures" option, and then choosing the desired image file from the file explorer. The image will then be inserted into the spreadsheet and can be resized, moved, or formatted as needed.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
An Excel spreadsheet can be used as the "data source" for a Word Mail Merge. This means that the data from the Excel spreadsheet can be merged into a Word document to create personalized letters, labels, or other documents. The Excel spreadsheet acts as a database of information that can be easily accessed and merged with the Word document.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 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 entry or formatting. It stands out from the other cells and provides a visual cue to the user. The dark wide border is a common feature in spreadsheet software and is widely used to improve user experience and efficiency.Rate this question:
-
- 14.
A Formula and a function are the same thing.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
A formula and a function are not the same thing. A formula is a mathematical expression that performs calculations, while a function is a predefined formula that performs a specific task. Functions can be used within formulas to simplify calculations and automate tasks. Therefore, the correct answer is False.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 (*). This symbol is the multiplication operator in Excel and is used to perform mathematical calculations. By using the asterisk symbol, you can multiply the values of different cells or numbers in Excel formulas and functions.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 correct formula to calculate the average of the given cells is =AVERAGE(A1:A5) or =(A1+A2+A3+A4+A5)/5. Both formulas will give the same result, which is the average of the values in cells A1 to A5.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 correct formula to get 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. These formulas will add up the values in the given range of cells and give the total.Rate this question:
Back to top