MS Excel MCQ Quiz & Study Notes

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

Question 121 : Which logical function checks whether ALL given arguments are TRUE?

A) OR

B) NOT

C) AND

D) XOR

Question 122 : If you want to extract the first 3 characters from the left side of a text string in cell A1, which formula is correct?

A) =LEFT(A1, 3)

B) =START(A1, 3)

C) =EXTRACT(A1, 3, "L")

D) =MID(A1, 1, 3)

Question 123 : What is the purpose of the Text to Columns feature?

A) To change font styles in columns

B) To split data in a single column into multiple columns

C) To convert columns into rows

D) To merge multiple columns into one

Question 124 : Which error indicates that a value is not available to a formula or function, often seen with VLOOKUP?

A) #DIV/0!

B) #N/A

C) #NULL!

D) #VALUE!

Question 125 : What does the F4 key do when you are typing a formula and your cursor is on a cell reference?

A) It deletes the reference

B) It opens the help menu

C) It cycles through absolute and relative reference types (adds/removes $ signs)

D) It saves the workbook

Question 126 : Which function is best used to calculate the payment for a loan based on constant payments and a constant interest rate?

A) LOAN()

B) RATE()

C) PMT()

D) INTEREST()

Question 127 : What does the function =PROPER("john doe") return?

A) JOHN DOE

B) john doe

C) John Doe

D) John doe

Question 128 : Which feature allows you to combine data from multiple worksheets into a single master worksheet?

A) Group Sheets

B) Data Consolidation

C) Merge & Center

D) Scenario Manager

Question 129 : Which of the following is an example of an Excel Add-in used for complex optimization problems?

A) Goal Seek

B) Data Table

C) Solver

D) Power Query

Question 130 : What is a Macro in MS Excel?

A) A large worksheet

B) A pre-recorded sequence of commands and functions used to automate repetitive tasks

C) A complex mathematical formula

D) A type of 3D chart

📚 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