Report a question

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

Excel Basics Quiz 10

Excel Basics Quiz 10

1 / 30

1) MS Excel में विभिन्न शीटों का संग्रह क्या कहलाता है? What is a collection of various sheets called in MS Excel?

2 / 30

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

3 / 30

3) MS Excel में डेटा को क्षैतिज रूप से व्यवस्थित करने वाली इकाइयों को क्या कहा जाता है? What are the units that arrange data horizontally in MS Excel called?

4 / 30

4) Excel में कोई भी सूत्र (formula) शुरू करने से पहले किस प्रतीक (symbol) का उपयोग किया जाता है? Which symbol is used before starting any formula in Excel?

5 / 30

5) संख्याओं के एक समूह का योग ज्ञात करने के लिए Excel में किस फ़ंक्शन का उपयोग किया जाता है? Which function is used in Excel to find the sum of a group of numbers?

6 / 30

6) MS Excel में एक नई वर्कबुक को पहली बार सहेजने (save) के लिए किस कमांड का उपयोग किया जाता है? Which command is used to save a new workbook for the first time in MS Excel?

7 / 30

7) मौजूदा Excel वर्कबुक खोलने के लिए किस शॉर्टकट कुंजी का उपयोग किया जाता है? Which shortcut key is used to open an existing Excel workbook?

8 / 30

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

9 / 30

9) MS Excel में 'फ़ाइल' टैब (File tab) में कौन सा विकल्प नहीं होता है? Which option is NOT present in the 'File' tab in MS Excel?

10 / 30

10) MS Excel में A1 से A5 तक की कोशिकाओं (cells) की श्रेणी को कैसे दर्शाया जाता है? How is the range of cells from A1 to A5 represented in MS Excel?

11 / 30

11) MS Excel mein data enter karne ki sabse chhoti unit kya hai? What is the smallest unit for entering data in MS Excel?

12 / 30

12) Excel 2007 aur uske baad ke versions mein Excel workbook ka default file extension kya hai? What is the default file extension for an Excel workbook in Excel 2007 and later versions?

13 / 30

13) Excel mein sabhi formulas kis character se shuru hone chahiye? What character must all formulas in Excel begin with?

14 / 30

14) Worksheets ke collection ko kya kaha jata hai? A collection of worksheets is known as what?

15 / 30

15) Excel Ribbon par 'Paste', 'Cut', aur 'Copy' ke options kis tab mein hote hain? Which tab on the Excel Ribbon contains options for 'Paste', 'Cut', and 'Copy'?

16 / 30

16) कॉलम C और रो 5 के intersection par ek cell ko sahi tarike se kaise refer karte hain? What is the correct way to refer to a cell at the intersection of column C and row 5?

17 / 30

17) Excel mein kaun si feature ek pattern ke aadhar par data ki series (jaise number, dates, ya formulas) ko automatically bhar deti hai? Which feature in Excel automatically fills a series of data (like numbers, dates, or formulas) based on a pattern?

18 / 30

18) Excel worksheet (Excel 2007 aur baad mein) mein lagbhag kitni rows hoti hain? Approximately, how many rows are there in an Excel worksheet (Excel 2007 and later)?

19 / 30

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

20 / 30

20) Microsoft Excel ka primary uddeshya nimnalikhit mein se kya hai? Which of the following is the primary purpose of Microsoft Excel?

21 / 30

21) MS Excel mein data rakhne ke liye buniyadi ikai kya hai? What is the basic unit for storing data in MS Excel?

22 / 30

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

23 / 30

23) MS Excel mein koi bhi formula kis symbol se shuru hota hai? Which symbol does any formula in MS Excel start with?

24 / 30

24) MS Excel mein worksheets ke sangrah ko kya kaha jata hai? What is a collection of worksheets called in MS Excel?

25 / 30

25) MS Excel mein rows aur columns ko kiske dwara pahchana jata hai? How are rows and columns identified in MS Excel?

26 / 30

26) MS Excel mein cell series jaise numbers, dates ko automatic fill karne ke liye kis feature ka upyog kiya jata hai? Which feature is used in MS Excel to automatically fill cell series like numbers, dates?

27 / 30

27) MS Excel mein 'Home', 'Insert', 'Page Layout' jaise vikalp kahan milte hain? Where are options like 'Home', 'Insert', 'Page Layout' found in MS Excel?

28 / 30

28) MS Excel mein workbook ko save karne ke liye shortcut key kya hai? What is the shortcut key to save a workbook in MS Excel?

29 / 30

29) MS Excel mein active cell ko kiske dwara darshaya jata hai? How is the active cell indicated in MS Excel?

30 / 30

30) MS Excel ka prathamik upyog kya hai? What is the primary use of MS 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 Madhya Pradesh CPCT? Our CPCT Excel Basics Quiz is designed to help you master the essential Excel skills needed to succeed in the exam and secure your dream government job. This comprehensive quiz covers key Excel concepts, ensuring you’re well-prepared for roles like MP Patwari, Steno, and other clerical positions. The CPCT certificate is mandatory for many government jobs in MP, so excelling in Excel is crucial for your career prospects. For official information about the CPCT, visit the MP government website (https://www.cpct.mp.gov.in/). Our CPCT Excel Practice Test and study materials align with the official syllabus, covering topics like rows, columns, formulas, and workbook navigation. Boost your preparation with our in-depth quizzes and improve your chances of landing a government job in Madhya Pradesh. Start your Excel for CPCT Exam preparation today and pave the way for a successful career.

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 a workbook in MS Excel?

A workbook is a collection of worksheets within a single Excel file. It allows you to organize and manage multiple sheets of data in one place, crucial for CPCT Excel Basics Quiz preparation.

How are cell addresses represented in Excel?

Cell addresses are denoted by a combination of the column letter and row number, such as A1 or B2, a fundamental concept in MP CPCT Excel Preparation.

What are rows in MS Excel?

Rows are the horizontal arrangements of data within a worksheet. They are essential for organizing and analyzing data in Excel for the CPCT Exam.