Report a question

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

Formulas & Functions Quiz 2

Formulas & Functions Quiz 2

1 / 30

1) एक फ़ॉर्मूला किस प्रतीक से शुरू होता है? Which symbol begins a formula?

2 / 30

2) जब आप किसी सेल से फ़ॉर्मूला कॉपी करते हैं, तो डिफ़ॉल्ट रूप से सेल संदर्भ कैसे बदलते हैं? When you copy a formula from a cell, how do cell references change by default?

3 / 30

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

4 / 30

4) किसी सेल संदर्भ को निरपेक्ष बनाने के लिए किस प्रतीक का उपयोग किया जाता है? Which symbol is used to make a cell reference absolute?

5 / 30

5) जब आप शून्य से भाग करते हैं तो कौन सी त्रुटि दिखाई देती है? Which error appears when you divide by zero?

6 / 30

6) तार्किक परीक्षण करने के लिए किस फ़ंक्शन का उपयोग किया जाता है और परीक्षण के परिणाम के आधार पर अलग-अलग मान लौटाता है? Which function is used to perform a logical test and return different values based on the result of the test?

7 / 30

7) MS Excel में सक्रिय सेल में दर्ज फ़ॉर्मूला कहाँ दिखाई देता है? Where does the formula entered in the active cell appear in MS Excel?

8 / 30

8) MS Excel फ़ार्मूला में संचालन का सही क्रम क्या है? What is the correct order of operations in an MS Excel formula?

9 / 30

9) वर्तमान तिथि को बिना समय के लौटाने के लिए किस फ़ंक्शन का उपयोग किया जाता है? Which function is used to return the current date without the time?

10 / 30

10) MS Excel में VLOOKUP फ़ंक्शन का मुख्य उद्देश्य क्या है? What is the main purpose of the VLOOKUP function in MS Excel?

11 / 30

11) योग के लिए किस फंक्शन का उपयोग किया जाता है? Which function is used for summation?

12 / 30

12) जब कोई सूत्र कॉपी किया जाता है तो सेल संदर्भ स्वचालित रूप से बदल जाता है, इसे क्या कहते हैं? When a formula is copied, the cell reference changes automatically, what is it called?

13 / 30

13) #DIV/0! त्रुटि कब प्रकट होती है? When does the #DIV/0! error appear?

14 / 30

14) IF फ़ंक्शन का मुख्य उद्देश्य क्या है? What is the main purpose of the IF function?

15 / 30

15) संख्याओं की श्रृंखला से अधिकतम मान ज्ञात करने के लिए किस फ़ंक्शन का उपयोग किया जाता है? Which function is used to find the maximum value from a series of numbers?

16 / 30

16) VLOOKUP फ़ंक्शन का उपयोग किस लिए किया जाता है? What is the VLOOKUP function used for?

17 / 30

17) दो या अधिक टेक्स्ट स्ट्रिंग्स को जोड़ने के लिए किस ऑपरेटर का उपयोग किया जाता है? Which operator is used to join two or more text strings?

18 / 30

18) दी गई संख्याओं के औसत की गणना के लिए कौन सा फ़ंक्शन उपयोग किया जाता है? Which function is used to calculate the average of given numbers?

19 / 30

19) संख्याओं वाले सेल की संख्या गिनने के लिए किस फ़ंक्शन का उपयोग किया जाता है? Which function is used to count the number of cells containing numbers?

20 / 30

20) एक्सेल में कोई भी फॉर्मूला किस चिन्ह से शुरू होता है? Any formula in Excel starts with which sign?

21 / 30

21) In a spreadsheet, which symbol must a formula begin with?

22 / 30

22) Which of the following is an example of an absolute cell reference?

23 / 30

23) In MS Excel, the formula =SUM(A1:A5) is an example of what?

24 / 30

24) What does the #DIV/0! error in a cell typically indicate?

25 / 30

25) Which function is used to find the largest value in a range of cells?

26 / 30

26) If you want to perform different calculations based on a condition, which function would you use?

27 / 30

27) What is the correct order of operations in formulas (PEMDAS/BODMAS rule)?

28 / 30

28) Which function counts the number of cells in a range that are NOT empty?

29 / 30

29) What is the primary purpose of the VLOOKUP function?

30 / 30

30) What is the main difference between a formula and a function in a spreadsheet?

Your score is

CPCT Eaxm Update Ke Liye Follow Karo

0%

Awesome! Tumne CPCT mock test pass kar liya!

Thank You

Next Quiz →

CPCT Formulas and Functions – Ace the CPCT and Get Your Dream Job

Are you preparing for the Madhya Pradesh CPCT? Mastering CPCT Formulas and Functions is crucial for success in this exam, which is mandatory for securing coveted government jobs like Patwari, Steno, and various clerical positions. This comprehensive quiz, aligned with the official CPCT syllabus (https://www.cpct.mp.gov.in/), offers invaluable practice to enhance your Excel skills and boost your job prospects. This in-depth CPCT Formulas and Functions quiz covers essential concepts, including using formulas and functions in MS Excel, understanding cell referencing, and applying practical knowledge to solve real-world problems. By practicing these quizzes, you’ll gain the confidence and expertise needed to excel in the CPCT and open doors to a rewarding career in the government sector. Familiarize yourself with functions like SUM and understand how to make cell references absolute using the dollar sign, all vital for CPCT success.

Key Features of Our CPCT Formulas and Functions Quiz

For more quiz

Old Paper Tests Topic Wise Tests Syllabus Wise Tests Mock Tests

Frequently Asked Questions

What types of formulas are commonly used in the CPCT?

The CPCT commonly tests your knowledge of basic Excel formulas, including SUM, AVERAGE, and those involving cell references (relative and absolute, using the dollar sign).

How can I improve my understanding of functions in MS Excel for the CPCT?

Regular practice with cpct formulas quiz and in-depth study of various functions in MS Excel, as outlined on cpctwale.com, are essential for improving your skills. Our quizzes cover functions like SUM and the use of the dollar sign for absolute references, which are vital for the CPCT exam.

Why are formulas and functions in MS Excel important for the CPCT?

Proficiency in excel formulas in cpct and functions in ms excel cpct is essential as it demonstrates practical computer skills required for many government jobs, ensuring you meet the mandatory CPCT certificate criteria.