CBSE Notes For Class 9
CBSE Class 9 Notes helps students face the competition in the current education system. For Class 10 and 12 board exams, students must be well prepared and score satisfactory marks in the main exam. It is observed that almost 90 percent of the Class 9th syllabus is repeated in Class 10th. So, students should clear the basics in Class 9 to understand the concepts easily in Class 10. In this case, the CBSE Notes is the best study tool to get a clear idea about the basics and gain a strong knowledge of the chapters.
We at BYJU’S are providing notes for CBSE Class 9 students, mainly for subjects like Science and Maths. Scoring well in these major subjects will increase the possibility of getting into good colleges in the long run. The notes that we are offering have been thoughtfully prepared by our experts to help you achieve the same. These notes are designed to help students overcome all the challenges in solving math problems and understand difficult science concepts. Basically, these notes act as a valuable reference tool for conducting effective revisions of the entire chapters given in each subject. Additionally, students can use these notes to get detailed explanations, practice problems, and study properly without wasting much precious time.
Students can access notes for Class 9 from the links given below:
Keep visiting BYJU’s for more CBSE study solutions like books, exemplars, sample papers and more.
Frequently Asked Questions on CBSE Class 9 Notes
Why is the class 9 cbse notes important for the students, what are the subjects covered in the cbse class 9 notes at byju’s, does the cbse class 9 notes help in scoring full marks, leave a comment cancel reply.
Your Mobile number and Email id will not be published. Required fields are marked *
Request OTP on Voice Call
Post My Comment
- Share Share
Register with BYJU'S & Download Free PDFs
Register with byju's & watch live videos.
Digital Presentation Class 9 Questions and Answers
Teachers and Examiners ( CBSESkillEduction ) collaborated to create the Digital Presentation Class 9 Questions and Answers . All the important Questions and Answers are taken from the NCERT Textbook Information Technology ( 402 ).
1. List the possible multimedia contents that are included while creating a presentation.
Answer – The following is a list of possible multimedia content to include while building a presentation:
A multimedia presentation is a stand-alone presentation that contains information provided through slides, video, or digital representations, as well as sound, such as narration, music, or sound effects.
2. List the important points to be considered while making an effective presentation.
Answer – The important points to making an effective presentation –
a. Create a consistent and simple design template with the slide master function.
b. Reduce the quantity of words on each screen by simplifying and limiting them.
c, Use different colors for the text and the background. It’s ideal to use light writing on a dark background.
d. Use high-quality photos to support and reinforce your message.
e. The number of slides should be kept to a minimum.
3. What are the advantages of using a presentation?
Answer – It’s easy to engage your audience with a presentation. Clear bullet points or summary language can help an audience follow the logic of a presentation, while beautiful graphics can hold an audience’s attention.
4. What objects can be inserted to slides in Impress?
Answer – Impress allows you to embed a variety of objects into a slide, including music or video clips, Writer documents, Math formulas, generic OLE objects, and so on. The primary window of Impress is divided into three sections: the Slides pane, Workspace, and Sidebar.
The Title Bar, Menu, Toolbars, and Status Bar are all part of the Impress window. These sections are comparable to the main Writer window. Normal, Outline, Notes, Handout, and Slide Sorter are the five tabs in Impress.
5. What are the steps to add picture or object to the slide?
Answer – Images that can be utilized in a presentation can be found in the Gallery. To use an image from the gallery, follow these steps: Step 1 – Click on Insert Tab Step 2 – Click on Media Step 3 – Click on Gallery Step 4 – Find the suitable image
6. How can text be added to header or footer on the sliders?
Answer – Step 1: Click on Page Drop. Step 2: Tap the Header or Footer button. Step 3: From the popup menu, select Edit Header or Edit Footer. Step 4: On the Ribbon, the tab Interface Header & Footer Software appears. Step 5: Insert the insertion point where you want a header or text footer to appear. step 6: press the (Enter) key.
7. Describe the use of fields available in header and footer.
Answer – In a word document, the header is the top margin and the footer is the bottom margin.
a. The headers and footers are used to provide additional information about the document for convenience of processing.
b. The page number, as well as the document’s name or title, we can be used as headers.
c. The author’s name, date and time of creation, and other information may be included in the footer.
d. These two fields, on the other hand, allow the usage of graphics such as the corporate logo.
e. Headers and footers work together to provide a multi-page document a consistent look.
8. Write the steps to create a template.
Answer – To create a new template in Impress are – Step 1 – Click on File menu Step 2 – Click on New or press Ctrl + N Step 3 – Click on Template Step 4 – Choose a template as per your choice
9. Write down the steps to add slide transition in your presentation.
Answer – There are just too many ready-made transition effects available. You can also add transitions like transition speed, sound effects, and automated transitions. Steps to add slide transition in the presentation are – Step 1 – Select Slide Transition Step 2 – Select Slide Pane Step 3 – Select transition Step 4 – Apply the transition
10. How will you add the slide number at the bottom of each slide?
Answer – Select Slide Number from the Text group on the Insert tab. Select the Slide tab in the Header and Footer dialogue box. Select the Slide number check box and then click Apply to number the slide you’ve chosen.
11. How will you insert a company’s logo (picture) in first slide of your presentation?
Answer – You can use a watermark to include a company’s logo in the background:
Step 1 – Open the presentation to which you’d like to apply a watermark.
Step 2 – Select Slide Master from the VIEW menu.
Step 3 – Select a rectangular form from the Shapes drop-down menu on the INSERT tab.
Step 4 – Format the shape by right-clicking on it and selecting Format Shape.
Step 5 – Choose Photo or texture fill from the right panel and browse for a picture file.
Step 6 – Choose a photo from your computer to place on the slide.
Step 7 – When you exit Slide Master and return to the standard presentation view, the watermark will appear.
12. How will you add the name of the company on the top of the each slide?
Answer – Headers can be used to add the company name to the top of each slide.
To add a header to each slide, follow these steps:
Step 1: Select Header & Footer from the Insert menu. Step 2: Select the desired header format from the side menu. Step 3: Personalize the header by adding your company’s name. Step 4: Select a location on the slide with a double-click. Each slide will include a header with the company’s name.
13. Write down the steps to create a table in a presentation.
Answer – Create and format a table in PowerPoint. Step 1 – Choose the slide to which you’d want to add a table. Step 2 – Select Table from the Insert tab. Step 3 – Do one of the following in the Insert Table dialogue box: Select the desired number of rows and columns using the mouse…. Step 4 – To add text to a table cell, first click it and then type your content into it.
14. Write down the steps to insert a chart in slide.
Answer – To add a chart, follow these steps:
Step 1 – Select Insert tab from the menu Step 2 – In the Illustrations Group, select the Insert Chart command. A dialogue box for inserting a chart Step 3 – Choose a category from the left pane of the dialogue box, then look through the charts in the centre. Step 4 – Select the chart Step 5 – Click on OK button
15. What are the five views of presentation?
Answer – The following are five perspectives on the presentation:
1. Normal view – This view allows you to work on a single slide at a time, adding and designing innovative styles. This default mode allows you to simultaneously see and work on the presentation.
2. Slide sorter view – This view allows you to change the properties of the slides. The slide sorter view shows a scaled-down version of the slide and allows you to quickly delete or rearrange other slides.
3. Reading view – This feature makes it easier to see the presentation on a different computer. The reading perspective, rather than viewing the presentation in full screen, allows you to easily access the meeting controls while presenting the slides.
4. Slide Show view – This view is mostly used to show the presentation to the audience on a full screen. This view shows the transition effects and slide timings.
5. Presenter view – This view allows two devices to be linked to show the presentation, such as a projector and a laptop.
Important Link ( Digital Presentation Class 9 Questions and Answers )
a. Communication Skills Class 9 MCQ
Communication Skills Class 9 Questions and Answers
b. Self Management Skills Class 9 MCQ
Self Management Skills Class 9 Questions and Answers
c. Basic ICT Skills Class 9 MCQ
Basic ICT Skills Class 9 Questions and Answers
d. Entrepreneurship Skills Class 9 MCQ
Entrepreneurial Skills Class 9 Questions and Answers
e. Green Skills Class 9 MCQ
Green Skills Class 9 Questions and Answers
Subject Specific Skills (Information Technology 402)
a. Introduction to IT ITeS Industry Class 9 MCQ
Introduction to IT ITeS Industry Class 9 Questions and Answers
b. Data Entry and Keyboarding Skills Class 9 MCQ
Data Entry and Keyboarding Skills Class 9 Solutions
c. Digital Documentation Class 9 MCQ with Solution
Digital Documentation Class 9 Solutions
d. Electronic Spreadsheet Class 9 MCQ
Electronic Spreadsheet Class 9 Questions and Answers
e. Digital Presentation Class 9 MCQ with Answer
The above Digital Presentation Class 9 Questions and Answers was created using the NCERT Book and Study Material accessible on the CBSE ACADEMIC as a reference.
Your valuable Feedback
Hi Students, Thank you for taking the time to reading Digital Presentation Class 9 Questions and Answers . Please take a few moments and leave your thoughts in the comment box below.
Disclaimer – 100% of the questions are taken from the CBSE textbook Digital Presentation Class 9 Questions and Answers , and our team has tried to collect all the correct Question and Answer from the textbook . If you found any suggestion or any error please contact us [email protected].
Employability skills Class 9 Notes
- Unit 1 – Communication Skills Class 9 Notes
- Unit 2 – Self-Management Skills Class 9 Notes
- Unit 3 – Basic ICT Skills Class 9 Notes
- Unit 4 – Entrepreneurial Skills Class 9 Notes
- Unit 5 – Green Skills Class 9 Notes
Employability skills Class 9 MCQ
- Unit 1 – Communication Skills Class 9 MCQ
- Unit 2 – Self-Management Skills Class 9 MCQ
- Unit 3 – Basic ICT Skills Class 9 MCQ
- Unit 4 – Entrepreneurial Skillls Class 9 MCQ
- Unit 5 – Green Skills Class 9 MCQ
Employability skills Class 9 Questions and Answers
- Unit 1 – Communication Skills Class 9 Questionns and Answers
- Unit 2 – Self-Management Skills Class 9 Questions and Answers
- Unit 3 – Basic ICT Skills Class 9 Questions and Answers
- Unit 4 – Entrepreneurial Skills Class 9 Questions and Answers
- Unit 5 – Green Skills Class 9 Questions and Answers
Information Technology Class 9 Notes
- Unit 1 – Introduction to IT-ITeS Industry Class 9 Notes
- Unit 2 – Data Entry and Keyboarding Skills Class 9 Notes
- Unit 3 – Digital Documentation Class 9 Notes
- Unit 4 – Electronic Spreadsheet Class 9 Notes
- Unit 5 – Digital Presentation Class 9 Notes
Information Technology Class 9 MCQ
- Unit 1 – Introduction to IT-ITeS Industry Class 9 MCQ
- Unit 2 – Data Entry and Keyboarding Skills Class 9 MCQ
- Unit 3 – Digital Documentation Class 9 MCQ
- Unit 4 – Electronic Spreadsheet Class 9 MCQ
- Unit 5 – Digital Presentation Class 9 MCQ
Information Technology Class 9 Questions and Answers
- Unit 1 – Introduction to IT-ITeS Industry Class 9 Questions and Answers
- Unit 2 – Data Entry and Keyboarding Skills Class 9 Questions and Answers
- Unit 3 – Digital Documentation Class 9 Questions and Answers
- Unit 4 – Electronic Spreadsheet Class 9 Questions and Answers
- Unit 5 – Digital Presentation Class 9 Questions and Answers
Talk to our experts
Revision Notes for Class 9 CBSE 2023-24 - Free PDF Download
- Revision Notes
Free Download of CBSE Class 9 Revision Notes
Revision is an art which one has to conquer to hold on to different important topics for a long time. And, we at Vedantu emphasize on this fact. With a huge pile of CBSE Class 9 syllabus , it is quite difficult for the students to remember every important topic of different chapters until the scheduled date of the exam. This is where revisions take an important role.
To ease the students' stress, Vedantu came up with the CBSE Class 9 Notes for Mathematics and Science . These notes are prepared by subject experts at Vedantu as per the latest NCERT syllabus.
Vedantu is a platform that provides free NCERT Solutions and other study materials for students. Register Online for Class 9 Science and Class 9 Maths tuition on Vedantu.com to score more marks in your examination.
Detailed Overview of Revision Notes for Class 9
Cbse notes for class 9, cbse class 9 science revision notes.
Science is one of the most important subjects for CBSE Class 9 students. Class 9 Students will be able to score maximum marks in Science if they have detailed knowledge of every topic given in the Class 9 NCERT Science textbook.
Understanding the concepts thoroughly will help you to easily answer the questions that are shown up in the exam.
After the completion of the Science syllabus, you can refer to Class 9 CBSE Science Revision Notes provided by Vedantu to enhance your preparation.
Once you download Class 9 CBSE Science Revision Notes pdfs for different chapters, you can access it anytime and anywhere. Your Science revision process will become effortless and smarter with these Class 9 CBSE Science revision notes. Ensure to go through these revision notes twice or thrice before the actual exam.
With the Vedantu’s subject expert recommendation and considering the entire Class 9 Science syllabus, we have provided Class 9 CBSE Science Revision Notes Pdfs of different chapters. To download Class 9 CBSE Science Revision Notes Pdfs, you just have to click on the chapter name given below.
Chapter-Wise CBSE Class 9 Science Revision Notes
Class 9 cbse mathematics revision notes.
Mathematics is the most important subject in academics that requires a lot of practice, revision, and most important concentration. We at Vedantu aims to provide Class 9 CBSE Mathematics Revision Notes that will help you to remember the important points and formulae of different chapters. These revision notes include a summary of the chapters, important points to remember, a brief explanation of every topic, derivation of the formula for a better understanding of different chapters.
If you find any difficulty in solving Mathematics numerical questions, these revision notes will resolve all your doubts. Additionally, Class 9 CBSE Mathematics Revision Notes are prepared by our subject experts who have put their maximum efforts to make your learning process easier. Moreover, these revision notes will also boost your confidence for the final examination. To download Class 9 CBSE Mathematics Revision Notes Pdfs for different chapters, you just have to click on the chapter name given below.
Chapter-Wise CBSE Class 9 Mathematics Revision Notes PDFs
Cbse class 9 social science notes for revision, benefits of cbse notes of class 9 by vedantu.
Some of the benefits of CBSE Notes of Class 9 are discussed below:
The entire content of different chapters can be accessed without login or sign up.
Chapter-Wise Science and Mathematics notes for Class 9 are available for free download in PDF format.
You can speed up the revision process for the entire syllabus of Mathematics and Science .
These CBSE Notes for Class 9 will certainly help you to score well in the Class 9 examination .
It helps you to identify the important points to learn for the examination.
Concise points help you to remember new information at the last minute.
Your important concepts will become clear as you read these revision notes chapter wise.
CBSE recommends the NCERT textbook and most of the questions are raised from the NCERT textbook in CBSE Class 9 exams. Due to this, our subject experts have drafted CBSE Class 9 notes for Mathematics and Science as per the new curriculum issued by the CBSE for the session 2023-24.
Download Science and Mathematics CBSE Notes For Class 9 in pdf format. It will be beneficial for you during the small gaps that you get between the exams. You can easily make a quick overview of the all important points of different chapters. So, download it now for the best level of preparation.
CBSE Class 9 Study Materials
Faqs on revision notes for class 9 cbse 2023-24 - free pdf download.
1. Which are the different chapters included in Class 9 Science?
There are altogether fifteen chapters included in CBSE Class 9 Science. These are given below
Matter in Our Surroundings,
Is Matter Around Us Pure,
Atoms and Molecules,
Structure of Atom,
The Fundamental Unit of Life,
Diversity in Living Organisms,
Force and Laws of Motion,
Work and Energy,
Why do We Fall Ill,
Improvement in Food Resources.
2. Which website offers the best Class 9 CBSE Mathematics and Science revision notes?
Vedantu platform offers best Class 9 CBSE Mathematics and Science revision notes as the revision notes are provided by the best subject experts as per the guidelines issued by CBSE boards. It is proved to be the best resource in terms of collecting information as they are available in pdf format for free.
3. Can we download Class 9 CBSE Mathematics and Science revision notes for free?
Yes. It’s available at a click. Download the Class 9 CBSE Mathematics and Science revision notes for free from Vedantu’s website. Vedantu helps you learn at the speed that you grab the great understanding of the chapters through its online classes, and study materials. Vedantu aims at offering the most effective Class 9 Maths and Science revision notes for students, as this helps students to understand the subject in a better way.
4. What are the Subjects of Science in class 9?
For class 9 students, CBSE has divided the subject of Science into three branches, namely Physics, Chemistry and Biology. Being a base of 10th standard, there are a lot of ideas and concepts for students to learn. CBSE class 9 notes are exclusively designed to help students with their revisions as well as studies by offering them crisp and useful information in the form of these notes. The link to these notes is-Revision notes for class 9.
5. Is CBSE 9th board exam?
CBSE conducts Board Exams for class 10 and class 12 only; class 9 exams are not conducted by the Board, but the question paper for the exam follows the pattern set and sent from the Boards. So, they are related to Boards, but class 9 is not a Board exam like in class 10 and class 12. Class 9 exams should be seen as a practice for the main Board exam students face in class 10.
6. Is Class 9 easy?
Class 9 is the base to class 10 for CBSE students. It is an acknowledged fact that class 9 is a little more difficult than class 10 since it deals with a whole lot of basics that are absolutely new to class 8 pass-outs. That being said, class 9 is not difficult altogether because the concepts are basics after all and if studied properly, then students can ace all the exams easily. CBSE Notes from Vedantu are a good choice of study material.
7. Which are the challenging subjects in class 9?
All subjects are easy with the proper preparation and all subjects are equally hard for students who have not prepared well. This said, when compared with all subjects in class 9, most students find Maths and Social Studies difficult. Social Studies is often stated as difficult due to the vastness of the subject, while Maths mainly poses difficulty in the chapter of Geometry. These difficulties can be easily overcome with CBSE Notes from Vedantu, which can be accessed free of cost from the link-Revision notes for class 9 .
8. How are notes useful for learning subjects in class 9?
Notes are well-made materials that students can blindly rely on to score excellent grades in their class 9. These are specifically prepared by experts who are proficient in the field of study, and the concise and precise details incorporated into these materials cover all the chapters in all the subjects with equal importance. All students are clear on the idea of revision being the best partner for exam preparations, and these notes serve this exact purpose. The revision notes are available on the vedantu website as well as on the vedantu app.
HOME TUITIONS IN INDIA
More from SANTOSH KUMAR SINGH
Recommended content, learn from anywhere on any device.
Top Leader by G2
Top Performer by SourceForge
Top Leader by Softwaresuggest
Ranked Amongst Top 25 Companies by LinkedIn
Most Preferred Workplace
Chapter 8: Motion - PowerPoint Presentation, Class 9, CBSE
Faqs on chapter 8: motion - powerpoint presentation, class 9, cbse pdf download, top courses for class 9, previous year questions with solutions, important questions, shortcuts and tricks, chapter 8: motion - powerpoint presentation, extra questions, objective type questions, study material, sample paper, semester notes, past year papers, practice quizzes, viva questions, video lectures, mock tests for examination.
Chapter 8: Motion - PowerPoint Presentation, Class 9, CBSE Free PDF Download
Importance of chapter 8: motion - powerpoint presentation, class 9, cbse, chapter 8: motion - powerpoint presentation, class 9, cbse notes, chapter 8: motion - powerpoint presentation, class 9, cbse class 9 questions, study chapter 8: motion - powerpoint presentation, class 9, cbse on the app, welcome back, create you account for free.
Unattempted tests, change country.
Important Questions and Notes
Unit 4 Electronic Spreadsheet Class 9 Notes Important Points
Electronic spreadsheet class 9 notes.
SPREADSHEET : A spreadsheet is a grid which interactively manages and organizes data in rows and columns. It is also called as Electronic Spreadsheet. It can also store, manipulate and create graphical representations of data.
It is used for managing financial and accounting documents, creating data reports, generating invoices, and for doing a variety of calculations on data etc.
Advantages of Spreadsheet : There are various advantages of spreadsheet software.
- A spreadsheet software can create graphical representations of data.
- It can be used to calculate and analyze the data for decision making.
- It also provide built-in formulae and functions for common mathematical, financial, statistical operations.
- It is widely used for data analysis and accounting applications.
Examples of Spreadsheet software : Examples are
- Microsoft Excel
- LibreOffice Calc
- OpenOffice Calc
- Apple Inc. Numbers
LibreOffice Calc is used to perform the following activities accurately and efficiently.
- Tabulation of data.
- Simple mathematical calculations.
- Complex calculations using formula and functions.
- Arranging data in ascending and descending order.
- Filtering the required data.
- Check the validity of data.
- Protection of data using passwords.
- Saving for future use.
Starting LibreOffice Calc : LibreOffice Calc is the spreadsheet application of LibreOffice suite. In Linux (Ubuntu) operating system, the LibreOffice gets installed by default. In Windows, you need to download LibreOffice from its official website and install it on your computer.
Steps to open LibreOffice Calc in Window : In Windows, find the shortcut of LibreOffice on Start menu or on the desktop. Double click the shortcut to open LibreOffice. Or Click the window menu, select LibreOffice application, then click LibreOffice Calc.
Steps to open LibreOffice Calc in Linux : In Ubuntu Linux, find the Calc icon on application launcher or search it by clicking on “Show Applications”.
Parts of LibreOffice Calc :
Following figure shows the parts of LibreOffice Calc. A brief explanation about the parts is given below.
a. Title bar : The Title bar, located at the top, shows the name of the current spreadsheet. The first created spreadsheet takes the name as Untitled 1, second is Untitled 2 and so on.
b. Menu bar : Menu bar is located just below the Title bar. It contains the menus with commands for various tasks.
c. Toolbars : The Calc opens with the Standard and Formatting toolbars at the top of the workspace by default. These toolbar provide a wide range of common commands and functions. Placing the mouse cursor over any icon displays a small box called a tooltip.
d. Worksheet : The worksheet in Calc is also referred to as spreadsheet. The spreadsheet can have many sheets. Each sheet can have many individual cells arranged in rows and columns. The sheet tab shows its default name as Sheet1, Sheet2, Sheet3, ….
e. Rows and columns : The sheet is divided into vertical columns and horizontal rows. Each sheet can have a maximum of 1,048,576 (220) rows and 1024 (210) columns. The rows are numbered as 1,2,3,4,… and columns are numbered as A, B, C, D, …., Z, AA, AB, AC, …., A Z …
f. Cell and cell address : The intersection of a row and column is called a cell. It is the basic element of a spreadsheet. It holds data, such as text, numbers, formulas and so on. A cell address is denoted by its column (letter) and row number. For example, D4, E9, Z89 are the valid example of cell address.
g. Active Cell : When we click on a cell it gets selected, and is ready to take data from the user. This selected or activated cell is called an active cell. It is always highlighted, with a thick border.
Range of cells : A block of adjacent cells in a worksheet which is highlighted or selected is called a range of cells .
The column range is the number of cells spread across the column. The cell address is represented by single column letter and multiple row number in a sequence. for example C1 : C6, A9 : A18 etc
The row range is the number of cells spread across the row. The cell address is represented by single row number with different columns. for example C5 : H5, A2 : J2 etc.
The row and column range is the number of cells spread across the row and columns. This range is a matrix with number of rows and number of columns. for example A3 : G5, D2 : H4 etc.
Let’s Practice 2
- What is the address of the first cell represented by Range1?
- What is the address of the last cell represented by Range1?
- Write the cell range represented by Range1.
- Write the cell range represented by Range 2.
- What is the name of the cell range along a row?
- What is the name of the cell range along a column?
- Write the cell range represented by Range 3.
- Give the number of cells in the cell range represented by Range 3.
Entering data : The data to be entered in a worksheet can be the label, values or formula.
a) Label : Label is the any text entered by using a keyboard. It may combine with letters, numbers, and special symbols. By default the labels are left aligned.
b) Values : The numerical data consisting of only numbers are called values. By default values are right aligned.
c) Formulae : Any expressions that begins with an equals ‘=’ is treated as formula.
Mathematical operators used in formulae : Spreadsheet Software has the most powerful features to calculate numerical data using formulae. LibreOffice Calc uses standard operators for formulae, such as a plus(+), minus(-), multiplication (*), a division (/) for arithmetic operation.
Note: The order of evaluation can be changed by using brackets.
Note: Formula starts with ‘=’ sign and nothing should be written on the left side of the equal sign (‘=’). If you forgot to put the ‘=’ before the formula, it will be treated as a label.
Steps to rename sheet :
- Select the menu Sheet → Rename Sheet.
- Give appropriate name and click OK
Steps to save the worksheet : To save the worksheet
- click on File → Save.
- A Save dialog box will appear.
- Select the location where you want to save the file.
- Enter the name of the file say, ‘Bill’
- Click on the Save button.
Steps to insert the column before any column : Position the cursor on any cell of the column before which you want to insert the column and select Sheet → Insert Columns → Columns → Columns left
Steps to insert the column after (right side) any column : Position the cursor on any cell of the column after which you want to insert the column and select Sheet → Insert Columns → Columns → Columns right .
Function : Functions are predefined formula in Calc which is used for tasks like finding the sum, count, average, maximum value, and minimum values for a range of cells.
Commonly used basic functions in Calc
Formatting the worksheet : The cell data can be formatted using Format cells dialog box. The Format cells dialog box can be opened using Format→cells using the Format menu, or from context menu opened through right clicking the cell. Shortcut to open this Format Cell dialog box is Ctrl+1. Various options of Format cell dialog box are shown below.
a) Formatting a range of cells with decimal places : Following are the steps to format a cell to the required number of decimal places:
- Select the range of cells.
- Open the ‘format cells dialog’ box
- Click the ‘Number’ tab
- Select the ‘Number’
- Change the decimal places as required
b) Formatting a range of cells to be seen as labels : Follow the steps below in order to format a range of cells as text.
- Select the range of cells
- Click the Number tab
- Select Text
- Enter numbers
c) Formatting of a cell range as different date format : In a spreadsheet application, the user can change Date in many different formats. To do these follow the below steps.
- Open the ‘Format cells dialog’ box
- Select the ‘Date’ category
- Select the date format
d ) Formatting a range of cells to display times : Follow the steps below to format a range of cells to display the time.
- Select the cell range
- Select the ‘Time’ category
- Select category Time should be displayed
e) Formatting alignment of a cell range : Follow the steps below to format the alignment of range of cells.
- Click the ‘Alignment’ tab
- Select left, right or center
Fill handle of a cell : The small black square in the bottom-right corner of the selected cell or range is called a fill handle.
Referencing : Referencing is the way to refer the formula or function from one cell to the next cell along the row or column. There are three types of referencing.
- Relative referencing
- Mixed referencing
- Absolute referencing
1. Relative referencing : When you drag any formula in any row or column in any direction, the formula gets copied in the new cell with the relative reference. for example A1, H15 etc.
2. Mixed referencing : In Mixed Referencing, the $ sign is used before row number or column name to make it constant. for example A$5, $C14.
3. Absolute referencing : In Absolute referencing, a $ symbol is used before the column name as well as row number to make it constant in any formula. For example, $C$12, $D$5, etc.
Identify the cell referencing in the following table:
Creation of Charts Using Spreadsheets : It is not easy to comprehend, compare, analyze or present data when they are represented as numbers. But when data are presented in the form of charts they become an effective tool to communicate. The various types of charts are given below.
Steps to create a column chart :
- Select the range of data say A1:F7
- Click on Insert → Chart
- Select the type of chart ie Column chart
- Click Finish
Disclaimer : I tried to give you the correct “ Electronic Spreadsheet Class 9 Notes ” , but if you feel that there is/are mistakes in “ Electronic Spreadsheet Class 9 Notes ” given above, you can directly contact me at [email protected]. Book and Study material available on CBSE official website are used as reference to create above “ Electronic Spreadsheet Class 9 Notes “. Screenshot of Electronic Spreadsheet interface used in the above blog is taken from CBSE study material.
Important Links of Class IX
Click here to download book pdf
Unit 1 : Introduction to IT–ITeS Industry
MCQ —————————– Notes ——————— Book Solution ————— Practice Questions
Unit 2 : Data Entry and Keyboarding Skills
MCQ —————————–Notes——————— Book Solution ————— Practice Questions
Unit 3 : Digital Documentation
Unit 4 : electronic spreadsheet, unit 5 : digital presentation, 2 thoughts on “unit 4 electronic spreadsheet class 9 notes important points”.
there are so many mistakes in electronic spreadsheet. so many things were repeated
=MIN- finds the smallest value in the range of cells. You typed there LARGEST, kindly change it
Leave a Reply Cancel reply
Mathematics Presentation for Class 9
Mathematics, chapter 1: number systems, chapter 2: polynomials, chapter 3: coordinate geometry, chapter 4: linear equations in two variables, chapter 5: introduction to eucluid's geometry, chapter 6: lines and angles, chapter 7: triangles, chapter 8: quadrilaterals, chapter 9: areas of parallelograms and triangles, chapter 10: circle, chapter 11: constructions, chapter 12: heron's formula, chapter 13: surface areas and volumes, chapter 14: statistics, chapter 15: probability.
Disclaimer: All contents are collected from various sources and updated at this platform to help teachers and students. If content owner (Original Creator) have any objection, Please mail us to [email protected] with ID Proof, content will be removed/credited. Thanks and Regards
Notes Station: To Read Click on Title
Mathematics presentation for class 9 chapter wise, कक्षा 6 पाठ योजना संस्कृत पाठ 1 class 6 sanskrit lesson plan chapter 1, split up of syllabus class 6 sanskrit, split up of syllabus class 6 hindi, book cart: to purchase click on title.
Oswaal Science Question bank - 9
Oswaal English Lang. & Lit. Question bank - 9
Oswaal Social Science Question bank - 9
Oswaal Mathematics Question bank - 9
MTG Foundation Course NTSE-NVS-NSO - 9
Golden Science Refresher for Class - 9
All in One Mathematics for Class - 9
All in One English Lang. & Lit. for Class - 9
All in One Social Science for Class - 9
All in One Hindi Course A for Class - 9
Beehive English Textbook Class - 9
NCERT - Mathematics Solutions - Class 9
Social Sc. Combo Pack NCERT Textbook - 9
Full Marks Hindi Course A Workbook Class - 9
Hindi Sparsh Bhaag 1 - NCERT Class - 9
Mathematics Textbook NCERT Class 9
NCERT Textbook Science Class 9
Full Marks CBSE Science Workbook - Class 9
Full Marks So. Science Workbook - Class 9
NCERT -Set of 8 Books - Class 9
Chapter wise Worksheets for CBSE All Subjects - 9
Full Marks Mathematics Practice Book Class 9
Full Marks English Workbook Class - 9
CBSE All In One Science Class 9
Mathematics by R D Sharma - Class 9
Amazon Affiliate Disclaimer: cbsecontent.com is a part of Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.in. As an amazon associates we earn from qualifying purchases.
I like this that’s great