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?
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
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 Question
What add-in program serves as the data analyzing tool in Excel?