B Mini Case 1 2 You are working in the finance department of Kashmir Emporium. 3 You are responsible for recording transactions and reporting to the department manager 4 A colleague has told you that the department manager doesn't like an unformatted spreadsheet. 5 Format this sheet such that it looks presentable. 6 In the question worksheet, a sample transaction statement is provided for a dient. You should format the statement by following the steps 7 The formatting should look like the image shown in the SampleAnswer Sheet 8 Steps to Perform: 9. Step Instructions Paints On the Question worksheet, perform the following did here and then disk Mini 10 1 101 as a cuestion 11 2 Cell Alto A7 should be formatted to bold 25 12 3 Right dick on 1st Row and change the height to 30 25 13 4 Apely a blue shade to the Text in cell B1 it can be any shade of Blue) 2.5 14 5 Vertical alignment of B1 cell should be middle aligned 251 15 6 Horizontal alignment of B1 cell should be right aligned 2.5 16 z Merge cells A2 and A3 25 17 B Apply All borders in cell Al to A7 25 18 9 Merte cells B2, B3, Q2 and 3 2.5 19 10 Right align text in cell B4 25 20 11 Select cell B4 and C4 together, then apply Outside Border 25 21 121dear format of Cell BS 25 22 13 Seled cells and storether, then apply Outside Border 2.5 23 14 Cell B7 and are merged. Unmerge the cells 25 24 15 in cell 07, underline the text 2.5 25 16 in call 87 align the text to left alien 25 28 17 Select cell B1 and together, then apply Outside Border 1.5 27 18 Select call 82. then apply Outside Border 15 28 19 Select cell 6 and together, then apply Outside Border 29 20 Select cell B7 and together, then apply Outside Border 1.5 30 1.5 21 Cell Cul content is not visible properly, double did on column to increase the column width 31 25 22 Format Transaction ID values in calls All to A19. as integers 32 2 23 Change the format of cells F11 to F19 to Accounting format 33 24 in cells F11 to F19. reduce the decimal to 2 34 25 in cells Hilto H19, the discount should be in format 2 35 26 Incalls 11 to 119, increase the number of decimal places to 3 decimal places 36 Cell range Elto is already mertedapply 27 to 32 in these cells 25 37 22 Change the ful to white color 38 28 Change the font size to 14 25 39 29 Change the font to Arial 25 40 30 Change the text orientation to 45 degree 2.5 41 31 column width of Ecolumn should be 15 25 42 321 Apply thid Outside Border to cell 1 to F3 2.5 43 33 Wrap content of coll 1 25 44 34 Hide column 25 45 35 Mide Rowe 25 46 36 in cell 12.613 change the date format to yyyymdd (such as 20200120 25 47 37 Freeze up to 12th row and upto 3rd column column 48 3 in cell 111 to 119, change the date format to did much as 01. 205 49 39 incell A 10 to 110, with light blue color 50 40 in cell A10 to 110 change the font to bold 51 41 Select cell range A1019 then Apely All Borders 15 15 56 Total Points B D H K 1 Client Name Bridgeway Associates Golden Gate-75 Address Broadway. 75 broadway suite 202. San Francisco Transaction Period 2 3 4 Saat California 5 Zip 94111 o Phone 188-111-9807 858-111-9808 7 Contact Name for Review From Date To Date 120/20 31/03/2020 Mr. Alexander Horst 10 Transaction Salesperson 1000 Sam utford 2.000 tiraness 3000 Samuel Follo 4000 Branis 5.000 Samueford 5000 Banes 7000 Samford 3.000 Samord 5.000 Brno 11 12 13 14 15 18 17 16 19 20 21 22 Order Date Product Name Out Friday, January 10, 2020 Carpet Plan Wednesday, Manuary 15, 2020 Carpet port Saturday, anuary 25, 2020 Pashmina Shaw Tuesday, January 23, 2010 Carpe Dupont Friday, January 31, 2010 Carpet port Saturday, February 15, 2020 Carpet Plan Tuesday. February 11, 2020 Carpet Saturday, February 22, 2020 Carpet Pain Tuesday, February 25.2020 Carpet Plan Discount (9 0.19 0.05 024 146 142 16 132 136 14 133 152 137 Price 700 900 2000 500 900 600 500 600 100 0.13 0.23 0.00 0.11 0.13 0.05 Delivery Date 1/15/20 120/220 1/10/20 2/2/20 2/5/20 2/20/20 2230 2/27/20 3/10 24 B Mini Case 1 2 You are working in the finance department of Kashmir Emporium. 3 You are responsible for recording transactions and reporting to the department manager 4 A colleague has told you that the department manager doesn't like an unformatted spreadsheet. 5 Format this sheet such that it looks presentable. 6 In the question worksheet, a sample transaction statement is provided for a dient. You should format the statement by following the steps 7 The formatting should look like the image shown in the SampleAnswer Sheet 8 Steps to Perform: 9. Step Instructions Paints On the Question worksheet, perform the following did here and then disk Mini 10 1 101 as a cuestion 11 2 Cell Alto A7 should be formatted to bold 25 12 3 Right dick on 1st Row and change the height to 30 25 13 4 Apely a blue shade to the Text in cell B1 it can be any shade of Blue) 2.5 14 5 Vertical alignment of B1 cell should be middle aligned 251 15 6 Horizontal alignment of B1 cell should be right aligned 2.5 16 z Merge cells A2 and A3 25 17 B Apply All borders in cell Al to A7 25 18 9 Merte cells B2, B3, Q2 and 3 2.5 19 10 Right align text in cell B4 25 20 11 Select cell B4 and C4 together, then apply Outside Border 25 21 121dear format of Cell BS 25 22 13 Seled cells and storether, then apply Outside Border 2.5 23 14 Cell B7 and are merged. Unmerge the cells 25 24 15 in cell 07, underline the text 2.5 25 16 in call 87 align the text to left alien 25 28 17 Select cell B1 and together, then apply Outside Border 1.5 27 18 Select call 82. then apply Outside Border 15 28 19 Select cell 6 and together, then apply Outside Border 29 20 Select cell B7 and together, then apply Outside Border 1.5 30 1.5 21 Cell Cul content is not visible properly, double did on column to increase the column width 31 25 22 Format Transaction ID values in calls All to A19. as integers 32 2 23 Change the format of cells F11 to F19 to Accounting format 33 24 in cells F11 to F19. reduce the decimal to 2 34 25 in cells Hilto H19, the discount should be in format 2 35 26 Incalls 11 to 119, increase the number of decimal places to 3 decimal places 36 Cell range Elto is already mertedapply 27 to 32 in these cells 25 37 22 Change the ful to white color 38 28 Change the font size to 14 25 39 29 Change the font to Arial 25 40 30 Change the text orientation to 45 degree 2.5 41 31 column width of Ecolumn should be 15 25 42 321 Apply thid Outside Border to cell 1 to F3 2.5 43 33 Wrap content of coll 1 25 44 34 Hide column 25 45 35 Mide Rowe 25 46 36 in cell 12.613 change the date format to yyyymdd (such as 20200120 25 47 37 Freeze up to 12th row and upto 3rd column column 48 3 in cell 111 to 119, change the date format to did much as 01. 205 49 39 incell A 10 to 110, with light blue color 50 40 in cell A10 to 110 change the font to bold 51 41 Select cell range A1019 then Apely All Borders 15 15 56 Total Points B D H K 1 Client Name Bridgeway Associates Golden Gate-75 Address Broadway. 75 broadway suite 202. San Francisco Transaction Period 2 3 4 Saat California 5 Zip 94111 o Phone 188-111-9807 858-111-9808 7 Contact Name for Review From Date To Date 120/20 31/03/2020 Mr. Alexander Horst 10 Transaction Salesperson 1000 Sam utford 2.000 tiraness 3000 Samuel Follo 4000 Branis 5.000 Samueford 5000 Banes 7000 Samford 3.000 Samord 5.000 Brno 11 12 13 14 15 18 17 16 19 20 21 22 Order Date Product Name Out Friday, January 10, 2020 Carpet Plan Wednesday, Manuary 15, 2020 Carpet port Saturday, anuary 25, 2020 Pashmina Shaw Tuesday, January 23, 2010 Carpe Dupont Friday, January 31, 2010 Carpet port Saturday, February 15, 2020 Carpet Plan Tuesday. February 11, 2020 Carpet Saturday, February 22, 2020 Carpet Pain Tuesday, February 25.2020 Carpet Plan Discount (9 0.19 0.05 024 146 142 16 132 136 14 133 152 137 Price 700 900 2000 500 900 600 500 600 100 0.13 0.23 0.00 0.11 0.13 0.05 Delivery Date 1/15/20 120/220 1/10/20 2/2/20 2/5/20 2/20/20 2230 2/27/20 3/10 24