Welcome to your Online excel assessment test
1. Which function is used to find the smallest number in a range of cells in Excel?
2. What does the function SUMIF do in Excel?
3. Which option is used to change the reference style in Excel from relative to absolute or mixed?
4. Which keyboard shortcut is used to open the 'Go To' dialog box in Excel?
5. What is the purpose of the 'PivotTable' feature in Excel?
6. Which function is used to round a number to the nearest integer in Excel?
7. What is the purpose of the 'IF' function in Excel?
8. What does the 'AutoFill' feature in Excel do?
9. Which function is used to count the number of cells in a range that meet multiple criteria in Excel?
10. What does the 'Freeze Panes' feature in Excel allow users to do?
