L 3 Ms Excel with Function/ Class- 8

Computer Science

Class-VIII

Lesson 3  MS Excel with function

A. Fill in the blanks:-

1. A numeric value used to   calculate   the factorial.

2. The Microsoft Excel FACT  function returns the factorial of a number.

3. CHAR function returns the character based on the  ASCII VALUE.

4. The syntax for the NOW function is  = NOW ( )

5. The Syntax for the CHAR function is   CHAR( ASCII_value )

 

B. Write a note:-

1. Fact Function

Ans: The Microsoft Excel FACT function returns the factorial of a number.

The FACT function is a built-in function in Excel that is categorized as a Math/Trig

Function. It can be used as a worksheet function (WS) in Excel.

2. Count function

Ans: Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. For example, you can enter the following formula to count the numbers in the range A1:A20: =COUNT(A1:A20). In this example, if five of the cells in the range contain numbers, the result is 5

C. Short Answer question

1. Define Ms Excel functions.

Ans: A function is a predefined formula that performs calculations using specific values in a particular order. Excel includes many common functions that can be used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells.

2. Explain these Functions with suitable examples:-

1. Fact()

Ans: The Excel FACT function returns the factorial of a given number. For example, =FACT(3) returns 6, equivalent to 3 x 2 x 1. number - The number to get the factorial of.

2. Char ()

Ans: The Excel CHAR function returns a character when given a valid character code. CHAR can be used to specify characters that are hard to enter in a formula. For example, CHAR(10) returns a line break on Windows, and CHAR(13) returns a line break on the Mac

 

3. Date/ Time

Ans: To enter a date in Excel, use the "/" or "-" characters. To enter a time, use the ":" (colon). You can also enter a date and a time in one cell. Date

3. Explain the Shortcut Keys to Formatting Date and Time

Ans: Date (day-month-year format)

Ctrl + Shift + #

Time (hour:minute:second and AM/PM format - such as 10:33:00 AM)

Ctrl + Shift + @

..............................................................................................................

Extra Question :

Q 1 Define formulae

Ans: Formula is an expression that calculates values in a cell or in a range of cells. For example, =A2+A2+A3+A4 is a formula that adds up the values in cells A2 through A4.

Q 2 Define function

Ans: A function is a predefined formula that performs calculations using specific values in a particular order. Excel includes many common functions that can be used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells.

Q 3 Write the type of functions

Ans:                 

Type	Example
Financial	PMT, Rate, etc.
Logical	And, If, Not, Or, etc.
Text	Char, Left, Right, etc.
Date & Time	Date, Time, Now, etc.
Look up & Reference	Hyperlink, lookup etc.
Math & Trig	Fact, Log, MOD, etc.
Statistical	Count, Max, Min, etc.
Engineering	Delta, erf, etc.
Cube	Cubeset, cuevalue, etc.
Information	Cell, info, etc.
compatibility	Mode, rank, etc.

  

Q 4 List of Functions

Function	Type	Syntax	Use
Now()	Date & Time	= Now( )	The NOW function in Excel is a formula that displays the current date and time.
Date	Date & Time	=Date(year, month, day)	Returns a date, from a user-supplied year, month and day
Time	Date & Time	=Time(hour, minute, second)	Returns a time, from a user-supplied hour, minute and second
Count	Statistical	=count(value1,value2…)	The COUNT function will count cells that contain numbers.
Char	Text	=Char (number)	The Microsoft Excel CHAR function returns the character based on the ASCII VALUE. The CHAR function is a built-in function in Excel that is categorized as a String/Text Function. It can be used as a worksheet function (WS) in Excel.
Fact	Maths & Trig	=Fact(number)	The Microsoft Excel FACT function returns the factorial of a number. The FACT function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function (WS) in Excel.