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.

 

 

L 2 Advance feature of Ms Word Page Layout / Class- 7

Computer Science

Class-VII

Lesson 2: Advance feature of Ms Word -Page Layout

A. Fill in the blanks

[One, margins, landscape, ghosted, portrait, width ]

1. Margin is the space between boundary of the paper and the text

2. The two types of orientations are _Portrait   and Landscape

3. Watermark is used to set the ghosted   text behind the content of every page.

4. You can choose style, colour and width  of your border.

5. By default there is only   one   column in your document.

B. True or False

1. Column option is available in Insert Tab.                                        False

2. You can set only two types of margins in MS Word.                      False

3. By default the orientation of a page is Portrait.                              True

4. A4 size is available in Page size option.                                           True

5. You will not set border colour in MS Word.                                   False

C. Short answer type questions

1. Name two types of orientations.

Ans: Page orientation is the direction in which a document is displayed or printed. The two basic types of page orientation are portrait (vertical) and landscape (horizontal). By default the orientation of a page is Portrait

 

2. Name four Margins available in MS Word.

Ans: It means the space between boundary of the paper and the text. You can set four margin Left, Right, Top and Bottom of your document. By default all margins are set to 1 inch.

 

3. Write the default margin set for the document.

Ans: By default all margins are set to 1 inch.

 

 

D. Long Answer Questions

1. What is the use of watermark?

Ans: Water mark option is used to set the ghosted text behind the content of every page. A watermark is a picture or text that appears behind a document's contents.

 

2. Write the steps to set the border of a document.

Ans: To apply border follow these steps..

1. Select Page layout tab and choose border from page background group.

2. Choose any style of your choice to set border. You also choose colour and width

of your border

 3. Then Click on ok. your screen will appear like this

 

3. Write the steps to change the number of columns.

Ans: Steps to use two or more columns in your document..

1. Select Page Layout Tab and select columns options. A drop down box will appear

2. Choose more columns if you want more than three columns in a document. A box

will appear .

3. Choose any number of option in NUMBER OF COLUMNS. For example if we choose two columns the screen will appear .

 

4. Write the steps to choose the landscape orientation of a document.

Ans: Choose landscape by using following steps.

1. Click on Page Layout Tab and choose Orientation option.

2. Two options shows on your screen as shown in figure. Choose landscape option.

 

L 2 Memory & Storage / Class-4

Computer Science

Class-IV

Lesson-2 Memory and Storage

 

A. Multiple Choice Questions (MCQs) :

 

1. The hard disk is located inside the :-

a) Printer                                        b) Monitor                                 c) CPU Box

Ans: c) CPU Box

 

2. Which of the following is not a primary memory?

a) Hard disk                                    b)ROM                                       c) RAM

Ans: a) Hard disk

 

3. The maximum capacity of multimedia card is upto…..

a) 223 GB                                        b) 128 GB                                   c) 31 GB

Ans: b) 128 GB

 

4. It is not a secondary storage device :

a) DVD                                            b) CD                                         c) RAM

Ans: c) RAM

 

5. It is a new optical disk format which is rapidly replacing DVDs .

a) CD                                               b) Pen Drive                              c) Blue Ray Disk

Ans: c) Blue Ray Disk

 

A. State True or False :-

1. RAM stands for Random Access Memory.                                                     True

2. The Primary memory has a limited storage capacity.                                  True

3. Memory Card is approximately of the size of postage stamp.                    True

4. A hard disk is very small in size.                                                                     False

5. A Flash Drive is very small in size and re-writable.                                       False

 

C. Fill in the blanks :

{ Pen drive, Primary, DVD, temporarily, Bit }

 

1. Primary  .memory is permanently fixed inside the computer in the form of a hard disk.

2. A Flash Drive is popularly known as   pen drive .

3. Bit     is the smallest unit of memory.

4. DVD   is the example of secondary memory.

5. Internal memory    temporarily     stores data.

 

D. Write the full form of following abbreviations.?

1) ALU : Arithmetic Logic Unit

2) HDD : Hard Disk

3) BRD : Blue Ray Disk

4) CPU : Central Processing Unit

5) DVD : Digital Versatile Disk

 

E. Answer the following questions :-

1. What do you understand by computer memory ? Write its types.

Ans : Memory is one of the main components of the computer, as it stores all the data

for processing and future use.

There are two type of memory :

a)     Primary memory : RAM , ROM

b)     Secondary Memory : Hard Disk, Floppy Disk, CD/DVD, Flash Disk

2. What is internal memory?

Ans:  The main memory / primary memory which place inside the computer is called internal memory.

(This is the computer's main memory which is fixed inside the CPU on motherboard and it is the fastest of all other data storage. 

This memory temporarily stores data while programs are running. CPU can directly read and write on this memory. Primary Memory is the place and process to store and to record information.)

 

3. Differentiate between RAM and ROM. Mention any two points.

Ans:

RAM	ROM
1)     Random Access Memory 2)     Stores  data and program during and after processing 3)     Stores information temporarily 4)     It’s processing is Very fast, but uses a lot of power 5)     Volatile	1)     Read Only Memory 2)     Stored by manufactures 3)     Stores instructions (information) Permanently 4)     Fast, but uses very little power 5)     Non-Volatile

 

 

4. What is hard disk ?

Ans: Hard disk is an inbuilt storage medium. It is the main storage medium for computer. It is fixed inside the CPU box. 

(It has large capacity on which we can store large amount of data.  All the programs and data of computer are stored in it.

Hard disks is made up of multiple disks also called, hard platters of metal. The hard disks can store up to 2 TB to 5 TB of data.)

 

5. Write three features of Flash Drive.

Ans: 1) It is flash memory data storage devices integrated with a USB interface.

2) It is also called USB drives, thumb drives or pen drives.

3) They are typically small, lightweight, removable, rewritable and easy to carry.

4) It operates fastly and is capable of holding more data than CD and floppy are more reliable.

5) Data capacity : 512 MB, 2GB, 8GB, 16 GB, 32 GB, 64GB etc.