CUET Accountancy - Which formula can be used to prevent leading or trailing spaces in a data validation rule? | PYQs + Solutions

CUET Accountancy 2025 31 May Shift 1

Computerised Accounting

Medium

Computerised Accounting

=TRIM(A1)=A1

=LEN(A1)>10

=ISNUMBER(A1)

=WEEKDAY(A1)<>1

✅ Correct Option: 1

Related questions:

22 May Shift 1

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.

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

Choose the correct answer from the options given below:

2 June Shift 2

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

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?

CUET Accountancy 2025 31 May Shift 1 PYQs

Keyboard Shortcuts