CSE 2111 Lecture 1: CSE 1.10.17

• School: Ohio State University
• Department: Computer Science & Engineering
• Course: CSE 2111
• Professor: Clair Farris

Document Summary

Preset formula that performs a calculation or task and displays the results in the associated cell. Syntax (layout of a function: =function name(arguments) A short-cut to all the functions in excel. Use fx toolbar button that walks you through building a function. Counta: difference between count and counta is count only determines the number of cells in a range that contain numbers, while counta counts all non- blank cells. =round(number, num_digits: number: number to be rounded, num_digits: number of decimal places. Automatically adjusts formula cell references when formula is copied. Keep the column and the row reference in the formula the same when copying the formula (signified by $ in front of column and row) Typing in the value in a formula or function instead of a cell reference. Keeps the column reference or the row reference in the formula the same when copying the formula (signified by $)