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

(Showing: 51 - 60 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.

51. In the formula, which symbol specifies the fixed columns or rows?
[A] $
[B] *
[C] %
[D] &
Loading...
52. What is the short cut key to highlight the entire column?
[A] Ctrl+C
[B] Ctrl+Enter
[C] Ctrl+Page Up
[D] Ctrl+Space Bar
Loading...
53. What does COUNTA () function do?
[A] counts cells having alphabets
[B] counts empty cells
[C] counts cells having number
[D] counts non-empty cells
Loading...
54. How do you wrap the text in a cell?
[A] Format, cells, font
[B] Format, cells, protection
[C] Format, cells, number
[D] Format, cells, alignment
Loading...
55. How do you display current date only in MS Excel?
[A] date ()
[B] Today ()
[C] now ()
[D] time ()
Loading...
56. How do you display current date and time in MS Excel?
[A] date ()
[B] Today ()
[C] now ()
[D] time ()
Loading...
57. Which Chart can be created in Excel?
[A] Area
[B] Line
[C] Pie
[D] All of the above
Loading...
58. What will be the output if you format the cell containing 5436.8 as '#,##0.00' ?
[A] 5430
[B] 5436.80
[C] 5436.8
[D] 6.8
Loading...
59. How do you rearrange the data in ascending or descending order?
[A] Data, Sort
[B] Data, Form
[C] Data, Table
[D] Data Subtotals
Loading...
60. Microsoft Excel is a powerful ...........
[A] Word processing package
[B] Spreadsheet package
[C] Communication S/W Package
[D] DBMS package
Loading...
Are these questions helpful for you?

Comments: (Your feedback is valuable to us)