Computerised Accounting

Spreadsheet

Easy

Computerised Accounting

Which key combination collapses the ribbon?

[Ctrl]+[F1]

[Ctrl]+[F3]

[Ctrl]+[F5]

[Ctrl]+[F7]

✅ Correct Option: 1

Ctrl+F1 toggles the ribbon between the expanded and collapsed state in Excel and other Office applications, freeing worksheet space.

2025: 30 May Shift 2

What is the maximum number of columns that a data validation form in Excel can display?

2025: 27 May Shift 1

By default cell reference is

2022: 15 July Shift 2

In which cell is the rate for PMT function where = PMT (C8, C9, C10, C11, C12)

2026: 6 June Shift 1

Match List-I with List-II

List-I	List-II
(A) Interest rate per period for the loan	(I) Type
(B) Total number of payments for the loan. Its unit (e.g. year) should match with the unit of the interest rate	(II) Rate
(C) Whether payment is made at the beginning (value=1) or at the end (value=0) of the period	(III) FV
(D) Future value, which is taken as 0, is the balance at the end of the loan period	(IV) Nper

Choose the correct answer from the options given below:

2025: 27 May Shift 2

The LOOKUP function has two syntax forms:

2025: 27 May Shift 1

__________ is the function which adds the cells as per given specified criteria.

Solution