#20 When one wishes to select the largest number from a set of data, one should use which function? Include the equal sign and the (). Submit Answer format: Text #21 What function lets you test if something is true or false and then do different things depending on which result you get? (include the =, but don't need to include the conditions) Submit Answer format: Text #22 You freeze the total cell so that it doesn't change when copied by putting what symbol in front of the letter and number that represents the cell position.? Submit Answer format: Text #23 To lock the top row in excel so that it will always be visible when you scroll, you first go to which tab? Submit Answer format: Text #32 The correct way to enter a cell address (for cell D3) in Excel when you want the row to always stay the same, but you want the column to change when you copy to the right or left is? You don't need to include the =. Submit Answer format: Text #33 If you are referencing cell (C2)in Excel and want to be able to copy the formula and keep using the data in cell C2 in every place you copy it to, how do you reference the cell, you don't need to include the = ? Submit Answer format: Text #34 If you are referencing cell (C2)in Excel and want to be able to copy the formula and update the column and keep the row fixed, how do you reference the cell in a formula, you don't need to include the =? Submit Answer format: Text