1 / 31

Spreadsheet Review

Spreadsheet Review. Press F5 NOW to start the PowerPoint. Do columns or rows run horizontally ?. Rows. What is the Active cell?. Current cell you are in. Which of these is a Cell address: a. D5 b. D:5 c. D/5. D5 (Just a letter and a number).

jui
Download Presentation

Spreadsheet 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. SpreadsheetReview Press F5 NOW to start the PowerPoint.

  2. Do columns or rows run horizontally ?

  3. Rows

  4. What is the Active cell?

  5. Current cell you are in

  6. Which of these is a Cell address:a. D5 b. D:5 c. D/5

  7. D5 (Just a letter and a number)

  8. How were the category headers aligned: Left, Right, or Center?

  9. Center

  10. What type of number format was used on the numbers: General, Currency, or Percentage?

  11. $ means Currency

  12. What chart shows data changes over time: column, line, or pie?

  13. Line Chart

  14. What are mathematical equations called in spreadsheets: a. formulasb. expressionsc. currency

  15. Formulas

  16. Use the spreadsheet to solve the following formula:(C7 - C8)/2

  17. 4

  18. Which column controlled the sort (find the column that is in order)?

  19. Office is the only column in an order

  20. Determine which of the following functions was used to get each of the answers on Row 10: Average, Count, Maximum, Sum.

  21. Max Average Count Sum

  22. What kind of chart is this?

  23. Column

  24. What does a chart Legend show?

  25. What the colors on the chart represent

  26. Is this data sorted in Ascending or Descending order?

  27. High to Low = Descending

  28. What type of chart is used to compare a piece of data to a whole: column, line, or pie?

  29. Pie

  30. How many cities made less than 350 in sales for the Q2 Sales?

  31. 5

More Related