Excel 2016 Dca n4m6b

DCA TEST (EXCEL)

Name : ……………………………………

1. Cell address A$4 in a formula means it is a (A) Relative cell reference (B) Absolute cell reference

(C) Mixed cell reference (D)All of the above

2. When you create a chart on a separate sheet in the same workbook it is called a (A) Chart sheet

(B) Embedded chart

(C) View sheet

(D) View chart

(C) (a) and (b)

(D) None of these

3. "In Excel, shortcut fill menu contain" (A) Fill weekdays

(B) Fill series

4. Paste Special dialog box of Excel contains _____ options for (A) Characteristics

(B) Formats Formulas

(C)Values

(D)All of the above

5. The built-in default copying in Excel is programmed to (A) Use relative position when copying formulas

(B) Use absolute position when copying formulas

(C) Use mixed position when copying formulas

(D) None of the above

6. “=ROUND(2.15,1) entered in a cell displays" (A) 2

(B) 2.1

(C) 2.2

(D) None of the above

7. The default page orientation in Excel is (A) Landscape

(B) Horizontal

(C) Portrait

(D) None of the above

8. “=MOD(-3,2) entered in a cell displays" (A)

-1

(B) 1

(C) -1.5

(D) 0

9. Which one of the following can be entered as a number in a cell? (A) "1,300.00"

(B) (5000.00)

(C) 1.1e+2

(D)All of the above

10. With which of the following all formulas in excel starts? A.

/

B.

*

C.

$

D.

=

11. On an excel sheet the active cell in indicated by? A. A dotted border

B. A dark wide border

C. A blinking border

D. By italic text

12. What term describes explanatory text attached to a cell? A. Context

B. Callout

C. Comment

D. Dialog

13. Which of these will not select all the cells in a document? A. Using the Edit – Select All menu

B. Pressing Ctrl + A on the keyboard

C. Clicking three times with the right mouse button in the spreadsheet 14. The default style for new data keyed in a new workbook is? A. Comma

B. Normal

C. Currency

D. Percent

15. Which of the following keyboard shortcut can be used for creating a chart from the selected cells ? A. F11

B. F10

C. F4

D. F2

16. A value used in a formula that does not change is called a ? A. Constant

B. Cell address

C. Varaible

D. Static

C. rows and columns

D. None of above

17. A Spreadsheet contains? A. columns

B. rows

18. To open an existing workbook, click the Open button on the ___ toolbar? A. Form

B. Standard

C. Drawing

19. Which among following is associated with excel?

D. Formatting

A. Graphic program

B. Word Processor

C. Presentation

D. Spreadsheet

20. The cell reference for a range of cells that starts in cell C1 and goes over to column H and down to row 10 is ? A. C1:10H

B. C1:H10

C. C1:H-10

D. C1:H:10

21. Except which of the following function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result ? A. NOT

B. OR

C. IF

D. AND

22. Which of the following is not a valid Zoom percentage in Excel? A. 10

B. 100

A. Cell Value

C. 300 B. Formula

D. 500 C. Both of above

D. None of above

23. Which function calculates your monthly mortage payment ? A. PV

B. NPER

C. PMT

D. All of above

24. Which types of charts can excel produce? A. Line graphs and pie charts only

B. Bar charts, line graphs and pie charts

C. Bar charts and line graphs only

D. Only line graphs

25. How is data organized in a spreadsheet? A. Rows and columns

B. Layers and planes

C. Lines and spaces

D. Height and width

26. VLOOKUP function used to? A. Finds related records

B. Looks up text that contain "v"

C. Check if two cells are identical

D. None of above

27. Gridlines may be turned off for display but turned on for printing. A. True

B. False

28. How do you change column width to fit the contents? A. Single-click the boundary to the left to the column heading B. Double click the boundary to the right of the column heading C. Press Alt and single click anywhere in the column D. All of above 29. To insert three columns between columns A and B you would A. Select column A

B. Select A and B

C. Select B

D. All of above

30. To drag a selected range of data to another worksheet in the same workbook, use the ? A. Ctrl key

B. Shift key

C. Alt key

D. Tab key

31. You can activate a cell by? A. Pressing the Tab key

B. Clicking the cell

C. Pressing an arrow key

32. Extension of MS-Excel File is A. .excel

B. .xls

C. .slx

D. None of the above

C. 20

D. Not Fixed

33. Default row height of a cell is A. 12

B. 15

D. All of above