MS Excel Questions Answers MCQ Download PDF

Download MS Excel Questions Answers MCQ MS Excel Questions Answers MCQ Practice Set PDF

Microsoft Excel is a powerful and versatile spreadsheet software that has become an essential tool in various fields, from business and finance to education and research. Proficiency in Excel is a valuable skill that can greatly enhance productivity and decision-making. One effective way to test and improve your Excel knowledge is through Multiple Choice Questions (MCQ). In this article, we will delve into a range of Excel-related MCQs and provide detailed answers to help you understand and master this indispensable software.

1)On an excel sheet the active cell in indicated by ?

A) A dotted border

B) A dark wide border

C)A blinking border

D) By italic text

View Answer
Option – B.

2)The default style for new data keyed in a new workbook is ?

A) Comma

B) Normal

C) Currency

D) Percent

View Answer
Option – B.

3)A value used in a formula that does not change is called a ?

A) Constant

B) Cell address

C) Varaible

D) Static

View Answer
Option – A.

4)what term describes a background that appears as a grainy, non smooth surface ?

A) Pattern

B) Gradient

C) Texture

D) Velvet

View Answer
Option – B.

5)You can convert existing Excel worksheet data and charts to HTML document by using the ?

A) Internet Assistant Wizard

B) Intranet Wizard

C) Import Wizard

D) Export Wizard

View Answer
Option – A.

6)Macros can be executed from the which of the following menu ?

A) Format

B) Home

C) Insert

D) Tools

View Answer
Option – D.

7)You can check the conditions against ____ when applying conditional formatting ?

A) Cell Value

B) Formula

C) Both of above

D) None of above

View Answer
Option – C.

8)How is data organized in a spreadsheet ?

A) Rows and columns

B) Layers and planes

C) Lines and spaces

D) Height and width

View Answer
Option – A.

9) How do you change column width to fit the contents ?

A) Single-click the boundary to the left to the column heading

B) Double click the boundary to the right of the column heading

C) Press Alt and single click anywhere in the column

D) All of above

View Answer
Option – B.

10)Which function is used for creating a data table ?

A) Sum

B) Table

C) Add

D) Count

View Answer
Option – B.