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