10.30.2
- 1. How can you mix relative and absolute references in a formula?
- 2. What is an absolute cell reference in Excel?
- 3. What is a relative cell reference in Excel?
- 4. Explain the COUNT and COUNTA functions and their differences.
- 5. How does the AVERAGE function work in Excel?
- 6. How does the SUM function work, and give an example?
- 7. What is the difference between a formula and a function in Excel?
- 8. What are basic formulas in Excel and how are they written?
- 9. Explain the difference between ascending and descending sort.
- 10. How can you filter data in Excel using built-in filters?
- 11. How do you apply basic sorting in Excel?
- 12. What is conditional formatting and how can beginners use it?
- 13. How can you format numbers, currency, dates, and percentages in Excel?
- 14. Explain different formatting options such as font, color, and borders.
- 15. What is the purpose of cell formatting in Excel?
- 16. How can you insert or delete rows and columns in Excel?
- 17. What is the difference between active cell and selected cells?
- 18. How can you select an entire row, column, or a range of cells?
- 19. What is the difference between a row and a column in Excel?
- 20. What is a cell in Excel, and how is it identified?