AfterBoards Logo
Skip to main contentSkip to solution

CUET Accountancy 2025 PYQs3 June Shift 1. Free, no login required.

Computerised Accounting

past year questions, CUET Accountancy 2025 3 June Shift 1

Spreadsheet

past year questions, Computerised Accounting, CUET Accountancy 2025 3 June Shift 1

Easy

Computerised Accounting

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?

Solution

✅ Correct Option: 1

The IF function follows the syntax: =IF(logical_test, value_if_true, value_if_false)

Since the passing criteria is 40% and above, we need to check if the value in A1 is greater than or equal to 40%.

Analyzing the options:

Option 1: =IF(A1>=40%,"PASS","FAIL")

  • Logical test: A1>=40% (checks if marks are 40% or more)
  • If true: displays "PASS"
  • If false: displays "FAIL"
  • This correctly implements the passing criteria ✓

Option 2: =IF(A1<40,"PASS","FAIL")

  • Uses wrong comparison operator (less than instead of greater than or equal to)
  • Would display "PASS" for marks below 40, which is incorrect

Option 3: =IF(A1>=40,"FAIL","PASS")

  • Has correct logical test but reversed results
  • Would display "FAIL" for marks 40% and above, which is incorrect

Option 4: =IF(A1+40,"PASS","FAIL")

  • Uses arithmetic operation (A1+40) instead of logical comparison
  • Not a valid logical test

Option 1 correctly checks if the percentage is 40% or above and returns "PASS", otherwise "FAIL".

Related questions:

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

2025: 31 May Shift 1

In Excel terminology, what is the area that contains the entire chart called?

2025: 3 June Shift 2

What is the difference between TODAY() and NOW() Function?

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.

2022: 30 Aug Shift 2

How many blank worksheets are shown when a new workbook is created.

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

(C) Select the range of cells to print

(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:

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)