To divide by the sum of cells A1 through A10 by 2 in Excel, use the formula: =SUM(A1:A10)/2. It is also possible to enter numbers directly into the formula.
Continue ReadingWhen entering a formula in Microsoft Excel, it is possible to use "pointing" to select the cells to reference. To "point" at a cell, click on it while editing the formula. Pointing minimizes the risk of referring to the wrong cell in a formula. Excel follows the mathematical order of operations, so it is possible to write more complex equations by using the mathematical operators * for multiplication, / for division, + for addition and - for subtraction.
Learn more about SoftwareTo merge cells in Excel, simply highlight the cells you want to merge, right-click, and select Format Cells. Next, select the Alignment tab, and check the Merge Cells box. The process should take less than one minute to complete.
Full Answer >To create a spreadsheet, open Excel and begin entering information into the cells. Save the spreadsheet to the hard drive by clicking File and Save. In Excel, every column has a capital letter at the top, and each row has a number on the left. These are combined to reference specific cells, for example 'A1' or 'C12'.
Full Answer >To remove duplicates in Excel, select the cells that include the duplicates, click on the Data tab, and select the Remove Duplicates option. Click OK on the dialogue box to delete the duplicate cells.
Full Answer >To hide cells in Excel 2010, first identify the row or column you want to hide. With the row or column highlighted, select Format, Visibility and Hide Rows or Hide Columns.
Full Answer >