![]() ![]() Copy the two formulas down through the remaining customers.Service Charge (cell F4) = 3.25% * (Beginning Balance – Payments – Credits)New Balance (G4) = Beginning Balance + Purchases – Credits – Payments + Service ChargeDetermine the totals in row 11 using the SUM Function.Determine the maximum, minimum, and average values in cells B12: B14 for the range B4: B10, and then copy the range B12: B14 to C12: G14.Format the numbers as follows:Assign the Currency style to the cells containing numeric data in the ranges B4: G4 and B11: G14.Assign a Comma style to the range B5: G10.Use conditional formatting to change the formatting to a light red fill with a dark red text in any cell in the range F4: F10 that contains a value greater than 10.Change the worksheet name from Sheet1 to Accounts Receivable and the sheet tab color to a red color. Change the font size in the range A3: G14 to 12 points.Build the following formula(s) to determine the service charge in column F and the new balance in column G for the first customer. Use it for this assignment.Format the worksheet as described in the following instructions:Change the theme of the worksheet (Page Layout | Theme).Apply the Title cell style to cells A1 and A2.Change the font size in cell A1 to 28 points.Merge and center the worksheet title and subtitle across columns A through G.Change the background color of cells A1 and A2 to a red color.Change the font color of cells A1 and A2 to a theme color.Draw a thick box border around the range A1: A2.Change the width and heightsChange the width of column A to 20.00 points.Change the widths of columns B through G to 12.00 points.Change the heights of row 1 and 2 to 30 and row 3 to 36.00 points and row 12 to 30.00 points.Format the column titlesFormat the column titles in row 3 and row titles in the range A11: A14, as shown in the finished worksheet above (Hint: Use Alt+Enter to wrap text).Center and Middle Align the column titles in the range A3: G3.Apply the Heading 3 cell style to the range A3: G3.Apply the Currency and Total cell styles to the range A11: G11.Bold the titles in the range A12: A14. The customer data in Table 1 (below) is available for test purposes.Instructions Part 1:Aficionado Guitar Parts balance reportPerform the following tasks:Download the Unit 2 Data File. You have been asked to use Excel to create formulas and functions in order to generate a report that summarizes the monthly accounts receivable balance (see below). p-ccj4284Formulas, Functions and FormattingOutcomes addressed in this activity:Unit Outcomes addressed in this unit:Properly use the built-in functions of SUM, AVERAGE, MAXIMUM, and MINIMUM in Excel worksheets.Build formulas.Create and move a clustered 3-D bar chart.Course Outcome practiced in this unit:IT153-1: Create spreadsheets to solve business problems.Purpose: This assignment will allow you the opportunity to practice your Excel skills and test your knowledge of the readings in the unit.Assignment DetailsAssignment InstructionsScenario:You are a part-time assistant in the accounting department at Aficionado Guitar Parts, a Chicago-based supplier of custom guitar parts. Their line of New Balance Numeric performance and lifestyle skate shoes utilise all the technology and comfort that New Balance has developed from over a hundred years of pioneering men and women's running shoes. New Balance Numeric draw upon the deep history and heritage of New Balance. ![]() The REVlite sole with a sturdy rubber outsole gives support and superior grip. The shoes keep the classic profile and its retro no-sew synthetic overlays for style and durability. Innovative REVlite midsole provides premium responsiveness and durability at a 30% lighter weight than other foams with comparable performanceįor the New Balance Numeric 420 skate shoe NB decked out their popular 70s-inspired silhouette with durable, skateboard-ready construction.Only 420 pairs made in limited edition green and white.New Balance Numeric 420 skate shoe in green and white. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |