MS Excel MCQ Quiz & Study Notes

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

Question 101 : What is the primary purpose of a PivotTable in Excel?

A) To sort data alphabetically

B) To quickly summarize and analyze large amounts of data

C) To create a static backup of a worksheet

D) To write complex macros

Question 102 : Which feature allows you to change the appearance of a cell based on its value?

A) Data Validation

B) Format Painter

C) Conditional Formatting

D) Cell Styles

Question 103 : Which function is used to trap and handle errors in a formula?

A) ISERROR

B) IFERROR

C) ERROR.TYPE

D) IFNA

Question 104 : What does the #REF! error indicate in Excel?

A) The column is too narrow

B) A formula contains an unrecognized function name

C) A formula refers to a cell that is not valid (e.g., deleted)

D) Division by zero was attempted

Question 105 : Which function calculates the number of characters in a text string?

A) COUNT

B) LEN

C) TEXTLENGTH

D) SIZE

Question 106 : Which tool restricts the type of data or the values that users enter into a cell?

A) Conditional Formatting

B) Data Consolidation

C) Data Validation

D) Protect Sheet

Question 107 : What does the function =TRIM(A1) do?

A) Cuts the text in half

B) Removes all spaces from text except for single spaces between words

C) Deletes the cell contents

D) Rounds a number to the nearest decimal

Question 108 : Which error appears if you misspell a function name, such as typing =VLOOKP instead of =VLOOKUP?

A) #VALUE!

B) #NAME?

C) #N/A

D) #REF!

Question 109 : What is the function of the Format Painter tool?

A) It applies mathematical formulas to a range

B) It paints the background color of the worksheet

C) It copies formatting from one place and applies it to another

D) It inserts images into cells

Question 110 : Which function searches for a value in the top row of a table and returns a value in the same column from a specified row?

A) VLOOKUP

B) HLOOKUP

C) INDEX

D) MATCH

📚 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