Menu
Popular Courses
Search

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

Share this page with your friends!

Share this page with your friends!

Latest Videos

Chapter 1 - GLOBAL STEEL SCENARIO & INDI 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 2024
Cube & Cuboid Part 1 Reasoning (Hindi)
Data Interpretation (DI) Basic Concept Reasoning (Hindi)
Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)
Real Numbers Part 7 Class 10 Maths
Real Numbers Part 1 Class 10 Maths
Polynomials Part 1 Class 10 Maths

Latest Test Papers

Chapter 1.1 : INTRODUCTION Chapter 1 : Raw Material Handling Plant GPOE/GPA 2024
Chapter 1.1 : Personnel Functions- An ov Chapter 1 : Personnel Management GFM 2024
Chapter 3.1 : INTRODUCTION Chapter 3 : Sinter Plant GPOE/GPA 2024
Chapter 2.3 : COAL HANDLING PLANT - Set Chapter 2 : Coke Ovens and Coal Chemicals GPOE/GPA 2024
Chapter 2.1 : Overview Chapter 2 : Materials Management GFM 2024