VLOOKUP IN MS EXCEL s.3

By AndTech-ug -

 VLOOKUP stands for Vertical Lookup. it is a function that makes excel search for a certain value in a column you specify from table array, in order to return  a value from a different column in the same row.

Vlookup is often used to grade items when a grading table is given

HOW TO USE VLOOKUP




Click on the link below to practice the qn

OPEN VLOOCKUP EXCEL FILE

HLOOKUP
HLOOKUP stands for Horizontal lookup (opposite of  vlookup). it is a function that makes excel search for a certain value in a specified row from table array, in order to return a value from different row in the same column.



COUNTIF FUNCTION
Count if counts the number of cells in a range, which citifies a given criterion or condition .

Here are some examples of how to use the COUNTIF function in Excel:

  1. Counting cells with a specific value: If you want to count the number of cells that contain a specific value, you can use the COUNTIF function. For example, if you want to count the number of cells in range A1:A10 that contain the number 5, you can use the following formula:
=COUNTIF(A1:A10, 5)
  1. Counting cells that meet a condition: You can also use the COUNTIF function to count cells that meet a certain condition. For example, if you want to count the number of cells in range A1:A10 that contain a number greater than 5, you can use the following formula:
=COUNTIF(A1:A10, ">5")
  1. Counting cells with specific text: If you want to count the number of cells that contain a specific text, you can use the COUNTIF function. For example, if you want to count the number of cells in range A1:A10 that contain the word “Excel”, you can use the following formula:
=COUNTIF(A1:A10, "Excel")
  1. Counting cells that do not meet a condition: You can use the COUNTIF function to count cells that do not meet a certain condition. For example, if you want to count the number of cells in range A1:A10 that do not contain the number 5, you can use the following formula:
=COUNTIF(A1:A10, "<>5")

Remember, the COUNTIF function is case-insensitive, so it does not distinguish between uppercase and lowercase text1.

SUMIF



Comments

Anonymous said…
Nice word brother. Keep possting
July 5, 2024 at 6:12 AM
Post a Comment

Popular posts from this blog

CARE AND SAFETY OF ICT TOOLS S.1

By AndTech-ug -
Image
QN1. Suggest safety measures for ICT tools in your school? 2. Identify the ICT tools that cane be found in the computer lab and state their uses? Care and safety of ICTs    1. Use strong password to ensure only authorized users can access ICT tools.   2. Make sure all software and hardware are regularly updated .   3. Use Antivirus Softwares to detect and remeove malware   4. Encrypt sensitive data stored on ICT tools to prevent unauthorized access in case of theft .   5. Always perform regular data backups to prevent data loss in case of system failures.   6. Use monitoring tools to track ICT usage and detect any suspicious activities.   7. Secure ICT equipment and infrastructure in locked rooms to prevent unauthorized access or tampering.  8. Keep dust away using dust blower, mopping the ICT Room.  9. have your windows burglar proofed    COMPUTER LABORATORY   A computer lab is a designate...
Read more

Data Processing cycle S.1

By AndTech-ug -
Image
The ccycle from when data is input into a computer upto when it is out put as information is called Data processing cycle. The data processing cycle cycle undergoes 4 stages 1. input 2. precessing 3. output 4. storage Data is first collected and entered in a computer as an INPUT by input devices like mouse, keyboard. Data is then sent to the central precessing unit (CPU) for processing and the result is information. (OUTPUT)
Read more

SYSTEM AND DATA SECURITY

By AndTech-ug -
Image
Computer Security Computer security, also known as cybersecurity, involves protecting computer systems and networks from theft, damage, and unauthorized access. This includes safeguarding hardware, software, and data from cyber threats like hacking, viruses, and other malicious activities. Data Security Data security focuses specifically on protecting data from unauthorized access, corruption, or theft. It encompasses a wide range of practices and technologies to ensure the confidentiality, integrity, and availability of data. Key practices in data security include: ●      Data Encryption: Encoding data so that only authorized parties can read it. ●      Access Controls: Restricting access to data to authorized users. ●      Data Masking: Hiding actual data with modified content to protect sensitive information. ●      Data Backup and Recovery: Regularly saving copies of data to prevent l...
Read more