CIS 1323 Credit by Exam Skills List

MICROSOFT OFFICE 2019/365—ACCESS

  • Create a new blank desktop database
  • Enter records—inserting, editing, deleting, sorting
  • Create, copy, and modify queries, forms and reports
  • Relationships
  • Primary key, foreign key
  • Field properties—datasheet view and design view
  • Export and import—excel, PDF, text files
  • Compact and repair database
  • Calculated fields and lookup fields
  • Create custom input masks
  • Record and field validation rules

MICROSOFT OFFICE 2019/365—EXCEL

  • Entering formulas using relative cell referencing, absolute cell referencing and mixed cell referencing
  • Basic statistical functions (Minimum, Maximum, Average, Count etc)
  • Basic financial functions (NPV, SLN, PMT, RATE, etc)
  • Basic formatting—alignment, column width, column height, inserting rows/columns, deleting rows/column, moving rows/columns, deleting cells, clearing cell contents, fill color, borders, hide, unhide column/row, grouping and ungrouping worksheets, freezing rows/columns, autofit column, best fit column, etc
  • Fill series
  • Functions: SUM, IF, VLOOKUP, CONCAT, AND, OR, nested IF, SUMIF, COUNTIF, AVERAGEIF, MATCH, INDEX, IFERROR, date and time functions
  • Conditional formatting
  • Quick analysis tool
  • Sorting and filtering, multi-column sorting
  • Spell Check
  • Add, delete, rename, move worksheet
  • Charts, moving charts, chart sheet, formatting charts, combination charts
  • Pivot table, add calculated field, grouping fields
  • Goal Seek and Solver
  • Sparklines and data bars
  • Custom filters, subtotal, outline and consolidate
  • Importing data
  • Adding comments
  • Locking cells, adding password
  • Macros
  • Creating and formatting tables
  • Import table from Access database

MICROSOFT OFFICE 2019/365—POWERPOINT

  • Create, save, print, edit presentations
  • Using a template or auto-create to create a presentation
  • Lists—bullet and number
  • Entering text, notes, comments on slides
  • Spell check and grammar check
  • Aligning and grouping objects
  • Themes and colors
  • Insert clip art, photo, table
  • Animation and transition effects
  • Insert a chart and table
  • Use WordArt or SmartArt
  • Presenter view
  • Import slides from Word outline
  • Use Format Painter

MICROSOFT OFFICE 2019/365—WORD

  • Apply heading styles
  • Change the font theme