Report a question

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

Data Formatting Quiz 7


Data Formatting Quiz 7

1 / 30

1) MS Excel mein sankhya ko mudra roop mein format karne ke liye kis option ka upyog kiya jata hai? Which option is used to format a number as currency in MS Excel?

2 / 30

2) Cell mein text ko daen (right) taraf align karne ke liye kis formatting tool ka upyog hota hai? Which formatting tool is used to align text to the right in a cell?

3 / 30

3) Cells mein specific sharton ke aadhar par formatting lagane ke liye kis feature ka upyog kiya jata hai? Which feature is used to apply formatting based on specific conditions in cells?

4 / 30

4) Ek cell mein '15/03/2023' ko 'March 15, 2023' mein badalne ke liye kis formatting category ka upyog karenge? Which formatting category would you use to change '15/03/2023' to 'March 15, 2023' in a cell?

5 / 30

5) Ek cell ki formatting ko doosri cells par apply karne ke liye kis tool ka upyog kiya jata hai? Which tool is used to apply the formatting of one cell to other cells?

6 / 30

6) Cell se formatting (jaise font color, background color) ko hatane ke liye kis option ka chayan kiya jata hai? Which option is selected to remove formatting (like font color, background color) from a cell?

7 / 30

7) Text ka akar badalne ke liye kis formatting option ka upyog kiya jata hai? Which formatting option is used to change the size of text?

8 / 30

8) Cells ke charon or line banane ke liye kis formatting feature ka upyog hota hai? Which formatting feature is used to create lines around cells?

9 / 30

9) MS Word mein text ko bade aksharon (uppercase) mein badalne ke liye kis feature ka upyog kiya jata hai? Which feature is used to change text to uppercase in MS Word?

10 / 30

10) Ek decimal number ko pratishat (percentage) ke roop mein pradarshit karne ke liye kis formatting category ka upyog kiya jata hai? Which formatting category is used to display a decimal number as a percentage?

11 / 30

11) संख्या को मुद्रा के रूप में प्रारूपित करने के लिए किस विकल्प का उपयोग किया जाता है? Which option is used to format a number as currency?

12 / 30

12) सेल के भीतर पाठ को क्षैतिज रूप से संरेखित करने के लिए आप किस विकल्प का उपयोग करेंगे? Which option would you use to align text horizontally within a cell?

13 / 30

13) दिनांक को 'DD-MM-YYYY' प्रारूप में बदलने के लिए किस डेटा प्रकार का उपयोग किया जाता है? Which data type is used to convert a date into 'DD-MM-YYYY' format?

14 / 30

14) नियमों के आधार पर कोशिकाओं को स्वचालित रूप से रंगीन करने के लिए किस फ़ॉर्मेटिंग विधि का उपयोग किया जाता है? Which formatting method is used to automatically color cells based on rules?

15 / 30

15) कई कोशिकाओं को एक बड़ी कोशिका में संयोजित करने के लिए किस उपकरण का उपयोग किया जाता है? Which tool is used to combine multiple cells into a single larger cell?

16 / 30

16) यदि सेल की सामग्री सेल की चौड़ाई से अधिक हो तो सामग्री को कई पंक्तियों में प्रदर्शित करने के लिए किस विकल्प का उपयोग किया जाता है? If cell content exceeds cell width, which option is used to display the content in multiple lines?

17 / 30

17) किसी संख्या में दशमलव स्थानों की संख्या को नियंत्रित करने के लिए किस फ़ॉर्मेटिंग विकल्प का उपयोग किया जाता है? Which formatting option is used to control the number of decimal places in a number?

18 / 30

18) संख्या को प्रतिशत के रूप में प्रदर्शित करने के लिए किस डेटा प्रकार का उपयोग किया जाता है? Which data type is used to display a number as a percentage?

19 / 30

19) फ़ॉन्ट, रंग और संरेखण जैसे पूर्वनिर्धारित फ़ॉर्मेटिंग विशेषताओं के समूह को क्या कहा जाता है? What is a collection of predefined formatting characteristics like font, color, and alignment called?

20 / 30

20) किसी सेल से सभी फ़ॉर्मेटिंग (लेकिन सामग्री नहीं) हटाने के लिए किस विकल्प का उपयोग किया जाता है? Which option is used to remove all formatting (but not content) from a cell?

21 / 30

21) Excel mein date ko DD-MM-YYYY format mein display karne ke liye kaun sa option istemal hota hai? Which option is used to display date in DD-MM-YYYY format in Excel?

22 / 30

22) CSV file mein data ko alag karne ke liye aamtaur par kis character ka upyog kiya jata hai? Which character is commonly used to separate data in a CSV file?

23 / 30

23) MS Word mein paragraph ko page ke beech mein align karne ke liye kaun sa alignment option hai? Which alignment option is used to align a paragraph to the center of the page in MS Word?

24 / 30

24) Web pages aur text documents mein character ko represent karne ke liye sabse zyada use hone wala encoding standard kaun sa hai? Which is the most commonly used encoding standard to represent characters in web pages and text documents?

25 / 30

25) Excel mein cells ko unki value ke aadhar par automatically format karne ke liye kis feature ka upyog hota hai? Which feature is used to automatically format cells in Excel based on their values?

26 / 30

26) Document ko landscape orientation mein print karne ka kya matlab hai? What does it mean to print a document in landscape orientation?

27 / 30

27) Digital typography mein font size ko aamtaur par kis unit mein maapa jata hai? In digital typography, font size is commonly measured in which unit?

28 / 30

28) Web applications mein data exchange ke liye kaun sa lightweight data-interchange format use hota hai? Which lightweight data-interchange format is used for data exchange in web applications?

29 / 30

29) MS Word mein do paragraphs ke beech ki jagah ko adjust karne ke liye kaun sa option upyog hota hai? Which option is used to adjust the space between two paragraphs in MS Word?

30 / 30

30) MS Excel mein currency format lagane ke liye kis shortcut key ka upyog kiya jata hai? Which shortcut key is used to apply currency format in MS Excel?

Your score is

0%

Awesome! Tumne CPCT mock test pass kar liya!

Thank You

Next Quiz →

CPCT Data Formatting – Ace the CPCT and Secure Your Dream Job

Preparing for the Madhya Pradesh CPCT? Our CPCT Data Formatting quiz is meticulously designed to help you master data formatting in MS Excel, a crucial skill tested in the CPCT exam. This comprehensive quiz covers key concepts, including currency formatting, cell alignment, and conditional formatting, ensuring you’re well-prepared for the real exam.

Securing a government job in Madhya Pradesh, such as Patwari, Steno, or Clerical Grade-3, requires a CPCT certificate. This mandatory certification validates your computer proficiency, significantly improving your job prospects in both government and private sectors. Practice with our in-depth quizzes and boost your chances of success. For official information about the CPCT, visit https://www.cpct.mp.gov.in/.

Key Features of Our CPCT Data Formatting Test

For more quiz

Frequently Asked Questions

What is conditional formatting in MS Excel?

Conditional formatting allows you to apply specific formatting to cells based on certain conditions, a key aspect of CPCT Excel preparation.

How does this quiz help with CPCT Excel preparation?

This quiz covers crucial MS Excel formatting topics, including date formatting and right alignment, frequently tested in the CPCT.

How does mastering data formatting help in the CPCT?

Strong data formatting skills are essential for excelling in the CPCT's MS Excel section, boosting your overall score and job prospects.