HW 10 Excel Chapter 5 Aspen Falls , accounting homework help

User Generated

pnzwnz

Business Finance

Description

Need help with excel hw

Unformatted Attachment Preview

Office 2013 – myitlab:grader – Instructions Excel Project SKL ECH05 H2 - Aspen Falls 1.1 Project Description: In this project, you will format a worksheet for the Aspen Falls Department of Tourism. In the worksheet, you will create custom number formats, cell styles, worksheet themes, change background fill colors, and apply borders. Additionally, you will apply conditional formatting to a range of cells, and use the Format Painter to copy formatting. Finally, you will insert header and footer elements, and modify the display of the worksheet. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step 1 2 Points Possible Instructions Start Excel 2013, and then download, open, and save the file exl05_grader_h2.xlsx. 0 Select the range D5:D16. Create a custom number format that will display the value as a dollar sign followed by a digit, a comma, and then two-digit number with zero decimal places. Use the Format Painter to copy the format from cell to G5:G21. 9 Hint: On the HOME tab, in the Number group, click the Number Dialog Box Launcher, and then click Custom. 3 Select the cell B4. Use the Format Painter to copy the format to C4:G4. 9 4 Select cell A17. Insert a cell to move the cells to the right, and then insert a row above row 17. 12 5 Select the range B4:G16. Use the Font group to apply the fill color Green, Accent 6, Lighter 80%. Apply the Thick Box Border with a border color of Green, Accent 6, Darker 50%, and a thin inside border with the color Green, Accent 6. 12.5 6 7 8 9 Select the range C5:C15. Apply the 4 Arrows (Colored) Icon Sets Style. 12 Apply conditional formatting in the cell range G5:G15 so the cell will be formatted Bold with the font color Blue, Accent 5 if the value in the cell is greater $30. Select cell A1. In the Cell Styles group, create a new Cell Style using the name Vintage Style. Change the number format to Text; change the horizontal alignment to Center Across Selection; vertical alignment to Center; change the font to Arial; apply Bold formatting; change the font size to 14; and change the fill color to Green, Accent 6, Darker 50%. Apply the Cell Style, Vintage Style to the range B1:G2. Select the range B18:G22. Apply the Green, Accent 6, Lighter 80% fill color, and a Thick box border color Green, Accent 6, Darker 50%. Select B20:G20. Apply a thin line Green, Accent 6, Darker 50% top and bottom border, and a Green, Accent 6, Lighter 40% fill color. Apply the same fill color to B16:G16 and B22:G22. Updated: 02/13/2015 1 12.5 0 0 Current_Instruction.docx Office 2013 – myitlab:grader – Instructions Step Excel Project Points Possible Instructions 10 In the Themes group, create a Custom Font using the name Vintage Fonts. Change the body font to Arial. 12.5 11 Download, save, and insert exl05_grader_h2_Logo.jpg in the left section of the worksheet footer. Insert the file name element in the right section of the worksheet footer. 12.5 12 13 Change the sheet options to hide the worksheet gridlines and row and column headings. Save the workbook, close the workbook window, and then submit the workbook as directed. Total Points Updated: 02/13/2015 2 9 0 101 Current_Instruction.docx Aspen Falls 2014 Vintage Car Show Fees Car Clubs National Capitol Club Bay Club Capitol Rockets Fast Guys Club Roaring Engines Eastern Fast Cars Northwest Flyers Southern Screamers Rip Roaring Classics Hot Rod Trucks Fast Lane Ladies Total $40 Spectators Total Earnings No. of Cars Fees Vendors Spaces Fees 21 840 Flea Tea 1 15 600 Perkins Popcorn 2 23 920 Candy Shack 1 42 1680 Thirst Quencher 1 24 960 Pop &Pizza 3 16 640 Hotty Dogs Plus 2 32 1280 Car Memorabilia 1 9 360 Stylish Shirts 2 46 1840 Tracy's Treasures 1 38 1520 Art's Auto 3 28 1120 Custom Interiors 2 294 11760 19 $30 673 $5 30 60 30 30 90 60 30 60 30 90 60 570 3365 15695
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

This question has not been answered.

Create a free account to get help with this and any other question!

Related Tags