Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

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

A beginner's guide to formatting cells in excel using shortcut keys for bold, italicize, and underline. It also covers the basics of using functions such as sum, average, and count. How to use reference operators for ranges and unions, and demonstrates how to calculate the sum and average of a range of cells, as well as how to find the lowest and highest numbers and count the numbers in a series.

Typology: Slides

2011/2012

Uploaded on 07/12/2012

divakar
divakar 🇮🇳

4.1

(25)

72 documents

1 / 15

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Bold, Italicize, and Underline
Short cuts???
Docsity.com
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe
pff

Partial preview of the text

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.