Report a question

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

Excel Basics Quiz 1

Excel Basics Quiz 1

1 / 30

1) MS Excel mein default roop se kitni sheets hoti hain? How many sheets are there by default in MS Excel?

2 / 30

2) Excel mein row aur column ke intersection ko kya kehte hain? What is the intersection of a row and column called in Excel?

3 / 30

3) Excel mein formula hamesha kis symbol se shuru hota hai? With which symbol does a formula always begin in Excel?

4 / 30

4) Excel mein active cell ko kaise pehchante hain? How is an active cell identified in Excel?

5 / 30

5) MS Excel mein 'Home', 'Insert', 'Page Layout' jaise options kahan hote hain? Where are options like 'Home', 'Insert', 'Page Layout' located in MS Excel?

6 / 30

6) Excel mein default roop se number alignment kya hota hai? What is the default alignment for numbers in Excel?

7 / 30

7) MS Excel ka primarily upyog kisliye kiya jaata hai? For what is MS Excel primarily used?

8 / 30

8) MS Excel worksheet mein adhikatam kitni rows ho sakti hain? What is the maximum number of rows in an MS Excel worksheet?

9 / 30

9) Naya workbook banane ke liye kis keyboard shortcut ka upyog kiya jaata hai? Which keyboard shortcut is used to create a new workbook?

10 / 30

10) Cells A1 se A5 tak ki sankhyaon ka yog karne ke liye kaunsa formula sahi hai? Which formula is correct to sum the numbers from cells A1 to A5?

11 / 30

11) MS Excel mein 'active cell' ko kaise pehchante hain? How do you identify the 'active cell' in MS Excel?

12 / 30

12) MS Excel mein formula hamesha kis symbol se shuru hota hai? With what symbol does a formula always begin in MS Excel?

13 / 30

13) MS Excel mein 'workbook' aur 'worksheet' ke beech kya antar hai? What is the difference between 'workbook' and 'worksheet' in MS Excel?

14 / 30

14) MS Excel mein cell address ka sahi udaharan kya hai? What is the correct example of a cell address in MS Excel?

15 / 30

15) MS Excel mein AutoFill feature ka upyog kisliye kiya jata hai? What is the purpose of the AutoFill feature in MS Excel?

16 / 30

16) MS Excel mein cells ki range ka total nikalne ke liye kis function ka upyog kiya jata hai? Which function is used to calculate the total of a range of cells in MS Excel?

17 / 30

17) MS Excel 2007 aur uske baad ke versions ki default file extension kya hai? What is the default file extension for MS Excel 2007 and later versions?

18 / 30

18) MS Excel mein 'Ribbon' ka mukhya uddeshya kya hai? What is the main purpose of the 'Ribbon' in MS Excel?

19 / 30

19) MS Excel mein ek nayi worksheet add karne ke liye aap kya karenge? What would you do to add a new worksheet in MS Excel?

20 / 30

20) MS Excel mein ek worksheet ka naam badalne ke liye sabse aasan tareeka kya hai? What is the easiest way to rename a worksheet in MS Excel?

21 / 30

21) Excel mein ek cell ko kiske dwara pahchana jata hai? How is a cell identified in Excel?

22 / 30

22) Excel mein 'workbook' kya hai? What is a 'workbook' in Excel?

23 / 30

23) Excel mein koi bhi formula kis symbol se shuru hota hai? With what symbol does any formula start in Excel?

24 / 30

24) Nimnalikhit mein se kaun sa ek vaidh (valid) cell address ka udaharan hai? Which of the following is an example of a valid cell address?

25 / 30

25) Excel mein 'Fill Handle' ka kya upyog hai? What is the use of 'Fill Handle' in Excel?

26 / 30

26) MS Excel 2007 aur uske baad ke versions ke liye default file extension kya hai? What is the default file extension for MS Excel 2007 and later versions?

27 / 30

27) Excel mein cells ki ek range ka total karne ke liye kis function ka upyog kiya jata hai? Which function is used to total a range of cells in Excel?

28 / 30

28) Excel mein 'Ribbon' kahan sthit hota hai? Where is the 'Ribbon' located in Excel?

29 / 30

29) Excel mein 'active cell' kya hai? What is an 'active cell' in Excel?

30 / 30

30) Excel mein data ki shaitij (horizontal) vyavastha ko kya kehte hain? What is the horizontal arrangement of data called in Excel?

Your score is

CPCT Eaxm Update Ke Liye Follow Karo

0%

Awesome! Tumne CPCT mock test pass kar liya!

Thank You

Next Quiz →

CPCT Excel Basics Quiz – Ace the CPCT and Get Your Dream Job

Preparing for the CPCT Excel Basics Quiz is crucial for securing a government job in Madhya Pradesh. This comprehensive CPCT Excel Basics Quiz covers essential concepts, helping you gain the computer proficiency required for roles like Patwari, Steno, and Clerical Grade-3. The CPCT certificate is mandatory for many MP government jobs, making thorough preparation essential. Boost your chances of success by mastering Excel with our in-depth quiz and practice resources. For official information about the CPCT, visit https://www.cpct.mp.gov.in/. Our CPCT Excel Preparation resources are designed to give you the edge you need. By focusing on key areas tested in the CPCT, such as cell referencing, formulas, and basic functions, you’ll be well-equipped to tackle the exam confidently. Practice regularly with our Excel for CPCT quizzes to improve your speed and accuracy, increasing your chances of achieving a high score and landing your dream government job.

Key Features of Our CPCT Excel Basics Quiz

For more quiz

Old Paper Tests Topic Wise Tests Syllabus Wise Tests Mock Tests

Frequently Asked Questions

What is the significance of the '=' symbol in Excel formulas?

In Excel, formulas always begin with the '=' symbol. This symbol indicates to Excel that the following text is a formula to be calculated, not just plain text. This is fundamental for CPCT Excel Basics preparation.

How can I identify the active cell in an Excel worksheet?

The active cell in Excel is easily identified by its darkened border. This visual cue helps you know which cell you are currently working in, which is important for CPCT Excel for Govt Jobs preparation.

How many worksheets are there in a new Excel workbook by default?

A new Excel workbook typically contains three worksheets by default. Understanding workbook structure is essential for effective Excel use and CPCT Excel Preparation.