Computerised Accounting

Spreadsheet

Easy

Computerised Accounting

Which function results can be displayed in AutoCalculate?

SUM and AVERAGE

MAX and LOOK

LABEL and AVERAGE

MIN and BLANK

✅ Correct Option: 1

AutoCalculate shows quick results for a selected range on the status bar, including Sum, Average, Count, Maximum and Minimum. Among the options only SUM and AVERAGE are both valid AutoCalculate functions; LOOK, LABEL and BLANK are not.

2026: 21 May Shift 1

Arrange the following in sequence while calculating depreciation using straight line method.

(A) Life of Asset

(B) Salvage Value of Asset

Choose the correct answer from the options given below:

2025: 30 May Shift 2

What happens when you select "Warning" style in the Error Alert tab?

2026: 23 May Shift 2

Which key, when pressed, display the access keys in MS Excel ?

2025: 30 May Shift 1

What shape is the Fill Handle in Excel?

2025: 14 May Shift 1

The best way to get started in Excel 2007 is to click the ____.

2025: 4 June Shift 2

Which Excel function is commonly used to calculate loan repayment instalments?

Which function results can be displayed in AutoCalculate?

Solution

Related questions:

Keyboard Shortcuts

CUET Accountancy Past Year Questions (Topic-Wise)