Computerised Accounting

Spreadsheet

Easy

Computerised Accounting

Following are the steps related to preparation of charts, arrange them in a correct sequence.

(A) Save a chart.

(B) Create a basic chart using the pattern from the panel available on top of the worksheet in 'Chart groups' option.

(C) Change the layout or style of chart

(D) Enter data on a worksheet with proper column and row titles.

Choose the correct answer from the options given below:

(C), (B), (D), (A)

(A), (C), (B), (D)

(B), (A), (D), (C)

(D), (B), (C), (A)

✅ Correct Option: 4

The logical sequence for preparing charts follows the natural workflow:

Step 1: Enter data on a worksheet with proper column and row titles (D)

Data must exist before creating any chart

Step 2: Create a basic chart using the pattern from the panel available on top of the worksheet in 'Chart groups' option (B)

Once data is available, the basic chart can be created from it

Step 3: Change the layout or style of chart (C)

After the basic chart is created, customization can be done

Step 4: Save a chart (A)

Finally, the completed chart is saved

The correct sequence is: D → B → C → A

This matches Option 4: (D), (B), (C), (A)

Correct Answer: Option 4

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: 14 May Shift 1

Which of the following is not a types of graphs and charts

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: 27 May Shift 1

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

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: 13 May Shift 1

Order of mathematical operations in solving data in electronic spreadsheet

(A) * Multiplication

(B) + Addition

(D) / Division

Choose the correct answer from the options given below:

Solution

Related questions:

Keyboard Shortcuts

CUET Accountancy Past Year Questions (Topic-Wise)