Here are the answers to your questions:
Question 20: Quitting unused apps on a smartphone or tablet can _____.
- Options:
- reduce CPU usage
- improve battery life
- free up memory
- Answer: All of the above options (reduce CPU usage, improve battery life, free up memory) are correct. However, if you have to choose one, "reduce CPU usage" is a common focus.
Question 21: In a spreadsheet, a(n) _____ can be used to compute a cell's value based on other cells' values.
- Options:
- number
- formula
- address
- chart
- Answer: formula
Question 22: In a spreadsheet, a(n) _____ like AVERAGE is a pre-built set of instructions for performing a calculation.
- Options:
- function
- address
- query
- protocol
- Answer: function
Question 23: Which is NOT a common use of spreadsheets?
- Options:
- Displaying a table of data, like a table showing recent home sales
- Drawing a chart, like a chart showing stock prices over the past year
- Creating formatted text, like a resume that nicely shows a person's education/experience
- Performing calculations, like adding a restaurant's daily sales into a month's total sales
- Answer: Creating formatted text, like a resume that nicely shows a person's education/experience (spreadsheets are not typically used for formatted documents like resumes).