Computerised Accounting

Spreadsheet

Easy

Which among the following is not a COUNT function in Excel :

COUNTIF

COUNT BLANK

COUNTA

COUNTFOR

✅ Correct Option: 4

Excel has these COUNT functions: COUNT, COUNTA, COUNTBLANK, COUNTIF, and COUNTIFS. COUNTFOR is not a valid Excel function.

2025: 30 May Shift 2

A _____ is a range of cells that shows the results of substituting different values in one or more formulas.

2023: 20 June Shift 2

The current version of Excel 2007 is now designed with a series of horizontal tables knows as ______

2023: 29 May Shift 2

Which command reverse the last action performed in the worksheet?

2026: 23 May Shift 2

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

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:

2025: 30 May Shift 1

What shape is the Fill Handle in Excel?

Solution