+
Exploring - Excel Chapter 7: Assessment Project 1 Specialized Functions

Exploring - Excel Chapter 7: Assessment Project 1 Specialized Functions

Rating:
Rating
(0)
Author: matthew stock
Description:

http://homework.plus/exploring-excel-chapter-7-assessment-project-1-specialized-functions-1/

Specialized Functions
 
Project Description:
In the following project, you will perform sales analysis, calculate summary data using database functions, and complete an amortization table.
 
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step

Instructions

Points Possible

1

Download and open the file namedexploring_e07_grader_a1.xlsx, and then save the file ase02c1Sales_LastFirst, replacing LastFirst with your name.

0

2

Click the Sales Data by Agent worksheet and enter a nested function in cell H9 the Bonus column. If the employee is international and sold over $200,000 they receive 5% bonus, all other employees receive 3%.

10

3

Using the appropriate cell referencing, copy the function down the column.

7

4

Type Ron in cell B24.

4

5

Type Q1 in cell B25.

4

6

Enter a nested function in cell B26 that uses the cells B24 and B25 to return a specific sales record.

10

7

Click the Individual Awards worksheet and enter conditions in the Criteria Range for international sales reps that made $250,000 or more in sales.

10

8

Perform an advanced filter based on the criteria range. Set the filter to copy the new data into row 22.

10

9

Enter a database function to calculate the total number of international sales rep in cell J8.

12

10

Enter a database function to calculate the highest international sales dollar in cell J9.

3


(more)
See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

25 Sophia partners guarantee credit transfer.

221 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 20 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial