Computerised Accounting

Spreadsheet

Easy

Order of mathematical operations in solving data in electronic spreadsheet

(A) * Multiplication

(B) + Addition

(C) ( ) Brackets

(D) / Division

Choose the correct answer from the options given below:

(A), (B), (C), (D)

(C), (A), (D), (B)

(B), (A), (D), (C)

(C), (B), (D), (A)

✅ Correct Option: 2

Electronic spreadsheets follow the standard mathematical order of operations, commonly known as BODMAS.

The order of priority for operations is:

1. Brackets ( ) - Highest Priority

2. Division and Multiplication - Second Priority

3. Addition (+) and Subtraction (-) - Lowest Priority

From the choices given:

2025: 14 May Shift 1

Which of the following is not a types of graphs and charts

2026: 13 May Shift 2

Match List-I with List-II.

List-I	List-II
(A) Depreciation using Straight Line Method	(I) =PMT(Rate, Nper, Pv, Fv, Type)
(B) Depreciation using Written Down Value Method	(II) =SLN(cost, salvage, life)
(C) Computation of Installment of Loan	(III) Use Drop Down List
(D) Data Validation	(IV) = DB(Cost, Salvage, Life, Period, Month)

Choose the correct answer from the options given below:

2026: 23 May Shift 2

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

2026: 31 May Shift 1

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

2025: 30 May Shift 2

______ feature allows us to create a cross tabulation summary of data in which heading can subsequently moved to give different views of the data.

2025: 22 May Shift 1

The following elements are important for salary computation and its payment:

(A) Grade Pay (GP)

(B) Dearness Allowance (DA)

(D) Goods and Service Tax (GST)

Choose the correct answer from the options given below:

Solution