Assalamu’alaikum.
Microsoft Excel known as the use of formulas – formula or formulas in the worksheet. Penggunaan rumus yang efektif akan memudahkan kalian dalam membuat laporan pekerjaan dengan menggunakan Microsoft Excel. Microsft Excel formulas or formulas have their own advantages for processing data through material calculations which are very diverse in function.
Digital School Solution application Digital School Solution 2003,2007,2010,2013, or the latest version 2016 or 2019, then surely you are already familiar with using the formula – Microsoft Excel formulas contained in the application. Now the question is what if you are a beginner ? what if you still don't know at all to open the Microsoft Excel data processing application as will be explained now ? No need to worry. now you will also be able to apply the formula – The formula in Microsoft Excel in this blog will include examples and pictures that will make it easier for you to practice it.
On facing various school exams from the Daily Test, UTS, UAS and Other tests, making staff or teachers or teachers must be busy with processing grades. Pengolahan nilai ujian memang membutuhkan waktu yang cukup banyak jika tidak memahami bagaimana method pengolahannya. Sesuatu yang sering terjadi di sekolah bahwa setiap guru mata pelajaran diharuskan memberikan results pengolahan nilai ujian tersebut dan dilaporkan ke kurikulum atau bahkan langsung diinformasikan melalui papan pengumuman untuk dibaca dan diketahui oleh siswanya.
Some teachers still use the manual system for processing grades nowadays by looking at the test scores, then determine the information whether the student passed or did not pass (remedial) with a predetermined minimum proviso standard. If you do this the manual way we are sure it will take up a lot of time. What if your students consist of hundreds or even thousands?
To determine the graduation criteria, will be used IF logic function. Reviews of form and description Digital School Solutionwe have discussed earlier in our post.
The following is step – steps to make pass and fail descriptions using the logic IF function :
- For example, data from a high school will be used as shown in the following figure:
Table List of students who will be searched for pass or fail information - For example, with the data above, you are asked to fill in the information column with a predicate GRADUATED or NOT PASS. The provisions are:
When average on cells F2 greater than or equal to 60, then it is stated GRADUATED, and when less than 60 stated NOT PASS. - Activate the mouse pointer on cell G2, then enter the following formula:
=IF(F2>Digital School Solution,Digital School Solution)
Add logic IF formula to cell G2
- Enter the formula above correctly, then press Enter on the keyboard. Digital School Solution “NOT PASS” Digital School Solution Rate-rate of salt F2 specified value 51,00.
Copy the formula into the cells below to see the graduation descriptions for other students.
Thus the article about creating a pass caption formula using the Microsoft Excel application, hopefully useful for all of us. thank you
Similar Posts:
- Excel Formula Calculates Percentage of Test Questions – Blog / items Microsoft Excel Rumus excels
- Understand the Excel Formulas Writing Procedure – Blog / items Microsoft Excel Rumus excels
- Excel Formula Finds Due Date – Blog / items Microsoft Excel Rumus excels
- Understanding Types – Type of Error Code in Microsoft Excel – Blog / items Microsoft Excel Rumus excels
- Online Exam Student Guide on the CBT System System Application – Blog / items Suspend-CBT System Tutorial & Way
- What is a Sispendik Application ? – General
- Complete Tutorial for Students Using the Madrasah Elearning Application – Blog / items Elearning Madrasah General
- How to Quickly Create a Decimal Value – Microsoft Excel
- How to Display Data With Accounting Format – Microsoft Excel
- How to Distinguish Positive and Negative Values with Symbols in Excel – Microsoft Excel
