Excel Chapter 2
1. Entering data into an excel worksheet is very simple. The user just has to click on the desired cell where information is to be entered, and then type what they want in the box. Whatever the user types, whether it be labels such as text entries or values such as numbers and formulas, will be automatically entered into the formula bar as well.
2. Labels and values both refer to data entered into cells in an Excel worksheet. However, they differ in that labels are texts entries whereas values are number or formula entries.
3. A series of # signs means that the number entered into the cell was wider than the column permitted. This can be resolved by resizing the column with to show the entire number and removing the # signs.
4. Changing column width or row height is a very easy task in Excel. The user can place the mouse pointer between the gray area of the columns containing letter headings, click, and drag the column left or right to expand or reduce its size. The same can be done for rows, but the user must drag up or down to resize the row height. Another neat feature is that if the user double clicks in the gray area between letters, the column size will automatically adjust to fit the largest data entry. Furthermore, the user can automatically adjust all the rows and columns of a worksheet by clicking on the arrow in the gray box in the upper left corner and then double clicking the gray at the top between any column or row.
5. The appearance of data is controlled by applying different formats to cells. Numerous formats exist for different sets of numbers. Some useful number formats include date, comma, accounting which is used for money, and percent.
6. The Format Painter tool enables the user to essentially copy a cells number format to another cell. The process involves selecting the cell with the desired number format, for example