AfterBoards Logo
Skip to main contentSkip to solution

CUET Accountancy 2025 PYQs2 June Shift 2. Free, no login required.

Computerised Accounting

past year questions, CUET Accountancy 2025 2 June Shift 2

Spreadsheet

past year questions, Computerised Accounting, CUET Accountancy 2025 2 June Shift 2

Easy

Computerised Accounting

Which function is used to remove spaces before and after the text?

Solution

✅ Correct Option: 4

The TRIM function is used to remove spaces before and after the text.

The TRIM function removes all leading spaces (spaces before text) and trailing spaces (spaces after text) from a text string. In most spreadsheet applications, it also reduces multiple spaces between words to a single space.

Example:

If cell A1 contains: " Hello World " (with spaces before and after)

Using =TRIM(A1) will return: "Hello World" (spaces removed)

The other options serve different purposes:

  • DUPLICATE: Creates copies of data
  • REMOVE: Not a standard function for removing spaces
  • DELETE: Used to delete cells or data entirely, not for text manipulation

Related questions:

2025: 27 May Shift 2

What is the expanded form of the accounting equation when incorporating revenues and expenses?

2026: 20 May Shift 1

Arrange the following steps related to freezing the formula using paste special command in logical sequence

(A) Click on Home Tab and select Copy symbol

(B) In the Paste Special box, under paste select the radio button next to Values and click OK

(C) Select the cell (s) that contains the formula

(D) Click on Paste tab and select Paste Special

Choose the correct sequence from the options given below:

2026: 23 May Shift 2

Which key, when pressed, display the access keys in MS Excel ?

2026: 20 May Shift 1

Which of the following arguments in a financial function represents the total number of payments?

2025: 30 May Shift 1

What shape is the Fill Handle in Excel?

2026: 29 May Shift 2

Match the LIST-I with LIST-II

LIST-ILIST-II
A.Depreciation using Straight Line MethodI.=PMT(rate, nper, pv, [fv], [type])
B.Depreciation using Written Down Value MethodII.=SLN(cost, salvage, life)
C.Computation of Installment of LoanIII.Drop Down List
D.Data ValidationIV.= DB(cost, salvage, life, period, [month])

Choose the correct answer from the options given below:

Keyboard Shortcuts

  • Left arrow: Previous question
  • Right arrow: Next question
  • S key: Jump to solution
  • Q key: Jump to question

CUET Accountancy Past Year Questions (Topic-Wise)