Which Excel feature can summarize the data in a large table?
Names are entered in cells A2:A500 and quantities are entered in cells B2:B500.
To calculate the total quantity for the person named "Wilson", I would use the ___________________ worksheet function.
To create a list of unique items, based on a list that contains many duplicate entries, which Excel feature would you use?
You want to create a drop down list in a cell, so users can select from a list of products. Which Excel feature should you use?
The sales tax rate is in cell H2. Sales totals are in cells B2:B20.
To calculate the tax on each sale, you'll enter a formula in cell C2, to multiply the sales total in B2, by the sales tax rate.
Then, you'll copy the formula down to cell B20.
Which formula should you use?
Have you just finished your training in Microsoft Excel and are looking to test out your understanding? The practice test below is set to test how well you can use excel effectively. Give it a try and ensure to read up on...
Microsoft excel quiz: test on functions! Microsoft Excel is considered to be one of the most diverse Microsoft office tools as it not only allows calculations but can also allow processing of different sets of data. Are you...
Questions: 10 | Attempts: 59008 | Last updated: Nov 19, 2020
Do you want to become familiar with Microsoft Excel? Do you think you can pass this quiz? Microsoft Excel helps to organize information in an easy to navigate way. It does complicated math problems so that you don’t have...
Questions: 10 | Attempts: 44121 | Last updated: Feb 12, 2021