Select the As new sheet option in Step 4 of the Chart Wizard to have Excel create the chart on a separate chart sheet in the workbook. This formula applies the average function to cell references D3, D7, and C11, and gives the average of the values stored in the three cells specified in the argument.Īrithmetic operators are the symbols used in formulas to calculate values, such as addition (+), subtraction (-), multiplication (*), division (/), and exponentiation (^). Arguments can be quite complex, but in this course, we’ll be using simple ones. The function name is followed by its arguments in parentheses that tell Excel which values to calculate. Dialog boxes guide you through replacing the text. In this lesson, the arguments are logical test, value if true, and value if false.Īrgument placeholders are text that stands in for an argument. The menus and tools in the application window vary depending on whether a document window is open.Īrguments are parts of a formula that are used to produce the resulting calculation. The Excel application window holds any open document windows. The (or Alternate) key on the keyboard is used in conjunction with other keys and mouse actions to perform various commands and functions. The active window is the area on the Desktop that is currently being used and which usually contains a file or an application. Any action you perform is performed on the active cell.

The active cell contains the insertion point and is identified by a dark border around the cell. For example, $C$8 always refers to cell C8. Absolute addresses are created by adding a $ sign in front of each character in the cell address. It always points to the location of a specific cell, even if you copy it. You can type 3-D references, but clicking the reference you want to add is much easier, because it automatically adds the exclamation point.Īn absolute address in a formula refers to a specific cell location or range. When the name of a sheet tab appears in a formula followed by an exclamation point, the cell address is a 3-D reference. The 3-D pie chart is a simple chart style that is useful for illustrating the parts of a whole.Ī 3-D reference makes it possible to link worksheets together. Microsoft Excel Glossary & Keyboard Shortcuts/Function Keys Excel Glossary (below) Excel Shortcuts and Function Keys

Ms excel shortcut keys formulas