Are you ready to test your knowledge of Microsoft Excel Quiz Questions and master essential text functions? This post features 20 multiple-choice Microsoft Excel Quiz Questions and Answers designed to help you sharpen your skills in handling text data, reference, range, conditional formatting, and dashboards in Excel. Whether you are a beginner or looking to refresh your knowledge, this quiz covers the basics of MS Excel text functions like UPPER(), LOWER(), and PROPER(), COUNT(), COUNTA(). Let us start with Microsoft Excel Quiz Questions now.
Microsoft Excel Quiz Questions and Answers
Microsoft Excel Quiz Questions and Answers
- What is one of the functions you can use to change the text case in your data?
- What does the Flash Fill feature have in common with the UPPER, LOWER, and PROPER functions?
- Which of the following tasks can Flash Fill do?
- Why do you need to use the Paste Values option when you paste contents from a helper row to the original row?
- Which of the following are valid sorting orders you can choose when adding sorting levels to your data?
- Which one of the following statements best describes the main purpose of a digital dashboard?
- According to the ‘Creating a Simple Dashboard using Excel’ video, what did subject matter experts advise when building dashboards?
- Which feature in Excel enables you to precisely control what information is displayed in a visualization such as a chart?
- Which of the following tasks should you perform before creating a dashboard?
- After importing a text file into Excel, some columns aren’t showing all the data. How can you fix all column widths at the same time?
- Which Excel feature helps divide a column that contains into two columns: ?
- Which of the following file types are not native Excel files but can be easily imported?
- Column B contains the named range, sales_price. Column C contains the named range, shipping_cost. What would be an appropriate formula to obtain the total of columns B and C in a single cell?
- Column C contains the named range, shipping_cost. Column D contains the named range, and location. What would be an appropriate formula to calculate the total shipping cost for all orders originating from the location of Sydney, given that location is the named range for column D?
- To quickly create a named range: highlight the data, including the heading, and press:
- Applying named ranges automatically embeds conditional formatting into your spreadsheet.
- What is the difference between the functions COUNT and COUNTA?
- Which of the following file types support macros?
- When using a formula to apply conditional formatting to a whole row, how should we refer to cell B34 in our formula?
- Which of the following are mixed cell references in Excel?
R Frequently Asked Questions with Answers