Report a question

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

Formulas & Functions Quiz 6

Formulas & Functions Quiz 6

1 / 30

1) Spreadsheet mein formula kis symbol se shuru hota hai? English?

2 / 30

2) Jab aap kisi formula ko neeche drag karte hain, to cell references automatically badal jate hain. Yeh kaunsa reference hai? English?

3 / 30

3) Cells A1 se A5 tak ka yog (sum) nikalne ke liye kaunsa formula sahi hai? English?

4 / 30

4) Agar aap kisi sankhya ko zero se divide karte hain, to spreadsheet mein kaunsi error show hogi? English?

5 / 30

5) Kisi cell reference ko absolute banane ke liye kis symbol ka upyog kiya jata hai? English?

6 / 30

6) Conditional logic lagane ke liye kis function ka upyog kiya jata hai jo true ya false ke adhar par alag-alag result deta hai? English?

7 / 30

7) Spreadsheet formulas mein operators ki praathamikta (precedence) kya hai? English?

8 / 30

8) Ek badi range mein kisi specific value ko khojne aur uske corresponding value return karne ke liye kaunsa function upyogi hai? English?

9 / 30

9) MS Excel mein, functions ko kis tab mein categories ke roop mein organize kiya jata hai? English?

10 / 30

10) Jab ek formula apne hi cell ko directly ya indirectly reference karta hai, to ise kya kehte hain? English?

11 / 30

11) A1 se A5 tak cells mein numbers ko jodane ke liye kaun sa formula hai? Which formula is used to add numbers in cells A1 to A5?

12 / 30

12) Spreadsheet mein absolute reference ko kaise darshaya jata hai? How is absolute reference denoted in a spreadsheet?

13 / 30

13) Spreadsheet mein #DIV/0! error kya darshata hai? What does the #DIV/0! error indicate in a spreadsheet?

14 / 30

14) IF function ka sahi syntax kya hai? What is the correct syntax for the IF function?

15 / 30

15) =2+3*4 formula ka parinam kya hoga? What will be the result of the formula =2+3*4?

16 / 30

16) VLOOKUP function ka mukhya uddeshya kya hai? What is the primary purpose of the VLOOKUP function?

17 / 30

17) Jab aap ek formula ko copy karte hain aur cell references automatically badal jate hain, toh ise kya kehte hain? When you copy a formula and cell references change automatically, what is it called?

18 / 30

18) Kaun sa function kewal numbers ko count karta hai, text aur empty cells ko nahi? Which function counts only numbers, ignoring text and empty cells?

19 / 30

19) Kaun sa function numeric value ko specific format ke saath text mein convert karta hai? Which function converts a numeric value to text with a specific format?

20 / 30

20) Agar aap formula mein A$1 jaise cell reference ka upyog karte hain, toh yeh kis prakar ka reference hai? If you use a cell reference like A$1 in a formula, what type of reference is it?

21 / 30

21) Which of the following is the correct syntax for the SUM function in Excel? English?

22 / 30

22) If you copy the formula =A1+B1 from cell C1 to cell C2, what will be the formula in C2? English?

23 / 30

23) Which error indicates division by zero in Excel? English?

24 / 30

24) What is the result of the formula =IF(10>5, "True", "False")? English?

25 / 30

25) What is the result of the formula =5+2*3? English?

26 / 30

26) To keep a cell reference constant when copying a formula, what should you use? English?

27 / 30

27) Which function counts the number of cells that contain numbers in a range? English?

28 / 30

28) Which function returns the current date without the time? English?

29 / 30

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

30 / 30

30) What error occurs when a formula refers to its own cell, either directly or indirectly? English?

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 Quiz – Ace the CPCT and Get Your Dream Job

Preparing for the Madhya Pradesh CPCT? Our CPCT Formulas and Functions 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, including the coveted MP Patwari, Steno, and other clerical positions. This comprehensive quiz covers key concepts in formulas and functions, ensuring you’re well-prepared for the real exam.

Excel proficiency is crucial for many government job roles. Regular practice with our quizzes will significantly improve your understanding of formulas, functions, and other Excel features. This preparation will not only help you pass the CPCT but also boost your overall computer proficiency, making you a strong candidate for various government and private sector jobs. For official information and details about the CPCT, visit the MP CPCT website (https://www.cpct.mp.gov.in/).

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 type of errors might I encounter while working with Excel formulas?

Common errors include #DIV/0! (division by zero) and incorrect cell referencing. Our CPCT Formulas Practice helps you understand and avoid these errors.

Why is understanding SUM formulas important for the CPCT?

SUM formulas are fundamental for data analysis and calculations, a key skill tested in the CPCT and required for various government jobs. Our Excel Formulas in CPCT quiz provides valuable practice.

What symbol indicates the start of a formula in a spreadsheet?

Formulas in spreadsheets always begin with an equals sign (=), which is a fundamental concept tested in the CPCT and essential for Excel proficiency.