MS Excel MCQ Quiz & Study Notes

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

Question 81 : What happens when the $ sign is entered before both the column letter and row number in a cell address (e.g., $B$2)?

A) A relative reference is created

B) A mixed reference is created

C) An absolute cell reference is created

D) The cell is formatted as currency

Question 82 : Which of the following formulas will result in a computational error in Excel?

A) =SUM(A1:A5)*0

B) =SUM(A1:A5)/(10-10)

C) =A1+B1/1

D) =SUM(A1:A5)^2

Question 83 : What does the Paste Special command allow you to do regarding formulas?

A) Paste the formula as an image

B) Paste the resulting value of a formula instead of the actual formula

C) Paste the formula to a different workbook only

D) Translate the formula

Question 84 : Which shortcut key is used to insert a new worksheet in MS Excel?

A) Ctrl + W

B) F11

C) Shift + F11

D) Ctrl + N

Question 85 : What is the maximum number of characters that a single cell can contain in MS Excel?

A) 256

B) 16,384

C) 32,767

D) 65,536

Question 86 : What is the maximum number of worksheets that can be added to an Excel workbook?

A) 256

B) 1024

C) Limited only by available memory

D) 255

Question 87 : Which function is specifically used to count cells matching a certain criteria?

A) COUNT

B) COUNTA

C) COUNTBLANK

D) COUNTIF

Question 88 : Which function counts only blank cells or cells with an empty string?

A) COUNT

B) COUNTA

C) COUNTBLANK

D) COUNTIF

Question 89 : What is the free, lightweight online version of MS Excel called?

A) Excel Lite

B) Excel Web App

C) Excel for Web

D) Microsoft Sheets

Question 90 : What is another name for a pre-programmed formula in Excel?

A) Macro

B) Function

C) Algorithm

D) Procedure

📚 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