Excel Microsoft 365 Questions and Answers Already Passed

Excel Microsoft 365 Questions and Answers Already Passed **Q1: When should you use Excel for a task?** A. For creating presentations B. For designing graphics C. For listing employees with their ID numbers **Answer: C. For listing employees with their ID numbers** **Q2: You are editing the "2018 Sales" workbook, which has wide columns and a colorful graph. If you add a new sheet named "2018 Profit," what will its initial formatting be?** A. It will look like a default blank sheet B. It will have the same formatting as "2018 Sales" had initially C. It will copy the exact current formatting of "2018 Sales" **Answer: B. It will have the same formatting as "2018 Sales" had initially** **Q3: If a user right-clicks a cell to quickly format it using the options shown in the image, which Excel tool are they using?** A. Context Menu B. Mini Toolbar C. Ribbon Toolbar **Answer: B. Mini Toolbar** **Q4: How can you add frequently used buttons to the Quick Access Toolbar?** A. Click on File, then Options B. Right-click the desired button on the ribbon and choose Add C. Drag the button from the ribbon to the Quick Access Toolbar **Answer: B. Right-click the desired button on the ribbon and choose Add** **Q5: How can you find out more information about a button’s functionality on the ribbon?** A. Double-click the button B. Right-click the button and select Info C. Hover over the button, then click "Tell me more" at the bottom of the info box **Answer: C. Hover over the button, then click "Tell me more" at the bottom of the info box** **Q6: You need to insert an average in the worksheet below and want to watch a video to learn more about the average function. How can you access the training?** A. Press F1 for Help B. Click on the Help menu option C. Right-click on the cell and choose Help **Answer: B. Click on the Help menu option** **Q7: What distinguishes a workbook from a worksheet in Excel?** A. A workbook is the file, while a worksheet