Sarkari Naukri

Government Exams Preparation

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


 

Data Analysis Tools

Microsoft Excel: Data Analysis Tools – Chapter 14 Introduction
https://www.youtube.com/watch?v=sNktVNhk3IA
How to use Goal Seek Function in Excel || Chapter 14 | Video 1
https://www.youtube.com/watch?v=PfSrve3um7w
How to Use the Solver Tool in Microsoft Excel | Hindi Tutorial || Chapter 14 | Video 2
https://www.youtube.com/watch?v=AdTfZhq6Z6Y
Excel : Using Data Table | Hindi Tutorial || Chapter 14 | Video 3
https://www.youtube.com/watch?v=at-BP_J41J8

Pivot Tables

Microsoft Excel: Pivot Tables – Chapter 13 Introduction
https://www.youtube.com/watch?v=4yQFHOuucJI
Pivot Table In Excel For Beginners | Hindi Tutorials || Chapter 14 | Video 1
https://www.youtube.com/watch?v=U0vc5ARnuAc
How to Modify a Pivot Table in Excel | Chapter 13 | Video 2
https://www.youtube.com/watch?v=J7EDQGBRmm0
How to Group Items in an Excel Pivot Table | Chapter 13 | Video 3
https://www.youtube.com/watch?v=pwUV1QKOYb8
Advance Excel : Grouping Excel Tables | Hindi Tutorials || Chapter 13 | Video 4
https://www.youtube.com/watch?v=ffrCCPsyBhM
Excel: How to Use Slicer | Hindi Tutorial || Chapter 13 | Video 5
https://www.youtube.com/watch?v=p-lhXSqEaeU
How to Create Pivot Charts in Excel | Hindi Tutorial || Chapter 13 | Video 6
https://www.youtube.com/watch?v=cAs21d70CTY

Database Features

Microsoft Excel: Database Features – Chapter 12 Introduction
https://www.youtube.com/watch?v=kYjPdwbIWpg
Excel Tutorial : Sorting Data | Hindi Tutorial || Chapter 12 | Video 1
https://www.youtube.com/watch?v=zLjIRViHAwQ
How to use Subtotal function in Excel | Hindi Tutorial || Chapter 12 | Video 2
https://www.youtube.com/watch?v=_Cd_2whepgM
Use Filters in Excel | Hindi Tutorial || Chapter 12 | Video 3
https://www.youtube.com/watch?v=qY5i-EV_d_Q
How to Split Data into Multiple Columns in Excel || Chapter 12 | Video 4
https://www.youtube.com/watch?v=dwUt9AT42NI
How to Remove Duplicate Data in MS Excel | Hindi Tutorial || Chapter 12 | Video 5
https://www.youtube.com/watch?v=CWuYywwJM4Q

 

Security and Sharing

Microsoft Excel: Security & Sharing – Chapter 11 Introduction
https://www.youtube.com/watch?v=ajCGx6yO_TM
Excel | Protecting a Worksheet || Chapter 11 | Video 1
https://www.youtube.com/watch?v=GibKmsS-xaE
How to Protect an Excel Workbook || Chapter 11 | Video 2
https://www.youtube.com/watch?v=Kxf6_4L5Cpg
How to Password Protect an Excel Workbook || Chapter 11 | Video 3
https://www.youtube.com/watch?v=Q4wkeoiG5Es
Microsoft Excel Hindi Tutorial : Sharing Workbooks || Chapter 11 | Video 4
https://www.youtube.com/watch?v=ttFs0oO3DZc
Use Track Changes Feature in Excel || Chapter 11 | Video 5
https://www.youtube.com/watch?v=UYMSFVbnQpU

 

If, VLookup and Power Functions

Microsoft Excel: Important Functions – Chapter 10 Introduction
https://www.youtube.com/watch?v=U0M5Rpu-m3U
IF Function in MS Excel | Hindi Tutorial || Chapter 10 | Video 1
https://www.youtube.com/watch?v=iEaI7H7Wrt0
How to use a VLOOKUP in Excel – Hindi Tutorial || Chapter 10 | Video 2
https://www.youtube.com/watch?v=KWnBPMEeOb8
How to use VLOOKUP to find exact match in Excel || Chapter 10 | Video 3
https://www.youtube.com/watch?v=NKw-t2PJiyY
How to Use COUNTIF, SUMIF and AVERAGEIF Function in Excel || Chapter 10 | Video 4
https://www.youtube.com/watch?v=FE6woTpVuyQ

 

Multiple Worksheets and Workbook

Microsoft Excel: Multiple Worksheet & Workbook – Chapter 9 Introduction
https://www.youtube.com/watch?v=ZV0jLb_JzKc
Excel: Inserting, Deleting and Renaming a Worksheet || Chapter 9 | Video 1
https://www.youtube.com/watch?v=bsHm_frvh4A
How to Move, Copy and Group Worksheets | Hindi Tutorial || Chapter 9 | Video 2
https://www.youtube.com/watch?v=YXUkmgaVx7o
How to Link Formula One Sheet to other Sheets in MS Excel 2013 || Chapter 9 | Video 3
https://www.youtube.com/watch?v=TrwWKnDIWS0
How to Manage Linked Formulas in Excel | Chapter 9 | Video 4

https://www.youtube.com/watch?v=zdNNIf-Kt2U