Spreadsheets
Up General Computer File Management System Maintenance Word Processing Skills Communication Skills Web skills Data bases Information Integrity Spreadsheets Presentation Skills

 

Digital Literacy Self-Assessment
2 = YES    |    1 = NOT SURE, BUT LIKELY    |    0 = NO or UNLIKELY
VIII. Spreadsheets 
score
Do you know how to create a simple spreadsheet with rows, columns and headings?
 
Can you move and scroll through a spreadsheet?
 
Do you know how to insert and delete rows and columns?
 
Do you know how to enter, edit, format and delete the contents of cells?
 
Do you know how to use the Format Cells menu option to format numbers, align cell content, change fonts and add borders and patterns?
 
Do you know how to write or create a formula (eg, using SUM, AVERAGE functions)?
 
Can you change the format of a number in a spreadsheet from currency to comma and do you know what that means?
 
Do you know how to copy a column of figures into a second column?
 
Do you know how to select a range of spreadsheet rows and columns and create a chart, bar graph, pie graph, table and line graph?
 
Do you know how to insert tables, graphs and spreadsheets into a word processing document?
 
TOTAL SCORE Spreadsheets
 
If you scored above 16 points on this section, you probably have the skill level you need.
If you scored between 10 and 15, you seem to have a significant amount of familiarity but we suggest you continue to give yourself opportunities to work with a computer and become even more familiar with that particular aspect**.
If you scored below 10, you need to get additional training and/or practice**.