Page 214 - DCAP101_BASIC_COMPUTER_SKILLS

Unit 10: Microsoft Excel

6. To add two cells (A1 and A2) together you use the following formula Notes
(a) = A + A (b) = Add(A +A )
1 2 1 2
(c) = together(A :A ) (d) A plus A
1 2 1 2
7. To make a number in cell C1 10% smaller than the number in C3 you enter
(a) = C3*1.10 (b) + C3*110
(c) = C3%10 (d) = C3*.90

8. On an excel sheet the active cell in indicated by …
(a) A dark wide boarder (b) A dotted border
(c) A blinking border (d) None of these

9. On an Excel sheet the active cell in indicated by
(a) A dark wide border (b) A dotted border
(c) A blinking border (d) None of these
10. Using the F11 shortcut key to create a chart on chart sheet creates
(a) A default chart (b) A 2-dimensional column chart

(c) A 2-dimensional bar chart (d) A 3-dimensional line chart

10.12 Review Questions

1. What are some ways to use Excel?

2. How many rows and columns are there in an excel?
3. How many worksheets can an Excel workbook have?
4. What is the difference between Microsoft Excel and Microsoft Word?

5. What are the advantages of Microsoft Excel?
6. How do you explain a Microsoft Excel?
7. How much RAM is there in a Microsoft Excel?

8. How do you insert rows in an Excel sheet?
9. How many cells are there in a single Excel sheet?
10. What do you mean by naming a cell?

11. What are functions?
12. What are the advantage of using names?

13. What do you understand by Function Wizard?
14. What does it mean by Environment of Excel?
15. How do you create an Excel Worksheet?

Answers for Self-Assessments Questions
1. (c) 2. (a) 3. (a) 4. (a)

5. (b) 6. (a) 7. (d) 8. (a)
9. (a) 10. (b)

LOVELY PROFESSIONAL UNIVERSITY 207