A. Is the company over, under, or on budget for February? How do you know? (1 point) b. Compare the actuals spent versus budgeted amount in January to the actuals spent versus budgeted amount in March? (1 point)

Match the terms in the hlookup syntax with their explanation. a. lookup value b. data table c. row index d. mode 1. name of the table that contains the value 2. specifies if an exact match must be found 3. value to be searched 4. name of the row that contains the value

Where can page numbers appear? check all that apply. in the header inside tables in the footer at the bottom of columns at the top of columns

Match the following errors with their definitions. a. #name b. #value c. #ref d. 1. when a formula produces output that is too lengthy to fit in the spreadsheet cell 2. when you enter an invalid cell reference in a formula 3. when you type text in cells that accept numeric data 4. when you type in a cell reference that doesn’t exist