Skip to main content

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.
Excel Worksheet Student Absence Fine Calculation Formulas
Excel Worksheet Student Absence Fine Calculation Formulas


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

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

Popular posts from this blog

Introduction to Algorithms and Algorithmic Notation With Examples

Topic: Introduction to Algorithm and Algorithmic Notation With Examples What is an Algorithm? The step by step procedure to solve a particular problem is called an Algorithm .  A Good Programmer always writes algorithms before developing programs. Algorithmic Notation with example algorithms  Advantages of  writing an Algorithm The process of solving a problem becomes simpler and easier with the help of  algorithm. There are less chance of errors in the program, if we design algorithms before writing our programs in any programming language. We can convert an algorithm into a program of any programming language. It is not dependent on any programming language. Therefore it is easy to understand for anyone even without programming knowledge. What is the Relationship between an Algorithm and a Program Sponsored Links An algorithm is the sequenc of steps to perform a task, whereas a program is the set of statements to perfor...

Define Data and Information With Examples

DATA Data is the collection of raw facts and figures. Actually data is unprocessed, that is why data is called collection of raw facts and figures. Define Data and Information with Examples We collect data from different resources. After collection, data is entered into computer for processing. Data may be collection of words, numbers, pictures,  or sounds etc. 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, obtained marks, photo graph etc. 2)    Data of Citizens During census, data of all citizens is collected. The staff will go house to house and collect data about citizens like number of persons living in a home, either they are literate or illiterate, number of children, data of each child, cast, religion, Computerized national Identity Card number, address, how many rooms and...

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