1 / 51

200

Let’s Get Wordy. Formulas. Functions. Excel It!. Who Knows?. 100. 100. 100. 100. 100. 200. 200. 200. 200. 200. 300. 300. 300. 300. 300. 400. 400. 400. 400. 400. 500. 500. 500. 500. 500. What program do we use to create spreadsheets?. Microsoft Excel.

ahammond
Download Presentation

200

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. Let’s Get Wordy Formulas Functions Excel It! Who Knows? 100 100 100 100 100 200 200 200 200 200 300 300 300 300 300 400 400 400 400 400 500 500 500 500 500

  2. What program do we use to create spreadsheets?

  3. Microsoft Excel

  4. What are the individual boxes that the intersection of rows and columns form called?

  5. Cells

  6. Each single cell has its own unique name called the….

  7. Cell address

  8. Instead of a “document” like MS Word, what is a spreadsheet file called?

  9. Workbook

  10. A group of cells that is highlighted is called a…

  11. Range

  12. What is the first thing you always have to enter when using a formula?

  13. =

  14. What is the formula for adding cell A1 to cell B1?

  15. =A1+B1

  16. What is the formula for subtracting cell G7 from cell E6

  17. =E6-G7

  18. What is the formula for dividing cell B4 by 7?

  19. =B4/7

  20. What is the formula for multiplying cell C6 by 10%?

  21. =C6*10% or=C6*0.10

  22. After the equals sign, what comes next in a function?

  23. The word describing the function in all capital letters.i.e. =SUM

  24. If you want to add values in multiple cells, what function would you use?

  25. The SUM function

  26. If you want to find the average of values in multiple cells what function would you use?

  27. The AVERAGE function

  28. If you want to take a value to a certain number of decimal places what function would you use?

  29. The ROUND function

  30. If you wanted to round cell B3 to 2 decimal places, what would the function be? (The entire thing)

  31. =ROUND(B3, 2)

  32. Open up “Candy Sales” and format the Sales column to look like money. candysales.xls

  33. Open up “Concession Stand” and use a formula to calculate the weekly pay of each employee. Concession Stand.xls

  34. Open up “Candy Sales” and use a function to find the total sales. candysales.xls

  35. Open up “Candy Sales” and use a function to find the average sales. candysales.xls

  36. Open up “Student Grades” and use a function to round the Test Average to 1 decimal place Student grades.xls

  37. ______ represents the rows of a spreadsheet

  38. Numbers

  39. ______ represents the columns of a spreadsheet

  40. Letters

  41. Why would you use a function instead of a formula?

  42. When you are dealing with a lot of information in your spreadsheet, functions can perform calculations a lot quicker than formulas can.=SUM(A1:A6) is a lot easier than =A1+A2+A3+A4+A5+A6

  43. What can you use to copy the formula or function you have entered to multiple cells?

  44. The Fill Handle (clicking and dragging the little black square on the bottom right of the cell)

  45. When you click on a cell, you see its cell address come up in…

More Related