1 / 14

Excel

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.

ivana
Télécharger la présentation

Excel

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Excel

  2. 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.

  3. 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

  4. 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

  5. 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

  6. 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

  7. 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

  8. Formulas • Formulas are equations used to calculate values in a cell. • Each formula begins with an equal sign(=). • Formulas appear in the formula bar.

  9. + 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

  10. 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

  11. 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

  12. 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

  13. 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

  14. 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

More Related