Computerised Accounting

Spreadsheet

Easy

Computerised Accounting

On the ribbon of MS Excel, the formula tab contains which of the following categorised functions?

Lookup and Reference Function

View Function

Developer Function

Page layout Function

✅ Correct Option: 1

The Formulas tab holds the Function Library, where functions are grouped into categories such as Financial, Logical, Text, Date and Time, Lookup and Reference, and Math and Trigonometry. View, Developer and Page Layout are separate ribbon tabs, not function categories.

2025: 30 May Shift 1

What shape is the Fill Handle in Excel?

2025: 15 May Shift 1

Where is the address of the active cell displayed?

2026: 6 June Shift 1

Which step completes an entry and moves the pointer to the cell to the right?

2025: 3 June Shift 1

Array formulas are enclosed between __________.

2025: 4 June Shift 2

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

2023: 29 May Shift 2

Which command reverse the last action performed in the worksheet?

On the ribbon of MS Excel, the formula tab contains which of the following categorised functions?

Solution

Related questions:

Keyboard Shortcuts

CUET Accountancy Past Year Questions (Topic-Wise)