[Forest Guard, 2022]
10. In a computer spreadsheet, SUM, AVERAGE, MIN and MAX are examples of _______
Calculations
Formulas
Functions
Relative addressing
Correct Answer :
Functions
The correct answer is (c) Functions.
In a computer spreadsheet, SUM, AVERAGE, MIN, and MAX are examples of functions. Functions are built-in formulas that perform specific calculations or operations in a spreadsheet. They are designed to simplify common mathematical or statistical tasks, and they can be used to quickly calculate totals, averages, minimums, maximums, and other values based on the data in the spreadsheet.
Option (a) Calculations and option (b) Formulas are related to functions, but they are not the same thing. Calculations refer to any mathematical or statistical operation performed on data in a spreadsheet, while formulas are combinations of values, operators, and functions that are used to calculate a result.
Option (d) Relative addressing refers to a method of referring to cells in a spreadsheet based on their position relative to the current cell. It is used in formulas and functions to make them easier to copy and reuse in different parts of the spreadsheet.
Therefore, the correct answer is (c) Functions.