Q: A file created in MS Excel is called a:

Workbook (वर्कबुक)

Question 1

What is a spreadsheet mainly used for?

Accepted Answer

Organizing and calculating data in rows and columns (पंक्तियों और स्तंभों में डेटा को व्यवस्थित करने और गणना करने के लिए)

Question 2

Which of the following is a spreadsheet software?

Accepted Answer

MS Excel (एमएस एक्सेल)

Question 3

A file created in MS Excel is called a:

Accepted Answer

Workbook (वर्कबुक)

Question 4

The default file extension of a modern Excel workbook is:

Accepted Answer

.xlsx (.xlsx)

Question 5

The intersection of a row and a column in a worksheet is called a:

Accepted Answer

Cell (सेल)

Question 6

In MS Excel, columns are labeled with:

Accepted Answer

Letters (अक्षरों से)

Question 7

In MS Excel, rows are labeled with:

Accepted Answer

Numbers (संख्याओं से)

Question 8

The cell reference "C10" refers to:

Accepted Answer

Column C, Row 10 (स्तंभ C, पंक्ति 10)

Question 9

A group of two or more cells in a worksheet is called a:

Accepted Answer

Range (रेंज)

Question 10

Which bar displays the content of the currently selected cell?

Accepted Answer

Formula bar (फॉर्मूला बार)

Question 11

The box that displays the cell reference or name of the selected cell is called the:

Accepted Answer

Name Box (नेम बॉक्स)

Question 12

Every formula in Excel must begin with:

Accepted Answer

= (=)

Question 13

Which function is used to add a range of numbers in Excel?

Accepted Answer

SUM (सम)

Question 14

Which function returns the average of a range of numbers?

Accepted Answer

AVERAGE (एवरेज)

Question 15

Which function returns the largest value in a range?

Accepted Answer

MAX (मैक्स)

Question 16

Which function returns the smallest value in a range?

Accepted Answer

MIN (मिन)

Question 17

Which function counts the number of cells that contain numbers?

Accepted Answer

COUNT (काउंट)

Question 18

Which function is used to perform a conditional test and return one of two values?

Accepted Answer

IF (इफ)

Question 19

In the formula =A1+B1, A1 and B1 are examples of:

Accepted Answer

Cell references (सेल संदर्भ)

Question 20

A cell reference like $A$1 is called a(n):

Accepted Answer

Absolute reference (एब्सोल्यूट रेफरेंस)

Question 21

A cell reference that changes automatically when copied to another cell, like A1, is called:

Accepted Answer

Relative reference (रिलेटिव रेफरेंस)

Question 22

Which symbol is used to lock a row or column in a cell reference (absolute reference)?

Accepted Answer

$ ($)

Question 23

The small square at the bottom-right corner of a selected cell, used to copy data or formulas, is called the:

Accepted Answer

Fill Handle (फिल हैंडल)

Question 24

Which feature automatically fills a series of numbers, dates, or text based on a pattern?

Accepted Answer

Auto Fill (ऑटो फिल)

Question 25

Which feature combines two or more adjacent cells into a single larger cell?

Accepted Answer

Merge Cells (मर्ज सेल्स)

Question 26

Which of the following is used to arrange data in ascending or descending order?

Accepted Answer

Sort (सॉर्ट)

Question 27

Which feature displays only the rows that meet certain criteria, hiding the rest?

Accepted Answer

Filter (फिल्टर)

Question 28

Which feature keeps specific rows or columns visible while scrolling through a large worksheet?

Accepted Answer

Freeze Panes (फ्रीज पेन्स)

Question 29

A visual representation of worksheet data, such as a bar or pie diagram, is called a:

Accepted Answer

Chart (चार्ट)

Question 30

Which of the following is NOT a type of chart available in MS Excel?

Accepted Answer

Paragraph Chart (पैराग्राफ चार्ट)

Question 31

Conditional Formatting in Excel is used to:

Accepted Answer

Automatically format cells based on their values (सेल के मानों के आधार पर उन्हें स्वतः फॉर्मेट करने के लिए)

Question 32

Which feature checks and restricts the type of data that can be entered into a cell?

Accepted Answer

Data Validation (डेटा वैलिडेशन)

Question 33

Freezing panes is most useful when working with:

Accepted Answer

Large worksheets with headers (हेडर वाली बड़ी वर्कशीट के साथ)

Question 34

To insert a new worksheet in an Excel workbook, you generally click the:

Accepted Answer

New Sheet (+) tab (न्यू शीट (+) टैब)

Question 35

Which keyboard shortcut is used to save a workbook in MS Excel?

Accepted Answer

Ctrl+S (Ctrl+S)

Question 36

Which keyboard shortcut is used to open a new workbook?

Accepted Answer

Ctrl+N (Ctrl+N)

Question 37

Which keyboard shortcut is used to open an existing workbook?

Accepted Answer

Ctrl+O (Ctrl+O)

Question 38

Which keyboard shortcut is used to print a worksheet?

Accepted Answer

Ctrl+P (Ctrl+P)

Question 39

Which keyboard shortcut selects an entire column in Excel?

Accepted Answer

Ctrl+Spacebar (Ctrl+Spacebar)

Question 40

Which keyboard shortcut selects an entire row in Excel?

Accepted Answer

Shift+Spacebar (Shift+Spacebar)

Question 41

Which key is commonly used to move to the next cell to the right in a row?

Accepted Answer

Tab (टैब)

Question 42

Which key is commonly used to move to the cell below in a column?

Accepted Answer

Enter (एंटर)

Question 43

A pivot table in Excel is mainly used to:

Accepted Answer

Summarize and analyze large amounts of data (बड़ी मात्रा में डेटा को संक्षेपित और विश्लेषित करने के लिए)

Question 44

The horizontal and vertical lines that divide a worksheet into cells are called:

Accepted Answer

Gridlines (ग्रिडलाइन)

Question 45

Which of the following formulas would correctly add the values in cells A1 and A2?

Accepted Answer

=A1+A2 (=A1+A2)

Question 46

Which tab in the Excel ribbon contains options for changing font, alignment, and number formatting?

Accepted Answer

Home (होम)

Question 47

Which tab in the Excel ribbon is used to insert charts, tables, and pictures?

Accepted Answer

Insert (इन्सर्ट)

Question 48

Which tab in the Excel ribbon contains tools for sorting and filtering data?

Accepted Answer

Data (डेटा)

Question 49

Protecting a worksheet or workbook with a password is mainly done to:

Accepted Answer

Prevent unauthorized changes (अनधिकृत परिवर्तनों को रोकने के लिए)

Question 50

Which of these is an example of a spreadsheet application other than MS Excel?

Accepted Answer

Google Sheets (गूगल शीट्स)

Chapter 4: Introduction to Spreadsheet

Great job!

Answer Review / उत्तर देखें

🏆 Leaderboard —