Question

Which two statements regarding spreadsheet functions are true?

1) Spreadsheet functions are predefined formulas that use values, referred to as arguments, to perform calculations.
2) A spreadsheet function always begins with the hash sign (#).
3) Spreadsheet functions are used to create tables and charts in spreadsheets.
4) Spreadsheet functions can only be used in Microsoft Excel.
5) Spreadsheet functions are case-sensitive.

Answer 1

The two true statements regarding spreadsheet functions are:

Spreadsheet functions are predefined formulas that use values, referred to as arguments, to perform calculations.

Spreadsheet functions are case-sensitive.

Options 1 and 5 are the correct statements.

Step-by-step explanation:

Predefined Formulas: Spreadsheet functions are indeed predefined formulas designed to perform specific calculations. Users input values, known as arguments, into these functions to obtain calculated results.

Case Sensitivity: Spreadsheet functions are case-sensitive, meaning the function names must be entered with the correct letter case (e.g., "SUM" and "sum" may be interpreted differently).

Statements 2, 3, and 4 are false. A spreadsheet function does not begin with a hash sign (#), they are not primarily used to create tables and charts (option 3), and they are not exclusive to Microsoft Excel (option 4).

Options 1 and 5 are the correct statements.