Advanced Options
1. Which elements of a worksheet can be protected from accidental modification?
A.  Contents B.  Objects C.  Scenarios D.  All of the above
2. Which Chart can be created in Excel?
A.  Area B.  Line C.  Pie D.  All of the above
3. Which language is used to create macros in Excel?
A.  Visual Basic B.  C C.  Visual C++ D.  Java
4. Which would you choose to create a bar diagram?
A.  Edit, Chart B.  Insert, Chart C.  Tools, Chart D.  Format, Chart
5. What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
A.  XY Chart B.  Line Chart C.  Pie Chart D.  Column Chart
6. How can you print three copies of a workbook?
A.  Select File > Properties form the menu and type 3 in the Copies to print text box B.  Select File > Print from the menu and type 3 in the Number of copies text box C.  Click the Print button on the standard toolbar to print the document then take it to Kinko’s and have 2 more copies made D.  Press Ctrl+P+3
7. When integrating word and excel, word is usually the
A.  Server B.  Destination C.  Client D.  Both b and c
8. You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
A.  Pie chart B.  Row chart C.  Line chart D.  Column chart
9. Which elements of worksheet can be protected from accidental modification
A.  Contents B.  Objects C.  Scenarios D.  All of above
10. The chart wizard term data series refers to
A.  A chart legend B.  A collection of chart data markers C.  A set of values you plot in a chart D.  A data label