#Microsoft function keys on keyboard series#

The arrow indicators on a filter button turn blue to indicate that a field is being used to filter the current list. Use the AutoFilter Control button to drop down a list of options that lets you select what you want displayed. Unlike data form mode, you can see all the matching records at the same time as they appear on the list.

#Microsoft function keys on keyboard series#

1ДЄutoFill is the Excel feature that allows you to automatically copy cells and fill them with a series without using Copy.ДЄutoFilter mode lets you quickly display only the rows in a list of data that meet the criteria that you specify. It also lets you create вЂњshorthandвЂќ entries that automatically fill in frequently used text when only a few letters are typed. Simply select the function you want to perform, then select the range you want to perform it on.ДЄutoCorrect is an Excel feature that automatically corrects a variety of commonly misspelled words. If you want to perform a function quickly without inserting it into a worksheet, you can use AutoCalculate on the status bar.

Select the As object in option in Step 4 of the Chart Wizard to have Excel create the chart on a worksheet in the workbook. 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