##### Introduction To Information System Discussion Question

 Writing Tutor: None Selected Time limit: 1 Day

• 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.
Nov 24th, 2014

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.

Nov 24th, 2014

...
Nov 24th, 2014
...
Nov 24th, 2014
May 23rd, 2017
check_circle