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. 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...
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. 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...
55. How do you display current date only in MS Excel?
[A] date ()
[B] Today ()
[C] now ()
[D] time ()
Loading...
56. Which Chart can be created in Excel?
[A] Area
[B] Line
[C] Pie
[D] All of the above
Loading...
57. 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...
58. How do you display current date and time in MS Excel?
[A] date ()
[B] Today ()
[C] now ()
[D] time ()
Loading...
59. Microsoft Excel is a powerful ...........
[A] Word processing package
[B] Spreadsheet package
[C] Communication S/W Package
[D] DBMS package
Loading...
60. How do you rearrange the data in ascending or descending order?
[A] Data, Sort
[B] Data, Form
[C] Data, Table
[D] Data Subtotals
Loading...
Are these questions helpful for you?

Comments: (Your feedback is valuable to us)