[SOLVED]>>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


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 Qtr2Qtr4 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

 



This essay is written by:

Prof. SirMojo Verified writer

Finished papers: 435

Proficient in:

English, History, Business and Entrepreneurship, Nursing, Psychology, Management

You can get writing help to write an essay on these topics
100% plagiarism-free

Hire This Writer
© 2017 theacademicessays. All Rights Reserved. Design & Developed by theacademicessays.
How to Avoid Plagiarism
  • Use multiple resourses when assembling your essay
  • Use Plagiarism Checker to double check your essay
  • Get help from professional writers when not sure you can do it yourself
  • Do not copy and paste free to download essays
Get plagiarism free essay
Loading...