🌍 All Study Guides 📊 Dashboard 📰 Blog 💡 About

Coursera Microsoft Power BI Data Analyst • STUDY MODE

Practice Quiz

QUESTION 1 OF 28

In your worksheet, you created formulas in column C that included the TRIM function and cell references from column B as arguments. The entries in column B contained a lot of unnecessary spaces though the entries contain only a single space between each word. What did the formulas remove?

The spaces before, after, and in the entries.

The spaces before and after the entries.Correct Answer

The spaces before the entries only.

QUESTION 2 OF 28

True or False: You created formulas in cells K2 to K200 to combine the content from column G and column l. You were then able to delete columns G and I immediately, as they were no longer required.

True

FalseCorrect Answer

QUESTION 3 OF 28

In the CONCAT formula in K2, you added a third argument to indicate that the two words needed space between them. What character did you input on either side of the space in the formula?

A double quote.Correct Answer

A parenthesis.

An exclamation mark.

QUESTION 4 OF 28

Jamie wants to perform a time analysis of Adventure Works’ sales data. However, a time analysis isn’t possible because of how the date is currently formatted. What error might have caused this formatting issue?

The dates are typed with forward slashes.

The dates are typed as text.Correct Answer

 The dates are typed as numbers.

QUESTION 5 OF 28

True or False: An Excel spreadsheet contains country names split over multiple columns. Cell A2 contains the word United. Cell B2 contains the word States. When executed, the following formula generates the result United States:

TrueCorrect Answer

False

QUESTION 6 OF 28

One of the employees at Adventure Works has made some typing errors in a spreadsheet. A text entry in cell contains the following text:

LOWER

PROPERCorrect Answer

UPPER

QUESTION 7 OF 28

In the Adventure Works Reseller spreadsheet, the reseller names are listed in column D. Cell D2 contains the following text, which is left-aligned in the cell with no redundant spaces:

East

Shop

BikeCorrect Answer

QUESTION 8 OF 28

Cell A2 contains the following entry:

aCE6548

Ace6548.

ACEE6548Correct Answer

QUESTION 9 OF 28

Cell E4 contains the city name North Miami Beach. What result would the following formula generate in your worksheet?

MiamiCorrect Answer

Beach

North

QUESTION 10 OF 28

In the spreadsheet, you were asked to create a formula using the MONTH function. The formula was

2023

7Correct Answer

QUESTION 11 OF 28

True or False: If you were to use a TODAY function in a formula in cell B1, the result would change each time the formulas in the worksheet recalculate.

True

FalseCorrect Answer

QUESTION 12 OF 28

You created a formula using the NETWORKDAYS function. You added two arguments for the function, which were the start date, and the end date. What data did the formula automatically exclude from the result?

Any weekend dateCorrect Answer

Any holiday date

Any weekend and holiday date

QUESTION 13 OF 28

The date 05/30/23 has a serial number of 45076. What serial number will the date 05/31/23 have?

45077Correct Answer

45078

45079

QUESTION 14 OF 28

How many arguments does the TODAY function require?

Two

NoneCorrect Answer

One

QUESTION 15 OF 28

You have created a formula in your spreadsheet using the TODAY function. What must you include after the word TODAY in your formula?

An opening and closing parenthesis only.Correct Answer

An opening and closing parenthesis and one space.

An opening and closing parenthesis and two spaces.

QUESTION 16 OF 28

You have created a formula in your spreadsheet using the NOW function. By default, what will the formula display in its result?

The time only.

The date only.

The date and time.Correct Answer

QUESTION 17 OF 28

You are working on a spreadsheet that contains three columns called Day, Month and Year. In another column, you would like to combine these entries so that it shows a complete date. Which function should you use to achieve this?

DATEDIF

DATECorrect Answer

CONCAT

QUESTION 18 OF 28

True or False: You can use the NETWORKDAYS.INTL function to calculate the number of working days between two dates while excluding national holidays and weekends because it has built-in knowledge of public holidays.

True

FalseCorrect Answer

QUESTION 19 OF 28

You have entered the following three dates in your spreadsheet in the month, day and year format. Which of these dates has the largest serial number?

01/30/2023

09/10/2025Correct Answer

04/15/2020

QUESTION 20 OF 28

You created an IF function formula in cell H7 that was designed to display the correct percentage discount if the amount in G7 was greater than $10,000. In what format did you enter the percentage in the Value if true section of the formula?

“10%”

10%Correct Answer

QUESTION 21 OF 28

True or False: When you created a formula in cell L7 to check and display the delivery charge for the region, you used IFS rather than IF because you needed to run more than two tests but also create the most concise formula.

TrueCorrect Answer

False

QUESTION 22 OF 28

You created a formula in H2 which used SUMIF to obtain a total for Region A entries only. What did you need to specify as the first argument in your formula?

The criteria rangeCorrect Answer

The criteria entry

The SUM range

QUESTION 23 OF 28

You have created a nested IF formula using three IF functions. How many closing parentheses do you need at the end of the formula?

ThreeCorrect Answer

One

Two

QUESTION 24 OF 28

Cell A2 of your worksheet contains a value of 250. What is the result of the following formula when added to your worksheet?

10%

5%Correct Answer

QUESTION 25 OF 28

You create a formula using the IFS function to test for a series of alphabet characters. When typing the criteria to test for, what symbols should you add around each text character?

Parentheses.

Single quotation marks.

Double quotation marks.Correct Answer

QUESTION 26 OF 28

In your worksheet, cell A2 contains a value of 100. Cell B2 contains a value of 200, and C2 contains a value of 400. What is the result of the following formula when added to your worksheet?

Result 2

Result 1Correct Answer

Result 3

QUESTION 27 OF 28

You create the following formula using the AVERAGEIF function: 

The average range.

The criteria.

The criteria range.Correct Answer

QUESTION 28 OF 28

In your worksheet, cell A2 contains the value 100. Cell B2 contains a value of 200, and C2 contains a value of 400. What is the result of the following formula when added to your worksheet?

Rate 1

Rate 2

Rate 3Correct Answer

Ready to test your recall?

In your worksheet, you created formulas in column C that included the TRIM function and cell references from column B as arguments. The entries in column B contained a lot of unnecessary spaces though the entries contain only a single space between each word. What did the formulas remove?

The spaces before, after, and in the entries.

The spaces before and after the entries.

The spaces before the entries only.

How confident are you in this answer?

Practice Quiz

In your worksheet, you created formulas in column C that included the TRIM function and cell references from column B as arguments. The entries in column B contained a lot of unnecessary spaces though the entries contain only a single space between each word. What did the formulas remove?

True or False: You created formulas in cells K2 to K200 to combine the content from column G and column l. You were then able to delete columns G and I immediately, as they were no longer required.

In the CONCAT formula in K2, you added a third argument to indicate that the two words needed space between them. What character did you input on either side of the space in the formula?

Jamie wants to perform a time analysis of Adventure Works’ sales data. However, a time analysis isn’t possible because of how the date is currently formatted. What error might have caused this formatting issue?

True or False: An Excel spreadsheet contains country names split over multiple columns. Cell A2 contains the word United. Cell B2 contains the word States. When executed, the following formula generates the result United States:

One of the employees at Adventure Works has made some typing errors in a spreadsheet. A text entry in cell contains the following text:

In the Adventure Works Reseller spreadsheet, the reseller names are listed in column D. Cell D2 contains the following text, which is left-aligned in the cell with no redundant spaces:

Cell A2 contains the following entry:

Cell E4 contains the city name North Miami Beach. What result would the following formula generate in your worksheet?

In the spreadsheet, you were asked to create a formula using the MONTH function. The formula was

True or False: If you were to use a TODAY function in a formula in cell B1, the result would change each time the formulas in the worksheet recalculate.

You created a formula using the NETWORKDAYS function. You added two arguments for the function, which were the start date, and the end date. What data did the formula automatically exclude from the result?

The date 05/30/23 has a serial number of 45076. What serial number will the date 05/31/23 have?

How many arguments does the TODAY function require?

You have created a formula in your spreadsheet using the TODAY function. What must you include after the word TODAY in your formula?

You have created a formula in your spreadsheet using the NOW function. By default, what will the formula display in its result?

You are working on a spreadsheet that contains three columns called Day, Month and Year. In another column, you would like to combine these entries so that it shows a complete date. Which function should you use to achieve this?

True or False: You can use the NETWORKDAYS.INTL function to calculate the number of working days between two dates while excluding national holidays and weekends because it has built-in knowledge of public holidays.

You have entered the following three dates in your spreadsheet in the month, day and year format. Which of these dates has the largest serial number?

You created an IF function formula in cell H7 that was designed to display the correct percentage discount if the amount in G7 was greater than $10,000. In what format did you enter the percentage in the Value if true section of the formula?

True or False: When you created a formula in cell L7 to check and display the delivery charge for the region, you used IFS rather than IF because you needed to run more than two tests but also create the most concise formula.

You created a formula in H2 which used SUMIF to obtain a total for Region A entries only. What did you need to specify as the first argument in your formula?

You have created a nested IF formula using three IF functions. How many closing parentheses do you need at the end of the formula?

Cell A2 of your worksheet contains a value of 250. What is the result of the following formula when added to your worksheet?

You create a formula using the IFS function to test for a series of alphabet characters. When typing the criteria to test for, what symbols should you add around each text character?

In your worksheet, cell A2 contains a value of 100. Cell B2 contains a value of 200, and C2 contains a value of 400. What is the result of the following formula when added to your worksheet?

You create the following formula using the AVERAGEIF function:&nbsp;

In your worksheet, cell A2 contains the value 100. Cell B2 contains a value of 200, and C2 contains a value of 400. What is the result of the following formula when added to your worksheet?

Ready to test your recall?

You create the following formula using the AVERAGEIF function: