Page 151 - Excle-En-V3

Create a cell for each faculty department, and in front of each department,
create a cell in which is written (Passed) and another (Failed). In front of the cell,
type the following function:

=COUNTIF ('English'!F3:F6,"passed")
=COUNTIF ('English'!F3:F6,"failed")
This is to count all the cells in the range F3:F6 in the “English” worksheet that
contain the word “passed”, and the same applies to the cells that contain the word
“failed.”
You can create a more professional and complex database using the Visual Basic
programming language by programming the Excel application to perform specific
tasks such as storing data in a database, recalling, and printing. To discover how to
do this in detail, you can search for Excel VBA online.

28 – Second Day Activities:

Activity 1
1 .Find the maximum value for the total number of students
2. Find the average for the total

143 Central Unit for Information Technology Training - Supreme Council of Universities © Intellectual Property Rights 2024