Microsoft Excel Quiz Questions and Answers - MS Excel MCQ - Page 7

(Showing: 61 - 70 out of 125 MCQs)

Microsoft Excel Quiz Questions and Answers from MS Office topic. These MS Excel mcq are important for the banking examinations. Important MS Office Computer Awareness Questions Answers (mcq) listing for techincal aptitude for IBPS PO , MT Exam, Bank PO, Clerk, SBI, RBI and other competitive.

61. Which is not the function of "Edit, Clear" command?
[A] Delete contents
[B] Delete notes
[C] Delete cells
[D] Delete formats
Loading...
62. To select an entire column in MS-EXCEL, press?
[A] CTRL + C
[B] CTRL + Arrow key
[C] CTRL + S
[D] None of the above
Loading...
63. To return the remainder after a number is divided by a divisor in EXCEL we use the function?
[A] ROUND ( )
[B] FACT ( )
[C] MOD ( )
[D] DIV ( )
Loading...
64. Which function is not available in the Consolidate dialog box?
[A] Pmt
[B] Average
[C] Max
[D] Sum
Loading...
65. In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
[A] AutoFill
[B] Auto correct
[C] Auto sum
[D] Auto format
Loading...
66. What do you mean by a Workspace?
[A] Group of Columns
[B] Group of Worksheets
[C] Group of Rows
[D] Group of Workbooks
Loading...
67. MS-EXCEL is based on .........?
[A] WINDOWS
[B] DOS
[C] UNIX
[D] OS/2
Loading...
68. Which area in an Excel window allows entering values and formulas?
[A] Title Bar
[B] Menu Bar
[C] Formula Bar
[D] Standard Tool Bar
Loading...
69. Multiple calculations can be made in a single formula using .......
[A] Standard Formulas
[B] Array Formula
[C] Complex Formulas
[D] Smart Formula
Loading...
70. An Excel Workbook is a collection of .......
[A] Workbooks
[B] Worksheets
[C] Charts
[D] Worksheets and Charts
Loading...
Are these questions helpful for you?

Comments: (Your feedback is valuable to us)