# MS Excel Basics Trivia Quiz: Practice Test!

Approved & Edited by ProProfs Editorial Team
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.
| By Bret Carpenter
B
Bret Carpenter
Community Contributor
Quizzes Created: 1 | Total Attempts: 616
Questions: 18 | Attempts: 617

Settings

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.

• 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.

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.

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.

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

A. True
Explanation
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.

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

B. False
Explanation
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

B. SHIFT
Explanation
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

B. False
Explanation
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

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

C. Sum
Explanation
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

A. Yes
Explanation
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

A. Yes
Explanation
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.

• D.

None of the above

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 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

A. True
Explanation
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.

#

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

B. False
Explanation
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?

=AVERAGE(A1:A5), =(A1+A2+A3+A4+A5)/5, =average(a1:a5), =(a1+a2+a3+a4+a5)/5
Explanation
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?

=SUM(A1:A5), =A1+A2+A3+A4+A5, =sum(a1:a5), =a1+a2+a3+a4+a5
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. These formulas will add up the values in the given range of cells and give the total.

Rate this question:

Related Topics