WSP-Excel Crash Course Exam
Questions & Answers10
nstructions: This question uses the fact pattern on tab Q51-58 in the Exam Workbook(opens in a
new tab). For the purposes of questions 51-58 do NOT remove duplicates.
How many homes in Philadelphia were at least 2000 square feet or more and had at least 3
bedrooms? Please use whole numbers. Do not use commas. For example, if the answer is
5,000.46, your answer should be 5000. - ANSWERS-86
Instructions: This question uses the fact pattern on tab Q51-58 in the Exam Workbook(opens in
a new tab). For the purposes of questions 51-58 do NOT remove duplicates.
How many homes had 30 or fewer Days on Market and cost at least $200 / square foot or
more? Please use whole numbers. Do not use commas. For example, if the answer is 5,000.46,
your answer should be 5000. - ANSWERS-77
Instructions: This question uses the fact pattern on tab Q51-58 in the Exam Workbook(opens in
a new tab). For the purposes of questions 51-58 do NOT remove duplicates.
Write a formula referencing cell D7 that outputs Upper Providence if the city is Wallingford,
Media, or Rose Valley, or will output the name of the current city if the city name is not one of
these three. Please write the name of the formula starting with the equal sign. Please hardcode
the names of these cities, in this order, in the formula to make sure your answer is read
correctly. Additionally, please use only the IF and OR functions when creating this formula. -
ANSWERS-=IF(OR(D7="Wallingford",D7="Media",D7="Rose Valley"),"Upper Providence",D7)
When you are in the Format Cells dialog (Ctrl 1):
, What is the keyboard shortcut for moving across tabs (Number, Alignment, Font Border, Fill,
Protection)?
How do you move counter clockwise across form elements?
How do you select a checkbox (put a checkbox next to it) - ANSWERS-1) Ctrl Tab OR Ctrl
PgUp/Ctrl PgDown, 2) Shift Tab 3) Spacebar
Instructions: Enter any keys that must be pressed together with a "+" between them; for
example, the shortcut for 'Copy' should be input as Ctrl+C, while the shortcut for 'Open file' is
input Alt f o.
What is a shortcut to clear the comments of the cell only. Note: there may be more than one
answer. Please input only one answer - ANSWERS-Alt h e a
Instructions: See question 7. Your answer for this question should be rounded to the nearest 1
decimal, comma separating 000s, NOT written in currency format. So if the answer is
$10,500.658, you would input 10,500.7.
In the previous question, you determined the total of Amy's sales over the analysis period. What
was her total profit? - ANSWERS-255,548.1
During the three-month period of January through March, what was the quantity of item 23
sold while Fred Rubble was the Manager on duty? - ANSWERS-784
During the month of May, how many postal codes bought more than 700 products by quantity?
- ANSWERS-4
Over the entire analysis period, which sales rep gave the most discounts by dollar amount?
Enter the name as: Firstname Lastname. - ANSWERS-Oliver Winslow
Instructions: See question 7.
Questions & Answers10
nstructions: This question uses the fact pattern on tab Q51-58 in the Exam Workbook(opens in a
new tab). For the purposes of questions 51-58 do NOT remove duplicates.
How many homes in Philadelphia were at least 2000 square feet or more and had at least 3
bedrooms? Please use whole numbers. Do not use commas. For example, if the answer is
5,000.46, your answer should be 5000. - ANSWERS-86
Instructions: This question uses the fact pattern on tab Q51-58 in the Exam Workbook(opens in
a new tab). For the purposes of questions 51-58 do NOT remove duplicates.
How many homes had 30 or fewer Days on Market and cost at least $200 / square foot or
more? Please use whole numbers. Do not use commas. For example, if the answer is 5,000.46,
your answer should be 5000. - ANSWERS-77
Instructions: This question uses the fact pattern on tab Q51-58 in the Exam Workbook(opens in
a new tab). For the purposes of questions 51-58 do NOT remove duplicates.
Write a formula referencing cell D7 that outputs Upper Providence if the city is Wallingford,
Media, or Rose Valley, or will output the name of the current city if the city name is not one of
these three. Please write the name of the formula starting with the equal sign. Please hardcode
the names of these cities, in this order, in the formula to make sure your answer is read
correctly. Additionally, please use only the IF and OR functions when creating this formula. -
ANSWERS-=IF(OR(D7="Wallingford",D7="Media",D7="Rose Valley"),"Upper Providence",D7)
When you are in the Format Cells dialog (Ctrl 1):
, What is the keyboard shortcut for moving across tabs (Number, Alignment, Font Border, Fill,
Protection)?
How do you move counter clockwise across form elements?
How do you select a checkbox (put a checkbox next to it) - ANSWERS-1) Ctrl Tab OR Ctrl
PgUp/Ctrl PgDown, 2) Shift Tab 3) Spacebar
Instructions: Enter any keys that must be pressed together with a "+" between them; for
example, the shortcut for 'Copy' should be input as Ctrl+C, while the shortcut for 'Open file' is
input Alt f o.
What is a shortcut to clear the comments of the cell only. Note: there may be more than one
answer. Please input only one answer - ANSWERS-Alt h e a
Instructions: See question 7. Your answer for this question should be rounded to the nearest 1
decimal, comma separating 000s, NOT written in currency format. So if the answer is
$10,500.658, you would input 10,500.7.
In the previous question, you determined the total of Amy's sales over the analysis period. What
was her total profit? - ANSWERS-255,548.1
During the three-month period of January through March, what was the quantity of item 23
sold while Fred Rubble was the Manager on duty? - ANSWERS-784
During the month of May, how many postal codes bought more than 700 products by quantity?
- ANSWERS-4
Over the entire analysis period, which sales rep gave the most discounts by dollar amount?
Enter the name as: Firstname Lastname. - ANSWERS-Oliver Winslow
Instructions: See question 7.
