Excel Level 2 Final

&

it joins two or more text strings in a single string

asterisk

it represents any number of characters ex ex* excel example exit

How should an airline company allocate its advertising budget between different advertising formats? Target cell

maximize profit

If a city has only one airport, where should it be located? constraints

none

What do you need to include when you are entering text into your formula?

quotes

Question mark

represents one single character

If a city has only one airport, where should it be located? Changing Cell

the longitude and latitude

If the cell B2 is 60, what will this IF function give you as a result? =IF (B2>55, ''yes'', ''no'')

yes

You forecasted Quarter 1 sales to be 1 million using the centered moving averages . Using the seasonal index below, this Quarter 1 . 80 Quarter 2 .90 Quarter 3 1.10 Quarter 4. 1.20

0.8 million

You are identifying a linear relationship between Arrival delay time in minutes (Y) and Airtime in minute (X). Your regression result is expressed as Y=1+0.7X The slope of the equation of this model can be interpreted as :

1 more minute in airtime increases 0.7 minute increase in arrival delay

The seasonal index of 1.20 for Quarter 4 sales indicates that your Quarter 4 sales were

20% higher than average sales.

You are asked to find a distance between two cities. Suppose cells C10:J17 are selected and named "distances". You try the formula in D26 as shown in the picture. What result will you get?

2052

The picture shows the distributions of three datasets. They all follow a normal distribution. The purple line shows data 1 ;. The pink line data 2. The orange line the data 3. (1 high/ thin 2 is aveage and 3 in thin like a pancake)

3

What is the mode of the following numbers? 1, 3, 4, 4, 5, 5, 5, 5, 6, 10

5

Which of the following is an operator for inserting a not equal to condition in an IFS, COUNTIFS or SUMIFS function?

<>

suppose cells B2:D3 are selected and named "lookup". The formula =HLOOKUP(B8, lookup, 2, False) is created in C8. If C8 is dragged through C11, what is the formula in C9?

=HLOOKUP(B9, lookup, 2, True)

Which is the best formula to return just the 6 characters on the left-hand side of the text in cell A1?

=LEFT(A1,5)

Suppose cells H11:I15 are selected and named "Lookup2". You want to obtain the product's price based on a product ID. What is the correct formula in I19 to retrieve the price for the product in H19?

=VLOOKUP(H19, Lookup2, 2, FALSE)

How should an airline company allocate its advertising budget between different advertising formats? Changing Cells

Amount spends on ads

Which of the following is an example of time series problem? A. Estimating the quantity demanded for a product in the next three months B. Estimating the sales for the next four quarters for a food company

Both A and B

(True/False) You can select any number of cells for the Set Objective variable.

False

Here is a scenario, you are running a grocery store, and you want to predict the sales of canned tomatoes. For 12 straight weeks, you have observed the sales (in the number of cans) of canned tomatoes. You hypothesize that the the following factors are influencing the sales of canned tomatoes: Notice on cart? : was a promotional notice for canned tomatoes placed on the shopping carts? 2 cents off? or 1 cent off? : was a price reduction (none, 1 or 2 cents off) given? Coupon? : was a coupon for canned tomatoes given to each customer Based on the p-values, which of the following factors are important in predicting the sales of canned tomatoes? (select multiple factors if applicable) Knowledge check in 5 question 2

Having notice on cart Having 2 cent off on price

Based on the results above, having a 2 cents off on the price can predict which of the followings?

Increase in sales of about 13 canned tomatoes

Based on the results above, having a notice on the carts can predict which of the followings?

Increase in sales of about 20 canned tomatoes

If a positively skewed distribution has a median of 10, which of the following statement is true?

Mean is GREATER than 10

Which of the measures are describing the central tendency of data?

Mean, Median, and Mode

If a city has only one airport, where should it be located? Target Cell

Min total distance

Which is the easiest method to assign a name to a cell or range of cells?

Select the cell(s) and then type the name in the Name Box (to the left of the formula bar)

What three elements do you need to identify before running Excel Solver?

Target cell, changing cells, and constraints

""

This sign matches blank cells

Under what circumstances should we be cautious about using the mean as a measure of central tendency?

When data is positively or negatively skewed.

Based on the results above, which of the following statement is correct about R square?

Your regression explains 88.7 percent of the variation in the sales of canned tomatoes

A linear trend equation was used to forecast values of Y based on the assumption that

a constant value Y changes over time

In time series analysis, you use moving averages in order to

de-seasonalize (smooth out) the data

How should an airline company allocate its advertising budget between different advertising formats? constraints

dont go over budget