BUSINESS ANALYSIS FINAL EXAM REVIEW QUESTIONS AND ANSWERS

BUSINESS ANALYSIS FINAL EXAM REVIEW QUESTIONS AND ANSWERS
c) 3 - CORRECT ANSWER✅✅In a nested if with 4 outcomes possible, how many ifs should be used?



a) 5

b) 4

c) 3

d) 2



b) If Statement - CORRECT ANSWER✅✅Which is not a part of a database function?



a) Calculating Field

b) If Statement

c) Database

d) Criteria Range



c) Logical Check - CORRECT ANSWER✅✅Which is not found in a vlookup statement?



a) Lookup Field

b) Return Column

c) Logical Check

d) Lookup Table



c) Lookup Table - CORRECT ANSWER✅✅What is not found in an IF statement?



a) True Outcome

b) False Outcome

c) Lookup Table

d) Logical Check

, c) Conditional Formatting - CORRECT ANSWER✅✅What type of formatting is complete based on a
certain criteria/conditions being met?



a) Color Formatting

b) Bold Formatting

c) Conditional Formatting

d) Criteria Formatting



a) Northwest Corner - CORRECT ANSWER✅✅Which cell in a 1 variable data table is left blank?



a) Northwest Corner

b) Southwest Corner

c) Northeast Corner

d) Southeast Corner



a) Northwest Corner - CORRECT ANSWER✅✅In a 2 variable data table, which cell location is the
formula found?



a) Northwest Corner

b) Southwest Corner

c) Northeast Corner

d) Southeast Corner



c) A5 - CORRECT ANSWER✅✅If told to start a 1 variable data table in cell A5, which cell is left blank?



a) B6

b) B5

c) A5