Info Systems Excel Portion

Question 1

IF Functions: = IF (logical _test, value_if_true, value_if_false)

Answer 1

Logical test: condition you want to evaluate
value if true: what excel should return if value is true
value if false: what excel should return if value is false

Question 2

Lookup: VLOOKUP (lookup_value, table_arrary, col_index_num, [range_lookup]

Answer 2

lookup value: value you want to search for in first column
table array: range of cells that contain the data you are looking for first column must include what you are searching for
col index num: column number in the table from which you want to retrieve results
range look up: “True”, approximate match, “False”, exact match

Question 3

Pivot tables

Answer 3

select data, insert, pivot table, select existing worksheet, sort based on logic

Question 4

Goal seek

Answer 4

data tab, what-if analysis, select goal seek, “set cell box” (select cell you want to achieve a target for), “to value box” (value you want cell to reach), “by changing cell box” (select cell that has variable you want to change)

Question 5

Explain deducting by 10%

Answer 5

To deduct 10% from a value, you multiply the original value by 90%

10% deduction means you are keeping 90% of the original score so multiple by 0.9