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

Explain Main Difference Between System Software and Application Software

Topic: Explain Main Difference Between System Software and Application Software            Differentiate between system software and application software Before , explaining the main differences between application software and system software, let us know the definitions of Application software and System software with examples. What is System Software: System software is a set of programs to control all components of computer and to manage overall operations of computer system. Differences between System software and application software System software is used as a base to install and run all application software. Examples of system software include: Operating Systems, like Microsoft Windows, DOS, Unix and Linux Device Drivers like Device driver software of a Printer (found on CD normally provided with the printer) Utility Programs like AVAST anti virus, Disk Scanners and File Viewers etc. What is Applicat...

What are Different Types of Computer Hardware

What is Hardware? The physical parts of a computer are called hardware. Hardware can be touched or seen by us. For example, hard disk, mouse, keyboard, CD, CD-ROM Drive, Floppy Disk, Speakers, Modem and Printers - all are computer hardware. Explain different types of computer hardware Different types of hardware components on the basis of the functionality  they provide are as follows: 1.    Input devices Input devices are used to enter data and instructions into computer. Examples of input devices are: Keyboard, mouse, scanner, digital camera etc. Microphone Mouse Keyboard 2.    The Central Processing unit Central processing unit is the brain of the computer . It is also called CPU or Processor. Intel is the leading manufacturer of microprocessors. For example, Intel Pentium IV 3.2 MHz is an example of a CPU. You can see the images of processors / Micro processors or CPUs. Images of CPU or Microprocessor or s...

Advantages and Disadvantages of Mesh Topology

Topic: Advantages and Disadvantages of Mesh Topology Mesh Topology In a mesh topology, every device on the network is physically connected to every other device on the network. Therefore, data can be sent on several possible paths from source computer to destination computer. Mesh topology is more reliable with better performance. Mesh Network Topology is mostly used in wide area networks where reliability is important. Advantages of Mesh Network Topology 1. Since, there are many links to transfer data, Mesh topology gets rid of the traffic problem . Data may be transferred through different links. 2. If one link becomes unusable, it does not disturb the whole system . Other links can be used for communication. 3. Since each node has physical connection with other nodes, therefore, one node can transfer data to many nodes at the same time. Disadvantages of Mesh Network Topology 1. It is very expensive due to implementation of multiple links for each no...