Excel Excel The purpose of a spreadsheet is

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. �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 A 15 enter , South Dakota �In cell B 15, enter 67. 3 �In cell A 16, edit the data to Delaware �In cell B 16, edit the data to 66. 8 �Add a row and column? ? �In cell A 5, delete the data �In cell H 1, enter your name and save

Using the Find Command �Open the Names. xlsx Data File �Save with usernames �Use the Find command to locate the name CHAVEZ �Click the worksheet outside the dialog box, press Ctrl + Home to return to Cell A 1 �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 A 1, type Cell Phone Bill Estimate �Bold the text in cell A 1 �In cell A 1, change the font size of the text to 14 �Merge and center the range A 1: D 1

�Change the fill color of cell A 1 to Blue, Accent 1 �Change the font color of cell A 1 to white background �Underline the content of cell A 1 �Center the contents of the range B 3: C 3 �Format the range D 4: D 7 in the Currency number format with two decimal places �Add a bottom border to cell D 6

�Widen column A to 17. In cell A 4 wrap text �Middle align the range B 4: D 4 �Apply the 20% Accent 1 cell style to the range D 4: D 7 �Freeze panes �Split panes �In cell A 2 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 D 4 and D 5 =D 4 + D 5 �Raise the value in B 4 to the 23 th power =B 4^23 �Multiply the value in cell E 2 times 25, and then divide the product by the value in cell E 10 =(E 2*25)/E 10

Practice Writing Formulas �Add the values in cell C 5 and C 6 �Subtract the values in cell B 3 from the value in cell B 2 �Multiplies the value in cell D 2 times 23 �Divides the value in cell A 5 by 37 �Raises the value in cell A 2 to the 12 th power �Divides the value in B 2 by 24, and then adds the value in cell A 7

�Divides the value in cell A 5 by the result of 12 plus the value in cell A 3 �Multiplies the values in cell C 3 times 27, and then divides the product by the value in cell C 4 �Divides 25 by the value in cell D 4, and then multiplies the result by the value in cell D 3 �Raises the value in G 3 to the 15 th power, and then divides the result by the value in G 4

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 C 3, add the values in cells A 3 and B 3 �In C 4, Subtract the value in cell B 4 from the value in A 4 �In C 5, Multiply the value in cell A 5 by the value in B 5

�In C 6, Divide the value in cell A 6 by the value in B 6 �In B 7, Sum the values in the range B 3: B 6 �In D 3, Add the values in cells A 3 and B 3, and then multiply by 3 �In D 4, Add the values in cells A 3 and A 4, and then multiply by cell B 3

�In D 5, Copy the formulas in cell D 4 to cell D 5 �In D 6, Subtract the value in cell B 6 from the value in cell A 6, and then divide by 2 �In D 7 Divide the value in cell A 6 by 2, and then subtract the value in cell B 6