i. Using Functions and nested functions in formulas Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. Functions can be used to perform simple or complex calculations. Structure of a function 1. Structure – a function begins with an equal

i. Filter your data 1. Select the Data that you want to filter then go to [Data] tab -> [Sort & Filter] group, click [Filter]. 2. Click on the down arrow in the column header to display a list to make filter choices. 3. To select by values, uncheck the [Select All] check box. Then [...]

i. Enter data in a worksheet 1. Click the cell where you want to enter data. 2. Type the data in the cell. 3. Press enter or tab to move to the next cell. ii. Format numbers 1. Select the cells that you want to format. 2. One the [Home] tab,