Excel_6F_Event_Budget_Instructions

.docx

School

Seneca College *

*We aren’t endorsed by this school

Course

ADMN4896

Subject

Accounting

Date

Jun 21, 2024

Type

docx

Pages

2

Uploaded by CountTurkey2826

Grader - Instructions Excel 2022 Project Excel_6F_Event_Budget Project Description: In this Project, you will create a budget template for Job Fair events. Then you will create a worksheet based on the budget template for review by Milton Hyken, Dallas Job Fair Director. Steps to Perform: Step Instructions Points Possible 1 Open the Excel file Student_Excel_6F_Event_Budget.xlsx downloaded with this project. 0 2 In cell B16, type Item and press TAB. In cell C16, type Description In cell D16, type Actual In cell E16, type Budget In cell F16, type Variance In cell C26, type Totals 10 3 To the ranges C8:C12 and B16:F16, apply Bold. To the range C8:C12, apply Align Right. To the range D8:D12, apply Align Left. Select columns B:F, display the Column Width dialog box, and then set the width of columns B:F to 15 12 4 To construct a formula to compute the Variance (Variance = Actual – Budget) for each budget item, in cell F17, type =d17-e17 and copy the formula down through cell F25. 8 5 In the range D26:F26, insert appropriate formulas to sum these columns. To the range D18:F25, apply Comma Style. To the ranges D17:F17 and D26:F26, apply Accounting Number Format. Remember that you are creating a template, so there is no data entered yet. 13 6 Navigate to cell E1, insert the picture e06F_Logo.jpg . Select the range A16:A26, and then apply Merge & Center. Change the Orientation to Rotate Text Up, type Event Budget and press ENTER. Select the merged cell, apply Middle Align, apply Bold, and change the Font Size to 24. 12 7 To the merged cell, apply a Fill Color—in the fifth column, select the second color. 5 8 Select the ranges D8:D12 and B17:E25. Remove the Locked formatting from the selected cells, and then protect the worksheet. Be sure the check box at the top and the first two check boxes in the list are selected, and as the password, type goseries 10 9 Display the Page Setup dialog box, insert a footer in the left section with the file name, and center the worksheet horizontally on the page. Display the Save As dialog box. Change the Save as type to Excel 4 Created On: 08/10/2022 1 GO22_XL_CH06_GRADER_6F_HW - Event Budget 1.1
Grader - Instructions Excel 2022 Project Step Instructions Points Possible Template. Navigate to your Excel Chapter 6 folder, and then using your own name, save the file as Lastname_Firstname_6F_Event_Budget_Template 10 To create a new budget report using the template as your model, display the Save As dialog box again, navigate to your Excel Chapter 6 folder, change the Save as type to Excel Workbook, and then using your own name, save the file as Lastname_Firstname_6F_Dallas_Budget This is the workbook you will submit for grading. In the new workbook, enter the following data in column D: Event Date: October 22, 2024 Event Location: Dallas Address: 288 Alba Drive City, State, ZIP: Dallas, TX 75210 Phone: 214.555.6575 10 11 Beginning in cell B17, complete the order by entering the following items: Item Description Actual Budget Venue Hall rental fee 7200 7000 Personnel Site staff 500 600 Equipment Computers 400 400 Publicity Signage 725 850 Speakers Speaking fee 1750 2000 14 12 Display the document properties. Be sure your name displays in the Author box. As the Subject, type your course name and section number. As the Tags, type Dallas, event budget Check the Print Preview to be sure the file name updated and displays in the left section of the footer. On the left, select Save. 2 13 Close the file, and then submit this file for grading. You do not need to submit your template file. 0 Total Points 100 Created On: 08/10/2022 2 GO22_XL_CH06_GRADER_6F_HW - Event Budget 1.1
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help