Create Formula By Using Function. Type an equal sign and then type a function. For example SUM for getting the total sales.
Once pressed the function is surrounded by curly braces indicating that the function is now an array. Type an equal sign and then type a function. By using the shortcut key ie AltF11.
Right-click anywhere on the ribbon then Choose the Customize the Ribbon in excel.
When we choose this command the Excel Options dialog box opens. Relative references are given by using brackets but the number indicates position relative to cell with formula. By using the Copy function you do not have to create multiple formulas that are almost identical. How to add in Excel.
