1 excel lesson 2 organizing the worksheet & formulas microsoft office 2010 introductory pasewark...
DESCRIPTION
Excel Lesson 3 Pasewark & Pasewark Microsoft Office 2010 Introductory 333 Inserting and Deleting Rows, Columns, and Cells To insert a row, click the row heading to select the row where you want the new row to appear. Then, click the Insert button on the Home tab. To insert a column, click the column heading to select the column where you want the new column to appear. Then, click the Insert button.TRANSCRIPT
1
Excel Lesson 2Organizing the Worksheet & Formulas
Microsoft Office 2010 Introductory
Pasewark & Pasewark
Excel Lesson 3
Pasewark & Pasewark Microsoft Office 2010 Introductory
Copying and Moving Cells (continued)
You can quickly move or copy data using the drag-and-drop method. First, select the cell or range, then drag them to a new location.
To copy cells, press and hold the Ctrl key. Filling copies a cell’s contents and/or formatting
into an adjacent cell or range. You can use the fill handle to help with copying
cells and also to continue a series of text items, numbers, or dates.
222
Excel Lesson 3
Pasewark & Pasewark Microsoft Office 2010 Introductory 333
Inserting and Deleting Rows, Columns, and Cells
To insert a row, click the row heading to select the row where you want the new row to appear. Then, click the Insert button on the Home tab.
To insert a column, click the column heading to select the column where you want the new column to appear. Then, click the Insert button.
Excel Lesson 3
Pasewark & Pasewark Microsoft Office 2010 Introductory 444
Inserting and Deleting Rows, Columns, and Cells (continued)
To delete a row or column, click the appropriate row or column heading and then click the Delete button on the Home tab.
Use the buttons in the Cells group on the Home tab to insert and delete cells.
Insert dialog box
Excel Lesson 3
Pasewark & Pasewark Microsoft Office 2010 Introductory 55
Freezing Panes in a Worksheet
You can view two parts of a worksheet at once by freezing panes.
When you freeze panes, you select which rows and/or columns of the worksheet remain visible on the screen as the rest of the worksheet scrolls.
5
Excel Lesson 3
Pasewark & Pasewark Microsoft Office 2010 Introductory 66
Checking Spelling in a Worksheet
To find and correct spelling errors, use the Spelling command on the Review tab.
6
Excel Lesson 3
Pasewark & Pasewark Microsoft Office 2010 Introductory 77
Preparing a Worksheet for Printing
7
So far, you have worked in Normal view, which is the best view for entering and formatting data in a worksheet.
Page Layout view shows how the worksheet will appear on paper, which is helpful when you prepare a worksheet for printing.
The margin is the blank space around the top, bottom, left, and right sides of a page.
Excel Lesson 3
Pasewark & Pasewark Microsoft Office 2010 Introductory
Preparing a Worksheet for Printing (continued)
Margins menu
8
Excel Lesson 3
Pasewark & Pasewark Microsoft Office 2010 Introductory 99
Preparing a Worksheet for Printing (continued)
9
By default, Excel is set to print pages in portrait orientation. Worksheets printed in portrait orientation are longer than they are wide. In contrast, worksheets printed in landscape orientation are wider than they are long.
The print area consists of the cells and ranges designated for printing.
Excel Lesson 3
Pasewark & Pasewark Microsoft Office 2010 Introductory 1010
Preparing a Worksheet for Printing (continued)
10
By default, gridlines, row numbers, and column letters appear in the worksheet but not on the printed page. You can choose to show or hide gridlines and headings in a worksheet or on the printed page.
Excel Lesson 3
Pasewark & Pasewark Microsoft Office 2010 Introductory 1111
Inserting Headers and Footers
11
A header is text that is printed in the top margin of each page. A footer is text that is printed in the bottom margin of each page.
Completed Header section
Excel Lesson 3
Pasewark & Pasewark Microsoft Office 2010 Introductory
What Are Formulas?
The equation used to calculate values based on numbers entered in cells is called a formula.
Each formula begins with an equal sign (=). The results of the calculation appear in the
cell in which the formula is entered.
121212
Excel Lesson 3
Pasewark & Pasewark Microsoft Office 2010 Introductory
What Are Formulas? (continued)
Formula and formula reset
13
Excel Lesson 3
Pasewark & Pasewark Microsoft Office 2010 Introductory
Entering a Formula
Worksheet formulas consist of two components:– operands– operators
An operand is a constant (text or number) or cell reference used in a formula.
An operator is a symbol that indicates the type of calculation to perform on the operands, such as a plus sign (+) for addition.
141414
Excel Lesson 3
Pasewark & Pasewark Microsoft Office 2010 Introductory
Entering a Formula (continued)
Mathematical operators
15
Excel Lesson 3
Pasewark & Pasewark Microsoft Office 2010 Introductory
Entering a Formula (continued)
A formula with multiple operators is calculated using the order of evaluation. – Contents within parentheses (beginning with
innermost) are evaluated first. – Mathematical operators are evaluated in a specific
order. (Shown in table on next slide).– If operators have the same order of evaluation, the
equation is evaluated from left to right.
161616
Excel Lesson 3
Pasewark & Pasewark Microsoft Office 2010 Introductory
Entering a Formula (continued)
Order of evaluation
17
Excel Lesson 3
Pasewark & Pasewark Microsoft Office 2010 Introductory 181818
Editing Formulas
If you enter a formula with an incorrect structure in a cell, Excel opens a dialog box that explains the error and provides a possible correction.
Formula error message
Excel Lesson 3
Pasewark & Pasewark Microsoft Office 2010 Introductory 191919
Editing Formulas (continued)
If you discover that you need to make a correction, you can edit the formula.
Click the cell with the formula you want to edit. Press the F2 key or double-click the cell to enter editing mode or click in the Formula Bar.
Excel Lesson 3
Pasewark & Pasewark Microsoft Office 2010 Introductory 2020
Creating Formulas Quickly
You can include cell references in a formula by using the point-and-click method to click each cell rather than typing a cell reference.
Worksheet users frequently need to add long columns or rows of numbers. To use the Sum button, click the cell where you want the total to appear, and then click the Sum button.
20
Excel Lesson 3
Pasewark & Pasewark Microsoft Office 2010 Introductory 2121
Previewing Calculations
When you select a range that contains numbers, the status bar shows the results of common calculations for the range.
By default, these calculations display the average value in the selected range, a count of the number of values in the selected range, and a sum of the values in the selected range.
21
Excel Lesson 3
Pasewark & Pasewark Microsoft Office 2010 Introductory
Previewing Calculations (continued)
Summary calculation options for the status bar
22
Excel Lesson 3
Pasewark & Pasewark Microsoft Office 2010 Introductory 2323
Showing Formulas in the Worksheet
23
At times you may find it simpler to organize formulas and detect errors when formulas are displayed in their cells.
To do this, click the Formulas tab on the Ribbon, and then, in the Formula Auditing group, click the Show Formulas button. The formulas replace the formula results in the worksheet.