Sail E0 Webinar

Computer Aptitude

MICROSOFT EXCEL Q/A MCQs

Total Questions : 635 | Page 9 of 64 pages
Question 81. In Excel it is acceptable to let long text flow into adjacent cells on a worksheet when
  1.    Data will be entered in the adjacent cells
  2.    No data will be entered in the adjacent cells
  3.    There is no suitable abbreviation for the text
  4.    There is not time to format the text
 Discuss Question
Answer: Option B. -> No data will be entered in the adjacent cells
Answer: (b)
Question 82. Hyperlinks cannot be
  1.    Special shapes like stars and banners
  2.    Drawing objects like rectangles ovals
  3.    Pictures
  4.    All can be hyperlinks
  5.    None of these
 Discuss Question
Answer: Option D. -> All can be hyperlinks
Answer: (d)
Question 83. In Excel 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
Answer: (b)
Question 84. Which of the following is the latest version of Excel
  1.    Excel 2000
  2.    Excel 2002
  3.    Excel ME
  4.    Excel XP
  5.    None of these
 Discuss Question
Answer: Option D. -> Excel XP
Answer: (d)
Question 85. How do you rearrange the data In ascending or descending order?
  1.    Data, Sort
  2.    Data, Form
  3.    Data, Table
  4.    Data Subtotals
  5.    None of these
 Discuss Question
Answer: Option A. -> Data, Sort
Answer: (a)
Question 86. In Excel you can zoom a worksheet
  1.    With the mouse pointer in Print Preview
  2.    With the zoom button on the Print Preview toolbar
  3.    With the Zoom command on the view menu
  4.    All of the above
 Discuss Question
Answer: Option D. -> All of the above
Answer: (d)
Question 87. 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.    Excel cannot replace
  4.    All of above
  5.    None of these
 Discuss Question
Answer: Option A. -> You can Find and Replace within the sheet or workbook
Answer: (a)
Question 88. Which of the following displays the contents of the active cell?
  1.    Active cell
  2.    Formula bar
  3.    Menu bar
  4.    Name box
  5.    None of these
 Discuss Question
Answer: Option B. -> Formula bar
Answer: (b)
Question 89. Which of the following special function keys allow the content in cell
  1.    esc
  2.    shift
  3.    return
  4.    Tab
  5.    None of these
 Discuss Question
Answer: Option C. -> return
Answer: (c)
Question 90. How can you remove borders applied In cells?
  1.    Choose None on Border , tab of Format cells
  2.    Open the list on Border tool in Formatting toolbar then choose first tool (no border)
  3.    Both of above
  4.    All of above
  5.    None of these
 Discuss Question
Answer: Option C. -> Both of above
Answer: (c)

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