Ms Excel(Computer Aptitude ) Questions and Answers

Question 1. How do you display current date only in MS Excel?
  1.    Date ()
  2.    Today ()
  3.    Now ()
  4.    Time ()
Explanation:-
Answer: Option B. -> Today ()
Question 2. How do you wrap the text in a cell?
  1.    Format, cells, font
  2.    Format, cells, protection
  3.    Format, cells, number
  4.    Format, cells, alignment
Explanation:-
Answer: Option D. -> Format, cells, alignment
Question 3. What does COUNTA () function do?
  1.    Counts cells having alphabets
  2.    Counts empty cells
  3.    Counts cells having number
  4.    Counts non-empty cells
Explanation:-
Answer: Option D. -> Counts non-empty cells
Question 4. What is the short cut key to highlight the entire column?
  1.    Ctrl + C
  2.    Ctrl + Enter
  3.    Ctrl + Page Up
  4.    Ctrl + Space Bar
Explanation:-
Answer: Option D. -> Ctrl + Space Bar
Question 5. In the formula, which symbol specifies the fixed columns or rows?
  1.    $
  2.    *
  3.    %
  4.    &
Explanation:-
Answer: Option A. -> $
Question 6. Excel displays the current cell address in the ________
  1.    Formula bar
  2.    Status Bar
  3.    Name Box
  4.    Title Bar
Explanation:-
Answer: Option C. -> Name Box
Question 7. What is the correct way to refer the cell A10 on sheet3 from sheet1?
  1.    Sheet3!A10
  2.    Sheet1!A10
  3.    Sheet3.A10
  4.    A10
Explanation:-
Answer: Option A. -> Sheet3!A10
Question 8. Which language is used to create macros in Excel?
  1.    Visual Basic
  2.    C
  3.    Visual C++
  4.    Java
Explanation:-
Answer: Option A. -> Visual Basic
Question 9. How many worksheets can a workbook have?
  1.    3
  2.    8
  3.    255
  4.    none of above
Explanation:-
Answer: Option D. -> none of above
Question 10. Which of the following is not a term of MS-Excel?
  1.    Cells
  2.    Rows
  3.    Columns
  4.    Document
Explanation:-
Answer: Option D. -> Document
© Lakshya_Education.com, All Right Reserved.
Contact Us services