Gell All Weeks Work Smarter with Microsoft Excel Coursera Quiz Answers
Table of Contents
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?
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?
ViewIn-Page Setup on the Print Options in Backstage View
From a command on the Layout Tab.
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?
View5. 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.
ViewGET STARTED WITH EXCEL MODULE GRADED QUIZ
Q1. What is this highlighted area in the Excel screen called?
ViewQ2. If you wish to save your Excel file, what method can you use? Select all options that apply.
ViewFile, Save
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?
ViewQ4. What types of data can you type into an Excel Cell? Select all options that apply.
ViewText and numbers together
Date and time entries
Numbers
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.
View2.Decrease the Margins
3.Add a Manual Page Break into the content on your Worksheet.
Knowledge check: Modify a worksheet quiz answers
- What kind of Format would the highlighted command on the Home Tab apply to numbers?
2. You type some numbers into the Worksheet and see the following symbols appear in a cell. Why have they appeared?
View3. 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?
View4. You want to apply a Range Name to a block of cells. Which of the following statements are true? Select all options that apply.
View2.The Name must be unique.
3.The Name can contain a mixture of text and numbers.
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.
View2.Search the whole workbook.
Knowledge check: get started with data quiz answer
Q1. What will the highlighted area of the cursor allow you to do?
ViewQ2. 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.
View2.Use the Shortcut Menu\
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?
ViewQ4. Where would you find the command button to clear content from a Cell or block of Cells in the Worksheet?
ViewQ5. 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
ViewMODULE 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?
ViewQ2. 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?
View2.The feature is called Flash Fill and the highlighted icon will allow you to customize the entries.
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.
View2.Clear all contents, comments, and formats.
3.Clear only the comments or notes on a cell.
4.Clear the formatting only.
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?
ViewQ5. 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.
View2.Right-click on the cell and choose Format Cells.
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?
ViewQ7. 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.
View2.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.
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?
ViewQ9. 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?
ViewQ10. 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?
ViewKnowledge Check: Working with formulas and functions quiz answer
Q1. What does the highlighted Fx command do in Excel?
View2. Which of these mathematical symbols has the highest precedence in Excel?
View3. You have typed the following Formula into your Worksheet. What does the $ symbol guarantee in the A4 Cell Reference?
View4. Where can you find the AutoSum Function? Select all options that apply.
View2.On the Formulas Tab
5. Where can you find the Calculate Now command?
ViewKnowledge 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?
View.
Q2. Why is this highlighted check box in the Sort dialog so important?
View.
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?
ViewQ4. 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?
ViewQ5. 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.
ViewUse the Clear command in the Data Tab.
Right-click and choose “Clear All” on the Shortcut Menu.
Turn off the Filter feature.
Knowledge check: Apply range in Excel quiz answer
Q1. Where is the Name Box on the Excel screen
ViewQ2. You want to apply a Range Name to a block of cells. Which of the following statements are true? Select all options that apply.
View2.The Name cannot contain spaces.
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?
ViewQ4. 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?
ViewQ5. Which option would you use to remove a Name from the File if you no longer need it?
ViewKnowledge 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?
ViewQ2. 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?
ViewQ3. What is a Nested Function?
ViewQ4. 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.
ViewAn opening and closing parenthesis
Commas
Q5. Question 5Where can you find a complete list of available functions? Select all options that apply.
ViewIn the Insert Function dialog
Knowledge check: Text functions quiz answer
1. does the number 3 indicate in this Formula?
View2. What does the TRIM Function do?
View3. Which Functions can change the case of the letters in a text string? Select all options that apply
ViewLOWER
UPPER
4. What would the result of this TEXTJOIN Formula be?
View5. 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?
ViewKnowledge check: Logical functions quiz answer
Q1. What does the following logical operator mean?
View2. What outputs can a Logical Function produce? Select all options that apply.
View3. What will the result of this Formula be?
View4.What will the result of this Formula be?
View5. What will the result of this Formula be?
ViewModule 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?
View2. =C2*A2
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.
View2.The Function name
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.
ViewA sort based on a partial text entry, such as Shoes in column C
A Numeric Sort
An Alphabetical Sort
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?
ViewKnowledge check: Create and modify tables quiz answer
1. Which Excel Ribbon contains the command to transform a block of data into a Table?
View2. 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?
View3. 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?
View4. if you switch on the Total Row feature in a table, what Function is used to create the results that appear?
View5. When this symbol appears what does it allow you to do?
ViewKnowledge 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.
View2.The name cannot contain spaces.
2. Where in Excel can you see a list of all the Tables that exist in the workbook?
View3. If you are creating a formula that references Table information, what kind of parentheses are used in a Structured Reference?
View4. What is the main difference between the SUBTOTAL Function and the DCOUNT Function?
View5. Where can you find the command to convert a Table back to a Range?
ViewKnowledge 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.
ViewUse the options button on the Charts group to open the Insert Chart Dialog.
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?
View3. Once you have created a Chart from your data, what would the highlighted button allow you to do?
View4. 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?
View5. 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?
ViewKnowledge Check: Analyzing data quiz answer
Q1. Where would you find the command to insert a Pivot Table?
View2. When you click to create a Pivot Table, where is the Pivot Fields Pane?
View3. If you move one of the field headings into the highlighted box, what will happen?
View4. 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.
ViewThe size
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?
ViewKnowledge 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.
View2.The name can contain spaces.
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.
View2.The two workbooks must be open.
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?
View4. Where will you find the command to Split the work window so that you can see different areas of the worksheet?
View5. If the Title Bar of the Excel screen shows the following, what does it mean?
ViewModule 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,
View2.You can make the data easier to read with banded colors.
3.The Table will be dynamic.
2. You are creating formulas in your workbook that refer to a named Table on a different worksheet. What is the following formula calculating?
View3. 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?
View4. 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.
View2.The name is too long.
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:
View6. 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
View7. 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?
View8. 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.
View9. 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.
View2.You add the staff member’s name to the Rows box.
10. What do the buttons on a Slicer represent?
ViewKnowledge check: Conditional formatting quiz answer
Q1. Where would you find the command to set Conditional Formats for a cell?
View2. You can create multiple Conditional Format rules to the same cell.
View3. 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?
View4. 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?
ViewThe 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?
ViewKnowledge 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?
View2. How do you know that there is a Comment on a cell when you look at the worksheet?
View3. 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?
View4. 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?
View5. 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?
ViewThe original author of the file.
Knowledge check: Customize the Excel environment quiz answer
Q1. Where can you position the Quick Access Toolbar on the Excel Screen?
View2. You cannot add a command to an existing Ribbon – True or False?
View3. 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?
View4. You would like to customize the color the Excel uses for the Error Indicator in Excel. Where do you go to do this?
View5. 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?
ViewKnowledge 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.
View2.TXT
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?
View3. What is the name of the grouping in the Data Ribbon that contains all the commands to access external data?
View4. 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?
ViewModule 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?
View2. 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?
View3. 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?
View4. 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?
ViewCopy 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
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?
View6. 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?
View7. Excel gives you two ways to add annotations to a cell in an Excel Workbook. You can add either a Note or a Comment to any cell. What features are available for Comments but not available for Notes?
Select all that apply.
ViewAdding a Reply.
Ability to use the @ symbol to notify someone of what has been said.
Date and timestamp.
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?
View9. 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?
ViewThe file will only contain information from one Excel sheet.
The columns will be separated by a Tab character.
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?
ViewWork 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