Upgrade to remove ads
BTS 161/165 - Excel Ch 1B - Creating a Worksheet and Charting Data- Part 2
Terms in this set (45)
A chart element that identifies the patterns or colors that are assigned to the categories int he chart.
Merge & Center
A command that joins selected cells in an Excel worksheet into one larger cell and centers the contents in the merged cell.
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 digit to its right is 5 or above.
The process of shrinking the width and/or height of printed output to fit a maximum number of pages.
A group of things that come one after another in succession; for example, January, February, March, and so on.
The label along the lower border of the Excel window that identify each worksheet.
A tiny chart in a cell that gives a visual trend summary alongside your data; makes a pattern more obvious.
Another name for a worksheet.
A predefined formula that adds all the numbers in a selected range of cells.
Constant values consisting of only text, and which usually provide information about number values; also referred to as labels.
A predefined set of colors, fonts, lines, and fill effects that coordinate with each other.
Numerical scale on the left side of a chart that shows the range of numbers for the data points; also called the Y-axis.
Another name for a text value, and which usually provides information about number values.
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.
lettered column headings
The area along the top edge of a worksheet that identifies each column with a unique letter or combination of letters.
An element of the Excel window that displays the name of the selected cell, table, chart or object.
A screen view that maximizes the number of cells visible on your screen and keeps the column letters and row numbers close to the columns and rows.
A specific way in which Excel displays numbers in a cell. There are 11 to chose from in the drop-down menu.
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.
The symbols with which you can specify the type of calculation you want to perform in an Excel formula.
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.
A point of light measured in dots per square inch on a screen; 64 pixels equals 8.43 characters, which is the average number if characters that will fit in a cell in an Excel worksheet using the default font.
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.
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.
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 combination of changes to more than one cell at a time.
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.
An Excel feature that displays a customized set of charts that, according to Excel's calculations, will best fit your data based on the range of data that you select.
relative cell reference
In a formula, the address of a cell based on the relative positions of the cell that contains the formula and the cell referred to in the formula.
A horizontal group of cells in a worksheet.
The numbers along the left side of an Excel worksheet that designate the row numbers.
Select All box
A box in the upper left corner of the worksheet grid that, when clicked, selects all the cells in a worksheet.
sheet tab scrolling buttons
Buttons to the left of the sheet tabs used to display Excel sheet tabs that are not in view; used when there are more sheet tabs than will display in the space provided.
A command that displays the formula in each cell instead of the resulting value.
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; on the right side, when numerical data is selected, common calculations such as Sum and Average display.
A charting command to swap the data over the axis-data being charted on the vertical axis will move to the horizontal axis and vice versa.
The formula entered in a cell and visible only on the Formula Bar.
The data that displays in the Formula Bar.
Another name for a constant value.
An Excel file that contains one or more worksheets.
Buttons at the far right of the ribbon tabs that minimize or restore a displayed workbook.
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.
Another name for the horizontal (category) axis.
Another name for the vertical (value) axis.
This set is often in folders with...
BTS 161/147 - PowerPoint Ch 1 - Getting…
BTS 161 - Go! with Windows 10, Getting S…
BTS 161 - Introduction to Microsoft Offi…
BTS 161 Word Ch 1 - Creating Documents w…
Other sets by this creator
BTS 161/165 - Excel Ch 2 - Using Functio…
BTS 161/165 - Excel Ch 1A - Creating a W…
BTS 161 Word Ch. 2 - Creating Cover Lett…
BTS 161 Word Ch. 2 - Creating Cover Lett…