Report a question

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

Excel Basics Quiz 3


Excel Basics Quiz 3

1 / 30

1) MS Excel mein ek cell ko kiske dwara identify kiya jaata hai? In MS Excel, by what is a cell identified?

2 / 30

2) MS Excel mein ek formula kis symbol se shuru hota hai? In MS Excel, with which symbol does a formula begin?

3 / 30

3) MS Excel 2013 aur uske baad ke versions mein by default kitni worksheets hoti hain? In MS Excel 2013 and later versions, how many worksheets are there by default?

4 / 30

4) MS Excel mein active cell ko kaise pehchana jaata hai? In MS Excel, how is the active cell identified?

5 / 30

5) MS Excel mein ek nayi blank workbook banane ke liye kaun sa keyboard shortcut istemal kiya jaata hai? Which keyboard shortcut is used to create a new blank workbook in MS Excel?

6 / 30

6) MS Excel mein "Ribbon" ka mukhya uddeshya kya hai? What is the main purpose of the "Ribbon" in MS Excel?

7 / 30

7) MS Excel 2007 aur uske baad ke versions mein default file extension kya hai? What is the default file extension in MS Excel 2007 and later versions?

8 / 30

8) MS Excel mein kisi cell ke content ko edit karne ka sabse aasan tarika kya hai? What is the easiest way to edit the content of a cell in MS Excel?

9 / 30

9) MS Excel mein "Workbook" kya hai? What is a "Workbook" in MS Excel?

10 / 30

10) MS Excel mein cursor ko cell A1 par le jaane ke liye kaun sa keyboard shortcut istemal kiya jaata hai? Which keyboard shortcut is used to move the cursor to cell A1 in MS Excel?

11 / 30

11) एक रो (पंक्ति) और एक कॉलम (स्तंभ) के प्रतिच्छेदन को क्या कहा जाता है? What is the intersection of a row and a column called?

12 / 30

12) एक्सेल वर्कबुक के लिए डिफ़ॉल्ट फ़ाइल एक्सटेंशन क्या है? What is the default file extension for an Excel workbook?

13 / 30

13) एक्सेल में सभी फ़ार्मूले किस प्रतीक से शुरू होने चाहिए? Which symbol must all formulas in Excel begin with?

14 / 30

14) एक्सेल में 'पेस्ट' कमांड किस टैब में होता है? Which tab contains the 'Paste' command in Excel?

15 / 30

15) एक्सेल में एक सेल की पहचान कैसे की जाती है? How is a cell identified in Excel?

16 / 30

16) एक्सेल में डेटा की एक श्रृंखला को स्वचालित रूप से भरने में कौन सी सुविधा मदद करती है? Which feature helps to automatically fill a series of data in Excel?

17 / 30

17) एक्सेल में वर्कशीट के संग्रह को क्या कहा जाता है? What is a collection of worksheets called in Excel?

18 / 30

18) एक्सेल में संख्याओं की एक श्रृंखला का कुल योग (टोटल) निकालने के लिए किस फ़ंक्शन का उपयोग किया जाता है? Which function is used to calculate the total of a range of numbers in Excel?

19 / 30

19) एक्सेल में चयनित सेल पर 'डिलीट' कुंजी दबाने पर क्या होता है? What happens when you press the 'Delete' key on a selected cell in Excel?

20 / 30

20) माइक्रोसॉफ्ट एक्सेल का मुख्य रूप से किस उद्देश्य के लिए उपयोग किया जाता है? For what main purpose is Microsoft Excel primarily used?

21 / 30

21) Excel mein cell ko kaise pahchana jata hai? How is a cell identified in Excel?

22 / 30

22) Excel mein ek workbook kya hai? What is a workbook in Excel?

23 / 30

23) Excel mein formula hamesha kis symbol se shuru hota hai? With which symbol does a formula always start in Excel?

24 / 30

24) Excel mein Ribbon kahan sthit hota hai? Where is the Ribbon located in Excel?

25 / 30

25) Excel mein AutoSum function ka kya upyog hai? What is the use of the AutoSum function in Excel?

26 / 30

26) Excel mein active cell kya darshata hai? What does an active cell indicate in Excel?

27 / 30

27) Excel mein Fill Handle ka kya upyog hai? What is the use of Fill Handle in Excel?

28 / 30

28) Excel mein worksheets ke naam kahan dikhayi dete hain? Where are the names of worksheets displayed in Excel?

29 / 30

29) Excel mein 'Merge & Center' feature ka kya upyog hai? What is the use of the 'Merge & Center' feature in Excel?

30 / 30

30) MS Excel mein row aur column ke intersection ko kya kehte hain? What is the intersection of a row and a column called in MS Excel?

Your score is

0%

Awesome! Tumne CPCT mock test pass kar liya!

Thank You

Next Quiz →

CPCT Excel Quiz – Ace the CPCT and Secure Your Dream Job

Preparing for the CPCT exam? Our CPCT Excel Quiz is designed to help you master the essential Microsoft Excel skills needed to succeed in the exam and secure your dream government job in Madhya Pradesh. This comprehensive quiz covers key Excel concepts, ensuring you’re well-prepared for the CPCT and increasing your chances of landing coveted roles like MP Patwari, Steno, or other clerical positions.

The CPCT certification is mandatory for many government jobs in MP. By practicing with our in-depth quizzes and familiarizing yourself with the types of questions asked, you’ll gain the confidence and proficiency required to pass the CPCT. For official information and details about the exam, visit the MP CPCT website (https://www.cpct.mp.gov.in/). Start your preparation journey with cpctwale.com and take a significant step towards a successful career in the government sector. Practice your Excel for CPCT Exam skills today!

Key Features of Our CPCT Excel Quiz

For more quiz

Frequently Asked Questions

What is a cell address in MS Excel, and why is it important?

A cell address, like A1 or B2, uniquely identifies each cell in a worksheet. Understanding cell addresses is fundamental for using formulas and navigating within Excel, which are key skills tested in the MP CPCT Excel Preparation.

How do formulas begin in MS Excel, and what role do they play?

Formulas in Excel always start with an equals sign (=). They are used for calculations and data manipulation, making them crucial for CPCT Excel Practice Test success and overall Excel proficiency.

How many worksheets are there by default in recent Excel versions?

By default, Excel 2013 and later versions have one worksheet. Knowing how to manage and navigate worksheets is essential for CPCT Excel Practice Test and using Excel efficiently for government job tasks.