Sail E0 Webinar

Computer Aptitude

MICROSOFT EXCEL Q/A MCQs

Total Questions : 635 | Page 11 of 64 pages
Question 101. The active cell:
  1.    is defined by a bold border around the cell.
  2.    Receives the data the user enters.
  3.    It is the formula bar.
  4.    Only A and B
  5.    None of these
 Discuss Question
Answer: Option D. -> Only A and B
Answer: (d)
Question 102. In Excel which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the resulting a difference cell
  1.    Count
  2.    Average
  3.    Sum
  4.    None of above
 Discuss Question
Answer: Option C. -> Sum
Answer: (c)
Question 103. You can add an image to a template by clicking the Insert Picture From File button on the .... Toolbar.
  1.    Standard
  2.    Formatting
  3.    Drawing
  4.    Picture
  5.    None of these
 Discuss Question
Answer: Option D. -> Picture
Answer: (d)
Question 104. You can activate a cell by
  1.    Pressing the Tab key
  2.    Clicking the cell
  3.    Pressing an arrow key
  4.    All of the above
  5.    None of these
 Discuss Question
Answer: Option D. -> All of the above
Answer: (d)
Question 105. In Excel the Paste Special command lets you copy and paste
  1.    Multiply the selection by a copied value
  2.    Cell comments
  3.    Formatting options
  4.    The resulting values of a formula instead of the actual formula
 Discuss Question
Answer: Option D. -> The resulting values of a formula instead of the actual formula
Answer: (d)
Question 106. What excel feature can you use if you want to work with one record at a time?
  1.    Auto Complete
  2.    Auto Filter
  3.    Data Form
  4.    Sub Totals
 Discuss Question
Answer: Option C. -> Data Form
Answer: (c)
Question 107. The horizontal and vertical lines on a worksheet are called
  1.    cells
  2.    sheets
  3.    blocklines
  4.    gridlines
  5.    None of these
 Discuss Question
Answer: Option A. -> cells
Answer: (a)
Question 108. An Excel Workbook is a collection of.......
  1.    Workbooks
  2.    Worksheets
  3.    Charts
  4.    Worksheets and Charts
  5.    None of these
 Discuss Question
Answer: Option D. -> Worksheets and Charts
Answer: (d)
Question 109. You can activate a cell by
  1.    Pressing the Tab key
  2.    Clicking the cell
  3.    Pressing an arrow key
  4.    All of above
  5.    None of these
 Discuss Question
Answer: Option D. -> All of above
Answer: (d)
Question 110. When the formula bar is active, you can see
  1.    The edit formula button
  2.    The cancel button
  3.    The enter button
  4.    All of the above
  5.    None of these
 Discuss Question
Answer: Option D. -> All of the above
Answer: (d)

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

DSP Combined 1 Free Revision Test SAIL JO E-0
GPOE / GPA Combined 1 Free Revision Test SAIL JO E-0
BSP Plant Specific Review Test SAIL JO E-0
BSL Combined 1 Free Revision Test SAIL JO E-0
GFM Combined 1 Free Revision Test SAIL JO E-0