MS Excel Notes PDF Free Download
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.
Topic Related Posts
- Basic Computer Knowledge Book PDF In Hindi
- Computer Question And Answers In Hindi PDF
- Computer Book PDF In Hindi For All Competitive Exams
- Important Computer Question in Hindi PDF
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
Q.2 A Spreadsheet contains?
(A) columns
(B) rows
(C) rows and columns
(D None of these
Q.3 Top open an existing workbook, click the open button on the…………toolbar?
(A) form
(B) standard
(C) Drawing
(D) Formatting
Q.4 Which among following is not associated with spelling dialogue box?
(A) Edit
(B) Ignore All
(C) Ignore
(D) Change
Q.5 What term describes a background that appears as a grainy, non-smooth surface?
(A) Pattern
(B) Gradient
(C) Velvet
(D) Texture
Q.6 Which among following is associated with excel?
(A) Graphic program
(B) Spreadsheet
(C) Microsoft office
(D) None of these
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
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
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?
(A) Hyperlinks
(B) Rows
(C) Index
(D) Transpose
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
Q.12 Macros can be executed from the which of the following menu?
(A) Format
(B) Tools
(C) Insert
(D) Home
Q.13 Protection and the Protect Sheet options can be selected from?
(A) Data
(B) Tools
(C) Edit
(D) Format
Q.14 Which of the following is not a valid Zoom percentage in Excel?
(A) 400
(B) 300
(C) 100
(D) 10
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
Q.16 How can we set page Border in Excel?
(A) From Edit menu
(B) From Home
(C) You can not set page border in Excel
(D) From Tools menu
Q.17 Which function calculates your monthly mortgage payment?
(A) PV
(B) NPER
(C) PMT
(D) All of above
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
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
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
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) \
Q.32 Which function in excel counts the numbers of characters in a cell?
(A) LENGTH
(B) LGT
(C) LEN
(D) LT
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 + $
Q.35 Shortcut to edit the selected cell?
(A) F3
(B) F8
(C) F4
(D) F2
Q.36 Which shortcut can be used to Switch between open workbooks?
(A) Ctrl + F2
(B) Ctrl + F6
(C) Ctrl + F8
(D) Ctrl + F10
Q.37 Shortcut to enter current date?
(A) Insert + –
(B) Shift + –
(C) Alt + –
(D) Ctrl + –
Q.38 Shortcut to enter current date?
(A) Ctrl +;
(B) Shift +;
(C) Home +;
(D) Alt +;
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
Q.40 Stylesheet formats can be applied from?
(A) Table>>Autoformat
(B) Format>>Autoformat
(C) Table>>Cells
(D) Fromat>>Cells
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
Q.12 Macros can be executed from which of the following menu?
(A) Format
(B) Tools
(C) Insert
(D) Home
Q.13 Protection and the Protect Sheet options can be selected from?
(A) Data
(B) Tools
(C) Edit
(D) Format
Q.14 Which of the following is not a valid Zoom percentage in Excel?
(A) 400
(B) 300
(C) 100
(D) 10
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
Q.16 How can we set page Border in Excel?
(A) From Edit menu
(B) From Home
(C) You can not set page border in Excel
(D) From Tools menu
Q.17 Which function calculates your monthly mortgage payment?
(A) PV
(B) NPER
(C) PMT
(D) All of above
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
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
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
DOWNLOAD MORE PDF |
|
| Maths Notes | CLICK HERE |
| English Notes | CLICK HERE |
| Reasoning Notes | CLICK HERE |
| Indian Polity Notes | CLICK HERE |
| General Knowledge | CLICK HERE |
| General Science Notes |
CLICK HERE |
mynotesadda.com will update many more new pdf and study materials and exam updates, keep Visiting and sharing our post, So more people will get this. This PDF is not related to mynotesadda.com and if you have any objection over this pdf, you can mail us at info@mynotesadda.com
Here you can also check and follow our Facebook Page (mynotesadda ) and our Facebook Group. Please share, comment, and like Our post on Facebook! Thanks to Visit our Website and keep Follow our Site to know our New Updates which is Useful for Your future Competitive Exams.
Please Support By Joining Below Groups And Like Our Pages We Will be very thankful to you.
- MyNotesAdda.com will update manymynotesadda
- Facebook Group :- https://www.facebook.com/mynotesadda
Tags:-ms excel 2007 full notes pdf free download,ms excel notes pdf free download in hindi,ms excel 2010 full notes pdf free download,microsoft excel notes for beginners pdf,advanced excel notes pdf,ms excel 2007 full notes pdf free download in hindi,ms excel pdf,excel formulas pdf with example 2016 download free
Comments are closed.