Report a question

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

Excel Basics Quiz 5

Excel Basics Quiz 5

1 / 30

1) Excel mein koi bhi formula kis symbol se shuru hota hai? Which symbol starts any formula in Excel?

2 / 30

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

3 / 30

3) Naye Excel workbook mein default roop se kitni worksheets hoti hain? How many worksheets are there by default in a new Excel workbook?

4 / 30

4) Excel mein cells ke sum (yog) ke liye kaun sa function istemal hota hai? Which function is used for the sum of cells in Excel?

5 / 30

5) Excel mein A1 se B5 tak ki range ko kaise darshaya jaata hai? How is the range from A1 to B5 represented in Excel?

6 / 30

6) Microsoft Excel ka primary upyog kya hai? What is the primary use of Microsoft Excel?

7 / 30

7) Excel mein worksheet mein sabse pehle cell (A1) par jaane ke liye kaun sa shortcut key combination hai? Which shortcut key combination is used to go to the first cell (A1) in an Excel worksheet?

8 / 30

8) Excel kya hai? What is Excel?

9 / 30

9) Excel file ko kya kehte hain? What is an Excel file called?

10 / 30

10) Excel 2016 ki default file extension kya hai? What is the default file extension for Excel 2016?

11 / 30

11) Excel mein formula kis symbol se shuru hota hai? With which symbol does a formula start in Excel?

12 / 30

12) Cell range A1 se A5 tak ka yog (sum) karne ke liye kaun sa formula upyog kiya jata hai? Which formula is used to sum the cell range A1 to A5?

13 / 30

13) Cell mein data ko automatically copy aur extend karne ke liye kis feature ka upyog karte hain? Which feature is used to automatically copy and extend data in a cell?

14 / 30

14) Excel mein Ribbon kahan hota hai? Where is the Ribbon located in Excel?

15 / 30

15) Excel mein jis cell mein aap kaam kar rahe hote hain, use kya kehte hain? What is the cell you are currently working in called in Excel?

16 / 30

16) Excel mein ek naya workbook banane ke liye kaun sa shortcut key upyog hota hai? Which shortcut key is used to create a new workbook in Excel?

17 / 30

17) एक वर्कशीट में सबसे छोटी इकाई क्या है? What is the smallest unit in a worksheet?

18 / 30

18) MS Excel में कई वर्कशीटों का संग्रह क्या कहलाता है? What is a collection of multiple worksheets called in MS Excel?

19 / 30

19) MS Excel में कोई भी फॉर्मूला हमेशा किस प्रतीक से शुरू होता है? Any formula in MS Excel always begins with which symbol?

20 / 30

20) MS Excel में वर्तमान में चयनित या सक्रिय सेल को क्या कहते हैं? What is the currently selected or active cell called in MS Excel?

21 / 30

21) MS Excel 2007 और उसके बाद के संस्करणों की फ़ाइल एक्सटेंशन क्या है? What is the file extension of MS Excel 2007 and later versions?

22 / 30

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

23 / 30

23) MS Excel में डेटा या फॉर्मूले को आसन्न सेल में तेज़ी से कॉपी करने के लिए किस छोटे वर्ग का उपयोग किया जाता है? Which small square is used to quickly copy data or formulas to adjacent cells in MS Excel?

24 / 30

24) MS Excel में, पंक्तियों (rows) और स्तंभों (columns) की पहचान क्रमशः कैसे की जाती है? In MS Excel, how are rows and columns identified respectively?

25 / 30

25) MS Excel में एक सेल का पता (address) कैसे दर्शाया जाता है? How is the address of a cell represented in MS Excel?

26 / 30

26) MS Excel वर्कशीट में दिखाई देने वाली हल्की रेखाएँ जो कोशिकाओं को अलग करती हैं, उन्हें क्या कहते हैं? What are the faint lines that appear in an MS Excel worksheet separating cells called?

27 / 30

27) Excel mein sabse basic unit kya hai? What is the most basic unit in Excel?

28 / 30

28) Excel mein cell address kaise darshaya jata hai? How is a cell address represented in Excel?

29 / 30

29) Excel mein formula kis sign se shuru hota hai? Which sign does a formula start with in Excel?

30 / 30

30) Ek Excel file ko kya kehte hain? What is an Excel file called?

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 Boost Your Career

Preparing for the CPCT Excel Basics Quiz is crucial for securing various government jobs in Madhya Pradesh, including coveted positions like Patwari and Stenographer. This comprehensive quiz, featuring 30 carefully curated questions, helps you build a strong foundation in Excel, a mandatory skill tested in the CPCT exam. Excelling in the CPCT significantly improves your prospects of landing your dream government job. Visit the official CPCT website (https://www.cpct.mp.gov.in/) for more details on the exam and its importance. Our CPCT Excel Basics Quiz covers essential topics like formulas, functions, and cell navigation, mirroring the actual CPCT exam format. By practicing with our in-depth quizzes and understanding the core concepts of Excel, you gain the confidence and skills to succeed in the CPCT and unlock numerous career opportunities in MP.

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 types of Excel formulas are commonly tested in the CPCT?

The CPCT often tests basic formulas like SUM, AVERAGE, and those related to cell referencing. Our CPCT Excel Practice Test covers these key areas comprehensively, ensuring you're well-prepared.

How does this quiz help me prepare for the actual CPCT Excel section?

This quiz simulates the real exam environment, covering essential Excel proficiency topics. It provides valuable practice and reinforces your understanding of core concepts, boosting your CPCT Excel score.

Are the questions in this quiz similar to those in the official CPCT?

Our quiz questions are designed to match the difficulty and style of the official CPCT Excel Basics section, offering relevant practice and increasing your chances of success in the MP Govt Jobs requiring CPCT certification.