Center for Professional Excellence

...

7. The maximum number of IF functions that can be nested as value_if_true and value_if_false

arguments is:(a) 4 (b) 16 (c) 32 (d) 64

8. In an MS Excel worksheet when you subtotal a horizontal range such as

SUBTOTAL(109,A2:K2,A3:K3) then in the given range hiding any:(a) column or row will not affect the subtotal

(b) column will not affect the subtotal but hiding a row will affect the subtotal

(c) row will not affect the subtotal but hiding a column will affect the subtotal

(d) column or row will affect the subtotal9. In an MS Excel worksheet you can display $ symbol with numeric values automatically if you

select the number format:

(a) Accounting only (b) Currency only

(c) both Accounting and Currency simultaneously (d) either Accounting or Currency

10. In an Excel worksheet, age of employees is stored in column B and their annual earning is

stored in column C. Which of the following formula will give the number of employees who

are more than 40 years old and have earning of Rs. 600,000 per annum or more?

(a) =COUNTIFS(B2:B101,">=40",C2:C101,">=600,000")

(b) =COUNTIFS(B2:B101,">40",C2:C101,">=600,000")

(c) =COUNTA(B2:C101,"B2:B101>40",C2:C102,">600,000")

(d) =COUNTA(B2:B101,">40",C2:C101,"=600,000")

11. In MS Excel, the sequence of steps to show/hide the gridlines is:(a) Page Layout >> Sheet options>> Gridlines >> View

(b) View >> Show >> Gridlines

(c) Home >> Font >> Borders >> No Border

(d) Both (a) and (b)

12. In MS Excel, the keyboard shortcut to insert current date in a cell is:(a) CTRL + D (b) CTRL + T (c) CTRL + ; (d) CTRL + /

13. In conditional formatting feature of MS Excel, we can:(a) use a formula to determine which cells to format

(b) format values that are above or below average

(c) format unique or duplicate values

(d) all of the above

14. Which of the following statements regarding protection of an MS Excel worksheet is correct?(a) Locking cells or hiding formula has no effect until you protect the worksheet

(b) Locking cells or hiding formula is effective as soon as you apply it

(c) A worksheet can be protected only if you apply hiding formula option

(d) A worksheet is protected automatically if you apply hiding formula option

15. Which of the following statements regarding shared MS Excel worksheet is NOT correct:(a) You can merge any two cells

(b) You can remove personal information from it

(c) You cannot remove comments from it

(d) Both (a) and (b)

16. In an MS Excel workbook:(a) you cannot save a worksheet as a web page

(b) you can have different personalized header and footer for different worksheets of the

same workbook

(c) you cannot insert comments on each cell

(d) you cannot protect a worksheet and still share it with others

17. An MS Excel worksheet contains data spread over 10 columns and a number of rows. On

print preview, it is observed that one column and a few rows are out of page boundary. The

quickest way of adjusting the data on one page is to:(a) adjust margins in Page Setup

(b) print it on a slightly bigger size of paper

(c) view and adjust page size in Page Break Preview

(d) set print area in Page Layout

18. In MS Excel, if the number format of a cell has been customised to “+##-42-####-####” and

12345678 is entered in the cell, it will be displayed as:(a) +12-42-3456-78 (b) 42-1234-5678

(c) +12-42-3456-78## (d) +-42-1234-5678

19. The most efficient way to increase the readability of large numeric values stored in a particular

column of an MS Excel worksheet is to select the column and then:(a) go to Format Cells: Number>> Select category Number>> Check ‘use 1000 separator’ >>

OK

(b) apply Bold font format

(c) apply Comma Style

(d) go to Format Cells: Number >> Select category custom>> Type: ###,###.00 >>OK

20. If you unprotect a protected worksheet in MS Excel and later close the workbook after making the desired changes then the next time when you open that workbook:

(a) the worksheet will open as protected sheet

(b) the worksheet will open as unprotected sheet

(c) the worksheet will not reflect the changes made by you

(d) will contain two copies of the worksheet, i.e. the modified worksheet and the original

protected worksheet21. Which of the following statements is correct regarding ‘hide’ feature of MS Excel?(a) You can hide more than one worksheet

(b) You can hide an entire workbook without actually closing it

(c) Both (a) and (b)

(d) You cannot hide more than one worksheet

22. MS Excel can import data from which of the following