CA IExcel Lesson 2

Excel Lesson 2√ Formatting √ Other Terms

  AutoFormat   autofit

  commas   cell style

  currency   labels

  general format   values

  Merge and Center   indent

  percent   rotated text or text orientation

border wrapping text

row height ######

column width Format Painter

cell alignment• top• Bottom• left• right,• Center• middle

fontfont sizefont styles

Cell SizeAutofit is an Excel feature that will

automatically size a cell to accommodate the longest entry without wasting space.

Cell size can also be adjusted using row height and column width.

TermsAligning Text causes the text to be placed

in a specific position within the cell.

◦ Text can be aligned vertically using:

Top

Middle

Bottom

◦ It can be aligned horizontally using;

Left

Right

Center

Text Indenting Text is text that is has

been moved over from the left.

Rotating Text or Changing Text Orientation is a feature that is useful to make the headings go up and down or diagonally.

Wrapping Text causes a new line to begin within the cell of a worksheet when the data exceeds the width of the column.

Fonts A font is the design of text.

◦ Calibri is the default font.◦ This PowerPoint’s font is Gills San MT.◦ Algerian, Comic Sans MS, Harrington and many other

fonts are available for you to chose from.◦ Use standard fonts like Calibri, Arial, Times New Roman

for regular work.◦ Use the decorative fonts for special purposes only.

Font size determines the size of the text.◦ Fonts size is measured in points. ◦ The default size if 11 points.

You can change font styles, which include Bold Italic Underline Shadow Strikethrough

Other FormattingBorder places a line

around a cell or range of cells.

Merge and Center combines several cells into one cell and places the text in the middle of the merged cell.

Themes and Styles AutoFormat is a collection of font,

patterns, and alignments that can be applied to a range of data that was used in Office 2003.◦ These include a predefined look both

for the data and headings. ◦ In Excel 2007, you use themes and

styles.

Format Painter and Cell StyleAs in Word, Format Painter is an easy way

to copy formatting from one cell to another. This is especially helpful when the cell contains several formats

A cell style is a collection of formatting characteristics you apply to a cell or range of cells.

You can also clear cell formats not wanted.

Types of Number FormatsNumber Formats change the way

the data looks in the cell.◦ General is the default format for data in a

cell.

◦ Currency is the format that displays numerical data so that it is preceded by a dollar sign, such as $4.85.

◦ Percent will display the number .60 as 60.0%.

◦ Commas is the format that displays numbers over 999 with commas in appropriate locations, such as 1,950.

What is #######?

###### means the cell is too narrow to display the answer.

This happens usually when you add formatting to a cell and all of a sudden the ##### appears because the $, commas, % make the data wider than the cell.