This exam is a hands-on computer test using the software packages listed below. The exam involves opening given files with the software, modifying the files based on instructions, answering questions about how to do certain operations, or what was the result of the operation, and integrating files among the different software packages.
If you feel you want to review for the exam — here are some pointers. We suggest knowing the strict definition of each topic on the Exam Overview/Topic List below. The exam must be completed using standard Microsoft processes. The “help” function is not available during the exam. (HINT: As you answer each question, complete the requested tasks in the order they are presented in the question — if you are requested to bold and underline something — bold first, then underline — the program looks for the “bold” response first, if you “underline” first the system believes you are trying to “bold”, not underline.) If you want to practice before taking the exam we suggest you conduct a Google search for on-line Microsoft 2010 Office tutorials. One such on-line site is available at http://www.baycongroup.com/ — please note the baycongroup site does not have all the topics listed on the BSU Exam Overview/Topic List noted in their list of tutorial items — you will need to review all items listed on the Exam Overview/Topic List included with this website.
ITM104 Word Processing: Microsoft Word 2010
- screen
- moving around the screen/document
- word wrap
- opening and saving documents
- moving text: cutting and pasting, copying and pasting
- basic formatting: margin, indents, alignment, tabs, fonts, style-bold, underlining,
- grammar check,
- headers and footers,
- footnotes and endnotes, tables,
- styles and templates,
- auto text, auto correct,
- format painter,
- columns,
- mail merge,
- hyperlink,
- outline,
- table of contents,
- index,
- master documents,
- forms,
- tracking changes
- comments
ITM105 Spreadsheet Topics: Microsoft Excel 2010
- screen
- entering labels
- change column width
- series auto fill
- renaming, moving, deleting, and inserting sheets
- entering formulas
- using fill handle and auto sum
- relative and absolute references
- functions including ‘IF’
- inserting rows and columns
- basic formatting: fonts, style, size, alignment, borders, currency, number, % formats, patterns, and colors
- headers and footers
- printing: centering, gridlines, row and column headings, displaying formulas, portrait and landscape orientation
- charts: annotating
- ranges (move, copy, name)
- freezing columns and rows
- hiding and protecting worksheet areas,
- recording macros
- lists
- data tables (one-way and two-way),
- scenario manager
- pivot tables and charts
- solver, goal seek, and data analysis tools
ITM106 Database Topics: Microsoft Access 2010
- brief overview of tables: design, creating a table, field names, data types, primary key, field properties (sizes, captions, default value, decimals, input masks), wizard only (phone number or date), indexes adding and deleting fields
- input (1 or 2 records only in data sheet view to see how field properties work)
- discuss relationships briefly
- importing Access tables: this will allow use of created tables for queries and reports
- sorting records in datasheet view
- filters
- forms
- exporting data
- subforms
- queries (include more than one table, include calculated field)
- create reports: use wizard
- revise reports (without wizard e.g. adding fields, etc.)