Use Spreadsheet Functions and Formulas Answers

3 verified answers2 views

Which of the following best describes the subtotal feature in spreadsheet software?

a formatting tool that adds background color to selected cells

a function that obtains a subtotal on selected data

a function that totals all values and subtotals in a range

a formula used to display values in scientific notation

Which of the following correctly describe cell protection in spreadsheet software? Choose all that apply.

Cell protection is a security feature used to limit changes and visibility of data.

The contents of an unlocked cell cannot be modified.

By default, cells are locked and not hidden.

Once activated, cell protection is guaranteed.

Which of the following can be done by using conditional formatting?

Calculate quarterly sales.

Highlight all “no” responses.

Count the number of students in high school.

Calculate average scores on a math test.

Did you find these answers helpful?

More from this Course