Home > Microsoft Excel > Quizzes > Basic Microsoft Excel Practice Test
Basic Microsoft Excel Practice Test
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 29% Most missed: “A circular reference is”
Microsoft Excel is a spreadsheet program that helps users store, organize, and manipulate data. It has many uses, including: Data analysis: Excel is a core tool for data analysis, which involves analyzing data to inform decision making. Formulas: Excel has formulas for every form of analysis. You can use formulas to solve simple and complex equations. Pivot tables: Pivot tables organize data into different number sets, which can make it easier to find data. Accounting: Excel supports processes like creating balance sheets, preparing financial statements, and setting budgets. Conditional... Show more
Basic Microsoft Excel Practice Test
Time left 00:00
25 Questions

1. You can use the format painter multiple times before you turn it off by
2. The name box
3. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
4. MS-EXCEL is based on ________
5. When a range is selected, how can you activate the previous cell?
6. How do you display current date and time in MS Excel?
7. What will be the output if you format the cell containing 5,436.8 as ‘#,##0.00’ ?
8. Which function is not available in the Consolidate dialog box?
9. You can use the formula palette to
10. You can move a sheet from one workbook into new book by
11. Which of the following is a correct order of precedence in formula calculation?
12. How can you find specific information in a list?
13. Right clicking something in Excel:
14. Which of the following will not cut information?
15. An excel workbook is a collection of
16. Text formulas:
17. Which of the following is not a worksheet design criterion?
18. Which of the following format you can decide to apply or not in AutoFormat dialog box?
19. Status indicators are located on the
20. Comments can be added to cells using ________
21. What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
22. To return the remainder after a number is divided by a divisor in EXCEL we use the function?
23. How do you delete a column?
24. The spelling dialog box can be involved by choosing spelling from ________ menu.
25. You can enter which types of data into worksheet cells?