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 |
Create a formula using a function. In the Sheet1 worksheet, the formula in cell B16 should contain the MAX function.