Across
- 2. type of chart to show the difference between the data points for one or more categories.
- 5. A Microsoft program used to calculate numbers (Data)
- 7. write a formula to multiply the values in cell A1 and B1 in sheets
- 9. Allow quickly apply the content for one cell to another cell?
- 10. 3 letters appended to a text file
- 13. type of chart to look at trends or data over a time period.
- 14. type of file that uses commas to separate data
- 17. what is missing in this function: average(c2:c10)
- 19. value returned for this formula: =(82-32)/5+8*2
- 20. Entities that allow you to create online personas. They collect info about you.
- 22. Most popular open source database program (mentioned in Khan Academy)
- 24. You apply this to a sheet to make it look professional
- 25. type of chart to show data as "slices of pie"
- 28. function used to add/summarize numbers in a range
- 29. in sheets columns are?
Down
- 1. You score a 70. based on this formula: =if(a1>70,"pass","fail) did you pass or fail?
- 3. Function used to calculate how many sales are over $20 from a series
- 4. in sheets rows are?
- 6. symbol all formulas begin with?
- 8. Limit the type of data that can be entered into a cell
- 11. Data is collected and stored in what kind of computing devices
- 12. counts all cells in a range that has values, both numbers and letters.
- 15. A google program used to calculate numbers (Data)
- 16. intersection of a row and a column is called
- 18. A group of cells is called
- 21. You create this on sheets to visualize your data
- 23. Combination of numbers and symbols used to express a calculation. Always begins with an = sign
- 26. formula gets the smallest value of a range of cells
- 27. Which Excel function is used to find the highest value in a range
- 28. function to create conditional logic
