In this article we provide information regarding latest Class 7 Computer Notes for July Month – Navodaya TGT Computer Science (CS) 2024-25.
Class 7 Computer Notes for August Month – Navodaya TGT CS
We are using source for Syllabus – Navodaya Vidyalaya Samiti Perspective Academic Planning Split of Syllabus 2024-25.
We are giving to the Point Notes for the Students.
Thanks Me Later
For the August Month Notes – Class 7 Computer Subject
Unites we covered in Notes
- Working with Excel (Cont.) Table Creating in MS Excel
- Cell reference in MS Excel
- Functions in MS Excel
- Sorting of Data in MS Excel
- Filtering Data in MS Excel
- Conditional Formatting
- Protection of Workbook and Worksheet
- Working with Powerpoint
- What is Power Point ?
- Insert a new slide
- Insert a image
- Word art
- Audio and Video
- Transitions in slide
- Custom animations
So Let’s Discuss the One by one.
Working with Excel (Cont.)
We are continuing MS Excel in August Month.
Table Creating in MS Excel
(a) Cell reference in MS Excel
A cell reference in Microsoft Excel is a combination of a column letter and a row number that identifies a cell or range of cells on a worksheet. Cell references can be used in formulas to help Excel find the data or values to calculate.
(b) Functions in MS Excel
Functions and Formulas are the backbone of your Excel skills. If you are comfortable in using just a few powerful functions and formulas you are already ahead of many people around you. That is a good reason to gain some knowledge about some basic functions and formulas you should know for your everyday tasks.
The Difference between an Excel Function and Formula
Function is a piece of code designed to calculate certain values. A formula on the other hand can contain values, references to cells, and functions. So that means, if you are calculating something in Excel you use formulas and use functions within your formulas.
Now, let’s have a look at the ten most fundamental functions to create powerful formulas in Excel.
- SUM Function – Syntax: SUM (number1, [number2], [number3], …)
- AVERAGE Function – Syntax: AVERAGE (number1, [number2], [number3], …)
- IF Function – Syntax: IF (logical_test, [value_if_true], [value_if_false])
- MIN & MAX Function – Syntax: MIN (number1, [number2], …) | MAX (number1, [number2], …)
- TRIM Function – Syntax: TRIM (text)
- CONCATENATE Function – Syntax: CONCATENATE (text1, [text2], …)
- COUNT Function – Syntax: COUNT (value1, [value2], …)
- COUNTA Function – Syntax: COUNTA (value1, [value2], …)
- COUNTIF Function – Syntax: COUNTIF (range, criteria)
- SUMIF Function – Syntax: SUMIF (range, criteria, [sum_range])
Thanks to Beloved Readers.