Answer:
1. VLOOKUP function.
2. SUMIF function.
3. COUNT function.
4. IF function.
5. HLOOKUP function.
Explanation:
Microsoft Excel is a software application or program designed and developed by Microsoft Inc., for analyzing and visualizing spreadsheet documents. There are different types of functions used in Microsoft Excel to perform specific tasks and these includes;
1. VLOOKUP function: it's an Excel function that avails end users the ability to lookup data in a table organized vertically. Thus, it's typically used for searching values in a column.
2. SUMIF function: it is an Excel function to sum cells that meet criteria such as text, dates and numbers. This function can be used with the following logical operators; <, >, and =.
3. COUNT function: it's an Excel function to find the total number of entries in a column. For example, to count the number of entries in B1:B15; COUNT(B2:B15).
4. IF function: runs a logical test and returns one value for a TRUE result, and another for a FALSE result. For example, to fail scores that are below 40; IF (A1 < 40, "Fail", "Pass").
5. HLOOKUP function: it's an Excel function that avails end users the ability to lookup data in a table organized horizontally. Thus, it's typically used for searching values in a column.
Answer:troubleshooting the network when there are problems with the connectivity ||||||| improving network speed
Explanation:
Answer
of course, y u askin tho, im pretty sure every person who doesnt have a sight disability can see her abs as well
Explanation:
Answer:
The difference between the centralized and the distributed database architecture are as follows:
- The centralized database is the type of database which works on the single file in the database. Whereas, the distributed database works with the multiple files in the database.
- The centralized database refers to the proper planning and the helps in the decision making in the management system. Whereas, in the distributed database system the data are mainly distributed in the multiple files and the user can easily access the near by file in the database system.
- In the centralized database, if the database are get fail then the overall system come to halt. On the other hand in the distributed system, if the component get failed then the performance of the system are get reduced.
