Hello Students,

MS Excel is a widely used software tool for data analysis, calculation, and visualization. It is commonly used in businesses, organizations, and academic institutions to manage data and analyze it to gain insights. As a result, proficiency in MS Excel is a valuable skill that is in high demand in many industries.

In an exam setting, having a good understanding of MS Excel can be beneficial. Notes in the form of a PDF document can be an effective way to prepare for an exam as they can provide concise and organized information about the features and functions of MS Excel. Some of the benefits of using MS Excel notes PDF in an exam include:

Comprehensive coverage: MS Excel notes PDF can cover a wide range of topics related to the software, from basic functions such as entering data, formatting cells, and creating charts, to more advanced topics such as using functions, pivot tables, and macros.

Time-saving: Notes in the form of a PDF document can save time as they provide a quick reference guide to important concepts and features. This can be particularly helpful in an exam setting where time is limited, and students need to recall information quickly.

Clarity: Notes in the form of a PDF document can be well-organized and provide clear explanations of complex concepts. This can help students better understand the material and retain the information for the exam.

Portable: MS Excel notes PDF can be easily downloaded and stored on a computer or mobile device. This makes it convenient for students to access their notes and study anytime, anywhere.

In summary, MS Excel notes in the form of a PDF document can be an effective tool for exam preparation. They can provide comprehensive coverage of the software’s features and functions, save time, provide clarity, and are portable. By using MS Excel notes PDF, students can increase their proficiency in the software, which can be an asset in their academic and professional careers.

### MS Excel Question and Answer

Q.1  Formula palette is used to?

(A) format cells containing number

(B) created and edit formulas containing functions

(C) entered assumption data

(D) Copy all cells

Ans .   B

(A) columns

(B) rows

(C) rows and columns

(D None of these

Ans .   C

Q.3  Top open an existing workbook, click the open button on the…………toolbar?

(A) form

(B) standard

(C) Drawing

(D) Formatting

Ans .   B

Q.4  Which among following is not associated with spelling dialogue box?

(A) Edit

(B) Ignore All

(C) Ignore

(D) Change

Ans .   A

Q.5  What term describes a background that appears as a grainy, non-smooth surface?

(A) Pattern

(C) Velvet

(D) Texture

Ans .   B

Q.6  Which among following is associated with excel?

(A) Graphic program

(C) Microsoft office

(D) None of these

Ans .   B

Q.7  The cell reference for a range of cells that starts in cell C1 and goes over to column H and down to row 10 is?

(A) C1:10H

(B) C1:H10

(C) C1:H-10

(D) C1:H:10

Ans .   B

Q.8  You can convert existing Excel worksheet data and charts to HTML document by using the?

(A) Intranet Wizard

(B) Internet Assistant Wizard

(C) Important Wizard

(D) Export Wizard

Ans .   B

Q.9  To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called?

(A) Pivot Table Report

(B) Pivot Table List

(C) Pivot Table Field List

(D) HTML

Ans .   A

Q.10  What function displays row data in a column or column data in a row?

(B) Rows

(C) Index

(D) Transpose

Ans .   D

Q.11  Except which of the following function, a formula with a logical function shows the word “TRUE’’ or “FALSE” as a result?

(A) NOT

(B) OR

(C) IF

(D) AND

Ans .   C

Q.12  Macros can be executed from the which of the following menu?

(A) Format

(B) Tools

(C) Insert

(D) Home

Ans .   B

Q.13  Protection and the Protect Sheet options can be selected from?

(A) Data

(B) Tools

(C) Edit

(D) Format

Ans .   B

Q.14  Which of the following is not a valid Zoom percentage in Excel?

(A) 400

(B) 300

(C) 100

(D) 10

Ans .  A

Q.15  You can check the condition against……….when applying conditional formatting?

(A) Cell value

(B) Formula

(C) Both of above

(D) None of above

Ans .   C

Q.16  How can we set page Border in Excel?

(B) From Home

(C) You can not set page border in Excel

Ans .   C

Q.17  Which function calculates your monthly mortgage payment?

(A) PV

(B) NPER

(C) PMT

(D) All of above

Ans .   C

Q.18  Which type of charts can excel produce?

(A) Bar charts, line graphs and pie charts

(B) Line graphs and pie charts only

(C) Bar charts and line graphs only

(D) Only line graphs

Ans .   A

Q.19  How is data organized in a spreadsheet?

(A) Rows and columns

(B) Layers and planes

(C) Lines and spaces

(D) Height and width

Ans .   A

Q.20  VLOOKUP function used to?

(A) Finds related records

(B) Looks up text that contain “V”

(C) Check if two cells are identical

(D) None of these

Ans .   A

#### MS Excel Questions and Answers for Competitive Exams

Q.31  Which among the following is the divide symbol in excel?

(A) /

(B) D

(C) Div

(D) \

Ans .   A

Q.32  Which function in excel counts the numbers of characters in a cell?

(A) LENGTH

(B) LGT

(C) LEN

(D) LT

Ans .   D

Q.33  Which function converts miles to kilometres?

(A) Change

(B) Convert

(C) Shift

(D) Conv

Ans .   B

Q.34  What is shortcut to enter current date in cell in excel?

(A) Ctrl +;

(B) Alt +;

(C) Shift + &

(D) Ctrl + \$

Ans .   A

Q.35  Shortcut to edit the selected cell?

(A) F3

(B) F8

(C) F4

(D) F2

Ans .   D

Q.36  Which shortcut can be used to Switch between open workbooks?

(A) Ctrl + F2

(B) Ctrl + F6

(C) Ctrl + F8

(D) Ctrl + F10

Ans .   B

Q.37  Shortcut to enter current date?

(A) Insert + –

(B) Shift + –

(C) Alt + –

(D) Ctrl + –

Ans .   D

Q.38  Shortcut to enter current date?

(A) Ctrl +;

(B) Shift +;

(C) Home +;

(D) Alt +;

Ans .   A

Q.39  When the formula bar is activated, you can see

(A) The Edit Formula button

(B) The cancel button

(C) The Enter button

(D) All of the above

Ans .   D

Q.40  Stylesheet formats can be applied from?

(A) Table>>Autoformat

(B) Format>>Autoformat

(C) Table>>Cells

(D) Fromat>>Cells

Ans .  B

Q.11  Except which of the following function, a formula with a logical function shows the word “TRUE’’ or “FALSE” as a result?

(A) NOT

(B) OR

(C) IF

(D) AND

Ans .   C

Q.12  Macros can be executed from which of the following menu?

(A) Format

(B) Tools

(C) Insert

(D) Home

Ans .   B

Q.13  Protection and the Protect Sheet options can be selected from?

(A) Data

(B) Tools

(C) Edit

(D) Format

Ans .   B

Q.14  Which of the following is not a valid Zoom percentage in Excel?

(A) 400

(B) 300

(C) 100

(D) 10

Ans .  A

Q.15  You can check the condition against……….when applying conditional formatting.

(A) Cell value

(B) Formula

(C) Both of above

(D) None of above

Ans .   C

Q.16  How can we set page Border in Excel?

(B) From Home

(C) You can not set page border in Excel

Ans .   C

Q.17  Which function calculates your monthly mortgage payment?

(A) PV

(B) NPER

(C) PMT

(D) All of above

Ans .   C

Q.18  Which type of charts can excel produce?

(A) Bar charts, line graphs and pie charts

(B) Line graphs and pie charts only

(C) Bar charts and line graphs only

(D) Only line graphs

Ans .   A

Q.19  How is data organized in a spreadsheet?

(A) Rows and columns

(B) Layers and planes

(C) Lines and spaces

(D) Height and width

Ans .   A

Q.20  VLOOKUP function used to?

(A) Finds related records

(B) Looks up text that contain “V”

(C) Check if two cells are identical

(D) None of these

Ans .   A

General Science Notes