Excel Microsoft 365 Study Guide Exam Fully Answered.

When would you use Excel for a task? - Answer when creating a list of employees with their ID numbers (Excel is commonly used for creating and maintaining lists). You are working in your company's "2018 Sales" Workbook with each column widened and a color graph. When you add a worksheet "2018 Profit," how will the new worksheet appear? - Answer with the same formatting as "2018 Sales" before you made any changes A user wants to quickly format a cell and right-clicks the cell to use the features seen in the image. Which Excel tool is being used? - Answer Mini Toolbar You would like to add some frequently used buttons to the Quick Access Toolbar. How can you do this? - Answer Right-click the button on the ribbon and select Add. You are using a button on the ribbon, and you are interested in learning more about its functionality. How can you access "Tell me more"? - Answer Hover over the button, then click Tell me more at the bottom of the information displayed. You want to add an average in the worksheet shown below. You want to learn more about the average function in Excel and think that a video will assist you. How can you access training from the workbook? - Answer Click Help from the menu bar. What is the difference between a workbook and worksheet? - Answer A workbook is the file and a worksheet is the individual tab within the workbook. You are adding dates in the spreadsheet shown below. What will happen when you press Enter after entering the date as shown in cell C9? - Answer The date will appear as 8/1/2020 and will be right-aligned.