adplus-dvertising

Welcome to the MS Excel MCQs Page

Dive deep into the fascinating world of MS Excel with our comprehensive set of Multiple-Choice Questions (MCQs). This page is dedicated to exploring the fundamental concepts and intricacies of MS Excel, a crucial aspect of MS Office. In this section, you will encounter a diverse range of MCQs that cover various aspects of MS Excel, from the basic principles to advanced topics. Each question is thoughtfully crafted to challenge your knowledge and deepen your understanding of this critical subcategory within MS Office.

frame-decoration

Check out the MCQs below to embark on an enriching journey through MS Excel. Test your knowledge, expand your horizons, and solidify your grasp on this vital area of MS Office.

Note: Each MCQ comes with multiple answer choices. Select the most appropriate option and test your understanding of MS Excel. You can click on an option to test your knowledge before viewing the solution for a MCQ. Happy learning!

MS Excel MCQs | Page 30 of 47

Explore more Topics under MS Office

Q291.
You can use drag-and-drop to embed excel worksheet data in a word document

a.

By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key

b.

By dragging a range of excel data to the word button on the taskbar while pressing Shift key

c.

By dragging a range of excel data to the word button on the taskbar while pressing Alt key

d.

None of above

Discuss
Answer: (a).By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
Q292.
The auto calculate feature

a.

Can only add values in a range of cells

b.

Provides a quick way to view the result of an arithmetic operation on a range of cells

c.

Automatically creates formulas and adds them to a worksheet

d.

both a and c

Discuss
Answer: (b).Provides a quick way to view the result of an arithmetic operation on a range of cells
Q293.
Excel uniquely identifies cells within a worksheet with a cell name

a.

Cell names

b.

Column numbers and row letters

c.

Column letters and row numbers

d.

Cell locator coordinates

Discuss
Answer: (c).Column letters and row numbers
Q294.
MS-EXCEL can be used to automate

a.

Financial statements, Business forecasting

b.

Transaction registers, inventory control

c.

Accounts receivable, accounts payable

d.

Any of the above

Discuss
Answer: (d).Any of the above
Q295.
NOT, AND, OR and XOR are

a.

Logical Operators

b.

Arithmetic operators

c.

Relational operators

d.

None of the above

Discuss
Answer: (a).Logical Operators
Q296.
In a report, you need to show the monthly rainfall in Nepal. The best way to do this is to insert a

a.

calendar

b.

photograph of rainfall

c.

chart showing rainfall amounts

d.

database of rainfall

Discuss
Answer: (c).chart showing rainfall amounts
Q297.
You want to record experiment information and create a chart that shows the rate of crystal growth over a period of time. The best application to use would be:

a.

word processing

b.

spreadsheet

c.

database

d.

graphics

Discuss
Answer: (b).spreadsheet
Q298.
You are editing an worksheet that you had previously saved. If you want to save the edited sheet without losing the original one, which command should you use?

a.

New

b.

Save As

c.

Edit

d.

Save

Discuss
Answer: (b).Save As
Q299.
If you want to have a blank line after the title in a worksheet, what is the best thing for you to do?

a.

Re-format the spreadsheet

b.

Insert a row

c.

Increase the column width

d.

Use the spacebar

Discuss
Answer: (b).Insert a row
Q300.
In order to arrange the countries from those with the highest population to those with the lowest, you need to sort on the population field in ……………

a.

ascending order

b.

descending order

c.

alphabetical order

d.

random order

Discuss
Answer: (b).descending order
Page 30 of 47

Suggested Topics

Are you eager to expand your knowledge beyond MS Office? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

DBMS

Get a firm grasp on database systems with our DBMS MCQs. Explore relational...

MySQL Database

Enhance your knowledge of relational databases with our MySQL MCQs. Understand...

Cyber Security

Understand the fundamentals of safeguarding digital assets with our Cyber Security...

Digital Logic Design

Understand the foundation of digital computers with our Digital Logic Design MCQs....

Cryptography and Network Security

Secure your knowledge of information security with our Cryptography and Network...

C Programming

Master one of the most widely used programming languages with our C Programming MCQs....

Internet of Things (IoT)

Discover how devices communicate with each other in the smart world with our IoT...

Data Warehousing and OLAP

Strengthen your knowledge of Data Warehousing and OLAP with our specialized MCQs....

Human Computer Interaction

Enhance your knowledge of Human-Computer Interaction with our specialized MCQs....