MS Excel MCQ Quiz & Study Notes

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

Question 51 : What will be the value returned by =WORKDAY("1-Jan-2021", 2) assuming 1-Jan-2021 is a Friday?

A) 3-Jan-2021

B) 4-Jan-2021

C) 5-Jan-2021

D) 2-Jan-2021

Question 52 : To convert existing excel worksheet data and charts to an HTML document, you use the:

A) Web Exporter

B) HTML Converter

C) Internet Assistant Wizard

D) Web Wizard

Question 53 : Which command is used to split the window into two?

A) View > Divide

B) Window > Split

C) Insert > Break

D) Layout > Split

Question 54 : Files created with the Lotus-1-2-3 spreadsheet package have what extension?

A) .xls

B) .123

C) .lot

D) .lts

Question 55 : When integrating Word and Excel, Word is usually considered the:

A) Server

B) Client

C) Host

D) Source

Question 56 : What is the shortcut to show or hide the Ribbon?

A) Ctrl + R

B) Ctrl + F1

C) Shift + F1

D) Alt + R

Question 57 : Which shortcut key hides the selected rows?

A) Ctrl + 9

B) Ctrl + 0

C) Alt + 9

D) Shift + 9

Question 58 : What is the correct option for a cell address?

A) 25A

B) A25

C) #A25

D) 25#A

Question 59 : The address of the active cell is displayed in the:

A) Formula Bar

B) Status Bar

C) Name Box

D) Title Bar

Question 60 : What is the value of =BASE(12, 2, 8)?

A) 1100

B) 00001100

C) 0110

D) 00000110

📚 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