🌍 All Study Guides 📊 Dashboard 📰 Blog 💡 About

Coursera Microsoft Power BI Data Analyst • STUDY MODE

Practice Quiz

QUESTION 1 OF 70

You had to freeze the screen so that the summary data in columns A to F and the headings in row 1 were always visible. On the Freeze drop-down options in the View ribbon, which choice did you make?

Freeze Top Row

Freeze First Column

Freeze PanesCorrect Answer

QUESTION 2 OF 70

You created the following formula in cell B12 to calculate the total sales for January 2022.

R2:R103 only

K2:K103 only

K2:K103 and R2:R103Correct Answer

QUESTION 3 OF 70

In cell D6, you created a formula to work out the percentage difference between the 2022 quarter-one sales and the 2023 quarter-one sales. Which of the following describes the logic of how this calculation should be designed?

(2022 total – 2023 total)/2022 total

(2023 total – 2022 total)/2023 total

(2023 total-2022 total)/2022 totalCorrect Answer

QUESTION 4 OF 70

In cell C12 you used SUMIF to calculate the total sales for January 2023 and then copied that formula down to cells C13 and C14. When you completed the exercise, what result was generated in C14?

$164,740Correct Answer

$143,555

$145,535

QUESTION 5 OF 70

The headings you added in rows 4 and 10 had to be centered across the tables of information that they related to by using the Merge & Center choice on the Home ribbon. Before selecting the Merge & Center button you typed the heading and then highlighted the cell range that the heading had to be centered in. Where should you type the heading before selecting Merge & center?

On the left edge of the cell range the heading is to be centered in.Correct Answer

On the right edge of the cell range the heading is to be centered in.   

In the middle of the cell range the heading is to be centered in. 

QUESTION 6 OF 70

When you type an entry into a cell in an Excel worksheet, where does the entry appear?

In the worksheet grid only.

In the Formula bar only.

In the worksheet and the Formula bar.Correct Answer

QUESTION 7 OF 70

Which Tab on the Excel Ribbon area would you select to see commands to manage security settings or collaborate with colleagues?

View

Home

ReviewCorrect Answer

QUESTION 8 OF 70

Which of the following statements are true about naming Excel files? Select all that apply.

Filenames can contain any punctuation symbol.

Filenames cannot have spaces.

Filenames can be a mix of text and numbers.Correct Answer

Filenames can have up to 255 characters.Correct Answer

QUESTION 9 OF 70

You are editing a spreadsheet that already has information in it. You type a long text heading into cell A1 and because cell B1 already contains an entry you can’t see all of the text you just typed. Which choice would you select so that some of the words will appear on a second line and the whole heading will be visible? 

Merge and center

Orientation

Wrap textCorrect Answer

QUESTION 10 OF 70

When you type the number 1.5 in the A1 and apply the Percentage format, how will Excel display it?

150%Correct Answer

15%

1.5%

QUESTION 11 OF 70

Column C in the sales spreadsheet that you’re updating contains supplier names. As you’re adding a new supplier name you realize that you need to make column C in your worksheet wider as it is not displaying the supplier name correctly. Which of the following is a mouse shortcut to make the column as wide as it needs to be?

Double-click the vertical line between the initials C and D.

Double-click the initial letter C.

Double-click the vertical line between initials B and C.Correct Answer

QUESTION 12 OF 70

One of the cells in your worksheet contains a number that you will need to refer to frequently. You decide to assign a name to the cell so that you can move quickly to it. Which of the following are allowed in names assigned to a cell or a cell range? Select all that apply.

Underscore CharactersCorrect Answer

Capitals

NumbersCorrect Answer

Spaces 

QUESTION 13 OF 70

Your spreadsheet contains a block of stock information. Column A contains the product name and column B contains the item color. There are 40 rows that have an entry of “Mountain Bike” in column A. Of these, 10 rows have “red” listed as the color in column B. Fifteen other rows for different products also have “red” in column B. If you filter by the term “Mountain Bike” on column A and then filter by the color “red” on column B, how many records will Excel display?

10Correct Answer

QUESTION 14 OF 70

True or False: Operators are symbols used to indicate actions such as addition, subtraction, division and multiplication.

True  Correct Answer

False

QUESTION 15 OF 70

You have the following formula in your worksheet. What would the result be?

45Correct Answer

QUESTION 16 OF 70

What mathematical symbol is processed first in the following formula?    

The multiplication symbol.

The subtraction symbol.Correct Answer

The division symbol.

QUESTION 17 OF 70

The following formula appears in your worksheet.=

G10Correct Answer

M6Correct Answer

QUESTION 18 OF 70

You are editing a results spreadsheet that people update in real time to show results. You want to create a formula that will show you how many cells have been updated and have content in them. 

2Correct Answer

QUESTION 19 OF 70

You need to add a SUM function formula to cell B2 in your worksheet to total the values in cell range A2 to A6. You decide to use the AutoSum Shortcut to create it. Where should you position the cursor before clicking on the AutoSum Shortcut button? 

On cell A6.

On cell B2.Correct Answer

On cell A2.

QUESTION 20 OF 70

You’ve been asked to create average calculations in a sales report. 

12Correct Answer

QUESTION 21 OF 70

You are using the Insert Function feature to add a SUM formula to your worksheet which will total the values in a block of cells. You are on the second step of the Insert Function which is a dialog called Function arguments. In the Number 1 line, what must you include? Select all that apply.

The last cell reference of the blockCorrect Answer

The Function name.

The first cell reference of the block.Correct Answer

A closing parenthesis.

A colon.Correct Answer

An opening parenthesis.

QUESTION 22 OF 70

Column C in your worksheet contains stock codes. The entry in cell C2 reads 2563tt. If you created the following formula in D2 what result would Excel display? 

2563tt

QUESTION 23 OF 70

In one of the Adventure Works’ sheets, the full address for a supplier is incorrectly entered in one cell. Cell D6 contains the following text without any extra spaces:

=MID(D6,5,4)

=MID(D6,9,6)

=MID(D6,15,8)Correct Answer

QUESTION 24 OF 70

You are creating a worksheet that your colleagues will use to log their work time. You need cell E4 to always show the current date and time. Which formula should you enter in E4 to have it always show the current date and time?

=NOW(E4)

=NOW(mm/dd/yyyy,00:00)

=NOW()Correct Answer

QUESTION 25 OF 70

You are working on a spreadsheet that contains sales information for the last two years. Each sale is recorded on a separate row with the date of the sale recorded in column A. Which of these functions can you use to split the dates into component parts? Select all that apply:

DATEDIF

MONTHCorrect Answer

YEARCorrect Answer

DATE

QUESTION 26 OF 70

You are a sales manager for Adventure Works and you are currently reviewing the Quarter 1 results for the sales teams. The team for the western region did not meet their quarterly sales target set so you are about to have a meeting with them. 

=IF(OR(C2>50000,D2>50000,E2>50000),”Yes”,”No”)Correct Answer

=IF(C2>50000,”Yes”,IF(D2>50000,”Yes”,”no”))

=IF(AND(C2>50000,D2>50000,E2>50000),”Yes”,”No”)

QUESTION 27 OF 70

You are reviewing a spreadsheet that records a large number of sales listed by city. You intend to create a SUMIF formula that identifies all rows that have the city name Chicago in column A. Which characters do you need to add around the name Chicago when you are adding it as the criteria? 

Double quotation marksCorrect Answer

Parentheses

Single quotation marks

QUESTION 28 OF 70

You are typing sales data into a column in your Microsoft Excel worksheet. When you type a numeric entry and press enter, the following entry appears: 

The cell contains an extra text character.

The cell is formatted as text.

The column is too narrow.Correct Answer

QUESTION 29 OF 70

True or False: The maximum number of data rows that can be contained in an Excel workbook is one million. 

True 

FalseCorrect Answer

QUESTION 30 OF 70

You open a spreadsheet that a colleague has shared with you and you notice that the column initial letter sequence is A, B, D. Why is the column initial letter C not visible?

The column is hidden.Correct Answer

The column has been deleted.

The column has been repositioned. 

QUESTION 31 OF 70

True or False: You can use the Undo feature to reverse deleting a worksheet as long as you haven’t saved the workbook.

True

FalseCorrect Answer

QUESTION 32 OF 70

You are compiling a sales report in an Excel worksheet. Cell C4 contains an important sales total. A colleague has explained to you that names can be assigned to cells to make them easier to locate and you decide to try this out. When you type the name June 2023 Sales Total in the Name box, Excel displays a warning message which says “You must enter a valid reference you want to go to, or type a valid name for this selection.” Why has Excel rejected this name?

It contains numbers.

It contains spaces.Correct Answer

It is too long.

QUESTION 33 OF 70

You open an Excel file that other colleagues have worked on and notice that there are gaps in the row numbers on the left of the screen and the numbers are in blue. What does this indicate?

The content has been copied and pasted.

The content has been filtered.Correct Answer

The content has been sorted.

QUESTION 34 OF 70

You’ve been asked to update a spreadsheet that already contains a lot of information, so you are adding entries beyond row 100 in the spreadsheet. Row one and column A in your worksheet both contain headings. You do not want to keep scrolling up or to the left to see the headings. 

Freeze panesCorrect Answer

Freeze first column

Freeze top row

QUESTION 35 OF 70

Cell D7 in your worksheet contains the value 10. In another cell in the workbook you have the following formula:    

500Correct Answer

1000

250

QUESTION 36 OF 70

Which set of parentheses will Excel process first when it is calculating the formula result?

(G7/C8)

 (A3-H4)Correct Answer

 (F10+C4)

QUESTION 37 OF 70

Cell A2 of your spreadsheet contains the value 500. Cell B2 contains the value 150 and cell C2 contains the entry 10%. You have entered the following formula in cell D2 which has the Percentage format applied.    

3500%Correct Answer

35% 

350%

QUESTION 38 OF 70

You are creating an end of month sales report. Cell D2 displays the value $150,000 which is the total sales achieved by your team in this month. In cell D3 you create the following formula to set a new sales target for the following month.    

$175,000

$165,000Correct Answer

$185,000

QUESTION 39 OF 70

You are using the AutoSum shortcut to add a formula. When you click on the dropdown arrow, which of the following functions are available? Select all that apply:

SUMCorrect Answer

COUNTA

MINCorrect Answer

AVERAGECorrect Answer

MAXCorrect Answer

QUESTION 40 OF 70

You are editing a worksheet to put the text content into a more appropriate format. 

Dr. Mary Anderson

Mary Anderson

QUESTION 41 OF 70

In one of the Adventure Works’ sheets, the full address for a supplier is incorrectly entered in one cell. Cell D6 contains the following entry in which there are no spaces.

FreemontCorrect Answer

Avenue

Main

QUESTION 42 OF 70

Some information in an Adventure Works spreadsheet has been downloaded incorrectly from another source. In one column three pieces of information, a stock number, a supplier and a product category have been blended together. The entry in E7 reads:

=RIGHT(E7,13)Correct Answer

=RIGHT(E7,11)

=RIGHT(E7,12)

QUESTION 43 OF 70

You are creating a worksheet that your colleagues will use to log their work time. You need cell E4 to always show the current date. Which formula should you enter in E4 to have it always show the current calendar date?

=TODAY(DD/MM/YYYY)

=TODAY(E4)

=TODAY()Correct Answer

QUESTION 44 OF 70

You are a sales manager for Adventure Works and you are currently reviewing the Quarter 1 results for the sales teams. The sales figures achieved by the teams are entered in column A. 

Send individual Emails.

Send a congratulation message on MS Teams.

Schedule a meeting with the team.Correct Answer

QUESTION 45 OF 70

You are reviewing a spreadsheet that records a large number of sales listed by city. You want to generate city-specific totals so you create the following formula using the SUMIF function: 

The sum range.Correct Answer

The criteria range.

The criteria.

QUESTION 46 OF 70

A colleague has shown you how to create a chart from some inventory data that you have in a worksheet. They’ve indicated that you can customize it using colors and titles. Where would you find commands relating to the chart?

On the Design tab.

On the Review tab.

On Contextual tabs.Correct Answer

QUESTION 47 OF 70

You’re adding sales figures to a column in Excel. Some of the numbers do not have any decimal place figures. You would like the figures in the column to show two decimal places, even if they are zeros, and also to have a character between the thousands and the hundreds. Which of the following number formats should you apply?

Currency 

Number

CommaCorrect Answer

QUESTION 48 OF 70

You’ve been asked to update a customer details spreadsheet. You realize that the person who originally created the spreadsheet added a title of Other Information in D1 and used column D to record comments which are no longer relevant. The cursor is currently on cell D1. If you select Delete sheet columns from the Delete dropdown on the Home ribbon, which column will Excel delete?

Column DCorrect Answer

Column E

Column C

QUESTION 49 OF 70

You are updating an inventory file with new stock items that Adventure Works have just received. You have previously set the width of column A to only show 5 characters. Cell B200 contains a heading. If you type the 6 character serial number 95869M in A200 how will it appear in the worksheet? 

95869M

#####

95869Correct Answer

QUESTION 50 OF 70

You are editing a sales report in an Excel worksheet. Other colleagues also work in the same file. Cell C4 contains an important sales total. You decide to assign a name to the cell and would first like to check what names are already in use in the workbook. Which of the following can you use to find and check the names in use? Select all that apply.

The Name manager dialog.Correct Answer

The Name Box.Correct Answer

The Search box.

Custom views.

QUESTION 51 OF 70

You are working on a worksheet that contains information on stock levels. You need to identify all rows in the data have a figure of 1000 in the Stock Level column. Which of the following options can you use to complete this task?

Use Does not equal on the Number filter sub-menu.

Use Equals on the Number filter sub-menu.Correct Answer

Use Greater than on Number filter sub-menu.

QUESTION 52 OF 70

True or False: When Excel is processing a formula, it will always process the mathematical operators in the order in which it encounters them as it reads left to right.

FalseCorrect Answer

True

QUESTION 53 OF 70

You have the following formula in your worksheet. According to the Order of Precedence, which mathematical operator would Excel process first? 

 /Correct Answer

QUESTION 54 OF 70

Your worksheet contains the following formula:   

30Correct Answer

103

QUESTION 55 OF 70

Cells J2, K2 and L2 in your worksheet all contain the number 5. In cell M2 there is a formula that reads:    

20Correct Answer

QUESTION 56 OF 70

Cell A2 of your spreadsheet contains the value 500. Cell B2 contains the value 150 and cell C2 contains the entry 10%. You have entered the following formula in cell D2 which still has the general format applied.    

35%

350%

35Correct Answer

QUESTION 57 OF 70

Columns A, B and C of your worksheet contain numbers. The columns are called Day, Month and Year. You need Excel to recognize the result as a date. You need to create a formula in another column to combine them into one complete date. Which function should you use to achieve this?

CONCAT

DATEDIF

DATECorrect Answer

QUESTION 58 OF 70

You are working on a spreadsheet that has a lot of typing errors in customer names entered in column B. Cell B2 contains the entry “Mary Anderson”. If you create the following formula in cell C2 what result will be displayed?  

MARY ANDERSON

QUESTION 59 OF 70

In one of the Adventure Works sheets, the full address for a supplier is incorrectly entered in the one cell. Cell B7 contains the entry:

LEFT

MIDCorrect Answer

RIGHT

QUESTION 60 OF 70

True or False: You recently created a spreadsheet that your colleagues can use to track and log their work hours. You designed it so that they would enter the date worked in column A and then their shift hours in other columns to the right. 

TrueCorrect Answer

False

QUESTION 61 OF 70

You are based in the New York office of Adventure Works and you’re currently working on a spreadsheet that contains the timeline for the rollout of their new marketing campaign. All the dates in the spreadsheet are in the MM/DD/YY format.

24Correct Answer

QUESTION 62 OF 70

In the inventory spreadsheet that you are updating, the supplier name needs to be entered in column A. You type a supplier name into cell A2 in your spreadsheet. You want to use one of Excel’s quick entry features to copy the same supplier name into all cells down to A100. What feature should you use?

Autofill  Correct Answer

Autocomplete

Autofit

QUESTION 63 OF 70

You want to remove the color that has been applied to the worksheet tabs. Which of the following series of steps would allow you to do this?

Right-click on the worksheet Tab to open the shortcut menu. Select Tab color and choose No color. Correct Answer

Right-click on the worksheet tab. Select Tab color and choose Clear tab color.

Right-click on the worksheet Tab to open the shortcut menu. Select Tab color and choose Remove tab color.

465.1000

465.100Correct Answer

465.10 

QUESTION 64 OF 70

You’ve been asked to update a monthly sales report and create some percentage calculations. 

=D7/D2

=D2/D7*100Correct Answer

=D7/D2*100

=D2/D7

QUESTION 65 OF 70

True or False: Columns A, B and C of your worksheet contain numbers. The columns are called Day, Month and Year. The following formula will combine the entries into one numeric date.    

True

FalseCorrect Answer

QUESTION 66 OF 70

You are updating a spreadsheet that displays some of Adventure Works’ international sales. The numbers in one column need to be identified as Japanese Yen. When you click on the Currency format dropdown on the Home ribbon that currency symbol is not offered. What is the correct series of steps to apply this format?

Select the Number format dropdown. Choose Currency as a category and then the Yen symbol.

Select the Number format dropdown. Choose More number formats. Choose Currency as a category and then the Yen symbol.

Select the Number format dropdown. Choose the Yen symbol from the list provided.Correct Answer

QUESTION 67 OF 70

You’ve been asked to update a customer details spreadsheet that has the customer title in column B and their last name in column C. You’ve been asked to add their first names so you need to add a new column to your spreadsheet between the existing columns B and C. Before you choose one of the Insert column options on the ribbon or shortcut menu, where should you position your cursor?

In column B.

In column C.Correct Answer

In column D.

QUESTION 68 OF 70

In your end of month sales report, you are creating a formula to compare last month’s sales figure with this month’s sales and display the percentage difference. Cell E10 contains the sales figure for the last month of $125,000. Cell F10 holds this month’s sales figure of $150,000. G10 is set to Percentage format and contains the formula:    

0.2

20%Correct Answer

QUESTION 69 OF 70

Cell A2 in your worksheet contains the value 50. B2 contains the value 10 and C2 contains a zero. A formula in cell D2 reads:    

0Correct Answer

QUESTION 70 OF 70

You are creating a SUM formula in cell A20 of your worksheet. You position the cursor on cell A20 and click on the AutoSum Shortcut button which makes Excel generate a suggestion of what it should include in the total. 

A1:A9

A1:19

A11:19Correct Answer

Ready to test your recall?

You had to freeze the screen so that the summary data in columns A to F and the headings in row 1 were always visible. On the Freeze drop-down options in the View ribbon, which choice did you make?

Freeze Top Row

Freeze First Column

Freeze Panes

How confident are you in this answer?

Practice Quiz

You had to freeze the screen so that the summary data in columns A to F and the headings in row 1 were always visible. On the Freeze drop-down options in the View ribbon, which choice did you make?

You created the following formula in cell B12 to calculate the total sales for January 2022.

In cell D6, you created a formula to work out the percentage difference between the 2022 quarter-one sales and the 2023 quarter-one sales. Which of the following describes the logic of how this calculation should be designed?

In cell C12 you used SUMIF to calculate the total sales for January 2023 and then copied that formula down to cells C13 and C14. When you completed the exercise, what result was generated in C14?

When you type an entry into a cell in an Excel worksheet, where does the entry appear?

Which Tab on the Excel Ribbon area would you select to see commands to manage security settings or collaborate with colleagues?

Which of the following statements are true about naming Excel files? Select all that apply.

When you type the number 1.5 in the A1 and apply the Percentage format, how will Excel display it?

One of the cells in your worksheet contains a number that you will need to refer to frequently. You decide to assign a name to the cell so that you can move quickly to it. Which of the following are allowed in names assigned to a cell or a cell range? Select all that apply.

True or False: Operators are symbols used to indicate actions such as addition, subtraction, division and multiplication.

You have the following formula in your worksheet. What would the result be?

What mathematical symbol is processed first in the following formula?&nbsp;&nbsp;&nbsp;&nbsp;

The following formula appears in your worksheet.=

You are editing a results spreadsheet that people update in real time to show results. You want to create a formula that will show you how many cells have been updated and have content in them.&nbsp;

You need to add a SUM function formula to cell B2 in your worksheet to total the values in cell range A2 to A6. You decide to use the AutoSum Shortcut to create it. Where should you position the cursor before clicking on the AutoSum Shortcut button?&nbsp;

You’ve been asked to create average calculations in a sales report.&nbsp;

You are using the Insert Function feature to add a SUM formula to your worksheet which will total the values in a block of cells. You are on the second step of the Insert Function which is a dialog called Function arguments. In the Number 1 line, what must you include? Select all that apply.

Column C in your worksheet contains stock codes. The entry in cell C2 reads 2563tt. If you created the following formula in D2 what result would Excel display?&nbsp;

In one of the Adventure Works’ sheets, the full address for a supplier is incorrectly entered in one cell. Cell D6 contains the following text without any extra spaces:

You are creating a worksheet that your colleagues will use to log their work time. You need cell E4 to always show the current date and time. Which formula should you enter in E4 to have it always show the current date and time?

You are working on a spreadsheet that contains sales information for the last two years. Each sale is recorded on a separate row with the date of the sale recorded in column A. Which of these functions can you use to split the dates into component parts? Select all that apply:

You are a sales manager for Adventure Works and you are currently reviewing the Quarter 1 results for the sales teams. The team for the western region did not meet their quarterly sales target set so you are about to have a meeting with them.&nbsp;

You are reviewing a spreadsheet that records a large number of sales listed by city. You intend to create a SUMIF formula that identifies all rows that have the city name Chicago in column A. Which characters do you need to add around the name Chicago when you are adding it as the criteria?&nbsp;

You are typing sales data into a column in your Microsoft Excel worksheet. When you type a numeric entry and press enter, the following entry appears:&nbsp;

True or False: The maximum number of data rows that can be contained in an Excel workbook is one million.&nbsp;

You open a spreadsheet that a colleague has shared with you and you notice that the column initial letter sequence is A, B, D. Why is the column initial letter C not visible?

True or False: You can use the Undo feature to reverse deleting a worksheet as long as you haven’t saved the workbook.

You open an Excel file that other colleagues have worked on and notice that there are gaps in the row numbers on the left of the screen and the numbers are in blue. What does this indicate?

You’ve been asked to update a spreadsheet that already contains a lot of information, so you are adding entries beyond row 100 in the spreadsheet. Row one and column A in your worksheet both contain headings. You do not want to keep scrolling up or to the left to see the headings.&nbsp;

Cell D7 in your worksheet contains the value 10. In another cell in the workbook you have the following formula: &nbsp;&nbsp;&nbsp;

Which set of parentheses will Excel process first when it is calculating the formula result?

Cell A2 of your spreadsheet contains the value 500. Cell B2 contains the value 150 and cell C2 contains the entry 10%. You have entered the following formula in cell D2 which has the Percentage format applied.&nbsp;&nbsp;&nbsp;&nbsp;

You are creating an end of month sales report. Cell D2 displays the value $150,000 which is the total sales achieved by your team in this month. In cell D3 you create the following formula to set a new sales target for the following month.&nbsp;&nbsp;&nbsp;&nbsp;

You are using the AutoSum shortcut to add a formula. When you click on the dropdown arrow, which of the following functions are available? Select all that apply:

You are editing a worksheet to put the text content into a more appropriate format.&nbsp;

In one of the Adventure Works’ sheets, the full address for a supplier is incorrectly entered in one cell. Cell D6 contains the following entry in which there are no spaces.

Some information in an Adventure Works spreadsheet has been downloaded incorrectly from another source. In one column three pieces of information, a stock number, a supplier and a product category have been blended together. The entry in E7 reads:

You are creating a worksheet that your colleagues will use to log their work time. You need cell E4 to always show the current date. Which formula should you enter in E4 to have it always show the current calendar date?

You are a sales manager for Adventure Works and you are currently reviewing the Quarter 1 results for the sales teams. The sales figures achieved by the teams are entered in column A.&nbsp;

You are reviewing a spreadsheet that records a large number of sales listed by city. You want to generate city-specific totals so you create the following formula using the SUMIF function:&nbsp;

A colleague has shown you how to create a chart from some inventory data that you have in a worksheet. They’ve indicated that you can customize it using colors and titles. Where would you find commands relating to the chart?

You are updating an inventory file with new stock items that Adventure Works have just received. You have previously set the width of column A to only show 5 characters. Cell B200 contains a heading. If you type the 6 character serial number 95869M in A200 how will it appear in the worksheet?&nbsp;

You are working on a worksheet that contains information on stock levels. You need to identify all rows in the data have a figure of 1000 in the Stock Level column. Which of the following options can you use to complete this task?

True or False: When Excel is processing a formula, it will always process the mathematical operators in the order in which it encounters them as it reads left to right.

You have the following formula in your worksheet. According to the Order of Precedence, which mathematical operator would Excel process first?&nbsp;

Your worksheet contains the following formula: &nbsp;&nbsp;

Cells J2, K2 and L2 in your worksheet all contain the number 5. In cell M2 there is a formula that reads:&nbsp;&nbsp;&nbsp;&nbsp;

Cell A2 of your spreadsheet contains the value 500. Cell B2 contains the value 150 and cell C2 contains the entry 10%. You have entered the following formula in cell D2 which still has the general format applied.&nbsp;&nbsp;&nbsp;&nbsp;

Columns A, B and C of your worksheet contain numbers. The columns are called Day, Month and Year. You need Excel to recognize the result as a date. You need to create a formula in another column to combine them into one complete date. Which function should you use to achieve this?

You are working on a spreadsheet that has a lot of typing errors in customer names entered in column B. Cell B2 contains the entry “Mary Anderson”. If you create the following formula in cell C2 what result will be displayed? &nbsp;

In one of the Adventure Works sheets, the full address for a supplier is incorrectly entered in the one cell. Cell B7 contains the entry:

True or False: You recently created a spreadsheet that your colleagues can use to track and log their work hours. You designed it so that they would enter the date worked in column A and then their shift hours in other columns to the right.&nbsp;

You are based in the New York office of Adventure Works and you’re currently working on a spreadsheet that contains the timeline for the rollout of their new marketing campaign. All the dates in the spreadsheet are in the MM/DD/YY format.

You want to remove the color that has been applied to the worksheet tabs. Which of the following series of steps would allow you to do this?

You’ve been asked to update a monthly sales report and create some percentage calculations.&nbsp;

True or False: Columns A, B and C of your worksheet contain numbers. The columns are called Day, Month and Year. The following formula will combine the entries into one numeric date. &nbsp;&nbsp;&nbsp;

Cell A2 in your worksheet contains the value 50. B2 contains the value 10 and C2 contains a zero. A formula in cell D2 reads: &nbsp;&nbsp;&nbsp;

You are creating a SUM formula in cell A20 of your worksheet. You position the cursor on cell A20 and click on the AutoSum Shortcut button which makes Excel generate a suggestion of what it should include in the total.&nbsp;

Ready to test your recall?

What mathematical symbol is processed first in the following formula?

You are editing a results spreadsheet that people update in real time to show results. You want to create a formula that will show you how many cells have been updated and have content in them.

You need to add a SUM function formula to cell B2 in your worksheet to total the values in cell range A2 to A6. You decide to use the AutoSum Shortcut to create it. Where should you position the cursor before clicking on the AutoSum Shortcut button?

You’ve been asked to create average calculations in a sales report.

Column C in your worksheet contains stock codes. The entry in cell C2 reads 2563tt. If you created the following formula in D2 what result would Excel display?

You are a sales manager for Adventure Works and you are currently reviewing the Quarter 1 results for the sales teams. The team for the western region did not meet their quarterly sales target set so you are about to have a meeting with them.

You are reviewing a spreadsheet that records a large number of sales listed by city. You intend to create a SUMIF formula that identifies all rows that have the city name Chicago in column A. Which characters do you need to add around the name Chicago when you are adding it as the criteria?

You are typing sales data into a column in your Microsoft Excel worksheet. When you type a numeric entry and press enter, the following entry appears:

True or False: The maximum number of data rows that can be contained in an Excel workbook is one million.

You’ve been asked to update a spreadsheet that already contains a lot of information, so you are adding entries beyond row 100 in the spreadsheet. Row one and column A in your worksheet both contain headings. You do not want to keep scrolling up or to the left to see the headings.

Cell D7 in your worksheet contains the value 10. In another cell in the workbook you have the following formula:

Cell A2 of your spreadsheet contains the value 500. Cell B2 contains the value 150 and cell C2 contains the entry 10%. You have entered the following formula in cell D2 which has the Percentage format applied.

You are creating an end of month sales report. Cell D2 displays the value $150,000 which is the total sales achieved by your team in this month. In cell D3 you create the following formula to set a new sales target for the following month.

You are editing a worksheet to put the text content into a more appropriate format.

You are a sales manager for Adventure Works and you are currently reviewing the Quarter 1 results for the sales teams. The sales figures achieved by the teams are entered in column A.

You are reviewing a spreadsheet that records a large number of sales listed by city. You want to generate city-specific totals so you create the following formula using the SUMIF function:

You are updating an inventory file with new stock items that Adventure Works have just received. You have previously set the width of column A to only show 5 characters. Cell B200 contains a heading. If you type the 6 character serial number 95869M in A200 how will it appear in the worksheet?

You have the following formula in your worksheet. According to the Order of Precedence, which mathematical operator would Excel process first?

Your worksheet contains the following formula:

Cells J2, K2 and L2 in your worksheet all contain the number 5. In cell M2 there is a formula that reads:

Cell A2 of your spreadsheet contains the value 500. Cell B2 contains the value 150 and cell C2 contains the entry 10%. You have entered the following formula in cell D2 which still has the general format applied.

You are working on a spreadsheet that has a lot of typing errors in customer names entered in column B. Cell B2 contains the entry “Mary Anderson”. If you create the following formula in cell C2 what result will be displayed?

True or False: You recently created a spreadsheet that your colleagues can use to track and log their work hours. You designed it so that they would enter the date worked in column A and then their shift hours in other columns to the right.

You’ve been asked to update a monthly sales report and create some percentage calculations.

True or False: Columns A, B and C of your worksheet contain numbers. The columns are called Day, Month and Year. The following formula will combine the entries into one numeric date.

Cell A2 in your worksheet contains the value 50. B2 contains the value 10 and C2 contains a zero. A formula in cell D2 reads:

You are creating a SUM formula in cell A20 of your worksheet. You position the cursor on cell A20 and click on the AutoSum Shortcut button which makes Excel generate a suggestion of what it should include in the total.