MS Excel Module 5: Quiz!
5 Questions
| Total Attempts: 164
.
Questions and Answers
- 1.Which Excel feature can summarize the data in a large table?
- A.
Data Validation
- B.
Conditional Formatting
- C.
AutoFormat
- D.
Pivot Table
- E.
Hyperlink
- 2.
Names are entered in cells A2:A500, and quantities are entered in cells B2:B500. To calculate the total quantity for the person named "Wilson", I would use the ___________________ worksheet function. - 3.
To create a list of unique items, based on a list that contains many duplicate entries, which Excel feature would you use?
- A.
AutoFilter
- B.
Merge Cells
- C.
Custom Sort
- D.
Data Validation
- E.
Advanced Filter
- 4.
You want to create a drop-down list in a cell so that users can select from a list of products. Which Excel feature should you use?
- A.
Pivot Table
- B.
AutoFormat
- C.
Data Validation
- D.
Insert Comment
- E.
Named Range
- 5.
The sales tax rate is in cell H2. Sales totals are in cells B2:B20. To calculate the tax on each sale, you'll enter a formula in cell C2 to multiply the sales total in B2 by the sales tax rate. Then, you'll copy the formula down to cell B20. Which formula should you use?
- A.
=B2*$H$2
- B.
=$B$2*$H$2
- C.
=B$2*$H$2
- D.
=B2*H2
- E.
=B2*$H2
Questions: 22 | Attempts: 7481 | Last updated: Mar 22, 2022
-
Sample QuestionWhich 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?
Microsoft Excel is a spreadsheet software program provided by Microsoft Office suite, used for creating spreadsheets in the form of rows and columns like a big table. It is the most popular program used since 1985 for...
Questions: 10 | Attempts: 4499 | Last updated: Mar 22, 2022
-
Sample QuestionHow do you spell check an Excel worksheet?
A Data Analyst is skilled enough to translate numbers into comprehensible words and meanings of business data, sales and logistics. He collects the data and information and uses it to promote a company or help it make a...
Questions: 10 | Attempts: 3584 | Last updated: Mar 22, 2022
-
Sample QuestionWhat add-in program serves as the data analyzing tool in Excel?
Back to top