Question details

EXP ECH09 H2 - Pharmaceutical Sales Accountant 1.1
$ 20.00

EXP ECH09 H2 - Pharmaceutical Sales Accountant 1.1

 

Project Description:

You are an accountant for a pharmaceutical sales company. As part of your tasks, you compile an annual report that documents regional sales information into one standardized worksheet. As part of this process, you group the worksheets and insert descriptive rows and columns, apply formatting, and insert functions. Your last step is to create a sales summary worksheet and provide basic information for management to evaluate.

 

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

Step

Instructions

Points Possible

1

Open the downloaded workbook named exploring_e09_grader_h2_Sales.xlsx and save it as exploring_e09_grader_h2_Sales_LastFirst.

0

2

Group the five regional worksheets (not including the Summary worksheet). Insert a new row above row 1 of the existing data. Type Agent in cell A1 and apply the Heading 2 cell style to the cell.

11

3

With the worksheets still grouped, type Qtr1 in cell B1. Use the fill handle to add Qtr2-Qtr4 in cells C1:E1. Apply Heading 3 format to cells B1:E1.

12

4

With the worksheets still grouped, type Total in cell F1. In cell F2, enter the following function: =SUM(B2:E2). Use the fill handle to complete the summary information for the rest of column F, down to cell F19.

12

5

With the worksheets still grouped, type Total in cell A20. In cell B20, insert a function to total Qtr1 sales. Copy the function to the range C20:F20.

12

6

With the worksheets still grouped, format cells B2:F20 with the Accounting Number Format. Set the column width for the range B1:F20 to 20.

12

7

With the worksheets still grouped, apply Heading 2 style to cell F1. Add Top and Double Bottom Borders to cells B20:F20.

11

8

Ungroup the worksheets, click the Summary worksheet tab, and then apply Accounting Number Format to cells B2:E6.

8

9

Select cells F2:F6 and press ALT+= to add totals to column F. Set the column width to 18.

12

10

Apply 3 Flags Indicator Icon Set conditional formatting to F2:F6

10

11

Save the workbook. Ensure that the following worksheets are present (in this order): North Region, East Region, South Region, MidWest Region, West Region, Summary, and Q&A. Close the workbook, and then submit the file as directed.

0

 

Total Points

100

 

 

Available solutions