1 / 41

Excel Review

Excel Review. What is a software tool used for entering, calculating, manipulating and analyzing sets of numbers?. Excel. What can the spreadsheet program be used for? Provide two examples. Entering grades keeping attendance record Budgeting creating graphs.

evita
Download Presentation

Excel Review

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 Review

  2. What is a software tool used for entering, calculating, manipulating and analyzing sets of numbers?

  3. Excel

  4. What can the spreadsheet program be used for? Provide two examples.

  5. Entering grades • keeping attendance record • Budgeting • creating graphs

  6. In a spreadsheet program, what is the document called that you do your work in?

  7. Worksheet

  8. What is the intersection of any column and row called?

  9. Cell

  10. What is an example of a cell location or a cell address?

  11. A3 • C6

  12. What calculates numbers based on values in other cells?

  13. Formulas

  14. What is a group of cells in a column, a row, or even a group that includes several rows and columns?

  15. Range

  16. Can you edit worksheet data directly in a cell or in the formula bar?

  17. Yes

  18. What are some of the advantages of using Charts and Graphs to display information?

  19. Easy to see information • Easy to compare information • Easy to understand information

  20. How can sheet tabs be renamed?

  21. Double clicking on the sheet tab and typing text

  22. Can additional worksheets be inserted into an Excel workbook if more sheets are needed?

  23. Yes

  24. What can be inserted into a cell in Excel?

  25. Numbers • Text • Formulas

  26. How many sheets are in the worksheet below?

  27. 3

  28. What is the name of this button?

  29. Merge and center

  30. What is the active cell in the diagram below?

  31. A1

  32. What is this a picture of?

  33. The drawing toolbar

  34. What is the formula to find the totals for cell E5?

  35. =sum(B5:D5)

  36. What is the name of the worksheet the data below is located in?

  37. Student Grades

  38. What is the formula to find the average of the 3 tests for the worksheet diagram below?

  39. =AVERAGE(B5:D5)

  40. What does the EDIT/FILL function do in Microsoft Excel?

  41. It uses the formula that was used in a particular cell and then applies that formula for the highlighted cells.

More Related