Gauge
I. Directions: Read Carefully each item. Use a separate sheet for your answers. Write only the
letter of the best answer for each item.
For items 1-5, analyze and interpret the graph in figure 1
Annual Sales Growth
30.0%
20.0%
10.0%
0.0%
-10.0%
-20.0%
-30.0%
-40.0%
Figure 1
2011-12 sales growth %
2012-13 sales growth %
2013-14 sales growth %
2014-15 sales growth %
-Co. A
-Co. B
-Co. C
-Co. D
-Co. E
1. Which company have 0% increase in sales?
A. Company A
B. Company B
C. Company C
D. Company D
2. Which company is at risk of bankruptcy?
A. Company B
B. Company C
C. company D
D. Company E
3. Which company is the best choice if you are to invest based on annual sales growth?
A. Company A
B. Company B
C. Company D
D. Company E
4. Which company had a constant decrease of sales growth for the past 4 years?
A. Company A
B. Company B
C. Company D
D. Company E
5. Which company have experienced fluctuating annual sales growth?
A. Company A
B. Company B
C. Company C
D. Company E
II. Directions: Write TRUE if the statement is correct, write FALSE if otherwise.
6. One of the main reasons why business owners use Excel is for handling data,
7. The intersection of the column and row is called Cell.
8. A workbook is also called spreadsheet.
9. When you click the menu bar, you will see the toolbar.
10. The filename of the spreadsheet can be seen in the title bar.
11. The column heading is named by a letter or a combination of letters.
12. A workbook has three worksheets as default setting.
13. The menu bar displays all the menus in vailable for use in excel.
14. The name box shows the information in a current cell.
15. The Formula bar shows the address of the current selection or active cell.
III. Give at least 5 advantages of using Excel in computing and presenting business data.
