Sail E0 Webinar

Computer Aptitude

MS EXCEL MCQs

Ms Excel

Total Questions : 506 | Page 17 of 51 pages
Question 161. The command Edit > Fill Across Worksheet is active only when
  1.    One sheet is selected
  2.    When many sheets are selected
  3.    When no sheet is selected
  4.    None of above
 Discuss Question
Answer: Option B. -> When many sheets are selected
Question 162. Which of the following series type is not valid for Fill Series dialog box?
  1.    Linear
  2.    Growth
  3.    Autofill
  4.    Time
 Discuss Question
Answer: Option D. -> Time
Question 163. Which of the following you can paste selectively using Paste Special command?
  1.    Validation
  2.    Formats
  3.    Formulas
  4.    All of above
 Discuss Question
Answer: Option D. -> All of above
Question 164. Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?
  1.    Square
  2.    Percentage
  3.    Goal Seek
  4.    Divide
 Discuss Question
Answer: Option D. -> Divide
Question 165. To remove the content of selected cells you must issue ______ command
  1.    Delete
  2.    Clear Contents
  3.    Clear All
  4.    Clear Delete
 Discuss Question
Answer: Option B. -> Clear Contents
Question 166. Edit > Delete command
  1.    Deletes the content of a cell
  2.    Deletes Formats of cell
  3.    Deletes the comment of cell
  4.    Deletes selected cells
 Discuss Question
Answer: Option D. -> Deletes selected cells
Question 167. The Delete key of keyboard is assigned to which command in Excel?
  1.    Edit > Clear > Contents
  2.    Edit > Clear > All
  3.    Edit > Delete
  4.    All of above
 Discuss Question
Answer: Option A. -> Edit > Clear > Contents
Question 168. If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must
  1.    From Edit menu choose Clear and then Formats
  2.    From Edit menu choose Delete
  3.    Click on Remove Formatting tool on Standard Toolbar
  4.    Double click the Format Painter and then press Esc key in keyboard
 Discuss Question
Answer: Option A. -> From Edit menu choose Clear and then Formats
Question 169. By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
  1.    Right click on Sheet Tab of third sheet and choose Delete from the context menu
  2.    Click on Sheet 3 and from Edit menu choose Delete
  3.    Both of above
  4.    None of above
 Discuss Question
Answer: Option A. -> Right click on Sheet Tab of third sheet and choose Delete from the context menu
Question 170. Which of the following action removes a sheet from workbook?
  1.    Select the sheet, then choose Edit > Delete Sheet
  2.    Select the sheet then choose Format > Sheet > Hide
  3.    Both of above
  4.    None of above
 Discuss Question
Answer: Option A. -> Select the sheet, then choose Edit > Delete Sheet

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