Computerised Accounting

Spreadsheet

Easy

Computerised Accounting

A cell reference identifies the location of a cell or group of cells in the spreadsheet also referred as a

Cell Location

Cell Address

Column Number

Row Number

✅ Correct Option: 2

In spreadsheet applications, a cell reference that identifies the location of a cell or group of cells is technically called a Cell Address.

A cell address combines both the column letter and row number (for example, A1, B5, C10) to uniquely identify each cell's position in the spreadsheet.

While "cell location" is a generic descriptive term, "cell address" is the standard technical terminology used in spreadsheet software like MS Excel or Google Sheets.

Column Number and Row Number are merely components that together form the complete cell address, but individually they cannot identify a specific cell's location.

Correct Answer: Option 2 - Cell Address

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: 4 June Shift 2

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

2026: 29 May Shift 1

In order to set the print area using Print Area Option, arrange the following in a correct sequence.

(A) OPTIONAL: To add more data to the print area select a range of cells.

(B) Select the Page Layout command tab

(D) In the Page Setup group, click Print Area» select Set Print Area. The print area is set

Choose the correct answer from the options given below:

2025: 27 May Shift 1

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

2025: 3 June Shift 2

Which Excel function is used to calculate depreciation under Straight Line Method (SLM)?

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:

A cell reference identifies the location of a cell or group of cells in the spreadsheet also referred as a

Solution

Related questions:

Keyboard Shortcuts

CUET Accountancy Past Year Questions (Topic-Wise)