MS Excel MCQ Quiz & Study Notes

Please wait... The bee is on your task.

Question 21 : Which wildcard characters are recognized by Excel?

A) # and @

B) * and ?

C) % and $

D) & and *

Question 22 : Which term is used to join selected cells into one cell?

A) Combine

B) Wrap

C) Merge

D) Link

Question 23 : Which chart represents only one value for each variable?

A) Bar

B) Pie

C) Line

D) Scatter

Question 24 : What does a red triangle at the top right corner of a cell indicate?

A) A formula error

B) A locked cell

C) A comment (cell tip) is associated with the cell

D) Text is overflowing

Question 25 : Which operator is used for concatenation in Excel?

A) +

B) *

C) & (Ampersand)

D) #

Question 26 : To select multiple non-adjacent cells in a worksheet, you will click them while holding which key?

A) Alt

B) Shift

C) Ctrl

D) Tab

Question 27 : When a formatted number does not fit within a cell, what does it display?

A) Error

B) N/A

C) ######

D) #VALUE!

Question 28 : The process of keeping certain rows and columns always visible while scrolling is called?

A) Locking

B) Freezing

C) Anchoring

D) Holding

Question 29 : What does the COUNTA function do?

A) Counts only cells containing numbers

B) Counts blank cells

C) Counts cells matching a criteria

D) Counts any non-empty cells (numbers, text, etc.)

Question 30 : What does VLOOKUP stand for?

A) Value Lookup

B) Variable Lookup

C) Vertical Lookup

D) Visual Lookup

📚 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

MS Excel

Knowledge Check: MS Excel

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

Exam Preparation Strategy for MS Excel