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.

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

Need Help With Your Assignment Projects?

X
× How can I help you?