Class 7 Computer Notes for August Month – Navodaya TGT CS

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

1. 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
2. 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.

1. SUM Function – Syntax: SUM (number1, [number2], [number3], …)
2. AVERAGE Function – Syntax: AVERAGE (number1, [number2], [number3], …)
3. IF Function – Syntax: IF  (logical_test, [value_if_true], [value_if_false])
4. MIN & MAX Function – Syntax: MIN (number1, [number2], …)    |      MAX (number1, [number2], …)
5. TRIM Function – Syntax: TRIM (text)
6. CONCATENATE Function – Syntax: CONCATENATE (text1, [text2], …)
7. COUNT Function – Syntax: COUNT (value1, [value2], …)
8. COUNTA Function – Syntax: COUNTA (value1, [value2], …)
9. COUNTIF Function – Syntax: COUNTIF (range, criteria)
10. SUMIF Function – Syntax: SUMIF (range, criteria, [sum_range])

Thanks to Beloved Readers.