Welcome to your Excel Online Test 11
Total number of questions are 10
1. What will be the result of the formula shown in the image below?
2. Which function will be used to sum only the visible cells as seen in the image below?
3. What is the correct syntax of the Excel SEQUENCE function?
4. Can the SEQUENCE function generate descending sequences?
5. Cell A1 contains the number '13250.669,' what formula can be used to round it to the nearest whole number?
6. Can the ABS function (absolute value) be used with non-numeric values?
7. Which Excel feature enables you to select or highlight all cells containing formulas from the options below?
8. What Excel formula would you use to find the average of values in cells A1 to A5
9. Which function will be used to sum cells A1:A5 in the image below?
10. A 'Subtotal' option is part of which menu or ribbon