🌍 All Study Guides 📊 Dashboard 📰 Blog 💡 About

Coursera Microsoft Power BI Data Analyst • STUDY MODE

Practice Quiz

QUESTION 1 OF 23

In Sheet1, Microsoft Excel automatically aligned a numerical entry to the left. In this case, such an action indicates an issue with the content. How can you correct an error like this?

Alter the Number format.

Edit the content.

Change the alignment.Correct Answer

QUESTION 2 OF 23

In step 3, you formatted cells E23 to H25, which contained figures representing Japanese Yen amounts. What steps did you take to apply the Yen Currency format to this block of cells?

Select the Currency button in the Number section of the Home tab. Choose More Accounting Formats. With Currency highlighted as a category, select the Symbol drop-down on the right. Select Japanese from the list of currencies that appear.Correct Answer

Select the Currency button in the Number section of the Home tab. Choose More Accounting Formats. With Custom highlighted as a category, select the Symbol drop-down on the right. Select Japanese from the list currency symbols that appear.

Select the Currency button in the Number section of the Home tab. Choose More Accounting Formats. With Special highlighted as a category, select the Symbol drop-down on the right. Select Japanese from the list of currency symbols that appear.

QUESTION 3 OF 23

As one of the final steps in the exercise, you hid the Contacts worksheet using the Hide & Unhide command. Where on the Home tab is this command located? 

On the Format choice in the Cells group.Correct Answer

On the Format choice in the Styles group.

On the Format choice in the Editing group.

QUESTION 4 OF 23

You attempt to rename an Excel file to Customer’s first/last name and address. However, Excel rejects this name. Can you identify the reason why Excel won’t accept this name?    

The filename contains prohibited punctuation marks.Correct Answer

The filename contains too many characters.

The filename contains several spaces.

QUESTION 5 OF 23

You want to quickly add the department name Customer Service in cells C1 to C20. You decide to use the Autofill feature. What type of mouse pointer shape do you need to Autofill?

A narrow white hand shape.

A narrow white cross shape.

A narrow black cross shape.Correct Answer

QUESTION 6 OF 23

You type some non-scientific numerical data directly into a Microsoft Excel worksheet. You then press Enter and 1.9E+09 appears in the cell. Why has this  text appeared in the cell?

The number format is incorrect.

The column is too narrow.Correct Answer

The cell contains text and numbers.

QUESTION 7 OF 23

Which number format option is both a format and an action button in Excel?

The Comma format

The Currency format

The Percentage formatCorrect Answer

QUESTION 8 OF 23

You are editing a worksheet in which column G is hidden and is not visible between columns F and H. Which set of steps can you take to unhide column G and check its contents?

Select column G and click Format on the Home tab. Choose Hide & Unhide from the drop-down menu and then unhide columns from the sub-menu.

Select the column to the right of the hidden column. Select Format on the Home tab. Choose Hide & Unhide from the drop-down menu and then unhide columns from the sub-menu.

Highlight columns F and H. Select Format on the Home tab. Choose Hide & Unhide from the drop-down menu and then unhide columns from the sub-menu.Correct Answer

QUESTION 9 OF 23

You type the heading Customer Name into a cell. Part of the heading is hidden because of the column width and the fact that there is other content in the cell directly to the right. You would like the full heading to be visible and the word Name to appear under the word Customer. How can you do this?

Use the Wrap Text command in the Alignment group.Correct Answer

Type the word Name in the cell underneath the heading.

Use the Center align command in the Alignment group on the Home tab.

QUESTION 10 OF 23

You need to sort or reorder a large block of information in a worksheet. Which tab do you need to select to access the Sort feature?

The Data tabCorrect Answer

The View tab

The Contextual Sort tab

QUESTION 11 OF 23

In the exercise, you sorted the Products worksheet data by the Product Name information stored in column C. Which of the following steps did you perform first, so that data would be sorted when you selected the Sort Ascending choice?

Select Product Name from a drop-down list.

Select column C by selecting the column initial.

Select any cell in column C.Correct Answer

QUESTION 12 OF 23

You were asked to sort the data first by Supplier and then by Units in Stock. Which choice did you select on the Data ribbon to perform this? 

SortCorrect Answer

Sort A to Z

Sort Z to A

QUESTION 13 OF 23

True or False: You used Sort to sort the data using two columns with a first-level sort by Supplier and a second-level sort data by Units in stock. This meant that when the sort was complete, the Supplier entries were no longer in alphabetical order.

True

FalseCorrect Answer

QUESTION 14 OF 23

While editing the Adventure Works file, you turn the first visible row and column in the spreadsheet static. Which one of the following options do you use to complete this task?

Freeze PanesCorrect Answer

Freeze Top Row

Freeze First Column

QUESTION 15 OF 23

True or False: You need to specify the key for a Sort when using the Sort Ascending choice by highlighting the relevant column.

True

FalseCorrect Answer

QUESTION 16 OF 23

You have five filters in place on the data in your worksheet. What is the quickest way to remove all filters and restore the full display of data?

Use the Clear option on the Data ribbon.Correct Answer

Use the Undo button.

Use the Clear filter from choice in each filter drop-down.

QUESTION 17 OF 23

You are working with a large block of data. You applied a filter but there are still a lot of rows visible. How can you determine how many results you have found?

Check the bottom-left of the Excel screen.Correct Answer

Check the middle of the status bar.

Check the bottom-right of the Excel Screen.

QUESTION 18 OF 23

In the exercise, you selected the Product Name filter to filter and find all the entries relating to mountain bikes. What were your next steps?

You selected Text filter and then contains on the sub-menu.Correct Answer

You selected Text filter and then begins on the sub-menu. 

You selected Text filter and then equals on the sub-menu.

QUESTION 19 OF 23

You want to move quickly to cell S1215 in your worksheet. To achieve this, you type the cell reference into a particular area of the screen and then press enter. What is the area of the screen called in which you type the cell reference?

The Formula Bar

The Name BoxCorrect Answer

The Title Bar

QUESTION 20 OF 23

You open an Excel worksheet that contains ten columns of data. The information is filtered, so some of the available data is not visible. How can you identify which heading the data is filtered by?

The Filter arrow contains an arrow symbol.

The Filter arrow drop-down symbol is in bold.

The Filter arrow contains a funnel symbol.Correct Answer

QUESTION 21 OF 23

Column A in your worksheet contains component names. All twenty-two names have been input as text except for one entry called 11ratchet, which begins with a number. If you were to sort this column in descending order, where would the entry 11ratchet appear?

At the top of the column.

At the bottom of the column.Correct Answer

In the middle of the column.

QUESTION 22 OF 23

Row one in your worksheet contains headings and it is currently visible at the top of the screen. The cursor is on cell B3. Which of the Freeze Panes options must you choose to ensure that the headings remain visible onscreen?

Freeze Top RowCorrect Answer

Freeze Panes

Freeze First Column

QUESTION 23 OF 23

True or False: You need to edit only those rows in a spreadsheet that have been shaded yellow. You can use the Filter by color filter option to hide rows that haven’t been formatted in this way.

False

TrueCorrect Answer

Ready to test your recall?

In Sheet1, Microsoft Excel automatically aligned a numerical entry to the left. In this case, such an action indicates an issue with the content. How can you correct an error like this?

Alter the Number format.

Edit the content.

Change the alignment.

How confident are you in this answer?

Practice Quiz

In Sheet1, Microsoft Excel automatically aligned a numerical entry to the left. In this case, such an action indicates an issue with the content. How can you correct an error like this?

In step 3, you formatted cells E23 to H25, which contained figures representing Japanese Yen amounts. What steps did you take to apply the Yen Currency format to this block of cells?

As one of the final steps in the exercise, you hid the Contacts worksheet using the Hide &amp; Unhide command. Where on the Home tab is this command located?&nbsp;

You attempt to rename an Excel file to Customer’s first/last name and address. However, Excel rejects this name. Can you identify the reason why Excel won’t accept this name?&nbsp;&nbsp;&nbsp;&nbsp;

You want to quickly add the department name Customer Service in cells C1 to C20. You decide to use the Autofill feature. What type of mouse pointer shape do you need to Autofill?

You type some non-scientific numerical data directly into a Microsoft Excel worksheet. You then press Enter and 1.9E+09 appears in the cell. Why has this&nbsp; text appeared in the cell?

Which number format option is both a format and an action button in Excel?

You are editing a worksheet in which column G is hidden and is not visible between columns F and H. Which set of steps can you take to unhide column G and check its contents?

You need to sort or reorder a large block of information in a worksheet. Which tab do you need to select to access the Sort feature?

In the exercise, you sorted the Products worksheet data by the Product Name information stored in column C. Which of the following steps did you perform first, so that data would be sorted when you selected the Sort Ascending choice?

You were asked to sort the data first by Supplier and then by Units in Stock. Which choice did you select on the Data ribbon to perform this?&nbsp;

True or False: You used Sort to sort the data using two columns with a first-level sort by Supplier and a second-level sort data by Units in stock. This meant that when the sort was complete, the Supplier entries were no longer in alphabetical order.

While editing the Adventure Works file, you turn the first visible row and column in the spreadsheet static. Which one of the following options do you use to complete this task?

True or False: You need to specify the key for a Sort when using the Sort Ascending choice by highlighting the relevant column.

You have five filters in place on the data in your worksheet. What is the quickest way to remove all filters and restore the full display of data?

You are working with a large block of data. You applied a filter but there are still a lot of rows visible. How can you determine how many results you have found?

In the exercise, you selected the Product Name filter to filter and find all the entries relating to mountain bikes. What were your next steps?

You want to move quickly to cell S1215 in your worksheet. To achieve this, you type the cell reference into a particular area of the screen and then press enter. What is the area of the screen called in which you type the cell reference?

You open an Excel worksheet that contains ten columns of data. The information is filtered, so some of the available data is not visible. How can you identify which heading the data is filtered by?

Column A in your worksheet contains component names. All twenty-two names have been input as text except for one entry called 11ratchet, which begins with a number. If you were to sort this column in descending order, where would the entry 11ratchet appear?

Row one in your worksheet contains headings and it is currently visible at the top of the screen. The cursor is on cell B3. Which of the Freeze Panes options must you choose to ensure that the headings remain visible onscreen?

True or False: You need to edit only those rows in a spreadsheet that have been shaded yellow. You can use the Filter by color filter option to hide rows that haven’t been formatted in this way.

Ready to test your recall?

As one of the final steps in the exercise, you hid the Contacts worksheet using the Hide & Unhide command. Where on the Home tab is this command located?

You attempt to rename an Excel file to Customer’s first/last name and address. However, Excel rejects this name. Can you identify the reason why Excel won’t accept this name?

You type some non-scientific numerical data directly into a Microsoft Excel worksheet. You then press Enter and 1.9E+09 appears in the cell. Why has this text appeared in the cell?

You were asked to sort the data first by Supplier and then by Units in Stock. Which choice did you select on the Data ribbon to perform this?