Download Microsoft Excel Expert (Excel and Excel 2019).MO-201.SelfTestEngine.2020-03-13.22q.vcex

Step 1: Open the correct worksheet (Section 3 Worksheet).Step 2: Click in cell A2.Step 3: Press down the Shift key and click in cell S2.Step 4: On the  Home  tab, under  Format, scroll down until you see 40% . Accent3, and click on it.   

Step 1: Open the correct worksheet (Section 3 Worksheet).Step 2: Click in cell A2.Step 3: Press down the Shift key and click in cell S2.Step 4: On the  Home  tab, under  Format, choose Format Cells.    Step 5: In the Format Cells dialog box, choose Date, 14-Mar, and Locale (location): English (United States). Click OK.   

Step 1:  Click Cell B2. Type the text: DateStep 2: Click cell C2. Type the text: 22-AugStep 3: Click cell D2. Type the text: 29-AugStep 3: Click cell C2, then shift-click cell D2.    Step 4: Copy until cell S2 (by dragging from cell D2 to cell S2).   

Step 1: Click cell B3.Step 2:Shift-click cell B25Step 3: Right-click somewhere in the B3-B25 cell range, and choose Format Cells from the context menu.    Step 4: In the Format Cells dialog box click the Alignment Tab, change Horizontal: to Right (Indent), change Indent: to 1, and then click the OK button.   

Step 1: Click cell C3Step 2: Shift-Click cell S25.Step 3: On the  Home  tab, under  Format, choose Conditional Formatting, and choose New Rule...    Step 4: In the New Formatting Rule dialog box set Format Style to: 3-Color Scale, and set Minimum Color to Green.    Step 5: In the same dialog box set Midpoint type to Percentile, set Midpoint Value to 70, and set Midpoint Color to White. Also set Maximum Type to Number, Maximum value to 25, and Maximum Color to Red. Finally click OK.   

Step 1: Click in cell B3, and then shift-click in cell S25.Step 2: On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.    Step 3: Still in the Page Layout tab, Enable the Gridlines Print option.   

Step 1: Right-click on the A column header, and select Hide from the context menu.    Step 2: Click on the O columns header, and then Shift-click on the R Column Header.Step 3: Right-click in one of the cells in the high-lighted area, and select Hide from the Context menu.   

Step 1: Click on the picture.Step 2: In the Format menu (which is displayed automatically) click the Crop Command, select Crop to Shape, and click Snip Same Side Corner Rectangle.   

Step 1: Open the correct worksheet (Summary Worksheet).Step 2: Click in cell B5.Step 3: Click on the insert function button.    Step 4: In the Insert Function Dialog box select the Category Text, scroll down and click on the function RIGHT, and click OK.    Step 5: In the Function Arguments Dialog box in the Text box type B2, in the Num_chars type 16, and click OK.   

Step 1: Click cell C7, and then Shift-click cell C29Step 2: Click the Name box at the left end of the formula bar. Step 3: Type: Homework. Press ENTER.