Menu
Popular Courses
Sail E0 20253 months
Fast Math Tricks165 videos
Quantitative Aptitude645 Videos
Reasoning Aptitude161 Videos
CLASS 8 MATHS(CBSE)417 Videos
CLASS 9 MATHS(CBSE)40 hours, 647 questions
Check All Courses
Search

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

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
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

Chapter 3.1 : Overview of Finance & Acco Chapter 3 : Finance & Accounts SAIL E0 - GFM 2024
Chapter 2.1 : Overview Chapter 2 : Materials Management SAIL E0 - GFM 2024
Chapter 1.1 : Personnel Functions- An ov Chapter 1 : Personnel Management SAIL E0 - GFM 2024
GPOE / GPA Combined 1 Free CBT Mock Test SAIL E0 2024
CBT Mixed Test 1 GPOE/GPA SAIL E0 2024