Question

The cell at the cell pointer position is called a/an ___________

2. Microsoft Excel opens a ___________ by default.

3. An Excel worksheet consists of ______________ rows and ______________ columns.

4. To determine the number of cells that contain numbers we use _____________ function.

5. The keyboard shortcut key to remove the top border in MS Excel is

(a) ALT + B (b) ALT + V (c) ALT + T (d) ALT + SHIFT + V

6. ________________ is a feature in MS Excel which can be used to define the orientation of text in a

cell.

7. ________________ is considered to be the first electronic spreadsheet.

8. The cursor in MS Excel is known as the ______________

9. Name the indent that allows the text to extend outward the margins.

10. ______________ option provides the user to see how and what the documents looks like when it

would be printed.

11. A _____________ is a dot or any other symbol that is placed before text.

12. Pressing ___________ clears all formatting.

(a) SHIFT + Spacebar (b) CTRL + SHIFT + Spacebar (c) CTRL + Spacebar (d) ALT + Spacebar

Very Short Answer type Questions (2 marks each). Answer any 5 Questions:

13. What are the shortcut key combinations for the following?

(a) Insert a Comment (b) Merge a document

(c) Print the merged document (d) Preview a mail merge

14. Explain the use of the following:

(a) AVERAGE (b) MAX

15. Give an example each of Relative and Absolute referencing.

16. Write the steps to perform subtraction using a formula.

17. Explain the use of Function Wizard.

18. What is the function of Auto Fill feature?​

Answer 1

Answer:

8)This question answer is Select mode.

Hope this will help u.