Sail E0 Webinar

Computer Aptitude

MS EXCEL MCQs

Ms Excel

Total Questions : 506 | Page 11 of 51 pages
Question 101. To delete an embedded objects, first
  1.    Double click the object
  2.    Select the object by clicking it
  3.    Press the Shift + Delete keys
  4.    Select it and then press the delete key
 Discuss Question
Answer: Option D. -> Select it and then press the delete key
Question 102. Comments can be added to cells using
  1.    Edit > Comments
  2.    Insert > Comments
  3.    File > Comments
  4.    View > Comments
 Discuss Question
Answer: Option B. -> Insert > Comments
Question 103. Which of the following is not a worksheet design criterion?
  1.    Efficiency
  2.    Aditibility
  3.    Description
  4.    Clarity
 Discuss Question
Answer: Option C. -> Description
Question 104. To copy cell contents using drag and drop press the
  1.    End key
  2.    Shift key
  3.    Ctrl key
  4.    Esc key
 Discuss Question
Answer: Option C. -> Ctrl key
Question 105. Which of the following is the latest version of Excel
  1.    Excel 2007
  2.    Excel 2016
  3.    Excel 365
  4.    Excel XP
 Discuss Question
Answer: Option C. -> Excel 365
Question 106. When you copy a formula
  1.    Excel erases the original copy of the formula
  2.    Excel edits cell references in the newly copied formula
  3.    Excel adjusts absolute cell references
  4.    Excel doesn’t adjust relative cell references
 Discuss Question
Answer: Option B. -> Excel edits cell references in the newly copied formula
Question 107. The autofill feature
  1.    Extends a sequential series of data
  2.    Automatically adds range of cell values
  3.    Applies a boarder around the selected cells
  4.    All of the above
 Discuss Question
Answer: Option D. -> All of the above
Question 108. Which menu option can be used to split windows into two
  1.    Format > window
  2.    View > window > split
  3.    Window > split
  4.    View > split
 Discuss Question
Answer: Option B. -> View > window > split
Question 109. Which of the following is an absolute cell reference?
  1.    !A!1
  2.    $A$1
  3.    #a#1
  4.    A1
 Discuss Question
Answer: Option B. -> $A$1
Question 110. What symbol is used before a number to make it a label?
  1.    ” ( quote )
  2.    = ( equal )
  3.    _ ( underscore )
  4.    ‘ ( apostrophe )
 Discuss Question
Answer: Option D. -> ‘ ( apostrophe )

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

Pie Chart - Test Paper 1 Data Interpretation Reasoning & DI
Tabulation - Test Paper 2 Data Interpretation Reasoning & DI
Test Paper 1 Direction Sense Test Reasoning & DI
ICA , RDIC,GFM Free Modal Test Paper - Non - Technical Branch Old Syllabus 2022 - SAIL Junior Officer E0
GFM Combined 1 Free Revision Test SAIL JO E-0