Technology Competency Assessment: Spreadsheets

To successfully complete this task, you must be able to complete the skills shown below. A sample task is also provided so you can practice the skills before taking the technology assessment. You may complete the task on your own or you may choose to go through our step by step practice. The content needed for this assignment is available at this link:


To demonstrate competency with spreadsheets, you will need to:

  • Change the background color of a cell
  • Change the spreadsheet font
  • Make text bold
  • Change text size
  • Create formulas and use functions
  • Insert a pie chart
  • Change fonts and text size inside charts
  • Apply borders to cells
  • Center and merge text across multiple cells
  • Find help when you need to perform a task you are not familiar with.