LO Patr 03 AA Condom C Sort & Ab A Ferg & Co 2 You are working in the fance department of Kashmir Emporium You are responsible for recording transaction and reporting to the departm 4 Acoleague has told you that the department manager doesn't eat formatted sp 5 Format this sheet such that it looks presentable thestion worksheet, a sample tramaction statement is provided for a clent. You should format the statement by following the stops The formatting should look the the image shown in the Samplewer Sheet 7 B Steps to Perform 9 Shep Instructions 10 1 11 12 13 14 15 16 17 18 19 10 20 21 On the Question worksheet, perform the following 2CE A1 to A7 should be formatted to bold 3ight click on 1st Row and change the height to 30 Apply a shade to the Text in cell 01 can be any shade of g 5 Vertical algment of 81 cell should be midde signed Horizontal alignment of 91 cell should be right aligned Menge cell and Al Apply All borders in cell A1 to A/ Merge cells B, and Right win text in 11 Select cead and C4 together, then apply Outside Border 12 Clear format of Cell 22 13 Select cell 85 and CS together, then apply Outside Bonder 23 24 15 In cell 07, underline the text 25 16 In cell 7, as the text to left alig 20 27 28 29 20 Select cell 87 and CZ together. then apply Outside Donder Instructions Questice SampleArmwar 14 Cell 7 and C7 are merged. Usmenge the cells 17 Select cell 1 and C1 together, then apply Dutside Border. 18 Select cell R2, then apply Outside Border 19 Select cet 86 and C6 together, then apply Outside Border, 25 25 15 13 13 13 25 23 2.5 25 25 25 LO W 91 AL Format Pr A Wrap Te Geral EXOOMgr & Center 5% Conditonal fome Formatting 30 31 21 Cell C11 content is not visible properly, double click on column C to increase the column width 27 Format Transaction ID values in cells A11 to A19, as intege 32 23 Change the format of cells F11 to 19 to Accounting format 33 24 cells F11 to F19, reduce the decimal to 0. 34 25 in cells 11 to H19, the decount should be in % format 35 26 36 37 27 30 28 39 29 Change the font to Arial 40 30 41 31 cells H11 to 19, increase the number of decimal places to 3 decimal places. Cell range E1 to 3 is already merged, apply 27 to 32 in these cell Change the fill to white color Change the font size to 14 Change the text orientation to 45 degree column width of E column should be 15 42 32 Apply thick Outside Border to cell ES to F 43 44 45 46 47 37 48 38 49 39 33 Wrap content of cell 34Hide column G 35Hide Row 36 in cell 12 & 13 change the date format to yyyy mm dd (such as 2020-01-200 Freeze up to 12th row and upto 3rd column (column C) In cell 111 to 119, change the date format to dd Mmm-yy (such as 01-Jan-201 cel A10 to 130, fill with light blue color 50 40 in cell A10 to 110, change the foot to bold 51 43 Select cell range A10.119, then Apply All Borders 52 53 54 55 56 C D E 25 25 ES 25 25 25 25] 2.5 2.5 25 2.5 14 4 15 15 Total Points 100 S& Data