Report a question

You cannot submit an empty report. Please add some details.

Excel Basics Quiz 11

Excel Basics Quiz 11

1 / 30

1) Excel ka mukhya upyog kya hai? What is the main use of Excel?

2 / 30

2) Excel file ka default extension kya hota hai? What is the default extension of an Excel file?

3 / 30

3) Excel mein har cell ka ek unique address hota hai, use kya kehte hain? Every cell in Excel has a unique address, what is it called?

4 / 30

4) Excel workbook mein kitni worksheets ho sakti hain? How many worksheets can an Excel workbook have?

5 / 30

5) Excel mein data enter karne ke liye sabse pahle kya karna hota hai? What must you do first to enter data in Excel?

6 / 30

6) Excel mein 'Ribbon' kahan paya jata hai? Where is the 'Ribbon' found in Excel?

7 / 30

7) Excel mein 'SUM' function ka kya upyog hai? What is the use of the 'SUM' function in Excel?

8 / 30

8) Excel mein data ko alphabetical order mein arrange karne ke liye kis feature ka upyog kiya jata hai? Which feature is used to arrange data in alphabetical order in Excel?

9 / 30

9) Ek naya Excel workbook banane ke liye kis shortcut key ka upyog kiya jata hai? Which shortcut key is used to create a new Excel workbook?

10 / 30

10) MS Excel 2013 aur uske baad ke versions mein, ek nayi workbook mein default roop se kitni worksheets hoti hain? In MS Excel 2013 and later versions, how many worksheets does a new workbook have by default?

11 / 30

11) MS Excel 2007 aur uske baad ke versions mein Excel workbook ki file extension kya hai? What is the file extension for an Excel workbook in MS Excel 2007 and later versions?

12 / 30

12) MS Excel mein koi bhi formula kis symbol se shuru hota hai? What symbol does any formula in MS Excel begin with?

13 / 30

13) MS Excel mein 'Fill Handle' ka kya upyog hai? What is the purpose of 'Fill Handle' in MS Excel?

14 / 30

14) MS Excel mein cell formatting options (jaise Bold, Italic, Font Size) kis tab mein milte hain? In MS Excel, which tab contains cell formatting options (like Bold, Italic, Font Size)?

15 / 30

15) MS Excel mein numbers ke samooh ka total nikalne ke liye kis function ka upyog kiya jata hai? Which function is used to calculate the sum of a group of numbers in MS Excel?

16 / 30

16) MS Excel mein cell reference ko absolute banane ke liye kis symbol ka upyog kiya jata hai? Which symbol is used to make a cell reference absolute in MS Excel?

17 / 30

17) MS Excel mein ek nayi blank workbook kholne ke liye kis keyboard shortcut ka upyog kiya jata hai? Which keyboard shortcut is used to open a new blank workbook in MS Excel?

18 / 30

18) MS Excel spreadsheet mein rows aur columns ka kya upyog hai? What is the purpose of rows and columns in an MS Excel spreadsheet?

19 / 30

19) Excel mein ek cell kya hai? What is a cell in Excel?

20 / 30

20) Excel mein koi bhi formula kis symbol se shuru hota hai? With which symbol does any formula start in Excel?

21 / 30

21) Excel mein worksheets ke collection ko kya kehte hain? What is a collection of worksheets called in Excel?

22 / 30

22) Excel mein file save karne ke liye shortcut key kya hai? What is the shortcut key to save a file in Excel?

23 / 30

23) Excel mein Name Box kya display karta hai? What does the Name Box display in Excel?

24 / 30

24) Excel mein rows ko kaise identify kiya jaata hai? How are rows identified in Excel?

25 / 30

25) Excel mein kisi cell ki content ko edit karne ka sabse teek tarika kya hai? What is the quickest way to edit the content of a cell in Excel?

26 / 30

26) Microsoft Excel mein spreadsheet file ko kis naam se jana jata hai? By what name is a spreadsheet file known in Microsoft Excel?

27 / 30

27) Excel worksheet mein rows ko kaise identify kiya jata hai? How are rows identified in an Excel worksheet?

28 / 30

28) Excel mein cell address A5 ka kya matlab hai? What does cell address A5 mean in Excel?

29 / 30

29) Excel mein koi formula shuru karne ke liye kis symbol ka upyog kiya jata hai? Which symbol is used to start a formula in Excel?

30 / 30

30) Excel 2010 aur uske baad ke versions ki default file extension kya hai? What is the default file extension for Excel 2010 and later versions?

Your score is

CPCT Eaxm Update Ke Liye Follow Karo

0%

Awesome! Tumne CPCT mock test pass kar liya!

Thank You

Next Quiz →

CPCT Excel Basics Quiz – Ace the CPCT and Boost Your Career

Preparing for the Madhya Pradesh CPCT? Our CPCT Excel Basics Quiz is designed to help you master the essential Excel skills needed to succeed in the exam and secure your dream government job. The CPCT certificate is a mandatory requirement for various government positions in MP, including Patwari, Steno, and Clerical Grade-3, making thorough preparation crucial. Visit the official CPCT website (https://www.cpct.mp.gov.in/) for more details on the exam and its significance. This comprehensive quiz covers key Excel concepts, from basic spreadsheet navigation to data analysis techniques. By practicing with our in-depth CPCT Excel Basics Quiz, you’ll gain the confidence and proficiency needed to excel in the CPCT and open doors to a rewarding career in the government sector. We focus on real-world applications, ensuring you’re not just memorizing answers but truly understanding how to use Excel effectively. Prepare for the MP CPCT with our valuable resources and improve your chances of securing your desired government job. This quiz aligns with the skills required for various roles, including Data Entry Operator, where Excel proficiency is highly valued.

Key Features of Our CPCT Excel Basics Quiz

For more quiz

Old Paper Tests Topic Wise Tests Syllabus Wise Tests Mock Tests

Frequently Asked Questions

What is the default extension of an Excel file?

The default extension of an Excel file is .xlsx, as covered in this CPCT Excel Basics Quiz. Knowing this is essential for file management in government job roles.

How many worksheets can an Excel workbook have?

An Excel workbook can contain multiple worksheets, although it starts with one by default. This is a fundamental concept tested in the MP CPCT Excel Preparation materials.

What's the importance of cell referencing in Excel for CPCT?

Cell referencing is crucial for creating formulas and performing calculations in Excel, a key skill assessed in the CPCT exam for government jobs like Data Entry Operator.