Computerised Accounting

Spreadsheet

Easy

Computerised Accounting

Which formula would result in TRUE if C4 is less than 10 and D4 is less than 100?

=AND(C4>10, D4>10).

=AND(C4>10, C4<100).

=AND(C4>10, D4<10).

=AND(C4<10, D4<100).

✅ Correct Option: 4

The AND function returns TRUE only when every condition inside it is TRUE. The two conditions required are C4 less than 10 and D4 less than 100, which translate to C4<10 and D4<100. Hence =AND(C4<10, D4<100). The other options test the wrong direction or the wrong cell.

2025: 3 June Shift 1

Array formulas are enclosed between __________.

2026: 6 June Shift 1

When Extend Selection is active, what is the keyboard shortcut for selecting all data up to and including the last row?

2025: 2 June Shift 2

Which function returns the cumulative interest paid between two periods?

2025: 30 May Shift 1

How do you add the Data Form button to Excel's Quick Access Toolbar? Click Quick Access Toolbar arrow

(A) Add

(B) All Commands

(D) More Commands

2026: 29 May Shift 2

Which function results can be displayed in AutoCalculate?

2023: 29 May Shift 2

How many blank worksheet(s) are shown, by default when a new workbook is created?

Which formula would result in TRUE if C4 is less than 10 and D4 is less than 100?

Solution

Related questions:

Keyboard Shortcuts

CUET Accountancy Past Year Questions (Topic-Wise)