Welcome to your Excel Online Test 10
Total number of questions are 15
1. The formula =SUM(A2:D2) in cell E2 is copied down the Total column. If I delete the values in the range A2:D6, how will this affect the formulas in the Total column?
2. What is the shortcut key to open the "Page Setup" dialog box?
3. How can you sum the values in cells A1 to G1.
4. In Excel, what does the function PMT stand for?
5. What will be the result of the formula shown in the image below?
6. You have a list of names in column A. You want to remove duplicate names from the list. What should you do?
7. In the image provided below, what is the result when you apply the keyboard shortcut 'Alt + =' to cell A8?
8. Which logical function returns TRUE if all arguments evaluate TRUE; FALSE if not?
9. What is the purpose of the IFERROR function in Excel?
10. What will be the result of the formula that appears in the image?
11. What is the function of the "PivotTable" feature in Excel?
12. Which chart type is best for showing the relationship between two sets of data in Excel?
13. What will be the result of the formula shown in the image below?
14. Which shortcut key is used to edit the active cell directly?
15. What is the shortcut to toggle the absolute and relative cell references in a formula in Excel?
