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

How to use Goal Seek Function in Excel || Chapter 14 | Video 1

How to Use the Solver Tool in Microsoft Excel | Hindi Tutorial || Chapter 14 | Video 2

Excel : Using Data Table | Hindi Tutorial || Chapter 14 | Video 3

Pivot Tables

Microsoft Excel: Pivot Tables – Chapter 13 Introduction

Pivot Table In Excel For Beginners | Hindi Tutorials || Chapter 14 | Video 1

How to Modify a Pivot Table in Excel | Chapter 13 | Video 2

How to Group Items in an Excel Pivot Table | Chapter 13 | Video 3

Advance Excel : Grouping Excel Tables | Hindi Tutorials || Chapter 13 | Video 4

Excel: How to Use Slicer | Hindi Tutorial || Chapter 13 | Video 5

How to Create Pivot Charts in Excel | Hindi Tutorial || Chapter 13 | Video 6

Database Features

Microsoft Excel: Database Features – Chapter 12 Introduction

Excel Tutorial : Sorting Data | Hindi Tutorial || Chapter 12 | Video 1

How to use Subtotal function in Excel | Hindi Tutorial || Chapter 12 | Video 2

Use Filters in Excel | Hindi Tutorial || Chapter 12 | Video 3

How to Split Data into Multiple Columns in Excel || Chapter 12 | Video 4

How to Remove Duplicate Data in MS Excel | Hindi Tutorial || Chapter 12 | Video 5

 

Security and Sharing

Microsoft Excel: Security & Sharing – Chapter 11 Introduction

Excel | Protecting a Worksheet || Chapter 11 | Video 1

How to Protect an Excel Workbook || Chapter 11 | Video 2

How to Password Protect an Excel Workbook || Chapter 11 | Video 3

Microsoft Excel Hindi Tutorial : Sharing Workbooks || Chapter 11 | Video 4

Use Track Changes Feature in Excel || Chapter 11 | Video 5

 

If, VLookup and Power Functions

Microsoft Excel: Important Functions – Chapter 10 Introduction

IF Function in MS Excel | Hindi Tutorial || Chapter 10 | Video 1

How to use a VLOOKUP in Excel – Hindi Tutorial || Chapter 10 | Video 2

How to use VLOOKUP to find exact match in Excel || Chapter 10 | Video 3

How to Use COUNTIF, SUMIF and AVERAGEIF Function in Excel || Chapter 10 | Video 4

 

Multiple Worksheets and Workbook

Microsoft Excel: Multiple Worksheet & Workbook – Chapter 9 Introduction

Excel: Inserting, Deleting and Renaming a Worksheet || Chapter 9 | Video 1

How to Move, Copy and Group Worksheets | Hindi Tutorial || Chapter 9 | Video 2

How to Link Formula One Sheet to other Sheets in MS Excel 2013 || Chapter 9 | Video 3

How to Manage Linked Formulas in Excel | Chapter 9 | Video 4

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