![]() ![]() ![]() 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. New Balance’s model or style number is the naming system for their shoes – generally speaking, the ‘higher number’ styles feature more New Balance technology, such as the 913, which incorporates RevLite and N2 cushioning, whereas ‘lower numbers’, offer retro styling and lighter technology such as Abzorb. If you’re somewhere in the middle, check out the 288 Sport, 379 and 440 models. If you’re after a cupsole, with greater foot protection and more features, then the brand’s more technical silhouettes such as the 913 will be for you. If you prefer the feel and grip of a vulcanised shoe then New Balance’s court shoe inspired silhouettes, such as the 212 or 213, or the slightly more technical 306, will be ideal. Choosing the right style for you is fairly simple. New Balance Numeric skate shoes have every angle of skateboarding covered. ![]() Watch the NB Numeric video ‘Gazette’ here About NB Numeric The reinforced toe helps absorb skate-specific wear-and-tear to finish off this trusted, durable shoe. This modern-retro men’s kick features a foam wedge in the heel to help enhance comfort for a soft ride. Our NM440V1 blends modern technology with soft cushioning to create a go-to shoe for both everyday skate and wear. C-Cap heel wedge in the midsole for impact protection.NDurance rubber outsole technology provides superior durability in high-wear areas to help get more out of the shoes. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |