![hjoe523](/avatars/44572.jpg)
hjoe523
17.06.2021 •
Computers and Technology
Q9. Complete the table with the name of the functions
1. Excel function to lookup data in a table organized
Vertically.
2. Is a function to sum cells that meet criteria.
3. Function to find the total number of entries in a
Column.
4. Runs a logical test and returns one value for a TRUE result, and another for a FALSE result
5. Excel function to lookup data in a table organized
Horizontally.
Solved
Show answers
More tips
- H Health and Medicine Liver Cleansing - Rejuvenation for the Body?...
- L Leisure and Entertainment Scrapbooking: What is it and Why is it Becoming More Popular?...
- H Horoscopes, Magic, Divination How to Cast a Love Spell on a Guy? Guide for Guys...
- F Family and Home How to Sew Curtain Tapes: Best Tips from Professionals...
- S Style and Beauty How are artificial nails removed?...
- S Style and Beauty How to Make Your Lips Fuller? Ideas and Tips for Beautiful Lips...
- F Food and Cooking The Disease That Haunted Abraham Lincoln...
- C Computers and Internet How to Get Rid of Windows Genuine Check?...
- H Health and Medicine How to perform artificial respiration?...
- S Style and Beauty Tricks and Tips: How to Get Rid of Freckles...
Answers on questions: Computers and Technology
- C Computers and Technology What are the two parts of a connector? a. the pin and the cable b. the plug and the jack c. the xlr and the rca d. the cylinder and the usb...
- C Computers and Technology 3 importance of excel...
- P Physics Apulley is used to lift a heavy mass from the floor to the platform. the ima of the system is 5 and the ama is 2.5. what is the efficiency of the system?...
- H History Relationship between the polis and monarchy, aristocracy,oligarchy,tyrants, and democracy...
- M Mathematics Put the following equation in slope intercept form. 10x - 5y = -20 is the correct answer y = 2x + 4?...
- B Biology Which of the following is true about salmonella bacteria...
- M Mathematics Morse code consists of 2 symbols dot and dash. if we use a set of 6 to represent any character or digit the total number that can be represented with that condition...
- M Mathematics Choose the correct classification of 5x + 2. third degree polynomial fourth degree trinomial first degree binomial sixth degree polynomial...
- B Biology Suppose that a small mainland tortoise and a large island tortoise are placed in the same pen at a zoo. which tortoise will be more poikilothermic, the small or large...
- M Mathematics Xz is a common external tangent to circles w and y. what is the distance between the two centers of the circles? round to the nearest hundredth....
Ответ:
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.
Ответ: