Sail E0 Webinar

Computer Aptitude

MS EXCEL MCQs

Ms Excel

Total Questions : 506 | Page 1 of 51 pages
Question 1. How do you display current date only in MS Excel?
  1.    Date ()
  2.    Today ()
  3.    Now ()
  4.    Time ()
 Discuss Question
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
 Discuss Question
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
 Discuss Question
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
 Discuss Question
Answer: Option D. -> Ctrl + Space Bar
Question 5. In the formula, which symbol specifies the fixed columns or rows?
  1.    $
  2.    *
  3.    %
  4.    &
 Discuss Question
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
 Discuss Question
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
 Discuss Question
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
 Discuss Question
Answer: Option A. -> Visual Basic
Question 9. How many worksheets can a workbook have?
  1.    3
  2.    8
  3.    255
  4.    none of above
 Discuss Question
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
 Discuss Question
Answer: Option D. -> Document

Latest Videos
Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)
Direction Sense Test Part 1 Reasoning (Hindi)
Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE
Cube & Cuboid Part 1 Reasoning (Hindi)
Data Interpretation (DI) Basic Concept Reasoning (Hindi)
Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)
Sail E0 free webinar Webinars
Real Numbers Part 7 Class 10 Maths
Real Numbers Part 1 Class 10 Maths
Polynomials Part 1 Class 10 Maths

Latest Test Papers

Chapter 3.1 : Overview of Finance & Accounts Department Chapter 3 : Finance & Accounts SAIL E0 - GFM 2024
Chapter 2.1 : Overview Chapter 2 : Materials Management SAIL E0 - GFM 2024
Chapter 1.1 : Personnel Functions- An overview Chapter 1 : Personnel Management SAIL E0 - GFM 2024
GPOE / GPA Combined 1 Free CBT Mock Test SAIL E0 2024
CBT Mixed Test 1 GPOE/GPA SAIL E0 2024