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

Uses Of Computer In Education Field

Computer can be used in education in the following ways: Computers In Teaching and Learning Process ( Computer Aided Learning - CAL ) Computers are being used actively in educational institutes to improve the learning process. Teachers can use audio video aids through computer to prepare lesson plans. They can use Microsoft Power Point to prepare electronic presentations about their lectures. These electronic presentations will be displayed on multimedia projectors in class rooms. This will be interesting and easy to learn for students. Multimedia presentations are easy to deliver for teachers too, These presentations save a lot of effort and time. Moreover multimedia presentations are interesting to view and hear sound and visual effects. Computers will be helpful for: Instructing the students using PowerPoint slides, Word documents or Web pages and using hyperlinks for be...

Types Of Network Topology

Today, we will types of network topology . What is a Network Topology? Definition of Network topology is the shape of the network . It is the physical layout of connected devices in a network. It tells us how a network will look like. Network Topology ( Definition 2) : The way in which the connections are made among all the network entities is called the topology of the network. Network Topology ( Definition 3) :Network topology specifically refers to the physical layout of the network, e.g., the location of the computers and how the cable is run between them. Network Topology ( Definition 4) :The physical topology of a network refers to the configuration of cables, computers, and other peripherals. The characteristics of a network depend upon the network topology selected. types of network topology Explain different types of network Topology Different network topologies are as follows: 1. Bus Topology 2. Ring Topology 3. Star Topology 4. Tree Topolo...

Explain Difference Between Compiler and Interpreter

Difference between Compiler and Interpreter The Compiler and Interpreter are the two main types of Language Translator or Language Processor Explain some important differences between Compiler and Interpreter or Differentiate between Interpreter and Compiler Compiler Interpreter 1. Compiler converts a source program into machine code as a whole. 1. Interpreter converts a source program into machine code one statement at a time. 2. Compiler after translating whole...

Perfect Computer Notes

Search This Blog