Midlands Microsoft Office Provider

1.5 Format Cells – Font Tab; Practice Exercise 5 – Intermediate Excel 2016

Practice Exercise 5:  Use the Format Cells Font tab to perform superscript and subscript formatting, as well as reset all cell formatting using the Normal font checkbox.
Still using the Excel data file “FORMAT CELLS EXERCISES”
On the Format Cells dialog box, select the tab “Font” (FIGURE 1).
                        FIGURE 1
Accounting Underlines
Single Underlining is used to denote Subtotal and Double Underlining is used to denote Grand Total.
At the bottom of the worksheet, select the ACCOUNTING FORMATTING tab.
STEP 1: Make cell B2 the active cell. Right-button mouse click cell B2 and select Format Cells from the mouse shortcut menu. On the Format Cells dialog box, select the Font tab.  In the “Underline” section, select “Single Accounting” (FIGURE 2) from the drop-down menu. Select OK button.

​
STEP 2: Make cell D2 the active cell. Right-button mouse click cell D2 and select Format Cells. In the Format Cells dialog box, select the Font tab. In the “Underline” section, select  “Single” from the drop-down menu (FIGURE 3). Select OK button.

​
​
​Note the differences between “Single Accounting” and “Single”. Single Accounting adds a single underline that is noticeably lower than the Single underline. Additionally, the width of the underline extends the entire cell width if the cell contains text or dates (FIGURE 4).
                           FIGURE 2
                              FIGURE 3
                                 Single Accounting               Single
                                   FIGURE 4
STEP 3: Make cell B5 the active cell. Right-button mouse click cell B5 and select Format Cells. In the Format Cells dialog box, select the Font tab.  In the “Underline” section, select “Double Accounting” (FIGURE 5) from the drop-down menu. Select OK button.

​
STEP 4: Make cell D5 the active cell. Right-button mouse click cell D5 and select Format Cells. In the Format Cells dialog box, select the Font tab. In the “Underline” section, select  “Double” from the drop-down menu (FIGURE 6). Select OK button.

​

​
​Notice the difference between “Double Accounting” and “Double”.
​Double accounting adds a double-underline that is noticeably lower than the Double underline. In addition, the width of the underline extends the entire cell width if the cell contains text or dates (FIGURE 7).

​
                        FIGURE 5
                        FIGURE 6
                          Double Accounting        Double
                        FIGURE 7
Practice Exercise Preparatory Activities: If you have not opened the Excel data file “FORMAT CELLS EXERCISES” do so now. Select the tab “Formatting & Reset”
Formatting cell(s) and Reset Cells to the Excel Default
(FIGURE 8) ​These are the default settings for Excel’s font; Calibri (body), Regular, Size 11. All of the fonts are True Type fonts, meaning they will display and print exactly the same.
FIGURE 8
Create a new tab by selecting the + symbol at the bottom of the worksheet. 

STEP 5: Make cell B2 the active cell. Right-button mouse click cell B2 and select Format Cells. On the Format Cells dialog box, select the Font tab. Apply the following format changes to cell B2:

  • Font A R Christy
  • red font
  • 16 point
  • Bold
  • Italics

After applying the above formatting changes to the text, the text should look similar to FIGURE 9.

​STEP 6: Check the Normal font checkbox (FIGURE 10) . Doing this will reset all font style or formatting changes back to the standard default, Calibri, Standard, 11 pt.
​Select OK.
​

​
The result is shown in FIGURE 11.
  FIGURE 9
FIGURE 10
   FIGURE 11
Apply Superscript, Subscript, and Strikethrough Formatting to a cell(s).
Using the same data file Format Cells Exercises, select the tab “Superscript – Subscript”

STEP 7: Make cell B1 the active cell. In cell B1, highlight only the letters “super” in the name “superscript test”.  (FIGURE 12). 
​
STEP 8: On the Format Cells Font tab, in the “Effects” section, check the box “Superscript” (FIGURE 13). Select the OK button.

​STEP 9: The superscript effect is shown in FIGURE 14.
                FIGURE 12

Picture

          
            FIGURE 13
                         FIGURE 14
STEP 10:  Make cell D1 the active cell. In cell D1, highlight only the letters “sub” in the name “subscript test” (FIGURE 15).

STEP 11: On the Format Cells Font tab, in the “Effects” section, check the box “Subscript” (FIGURE 16). Select the OK button.

​STEP 12: The subscript effect is shown in FIGURE 17.
                 FIGURE 15
              FIGURE 16
FIGURE 17
STEP 13: Make cell F1 the active cell. In cell F1, highlight only the letters        “strike” in the name “strikethrough test”. (FIGURE 18).
STEP 14: On the Format Cells Font tab, in the “Effects” section, check the box “Strikethrough” (FIGURE 19). 
STEP 15: The strikethrough effect is shown in FIGURE 20.

​Note: If you desire to produce a superscript, subscript, or strikethrough of all data in the cell, you ​do not have to highlight anything. Excel will create the effect on all data in the cell automatically.
FIGURE 18
FIGURE 19
FIGURE 20
This is the end of this section. To continue, go to Module 1 Section 1.6 Format Cells – Border Tab; Practice Exercise 6