![]() Excel Flashcards Flashcards | Quizlet. The selected cell in the worksheet; indicated with a dark border. The worksheet currently displayed in the workbook window. The workbook you are currently using. ![]() ![]() A single rectangular block that includes a group of contiguous cells. A symbol, such as +, - , *, or /, used in a formula to perform arithmetic calculations. The feature that helps make entering repetitive text easier. As you enter text in a worksheet, text that begins with the same letters as a previous entry in the same column is displayed. To eliminate empty space by matching the column width to the longest cell entry or the row height to the tallest cell entry. A button that quickly inserts Excel functions that summarize all the values in a column or row using a single statistic - SUM, AVERAGE, COUNT, MIN or MAXThe intersection of a column or row in a worksheet. A group of worksheet cells, which can be adjacent or nonadjacent. How to Create a Histogram in Excel. A histogram is a column chart that displays frequency data. In order to use the Histogram tool in Excel, you'll need to organize. Box and Whisker Charts (Box Plots) are commonly used in the display of statistical analyses. Microsoft Excel does not have a built in Box and Whisker chart type, but. Jon. Simple request. I want to put 95% confidence limits around some bar chart means. I cannot believe excel (2007) needs me to calculate the Confidence Limits in. Example - A2: G1. The address of a cell indicating its column and row location. In Excel, the part of the worksheet that identifies each column by a different letter. To remove data from a cell and place it on the Office Clipboard. A value in a recognized date format. To remove a cell or cells from a worksheet, shifting the remaining worksheet cells into the space previously occupied by the deleted cell or cells; also to remove a worksheet entirely from a workbook. To move an item (either text or a graphic) by selecting it and dragging it with the mouse. A mode in which you can edit part of an entry rather than the entire contents of a cell. The command to locate specific letters and numbers in a workbook. A mathematical expression that calculates a value; all Excel formulas always begin with an equal sign (=) followed by an expression that describes the calculation to be done. The bar located above the workbook window in which the contents of a cell are displayed. Excel view in which cell formulas are displayed rather than the values returned by the formulas. A predefined formula that performs calculations using specific values called arguments. A type of page orientation in which the page is wider than it is tall, so that text spans the widest part of the page. A spreadsheet program you use to display, organize, and analyze numerical data. The box located on the far left of the Formula bar in which the cell reference to the active cell is also displayed. Cell range that is comprised of two or more separate adjacent ranges. The view that renders the workbook and worksheets for the computer screen. A numerical value that can be used in a mathematical calculation. A mathematical symbol that you use to combine values and then return a single value. A set of predefined rules that Excel follows to unambiguously calculate a formula by determining which operator is applied first, which operator is applied second and so forth. In Excel, a view that displays the worksheet as it is divided up into pages. Anything outside of the print area is grayed out. In Excel, a view that shows how the worksheet will be laid out on the pages sent to the printer. A colored dot that, when combined with other pixels, forms a picture or graphics display; stands for picture element. A worksheet that includes questions to help you define the purpose and objective of a workbook. The unit used to measure the size of the characters in a font. A type of page orientation in which the page is taller than it is wide (like a typical business letter.)A group of worksheet cells, which can be adjacent or nonadjacent. AKA a cell range)Identification of a cell range using the upper- left and lower- right corners of the rectangular selection of cells. The command to overwrite letters and numbers in a workbook with another entry. In Excel, the part of a worksheet that identifies each row by a different number. The range of values that spans along an axis. To change the size of a graphic to make it fit into a document. The area at the bottom of a worksheet that identifies the worksheet; clicking a sheet tab makes the worksheet active. A feature that check the words in a document against the program's built- in dictionary and helps you avoid typographical errors. . A tool used in business for budgeting, inventory management, and decision making fir analyzing and reporting information.A combination of letter, numbers and some symbols. Two or more text characters. A value in a recognized time format. To cut off, or hide, the part of an entry that does not fit in a cell. An approach using an electronic spreadsheet in which you change one or more of the values in the worksheet and then examine the recalculated values to determine the effect of the change. The file in which Excel stores an electronic spreadsheet. Window in which a workbook is displayed; also called worksheet window. Each workbook is made up of individual worksheets, or sheets, containing formulas, functions, values, text, and graphics. A variation on an Excel theme color. A color option that uses the Windows default text and background color values. In an Excel table, rows of alternating colors that make data easier to read. A line that prints along the side of a table cell or around the outside of selected text. A setting that applies formatting only when a cell's value meets a specified condition. A color you specify as a mixture of red, blue, and green color values, which makes available 1. A horizontal bar added to the background of a cell whose length reflects the cell's value. A range of data you can treat as a distinct object in a worksheet. A set of characters that uses the same typeface, style, and size. Determined by point size, which is a unit of measurement equal approximately to 1/7. Various ways that fonts can be displayed, such as regular, italic, bold, or bold italic; a special attribute applied to the characters of a font. Text that appears at the bottom of every page in a document or at the bottom of every slide in a presentation. A button on the Ribbon that, when selected, copies a format from one cell range to another. To change the appearance, not the data, of your workbook. Default number format that automatically displays number, for the most part, the same way you enter them. Text that appears at the top of every page in a document or every slide in a presentation. Used to identify the format of the data marker used for each series in a chart. Used if the chart contains more than one data series. An Office feature that shows the results you would achieve in your file, such as the effects of formatting options on a document's appearance, if you click the option to which you are pointing. A page break that you insert anywhere on a page. The space between the page content and the edges of the page. To combine the main document with a data source. A tool bar that appears next to the pointer whenever you select text and contains buttons for the most commonly used formatting commands, such as font, font size, styles, color, alignment, and indents that may appear in different groups or tabs on the Ribbon. In Excel, a font that can be used no matter what theme the workbook has. Location in a worksheet that determines where a new page begins. The unit used to measure the size of the characters in a font. Selected portion of a worksheet to be printed. In Excel, information that prints on each page. A font that does not have the small horizontal lines (called serifs) at the tops and bottoms of letters. A font that includes small horizontal lines (called serifs) at the tops and bottoms of letters. A color that is always available regardless of the workbook's theme. A saved collection of formatting options - number formats, text alignment, font size and colors, borders, and background fills - that can be applied to cells in a worksheet. An Excel setting that applies styles to four table elements (header row, first column, last column, and totals row). A designed collection of formatting options that include color, graphics, and background images. The 1. 2 colors that belong to a workbook's theme. A font associated with a particular design theme and used for headings and body text. The specific design of a set of printed characters, including letters, numbers, punctuation marks, and symbols. Cell reference that points to a specific cell and does not change when copied; appears with a dollar sign ($) before each column and row designation. Specifies the numbers, text, or cell references used by a function to calculate a value.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2017
Categories |