Sail E0 Webinar

Computer Aptitude

MS EXCEL MCQs

Ms Excel

Total Questions : 506 | Page 3 of 51 pages
Question 21. What is represented by the small, black square in the lower-right corner of an active cell or range?
  1.    Copy handle
  2.    Fill handle
  3.    Insert handle
  4.    Border
 Discuss Question
Answer: Option B. -> Fill handle
Question 22. In Excel, a Data Series is defined as what?
  1.    A type of chart
  2.    A cell reference
  3.    A collection of related data
  4.    A division of results
 Discuss Question
Answer: Option C. -> A collection of related data
Question 23. In Excel, the Fill Color button on the Formatting toolbar is used for what?
  1.    To insert a background
  2.    To add borders
  3.    To select a distribution of figures
  4.    To add shading or color to a cell range
 Discuss Question
Answer: Option D. -> To add shading or color to a cell range
Question 24. A ________ is a grid with labeled columns and rows.
  1.    Dialog box
  2.    Worksheet
  3.    Clipboard
  4.    Toolbar
 Discuss Question
Answer: Option B. -> Worksheet
Question 25. In help menu of Excel, which of the following tabs are found?
  1.    Contents tab
  2.    Answer Wizard tab
  3.    Index tab
  4.    all of the above
 Discuss Question
Answer: Option D. -> all of the above
Question 26. The active cell:
  1.    Is defined by a bold border around the cell
  2.    Receives the data the user enters
  3.    It is the formula bar
  4.    Only A and B
 Discuss Question
Answer: Option D. -> Only A and B
Question 27. B7:B9 indicates:
  1.    Cells B7 and cell B9 only
  2.    Cells B7 through B9
  3.    Cell B8 only
  4.    None of the above
 Discuss Question
Answer: Option B. -> Cells B7 through B9
Question 28. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
  1.    Logical
  2.    Math & Trigonometry
  3.    Statistical
  4.    Financial
 Discuss Question
Answer: Option D. -> Financial
Question 29. Which of the following methods cannot be used to enter data in a cell
  1.    Pressing an arrow key
  2.    Pressing the Tab key
  3.    Pressing the Esc key
  4.    Clicking on the formula bar
 Discuss Question
Answer: Option C. -> Pressing the Esc key
Question 30. The Cancel and Enter buttons appear in the:
  1.    Title bar
  2.    Formula bar
  3.    Menu bar
  4.    Sheet tabs
 Discuss Question
Answer: Option B. -> Formula bar

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