Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Use autofill to copy the formula and formatting

10/11/2021 Client: muhammad11 Deadline: 2 Day

Exp19_Excel_Ch09_ML2_Pizza_Sales_Instructions.docx
Grader - Instructions Excel 2019 Project

Exp19_Excel_Ch09_ML2_Pizza_Sales
Project Description:
You manage a chain of pizza restaurants in Augusta, Lewiston, and Portland, Maine. Each store manager created a workbook containing the quarterly sales for each type of sale (dine-in, carryout, and delivery). You want to create links to a summary workbook for the yearly totals.

Steps to Perform:
Step

Instructions

Points Possible

1

Start Excel. Download and open the file named Exp19_Excel_Ch09_ML2_Pizza.xlsx. Grader has automatically added your last name to the beginning of the filename.

0

2

You want to enter totals from the Augusta workbook into the Pizza workbook. Display the Augusta worksheet; in cell B4, insert a link to the Dine-In total in cell F4 in the Exp19_Excel_Ch09_ML2_Augusta workbook. Edit the formula to make the cell reference relative.

5

3

You want to copy the formula down the column but preserve the original formatting. Use AutoFill to copy the formula from cell B4 to the range B5:B7 in the Augusta worksheet. Close the Augusta workbook; keep the Pizza workbook open.

6

4

You want to enter totals from the Portland workbook into the Pizza workbook. Display the Portland worksheet; in cell B4 insert a link to the Dine-In total in cell F4 in the Exp19_Excel_Ch09_ML2_Portland workbook. Edit the formula to make the cell reference relative.

5

5

You want to copy the formula down the column but preserve the original formatting. Use AutoFill to copy the formula from cell B4 to the range B5:B7 in the Portland worksheet. Close the Portland workbook; keep the Pizza workbook open.

6

6

You want to enter totals from the Lewiston workbook into the Pizza workbook. Display the Lewiston worksheet; in cell B4 insert a link to the Dine-In total in cell F4 in the Exp19_Excel_Ch09_ML2_Lewiston workbook. Edit the formula to make the cell reference relative.

5

7

You want to copy the formula down the column but preserve the original formatting. Use AutoFill to copy the formula from cell B4 to the range B5:B7 in the Lewiston worksheet. Close the Lewiston workbook; keep the Pizza workbook open.

6

8

The Summary sheet should contain the same formatting as the other sheets. Select the range A1:B7 in the Lewiston worksheet. Group the Lewiston and Summary worksheets. Fill formatting only across the grouped worksheets.

5

9

Ungroup the worksheets and change the width of column B to 16 in the Summary worksheet.

2

10

You are ready to insert functions with 3-D references in the Summary worksheet. In cell B4, insert a SUM function that calculates the total Dine-In sales for the three cities.

5

11

Copy the formula in cell B4 and use the Paste Formulas option in the range B5:B7 to preserve the formatting.

5

12

You are ready to display the Contents worksheet and insert hyperlinks. • Insert a hyperlink in cell A3 that links to cell B7 in the Augusta sheet. Include the ScreenTip text: Augusta total sales (no period). • Insert a hyperlink in cell A4 that links to cell B7 in the Portland sheet. Include the ScreenTip text: Portland total sales (no period). • Insert a hyperlink in cell A5 that links to cell B7 in the Lewiston sheet. Include the ScreenTip text: Lewiston total sales (no period). • Insert a hyperlink in cell A6 that links to cell B7 in the Summary sheet. Include the ScreenTip text: Total sales for all locations (no period).

10

13

You want to create a data validation rule. Select the range B3:B5 on the Future worksheet and add the following data validation rule: • Allow Date between 3/1/2021 and 10/1/2021. • Enter the input message title: Proposed Date (no period). • Enter the input message: Enter the proposed opening date for this location. (including the period). • Select the Information error alert style. • Enter the error alert title: Confirm Date (no period). • Enter the error message: Confirm the date with the VP. (including the period).

13

14

You should test the validation rule to ensure it works correctly. Enter 10/5/2021 in cell B5 and click OK in the Confirm Date message box.

3

15

You want to unlock a range on the Future worksheet to enable changes by users. Unlock the range B3:B5.

6

16

Now that the cells are unlocked, you are ready to protect the Future worksheet. Protect the worksheet without a password and using the default settings.

6

17

Hide the Future worksheet.

6

18

Create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side of the five visible worksheets.

6

19

Mark the workbook as final. Note: Mark as Final is not available in Excel for Mac. Instead, use Always Open Read-Only on the Review tab.

0

20

Save and close Exp19_Excel_Ch09_ML2_Pizza.xlsx. Exit Excel. Submit the file as directed.

0

Total Points

100

Created On: 09/03/2020 1 Exp19_Excel_Ch09_ML2 - Pizza Sales 1.1

Amy_Exp19_Excel_Ch09_ML2_Pizza.xlsx
Contents
Pizza Workbook
Augusta
Portland
Lewiston
Summary
Augusta
Augusta
Category Total
Dine-In
Pick-up
Delivery
Total
Portland
Portland
Category Total
Dine-In
Pick-up
Delivery
Total
Lewiston
Lewiston
Category Total
Dine-In
Pick-up
Delivery
Total
Summary
Regional Totals
Category Total
Dine-In
Pick-up
Delivery
Total
Future
Plans for New Locations
Eugene 5/1/2021
Salem 7/1/2021
Hillsboro 9/1/2021
Exp19_Excel_Ch09_ML2_Portland.xlsx
Portland
Portland Location
Category 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total
Dine-In $ 45,000 $ 41,000 $ 38,000 $ 33,000 $ 157,000
Pick-up $ 19,000 $ 21,000 $ 20,000 $ 20,000 $ 80,000
Delivery $ 25,000 $ 35,000 $ 45,000 $ 55,000 $ 160,000
Total $ 89,000 $ 97,000 $ 103,000 $ 108,000 $ 397,000
&A &F

Exp19_Excel_Ch09_ML2_Lewiston.xlsx
Lewiston
Lewiston Location
Category 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total
Dine-In $ 12,000 $ 10,000 $ 8,000 $ 6,000 $ 36,000
Pick-up $ 27,000 $ 26,000 $ 26,000 $ 26,000 $ 105,000
Delivery $ 25,000 $ 34,000 $ 46,000 $ 60,000 $ 165,000
Total $ 64,000 $ 70,000 $ 80,000 $ 92,000 $ 306,000
&A &F

Exp19_Excel_Ch09_ML2_Augusta.xlsx
Augusta
Augusta Location
Category 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total
Dine-In $ 40,000 $ 34,000 $ 29,000 $ 22,000 $ 125,000
Pick-up $ 62,000 $ 63,000 $ 62,000 $ 63,000 $ 250,000
Delivery $ 22,000 $ 26,000 $ 35,000 $ 42,000 $ 125,000
Total $ 124,000 $ 123,000 $ 126,000 $ 127,000 $ 500,000
&A &F

Exp19_Excel_Ch09_ML2_Pizza_final_result.jpg

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Write My Coursework
Professional Coursework Help
Online Assignment Help
Top Writing Guru
Essay & Assignment Help
Top Grade Essay
Writer Writer Name Offer Chat
Write My Coursework

ONLINE

Write My Coursework

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$46 Chat With Writer
Professional Coursework Help

ONLINE

Professional Coursework Help

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

$16 Chat With Writer
Online Assignment Help

ONLINE

Online Assignment Help

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

$36 Chat With Writer
Top Writing Guru

ONLINE

Top Writing Guru

I find your project quite stimulating and related to my profession. I can surely contribute you with your project.

$45 Chat With Writer
Essay & Assignment Help

ONLINE

Essay & Assignment Help

Being a Ph.D. in the Business field, I have been doing academic writing for the past 7 years and have a good command over writing research papers, essay, dissertations and all kinds of academic writing and proofreading.

$50 Chat With Writer
Top Grade Essay

ONLINE

Top Grade Essay

I will provide you with the well organized and well research papers from different primary and secondary sources will write the content that will support your points.

$42 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Culture Drives Behavior Discussion - Assignment 13 - Fundamentals of human resource management 7th edition pdf free download - Scotty doesn't know guitar tab - Tamiu course descriptions - Nouns verbs adjectives adverbs - Epidemiology for public health practice 5th edition test bank - All things great and beautiful - Pan handle realty llc v olins - Was king tut murdered national geographic - German ersatz bayonet for sale - Tube bundle cleaning equipment - Discussion 1 250 words by 08/18/20 at 6:00 pm please add references and citations - Factorise x 5 x 4 1 - Unit 1 Assignment - Bsc final year project - Change in net operating working capital formula - Worlds apart a series on cross cultural health care - design Boost Converter according to the specification. - Customer satisfaction in hotel industry ppt - Stock splits are issued primarily to - Submission file format: Word document with all the answers, clearly identifying all steps, results, and including comments besides each answer. - Human growth and development - You have been hired to design a family friendly seesaw derive an expression - Boss judith think 4th ed mcgraw hill 2017 - The virtual evolution stickleback lab answers - Vue cheat sheet 3 - Independent study - Reflection on Child Development - William and mary mental health - Java slot machine assignment - Triangle shirtwaist fire essay outline - The angle sum of a triangle - Coca cola mission and values - Bobby caldwell las vegas tickets chrome showroom february 15 - Vacation villas at fantasyworld owners - Writing observations in childcare examples - Classroom Management - Sugarloaf reservoir fish stocking - Several years ago the jakob company - Medication - Informatics in healthcare - Jabulani)][@DURBAN HAPPY CLINIC +27835179056 SAFE ABORTION CLINIC//PILLS Tembisa,Soweto,Johannesburg, Pretoria, Germiston MIDRAND BIZANA - Appearance vs reality macbeth - Infinitivo seguir (1) yo (2) morí tú seguiste (3) nosotras seguimos (4) ellos (5) murieron - Satya nadella at microsoft instilling a growth mindset - Electric arc bearing damage - The corporate controller's salary would be considered - Inf 103 week 2 assignment - Nu5002s - Social work role play scenarios - The financial detective 2016 case study solution - Characteristics of full service schools - Mlc masterkey super performance - Significance of dante's inferno in prufrock - Data entry screen design examples - Change agent in nursing - Minimum standards practice test - Beseech definition romeo and juliet - Database security - What is the quotient in simplified form? state any restrictions on the variable. show work. - 8500: Discussion 2-2 - The beatles eleanor rigby meaning - You are going to be assessed for: Your skills and knowledge using written and observation activities that apply to the workplace. Your ability to apply your learning. - Latitude and longitude worksheets - Return and Risk - Europa foods london - Purpose of the assessment (with ULO Mapping) - Dibels oral reading fluency benchmarks - 100 pair copper cable - Assignment on marketing plan for a new product ppt - English composition - Grain auger flex spouts - Fitness fanatics is a regional chain of health - Alpha chiang fundamental methods of mathematical economics - SOCW 6090 Week 3 - Discussion: Assessing Suicide Risk - Kimmel center promotional code beauty and the beast - Pedigree analysis answer key - Aws pci dss compliance - Ravensworth terrace primary school - Council clean up liverpool - Ottobock c-leg 4 manual - The other side is not dumb summary - Katch mcardle formula tdee - Workers performing similar work are paid more in some industries than others. Explain why this is so. - Characteristics of an agile mis infrastructure - Kramer and knox began a partnership by investing - 4 5 minute speeches - 87 1/2 percent as a fraction - Attention retention reproduction motivation - Finance and Operations - Sample business plan for a food truck - List of doctors at sir charles gairdner hospital - Case study Outline - 14 silver lake road mylor - Assignment probation - Searle v wallbank 1947 ac 341 - Villa mella restaurant elizabeth nj - Nursing leadership practicum objectives examples - MLK