Check Your Tech

Purpose: To offer learners scenarios to practice creating functions using Microsoft Excel. Content: Using an Excel spreadsheet to work in, learners are given 10 different basic scenarios and are asked to create functions. This is on an intermediate level, and the content is for practicing what learners have already learned, not to teach the functions themselves. Functions included are AND (), CONCAT (), TEXTJOIN (), LEFT (), UPPER (), AVERAGE (), COUNTBLANK (), IF (), SUMIF (), MAX (), VLOOKUP

Purpose: To offer learners scenarios to practice creating functions using Microsoft Excel. Content: Using an Excel spreadsheet to work in, learners are given data in a worksheet and are asked to answer the questions by determining and using functions. This is on an intermediate level, and the content is for practicing what learners have already learned, not to teach the functions themselves. Functions included are SUMIF (), COUNTBLANK(), COUNTIF (), ROUND(AVERAGE), VLOOKUP (), MID (), RANDBETW

Purpose: To offer learners a quick way to study Microsoft Excel functions by matching the function names with the definition of what they do. This is on a basic level, and the content is for a quick study guide to reinforce function knowledge. Content: Learners are given a word bank of 24 different Microsoft Excel function names and are asked to match them to the definition of what they do. This is a stand-alone Microsoft WORD document that can be downloaded and copied or filled-in and saved el