Thursday, 3 September 2015

Most Recently Asked MS Excel Multiple Choice Questions And Answers

41. When integrating Word and Excel, Word is usually the
a. Server
b. Client
c. Source
d. None of these
Ans: b

42. The number of rows in a worksheet is
a. 36500
b. 65536
c. 256
d. 64536
Ans: b

43. With which of the following all formulas in excel starts?
a. /
b. *
c. $
d. =
Ans: d

44. 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
Ans: b

45. What term describes explanatory text attached to a cell?
a. Context
b. Callout
c. Comment
d. Dialog
Ans: c

46. How we can view a cell comment?
a. Position the mouse pointer over the cell
b. click the comment command on the view menu
c. click the edit comment commands on the Insert menu
d. click the Display comment command on the window menu
 Ans: a

47. 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
Ans: c

48. The default style for new data keyed in a new workbook is ?
a. Comma
b. Normal
c. Currency
d. Percent
Ans: b

49. If you press ___, the cell accepts your typing as its contents ?
a. Tab
b. Ctrl+Enter
c. Enter
d. Alt+Enter
Ans: c

50. Which of the following is an absolute cell reference?
a. !A!1
b. $A$1
c. #a#1
d. A1

Ans: b

More Questions & Answers:-
Page1 Page2 Page3 Page4 Page5

No comments:

Post a Comment