QuiztudyPREMIUM
🌍 All Study Guides📊 Dashboard📰 Blog💡 About
Coursera Microsoft Power BI Data Analyst • STUDY MODE

Practice Quiz

QUESTION 1 OF 21

When you created the calculation in cell G4, you were able to use the double-click shortcut to Autofill copies of the formula into the cells underneath. What data did Excel use as a visual reference to determine when to stop copying the formula?

A
The block of information in row 201. 
B
The block of information in column F.Correct Answer
C
The block of information in column K.
QUESTION 2 OF 21

In cell H4 you created a formula that worked out the total shipping cost. Cell P1 contained the $5 per item shipping charge. Column F contained multiple rows of entries. Which of the following was the correct syntax for the formula to ensure that it copied correctly when you used the Autofill shortcut?

A
=$F$4*P1
B
=F4*P1
C
=F4*$P$1Correct Answer
QUESTION 3 OF 21

In cell J4, you created a formula with parentheses to set a new retail price by adding numbers together and working out a percentage increase. What result did you get for the calculation? 

A
$224.66
B
$333.24Correct Answer
C
$222.16
QUESTION 4 OF 21

You are creating a formula in a worksheet called Summary. This formula also includes a reference to cell H2 in a worksheet called Products. How will this reference appear in the formula?

A
ProductsH2
B
Products!H2Correct Answer
C
H2
QUESTION 5 OF 21

You are creating a calculation in your worksheet. You want Excel to subtract a figure held in C5 from a total held in H2 and then for the result to be divided by four. Which formula will calculate this correctly?

A
 =H2-C5/4
B
=(H2-C5)/4Correct Answer
C
=C5-H2/4
QUESTION 6 OF 21

A Microsoft Excel worksheet contains the following formula:

A
Addition
B
MultiplicationCorrect Answer
C
Division
QUESTION 7 OF 21

You are creating a formula in cell C2 in your worksheet. The calculation only needs to appear in cell C2. You have typed the following formulas: 

A
Parentheses
B
Dollar Signs
C
An Equals SignCorrect Answer
QUESTION 8 OF 21

Cell D2 of your worksheet contains the weekly sales total. Cell D7 contains the overall monthly sales. You need cell E2 to show what percentage the week one total is of the overall monthly total. You’ve already applied the percentage format to E2. Which of the following options is the correct syntax for the formula?

A
=D2/D7Correct Answer
B
=D7/D2
C
=D2/D7*100
QUESTION 9 OF 21

True or False: When Excel processes the following formula, it will first multiply cell A1 by cell C3 before it processes the addition.

A
True
B
FalseCorrect Answer
QUESTION 10 OF 21

You have created the following formula in your worksheet:

A
C6, E4, F6
B
D4, C6, E4
C
D4, E4, F6Correct Answer
QUESTION 11 OF 21

What mathematical sign does Excel process last when calculating the results of the following formula?

A
The plus sign.Correct Answer
B
The Division sign.
C
The Multiplication sign.
QUESTION 12 OF 21

Cell C34 in your worksheet is blank and cell C35 contains a formula. The cursor is on C36. If you use the AutoSum shortcut to add a SUM formula, which cell range does Excel automatically suggest as the argument for the function?

A
C34Correct Answer
B
C36
C
C35
QUESTION 13 OF 21

True or False: When you created the Total Revenue formula in C35, the results appeared as dollar amounts because the Accounting format had been applied to the cell in advance.

A
True
B
FalseCorrect Answer
QUESTION 14 OF 21

When you created the formula in C39 to count how many days there were in the month, what answer did the formula produce?

A
0
B
31
C
30Correct Answer
QUESTION 15 OF 21

You need to access the full range of functions available in Excel. Which ribbon do you need to select to access the full library of functions?

A
The Formula ribbon.Correct Answer
B
The Data ribbon.
C
The Home ribbon.
QUESTION 16 OF 21

You need to access the Insert function feature to create a function formula. What actions can you take to access this feature? Select all that apply:

A
Use the Insert function choice on the Formulas ribbon.Correct Answer
B
Use the FX symbol to the left of the Formula bar.Correct Answer
C
Use the Name box beside the Formula bar.
QUESTION 17 OF 21

Which of the following items are part of a function formula? Select all that apply:

A
ParenthesesCorrect Answer
B
An equals signCorrect Answer
C
Periods
D
The function nameCorrect Answer
QUESTION 18 OF 21

You need to know how many cells in a cell range contain entries. The cells with entries contain a mixture of text and numeric entries. Which function should you use in this situation? 

A
COUNTACorrect Answer
B
COUNT
C
COUNTBLANK
QUESTION 19 OF 21

Three cells in your worksheet contain numbers. Cell D7 holds the number 10, D8 contains the number 20, and D9 contains the number 30. What is the result of the following formula when added to cell D10? 

A
=MAX(D7:D8) 
B
10
C
30
D
20Correct Answer
QUESTION 20 OF 21

Cells B1 to B3 in your worksheet contain numbers. Cell B4 has a piece of text. You add an AVERAGE function formula to cell B5, which works out the average of cells B1 to B4. How will Excel work out the average?

A
Total the numbers in B1 to B3 and divide by 4.
B
Total the numbers in B1 to B3 and divide by 5.
C
Total the numbers in B1 to B3 and divide by 3.Correct Answer
QUESTION 21 OF 21

Cell E4 in your worksheet contains the value 300, cell E5 the value 300, and cell E6 the value 0. What is the correct answer to the following formula when added to your worksheet?

A
300
B
200
C
100Correct Answer

Ready to test your recall?

When you created the calculation in cell G4, you were able to use the double-click shortcut to Autofill copies of the formula into the cells underneath. What data did Excel use as a visual reference to determine when to stop copying the formula?

A
The block of information in row 201. 
B
The block of information in column F.
C
The block of information in column K.

How confident are you in this answer?