Computerised Accounting

Spreadsheet

Easy

Computerised Accounting

Which function results can be displayed in Auto Calculate?

SUM and AVERAGE

MAX and LOOK

LABEL and AVERAGE

MIN and BLANK

✅ Correct Option: 1

The AutoCalculate area on the Excel status bar displays quick results such as Sum, Average, Count, Minimum and Maximum for the selected cells. LOOK, LABEL and BLANK are not Excel functions, so only the pair SUM and AVERAGE is valid.

2026: 29 May Shift 2

Which category of functions is used in the formula of PMT?

2025: 22 May Shift 1

The following elements are important for salary computation and its payment:

(A) Grade Pay (GP)

(B) Dearness Allowance (DA)

(D) Goods and Service Tax (GST)

Choose the correct answer from the options given below:

2025: 31 May Shift 1

In a chart, what do data points represent?

2025: 13 May Shift 2

Which is not the Elements of a Chart/graph-

2025: 3 June Shift 1

What would be the syntax for "IF" Function to get a result of Pass or Fail If Passing criteria is 40% and above. Further percentage of marks is available in Cell A1?

2025: 30 May Shift 2

A _____ is a range of cells that shows the results of substituting different values in one or more formulas.

Which function results can be displayed in Auto Calculate?

Solution

Related questions:

Keyboard Shortcuts

CUET Accountancy Past Year Questions (Topic-Wise)