| # A B C D E F G H I J K L M N O P Q R S T U V W X Y Z |
| |
A
| Absolute cell reference | A cell reference that refers to cells by their fixed position in a worksheet; an absolute cell reference remains the same when the formula is copied. |
| Accounting Number Format | The Excel number format that applies a thousand comma separator where appropriate, inserts a fixed U.S. dollar sign aligned at the left edge of the cell, applies two decimal places, and leaves a small amount of space at the right edge of the cell to accommodate a parenthesis for negative numbers. |
| Active cell | The cell, surrounded by a green border, ready to receive data or be affected by the next Excel command. |
| Application-level controls | Buttons at the far right of the ribbon tabs that minimize or restore Excel. |
| Arithmetic operators | The symbols +, −, *, /, %, and ^ used to denote addition, subtraction (or negation), multiplication, division, percentage, and exponentiation in an Excel formula. |
| Auto Fill | An Excel feature that generates and extends values into adjacent cells based on the values of selected cells. |
| AutoComplete (Excel) | A feature that speeds your typing and lessens the likelihood of errors; if the first few characters you type in a cell match an existing entry in the column, Excel fills in the remaining characters for you. |
| AutoFit | An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column. |
| AutoSum | A button that inserts a SUM function. |
| Click here to go to the top of the page |
C
| Category axis | The area along the bottom of a chart that identifies the categories of data; also referred to as the x-axis. |
| Category labels | The labels that display along the bottom of a chart to identify the categories of data; Excel uses the row titles as the category labels. |
| Cell | The intersection of a column and a row. |
| Cell address | The identification of a specific cell by its intersecting column letter and row number. Another name for a cell reference. |
| Cell content | Anything typed into a cell. |
| Cell reference | The identification of a specific cell by its intersecting column letter and row number. Another name for cell address. |
| Cell style | A defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading. |
| Chart (Excel) | The graphic representation of data in a worksheet; data presented as a chart is usually easier to understand than a table of numbers. |
| Chart Elements button | A button with which you can add, remove, or change chart elements such as the title, legend, gridlines, and data labels. |
| Chart Filters button | A button with which you can edit what data points and names are visible on your chart. |
| Chart layout | The combination of chart elements that can be displayed in a chart such as a title, a legend, labels for the columns, and the table of charted cells. |
| Chart style | The overall visual look of a chart in terms of its graphic effects, colors, and backgrounds; for example, you can have flat or beveled columns, colors that are solid or transparent, and backgrounds that are dark or light. |
| Chart Styles button | A button with which you can select a style and color scheme for your chart. |
| Chart Styles gallery | A group of predesigned chart styles that you can apply to an Excel chart. |
| Chart types | Various chart formats used in a way that is meaningful to the reader; common examples are column charts, pie charts, and line charts. |
| Collaboration | Working together with others as a team in an intellectual endeavor to complete a shared task or achieve a shared goal. |
| Column | A vertical group of cells in a worksheet. |
| Column chart | A chart in which the data is arranged in columns and that is useful for showing data changes over a period of time or for illustrating comparisons among items. |
| Column heading | The letter that displays at the top of a vertical group of cells in a worksheet; beginning with the first letter of the alphabet, a unique letter or combination of letters identifies each column. |
| Comma Style | The Excel number format that inserts thousand comma separators where appropriate and applies two decimal places. Comma Style also leaves space at the right to accommodate a parenthesis when negative numbers are present. |
| Constant value | Numbers, text, dates, or times of day that you type into a cell. |
| Context-sensitive | Refers to commands associated with activities in which you are engaged; often activated by right-clicking a screen item. |
| Click here to go to the top of the page |
D
| Data (Excel) | Text or numbers in a cell. |
| Data marker | A column, a bar, an area, a dot, a pie slice, or another symbol in a chart that represents a single data point; related data points form a data series. |
| Data point | A value that originates in a worksheet cell and that is represented in a chart by a data marker. |
| Data series | Related data points represented by data markers; each data series has a unique color or pattern represented in the chart legend. |
| Displayed value | The data that displays in a cell. |
| Click here to go to the top of the page |
E
| Expand Formula Bar button | An Excel window element with which you can increase the height of the Formula Bar to display lengthy cell content. |
| Expand horizontal scroll bar button | An Excel window element with which you can increase the width of the horizontal scroll bar. |
| Click here to go to the top of the page |
F
| Fill handle | The small black square in the lower right corner of a selected cell. |
| Format (Excel) | Changing the appearance of cells and worksheet elements to make a worksheet attractive and easy to read. |
| Formula | An equation that performs mathematical calculations on values in a worksheet. |
| 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. |
| Function | A predefined formula—a formula that Excel has already built for you—that performs calculations by using specific values in a particular order. |
| Click here to go to the top of the page |
G
| General format | The default format that Excel applies to numbers; this format has no specific characteristics—whatever you type in the cell will display, with the exception that trailing zeros to the right of a decimal point will not display. |
| Click here to go to the top of the page |
H
| Help button | A button that displays Excel Help options. |
| Click here to go to the top of the page |
L
| Label | Another name for a text value; usually provides information about number values. |
| Left alignment | The cell format in which characters align at the left edge of the cell. This is the default for text entries and is an example of formatting information stored in a cell. |
| Legend | A chart element that identifies the patterns or colors that are assigned to the categories in the chart. |
| Lettered column headings | The area along the top edge of a worksheet that identifies each column with a unique letter or combination of letters. |
| Click here to go to the top of the page |
M
| Merge & Center | A command that joins selected cells in an Excel worksheet into one larger cell and centers the contents in the new cell. |
| Microsoft Office 365 | A set of secure online services that enable people in an organization to communicate and collaborate by using any Internet-connected device—a computer, a tablet, or a mobile phone. |
| Click here to go to the top of the page |
N
| Name Box | An element of the Excel window that displays the name of the selected cell, table, chart, or object. |
| New sheet button | A button that inserts an additional worksheet in the workbook. |
| Number format | A specific way in which Excel displays numbers in a cell. |
| Number values | Constant values consisting of only numbers. |
| Numbered row headings | The area along the left edge of a worksheet that identifies each row with a unique number. |
| Click here to go to the top of the page |
O
| Operators | The symbols with which you can specify the type of calculation you want to perform in an Excel formula. |
| Click here to go to the top of the page |
P
| 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. |
| 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 digits that will fit in a cell in an Excel worksheet using the default font. |
| Pixel | The abbreviated name for a picture element. |
| 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. |
| Click here to go to the top of the page |
Q
| Quick Analysis button | The button 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. |
| Quick Analysis Tool | A tool that displays a button in the lower right corner of a selected range with options to analyze data by using Excel features such as charts, color-coding, and formulas. |
| Quick Layout gallery | A group of predesigned chart layouts that you can apply to an Excel chart. |
| Click here to go to the top of the page |
R
| Range | Two or more selected cells on a worksheet that are adjacent or nonadjacent; because the range is treated as a single unit, you can make the same changes or a combination of changes to more than one cell at a time. |
| Range finder | An Excel feature that outlines cells in color to indicate which cells are used in a formula; useful for verifying which cells are referenced in a formula. |
| Recommended Charts | An Excel feature that displays a customized set of charts that will best fit the range of data that you select, according to Excel. |
| Relative cell reference | In a formula, the address of a cell based on the relative position of the cell that contains the formula and the cell referred to. |
| Rounding | A procedure in which you determine which digit at the right of the number will be the last digit displayed and then increase it by one if the next digit to its right is 5, 6, 7, 8, or 9. |
| Row | A horizontal group of cells in a worksheet. |
| Row heading | The numbers along the left side of an Excel worksheet that designate the row numbers. |
| Click here to go to the top of the page |
S
| Scaling (Excel) | The process of shrinking the width and/or height of printed output to fit a maximum number of pages. |
| Select All box | A box in the upper left corner of the worksheet grid that, when clicked, selects all the cells in a worksheet. |
| Series | A group of things that come one after another in succession—for example, January, February, March, and so on. |
| Sheet tab scrolling buttons | Buttons to the left of the sheet tabs that display Excel sheet tabs that are not in view; use when there are more sheet tabs than will display in the space provided. |
| Sheet tab | Identifies a worksheet in a workbook. |
| Sparkline | A tiny chart in the background of a cell that gives a visual trend summary alongside your data; makes a pattern more obvious. |
| Spreadsheet | Another name for a worksheet. |
| Status bar (Excel) | The area along the lower edge of the Excel window that displays, on the left side, the current cell mode, page number, and worksheet information, and on the right side, when numerical data is selected, common calculations such as Sum and Average display. |
| SUM function | A predefined formula that adds all the numbers in a selected range of cells. |
| Switch Row/Column | A charting command used to swap the data over the axis—data being charted on the vertical axis will move to the horizontal axis and vice versa. |
| Click here to go to the top of the page |
T
| Team | A group of workers tasked with working together to solve a problem, make a decision, or create a work product. |
| Text values | Constant values consisting of only text and which usually provide information about number values; also referred to as labels. |
| Click here to go to the top of the page |
U
| Underlying formula | The formula entered in a cell and visible only on the Formula Bar. |
| Underlying value | The data that displays in the Formula Bar. |
| Click here to go to the top of the page |
V
| Value | Another name for a constant value. |
| Value axis | A numerical scale on the left side of a chart that shows the range of numbers for the data points; also referred to as the y-axis. |
| Click here to go to the top of the page |
W
| Workbook | An Excel file that contains one or more worksheets. |
| Worksheet | The primary document that you use in Excel to work with and store data, and which is formatted as a pattern of uniformly spaced horizontal and vertical lines. |
| Click here to go to the top of the page |
X
| x-axis | Another name for the horizontal (category) axis. |
| Click here to go to the top of the page |
Y
| y-axis | Another name for the vertical (value) axis. |
| Click here to go to the top of the page |
burlingameshoebethe.blogspot.com
Source: https://wps.pearsoned.com/bp_go_aio_2/244/62498/15999685.cw/content/index.html
0 Response to "In the Excel Window Which of the Following Continuously Displays the Buttons for Switching Worksheet"
Post a Comment