Report a question

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

Excel Basics Quiz 9


Excel Basics Quiz 9

1 / 30

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

2 / 30

2) एक मानक एक्सेल वर्कबुक के लिए फ़ाइल एक्सटेंशन क्या है? What is the file extension for a standard Excel workbook?

3 / 30

3) एक्सेल में किसी फ़ॉर्मूला की शुरुआत किस प्रतीक से होनी चाहिए? Which symbol must a formula begin with in Excel?

4 / 30

4) एक्सेल में फिल हैंडल का उद्देश्य क्या है? What is the purpose of the Fill Handle in Excel?

5 / 30

5) कार्यपत्रकों के संग्रह को क्या कहा जाता है? What is a collection of worksheets called?

6 / 30

6) निम्नलिखित में से कौन-सा डेटा का प्रकार नहीं है जिसे एक्सेल सेल में दर्ज किया जा सकता है? Which of the following is NOT a type of data that can be entered into an Excel cell?

7 / 30

7) एक्सेल सेल में टेक्स्ट के लिए डिफ़ॉल्ट संरेखण क्या है? What is the default alignment for text in an Excel cell?

8 / 30

8) एक्सेल वर्कशीट में सेल A1 पर तेज़ी से जाने के लिए कौन सा कीबोर्ड शॉर्टकट है? What is the keyboard shortcut to quickly move to cell A1 in an Excel worksheet?

9 / 30

9) एक्सेल के रिबन में कौन सा टैब आम तौर पर फ़ॉन्ट, संरेखण और संख्या प्रारूप जैसे मूल फ़ॉर्मेटिंग के विकल्प रखता है? Which tab in Excel's Ribbon typically contains options for basic formatting like Font, Alignment, and Number formats?

10 / 30

10) Excel mein cell ke address ko kya kaha jata hai? What is a cell's address called in Excel?

11 / 30

11) Excel mein workbook kya hoti hai? What is a workbook in Excel?

12 / 30

12) Excel mein koi bhi formula kis symbol se shuru hota hai? Which symbol does any formula in Excel start with?

13 / 30

13) Excel mein 'Ribbon' kya hai? What is 'Ribbon' in Excel?

14 / 30

14) Excel mein AutoFill feature ka kya upyog hai? What is the use of the AutoFill feature in Excel?

15 / 30

15) Excel mein cells ki range ka total nikalne ke liye kis function ka upyog kiya jata hai? Which function is used to calculate the total of a range of cells in Excel?

16 / 30

16) Excel mein, ek 'active cell' kya hoti hai? What is an 'active cell' in Excel?

17 / 30

17) Excel mein rows ko kisse identify kiya jata hai? How are rows identified in Excel?

18 / 30

18) Excel mein kisi workbook ko save karne ke liye konsi shortcut key ka upyog kiya jata hai? Which shortcut key is used to save a workbook in Excel?

19 / 30

19) एक एक्सेल फ़ाइल को क्या कहा जाता है? What is an Excel file called?

20 / 30

20) एक्सेल में एक नया वर्कबुक बनाने के लिए शॉर्टकट कुंजी क्या है? What is the shortcut key to create a new workbook in Excel?

21 / 30

21) एक्सेल में हर फ़ॉर्मूला किस प्रतीक से शुरू होता है? Every formula in Excel starts with which symbol?

22 / 30

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

23 / 30

23) एक एक्सेल वर्कबुक को सेव करने के लिए शॉर्टकट कुंजी क्या है? What is the shortcut key to save an Excel workbook?

24 / 30

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

25 / 30

25) कौन सा फ़ंक्शन संख्याओं की एक श्रेणी का योग (total) गणना करता है? Which function calculates the total of a range of numbers?

26 / 30

26) एक एक्सेल वर्कशीट में अधिकतम कितनी पंक्तियाँ (rows) होती हैं? What is the maximum number of rows in an Excel worksheet?

27 / 30

27) चार्ट डालने (insert) के विकल्प किस रिबन टैब में होते हैं? Which ribbon tab contains options to insert charts?

28 / 30

28) एक सक्रिय सेल के निचले-दाएं कोने पर स्थित छोटे वर्ग को क्या कहा जाता है? What is the small square at the bottom-right corner of an active cell called?

29 / 30

29) Excel mein cell ko kis prakar identify kiya jata hai? How is a cell identified in Excel?

30 / 30

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

Your score is

0%

Awesome! Tumne CPCT mock test pass kar liya!

Thank You

Next Quiz →

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

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 mandatory for various roles like MP Patwari, Stenographer, and other clerical positions, making thorough preparation crucial. This comprehensive quiz covers key Excel concepts, from basic formulas and functions to data manipulation and formatting. By practicing with our in-depth quizzes and referring to the official CPCT website (https://www.cpct.mp.gov.in/), you’ll gain the confidence and expertise to excel in the CPCT and open doors to a rewarding career in the government sector. Enhance your MP CPCT Excel Preparation today and take the first step towards your dream job. Our Excel for CPCT Exam resources are tailored to the specific requirements of the test, covering everything you need to know to pass with flying colors.

Key Features of Our CPCT Excel Basics Quiz

For more quiz

Frequently Asked Questions

What is the significance of the '=' symbol in Excel formulas?

In Excel, all formulas must begin with the '=' symbol. This signifies to Excel that the following characters constitute a formula to be calculated. It's a fundamental concept in Excel for CPCT Exam preparation.

How does understanding cell intersections help in Excel?

The intersection of a row and column in Excel is called a cell. Each cell has a unique address, which is essential for referencing data and creating formulas for MP CPCT Excel Preparation.

What is the standard file extension for an Excel workbook?

The standard file extension for an Excel workbook is '.xlsx'. Knowing this is helpful for file management during your CPCT Online Practice Test.