Excel Formatting and Function Basics: Bold, Italicize, Underline, Sum, Average, Count, Slides of MS Microsoft Excel skills

Download Excel Formatting and Function Basics: Bold, Italicize, Underline, Sum, Average, Count and more Slides MS Microsoft Excel skills in PDF only on Docsity!

Bold, Italicize, and Underline

 Short cuts???

Bold, Italicize, and Underline with

short cut keys

 Bold, Italicize, and Underline with Shortcut Keys

 Type All three in cell D2.

 Click the check mark located on the Formula bar.

 Hold down the Ctrl key while pressing "b" (Ctrl+b).

Excel bolds the cell contents.

 Hold down the Ctrl key while pressing "i" (Ctrl+i).

Excel italicizes the cell contents.

 Hold down the Ctrl key while pressing "u" (Ctrl+u).

Excel applies a single underline to the cell contents.

 Open Microsoft Excel.

 Type 12 in cell B1.

 Press Enter.

 Type 27 in cell B2.

 Press Enter.

 Type 24 in cell B3.

 Press Enter.

 Type =SUM(B1:B3) in cell A4.

 Press Enter. The sum of cells B1 to B3, which is 63, appears

Insert function with a ribbon

Calculate the average

Calculate average by autosum

symbol

Find the lowest number

Find the highest number

1. Move to cell A9.

2. Type Count.

3. Press the right arrow key to move to cell B9.

4. Choose the Home tab.

5. Click the down arrow next to the AutoSum button.

6. Click Count Numbers. Excel places the count

function in cell C9 and takes a guess at which cells

you want to count. The guess is incorrect, so you

must select the proper cells.

 Select B1 to B3.

 Press Enter. The number of items in the series, which

is 3, appears.