C. Spreadsheet Work Area: By default the work area is a grid. Along the top are column headers A through Z (and beyond), and along the left side are numbered row headers. Each rectangle in the spreadsheet is called a cell, and they are each named according to their column letter and row number. For example, the cell selected here is A3.

D. Formula Bar: The Formula Bar displays the information contained within a highlighted single cell or range of cells. If in cell A1 you entered “1” as a value, “1” will appear in the Formula Bar. Plain text that you enter in a cell will also appear in the Formula Bar.

There are cases where what you see in the Formula Bar is different than whats in the cell. For example, lets say A1 = 1 and A2 = 2. If you create a formula in A3 that equals A1 + A2, then the A3 cell in your worksheet would show “3,” but the Formula Bar would show “=A1+A2.” This is important when youre trying to move cells to other parts of your worksheet _ remember that the display “value” of a cell isnt necessarily what the cell contains.

D. Multi_cell Formatting Features: This section contains two very important features that solve common problems for new Excel users. The first is Wrap Text. Normally, when you enter text into a cell that extends beyond the size of the cell, it spills into the next cell. For example, if you type “Budgeted Items” into A1, some of the word “Items” spills into B1. Then, if you type into B1, you cover up any characters from A1 that extended into B1. The extra text from cell A1 still exists, but now it is hidden. If you dont want to widen the cells, click the Wrap Text icon on A1 _ this will split “Budgeted Items” into two stacked lines instead of one within A1. This makes the entire row taller to accommodate the content. Now, typing into B1 wont cover up existing text.

• ABOUT | CONTACT | PRIVACY POLICY | COOKIES POLICY | TERMS & CONDITIONS | COPYRIGHT | IMAPS •

© 2015 Centennialwines - All Rights Reserved