150 likes | 351 Views
Excel . Excel. The purpose of a spreadsheet is to solve problems involving numbers. A worksheet consists of columns and rows that intersect to form cells . Each cell is identified by a cell reference , which combines letter of column and number of the row.
E N D
Excel • The purpose of a spreadsheet is to solve problems involving numbers. • A worksheet consists of columns and rows that intersect to form cells. • Each cell is identified by a cell reference, which combines letter of column and number of the row. • A group of selected cells is called a range – identified by the cells in the upper left and lower right corners of the range separated by a colon.
Entering Data • Open the Homes.xlsx Data File • Save with usernamehomeowner • In cell A15 enter , South Dakota • In cell B15, enter 67.3 • In cell A16, edit the data to Delaware • In cell B16, edit the data to 66.8 • Add a row and column???? • In cell A5, delete the data • In cell H1, enter your name and save
Using the Find Command • Open the Names.xlsx Data File • Save with usernamenames • Use the Find command to locate the name CHAVEZ • Click the worksheet outside the dialog box, press Ctrl + Home to return to Cell A1 • Click in the Find and Replace dialog box, and locate the name YORK • Click in the Find and Replace dialog box, click the Replace tab, and replace the name FORBES with FORGE, undo and change to FORBERGE and save
Changing Appearance • Open the Cell. xlsx Data File • Save with usernamecellbill • In cell A1, type Cell Phone Bill Estimate • Bold the text in cell A1 • In cell A1, change the font size of the text to 14 • Merge and center the range A1:D1
Change the fill color of cell A1 to Blue, Accent 1 • Change the font color of cell A1 to white background • Underline the content of cell A1 • Center the contents of the range B3:C3 • Format the range D4:D7 in the Currency number format with two decimal places • Add a bottom border to cell D6
Widen column A to 17. In cell A4 wrap text • Middle align the range B4:D4 • Apply the 20% Accent 1 cell style to the range D4:D7 • Freeze panes • Split panes • In cell A2 enter your name • Save and close
Formulas • Formulas are equations used to calculate values in a cell. • Each formula begins with an equal sign(=). • Formulas appear in the formula bar.
+ addition • - subtraction • * multiplication • / division • ^ exponentiation • Examples: • Add the values in cell D4 and D5 =D4 + D5 • Raise the value in B 4 to the 23th power =B4^23 • Multiply the value in cell E2 times 25, and then divide the product by the value in cell E 10 =(E2*25)/E10
Practice Writing Formulas • Add the values in cell C5 and C6 • Subtract the values in cell B3 from the value in cell B2 • Multiplies the value in cell D2 times 23 • Divides the value in cell A5 by 37 • Raises the value in cell A2 to the 12th power • Divides the value in B2 by 24, and then adds the value in cell A7
Divides the value in cell A5 by the result of 12 plus the value in cell A3 • Multiplies the values in cell C3 times 27, and then divides the product by the value in cell C4 • Divides 25 by the value in cell D4, and then multiplies the result by the value in cell D3 • Raises the value in G3 to the 15th power, and then divides the result by the value in G4
Using formulas • Open the Results.xlsx Data File • Save with usernameformularesults • Enter formulas in the specified cells that perform the operations listed and note the resulting value. • In Cell C3, add the values in cells A3 and B3 • In C4,Subtract the value in cell B4 from the value in A4 • In C5, Multiply the value in cell A5 by the value in B5
In C6, Divide the value in cell A6 by the value in B6 • In B7, Sum the values in the range B3:B6 • In D3, Add the values in cells A3 and B3, and then multiply by 3 • In D4, Add the values in cells A3 and A4, and then multiply by cell B3
In D5, Copy the formulas in cell D4 to cell D5 • In D6, Subtract the value in cell B6 from the value in cell A6, and then divide by 2 • In D7 Divide the value in cell A6 by 2, and then subtract the value in cell B6