1/19/15 10:16 PMTest Canvas: In-Class Exercise 3
Page 1 of 7https://connect.ubc.ca/webapps/assessment/do/content/assessment?a…ontent_id=_2623861_1&assessmentType=Test&method=modifyAssessment
Go To Student View
Edit Mode is:
ON
•
2014W2-
COMM391-
201,
202,
&
203-
Introduction
to
Management
Information
Systems-
SAUNDERS
Tests, Surveys, and Pools Tests Test Canvas : In-Class Exercise 3
H
Test Canvas: In-Class Exercise 3
The Test Canvas allows you to add and edit questions, add Question Sets or Random Blocks, reorder questions, and review the test. More Help
You can edit, delete, or change the point values of test questions on this page. If necessary, test attempts will be regraded after you submit your changes.
Description
To test VLOOKUP
Instructions
Please complete In-Class Exercise 3 by Wednesday, January 14th at 11:59pm. You can have unlimited attempts until then. Only the LAST set of
SUBMITTED answers will count. Any attempts in progress, but not submitted, will NOT count.
Total
Questions
7
Total Points 10
Number of
Attempts
403
Select: All
All None
None Select by Type:
– Question Type –
Points Update and Regrade
Update and Regrade Hide Question Details
Hide Question Details
1. Multiple Choice: VLOOKUP: All of the statements are
true, EXCEPT:
Question
All of the statements are true, EXCEPT:
Answer
The VLOOKUP function searches the first column of a range of cells, and returns a value from any cell on any row within
the stated range. VLOOKUP starts with the first value in the first column, and works its way down until it finds a match.
The col_index_num argument in the VLOOKUP function has to be between 1 and the number of columns in the
table_array.
The range_lookup argument in the VLOOKUP function is an optional argument that can be filled with either TRUE or
FALSE. By default, this is set to FALSE.
2. Multiple Answer: Adanac Part A: The fictional country
of Adanac has a…
Question
?
?
Question Settings
Question Settings
Points: 1.42
Points: 1.43
1/19/15 10:16 PMTest Canvas: In-Class Exercise 3
The fictional country of
Adanac
has altogether 20 land border crossings, seaports, and airports for people and goods to get into the
country. These land border crossings, seaports, and airports are collectively called “ports of entry.” Each port of entry has its own
code (see column A in the Excel screenshot below). The code tells where the port of entry is located (in a specific region and in a
specific district within a region). To determine where a port of entry is located, one can use the available VLOOKUP tables (columns I
and J, as applicable).
For example, Casa Loma (code: 603) is a land border crossing located in the Southwest District of the Southern Region.
A screenshot of an Excel table detailing all 20 ports of entry in
Adanac
is displayed below.
Use the above information and screenshot to answer the following FIVE questions. The questions are INDEPENDENT of each other.
You are asked to classify each port of entry based on its region (North or South). To do so, you will have to complete column E using
a VLOOKUP function. Which of the following formulas
in cell E2
will produce a correct result?
There is AT LEAST ONE correct option, but you MUST SELECT ALL correct options.
Answer
=VLOOKUP(A2,$I$3:$J$4,2,TRUE)
=VLOOKUP(A2,$I$3:$J$4,1,TRUE)
=VLOOKUP(A2,$I$3:$J$4,2,FALSE)
=VLOOKUP(A2,$I$3:$J$4,1)
=VLOOKUP(A2,$I$3:$J$4,2)
(or nested IF). The rules remain the same: ports coded 200-499 are in the Northern Region, and those coded 500-999 are in the