The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Ready to test your MS Excel Basics? Here is a quick quiz for you. Do you think you will Ace this quiz? This quiz involves your knowledge of the easiest way to add up columns of numbers, change the column width to fit the contents, add a new row, and the correct sequence to follow for a user to remove a spreadsheet from a workbook. It will all add up if you take this quiz.
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 allows you to quickly add up a column of numbers. By clicking this button and then pressing ENTER, the sum of the numbers in the column will be displayed in the cell below the numbers. This method is faster than using the Subtotals feature or viewing the sum in the formula bar.
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 After copying the cell with the formula, the next step is to click the arrow on the Paste button on the Standard toolbar. From the options that appear, select "Values". This will paste only the result of the formula into the desired 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.
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. By doing so, the column will automatically adjust its width to accommodate the widest content within it. This action is a quick and efficient way to ensure that all the data in the column is visible without any truncation or overflow.
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. True
Explanation The statement is true because when you create a new workbook in most spreadsheet programs, it automatically comes with three worksheets. However, you have the option to change this default number and add or remove worksheets as needed.
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 correct answer is "The cell is not wide enough." This means that when entering data into a cell in a spreadsheet or table, the width of the cell is not sufficient to display the entire content. This can happen when the content is longer than the cell's width, causing it to be cut off or displayed partially. To resolve this issue, the cell's width needs to be adjusted to accommodate the full content.
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. False
Explanation The statement is false because 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 to be inserted, not above.
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. SHIFT
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 workbook. By holding down the SHIFT key and clicking on the worksheet tabs, you can select multiple worksheets at once and perform actions on all of them 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. False
Explanation To copy an entire worksheet and all its data, you should right-click the worksheet tab of the sheet that you want to copy, select "Move or Copy" from the context menu, choose the location where you want to copy the worksheet, and then click "OK". Holding down SHIFT and dragging the selected sheet along the row of sheet tabs does not copy the worksheet.
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
Explanation To remove a spreadsheet from a workbook, the correct sequence of events is to go to FILE, then select SAVE AS, then choose SAVE AS TYPE, and finally select Excel 4.0 Work Sheet. This sequence of events will allow the user to save the spreadsheet as a different file type, effectively removing it from the current workbook.
Rate this question:
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. Sum
Explanation The Sum formula is 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. The Count formula is used to count the number of cells that contain numeric values, while the Average formula calculates the average of the numeric values in the range.
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. Yes
Explanation It is possible to insert an image from a file into an Excel spreadsheet. This can be done by selecting the cell where the image needs to be inserted, then going to the "Insert" tab, and clicking on the "Pictures" option. From there, the user can browse for the image file on their computer and insert it 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. Yes
Explanation An Excel spreadsheet can indeed be used as the "data source" for a Word Mail Merge. This means that the data in the Excel spreadsheet can be merged into a Word document, allowing for the creation of personalized documents such as letters, labels, or envelopes. The Mail Merge feature in Word allows users to easily combine data from different sources, including Excel, to streamline the process of generating multiple documents with personalized information.
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 border
Explanation The active cell on an Excel sheet is indicated by a dark wide border. This border helps the user identify which cell they are currently working on or editing. It stands out from the other cells and provides a visual cue to the user. The dotted border is not used to indicate the active cell, and neither is a blinking border. Therefore, the correct answer is a dark wide border.
Rate this question:
14.
A Formula and a function are the same thing.
A.
True
B.
False
Correct Answer A. True
Explanation A formula and a function are not the same thing. A formula is a mathematical expression that performs calculations using values, operators, and functions. On the other hand, a function is a predefined formula that performs a specific task and returns a value. Functions can be used within formulas to simplify calculations and automate processes. Therefore, the statement that a formula and a function are the same thing is incorrect.
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, the asterisk symbol (*) is used. This is the standard symbol for multiplication in Excel as well as in most programming languages and mathematical operations. The asterisk represents the multiplication operator and is used to perform calculations involving multiplication of numbers or cells in Excel.
Rate this question:
16.
The formula = ((A2+B5)*5% is valid.
A.
True
B.
False
Correct Answer B. False
Explanation The given formula is not valid because it is missing a closing parenthesis. The correct formula should be = ((A2+B5)*5%) which ensures that all parentheses are properly closed.
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?
Explanation The formula to calculate the average of the given cells is =AVERAGE(A1:A5) or =(A1+A2+A3+A4+A5)/5 or =average(a1:a5) or =(a1+a2+a3+a4+a5)/5. This formula adds up the values in the cells A1 to A5 and then divides the sum by the total number of cells, which is 5 in this case. This will give the average value of the cells.
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?
Explanation 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. All of these formulas will add up the values in the given range and provide the total.
Rate this question:
19.
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".
Correct Answer =IF(E10>74,"PASSED","FAILED")
Explanation The given correct answer is the formula "=IF(E10>74,"PASSED","FAILED")". This formula uses the IF function to check if the value in cell E10 is greater than 74. If it is, the formula returns "PASSED", otherwise it returns "FAILED". This formula is used to determine whether a student has passed or failed based on their remark, where a remark of 75 or higher is considered a pass.
Rate this question:
20.
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".
Correct Answer =IF(A1>74,"PASSED","FAILED")
Explanation The answer provided is an Excel formula that uses the IF function. 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 allows for the automatic determination of whether the remarks should be "PASSED" or "FAILED" based on the value in cell A1.
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.