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

Explain Data Processing Cycle and Main Activities of Data Processing Cycle

After collecting data, it is processed to convert into information. The data is processed again and again until accurate result is achieved. This is called data processing cycle . Data processing cycle involves following three basic activities: Major Activities Involved in Data Processing Cycle Explain Data processing cycle 1. Input 2. Processing 3. Output 1. INPUT It is the process in which collected data is given to computer after converting into binary form. Input step can be further divided into following steps: i) Planning Here objectives of data processing are defined. For example, in examination system, objective is to process student examination data to get result cards. ii) Data Collecting Here data is collected. Data is the raw material for data processing. This must be accurate for getting accurate results. iii) Input Here data is entered into computer. iv) Verification Here collected data is verified to determine whether it is valid for ...

Explain Different Types of Data Processing and Advantages Disadvantages

Today we will discuss different types or levels of data processing in detail. Let us define Data processing first. DATA PROCESSING Data processing is the sequence of operations performed on data to convert it into useful information . These operations may be arithmetic, statistical or logical operations. We can arrange or classify data. We can send and receive data from one point to another. Explain different types of data processing TYPES OF DATA PROCESSING (OR) LEVELS OF DATA PROCESSING) There are three types of data processing . 1) Manual data processing 2) Mechanical data processing 3) Electronic data processing We may also use the term Levels of data processing. First level of data processing was manual data processing when there were no calculating devices (before the invention of calculators). Therefore all processing jobs were performed manually by hand with the help of pen , paper and mind. In second level of data processing, machines like calculat...

Perfect Computer Notes

Search This Blog