Excel Worksheet Student Absence Fine Calculation Formulas

Today, we will discuss how to create an Excel Worksheet that helps calculate Students Absence Fine Calculation on basis of Total Lectures Delivered and Total Lectures Attended (Presence) of the student.

Steps To Prepare an Excel Worksheet for Student Absence Fine Calculation

1. Start MS Excel with a blank workbook option.

2. Type sample data in first Excel worksheet as shown in the given image.

3. Type formula for calculation of number of absence of a student.

Place cursor in Cell with reference E3.

Type = sign in E3

Type C3-D3 and press Enter

Steps To Prepare an Excel Worksheet for Student Absence Fine Calculation

4. Copy the formula of cell E3 in all lower level cells with the help of Fill Handle in

lower right corner of Cell E3.

5. Type formula for calculation of fine by multiplying cell E3 with 50.

6. Type formula of fine calculation =E3 * 50 and press enter in cell referenced by F3.

7. Copy the fine calculation formula downward in all required cells of column F.

8. Congratulations you have successfully prepared Excel Worksheet for Absence Fine calculation of students.

9. Please, do not forget to save file.

Comments

Explain Different Types Of Data

DATA Data is the collection of raw facts and figures. It is without any proper meaning. Data may be collection of words, numbers, graphics or sounds. What is data? Explain different types of data Examples of Data 1) Student Data on Admission Forms When students get admission in a college. They fill admission form. This form contains raw facts (data of student) like name, father’s name, address of student etc. 2) Data of Citizens During census, data of all citizens is collected. 3) Survey Data Different companies collect data by survey to know the opinion of people about their product. 4) Students Examination data In examination data about obtained marks of different subjects for all students is collected. Different Types Of Data There are following main types of Data. 1) NUMERIC DATA Numeric data consists of 0 to 9 digits, + and – sign and dec...

What are Dual Devices or Both Input/ Output Devices

The devices that can be used to perform both functions -input and output- are called Dual Devices. These devices are also called Dual Purpose Devices or Both Input/Output Devices. With the help of a dual purpose device, we can enter data into computer as well as we can output data from the computer to outside world. For example, Dual devices include: Touch Screen Monitor, Modem, Network Interface Card, Sound card, Hard disk drive, Floppy disk Drive, Magnetic Tape Drive CD-Writer and DVD-Writer etc. These are also called Input/output devices, because they perform both functions. Touch Screen Monitor Dual Devices or Both Input / Output Devices - Touch screens Touch Screen Monitor is an input/output device. It uses a special touch sensitive screen. The User can enter data by touching icons or menus on the screen. As soon as the user selects a command from menu, output is displayed on screen. Commonly touch screen monitors use sensors to detect touch of finger. ...

Important Objective Type Questions 101-155

MMC stands for multimedia card. SD stands for secure digital card. System Bus is used to connect main components of a computer such as cpu and main memory. A Port is an interface or a point of attachments. POS stands for Point Of Sale terminal. ATM stands for Automated Teller Machine. PIN stands for Personal identification number. Kbps stands for kilobits per second. Mbps stands for megabits per second. A port that transmits one bit at a time is called Serial Port. A type of port that transmits many bits at a time is called Parallel Port. LPT stands for Line Printer. Examples of system software are Operating System, Utility Programs and Device Drivers. Examples of operating systems are DOS, Windows, Unix and Linux. Examples of Utility programs are File Manager, Image Viewer, Disk Scanner and File Compressor. Software used to detect and remove viruses is called Antivirus . Examples of antivirus programs are Mcaffee, Avast, ...

Perfect Computer Notes

Search This Blog