The IF function has four entries.
Which of the following is not a valid formulation of the SUM function?
each of the above is valid
How would Excel evaluate the following formula? =OR(710yrs) in 2010:
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
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
(Round the answer to whole number)
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/
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)
Use the Brewery.xlsx file to answer the following question: Which state has the highest total profit?
Use the Brewery.xlsx file to answer the following question: Across all four locations, what percentage of total profit is made in MA?
The Create Relationships and Edit Relationships windows are the same, except the Create Relationships window has all the fields pre-populated.
Within the Relationship View, the number (1) denotes the table on the One side of the relationship.
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
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.
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”
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
Edits can be made in Reading View.
Which of the options can NOT be changed in the Visualizations toolbar?
To show a line graph and a bar chart what kind of visualization should you create?