Sail E0 Webinar

Computer Aptitude

MS EXCEL MCQs

Ms Excel

Total Questions : 506 | Page 15 of 51 pages
Question 141. Tab scroll buttons are place on Excel screen
  1.    Towards the bottom right corner
  2.    Towards the bottom left corner
  3.    Towards the top right corner
  4.    Towards the top left corner
 Discuss Question
Answer: Option B. -> Towards the bottom left corner
Question 142. Which of the following is not the correct method of editing the cell content?
  1.    Press the Alt key
  2.    Press the F2 key
  3.    Click the formula bar
  4.    Double click the cell
 Discuss Question
Answer: Option A. -> Press the Alt key
Question 143. Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?
  1.    Work sheet
  2.    Chart sheet
  3.    Macro sheet
  4.    Data sheet
 Discuss Question
Answer: Option D. -> Data sheet
Question 144. You can merge the main document with data source in Excel. In mail merge operation, Word is usually
  1.    Server
  2.    Source
  3.    Client
  4.    None of the above
 Discuss Question
Answer: Option C. -> Client
Question 145. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
  1.    F8
  2.    F9
  3.    F10
  4.    F11
 Discuss Question
Answer: Option B. -> F9
Question 146. You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?
  1.    Custom List
  2.    Auto Fill Options
  3.    Fill Across Worksheet
  4.    Fill Series
 Discuss Question
Answer: Option A. -> Custom List
Question 147. Where can you change automatic or manual calculation mode in Excel?
  1.    Double CAL indicator on status bar
  2.    Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button
  3.    Both of above
  4.    None of above
 Discuss Question
Answer: Option B. -> Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button
Question 148. How can you show or hide the gridlines in Excel Worksheet?
  1.    Go to Tools > Options > View tab and mark or remove the check box named Gridline
  2.    Click Gridline tool on Forms toolbar
  3.    Both of above
  4.    None of above
 Discuss Question
Answer: Option C. -> Both of above
Question 149. Which of the following Excel screen components can NOT be turned on or off?
  1.    Formula Bar
  2.    Status Bar
  3.    Tool Bar
  4.    None of above
 Discuss Question
Answer: Option D. -> None of above
Question 150. What happens when you press Ctrl + X after selecting some cells in Excel?
  1.    The cell content of selected cells disappear from cell and stored in clipboard
  2.    The cells selected are marked for cutting
  3.    The selected cells are deleted and the cells are shifted left
  4.    The selected cells are deleted and cells are shifted up
 Discuss Question
Answer: Option B. -> The cells selected are marked for cutting

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 : INTRODUCTION Chapter 3 : Sinter Plant SAIL E0 - GPOE/GPA 2024
Chapter 2.3 : COAL HANDLING PLANT - Set 1 Chapter 2 : Coke Ovens and Coal Chemicals SAIL E0 - GPOE/GPA 2024
Chapter 1.1 : INTRODUCTION Chapter 1 : Raw Material Handling Plant SAIL E0 - GPOE/GPA 2024
GPOE / GPA Combined 1 Free Revision Test SAIL JO E-0
DSP Combined 1 Free Revision Test SAIL JO E-0