Welcome to your Excel Online Test 9
Total number of questions are 10
1. As shown in the image below, you have a list of sales quantities in column B and their corresponding prices in column C. You want to calculate the total revenue. Which of the following formulas should you use?
2. As shown in the image below, in cell B7, which formula should you use to calculate the total sales for the specific product 'Laptop'?
3. What is the correct syntax for the Excel IF function?
4. What will be the result of the formula as seen in the image below?
5. What happens if no values meet the specified criteria in a SUMIFS function?
6. In the image provided below, what is the result when you apply the keyboard shortcut 'Alt + =' to cell A8?
7. What will be the answer to the formula in the image below?
8. Which function is used to multiply corresponding elements in an array or ranges and then calculate the sum of those products?
9. In the image provided below, there is a list of fruits in column A, and your goal is to determine which formula is best for counting the occurrences of "Apple".
10. What is the purpose of the IFERROR function in Excel?
