Mind Tap Excel
Enter text in a cell.
In the Sheet1 worksheet, cell F3 should contain the text “Total”.
Enter text in a cell.
In the Sheet1 worksheet, cell A12 should contain the text “Vancouver”.
Enter a number in a cell.
In the Sheet1 worksheet, cell B12 should contain the value 120.
Enter a number in a cell.
In the Sheet1 worksheet, cell C12 should contain the value 130.
Enter a number in a cell.
In the Sheet1 worksheet, cell D12 should contain the value 117.
Enter a number in a cell.
In the Sheet1 worksheet, cell E12 should contain the value 130.
Update a value in a cell.
In the Sheet1 worksheet, cell B3 should contain the text “Quarter 1”.
AutoFill values in a range.
In the Sheet1 worksheet, the range C3:E3 should contain the series of annual quarters.
Edit Data
Update a value in a cell.
In the Sheet1 worksheet, cell B4 should contain the value 133.
Update a value in a cell.
In the Sheet1 worksheet, cell B6 should contain the value 109.
Copy and Move Cell Data
Copy and paste a value in a cell.
In the Sheet1 worksheet, cell A13 should contain the text “Total”.
Cut and paste a range of values.
In the Sheet1 worksheet, the values in the range H5:H7 should be cut from the worksheet.
Enter Formulas and Use AutoSum
Use relative references in a formula.
The formula in cell F4 should reference the cells B4, C4, D4, E4.
Create a formula using a function.
In the Sheet1 worksheet, the formula in cell B13 should contain the SUM function.
Copy Formulas with Relative Cell References
Copy a formula into a range.
In the Sheet1 worksheet, cell F4 contains an incorrect formula.
Copy a formula into a range.
In the Sheet1 worksheet, cell B13 contains an incorrect formula.
Copy Formulas with Absolute Cell References
Enter text in a cell.
In the Sheet1 worksheet, cell G3 should contain the text “% of Total”.
Use mixed references in a formula.
The formula in cell G4 should contain a relative reference to cell F4 and an absolute reference to cell F13.
Copy a formula into a range.
In the Sheet1 worksheet, cell G4 contains an incorrect formula.
Enter a Formula with Multiple Operators
Enter text in a cell.
In the Sheet1 worksheet, cell J3 should contain the text “This Year”.
Use relative references in a formula.
The formula in cell K3 should reference cell F13.
Enter text/a number in a cell.
In the Sheet1 worksheet, cell J5 should contain the text “% Increase”.
Use absolute, relative, or mixed references in a formula.
In the Sheet1 worksheet, the formula in cell K5 should reference cells K3 and K1.
Change the number format.
In the Sheet1 worksheet, cell K5 should be formatted using the Percentage number format with two decimal places.
Insert a Function
Create a formula using a function.
In the Sheet1 worksheet, the formula in cell B15 should contain the AVERAGE function.
Create a formula using a function.
In the Sheet1 worksheet, the formula in cell B16 should contain the MAX function.
Create a formula using a function.
In the Sheet1 worksheet, the formula in cell B17 should contain the MIN function.
Switch Worksheet Views
Set the print area for a worksheet.
The print area of the Sheet1 worksheet should be A1:K20.
Non-graded – Choose Print Options