AD 100
Test 1
QUESTION 1
The IF function has four entries.
True
False
0.9 points
QUESTION 2
Which of the following is not a valid formulation of the SUM function?
=SUM(3,A2,D5,FALSE)
=SUM(A10:A20, A10,A10)
=SUM(A1:D1,B1:B5,6)
=SUM(6)
each of the above is valid
0.9 points
QUESTION 3
How would Excel evaluate the following formula? =OR(710yrs) in 2010:
https://home.treasury.gov/resource-center/data-chart-center/interest-rates/TextView?type=daily_treasury_real_long_term&field_tdr_date_value=all
Under the Resource Center, select “Daily Treasury Real Long-Term Rate Averages”
Select type of Interest Rate Data: Daily Treasury Real Long-Term Rates
Select Time Period: 2010
1.72
1.73
1.74
1.75
1.76
0.9 points
QUESTION 2
Using the following URL of http://finance.yahoo.com/quote/GOOG/history, determine the average volume for shares of Google in 2020. Use the following parameters:
Time Period: 12/31/2019- 12/30/2020
Show: Historical Prices
Frequency: Weekly
(Round the answer to whole number)
( )
0.9 points
QUESTION 3
Using the following URL, what was the average population of the countries ranked 51-100 in population size in 1900 (round to the nearest 1000): https://www.bu.edu/adminsc/2021/03/18/list-of-countries-by-population-in-1900/
( )
1.4 points
QUESTION 4
Use the Brewery.xlsx file to answer the following question: What percentage of profit does Lager account for among the three types of beer? (rounded to 2 decimals)
26.13%
52.00%
25.68%
14.25%
13.76%
0.9 points
QUESTION 5
Use the Brewery.xlsx file to answer the following question: Which state has the highest total profit?
CT
MA
TX
PA
CA
0.9 points
QUESTION 6
Use the Brewery.xlsx file to answer the following question: Across all four locations, what percentage of total profit is made in MA?
75.69%
81.00%
45.26%
74.56%
84.29%
Test 4
QUESTION 1
The Create Relationships and Edit Relationships windows are the same, except the Create Relationships window has all the fields pre-populated.
True
False
0.9 points
QUESTION 2
Within the Relationship View, the number (1) denotes the table on the One side of the relationship.
True
False
0.9 points
QUESTION 3
Which of the following options for data load is off by default?
Import relationships from data sources
Update relationships when refreshing queries
Autodetect relationships after data is loaded
Allow data preview to download in the background
1.4 points
QUESTION 4
Many-to-One cardinality specifies that there is a single record in one table for many records that map in the table that is joined.
True
False
0.9 points
QUESTION 5
Which is an example of a Parent-Child relationship?
“A list of transactions, each of which takes place at a specific time and place”
“A company with multiple offices, which in turn have multiple branches”
“A list of raw materials, each of which are used to assemble various goods”
“A list of services, each of which are available from various companies”
0.9 points
QUESTION 6
Which of the following are most likely to require a many to many relationship?
A list of parents and a list of their children
A list of dates and a list of historical events
A list of cities and a list of GPS coordinates
A list of companies and a list of brands they produce
1.4 points
QUESTION 7
Edits can be made in Reading View.
True
False
0.9 points
QUESTION 8
Which of the options can NOT be changed in the Visualizations toolbar?
Axis Title
Calculated Column
Graph Color
Data Labels
0.9 points
QUESTION 9
To show a line graph and a bar chart what kind of visualization should you create?
Scatter Chart
Matrix Visualization
Combination Chart
Slicer