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