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.

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

Explore more Topics under MS Office

01

MS Word

02

MS Powerpoint

03

MS Access

04

Shortcut Keys

Q231.

Which of the following is the oldest spreadsheet package?

VisiCalc

Lotus 1-2-3

Excel

StarCalc

Discuss

Answer: (a).VisiCalc

Q232.

Rounding errors can occur

When you use multiplication, division, or exponentiation in a formula

When you use addition and subtraction in a formula

Because excel uses hidden decimal places in computation

When you show the results of formulas with different decimal places that the calculated results

Discuss

Answer: (a).When you use multiplication, division, or exponentiation in a formula

Q233.

You can copy data or formulas

With the copy, paste and cut commands on the edit menu

With commands on the shortcut menu

With buttons on the standard toolbars

All of the above

Discuss

Answer: (d).All of the above

Q234.

You cannot link excel worksheet data to a word document

With the right drag method

With a hyperlink

With the copy and paste special commands

With the copy and paste buttons on the standard toolbar

Discuss

Answer: (d).With the copy and paste buttons on the standard toolbar

Q235.

Which of the following is a popular DOS based spreadsheet package?

Word

Smart cell

Excel

Lotus 1-2-3

Discuss

Answer: (d).Lotus 1-2-3

Q236.

An excel workbook is a collection of

Workbooks

Worksheets

Charts

Worksheets and charts

Discuss

Answer: (d).Worksheets and charts

Q237.

Excel files have a default extension of

Xls

Xlw

Wk1

123

Discuss

Answer: (a).Xls

Q238.

You can use the format painter multiple times before you turn it off by

You can use the format painter button on ly one time when you click it

Double clicking the format painter button

Pressing the Ctrl key and clicking the format painter button

Pressing the Alt key and clicking the format painter button

Discuss

Answer: (b).Double clicking the format painter button

Q239.

You can use the formula palette to

Format cells containing numbers

Create and edit formulas containing functions

Enter assumptions data

Copy a range of cells

Discuss

Answer: (b).Create and edit formulas containing functions

Q240.

You can convert existing excel worksheet data an charts to an HTML document by using

FTP wizard

Internet assistant wizard

Intranet wizard

Import wizard

Discuss

Answer: (b).Internet assistant wizard

Page 24 of 47

Welcome to the MS Excel MCQs Page

MS Excel MCQs | Page 24 of 47

Explore more Topics under MS Office

MS Word

MS Powerpoint

MS Access

Shortcut Keys

Suggested Topics

Digital Logic Design

CSS

Systems Analysis and Design Methods

Data Structures and Algorithms

Computer Architecture

DBMS

Systems Programming

Java Spring Framework

Neural Networks