Report a question

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

Data Formatting Quiz 2

Data Formatting Quiz 2

1 / 30

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

2 / 30

2) MS Excel mein cell mein number ko currency format mein badalne ke liye kis option ka upyog kiya jata hai? Which option is used to change a number to currency format in MS Excel?

3 / 30

3) Ek date format DD-MM-YYYY mein 'DD' kya darshata hai? What does 'DD' represent in a date format DD-MM-YYYY?

4 / 30

4) MS Word mein text ko page ke daayein (right) kinare par align karne ke liye kis option ka upyog kiya jata hai? Which option is used to align text to the right edge of the page in MS Word?

5 / 30

5) Documents mein do lines ke beech ki jagah ko badhane ya kam karne ke liye kis formatting option ka upyog hota hai? Which formatting option is used to increase or decrease the space between two lines in documents?

6 / 30

6) MS Excel mein data values ke aadhaar par cells ko automatic roop se format karne ke liye kis feature ka upyog hota hai? Which feature is used to automatically format cells based on data values in MS Excel?

7 / 30

7) Document ke print hone ke tareeke ko landscape ya portrait mein badalne ke liye kis formatting setting ka upyog hota hai? Which formatting setting is used to change how a document prints, either landscape or portrait?

8 / 30

8) Text ke aakaar (size) ko badalne ke liye kis formatting property ka upyog kiya jata hai? Which formatting property is used to change the size of text?

9 / 30

9) Paragraph ki pehli line ko left margin se thoda andar karne ke liye kis formatting option ka upyog hota hai? Which formatting option is used to move the first line of a paragraph slightly inward from the left margin?

10 / 30

10) MS Word mein selected text se sabhi formatting (bold, italic, color, etc.) hatane ke liye kis option ka upyog hota hai? Which option is used to remove all formatting (bold, italic, color, etc.) from selected text in MS Word?

11 / 30

11) MS Word mein text ke appearance ko badalne ke liye kis feature ka upyog hota hai? Which feature is used to change the appearance of text in MS Word?

12 / 30

12) Spreadsheet mein sankhya ko mudra roop mein pradarshit karne ke liye kis format ka upyog kiya jata hai? Which format is used to display numbers as currency in a spreadsheet?

13 / 30

13) Ek cell mein date ko 'DD-MM-YYYY' format mein pradarshit karne ke liye aap kya chunenge? What would you choose to display a date in 'DD-MM-YYYY' format in a cell?

14 / 30

14) Cell mein text ko left, center, ya right mein vyavasthit karne ke liye kis formatting option ka upyog hota hai? Which formatting option is used to arrange text in a cell to left, center, or right?

15 / 30

15) Kisi spreadsheet mein, data ke aadhar par cells ke rang ko automatically badalne ke liye kis feature ka upyog kiya jata hai? In a spreadsheet, which feature is used to automatically change the color of cells based on data?

16 / 30

16) Spreadsheet mein cells ke charon or lines lagane ke liye kis formatting option ka upyog kiya jata hai? Which formatting option is used to draw lines around cells in a spreadsheet?

17 / 30

17) Agar cell mein data bahut lamba ho aur woh adjacent cell mein na ja sake, toh use ek hi cell mein multiple lines mein dikhane ke liye kya upyog karte hain? If data in a cell is too long and cannot go into an adjacent cell, what is used to display it in multiple lines within the same cell?

18 / 30

18) Spreadsheet mein kisi cell se saare formatting (font, colour, border, etc.) ko hatane ke liye kis command ka upyog hota hai? Which command is used to remove all formatting (font, colour, border, etc.) from a cell in a spreadsheet?

19 / 30

19) Sankhya 0.75 ko 75% ke roop mein pradarshit karne ke liye kis number format ka upyog kiya jata hai? Which number format is used to display the number 0.75 as 75%?

20 / 30

20) Copy kiye gaye cell se kewal formatting ko paste karne ke liye 'Paste Special' dialogue box mein kaun sa option chuna jata hai? Which option is selected in the 'Paste Special' dialogue box to paste only the formatting from a copied cell?

21 / 30

21) टेक्स्ट का आकार बदलने के लिए किस विकल्प का उपयोग किया जाता है? Which option is used to change the size of text?

22 / 30

22) पैराग्राफ को बाएं, केंद्र या दाएं संरेखित करने के लिए किस विकल्प का उपयोग किया जाता है? Which option is used to align a paragraph left, center, or right?

23 / 30

23) एक्सेल में संख्याओं को मुद्रा प्रारूप में बदलने के लिए किस सुविधा का उपयोग किया जाता है? Which feature is used to change numbers to currency format in Excel?

24 / 30

24) विशिष्ट मानदंडों के आधार पर सेल के स्वरूप को स्वचालित रूप से बदलने के लिए एक्सेल में किस सुविधा का उपयोग किया जाता है? Which feature is used in Excel to automatically change the appearance of a cell based on specific criteria?

25 / 30

25) तारीखों को "DD-MM-YYYY" प्रारूप में प्रदर्शित करने के लिए कौन सा विकल्प सही है? Which option is correct for displaying dates in "DD-MM-YYYY" format?

26 / 30

26) टेक्स्ट को बोल्ड, इटैलिक या अंडरलाइन करने के लिए किस समूह के विकल्पों का उपयोग किया जाता है? Which group of options is used to make text bold, italic, or underline?

27 / 30

27) एक जगह से फ़ॉर्मेटिंग कॉपी करके दूसरी जगह लागू करने के लिए किस टूल का उपयोग किया जाता है? Which tool is used to copy formatting from one place and apply it to another?

28 / 30

28) एक्सेल में सेल के चारों ओर बॉर्डर जोड़ने के लिए किस विकल्प का उपयोग किया जाता है? Which option is used to add borders around cells in Excel?

29 / 30

29) चयनित टेक्स्ट को अपरकेस, लोअरकेस या कैपिटलाइज्ड केस में बदलने के लिए किस सुविधा का उपयोग किया जाता है? Which feature is used to change selected text to uppercase, lowercase, or capitalized case?

30 / 30

30) टेक्स्ट या सेल से सभी फ़ॉर्मेटिंग हटाने के लिए किस कमांड का उपयोग किया जाता है? Which command is used to remove all formatting from text or cells?

Your score is

CPCT Eaxm Update Ke Liye Follow Karo

0%

Awesome! Tumne CPCT mock test pass kar liya!

Thank You

Next Quiz →

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

Are you preparing for the CPCT exam in Madhya Pradesh? CPCT Data Formatting is a crucial skill tested in the exam. This comprehensive quiz featuring 30 carefully curated questions will sharpen your data formatting skills in MS Word and Excel, essential for various government jobs. The CPCT certificate, mandatory for roles like MP Patwari, Steno, and Clerical Grade-3, significantly enhances your job prospects.

This in-depth quiz covers key data formatting concepts, including shortcuts, number formatting, and alignment. Regular practice on cpctwale.com and referring to the official CPCT website (https://www.cpct.mp.gov.in/) will boost your confidence and improve your chances of securing a government job. A strong grasp of MS Word and Excel formatting is also valuable for private-sector roles. Prepare effectively with our valuable resources and improve your overall computer proficiency.

Key Features of Our CPCT Data Formatting Test

For more quiz

Old Paper Tests Topic Wise Tests Syllabus Wise Tests Mock Tests

Frequently Asked Questions

What are some common data formatting tasks in MS Word?

Common tasks include changing font styles (bold, italics), adjusting alignment, and applying bullet points and numbering. These skills are essential for CPCT exam preparation and improve document presentation.

How can I improve my data formatting skills in MS Excel for the CPCT exam?

Practice using different number formats (currency, percentage), applying formulas, and creating charts. These MS Excel formatting skills are frequently tested in the CPCT.

Why is data formatting important for government job aspirants?

Proper data formatting ensures clear and professional documents, crucial for government jobs. The CPCT exam specifically assesses these skills, making them essential for roles like MP Patwari and Steno.