11. In Excel Desktop, what is one of the function categories on the Formulas tab, in the Function Library group?
- Functional
- Lookup & Reference
- Analytical
- Medical
12. How do you make a cell reference absolute in a formula?
- Put an asterisk (*) in front of the column or behind the row identifiers in the formula
- Put a percentage sign (%) behind the column or row identifiers in the formula
- Put a dollar sign ($) in front of the column and/or row identifiers in the formula
- Put a plus sign (+) between the column and row identifiers in the formula
13. Formula errors in Excel are preceded by a hash symbol (#). What does it mean when multiple hash symbols exist in a cell?
- Column isn’t wide enough or it contains negative date or time values
- Formula contains unrecognized text
- Formula contains multiple errors
- Formula is missing a cell reference