To include an absolute reference to a cell you first have to select the cell that you want to include an absolute reference. Then in the formula bar put a dollar sign in front of the cell letter and put another dollar sign in front of the cell number. Then click enter and the cell will have an absolute reference.
2. Connect Two Shapes With a Double Point Arrow
To connect two shapes with a double point arrow first click on one of the shapes. Then you click on the insert tab or format tab in the drawing tools tab. Then click on the shapes button drop down arrow. Then click on the double point arrow in the line group. To add a certain thickness of line click on shape outline and then click on weight. Then you can choose how thick or thin you want the line to be.
3. In a Cell Average a Range of Cells That Are Greater Than 1000
Click on the cell where you want the average to be at. Then go to the formulas tab and click on insert function. Then type in average ifs and click go. Then click on the average ifs when it is highlighted. Then enter in the cells you want to average in the average range box and in the criteria range 1 box type in the range you want to average. Then in Criteria 1 type in > 1000. Then click ok and the formula will be entered.
4. Convert Comma Delimmeted Text to Columns
First select the cells that you want to convert into columns. Then got ot the data tab. Under the data tools group click on text to columns button. Then make sure delimetted is selected and click next, then under delimetters click on comma and click next. Then under step 3 of the wizards dialog box click on finish. The text is now converted into columns.
