1 A list containing customer and customer purchase informati

1. A list containing customer and customer purchase information has the following columns: customer name, location (of the customer, i.e., North, South, East, and West), customer income, customer age, and mode of payment during last purchase (cash or card). A pivot table to find the number of customers in each location and containing age, income, and purchase information of customers needs to be created. Where must the \"location\" field be dropped in the pivot table skeletal structure to create such a table?

A. Report Field

B. Column Labels

C. Row Labels

D. \"Values\" area

2.If you wanted customers who earned an annual income of less than $25,000 to appear in red, what spreadsheet feature would you use?

A. Data ordering

B. Goal Seeking

C. Data validation

D. Conditional formatting

3. A company uses Excel to maintain a list of its customers. It maintains details of customer name, id, age, and region of residence (East, West, North, and South). If a manager wants a list of only those customers living in the North, which of the following functions of Excel can the manager use?

A. Basic Filter

B. Custom Filter

C. Goal Seek

D. Conditional formatting

4. Using spreadsheet software, a company creates a list of its customers with the following columns: customer\'s date of birth, customer location, and date of latest purchase. If the company needs to find the exact number of individuals to whom birthday wishes would need to be sent on a particular day, which function should it use?

A. Basic Filter

B. Custom Filter

C. Pivot table

D. Goal Seek

5. If you were searching for a particular customer in a list and you knew, for instance, the state the customer lived in, what spreadsheet feature should you use?

A. Goal Seeking

B. Filter

C. Sorting

D. Pivot Table

Solution

Solution:

1. C- Rowlable

Location is a non numeric field so it is dropped in row label

2. D- Conditional formatting

The salary condition is given

3. D-Conditional formatting

Location condition is given

4. C-pivot table

Pivot table is used to analyze the data easily

5.A- goal seeking

Here we know the customer list, where they lived. so goal seeking gives best result