Quiz 2 Fall 2008

# Quiz 2 Fall 2008 - Review Assessment: Quiz #2 Name Status...

This preview shows pages 1–3. Sign up to view the full content.

Review Assessment: Quiz #2 Name Quiz #2 Status Completed Score 42.5 out of 100 points Instructions Answer each question. There is only one correct answer for each question. Question 1 0 out of 2.5 points What is the maximum number of IF functions that can be nested in a formula? Selected Answer: 10 Correct Answer: 8 Question 2 0 out of 2.5 points What is the maximum number of conditions that can be programmed with nested if functions? Selected Answer: 7 Correct Answer: 9 Question 3 2.5 out of 2.5 points In general, if there are 5 conditions, how many IF functions would be used? Selected Answer: 4 Correct Answer: 4 Question 4 5 out of 5 points How many IF functions would be needed to compute the following equation WITHOUT the use of the AND/OR functions?

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Selected Answer: 3 Correct Answer: 3 Question 5 0 out of 5 points What would be the result of the following AND function when the value in cell J1 is -1: =AND(J1<0,J1>=-0.5) Selected Answer: True Correct Answer: False Feedback: Both conditions have to be satisfied for the AND function to have a True result. Question
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 06/27/2010 for the course RWS 305 taught by Professor None during the Fall '07 term at SD State.

### Page1 / 6

Quiz 2 Fall 2008 - Review Assessment: Quiz #2 Name Status...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online