Ms. Cancelino

email Ms. Cancelino

I can demonstrate my ability to...

• customize Word and its views, use features that improve readability and modify document properties.

• apply font attributes, format paragraphs, format a document, apply styles and insert and format objects.

• insert and format a table, manage and enhance table data, create a mail merge document and complete a mail merge.

• create and modify footnotes and endnotes, explore special features, track changes and review a document.

I can demonstrate my ability to...

• explore the Excel window, enter and edit cell data, create formulas and functions, manage columns and rows, select move, copy and paste data, apply cell styles, alignment and font options, apply number formats, manage worksheets and select page setup options and preview/print a worksheet.

• utilize cell references in formulas, insert functions and use complex functions.

• create a variety or chart types, add and format chart elements, apply chart styles and colors, modify chart data sources and create/customize sparklines.

• freeze rows/columns, print large datasets, explore the benefits of data tables, design, create and apply tables and  styles, create structure references in formulas, sort and filter data, adding a total row, apply conditional formatting and create conditional formatting rules.

I can demonstrate my ability to...

• plan and prepare a presentation, add presentation content, view, rearrange and delete slides, format slide content with pictures, SmartArt and WordArt and configuring a presentation to present and distribute.

• examine slideshow principles, creating and formatting shapes, applying and controlling animations and transitions and adding video and audio.

• create, modify and work with SmartArt, insert, modify and format a table, insert, edit and modify a chart and its elements, and imbed and link objects.

• group and ungroup objects, transform a picture, animate objects and enhance transitions.

I can demonstrate my ability to...

• open, save and enable content in a database, recognize database object types, modify, add and save data, use database utilities, work with filters, sort data, and create a database.

• design, create and modify tables, import data and establish table relationships, create queries, specify query criteria and sort order, run a query, copy/modify a query and create and modify a multitable query.

• create a query with a calculated field, format calculated results, recover from common errors, verify calculated results, create expressions using the expression builder, use built-in functions, add aggregate functions to datasheets and create queries with aggregate functions.

• create forms using form tools, modify forms, use the form layout control, sort records in a form, create reports using report tools, use report views, modifying a report and sort and group records in a report.