Скачать или смотреть Illustrated Excel 2019 | Module 9: SAM Project 1b | Taco Gato

Illustrated Excel 2019 | Module 9: SAM Project 1b | Taco Gato #illustratedexcel

If you directly want to get the project from us then contact us on our Whatsapp. Link is given here,

Whatsapp Contact Link:
https://api.whatsapp.com/message/4B6NMKKBK...

Whatsapp Number:
+919116641093
+918005564456

Gmail Id:
[email protected]

We are providing help in all Online Courses, Computer Science, Business and Management, Business Math, Business and Finance, Business and Accounting, Human Resource Management, History, English.

PROJECT STEPS
1. Gabriel Santos owns Taco Gato, a food truck in Fort Worth, Texas. He is using an Excel workbook to track the daily sales of menu items and accept orders for food truck catering at local events. He asks for your help in automating the workbook.
Go to the Weekly Sales worksheet, which lists the food items sold from the Taco Gato truck during the previous week. Add a title to the worksheet as follows:
a. Display the Developer tab on the ribbon, and then run the Week_Title macro to insert a title for the worksheet.
b. Edit cell A1 to add 5/24/21 as the date at the end of the title.
2. Gabriel wants to use a button to insert totals in the range G4:G14, and has already created a macro named Total_Sold that performs this action.
Set up a button to run the macro as follows:
a. Assign the Total_Sold macro to the Total Sold button in row 2.
b. Use the Total Sold button to run the Total_Sold macro.
3. Gabriel likes to keep track of the top four items sold each week and wants to use the Top 4 button to identify them.
Identify the top four items sold by recording a new macro as follows:
a. Use Top as the macro name.
b. Store the macro in This Workbook.
c. With the macro recording, select the range B4:F14.
d. Apply the Top 10 Items conditional formatting rule to the selected range.
e. Use 4 as the number of top values to highlight.
f. Highlight the cells with Green Fill with Dark Green Text.
g. Stop recording the macro.
4. Assign the Top macro to the Top 4 button so that Gabriel can identify the top four values by clicking the button.
5. Gabriel created a macro named Bottom that highlights the bottom 5 percent of values. However, Gabriel wants the macro to highlight the bottom four values to match the new Top macro.
Modify and test the Bottom macro as follows:
a. Open the Bottom macro in the Visual Basic Editor.
b. After the .TopBottom = xlTop10Bottom line of code, change the .Rank = 5 line of code to .Rank = 4 so that the highlighting rule identifies the bottom four values.
c. Change the .Percent = True line of code to .Percent = False so that the highlighting rule selects values rather than a percentage of values.
d. Use the Bottom 4 button to run the Bottom macro and highlight the bottom four items sold for the week.
6. Go to the Catering Orders worksheet, which serves as a form for entering information about catering customers and their events. The worksheet is not finished, and Gabriel asks you to complete it.
In cell C25, enter a formula without using a function that displays the customer's address from the cell named Address (cell B5).
7. Customers can reserve a Taco Gato food truck for one of five durations at a catering event. Add a fifth duration to the Duration section as follows:
a. In cell F9, insert an Option Button (Form Control).
b. Edit the option button text to use the Unlimited to replace the placeholder text.
c. Format the new option button to link it to cell $K$26, if necessary.
d. Position the new option button so that it is aligned with the top of the 3 hours option button to its left.
8. Gabriel asks you to also add a check box to the Menu Items section.
a. In cell C14, insert a Check Box (Form Control).
b. Edit the check box text to use Fish taco to replace the placeholder text.
c. Format the new check box to link it to cell $N$25.
d. Position the Fish taco check box so that its box aligns with the Steak quesadilla box below it and with the Classic nachos box to its left.
9. Gabriel created a macro named ClearForm that clears the form for a new customer request. To make it easy to run the macro, add a button to the form as follows:
a. In cell A10, insert a Button (Form Control).
b. Assign the ClearForm macro to the button.
c. Edit the button to use Clear to replace the placeholder text.
d. Format the new button to change its height to 0.4" and the width to 1.3".
e. Position the Clear button to align with the top and bottom of the Save Form button on its right.