MS Excel MCQ Quiz & Study Notes

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

Question 41 : What is the output of =FLOOR(14, 4)?

A) 16

B) 14

C) 12

D) 10

Question 42 : What is the output of =MEDIAN(1, 2, 3, 4, 5, 6)?

A) 3

B) 4

C) 3.5

D) 7

Question 43 : How many cells are in the range A1:D7?

A) 11

B) 28

C) 24

D) 32

Question 44 : What does the formula =SUMSQ(1, 2, 3, 4) calculate?

A) Sum of the numbers

B) Square root of the sum

C) Sum of the squares (1+4+9+16)

D) Median of the squares

Question 45 : Which of the following is NOT a valid Excel function?

A) COUNT

B) COUNTA

C) COUNTBLANK

D) COUNTNUMBERS

Question 46 : Which tool is considered "Best" for What-If analysis according to your notes?

A) Scenarios

B) Goal Seek

C) Data Table

D) Solver

Question 47 : A Doughnut chart in MS Excel is similar to which other chart?

A) Line chart

B) Pie chart

C) Bar chart

D) Scatter plot

Question 48 : Which chart type is NOT supported by MS Excel according to your notes?

A) Scatter Plot

B) Area chart

C) Volume chart

D) Line chart

Question 49 : Rotating data from rows to columns and vice versa is called?

A) Reversing

B) Switching

C) Transposing

D) Inverting

Question 50 : The WORKDAY function skips which days by default if no holidays are provided?

A) Sundays only

B) Saturdays and Sundays

C) Mondays and Fridays

D) None

📚 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