MS Excel MCQ Quiz & Study Notes

Knowledge Check: MS Excel

Welcome to the MS Excel MCQ Challenge. This section is specifically curated to align with the JOA (IT) 2026 syllabus. By practicing these 154 targeted questions, you will strengthen your understanding of concepts related to MS Excel. Each question includes a detailed explanation to help you bridge the gap between theory and practical application.

Question 141 : The operation of combining two cells into a single cell in Excel is known as:

A) Add

B) Sum

C) Merge

D) Concatenate

Question 142 : Which of the following is the file extension of MS Excel?

A) .exls

B) .xlsx

C) .els

D) .exl

Question 143 : Which of the following statements is NOT true with regards to the Auto Filter option in Microsoft Excel?

A) By filtering information in a worksheet, you can find values quickly.

B) You can set a filter on a column of data at a time.

C) You can control not only what you want to see, but also what you want to exclude.

D) You can search for text and numbers using the Auto Filter option.

Question 144 : The basic unit of a worksheet into which we enter data in Excel is called a ________.

A) Tab

B) Cell

C) Box

D) Range

Question 145 : Excel documents are stored as files called ________.

A) Worksheets

B) Workbooks

C) Workproject

D) Workbooks files called

Question 146 : How are data organized in a spreadsheet?

A) Lines and spaces

B) Layers and Channels

C) Attributes and Translucency

D) Rows and columns

Question 147 : Accidental click on undo button in Excel 2007 is reversed by clicking ________.

A) Revert

B) Step to the Back

C) Redo

D) Step Backward

Question 148 : To remove data from the existing cell in MS-Excel, we use the ________ key.

A) SEO

B) Gopher

C) TCP

D) Delete

Question 149 : Tab key is used for ________.

A) To go upward in a line

B) To go downward in a line

C) To go leftward of the line

D) To indent a line

Question 150 : If you copy =SUM(A1:A5) from Cell A6 to Cell B6, which formula will result for Cell B6 in Excel 2007?

A) =SUM(B1:B5)

B) =SUM(A6:B6)

C) =SUM(B1:B6)

D) =SUM(A1:B1)

← Previous Page 15 of 16 Next Questions →

Discover more technical MCQs by navigating to the next page.

📚 Subject-Wise Practice Sets (मॉक टेस्ट Hub)

पिछले वर्षों के प्रश्नपत्रों से संकलित महत्वपूर्ण प्रश्नों को विषय-वार 25-25 प्रश्नों के सेट्स में हल करें:

📝 Computer Sets 📝 Current Affairs Sets 📝 English Sets 📝 Hindi Sets 📝 HP GK Sets 📝 India GK Sets 📝 Maths Sets 📝 Nursing Sets 📝 Psychology Sets 📝 Reasoning Sets 📝 Sanskrit Sets 📝 Science Sets 📝 World GK Sets

Exam Preparation Strategy for MS Excel

To excel in the JOA (IT) 2026 exam, we recommend reviewing the Study Material tab first to build a conceptual foundation before attempting these MCQs. Understanding the MS Excel lifecycle and its implementation is crucial for scoring high in the computer awareness section. Our content is updated regularly to match the latest HPSSC/HPPSC exam patterns.