Spreadsheet Functions

Question 1

Countif = function that returned the number of cells that match a specific value.

Answer 1

=countif(range, “value”)

=countif(A1,A17,”<100”)

Question 2

<+>

Answer 2

Left arrow means less right arrow means more.

Question 3

LEN Function if you know a specific length in a column and want to check.

Answer 3

=LEN(range)

One can use conditional format with Len to look for the value.

Question 4

Left function. Number of characters from the left.

Same as the right Function instead looks at the right.

Answer 4

=LEFT(range, number of characters)

=LEFT(A2,5) the five is the number of characters from the left.

Question 5

MID function it gives you the segment from the middle.

Answer 5

=MID(range, where the function should start add coma and how many characters one wants)
=MID(D2,4)

Question 6

Concatenate function function that joins together two or more strings.

Answer 6

=concatenate( item1,item2)

=concatenate( A2,B2)

Question 7

Trim function it removes leading and trailing repeated spaces.

Answer 7

=Trim( range)

Question 8

How many functions have I learned?

Answer 8

7
Countif= returns a specific value that match
Len= length counts the number of the text
Left= return the left number of characters.
Right= return the right number of characters.
Mid= return the middle
Concatenate= returns a combination of values.
Trim= it cleans white spaces.