BCIS 1 FINAL EXAM REVIEW

SPRING SEMESTER

J. Flowers

Word Processing

• Mail Merge• Modified blocked letter

– Date at center point– Closing at center point

• Mixed punctuation– Colon after salutation– Comma after

complimentary closing

• Correct errors you find in letter

• Supply missing parts of the letter

• Provide a complimentary closing

• Add merge fields in set-up

• Insert merge fields through out body of letter

• Merge • Print designated copies of

mail merge

Spreadsheet

• Use an If/Then statement for Payroll

• Calculate commission• Calculate gross pay• Calculate deductions in

payroll– Federal Withholding– FICA

• Calculate net pay• Create a chart with

legend, data labels

• Print spreadsheet– With gridlines– Showing row and column

headings– With formulas– Try to fit on one page– Landscape

Database

• Create a table

• Insert a field in an established table

• Add records to a table

• Delete records in a table

• Create Queries in a database and save in Word file

• Create a report– Sort data in the report

Desktop Publishing

• Create a flyer in MS Publisher

• Use WordArt

• Use text frames to divide it into two columns

• Insert graphics

• Use bullets– Change bullets to graphics

• Use borders