Report a question

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

Data Formatting Quiz 4


Data Formatting Quiz 4

1 / 30

1) MS Word mein text ko mota (bold) karne ki shortcut key kya hai? What is the shortcut key to make text bold in MS Word?

2 / 30

2) Excel mein default roop se number kis taraf align hote hain? In Excel, by default, numbers are aligned to which side?

3 / 30

3) MS Word mein lagayi gayi sabhi formatting ko hatane ke liye kis option ka upyog kiya jaata hai? Which option is used to remove all applied formatting in MS Word?

4 / 30

4) Excel mein cells ko ek nirdisht shart (condition) ke aadhar par format karne ke liye kis feature ka upyog kiya jata hai? Which feature is used to format cells based on a specific condition in Excel?

5 / 30

5) MS Office mein ek object se formatting copy karke dusre object par apply karne ke liye kis tool ka upyog kiya jata hai? Which tool is used to copy formatting from one object and apply it to another in MS Office?

6 / 30

6) MS Word mein do lines ke beech ki jagah (space) ko badalne ke liye kis option ka upyog kiya jata hai? Which option is used to change the space between two lines in MS Word?

7 / 30

7) Excel mein '1/1/2023' ko '01-Jan-2023' mein badalne ke liye kis formatting ka upyog kiya jaega? Which formatting will be used to change '1/1/2023' to '01-Jan-2023' in Excel?

8 / 30

8) MS Word mein selected text ka font size badhane ke liye shortcut key kya hai? What is the shortcut key to increase the font size of selected text in MS Word?

9 / 30

9) Excel mein poorv-nirdharit formatting (jaise font, border, shading) ke sangrah ko kya kehte hain? What is a collection of pre-defined formatting (like font, border, shading) called in Excel?

10 / 30

10) MS Word mein paragraph ki lines ko dono taraf se barabar karne ke liye kis alignment ka upyog kiya jata hai? Which alignment is used to make paragraph lines even on both sides in MS Word?

11 / 30

11) Excel mein currency format ke liye kaun sa symbol istemal hota hai? Which symbol is used for currency format in Excel?

12 / 30

12) MS Word mein date format badalne ke liye kis option ka upyog kiya ja sakta hai? Which option can be used to change date format in MS Word?

13 / 30

13) Custom data format banane ke liye kis feature ka upyog hota hai? Which feature is used to create custom data format?

14 / 30

14) MS Word mein text ko uppercase mein badalne ke liye kaun sa option hai? Which option is available to change text to uppercase in MS Word?

15 / 30

15) Excel mein percentage format ke liye kaun sa symbol istemal hota hai? Which symbol is used for percentage format in Excel?

16 / 30

16) Excel mein default roop se numbers kis taraf align hote hain? By default, numbers align to which side in Excel?

17 / 30

17) Data ko specific criteria ke adhar par format karne ke liye kis feature ka upyog hota hai? Which feature is used to format data based on specific criteria?

18 / 30

18) MS Word ya Excel mein, selected content se formatting hatane ke liye kaun sa option istemal hota hai? Which option is used to remove formatting from selected content in MS Word or Excel?

19 / 30

19) Excel mein din (day) ko do digit mein display karne ke liye kaun sa format code istemal hota hai? Which format code is used to display day in two digits in Excel?

20 / 30

20) Excel mein default number format kaun sa hai? Which is the default number format in Excel?

21 / 30

21) टेक्स्ट को बोल्ड करने के लिए शॉर्टकट कुंजी क्या है? What is the shortcut key to make text bold?

22 / 30

22) एक्सेल में 0.25 को 25% के रूप में प्रदर्शित करने के लिए किस फॉर्मेट का उपयोग किया जाता है? Which format is used in Excel to display 0.25 as 25%?

23 / 30

23) लेफ्ट अलाइनमेंट' का क्या अर्थ है? What does 'Left Alignment' mean?

24 / 30

24) वर्ड प्रोसेसर में 'लाइन स्पेसिंग' क्या नियंत्रित करती है? What does 'Line Spacing' control in a word processor?

25 / 30

25) DD-MM-YYYY' किस प्रकार के डेटा फॉर्मेट का उदाहरण है? 'DD-MM-YYYY' is an example of what type of data format?

26 / 30

26) एक्सेल में 'कंडीशनल फॉर्मेटिंग' का उपयोग किसलिए किया जाता है? What is 'Conditional Formatting' used for in Excel?

27 / 30

27) निम्न में से कौन सा एक फॉन्ट प्रॉपर्टी नहीं है? Which of the following is NOT a font property?

28 / 30

28) एक्सेल में कई सेल्स को एक सेल में संयोजित करने के लिए किस फंक्शन का उपयोग किया जाता है? Which function is used in Excel to combine multiple cells into one?

29 / 30

29) वर्ड प्रोसेसिंग में 'इंडेंटेशन' क्या करता है? What does 'Indentation' do in word processing?

30 / 30

30) क्लियर फॉर्मेटिंग' ऑप्शन का क्या उद्देश्य है? What is the purpose of the 'Clear Formatting' option?

Your score is

0%

Awesome! Tumne CPCT mock test pass kar liya!

Thank You

Next Quiz →

CPCT Data Formatting Quiz – Ace the CPCT and Get Your Dream Job

Acing the CPCT is crucial for landing a government job in Madhya Pradesh. This CPCT Data Formatting Quiz is meticulously designed to refine your skills in MS Word and Excel, essential tools for any government role. This comprehensive quiz covers key data formatting concepts, including shortcuts, alignment, and conditional formatting, directly aligning with the official CPCT syllabus (https://www.cpct.mp.gov.in/). By mastering these skills, you’ll be well-prepared for the CPCT and increase your chances of securing coveted positions like MP Patwari, Steno, or Clerical Grade-3. Elevate your job prospects with our in-depth CPCT Data Formatting Quiz and take a significant step towards your dream career.

Key Features of Our CPCT Data Formatting Quiz

For more quiz

Frequently Asked Questions

How does this quiz improve my MS Word skills?

This quiz covers crucial MS Word formatting shortcuts and techniques, like Ctrl+B for bold text and 'Clear All Formatting,' improving your efficiency and CPCT exam readiness.

What Excel formatting skills are covered in this quiz?

This quiz tests your knowledge of Excel's default number alignment, conditional formatting, and other essential data formatting skills for the CPCT exam.

Is this quiz relevant to the official CPCT syllabus?

Absolutely! This CPCT Data Formatting Quiz is designed to align with the official CPCT syllabus, ensuring you focus on the most relevant data formatting skills for the exam and future government roles.