Std 7 - Chapter - 3 - More on MS Excel 2007 - Formulae and Functions

Chapter - 3

More on MS Excel 2007 – Formulae and Functions

1.	What do you understand by the term Conditional Formatting?
	This feature allows us to format the data in the worksheet depending on if it satisfies a certain condition.
2.	What are functions?
	Functions are predefined commands that act on a cell or range of cells and perform some particular operation quickly.
3.	Define the term filtering?
	Filtering is a quick way to find a set of data in a range.
4.	What is cell referencing?
	Cell referencing means how a cell address behaves in the formulae when it is copied from one cell to the other.
5.	What do the following functions do? Explain with proper syntax and example of each.
	a)      SUM: It adds all the numbers in a given range of cells. Syntax: =SUM(range or numbers) Example: =SUM(A1:A5) b)     AVERAGE: It calculates the average of the numbers in a given range of cells Syntax: =AVERAGE(range or numbers) Example: =AVERAGE(A1:A5) c)      MIN: It returns the smallest value in a given range of cells. Syntax: =MIN(range or numbers) Example: =MIN(A1:A5) d)     MAX: It returns the largest value in a given range of cells. Syntax: =MAX(range or numbers) Example: =MAX(A1:A5)
6.	What is the use of IF function? Explain with an example.
	The IF function checks to see if a condition you specify is true, or false. The IF function returns the first value if the condition specified evaluates to TRUE and the second value if it evaluates to FALSE. Syntax: =IF(condition, value_if_True, value_if_False) Example 1: =IF(A1>50, 150,100) Example 2: =IF(A2=100, A2*10,”LOW”)
7.	What is Sorting? In how many ways you can sort your data?
	Sorting means to arrange data either in ascending or descending order. Excel allows you to sort by date, sort by text or numbers, sort by multiple columns, or by colour. And, if you like, you can even colour code your data.
8.	Define the following with an appropriate example of each.
	a)      Relative referencing: in this referencing both column part and row part are not fixed. E.g. if the formula in D4 is =B4*C4, when the formula is copied vertically notice that the cell address in the formula is automatically changed. (Pg. No 36) b)      Absolute referencing: in this referencing both column part and row part are fixed.  E.g. if the formula in D4 is =$B$4*2 and when it is copied to the lower rows, there is no change in the cell address. (Pg. No 37) c)      Mixed referencing: in this referencing either column part or row part is fixed.  E.g. $B4 is a mixed cell reference with absolute column and relative row and C$4 is a mixed cell reference with relative column and absolute row. (Pg. No 37)
9.	Write the steps to apply Custom Filter on a range of cells.
	Step 1: Click Data tab – filter Step 2: Click the arrow in the column heading. Step 3: Select Number Filters from the list. Step 4: Click Custom Filter, Custom AutoFilter dialog box appears. Step 5: Choose the option according to the condition you want. Step 6: Too add another criteria, click Add Step 7: Specify the second condition in the same way. Step 8: Click OK button to view the rows according to the specified conditions.

Std 7 - Chapter 2 - More on MS Windows 7

Chapter - 2

More on MS Windows 7

1.	What is the use of Select all option?
	Select all option is used to select all the files and folders present in a folder or drive.
2.	How do you work with On-screen Keyboard?
	After opening the On-Screen keyboard, type using the mouse or another pointing device by just clicking the required key.
3.	How do you create a shortcut for any file/folder on the desktop?
	Select the file/folder, Right click on file/folder and select Send To option, Select the Desktop to create a shortcut on the desktop.
4.	What is Windows Explorer?
	The Windows Explorer program is efficient for viewing files/folders in Windows.
5.	Write down the different Group by option available for arranging the contents of a folder/drive.
	Group by option organises files and folder by breaking them into different sections. 1)      Name: It organises files and folders in alphabetical order by their name. 2)      Date modified: It arranges icons in the ascending order of modification date. 3)      Type: It organises files and folder according to their file type. 4)      Size: It organises files and folders in order of file size.
6.	What do you mean by CD burning?
	CD burning is the process of copying data to CD/DVD.  To burn a CD/DVD we require a recordable CD drive or DVD drive, a writable CD or DVD-ROM, a CD or DVD burning software installed on your computer.
7.	What are Libraries in Windows 7?
	Libraries are user defined collections of content.  It is a kind of folder used to manage documents, music, pictures and other files.
8.	Write down the different viewing options available for viewing the contents of file/folder.
	a)      Extra Large Icons: displays your files and folders as extra-large icons. b)      Large Icons: displays your files and folders as large icons. c)      Medium Icons: displays your files and folders as medium icons. d)      Small Icons: displays your files and folders as small icons. e)      List: displays the list of files and folders preceded by small icons. f)       Details: lists the files and folders with detailed information about your files, including name, type, size and date modified. g)      Ties: displays your files and folders as icons. h)      Content: displays your files and folders in content format with name, type, and size information.

Additional Questions

1.	How to select files/folders randomly?
	Hold down CTRL key and click on the required files or folders.
2.	What do you mean by shortcuts?
	Shortcuts are a convenient way to open any file, program without going to the actual location of the file.  You can create a shortcut of any file at any locations such as inside a folder, on desktop etc.
3.	What is the use of Sort by option?
	The Sort by option is used to arrange the icons of a file/folder according to different parameters such as name, date modified, type and size.

Std 7 - Chapter 1 - Introduction To Computers

Chapter - 1

Introduction to Computers

1.	What is the relationship between computer hardware and software?
	Both Hardware and Software together make a computer system functional.
2.	What do you do when the computer stops responding?
	Close the applications if possible.  Press Ctrl+Alt+Del key combination.  Choose Start Task Manager, Click and select the application which is not responding, Click on the End Task button to terminate the problem.
3.	What is a plotter?
	Plotter is used for making a large paper drawing such as construction maps or engineering drawings.
4.	Define field and record.
	A field is a collection of bytes that contain data bout an item. Eg: name of a student. A record is a collection of inter-related fields. Eg: a student’s record may contain name, age, and class.
5.	Define the terms Hardware and Software.
	Hardware is the physical component of a computer system.  E.g. CPU, RAM, Monitor Software are the instructions or commands that make the hardware components operational. E.g. Operating System, Application Software
6.	What is data hierarchy?
	Data Hierarchy refers to the systematic organization of data, often in a hierarchical form. Data organization involves fields, records, files and so on.
7.	What is a bit?
	A bit is the short form of Binary Digit.  A computer system represents data using the digits 0 and 1.  A bit is represented by an electronic circuit that is either OFF or ON.
8.	Write short notes on Application Software and System Software.
	Application Software: Application Software consists of programs that are designed to do specific tasks, such as payroll, inventory, word processing, spread sheets etc. System Software: It performs the basic functions and controls the various resources of a computer system.  The Operating System is an example of System Software.  E.g. Windows 7, Linux etc.
9.	Explain the computer memory and its types.
	The storage device of a computer system is known as computer memory.  There are two types of computer memory: 1)      Primary Memory: is often called the working memory or the main memory of a computer system.  RAM and ROM are the two major types of primary memory. a.      RAM: Random Access Memory:- It is capable of sending and receiving data at a very high speed.  RAM is volatile in nature means when the computer switched off data stored in RAM is lost. b.      ROM: Read Only Memory:- it holds instructions put by the manufacturer to operate the computer.  It is permanent memory. 2)      Secondary Memory: is used to store data for a long time.  It is permanent in nature.  Data stored in secondary memory are not lost when the computer is switched off.  It is also called non-volatile memory.  E.g. Hard Disk, Pen drive etc.
10.	Explain the types of printers.
	There are mainly three types of printers: Dot Matrix Printer: This printer contains movable print head with pins that strike the ribbon placing a dot on the paper with hundreds of dots forming images or text.  These printers are less expensive but are very noisy. Inkjet Printer: This printer forms letters and images on the paper by spraying small streams of quick-drying ink. Laser Printer: This printer uses laser technology to print images on the paper.  This gives the best quality output and is the most expensive.

Additional Questions

1.	What do you mean by Troubleshooting?
	Detecting the problem in a computer system when it is not working properly is called troubleshooting.
2.	What do you mean by ‘Computer is Hung’?
	While working on our computer and our system suddenly stops responding to your commands.  This situation is known as ‘Computer is Hung’.
3.	What is a Database?
	A database is a collection of all the files in an organization.  E.g. files of students, teachers and other staff members of in a school make the school database.
4.	Explain the various types of scanners.
	This input device scans images from photographs, posters, magazine’s directly into the computer. Flatbed Scanner: This scanner has a flat plane of glass where the item being scanned is placed.  It works like a photocopy machine. Handheld Scanner: This scanner is dragged over the object that needs to be scanned.  It is mostly used in shopping stores.

IT Club Entrance Examination 2013

IT Club Entrance Examination for 2013-14 commenced on 12-06-2013.  Those who given name for the examination be in touch with me for the exact time and date.  Mostly the exams will be after school hours.  That is 2:45 pm to 3:30 pm.

All the best for the examination

Std - 8 - Chapter - 1

1.	What is a computer network?
	A computer network is a collection of computers and peripheral devices connected by communication links.
2.	What is a workstation?
	Workstation is a computer that is connected to a network.
3.	What are the basic types of topologies?
	Star, Ring and Bus are the basic types of topologies.
4.	Write full forms of the following
	a)      LAN – Local Area Network b)      WAN – Wide Area Network c)      MAN – Metropolitan Area Network d)      PAN – Personal Area Network e)      CAN – Campus Area Network f)       NIC – Network Interface Card g)      TCP/IP – Transmission Control Protocol / Internet Protocol h)      HTTP – Hyper Text Transfer Protocol
5.	What is a Node?
	A node is a computer or any other devices on a network that communicates with other devices.
6.	What is a topology?
	The art of connecting different computers in a network is known as topology.
7.	Describe a network and networking in your own words?
	A network is a group of devices connected with one another.  Networking refers to the inter-connection of various devices to share their resources.
8.	Differentiate between LAN and WAN.
	LAN (Local Area Network) is a computer network covering a small geographic area, like a home, office, schools, or group of buildings.	WAN (Wide Area Network) is a computer network that covers a broad area (e.g., any network whose communications links cross metropolitan, regional, or national boundaries over a long distance.
	High Speed	Low Speed
	Network in an organization can be a LAN	Internet is a good example of a WAN
9.	Write short note on the hardware parts required to establish a network.
	Network hardware includes the physical components that are used to create a network. Cables: Cables are the wires that connect computers and resources on a network. Connectors: A connector is a device that joins two computers or networks together. NIC: Network Interface Card is a device that joins a cable to a computer.
10.	Write Three benefits of a network.
	Ease of Access: Storing information on one or two central computers makes it easy for people to work with and manage their files. Work From Home: The network has dedicated computers that allow people to connect to the company’s network at home using a modem. Share Resources: Computers connected to a network can share equipments and devices including printers and hard drives.
11.	Write advantages and disadvantages of the following:
	a)      Ring Topology Advantages: The ring works well where there is no central-site computer system. It is more reliable than a star network. Disadvantages: Requires more complicated control software. Failure of one node results into the failure of the entire network. b)      Star Topology Advantages: Star topology has minimal line cost. If any of the local computers fails, the remaining portion of the network is unaffected. Disadvantages: The system crucially depends on the central switch. If it fails, the entire network goes down. c)      Bus Topology Advantages: It is quite easy to set up. Failure of one node does not affect the rest of the network. Disadvantages: It offers limited flexibility for change. A signal on the bust must be strong enough to reach the receiver.

Additional Questions

1.	What is a File Server?
	A file server is a computer connected to the network, which serves or distributes files to the network users.
2.	Explain Wi-Fi?
	Wi-Fi (Wireless Fidelity) technology is the wireless computer network that allows users to connect to the Internet without wires or cables.
3.	What is an Enterprise Network?
	When a single company owns and controls a wide area network, it is often called as an Enterprise Network.
4.	What is HTTP?
	Hyper Text Transfer Protocol (HTTP) is a set of rules for transferring files (text, graphic images, sound, video, and other multimedia files) on the World Wide Web.
5.	What do you mean by a network protocol?
	A network protocol defines rules for communication between network devices.  E.g.: HTTP, FTP, TCP/IP