Function A predefined formula-a formula that Excel has already built for you-that performs calculations by using specific values in a particular order. Formula Bar An element in the Excel window that displays the value or formula contained in the active cell here you can also enter or edit values or formulas. Formula An equation that performs mathematical calculations on values in a worksheet. Format (Excel) Changing the appearance of cells and worksheet elements to make a worksheet attractive and easy to read. Fill handle The small black square in the lower right corner of a selected cell.
Expand horizontal scroll bar button An Excel window element with which you can increase the width of the horizontal scroll bar. Expand Formula Bar button An Excel window element with which you can increase the height of the Formula Bar to display lengthy cell content. Excel pointer An Excel window element with which you can display the location of the pointer. Displayed value The data that displays in a cell.
Data series Related data points represented by data markers each data series has a unique color or pattern represented in the chart legend. Data marker A column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point related data points form a data Quick Analysis tool A tool that displays in the lower right corner of a selected range with which you can analyze your data by using Excel tools such as charts, color-coding, and formulas. Point and click method The technique of constructing a formula by pointing to and then clicking cells this method is convenient when the referenced cells are not adjacent to one another. Pixel The abbreviated name for a picture element. Picture element A point of light measured in dots per square inch on a screen 64 pixels equals 8.43 characters, which is the average number of characters that will fit in a cell in an Excel worksheet using the default font.
Page Layout view A screen view in which you can use the rulers to measure the width and height of data, set margins for printing, hide or display the numbered row headings and the lettered column headings, and change the page orientation this view is useful for preparing your worksheet for printing.
0 kommentar(er)
