##### Introduction To Information System Discussion Question

*label*Writing

*account_circle*Unassigned

*schedule*1 Day

*account_balance_wallet*$5

- Last week we used the built-in functions sum, min, max, and average. Excel has over 300 built-in functions. Choose 3 other functions and describe what they do and how you could use them.

**The COUNT Function**

The COUNT function determines how many number values are contained
within its arguments. If an argument is a cell or a range of cells,
COUNT identifies how many of the values in that range are numeric. The
syntax for COUNT is =COUNT(arguments). The arguments that COUNT takes
are cell references, constants or some combination of the two. Like the
other functions discussed here, COUNT ignores text, blank cells (not
zeros), error values, and logical values.

If B2 contains the number 5, B3 the logical value TRUE, B4 the number 74, and B5 the text NO, then =COUNT(B2:B5) will return the value 2. This is because 2 cells contain number values.

As noted, any of these functions can take other functions as arguments. So the expression =(SUM(C2:C4,AVERAGE(B3,G5)) will find the average of the values in cells B3 and G5, and will add this to the sum of the values in cells C2, C3, and C4.

**CONCATENATE**

A fancy word for combining data in 2 (or more) different
cells into one cell. This can be done with the Concatenate excel formula
or it can be done by simply putting the & symbol
in between the two cells. If I have “Steve” in cell A1 and “Quatrani”
in cell B1 I could put this formula: =A1&” “&B1 and it would
give me “Steve Quatrani”. (The “ “ puts a space in between what you are combining with the &). I can use =concatenate(A1, “ “, B1) and it will give me the same thing: “Steve Quatrani”

**VLOOKUP**

Formula: =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

By far my most used formula. The official description of
what it does: “Looks for a value in the leftmost column of a table, and
then returns a value in the same row from a column you specify…”.
Basically, you define a value (the lookup_value) for the formula to
look for. It looks for this value in the leftmost column of a table (the
table_array).

Hope this helps.

Please best my answer if helpful. Thanks :)

*check_circle*

*check_circle*

*check_circle*

Secure Information

Content will be erased after question is completed.

*check_circle*