D. Which function will you use in the given situations?
1. To add the numbers in a given range of cells.
2. To calculate the average value.
Auto.co.
ALMOSA
e...
3. To count the number of cells with values in it.
4. To show the current date.
5. To calculate the number of characters in a text string.
Answers
Answer:
If we wish to find out the average price from January 8 to 12, we can use the AVERAGE function along with the COUNT and OFFSET functions.
The formula to use will be:
The OFFSET function helped in creating dynamic rectangular ranges. By giving the starting reference B2, we specified the rows and columns the final range would include.
OFFSET will now return a range originating from the last entry in column B. Now the COUNT function is used for all of column B to get the required row offset. It counts only numeric values, so the headings, if any, are automatically ignored.
There are 12 numerical values in column B, so offset would resolve to OFFSET(B2,12,0,-5). With these values, OFFSET starts at B2, offsets 12 rows to B13, then uses -5 to extend the rectangular range up “backward” five rows to create the range B9:B12.
Finally, OFFSET returns the range B9:B12 to the AVERAGE function, which computes the average of values in that range.
Things to rememberIf we wish to count logical values, then we should use the COUNTA function.The function belongs to the COUNT function family. There are five variants of COUNT functions: COUNT, COUNTA, COUNTBLANK, COUNTIF, and COUNTIFS.We need to use the COUNTIF function or COUNTIFS function if we want to count only numbers that meet specific criteria.If we wish to count based on certain criteria, then we should use COUNTIF.The COUNT function doesn’t count logical values TRUE or FALSE.
Click here to download the sample Excel file
Additional resources
Thanks for reading CFI’s guide to important Excel functions! By taking the time to learn and master these functions, you’ll significantly speed up your financial analysis. To learn more, check out these additional CFI resourc