Sail E0 Webinar

Computer Aptitude

MS EXCEL MCQs

Ms Excel

Total Questions : 506 | Page 22 of 51 pages
Question 211. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet ?
  1.    Press Ctrl + Home
  2.    Press Home
  3.    Press Alt + Home
  4.    Press Shift + Home
 Discuss Question
Answer: Option A. -> Press Ctrl + Home
Question 212. Files created with Lotus 1-2-3 have an extension
  1.    XLS
  2.    123
  3.    Doc
  4.    WK1
 Discuss Question
Answer: Option B. -> 123
Question 213. You can edit a cell by
  1.    Selecting Edit > Edit cell from the menu
  2.    Clicking the formula button
  3.    Double clicking the cell to edit it in place
  4.    None of these
 Discuss Question
Answer: Option C. -> Double clicking the cell to edit it in place
Question 214. Which elements of worksheet can be protected from accidental modification
  1.    Contents
  2.    Scenarios
  3.    Objects
  4.    All of the listed here
 Discuss Question
Answer: Option D. -> All of the listed here
Question 215. What symbol is used before a number to make it a label ?
  1.    ' (apostrophe)
  2.    " (quote)
  3.    _ (underscore)
  4.    = (equal)
 Discuss Question
Answer: Option A. -> ' (apostrophe)
Question 216. The autofill feature
  1.    Applies a boarder around the selected cells
  2.    Extends a sequential series of data
  3.    All of the listed here
  4.    Automatically adds range of cell values
 Discuss Question
Answer: Option C. -> All of the listed here
Question 217. Which menu option can be used to split windows into two
  1.    Window > split
  2.    View > window > split
  3.    Format > window
  4.    View > split
 Discuss Question
Answer: Option B. -> View > window > split
Question 218. 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 219. To copy cell contents using drag and drop press the
  1.    End key
  2.    Ctrl key
  3.    Shift key
  4.    Esc key
 Discuss Question
Answer: Option B. -> Ctrl key
Question 220. Getting data from a cell located in a different sheet is called ___
  1.    Referencing
  2.    Functioning
  3.    Accessing
  4.    Updating
 Discuss Question
Answer: Option A. -> Referencing

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