BCIS 1405

Business Computer Applications

Spreadsheet Test Review

1. Know how to enter both value data (numeric) and label data (alphanumeric) into specific cells.

2. Know how to format the data with Bold, Italicize, and Underline.

3. Know how to align data with right, center, left alignment, and center across several selected columns.

4. Know how to format numbers using currency, comma, and decimal places, and adjust column widths.

5. Know how to use AutoSum to add a series of numbers together.

6. Know how to Subtract one number from another in a formula.

7. Know how to create a pie chart using specified data, showing data labels with each segment.

8. Know how to explode a segment in the pie chart.

9. Know how to copy and paste spreadsheet data or the chart into a wordprocessing document.

10. Know how to add your name to a header.