Excel Training Exam | 100% Correct Answers | Verified | Latest 2024 Version

There is a button on the ribbon, and you are interested in learning more about its functionality. How can you access "Tell me more"? - Hover over the button, then click "Tell me more" at the bottom of the information displayed. 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? - with the same formatting as "2018 Sales" before you made any changes What does it mean that the right mouse button is "context-sensitive"? - The menu items available will differ depending on the context of what you are right-clicking . You would like to add some frequently used buttons to the Quick Access Toolbar. How can you do this? - Right-click the button on the ribbon and select Add. You are working in the most recent version of Excel provided by your company. Why would you use the "Save as type" pulldown menu? - You are saving the file for someone with an older version of Excel. As you are entering sales data into a new worksheet, you inadvertently type 6/31/2019. Which action will Excel take with this? - Excel will display it as 6/31/2019 but left-justified and as only a set of numbers and dashes, and not an actual date