MS Excel MCQ Quiz & Study Notes

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

Question 71 : How many total cells are referenced in the range A10:D30?

A) 80

B) 84

C) 21

D) 28

Question 72 : What is the value of =ROUND(8.50, 0) in MS Excel?

A) 8

B) 8.5

C) 9

D) 0

Question 73 : What is the correct address of the cell located at Row 25 and Column Y?

A) 25Y

B) Y-25

C) Y25

D) ColYRow25

Question 74 : In a table with data filled in A1 to D5 (total 12 non-empty cells), what does =COUNTA(A1:D5) return?

A) 20

B) 5

C) 12

D) 4

Question 75 : Which of the following is NOT an option under the View > Freeze Panes menu?

A) Freeze Panes

B) Freeze Top Row

C) Freeze 1st Column

D) Freeze Bottom Row

Question 76 : What was the default number of worksheets in an MS Excel 2013 (and prior) workbook?

A) 1

B) 2

C) 3

D) No default

Question 77 : What is the minimum zoom percentage allowed in MS Excel?

A) 10%

B) 25%

C) 50%

D) 5%

Question 78 : What is the default zoom percentage in MS Excel?

A) 50%

B) 75%

C) 100%

D) 125%

Question 79 : Which Excel format specifically stores data as a string of texts?

A) Number

B) Currency

C) Text Formats

D) Labels

Question 80 : What happens when you select a cell in MS Excel and type "=B25"?

A) It formats the cell as B25

B) It shows the value contained in cell B25

C) It moves the cursor to B25

D) It generates an error

📚 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