Sail E0 Webinar

Computer Aptitude

MS EXCEL MCQs

Ms Excel

Total Questions : 506 | Page 18 of 51 pages
Question 171. While Finding and Replacing some data in Excel, which of the following statement is valid?
  1.    You can Find and Replace within the sheet or workbook
  2.    Excel does not have option to match case for find
  3.    Both are valid
  4.    None are valid
 Discuss Question
Answer: Option A. -> You can Find and Replace within the sheet or workbook
Question 172. Which of the following is not true about Find and Replace in Excel
  1.    You can search for bold and replace with italics
  2.    You can decide whether to look for the whole word or not
  3.    You can search in formula too
  4.    You can search by rows or columns or sheets
 Discuss Question
Answer: Option A. -> You can search for bold and replace with italics
Question 173. You can move a sheet from one workbook into new book by
  1.    From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK
  2.    From Edit menu choose Move of Copy then choose (Move to end) and click OK
  3.    From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
  4.    None of above
 Discuss Question
Answer: Option C. -> From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
Question 174. What is the shortcut key to replace a data with another in sheet?
  1.    Ctrl + R
  2.    Ctrl + Shift + R
  3.    Ctrl + H
  4.    Ctrl + F
 Discuss Question
Answer: Option C. -> Ctrl + H
Question 175. Comments can be added to cells using ________
  1.    Home > Comments
  2.    Insert > Comment
  3.    Data > Comments
  4.    View > Comments
 Discuss Question
Answer: Option B. -> Insert > Comment
Question 176. Which menu option can be used to split windows into two?
  1.    Review > Window
  2.    View > Window > Split
  3.    Window > Split
  4.    View > Split
 Discuss Question
Answer: Option B. -> View > Window > Split
Question 177. Getting data from a cell located in a different sheet is called ________
  1.    Accessing
  2.    Referencing
  3.    Updating
  4.    Functioning
 Discuss Question
Answer: Option B. -> Referencing
Question 178. Which of the following is not a valid data type in Excel?
  1.    Number
  2.    Character
  3.    Label
  4.    Date/Time
 Discuss Question
Answer: Option B. -> Character
Question 179. Which elements of a worksheet can be protected from accidental modification?
  1.    Contents
  2.    Objects
  3.    Scenarios
  4.    All of the above
 Discuss Question
Answer: Option D. -> All of the above
Question 180. A numeric value can be treated as label value if ________ precedes it.
  1.    Apostrophe ( ‘ )
  2.    Exclamation ( ! )
  3.    Hash ( # )
  4.    Tilde ( ~ )
 Discuss Question
Answer: Option A. -> 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