". VdoTips: MS EXCEL PRACTICE SET

APPLY LATEST GOVT JOBS

hi

MS EXCEL PRACTICE SET

16. Concatenation of text can be done using
(A)Apostrophe (&lsquo)
(B)Exclamation (!)
(C)Hash (#)
(D)Ampersand (&)


17. Data can be arranged in a worksheet in a easy to understand manner using
(A)auto formatting
(B)applying styles
(C)changing fonts
(D)all of above


18. You can use drag-and-drop to embed excel worksheet data in a word document
(A)By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
(B)By dragging a range of excel data to the word button on the taskbar while pressing Shift key
(C)By dragging a range of excel data to the word button on the taskbar while pressing Alt key
(D)None of above


19. The auto calculate feature
(A)Can only add values in a range of cells
(B)Provides a quick way to view the result of an arithmetic operation on a range of cells
(C)Automatically creates formulas and adds them to a worksheet
(D)A and c


20. Excel uniquely identifies cells within a worksheet with a cell name
(A)Cell names
(B)Column numbers and row letters
(C)Column letters and row numbers
(D)Cell locator coordinates