Computerised Accounting

Spreadsheet

Easy

Computerised Accounting

Array formulas are enclosed between __________.

Square Brackets [ ]

Braces { }

Inverted Commas ' '

Double Inverted Commas " "

✅ Correct Option: 2

Array formulas in spreadsheet applications like Microsoft Excel are enclosed between braces { }.

When you enter an array formula using Ctrl+Shift+Enter, the application automatically adds curly braces around the formula to indicate that it should be processed as an array formula. For example: {=SUM(A1:A10*B1:B10)}

You cannot manually type these braces - they appear only when the formula is entered correctly as an array formula using the special key combination.

Correct Answer: Option 2 - Braces { }

2025: 30 May Shift 1

How is an absolute cell reference indicated?

(A) With a # sign before the cell

(B) With a $ sign before the column and/or row

(D) With a $ sign before the column and/or row

Choose the correct answer from the options given below:

2025: 27 May Shift 1

$C4 or C$4 is an example of __________ reference.

2022: 20 Aug Shift 2

The data that is entered in a cell may be either:

A. Numeric

B. Alpha-Numeric

C. Date

D. Label

Choose the correct answer from the options given below:

2025: 4 June Shift 2

Which Excel function is commonly used to calculate loan repayment instalments?

2025: 15 May Shift 2

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

2025: 3 June Shift 2

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

Array formulas are enclosed between __________.

Solution

Related questions:

Keyboard Shortcuts

CUET Accountancy Past Year Questions (Topic-Wise)