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 16 of 47

Explore more Topics under MS Office

Q151.
In MS-Excel to save a workbook, you

a.

Click the save button on the standard toolbar from the menu

b.

Press Ctrl+F5

c.

Click Save on the Windows Start button

d.

Select Edit>Save

Discuss
Answer: (a).Click the save button on the standard toolbar from the menu
Q152.
In MS-Excel you can edit a cell by

a.

Clicking the formula button

b.

Double clicking the cell to edit it in-place

c.

Selecting Edit>Edit Cell from the menu

d.

Both (b) and (c)

Discuss
Answer: (b).Double clicking the cell to edit it in-place
Q153.
In MS-Excel which is not an advantage of using computerized spreadsheets?

a.

Flexibility of moving entries

b.

Speed of calculation

c.

Ability of generate tables

d.

Cost of initial setup

Discuss
Answer: (d).Cost of initial setup
Q154.
In MS-Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the

a.

Unfreeze panes command on the window menu

b.

Freeze panes command on the window menu

c.

Hold titles command on the edit menu

d.

None of these

Discuss
Answer: (b).Freeze panes command on the window menu
Q155.
In MS-Excel to center worksheet titles across a range of cells, you must

a.

Select the cells containing the title text plus the range over which the title text is to be centered and click on ' merge and center ' option from formatting bar

b.

Widen the columns

c.

Both (a) and (b)

d.

Format the cells with the comma style

Discuss
Answer: (a).Select the cells containing the title text plus the range over which the title text is to be centered and click on ' merge and center ' option from formatting bar
Q156.
In MS-Excel Text formulas

a.

Replace cell references

b.

Return ASCII values of characters

c.

Concatenate and manipulate text

d.

None of these

Discuss
Answer: (c).Concatenate and manipulate text
Q157.
In MS-Excel how do you delete a column?

a.

Select the column heading you want to delete and select the Delete Row button on the standard toolbar

b.

Select the column heading you want to delete and select Insert Delete from the menu

c.

Select the row heading you want to delete and select Edit>Delete from the menu

d.

Right click the column heading you want to delete and select delete from the shortcut menu

Discuss
Answer: (d).Right click the column heading you want to delete and select delete from the shortcut menu
Q158.
In MS-Excel how do you insert a row?

a.

Right-click the row heading where you want to insert the new row and select insert from the shortcut menu

b.

Select the row heading where you want to insert the new row and select Edit >Row from the menu

c.

Select the row heading where you want to insert the new row and click the insert Row button on the standard toolbar

d.

All of the above

Discuss
Answer: (a).Right-click the row heading where you want to insert the new row and select insert from the shortcut menu
Q159.
In MS-Excel how can you print three copies of a workbook?

a.

Select File>Properties from the menu and type 3 in the Copies to print text box.

b.

Select File >Print from the menu and type 3 in the Number of copies text box

c.

Click the Print button on the standard toolbar to print the document then take it to Kinko's and have 2 more copies made

d.

None of these

Discuss
Answer: (b).Select File >Print from the menu and type 3 in the Number of copies text box
Q160.
In MS-Excel to create a formula, you first

a.

Select the cell you want to place the formula into

b.

Type the equals sign (=) to tell MS-Excel that you're about to enter a formula

c.

Enter the formula using any input values and the appropriate mathematical operators that make up your formula

d.

Choose the new command from the file menu

Discuss
Answer: (a).Select the cell you want to place the formula into
Page 16 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!

R Programming

Unleash the power of statistical computing with our R Programming MCQs. Topics cover...

IT Fundamentals

Navigate the basics of information technology with our IT Fundamentals MCQs. Get a...

Java Programming

Level up your coding skills with our Java Programming MCQs. From object-oriented...

SQL Server

Master Microsoft's database server with our SQL Server MCQs. Topics cover database...

Digital Communication

Master the basics of electronic communication with our Digital Communication MCQs....

C Programming

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

Digital Image Processing (DIP)

Delve into the techniques of enhancing digital images with our Digital Image...

Formal Languages and Automata Theory

Discover the mathematical models of computation with our Formal Languages and...

CompTIA PenTest+ Certification Exam PT0 002

Prepare for the CompTIA PenTest+ PT0-002 exam with our targeted MCQs. Covering...