QuickHelper

(10)

$20/per page/

About QuickHelper

Levels Tought:
Elementary,High School,College,University,PHD

Expertise:
Accounting,Applied Sciences See all
Accounting,Applied Sciences,Business & Finance,Chemistry,Engineering,Health & Medical Hide all
Teaching Since: May 2017
Last Sign in: 353 Weeks Ago, 2 Days Ago
Questions Answered: 20103
Tutorials Posted: 20155

Education

  • MBA, PHD
    Phoniex
    Jul-2007 - Jun-2012

Experience

  • Corportae Manager
    ChevronTexaco Corporation
    Feb-2009 - Nov-2016

Category > Business & Finance Posted 08 Jun 2017 My Price 15.00

i need help with excel creating formulas

Question description

 

 

Fernwood Art Center Adult Classes

 

Project Description:

In this project, you will create a spreadsheet detailing the list of adult classes offered by the Fernwood Art Center for Session 2. You will calculate the cost of each class for those with a member discount. Additionally, you will create a formula to summarize the total fees collected for each class during the first session of the season. Finally, you will format the worksheet spreadsheet to make it visually appealing.

Instructions:

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

Step

Instructions

Points Possible

1

Start Excel. Download and open the workbook named exploring_e01_grader_a1.xlsx.

0

2

Set a width of 25 for column A.

4

3

Center horizontally the labels in the range A8:G8 and then apply wrap text to the labels in the range A8:G8.

6

4

Merge and center the label Total Fees Collected in the range H7:H8. Wrap text for the label in its merged cell.

6

5

In cell E9, enter a formula that calculates the Session Fee for a Member. Members receive a Member Discount off the Non-Member Session Fee. Copy the formula from cell E9 down through row 12.

15

6

In cell H9, create a formula that will calculate the total fees collected for the Introduction to Watercolor class. Copy the formula from cell H9 down through row 12.

15

7

Change the value in cell  D11 to 280. Insert a row below row 9. Enter Basic Drawing in cell A10, 4 in cell B10, 50% in cell C10, 275in cell D10, 10 in cell F10, and 4 in cell G10. Be sure the formulas in columns E and H are copied to the new row.

10

8

Apply Percent Style to the Member Discount values in column C. Center horizontally the Member Discount percentages in column C.

4

9

Apply Accounting Number Style to the Non-Member fees in column D, the Member fees in column E, and the Total Fees Collected in column H.

8

10

Set the Outside Borders around the range A7:H13.

4

11

Apply Green, Accent 6, Darker 50% fill color and White, Background 1 font color to the Total Fees Collected label.

8

12

Change the page setup options so that the data is centered horizontally on the page.

3

13

Change the orientation to Landscape.

3

14

Create a footer that displays the text Art Center Classes in the left section and insert the sheet name code in the right section of the footer area.

6

15

Copy the Session 2 worksheet, move it to the end, and rename it as Copy.

4

16

Display the settings to print gridlines and headings.

4

17

Ensure that the worksheets are correctly named and placed in the following order in the workbook: Session2, Copy. Save the workbook. Close the workbook, and then exit Excel. Submit the workbook as directed.

0
 

Total Points

100

                                                                                                                       

Answers

QuickHelper
(10)
Status NEW Posted 08 Jun 2017 08:06 PM My Price 15.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k Y-----------ou -----------for----------- us-----------ing----------- ou-----------r w-----------ebs-----------ite----------- an-----------d a-----------cqu-----------isi-----------tio-----------n o-----------f m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l

Not Rated(0)