This section allows candidates to understand the concept of spreadsheets and
demonstrate their ability to use a relevant application. Candidates will be able
to understand and complete tasks related to the creation, formatting,
modification, and use of a spreadsheet in conjunction with the use of basic
types and functions, while also being able to create and format charts.
Specifically, candidates will be able to:
Work with spreadsheets and save them in various file formats.
Select and use the available built-in functions of the application, such as the
Help function to improve productivity.
Enter data into cells and use best practices when creating lists. They will be
able to select, sort, copy, move, and delete data.
Manipulate the rows and columns of a spreadsheet. They will copy, move, delete,
and rename worksheets appropriately.
Create mathematical and logical formulas using basic spreadsheet functions. They
will use correct practices in creating formulas and recognize error values in
formulas.
Format numbers and text content within a spreadsheet.
Select, create, and format charts to effectively communicate information.
Adjust page settings and review and correct the content of a spreadsheet before
final printing.