Question: Setup the spreadsheet with proper formatting and formulas so it can be presented to management. a. Create a new worksheet titled - Ql - 2016

Setup the spreadsheet with proper formatting and formulas so it can be presented to management. a. Create a new worksheet titled - "Ql - 2016 Quarterly Sales" and copy the data from the "Main" worksheet onto the sheet. b. Add a column to calculate the total for each product. Use the SUM function. C. Add rows to calculate the Total, Average and Median sales for each quarter. Use the SUM, AVG, and MEDIAN functions. d. Format the title at the top so it stands out. Add distinct formatting to the column and row headings. Format the data in the cells to show currency

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Read the brief case below. Using the Excel spreadsheet provided, complete the questions. Downtown Office Supply Downtown Office supply is a small family owned store in a small suburb. In order to...

Assignment: Excel (75 points) Read the brief case below. Using the Excel spreadsheet provided, complete the questions. Downtown Office Supply Downtown Office supply is a small family owned store in a...

Coffee Company Quarterly Product Sales 2014 Product Name Q1 Q2 Q3 Q4 Total Chai tea 705.6 878.4 1174.5 2128.5 Dark roast special blend 2720.8 228 2061.5 2028.25 Light roast decaf 590.4 360 1100.7...

Read the brief case above. Using the Excel spreadsheet provided, develop your spreadsheet and complete the questions. Steams Coffee Steams coffee is a leading vendor or coffee and tea beverages...

Steams coffee is a leading vendor or coffee and tea beverages across the Southwest region of the United States. As part of their business expansion initiatives, they opened new stores in the State of...

business the owners want to do some analysis to see how their sales are doing. Management wants to see how the company did last year and make some decisions about what products to keep along with...

Read the brief case below. Using the Excel spreadsheet provided, complete the questions. Setup the spreadsheet with proper formatting and formulas so it can be presented to management. Change the tab...

Downtown Office Supply Downtown Office supply is a small family owned store in a small suburb. In order to maintain and grow the business the owners want to do some analysis to see how their sales...

The owners want to do some analysis to see how their sales are doing. Management wants to see how the company did last year and make some decisions about what products to keep along with staffing for...

When both ovaries are removed from rat then which hormone is decreased in blood? (A) Oxytocin (B) Prolactin (C) Estrogen (D) Gonadotropin releasing factor.

The 7/8-in.-diameter pins at A and C that support the structure are in single shear. Find the largest force F that can be applied to the structure if the working shear stress for these pins is 5000...

Which financial Incentive pary plan imolves companies paying employees for ofleing ideas on how to cat conds or improve quality? Mancle Choke profit shaving papments for toggestions egrobuction toine...

Explain how the following software protections protect against cyber attacks. Updates anti malware protection Anti virus protection