DCA 103 (MS EXCELL)

1. What is Microsoft Excel?

2. What is the default file extension for an Excel workbook?

3. The first cell in excel worksheet is labelled as___?

3. The intersection of a column and a row in a worksheet is called____

4. How many sheet are there in excel workbook by default?

5. Excel display the current cells address in the ____?

6. In Microsoft Excel spreadsheets, rows are designated as _______.

7. Default file name in MS Excel is?

8. Which Excel feature is used to automatically fill a series of data based on a pattern?

9. How do you merge two or more cells in Excel?

10. What function is used to calculate the sum of a range of cells?

11. How do you start a formula in Excel?

12. function is used to count the number of numerical values in a range?

13. What is an Excel Spreadsheet?

14. What is an Excel Worksheet?

13. What is an Excel Range?

14. Which function is used to calculate the average in a range of cells?

15. Which shortcut key is used to save an Excel workbook?

16. What does the VLOOKUP function do?

17. What does the Freeze Panes feature do?

18. What is an Excel Chart?

19. What is the Excel Ribbon?

20. What is the Excel formula for calculating percentage?

21. How can you quickly select an entire column in Excel?

22. What does the NOW() function return?

23. Which function is used to find the largest value in a range?

24. What does the IF function do?

25. In the formula, which symbol specifies the fixed columns or rows?

26. How are data organized in a spreadsheet?

27. What is the use of a horizontal Scroll Bar in MS Excel?

28. How many characters can be typed in a single cell in excel?

29. Which key is used to make multiple line in a single cell

30. Minimum zoom size ub ms excel is ?

31. What is the row limit of MS Excel?

32. ____ is the correct syntax of IF() Function.