Work Smarter with Microsoft Excel Coursera Quiz Answers

Gell All Weeks Work Smarter with Microsoft Excel Coursera Quiz Answers

Work Smarter with Microsoft Excel Coursera Quiz Answers

KNOWLEDGE CHECK: PRINTING WORKBOOK CONTENT QUIZ ANSWER

1. Where will you find the command to add a Page Break to your Worksheet?

[expand title=View Answer] On the Page Layout Tab [/expand]

2. You are about to print your Worksheet and would like to have Page Numbers at the bottom of the printed pages. Where would you do this in Excel?

[expand title=View Answer]
From a command on the Insert Tab.

In-Page Setup on the Print Options in Backstage View

From a command on the Layout Tab.
[/expand]

4. When you begin to print your Worksheet, you realize that there will be two pages in the printout. Which feature would you use to make sure that the headings in your data repeat on both pages?

[expand title=View Answer]Print Titles[/expand]

5. When you print your Worksheet you realize that there is one line of print appearing on a second page. How could you ensure that everything is printed on a single page? Select all options that apply.

[expand title=View Answer]On the Page Layout Tab, change the choice in the Height box in the Scale to Fit group. [/expand]

GET STARTED WITH EXCEL MODULE GRADED QUIZ

Q1. What is this highlighted area in the Excel screen called?

[expand title=View Answer]The Formula Bar[/expand]

Q2. If you wish to save your Excel file, what method can you use? Select all options that apply.

[expand title=View Answer]
Ctrl + S

File, Save
[/expand]

Q3. When you open an Excel File you see that it has opened in Compatibility Mode. You can see this from the Excel Title Bar. As you will be the only person working on this file, you want to convert this file to the Excel Office 365 format. Where can you find the Convert button?

[expand title=View Answer] File, Info333 [/expand]

Q4. What types of data can you type into an Excel Cell? Select all options that apply.

[expand title=View Answer]
Text

Text and numbers together

Date and time entries

Numbers
[/expand]

Q5. When you print your Worksheet you realize that there is one line of print appearing on a second page. How could you ensure that everything is printed on a single page? Select all options that apply.

[expand title=View Answer]
1.On the Page Layout Tab, change the choice in the in the Height box in the Scale to Fit group.
2.Decrease the Margins
3.Add a Manual Page Break into the content on your Worksheet.
[/expand]

Knowledge check: Modify a worksheet quiz answers

1. What kind of Format would the highlighted command on the Home Tab apply to numbers?

[expand title=View Answer] Applies a Format that has two decimal places and a currency symbol [/expand]

2. You type some numbers into the Worksheet and see the following symbols appear in a cell. Why have they appeared?

[expand title=View Answer] The data entered is not recognized. [/expand]

3. You type the heading Customer Name into a cell. Part of the heading is hidden because of the Column width. You would like the word Name to appear under the word Customer. How can you do this?

[expand title=View Answer] Use the Wrap Text command in the Alignment group on the Home Tab. [/expand]

4. You want to apply a Range Name to a block of cells. Which of the following statements are true? Select all options that apply.

[expand title=View Answer]
1.The Name cannot contain spaces.
2.The Name must be unique.
3.The Name can contain a mixture of text and numbers.
[/expand]

5. You are using the Find and Replace feature to locate some pieces of text in your Excel file that you need to replace. Which of the following can you do to customize the search? Select all options that apply.

[expand title=View Answer]
1.Make the search case-sensitive.
2.Search the whole workbook.
[/expand]

Knowledge check: get started with data quiz answer

Q1. What will the highlighted area of the cursor allow you to do?

[expand title=View Answer] Use the Autofill feature[/expand]

Q2. You want to Cut some data from one location in an Excel spreadsheet so that you can Paste it in at a different spot. How can you Cut the data? Select all options that apply.

[expand title=View Answer]
1.Use the Cut command in the Clipboard section of the Home Tab
2.Use the Shortcut Menu\
[/expand]

Q3, You notice that there is a column initially missing at the top of the Excel Worksheet. What does this tell you about the Worksheet?

[expand title=View Answer] That a Column has been hidden[/expand]

Q4. Where would you find the command button to clear content from a Cell or block of Cells in the Worksheet?

[expand title=View Answer] On the Home Tab [/expand]

Q5. You typed a series of headings across a Row in your Worksheet but then decided that it would be better if they were vertically down the Column instead. What feature can you use to change the

[expand title=View Answer] The Transpose feature [/expand]

MODULE GRADED QUIZ: STARTED WITH EXCEL WEEK 01 ANSWER

Q1. A client has sent an Excel File for you to review. When you open the file, you notice that it has the words Compatibility Mode on the Title Bar beside the filename. What does this mean and what can you do if you are not sending the same file back to the client?

[expand title=View Answer] The file has been created in an older version of Excel and you should go to File, Info, and choose to convert it to a new Excel format.[/expand]

Q2. Excel gives you many quick shortcuts for adding data to the worksheet. You typed a date in cell A1, hovered over the square in the bottom right of the cursor, and then dragged it down. What feature have you used and what will the highlighted icon allow you to?

[expand title=View Answer]
1.The feature is called Autofill and the highlighted icon will allow you to reverse the process.
2.The feature is called Flash Fill and the highlighted icon will allow you to customize the entries.
[/expand]

Q3. You are having a conversation with a colleague who is more experienced with Excel. You mention that you sometimes find it difficult to completely empty a cell and that you will often use the delete option on the right-click menu option as a quick solution. Your colleague reminds you that if you use the delete on the right-click menu you are shifting cells on the worksheet and there is always a possibility that figures would then line up under the wrong heading. They recommend using the Clear button on the Home Ribbon instead. What can you delete using this button? Select all options that apply.

[expand title=View Answer]
1.Clear the content but leave the formatting and comments in place.
2.Clear all contents, comments, and formats.
3.Clear only the comments or notes on a cell.
4.Clear the formatting only.
[/expand]

Q4. You are working on an Excel file that other people in your department also have access to. While checking a worksheet updated by a colleague, you notice that they have manually formatted a heading. You like the changes they have made and would like to format the two new headings you have just typed in your worksheet in a similar way. What would be the quickest way for you to do this?

[expand title=View Answer] Position the cursor on the heading formatted by your colleague. Double-click on the Format Painter button on the Home Ribbon. Move the mouse pointer to the first of the new headings you have just typed in your worksheet and click the mouse button. Move the mouse pointer to the second heading and click again. Click on the Format Painter button again. [/expand]

Q5. You need to format a block of financial information so that the figures are showing the correct currency symbol. How can you do this? Select all options that apply.

[expand title=View Answer]
1.Click on the Number Format drop-down in the Number group on the Home Ribbon and choose Currency.
2.Right-click on the cell and choose Format Cells.
[/expand]

Q6. You are creating a spreadsheet to track new stock. Each product that you are listing will be assigned a category code which will simply be two letters. You can see that Column G is not wide enough to fully display the heading Sales Category. As the entries underneath the heading will only ever be two letters, you do not want to widen the column. How can you format the heading so that both words will be visible?

[expand title=View Answer] Use the Wrap Text feature. [/expand]

Q7. Question 7 You have created a workbook containing several sheets of information for a client. You would like to change some information, and you decide that a Search and Replace would be the quickest way to do this. When you go to Home, Find and Select and then click on Find what options are you given in the Find dialog that can make your search quicker and more efficient? Select all options that apply.

[expand title=View Answer]
1.You can specify worksheet names to limit the search to a subset of the worksheets in the file.
2.You can search for entries formatted in a particular way.
3.You can perform a search that looks through the whole workbook.
4.You can limit the search to any notes or comments that might have been added.
[/expand]

Q8. You have created a worksheet that contains many technical terms, and you decide to run the spellcheck feature to make sure that everything is spelled correctly. When the spellchecker begins, you realize that it is checking in the wrong language. How can you quickly change the?

[expand title=View Answer] In the Spellchecker dialog, click on the Dictionary Language drop-down and change to the correct dictionary. [/expand]

Q9. You are updating a worksheet and the cursor is currently on D3. The data in the sheet ends in column E and in row 8. This is the only content in the spreadsheet. If you go to the Page Layout ribbon and use the Breaks command to add a manual page break, how many pages would you have in the worksheet?

[expand title=View Answer]One[/expand]

Q10. You have a worksheet that contains a detailed breakdown of figures. At the top of the worksheet is a summary. In the Print Setup options dialog which setting should you adjust to print only the summary?

[expand title=View Answer] Change the Print Area setting. [/expand]

Knowledge Check: Working with formulas and functions quiz answer

Q1. What does the highlighted Fx command do in Excel?

[expand title=View Answer] Opens the Insert Function dialog. [/expand]

2. Which of these mathematical symbols has the highest precedence in Excel?

[expand title=View Answer]/ (Divide) [/expand]

3. You have typed the following Formula into your Worksheet. What does the $ symbol guarantee in the A4 Cell Reference?

[expand title=View Answer] It means that if the Formula is copied or moved, the Column Initial will stay the same. [/expand]

4. Where can you find the AutoSum Function? Select all options that apply.

[expand title=View Answer]
1.In the Editing group on the Home Tab
2.On the Formulas Tab
[/expand]

5. Where can you find the Calculate Now command?

[expand title=View Answer] On the Formulas Tab [/expand]

Knowledge check: Sorting and filtering data quiz answer

Q1. You have clicked on the Sort button and the following message appears. If you select the highlighted choice, what will happen?

[expand title=View Answer] Excel will use the column that you have highlighted as the key to the Sort. [/expand]

.

Q2. Why is this highlighted check box in the Sort dialog so important?

[expand title=View Answer] Excel uses this to decide on the dimensions of the block of data. [/expand]

.

Q3. When you open a file sent by a colleague, you notice that the row numbers on the left-hand side are in blue. What does this mean?

[expand title=View Answer] The data has been Filtered [/expand]

Q4. You have a block of data that contains a list of addresses in one Column. You would like to filter the data based on a particular location, which would be a part of the address. What is the quickest way to Filter so that you only see the Rows where that area is mentioned in the address?

[expand title=View Answer] Use the Text Filters option on the drop-down Filter list. [/expand]

Q5. When you open a File, you realize that there are several Filters in place, so you are not seeing all the rows in the data. How can you clear the Filters? Select all options that apply.

[expand title=View Answer]
Click on each Filter drop-down arrow and use the Clear Filter option.

Use the Clear command in the Data Tab.

Right-click and choose “Clear All” on the Shortcut Menu.

Turn off the Filter feature.
[/expand]

Knowledge check: Apply range in Excel quiz answer

Q1. Where is the Name Box on the Excel screen

[expand title=View Answer]To the left of the Formula Bar [/expand]

Q2. You want to apply a Range Name to a block of cells. Which of the following statements are true? Select all options that apply.

[expand title=View Answer]
1.The Name can contain a mixture of text and numbers.
2.The Name cannot contain spaces.
[/expand]

Q3. You are creating a Formula and would like to use a Name that you’ve previously created in the calculation. When the Autocomplete suggestion list appears, what symbol will be beside the Name in the drop-down list?

[expand title=View Answer] 1 [/expand]

Q4. You created a Formula that contains both Cell References and a Name. You are about to copy the Formula. If you want the formula to remain unchanged in its new location, where do you need to put Dollar Signs?

[expand title=View Answer] On the Cell References only [/expand]

Q5. Which option would you use to remove a Name from the File if you no longer need it?

[expand title=View Answer] The Name Manager dialog [/expand]

Knowledge check: Specialized functions quiz answer

Q1. you are typing a Function Formula and the floating Screen Tip is visible. Some of the words in the Screen Tip are enclosed in square brackets. What do these indicate?

[expand title=View Answer] Those pieces of information are optional in the Formula[/expand]

Q2. When you create a Formula in Excel, you see the calculation on the Formula Bar and the results in the Worksheet. If you want to see the Formulas in the Worksheet, where can you find the Show Formulas command?

[expand title=View Answer] On the Formulas Tab[/expand]

Q3. What is a Nested Function?

[expand title=View Answer]A Function used inside another Function [/expand]

Q4. You are adding a function formula to your worksheet. When the Formula is complete, apart from the Function name what other characters must it include? Select all options that apply.

[expand title=View Answer]
An Equals Sign

An opening and closing parenthesis

Commas
[/expand]

Q5. Question 5Where can you find a complete list of available functions? Select all options that apply.

[expand title=View Answer]
On the Formula Tab

In the Insert Function dialog
[/expand]

Knowledge check: Text functions quiz answer

1. does the number 3 indicate in this Formula?

[expand title=View Answer] That the Formula should return 456 [/expand]

2. What does the TRIM Function do?

[expand title=View Answer] Removes all spaces from a piece of text, except for the spaces between words.[/expand]

3. Which Functions can change the case of the letters in a text string? Select all options that apply

[expand title=View Answer]
PROPER

LOWER

UPPER
[/expand]

4. What would the result of this TEXTJOIN Formula be?

[expand title=View Answer] JohnSmith [/expand]

5. You are entering a TRANSPOSE formula to swap a vertical range of Cells to a horizontal. What keys do you press to finish the Formula?

[expand title=View Answer] Ctrl + Shift + Enter[/expand]

Knowledge check: Logical functions quiz answer

Q1. What does the following logical operator mean?

[expand title=View Answer] Is Not Equal To[/expand]

2. What outputs can a Logical Function produce? Select all options that apply.

[expand title=View Answer] True [/expand]

3. What will the result of this Formula be?

[expand title=View Answer] TRUE [/expand]

4.What will the result of this Formula be?

[expand title=View Answer] 15,000 [/expand]

5. What will the result of this Formula be?

[expand title=View Answer] Sunday [/expand]

Module graded quiz: Working with functions quiz answer

Q1. You have been asked to check stock levels for a product which is in high demand. There are two lists of customers who would like to purchase as many items of this product as possible. Which formula below would work out the correct answer of 6 per customer?

[expand title=View Answer]
1. =(A3+B3)/(D3+E3)
2. =C2*A2

[/expand]

3. Functions are a useful and vital part of Excel. Excel contains over a hundred of these predefined formulas which range from the simple and straightforward to the very complex. Which of the following must every function formula contain? Select all options that apply.

[expand title=View Answer]
1.A pair of parentheses
2.The Function name
[/expand]

4. You are working with this block of data and need to sort it. What kinds of sort can you do with this information? Select all options that apply.

[expand title=View Answer]
A Sort-by-Date Order

A sort based on a partial text entry, such as Shoes in column C

A Numeric Sort

An Alphabetical Sort
[/expand]

5. You are sent a worksheet by a colleague, and you notice an error message. You need to fix this issue so what is likely to be the cause of this message?

[expand title=View Answer]Your colleague has used an incorrect character in the cell Name. They should have used space instead of the underscore [/expand]

Knowledge check: Create and modify tables quiz answer

1. Which Excel Ribbon contains the command to transform a block of data into a Table?

[expand title=View Answer] The Insert Ribbon [/expand]

2. You have created a Table that starts in cell A1 and extends down as far as D20. If you put your cursor in A21 and begin typing, what would you expect to happen?

[expand title=View Answer]The bottom border of the Table will drop down to incorporate the cells A21 to D21.[/expand]

3. You have created a Table and it currently has the default blue and white banded color scheme. If you wish to change this color scheme quickly or customize it, where will you find the commands to do this?

[expand title=View Answer] On the Table Styles section of the Table Design Ribbon [/expand]

4. if you switch on the Total Row feature in a table, what Function is used to create the results that appear?

[expand title=View Answer] SUM [/expand]

5. When this symbol appears what does it allow you to do?

[expand title=View Answer] Resize the Table [/expand]

Knowledge checky: Table references quiz answer

1. When you are naming Tables, which of the following rules do you need to observe? Select all options that apply.

[expand title=View Answer]
1.The name must not be used anywhere else in the workbook.
2.The name cannot contain spaces.
[/expand]

2. Where in Excel can you see a list of all the Tables that exist in the workbook?

[expand title=View Answer] In the Name Manager dialog [/expand]

3. If you are creating a formula that references Table information, what kind of parentheses are used in a Structured Reference?

[expand title=View Answer] [ ] [/expand]

4. What is the main difference between the SUBTOTAL Function and the DCOUNT Function?

[expand title=View Answer] The DCOUNT Function allows you to set criteria.[/expand]

5. Where can you find the command to convert a Table back to a Range?

[expand title=View Answer] In the Tools section of the Table Design Ribbon. [/expand]

Knowledge check: Visualizing data with basic charts quiz answer

1. You decide to visualize your data by adding a Pie Chart to your Worksheet. Which of the following methods can you use to add in the chart? Select all options that apply.

[expand title=View Answer]
Go to the Charts group of the Insert Ribbon and click on the Pie Chart Icon.

Use the options button on the Charts group to open the Insert Chart Dialog.
[/expand]

2. You have already created a Chart in your worksheet. You add some new information to the data that you based the Chart on. How can you include this new data in the Chart?

[expand title=View Answer] Select the chart and drag the resize handles to include the new data.[/expand]

3. Once you have created a Chart from your data, what would the highlighted button allow you to do?

[expand title=View Answer] You can use it to add new elements to enhance your Chart. [/expand]

4. You have added a Chart to your worksheet and want to make it stand out more. You decide to use the Chart Styles feature to do this. Which ribbon will you find this feature on?

[expand title=View Answer] The Chart Design contextual ribbon[/expand]

5. You have created a Chart from data that shows company revenue steadily rising over the last six months. You decide to add a Trendline to the Chart, to make this pattern clear to anyone viewing the Chart. Which type of Trendline should you choose?

[expand title=View Answer]Linear [/expand]

Knowledge Check: Analyzing data quiz answer

Q1. Where would you find the command to insert a Pivot Table?

[expand title=View Answer] In the Tables section of the Insert Ribbon [/expand]

2. When you click to create a Pivot Table, where is the Pivot Fields Pane?

[expand title=View Answer]On the right-hand side of the Excel Screen 3. [/expand]

3. If you move one of the field headings into the highlighted box, what will happen?

[expand title=View Answer] Excel will perform calculations on the field data. [/expand]

4. You have added a Slicer to your worksheet to filter the results generated in the Pivot Table. Which of the following settings can you customize for Slicers? Select all options that apply.

[expand title=View Answer]
The color
The size
[/expand]

5. You have created a Pivot Table, totaling the company revenue for the last six months. In which situation would you use the options in the highlighted tab?

[expand title=View Answer] You would use it to change the formatting of the figures generated by the Pivot Table. [/expand]

Knowledge Check: Managing large workbook quiz answer

Q1. When you are naming Sheets, which of the following rules do you need to observe? Select all options that apply.

[expand title=View Answer]
1.The name cannot exceed 31 characters.
2.The name can contain spaces.
[/expand]

2. You would like to copy a sheet from one workbook to another. What guidelines do you need to keep in mind? Select all options that apply.

[expand title=View Answer]
1.You must tick the “Create a Copy” checkbox.
2.The two workbooks must be open.
[/expand]

3. In this worksheet, if you use the Freeze Panes choice while the cursor is in the cell shaded yellow, what areas of the worksheet will stay static?

[expand title=View Answer] Row 1 and Columns A and B [/expand]

4. Where will you find the command to Split the work window so that you can see different areas of the worksheet?

[expand title=View Answer] On the View Ribbon [/expand]

5. If the Title Bar of the Excel screen shows the following, what does it mean?

[expand title=View Answer] That the number 1 is part of the filename [/expand]

Module graded quiz: Organizing and visualizing data quiz answers

Q1. You are tracking sales data for the team that you manage and have already typed in some of the data. A colleague suggests that rather than typing it as a plain data list, you could format it as a Table. What extra functionality will be possible if you make this list into a Table? Select all options that apply,

[expand title=View Answer]
1.The Table can be named and referred to from anywhere in the workbook.
2.You can make the data easier to read with banded colors.
3.The Table will be dynamic.
[/expand]

2. You are creating formulas in your workbook that refer to a named Table on a different worksheet. What is the following formula calculating?

[expand title=View Answer] This is calculating a total for a column called Sales in a worksheet called Transactions. [/expand]

3. You are about to attend a weekly meeting with the Sales team that you manage, and you want to check who has been meeting their target so far this week. You need to create a formula in G5 in this Table which will calculate this for you. Which of the following is the correct calculation to do this?

[expand title=View Answer] =(Sales-Target) [/expand]

4. You are renaming a worksheet to reflect its contents. You want to rename it ClientsPurchasingHistory – January/May. Which elements in this name will Excel have difficulty with? Select all that apply.

[expand title=View Answer]
1.You have used spaces.
2.The name is too long.
[/expand]

5. You have been sent an Excel file by a colleague and you are reviewing the formulas that have been added to the worksheet. One of the cells contains the following formula:

[expand title=View Answer] This is the name of a sheet. [/expand]

6. You are reviewing a workbook that was prepared by a colleague. Some confidential figures are not included in any of the sheets in the workbook. Because of the confidentiality of the figures, you wonder if your colleague has hidden the worksheet that they are on. How can you check if this is the case

[expand title=View Answer] Go to the Home Ribbon and click on the Format drop-down. Move to the Visibility Section and choose unhide sheet from the sub-menu. [/expand]

7. You have created a Chart showing the sales achieved by each member of your team. Just before you are about to present this Chart at a meeting with your manager, one of the team calls you to say that they have received orders from two new customers. You want the Chart to show the details of these new orders. What do you need to do to ensure that the Chart shows the correct information?

[expand title=View Answer] Delete the Chart. Amend the source and then highlight it and add the Chart again.[/expand]

8. You are preparing for a meeting with your manager to discuss how each member of the Sales Team is performing versus the target set for the team. To help make the picture clear, you have transformed the figures into a chart. One of the team members has outperformed her colleagues and you would like to format that result in a different color so that it stands out. What are the correct steps to do this? Select all options that apply.

[expand title=View Answer] Click on Leah’s result so that all the blue data series columns are selected. Click again so that only Leah’s result is selected. Go to the Chart Format Ribbon and click on Format Selection. Change the color in the Format Data Point Pane. [/expand]

9. You have been asked to create a summary of the sales figures achieved by your team and decide to create a Pivot Table to do this. The data is organized under the following headings:

You need the Pivot table to show you the overall sales total and the amount achieved by each person on the team. You also want to be able to see what percentage of the overall total each salesperson achieved, and you need to be able to filter by their name. You will be dragging the headings into the Pivot Table Task Pane.

What steps do you need to take to design the Pivot Table to give you this information? Select all options that apply.

[expand title=View Answer]
1. Add Weekly Sales to the Values box. Go to the Value Field Settings dialog and change the Show Values As setting to % of grand total.
2.You add the staff member’s name to the Rows box.
[/expand]

10. What do the buttons on a Slicer represent?

[expand title=View Answer] Unique entries that exist within the Field that the Slicer is based on [/expand]

Knowledge check: Conditional formatting quiz answer

Q1. Where would you find the command to set Conditional Formats for a cell?

[expand title=View Answer]In the Styles group on the Home Ribbon [/expand]

2. You can create multiple Conditional Format rules to the same cell.

[expand title=View Answer]True [/expand]

3. You want to add a Conditional Format rule to a block of cells which would highlight all values over 10,000. Which of the following quick-choice menus should you use on the Conditional Formats drop-down?

[expand title=View Answer] Highlight Cell Rules[/expand]

4. You would like to check if there are any Conditional Format rules applied to a particular block of cells. Where can you find the Rules Manager which will allow you to do this?

[expand title=View Answer] The Manage Rules option at the bottom of the Conditional Formats drop-down. [/expand]

The Format Cells Dialog

5. You have set three Conditional Format rules on the same cell. You want to ensure that if the criteria in the first rule is met, then only that rule will be enforced. Which setting controls this in Conditional Formatting?

[expand title=View Answer] The Stop if True checkbox. [/expand]

Knowledge check: Enhancing and managing workbook quiz answers

Q1. You are working on a spreadsheet in collaboration with a colleague who works a different shift to you. You have a question that you would like to ask about some of the content in the worksheet. You would like your colleagues to see this question as soon as they open the workbook, and you would like them to be able to leave a reply. Which Excel feature would be the best for this?

[expand title=View Answer] Comments[/expand]

2. How do you know that there is a Comment on a cell when you look at the worksheet?

[expand title=View Answer] There is a red triangle in the top right corner of the cell.[/expand]

3. You and your colleague have been having a conversation using the Comment feature in a worksheet. You would like to close a conversation but keep a record of it. Which of these would be the best approach?

[expand title=View Answer] Click on the ellipsis in the original comment and choose Resolve Thread.[/expand]

4. You would like to remove all personal information from a Workbook before you send it to a different department. Which Excel feature would you use for this?

[expand title=View Answer] The Document Inspector.[/expand]

5. Every Excel workbook contains metadata information that is stored in the file as it is being created. This information is known as Document Properties. Which of the following pieces of information are recorded?

[expand title=View Answer]
The date the file was originally created.
The original author of the file.
[/expand]

Knowledge check: Customize the Excel environment quiz answer

Q1. Where can you position the Quick Access Toolbar on the Excel Screen?

[expand title=View Answer] Below the Ribbon Area. [/expand]

2. You cannot add a command to an existing Ribbon – True or False?

[expand title=View Answer] False [/expand]

3. You have already used the Spellcheck feature to check your worksheet. You notice that a title that is in block capitals is incorrect, but Excel has not flagged it. What has gone wrong?

[expand title=View Answer] The “Ignore Words in Uppercase” checkbox in the Proofing options is ticked.[/expand]

4. You would like to customize the color the Excel uses for the Error Indicator in Excel. Where do you go to do this?

[expand title=View Answer] File, Options, General. [/expand]

5. You would like to add a command to a Ribbon but when you go into the File, Options, Customize Ribbon dialog you cannot see it on the list of commands on the left-hand side. What should you do?

[expand title=View Answer] Change the Choose Commands From choice to All. [/expand]

Knowledge check: Exporting and sourcing data quiz answers

Q1. You have created a file in Excel which you are now intending to save in a different file format. Which of the following formats will remove all formatting from the exported file?

Select all options that apply.

[expand title=View Answer]
1.CSV
2.TXT
[/expand]

2. If you are choosing a format to export your Excel data to, which of the following results do the CSV, PDF, and TXT formats have in common?

[expand title=View Answer] They all remove formatting[/expand]

3. What is the name of the grouping in the Data Ribbon that contains all the commands to access external data?

[expand title=View Answer] Get Data[/expand]

4. You used the Get Data command to import data from another file format. The data has been loaded into the current Excel worksheet and the Query Editor is visible on the right-hand side of the work screen. If you click on the highlighted choice, what will happen?

[expand title=View Answer] The Data will no longer be a table, but it will maintain the Query and the link to the original source file to allow for automatic refresh.[/expand]

Module graded quiz: Advanced Excel features quiz answer

Q1. You are working offline on some important Excel files which are saved on your PC. Your area has been subject to unexpected power cuts. How can you ensure that you do not lose any important data if a power cut happens?

[expand title=View Answer] Go to File, Options, Save, and Tick the AutoRecover checkbox. [/expand]

2. The worksheets that you create typically contain many Charts. As the files will be circulated to a wide audience in the organization, you want to add Alternative Text to Charts as you create them. To speed up this process, you decide to have the Alt+Text option as a separate button on the Review Ribbon. Once you have begun the process by going to File, Options, and Customize Ribbon, you cannot see Alt Text as a choice in the left-hand list. What steps do you need to take to successfully add Alt+Text to the Review Ribbon?

[expand title=View Answer] Click on the “Choose Commands From” drop-down. Change the choice from Popular to All. Locate and select Alt+Text. With the Review Ribbon selected in the list to the right, click on the New Group choice. Type a name and press enter. Click the Add button between the two lists to position Alt+Text in the group. [/expand]

3. You have created a worksheet that tracks the sales made by the Sales Team. You saved it in OneDrive and shared it with the team members. You have asked them to update their sales figures on an ongoing basis. You would like to create a Conditional Format rule so that you can check this file at any time and be immediately aware of the top three sales figures. What would be the most efficient way to do this?

[expand title=View Answer]Select the cells where the sales figures will be entered. Go to Home, Conditional Formatting, and Choose from Top/Bottom Rules. [/expand]

4. The Manage Rules box allows you to monitor and control the Conditional Format rules set for any cell. Which of the following are settings you can control using Manage Rules?

[expand title=View Answer]
Edit a Rule

Copy a rule to apply to another block of Cells.

See what rules are applied to a cell.

If there are multiple rules, stop Excel processing the list at a certain point
[/expand]

5. You created a spreadsheet to track your team’s Sales achievements. Now you want to create a Conditional Format Rule on the Weekly Sales column. You want it to change the color of the cell in Column E when the value in it matches or exceeds the target figure in column F. How would you do this?

[expand title=View Answer] Select E5 to E15. Click on Home, Conditional Formatting, New Rule, and use the Format All Cells Based on Their Values choice. [/expand]

6. You have been collaborating on a worksheet with a colleague and you have both contributed to a Comment thread. You decide that the conversation should be closed. You need to keep the Comments until the final review of the worksheet is completed by a more senior colleague. What would you do to indicate that the conversation is closed?

[expand title=View Answer]Resolve the Comment Thread.[/expand]

8. You have imported Data from an Access Database into your Excel Workbook. The Query Editor window is visible on the right-hand side of the Excel screen. Now that you have imported the data in your worksheet, you will only be working on it in Excel. You’re aware that colleagues amend the original data in Access regularly, but you do not need to see those changes in the Excel copy. What should you do to ensure that the data you have brought into Excel does not update when your Colleagues change the source?

[expand title=View Answer] In the Table Design Ribbon, click on the Convert to Range choice in the Tools Group.[/expand]

9. A client has asked you to send information to them in a CSV format that they can import into their own accounting system. Which of the following statements are true in relation to the file you are sending to the client?

[expand title=View Answer]
The file will only contain plain text.

The file will only contain information from one Excel sheet.

The columns will be separated by a Tab character.
[/expand]

10. You have already created the CSV copy of the Excel file that the customer has requested. You decide to also send a PDF copy of the original file so that your customer can see the original layout. Which series of steps would be correct to complete this action?

[expand title=View Answer] Click on File, Share, and click on the PDF icon. [/expand]

Work Smarter with Microsoft Excel Course Review:

In our experience, we suggest you enroll in Work Smarter with Microsoft Excel courses and gain some new skills from Professionals completely free and we assure you will be worth it.

Work Smarter with Microsoft Excel course is available on Coursera for free, if you are stuck anywhere between a quiz or a graded assessment quiz, just visit Networking Funda to get Work Smarter with Microsoft Excel Coursera Quiz Answers.

Get All Course Quiz Answers of Microsoft 365 Fundamentals Specialization

Work Smarter with Microsoft Word Coursera Quiz Answers

Work Smarter with Microsoft Excel Coursera Quiz Answers

Work Smarter with Microsoft PowerPoint Coursera Quiz Answers