Excel

Question 1

MONTH

if you want the 1 in 1/16/2014 and turn it to a month name, and that format was in A10, then you would want to use this formula

Answer 1

=TEXT(A10,”mmmm”)

Question 2

Division

Answer 2

=A2/B2

=Cell/cell

Question 3

ADDITION

Answer 3

=Sum(A1,A2)
for multiple cells =Sum(A1,A4)
=SUM(CELL,CELL)

Question 4

Max

Answer 4

=max(A1:A24)

Question 5

MINIMUM

Answer 5

=min(A1:A2

Question 6

Count

count the number of rows. This one counts numbers and letters

Answer 6

=countA(A1:A8)

Question 7

COUNT
(this one only counts numbers)

Answer 7

=count(A1:A2)

Question 8

AVERAGE

Answer 8

=Average(D3:D7)

Question 9

MULTIPLAY AND DIVIDE

Answer 9

=A2*B2/C2

Question 10

IF

Grandpa John gives his kids Christmas gifts, but only if they are younger than 18. Column B are the kids

Answer 10

MODEL
=IF(logical test,[value if true],[value if false])

=IF(B2>18,”no”,”yes”)

=IF(the column you want the answer for PACMANED, “anawer”,”answer”)

Question 11

NESTED IF

If A2 was a student name and we had to give a grade of A,B,C,D,or F, and you needed 89 or above for an A, 79 or more for a B, 69 for C, 59 for a D or an F

Answer 11

=IF(A2>89,”A”,IF(A2>79,”B”,IF(A2>69,”C”,IF(A2>59,”D”,”F”)

Question 12

CONCATENATE

Answer 12

=CONCATENATE(B2,” “,c2)
=CONCATENATE(The first word, telling to put the 2 words together, The last of the second word)

Question 13

NESTING

Answer 13

Using a function as one of the arguments in a formula that uses a function

Question 14

VLookup Formula

Answer 14

=vlookup(lookup_value, table_array, col_index_num, [range_Lookup])

Question 15

VLookup Arguments

Answer 15

lookup_value – what we are looking for – this could be a text, number, or a single cell reference

table_array/table range – the range in which we will lookup for our value and its corresponding result. Please note that the range must start from the column which contains the value, and should contain the column in which we have our result.

col_index_num – What is the column number from which we want to return the result? The number should be relative to the first column in the selected range in table_array.

[range_lookup] – Which range lookup method should be used. 0 is the default, so you should always type 0 (or FALSE), which means “Exact Match” – Go to the exact match to the value I’m looking for. 1 (or True) stands for “Approximate match”, and it should not be used on most cases so we’ll skip it for now.

Question 16

VLOOKUP Simple Hugh explanation

Answer 16

(What I am lookup for, Somewhere within the range of these cells, within the number of columns i selected or what is the last column I selected, is it precise [False or 0] or approximate [true or 1]

Question 17

SumIF

Answer 17

=SUMIF(B2:B25,”>5”)

=SumIF(Cell:Cell,”answer”)

=SUMIF(range, criteria, [sum_range])

Question 18

AUTOFILLING/FILL HANDLE

Answer 18

Highlight

ASCENDING with numbers
type in two or more numbers in separate cells so Excel gets an idea of the pattern that u want to drag the bottom right and the it will ascend
to copy just insert data in one cell then drag

Question 19

SumIf Example

I want to only find the total sales in the New YOrk area, and the cities are in column E. Some of the cities in column E are not New York, and they are in the range of E2 to E20. And the city’s total sales are in the G column which the range is G2 to G20. what is my sumIf Syntax

Answer 19

=SumIf(E2:E20,”New York”,G2:G20)