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

Excel chapter 9

18/03/2021 Client: saad24vbs 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

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:

Calculation Master
ECFX Market
Top Class Engineers
24/7 Assignment Help
Finance Professor
Coursework Helper
Writer Writer Name Offer Chat
Calculation Master

ONLINE

Calculation Master

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$66 Chat With Writer
ECFX Market

ONLINE

ECFX Market

I have read your project details. I can do this within your deadline.

$80 Chat With Writer
Top Class Engineers

ONLINE

Top Class Engineers

I have read your project details. I can do this within your deadline.

$26 Chat With Writer
24/7 Assignment Help

ONLINE

24/7 Assignment Help

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$65 Chat With Writer
Finance Professor

ONLINE

Finance Professor

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$90 Chat With Writer
Coursework Helper

ONLINE

Coursework Helper

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$89 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

Visualizing and communicating in Excel - Course Project Overview - Stakeholder register and Communications Management table - Preparation of isoamyl acetate - Examples of chemical weathering in everyday life - Epping animal welfare facility epping vic 3076 - Ain t nobody peeking but the stars above - The middle ages timeline - The lymphatic system and immune response review sheet - Henry ossawa tanner's the banjo lesson creates emphasis through - Why is being organised important - How to linearize sine function - Test bias and test fairness - See below - JOURNAL - What human characteristic is thematized in the excerpt? - Use pareto analysis to investigate the following data - According to piaget accommodation occurs when individuals - Kwun tong post office - Dissertation on IoT - Minutes to decimal converter - Fixing scored cam journals - Pwc internship recruitment process - Health administration 5 - Gopro case analysis - Valleylab force triad service manual - What is a bronsted lowry base example - Nursing Concepts Of Teaching & Learning Discussion W5 - Right boss wrong company case study answers - Folk song philippine literature - Information system development life cycle ppt - Two objects attract each other with a gravitational force of - Disloyalty, greed, mercilessness, prejudice, and intolerance are examples of: - The crucible and the dressmaker sample essay - Holiday travel vehicles class diagram - Eassy(550 Words) APA format - 3 references - Paddle pop begins 2 full movie - 2-3 page assignment - Gantt chart visual paradigm - Australian standards for tiling - Cloud computing 5 - Discussion 1 - I am hiring writing team for the subjects of business, management , marketing, finance, HR - Dampening paper for printmaking - What is the technology acceptance model - Tell tale heart pdf - Altium print all schematic pages - Uclu rights and advice - Week 8 Discussion - Computer gateway device crossword clue - United church of god sabbath - Product life cycle powerpoint presentation - MBA630 Application Assignment 1 - Listed below are costs found in various organizations - Sacred mexican kitchen mernda - Paper on Cambodian - Art appreciation discussion questions - 50x tae buffer sigma - Compare and contrast across two cultures - Northouse pg 2016 leadership theory and practice 7th ed - Youth living away from home allowance - Harrys pizza port pirie - How to find the lowest common denominator - Adapted physical education checklist - Similarity transformation state space - Is an oxymoron a literary device - Spss output to word - Acid base titration curve lab report answers - Nakshatras and their lords - Draw network diagram in word - Waste water management mauritius - Project for 6 week - Hills like white elephants citation mla - Bond length of hcl - Current Event - Totalitarian Restrictions or Ethnic Conflict - Waiting for godot upheaval - The adventure of the speckled band conflict - Wshfc home advantage guidelines - Box and whisker plot applet - Brian foster chest pain shadow health - Algebra of events probability ppt - Brick cavity wall thickness - Measurement and Data Collection 8381 - Emotional intelligence in labor and delivery case study - A 1.20 kg piece of cheese is placed - Bus 475 week 2 quiz - The blind side football game scene - Aging the individual and society 9th edition pdf - Darren r lebl md reviews - Fairy in the tempest crossword clue - Early childhood education assignment help - Discussion-8 MM - Organizational behavior book pdf free download - Qut wil placement agreement - Checking out me history analysis - Week Assignments - Soc - What is transformer coupled amplifier - Myprogramminglab answers java chapter 2 - The calorie lab - Lutron wiring diagram uk