Practicing Success

Target Exam

CUET

Subject

Accountancy

Chapter

Spreadsheet

Question:

In which function results can be displayed in Autocalculate?

Options:

MAX and LOOK

SUM and AVERAGE

LABEL and AVERAGE

MIN and BLANK

Correct Answer:

SUM and AVERAGE

Explanation:

The correct answer is Option (2) - SUM and AVERAGE.

In an Autocalculator or spreadsheet program like Microsoft Excel or Google Sheets, the SUM function is used to calculate the total of a range of values, and the AVERAGE function is used to calculate the average of a range of values. These functions are commonly used to display results in a spreadsheet for various calculations.