Sarkari Naukri

Government Exams Preparation

Menu
  • Sarakri Naukri Home
  • Jobs
    • Jobs by Post
      • Accountant
      • Assistant Professor
      • Chef – Cooks
      • Clerk
      • Data Entry Operator
      • Computer Programmer
      • Draughtsman
      • Driver
      • Electrician
      • Fresher
      • HR
      • Junior Assistant
      • Junior Engineer
      • Lab Assistant
      • LDC
      • Librarian
      • Management Trainee
      • Managers
      • Medical Officer
      • Nursing
      • Office Assistant
      • Security Officer
      • Staff Nurse
      • Stenographer
      • Teacher
      • TGT Teachers
      • Scientist
      • UDC – Upper Division Clerk
      • Close
    • Jobs by Qualification
      • 10+2
      • 10th Pass
      • BA
      • B. Arch
      • BBA
      • B. Com
      • B. E.
      • B. ED.
      • B. Sc.
      • BCA
      • BDS
      • B Tech
      • Chartered Accountants – CA
      • Civil Engineering
      • Company Secretary
      • Diploma Holder
      • Doctors
      • Engineers
      • Graduate
      • LLB
      • M. A
      • MBA
      • MCA
      • M. Tech
      • Mechanical Engineer
      • Post Graduates
      • M. Sc
      • Ph. D
      • Close
    • Jobs by State
      • Andhra Pradesh
      • Assam
      • Bangalore
      • Bengal
      • Bihar
      • Chennai
      • Chhattisgarh
      • Delhi
      • Goa
      • Gujarat
      • Haryana
      • Himachal Pradesh
      • Hyderabad
      • Jammu & Kashmir
      • Jharkhand
      • Karnataka
      • Kerala
      • Kolkata
      • Madhya Pradesh
      • Maharashtra
      • Mumbai
      • Odisha
      • Pune
      • Punjab
      • Rajasthan
      • Tamil Nadu
      • Uttar Pradesh
      • Uttarakhand
      • Close
    • Close
  • Aptitude
  • English
  • Reasoning
  • GK
  • Interview Questions
  • Computer
    • Power point
    • illustrator
    • Excel
    • Photoshop
    • Microsoft Word
    • Close
Excel || Menu
  • MCQ
  • Getting Started with Excel
  • Entering Data
  • Creating Formula and Functions
  • Formatting
  • Adjusting Worksheet Layout and Data
  • Printing
  • Introduction to Chart
  • Adjusting Worksheet Views
  • Multiple Worksheets and Workbook
  • If, VLookup and Power Functions
  • Security and Sharing
  • Database Features
  • Pivot Tables
  • Data Analysis Tools

MS Excel MCQ 3

 5%

Question 1 of 20

1. In Microsoft Excel cells, function must start with ________

Question 1 of 20

Question 2 of 20

2. Which of the following Excel screen components can NOT be turned on or off?

Question 2 of 20

Question 3 of 20

3. Which function Is not available In the Consolidate dialog box?

Question 3 of 20

Question 4 of 20

4. MS Excel provides the default value for step in Fill Series dialog box

Question 4 of 20

Question 5 of 20

5. In MS Excel, Workbook can be closed using keyboard shortcut ______

Question 5 of 20

Question 6 of 20

6. Which of the following you can paste selectively using Paste Special command?

Question 6 of 20

Question 7 of 20

7. Which of the following will not cut information?

Question 7 of 20

Question 8 of 20

8. When a row of data is to be converted into columns

Question 8 of 20

Question 9 of 20

9. In MS Excel, keyboard shortcut keys to create a new workbook is _____

Question 9 of 20

Question 10 of 20

10. Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?

Question 10 of 20

Question 11 of 20

11. In Excel to select a column the easiest method is to

Question 11 of 20

Question 12 of 20

12. Ctrl + D shortcut key in Excel will

Question 12 of 20

Question 13 of 20

13. What happens when you press Ctrl + X after selecting some cells in Excel?

Question 13 of 20

Question 14 of 20

14. When the formula bar is active, you can see

Question 14 of 20

Question 15 of 20

15. The shortcut key Ctrl + R is used in Excel to

Question 15 of 20

Question 16 of 20

16. In MS Excel, Ctrl+S can be used to_______

Question 16 of 20

Question 17 of 20

17. Which of the following option is not available in Paste Special dialog box?

Question 17 of 20

Question 18 of 20

18. Which tool you will use to join some cells and place the content at the middle of joined cell?

Question 18 of 20

Question 19 of 20

19. The command Edit > Fill Across Worksheet is active only when

Question 19 of 20

Question 20 of 20

20. Edit > Delete command

Question 20 of 20

Loading... Loading...

 

Filed Under: Computer, Excel

Contact Us—Terms of Service—Privacy Policies

All trademarks / Logo are property of their respective owners.
Copyright Sarkari Naukri © 2023 All Rights Reserved.