Excel
During the test you must be able to complete the skills shown below. A sample task list is also provided so you can practice the skills before taking the technology assessment. We recommend that you go through our step by step practice. The content needed for this step by step practice is available at this link:
To demonstrate competency with Excel Spreadsheets, you will need to:
- Merge and Center text across multiple cells
- Change the background color of a selection of cells
- Apply borders to cells
- Adjust the width of the columns
- Change the spreadsheet font
- Make text bold
- Change text size
- Create formulas, use functions and know the difference between the two
- Format decimals and percentages
- Insert a specified chart
- Change fonts and text size inside the chart
- Find help when you need to perform a task you are not familiar with