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

Explore more Topics under MS Office

Q201.
Which of the following is not a way to complete a cell entry?

a.

Pressing enter

b.

Pressing any arrow key on the keyboard

c.

Clicking the Enter button on the Formula bar

d.

Pressing spacebar

Discuss
Answer: (d).Pressing spacebar
Q202.
You can activate a cell by

a.

Pressing the Tab key

b.

Clicking the cell

c.

Pressing an arrow key

d.

All of the above

Discuss
Answer: (d).All of the above
Q203.
Text formulas:

a.

Replace cell references

b.

Return ASCII values of characters

c.

Concatenate and manipulate text

d.

Show formula error value

Discuss
Answer: (c).Concatenate and manipulate text
Q204.
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
Q205.
Which of the following is not a basic step in creating a worksheet?

a.

Save workbook

b.

Modifiy the worksheet

c.

Enter text and data

d.

Copy the worksheet

Discuss
Answer: (d).Copy the worksheet
Q206.
How do you select an entire column?

a.

Select Edit > Select > Column from the menu

b.

Click the column heading letter

c.

Hold down the shift key as you click anywhere in the column

d.

Hold down the Ctrl key as you click anywhere in the column

Discuss
Answer: (b).Click the column heading letter
Q207.
How can you print three copies of a workbook?

a.

Select File > Properties form 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.

Press Ctrl+P+3

Discuss
Answer: (b).Select File > Print from the menu and type 3 in the Number of copies text box
Q208.
To create a formula, you first:

a.

Select the cell you want to place the formula into

b.

Type the equals sign (=) to tell 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: (b).Type the equals sign (=) to tell Excel that you’re about to enter a formula
Q209.
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

b.

Widen the columns

c.

Select the cells containing the title text plus the range over which the title text is to be enfettered

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
Q210.
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
Page 21 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!

Systems Programming

Decode low-level programming with our Systems Programming MCQs. These questions delve...

C Programming

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

C# programming

Hone your skills in the C# language with our MCQs. Understand data types, operators,...

MATLAB

Hone your computational mathematics skills with our MATLAB MCQs. Understand...

Management Information Systems

Discover how businesses leverage technology with our Management Information Systems...

R Programming

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

SQL Server

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

CSS

Polish your web design skills with our CSS MCQs. Learn about selectors, properties,...

Cyber Security

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