Sail E0 Webinar

Computer Aptitude

MS EXCEL MCQs

Ms Excel

Total Questions : 506 | Page 47 of 51 pages
Question 461. . Which among following can't be considered as worksheet criterion ?
  1.    Efficiency
  2.    Auditability
  3.    Clarity
  4.    Description
 Discuss Question
Answer: Option D. -> Description
Question 462. . When creating a vertical page break ?
  1.    The active cell must be in row 1
  2.    The active cell must be A1
  3.    The active cell must be in row 10
  4.    The active cell must be in column A
 Discuss Question
Answer: Option A. -> The active cell must be in row 1
Question 463. . The intersection of row and column is called a ?
  1.    dataset
  2.    cell
  3.    data
  4.    set
 Discuss Question
Answer: Option B. -> cell
Question 464. . Which dialogue box we can use to name a constant ?
  1.    Create Name
  2.    Define Name
  3.    Get Name
  4.    Create Constant
 Discuss Question
Answer: Option B. -> Define Name
Question 465. . Which among following is types of excel data types ?
  1.    Numbers, Formulas, Labels
  2.    Data, Words, Numbers
  3.    Words, Number, Labels
  4.    Equations, Data, Numbers
 Discuss Question
Answer: Option A. -> Numbers, Formulas, Labels
Question 466. . You will use which feature in excel, if you want to work with one record at a time ?
  1.    Auto Complete
  2.    Auto Filter
  3.    Sub Totals
  4.    Data Form
 Discuss Question
Answer: Option D. -> Data Form
Question 467. . One cell format can be copied to another cell by using ?
  1.    Format Painter
  2.    Format Setting
  3.    Format Showing
  4.    Format Checking
 Discuss Question
Answer: Option A. -> Format Painter
Question 468. . To join some cells and place the content at the middle of joined cell, which tool you will use?
  1.    From Format Cells dialog box choose Merge and Center check box
  2.    Click on Merge and Center tool on formatting toolbar
  3.    From Format Cells dialog box select the Centered alignment
  4.    From Format Cells dialog box click on Merge Cells check box
 Discuss Question
Answer: Option B. -> Click on Merge and Center tool on formatting toolbar
Question 469. . On Excel screen, Tab scroll buttons are
  1.    towards the top left corner
  2.    towards the top right corner
  3.    towards the bottom right corner
  4.    towards the bottom left corner
 Discuss Question
Answer: Option D. -> towards the bottom left corner
Question 470. . In Excel Worksheet how can you show or hide the grid-lines ?
  1.    Click Grid-line tool on Forms toolbar
  2.    Go to Tools -> Options -> View tab and mark or remove the check box named Gridline
  3.    Both of above
  4.    None of above
 Discuss Question
Answer: Option C. -> Both of above

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

DSP Combined 1 Free Revision Test SAIL JO E-0
GPOE / GPA Combined 1 Free Revision Test SAIL JO E-0
BSP Plant Specific Review Test SAIL JO E-0
BSL Combined 1 Free Revision Test SAIL JO E-0
GFM Combined 1 Free Revision Test SAIL JO E-0