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

MICROSOFT EXCEL Q/A MCQs

Total Questions : 635 | Page 1 of 64 pages
Question 1. Which of the following is not a valid data type in Excel?
  1.    Number
  2.    Character
  3.    Label
  4.    Date/Time
  5.    None of these
 Discuss Question
Answer: Option B. -> Character
Question 2. In Excel the function calculates depreciation at the same amount each year over an asset’s useful life
  1.    DB (fixed-declining balance)
  2.    SLN (straight line)
  3.    DDB (double-declining)
  4.    All of above
 Discuss Question
Answer: Option B. -> SLN (straight line)
Question 3. Which of the following is not true about Find and Replace in Excel
  1.    You can search for bold and replace with italics
  2.    You can decide whether to look for the whole word or not
  3.    You can search in formula too
  4.    You can search by rows or columns or sheets
  5.    None of these
 Discuss Question
Answer: Option D. -> You can search by rows or columns or sheets
Question 4. A worksheet range is a
  1.    A command used for data modeling
  2.    A range of values such as from 23 to 234
  3.    A group of cells
  4.    A group of worksheets
 Discuss Question
Answer: Option C. -> A group of cells
Question 5. Which of the following is not a way to complete a cell entry?
  1.    Pressing enter
  2.    Pressing any arrow key on the keyboard
  3.    Clicking the Enter button on the Formula bar
  4.    Pressing spacebar
  5.    None of these
 Discuss Question
Answer: Option D. -> Pressing spacebar
Question 6. All formula In Excel start with
  1.    .>
  2.    +
  3.    =
  4.    -
  5.    None of these
 Discuss Question
Answer: Option C. -> =
Question 7. Pre-made sheet formats like Simple, Classic, Accounting, Colorful etc can be applied from
  1.    from Format » Cells
  2.    from Format > > Auto format
  3.    from Table > > Auto format
  4.    All of above
  5.    None of these
 Discuss Question
Answer: Option B. -> from Format > > Auto format
Question 8. Excel worksheet cells work very similarly to what common element of the windows graphical user interface
  1.    Option buttons
  2.    List boxes
  3.    Text boxes
  4.    Combo boxes
 Discuss Question
Answer: Option C. -> Text boxes
Question 9. To activate the previous cell in a pre-selected range, press
  1.    The Alt key
  2.    The Tab key
  3.    The Enter key
  4.    All of the above
  5.    None of these
 Discuss Question
Answer: Option E. -> None of these
Question 10. Tab scrolling buttons
  1.    Allow you to view a different worksheet
  2.    Allow you to view additional worksheet row down
  3.    Allow you to view additional worksheet columns to the right
  4.    Allow you to view additional sheet tabs
  5.    None of these
 Discuss Question
Answer: Option D. -> Allow you to view additional sheet tabs

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