CS100 Final: Final+Review+Package+W2014+Solutions.pdf

415 views23 pages

Document Summary

This review package was created by the cs 100 instructional support assistants. It is based on all the course material, some of which you may have seen on previous assignments. Make sure to study the material before you start on this package. We strongly encourage you to try to complete this package without any outside help. Good luck: list the parameters and provide a brief explanation of the following functions. It returns the contents of the cell that has that name or address. =string1 & string2 & . =if(logical condition, value when true, value when false) Counts the number of cells that meet the given criterion. =countif(range, criterion) range: range containing cells to be counted criterion: logical condition to be met for including cell in the count. Extracts a specific number of characters from a label starting at the position specified.