Computerised Accounting

Spreadsheet

Easy

Computerised Accounting

What does the "cell reference" in a formula typically consist of?

The row number followed by the column letter

The column letter followed by the row number

The sheet name only

The file path

✅ Correct Option: 2

A cell reference in a spreadsheet formula identifies a specific cell's location using the column letter followed by the row number.

For example:

A1 refers to the cell in Column A, Row 1
B5 refers to the cell in Column B, Row 5
Z100 refers to the cell in Column Z, Row 100

This format allows formulas to reference values from specific cells. When you write a formula like =A1+B1, the spreadsheet knows exactly which cells to fetch values from.

Option 1 is incorrect because it reverses the order (e.g., 1A instead of A1), which is not the standard convention.

Option 3 (sheet name only) is incomplete as it doesn't pinpoint a specific cell within that sheet.

Option 4 (file path) is used for linking external files, not for basic cell referencing within a worksheet.

2025: 22 May Shift 1

Which combination is true in respect of using a graph/chart?

(A) Quicker and easier to create a chart immediately to see the possible relationship of variables to one another, rather than paging through raw data.

(B) Provide information in as little time as possible.

(C) Graphs do not have the ability to take large amounts of information and make them into exhibitions that are easily used to persuade

(D) A graph may be either a single line graph or a multi-line graph.

2025: 30 May Shift 1

Which of the following is NOT a method to create a drop-down list for data validation?

2026: 13 May Shift 2

Match List-I with List-II.

List-I	List-II
(A) Depreciation using Straight Line Method	(I) =PMT(Rate, Nper, Pv, Fv, Type)
(B) Depreciation using Written Down Value Method	(II) =SLN(cost, salvage, life)
(C) Computation of Installment of Loan	(III) Use Drop Down List
(D) Data Validation	(IV) = DB(Cost, Salvage, Life, Period, Month)

Choose the correct answer from the options given below:

2025: 4 June Shift 2

How do you display or hide the horizontal and vertical axes in a chart?

2025: 13 May Shift 1

Using MS Excel, we can create a basic chart by the following steps.

(A) On clicking of Start symbol we will get Programs option

(B) Click on Insert tab to get tools for chart

(D) On selecting MS Excel 2007 program it will provide a blank workbook with a Ribbon displayed at the top.

Choose the correct answer from the options given below:

2025: 27 May Shift 1

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

What does the "cell reference" in a formula typically consist of?

Solution

Related questions:

Keyboard Shortcuts

CUET Accountancy Past Year Questions (Topic-Wise)