Home
Subjects
Create
Search
Log in
Sign up
Upgrade to remove ads
Only $2.99/month
Other
Computer Skills
Excel
BTS 161/165 - Excel Ch 1B - Creating a Worksheet and Charting Data- Part 2
STUDY
Flashcards
Learn
Write
Spell
Test
PLAY
Match
Gravity
Terms in this set (45)
legend
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.
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 digit to its right is 5 or above.
scaling
The process of shrinking the width and/or height of printed output to fit a maximum number of pages.
series
A group of things that come one after another in succession; for example, January, February, March, and so on.
sheet tabs
The label along the lower border of the Excel window that identify each worksheet.
sparkline
A tiny chart in a cell that gives a visual trend summary alongside your data; makes a pattern more obvious.
spreadsheet
Another name for a worksheet.
SUM function
A predefined formula that adds all the numbers in a selected range of cells.
text values
Constant values consisting of only text, and which usually provide information about number values; also referred to as labels.
theme
A predefined set of colors, fonts, lines, and fill effects that coordinate with each other.
value axis
Numerical scale on the left side of a chart that shows the range of numbers for the data points; also called the Y-axis.
label
Another name for a text value, and which 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.
lettered column headings
The area along the top edge of a worksheet that identifies each column with a unique letter or combination of letters.
Name Box
An element of the Excel window that displays the name of the selected cell, table, chart or object.
normal view
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.
number format
A specific way in which Excel displays numbers in a cell. There are 11 to chose from in the drop-down menu.
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.
operators
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.
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 if characters 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.
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.
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 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, 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.
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.
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.
Show Formulas
A command that displays the formula in each cell instead of the resulting value.
status bar
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.
Switch Row/Column
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.
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.
value
Another name for a constant value.
workbook
An Excel file that contains one or more worksheets.
workbook-level buttons
Buttons at the far right of the ribbon tabs that minimize or restore a displayed workbook.
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.
X-axis
Another name for the horizontal (category) axis.
Y-axis
Another name for the vertical (value) axis.
This set is often in folders with...
BTS 161/147 - PowerPoint Ch 1 - Getting…
33 terms
BTS 161 - Go! with Windows 10, Getting S…
94 terms
BTS 161 - Introduction to Microsoft Offi…
116 terms
BTS 161 Word Ch 1 - Creating Documents w…
46 terms
Other sets by this creator
BTS 161/165 - Excel Ch 2 - Using Functio…
35 terms
BTS 161/165 - Excel Ch 1A - Creating a W…
44 terms
BTS 161 Word Ch. 2 - Creating Cover Lett…
25 terms
BTS 161 Word Ch. 2 - Creating Cover Lett…
25 terms