Worksheets Copyright 2006 SouthWesternThomson Learning Workbooks and Worksheets

Workbooks and Worksheets n n n A workbook is a file in Excel A worksheet is one section in a workbook A worksheet contains ¡ ¡ ¡ Columns indicated by letters (A, B, C) Rows indicated by numbers (1, 2, 3) Cells indicated by letter and number (B 2) Click the mouse or tap the RIGHT ARROW key to continue. Screen 2

Excel Window Formula bar Cell: intersection of a row and a column Column heading Row Worksheet tabs Column Click the mouse or tap the RIGHT ARROW key to continue. Screen 3

Worksheet Guidelines n Worksheet title ¡ ¡ ¡ ALL CAPS Bold 12 -point or 14 -point font Center across data Leave one blank row after Worksheet title Click the mouse or tap the RIGHT ARROW key to continue. Screen 4

Worksheet Guidelines n Column heads ¡ ¡ ¡ n 12 -point or default font Bold Center alignment Data in cells ¡ ¡ Default or regular 12 -point font Align data appropriately Column heads Data in cells Click the mouse or tap the RIGHT ARROW key to continue. Screen 5

Worksheet Guidelines n n Center worksheets horizontally Center worksheets vertically or use a 2 -inch top margin 2" top margin Click the mouse or tap the RIGHT ARROW key to continue. Screen 6

Formulas n n n Equations that perform calculations on values in a worksheet Begin with an equal sign Appear in the formula bar while results appear in the cell Formula in formula bar Result of formula in cell Click the mouse or tap the RIGHT ARROW key to continue. Screen 7

Functions n n Predefined formulas that can be used to perform calculations Examples ¡ ¡ ¡ AVERAGE finds the average of numbers COUNT counts the numbers in a cell range MIN finds the smallest number in a cell range MAX finds the largest number in a cell range SUM finds the total of numbers in a cell range =AVERAGE(B 4: G 4) Formula with function Click the mouse or tap the RIGHT ARROW key to continue. Screen 8

Clearing Cells n To clear the content or formats in a cell ¡ ¡ ¡ Go to the cell or select several cells Choose Edit, Clear Choose n n n All to clear contents and formats Formats to clear only formats Contents to clear only contents Click the mouse or tap the RIGHT ARROW key to continue. Screen 9

Copying Data n To copy data ¡ ¡ n Select the cell(s) and click Copy Move to the new location and click Paste To copy data using the fill handle ¡ ¡ Click and drag over adjacent cells to which you wish to copy Release the mouse button Click the fill handle and drag over cells Click the mouse or tap the RIGHT ARROW key to continue. Release the mouse and data will be copied to cells Screen 10

Column Widths n To change the column width ¡ ¡ Click and drag the column heading border Set an exact width in the Column Width box n n Choose Format, Column, Width Enter a number for the column width Click and drag a column heading border Click the mouse or tap the RIGHT ARROW key to continue. Screen 11

Inserting and Deleting n To insert a row or column ¡ ¡ n Click Insert on the menu bar Choose Row or Column To delete a row or column ¡ ¡ Select the row or column Choose Edit, Delete Click and drag over row headings to select rows Click the mouse or tap the RIGHT ARROW key to continue. Screen 12

Sorting Data n Arranging data in a particular order ¡ ¡ n Ascending order (1 to 10, A to Z) Descending order (10 to 1, Z to A) To sort worksheet data ¡ ¡ Choose Data, Sort Enter the criteria in the Sort box Select to leave out title and column heads Click the mouse or tap the RIGHT ARROW key to continue. Screen 13

Review 1. In Excel software a. A worksheet can contain several workbooks b. A workbook can contain several worksheets c. A worksheet is a file Read the question and decide which answer you think is correct. Click the mouse to see the correct answer. Click the mouse or tap the RIGHT ARROW key to continue. Screen 14

Review 1. In Excel software A workbook can contain several worksheets Click the mouse or tap the RIGHT ARROW key to continue. Screen 15

Review 2. In an Excel worksheet a. The worksheet title is shown vertically in a column b. Rows are identified by letters c. A cell is the intersection of a row and a column Read the question and decide which answer you think is correct. Click the mouse to see the correct answer. Click the mouse or tap the RIGHT ARROW key to continue. Screen 16

Review 2. In an Excel worksheet A cell is the intersection of a row and a column Click the mouse or tap the RIGHT ARROW key to continue. Screen 17

Review 3. In a worksheet a. The worksheet title should be aligned at the left b. All the data in the rows should be in a bold font c. The column heads should be centered and in bold Read the question and decide which answer you think is correct. Click the mouse to see the correct answer. Click the mouse or tap the RIGHT ARROW key to continue. Screen 18

Review 3. In a worksheet The column heads should be centered and in bold Click the mouse or tap the RIGHT ARROW key to continue. Screen 19

Review 4. In an Excel worksheet a. Rows can be inserted or deleted b. Rows can be inserted but not deleted c. Columns can be deleted but not inserted Read the question and decide which answer you think is correct. Click the mouse to see the correct answer. Click the mouse or tap the RIGHT ARROW key to continue. Screen 20

Review 4. In an Excel worksheet Rows can be inserted or deleted Click the mouse or tap the RIGHT ARROW key to continue. Screen 21

Review 5. A worksheet should a. Be centered horizontally on the page b. Have a 1 -inch top margin c. Have a 3 -inch bottom margin Read the question and decide which answer you think is correct. Click the mouse to see the correct answer. Click the mouse or tap the RIGHT ARROW key to continue. Screen 22

Review 5. A worksheet should Be centered horizontally on the page Click the mouse or tap the RIGHT ARROW key to continue. Screen 23