Excel Turtorial Training 3
Training Progress
Wednesday, March 11, 2015
Student:
Tojuola John
Assignment:
Excel Tutorial 3 Training - 512921
Percent Complete:
100% (10/10)
Subject
Launch Assignment
Activity
Task ID
Task
Completed
MS Excel 2013
Fill adjacent cells with formulas 3305
Fill cells C17 and D17 with the formula from cell B17 by selecting cell B17, then positioning the mouse over the lower-right corner of cell B17 until the fill handle appears. Press and hold the left mouse button, drag the mouse over cells C17 and D17, and then release the mouse button.
3/2/2015 3:55:00 PM
MS Excel 2013
Use absolute cell references
3454
Use absolute cell references by typing
= in cell F5, and then clicking cell E5.
Type / in the cell, click cell E9, and press F4.
3/10/2015 8:22:00 AM
MS Excel 2013
Use the Quick Analysis tool to create a formula
3812
To use the Quick Analysis tool to create a formula, click and drag to select cells D3:D16, then click the
Quick Analysis button. Click TOTALS, then click the first Sum option in the list of formulas.
3/3/2015 8:29:00 PM
MS Excel 2013
Fill a range of cells with a series of labels
3306
To autofill cells with the names of months, type January in the current cell. Position the mouse over the lower-right corner of cell B2 until the fill handle appears. Press and hold the left mouse button as you drag the mouse to the right to include cells C2 and D2, then release the mouse button. 3/3/2015 8:30:00 PM
Training Progress Report 1 of 3
Training Progress
Subject
Activity
Task ID
Task
Completed
MS Excel 2013
Fill a range of cells with a number series
3392
To autofill a range with numbers, click and drag to select cells A5:A6, and release the mouse button. Point to the lower-right corner of the selected range until the fill handle appears, and then drag the fill handle at the bottom of cell A6 down to the bottom of cell
A12. Release the mouse button.
3/3/2015 8:36:00 PM
MS Excel 2013
Create a formula using the
TODAY
Wednesday, March 11, 2015
Student:
Tojuola John
Assignment:
Excel Tutorial 3 Training - 512921
Percent Complete:
100% (10/10)
Subject
Launch Assignment
Activity
Task ID
Task
Completed
MS Excel 2013
Fill adjacent cells with formulas 3305
Fill cells C17 and D17 with the formula from cell B17 by selecting cell B17, then positioning the mouse over the lower-right corner of cell B17 until the fill handle appears. Press and hold the left mouse button, drag the mouse over cells C17 and D17, and then release the mouse button.
3/2/2015 3:55:00 PM
MS Excel 2013
Use absolute cell references
3454
Use absolute cell references by typing
= in cell F5, and then clicking cell E5.
Type / in the cell, click cell E9, and press F4.
3/10/2015 8:22:00 AM
MS Excel 2013
Use the Quick Analysis tool to create a formula
3812
To use the Quick Analysis tool to create a formula, click and drag to select cells D3:D16, then click the
Quick Analysis button. Click TOTALS, then click the first Sum option in the list of formulas.
3/3/2015 8:29:00 PM
MS Excel 2013
Fill a range of cells with a series of labels
3306
To autofill cells with the names of months, type January in the current cell. Position the mouse over the lower-right corner of cell B2 until the fill handle appears. Press and hold the left mouse button as you drag the mouse to the right to include cells C2 and D2, then release the mouse button. 3/3/2015 8:30:00 PM
Training Progress Report 1 of 3
Training Progress
Subject
Activity
Task ID
Task
Completed
MS Excel 2013
Fill a range of cells with a number series
3392
To autofill a range with numbers, click and drag to select cells A5:A6, and release the mouse button. Point to the lower-right corner of the selected range until the fill handle appears, and then drag the fill handle at the bottom of cell A6 down to the bottom of cell
A12. Release the mouse button.
3/3/2015 8:36:00 PM
MS Excel 2013
Create a formula using the
TODAY