17 Years of Purchasing Skills. Spreadsheets: Understands the purpose/structure of a spreadsheet Interprets data from an existing spreadsheet Understands terminology - column, row, cell, cell range Understands cell addressing Understands active cell Enters data (labels, values) in a cell Formats data in a cell eg. bold, alignment Generates appropriate graphs eg. bar, column, line Changes column width and row height Adds/deletes row/columns Uses sum formula and undertakes basic calculations Formats data to currency, time, number, percentage Sorts data Understands strengths and weaknesses of a spreadsheet Return to Top Databases Understands structure/purpose of a database Understands strengths and weaknesses of databases Understands basic terminology - fields, records, files Opens and uses a commercial database eg. electronic encyclopaedias Locates specific information searching by subject, key word, author Locates specific record(s) using find function Uses relevant fields Chooses appropriate data types for fields Sorts data Adds/deletes records Edits data in an existing record