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. Which function will be used to sum cells A1:A5 in the image below?
4. What is the correct syntax of the Excel SEQUENCE function?
5. Can the SEQUENCE function generate descending sequences?
6. What will be the result of the formula shown in the image below?
7. What Excel formula would you use to find the average of values in cells A1 to A5
8. Cell A1 contains the number '13250.669,' what formula can be used to round it to the nearest whole number?
9. A 'Subtotal' option is part of which menu or ribbon
10. Which Excel feature enables you to select or highlight all cells containing formulas from the options below?
