Unit 7 - Excel Workbook
Truncated
A cell value that has been cut off from view has been truncated. The complete value is still there, but is not visible. To make the data visible, simply widen the column.
Chart
A chart is used to graphically display data.
Data marker
A data marker is a column in the chart that represents a single data point.
Data series
A data series includes the individual colored columns, lines, or slices that represent the data in the chart.
Formula
A formula is an equation that performs mathematical calculations on number values.
Chart elements
Chart elements are the different parts of a chart. These include the title, legend, labels, and so forth.
Chart styles
Chart styles are the visual designs, such as color and shape of the pie slice or bar(s). You can manually adjust these design features, or you can use one of the predefined styles in the Chart Styles group.
Chart tools
Chart tools are additional tools on the ribbon bar for use in designing and formatting charts. These appear when a chart is selected.
Deselect
Clicking the mouse anywhere outside the currently selected cell or range of cells will deselect the cells.
Chart tools are additional tools on the ribbon bar for use in designing and formatting charts. These appear when a chart is selected.
Contextual tabs are additional tools that appear only when a chart is selected.
Value
Data inside the cell is called a value. The value can be a text value such as number values or words for labels.
Workbook
Excel files are called workbooks. This includes the individual worksheets and charts.
A First Look at Excel
Excel shares many of the same features and organization as Microsoft Word.
=
Excel uses the equal sign to designate the beginning of a formula.
Cell reference
Formulas often use the values found in other cells to make calculations. The cell reference is the part of a formula that gives the cell address used to make calculations. Example: =SUM(C4+D4) "C4" and "D4" are cell references. This formula will add whatever values are found in C4 and D4.
Highlighting
Highlighting is selecting cells by clicking and dragging with your mouse.
Absolute cell reference
If you don't want a cell reference to change when a formula is moved, it needs to be designated as an absolute cell reference. This is done by adding a $ before the column and row. In the formula below, the value found in cell C4 would be added regardless of where the formula was moved, but D4 would change if the formula was moved. =SUM($C$4+D4)
How do you know which cell is active?
It is the cell with a thicker black box around it.
Cell styles
Located under the Home tab, this button provides a list of predefined formatting to add emphasis to cell values.
Function
Predefined formulas such as SUM or MIN are functions. These are found on the Home tab in the Editing group.
End+←,↑,→, or ↓
Pressing End and an arrow key moves the active cell to the first or last cell containing data in that row or column.
Relative cell reference
Relative cell references adjust if the formula is moved or if columns or rows are inserted. If the formula =SUM(C4+D4) was copied down one row, the cell references would automatically change to =SUM(C5+D5) in the new formula.
Scroll bars
Slide the scroll bars to control what portion of the worksheet you view. You can also use arrows at the ends of the bars to change views.
What keyboard key would you use to move from cells left to right?
Tab
Use the Sum Function
The Sum function is one of the most frequently used formulas for spreadsheets. It allows you to add up large numbers quickly and automatically. Even if some of the numbers are changed later on, Excel adjusts the results to match.
Active cell
The active cell is the one that is currently outlined in black and ready for data to be entered into it.
Column width
The boundary line of columns can be dragged to increase or decrease their width. You can also double-click the line between column letters to automatically adjust the width to fit the largest value.
Category axis, or X axis
The category axis, or X axis, is located at the bottom of the chart and is used to label the categories in the chart. Excel uses the row titles for the category axis.
Cell reference
The cell reference is the name of the cell that describes where a certain column and row intersect. The cell reference consists of a letter and the number, such as C4, which is where column C and row 4 intersect. The cell reference is also called the cell address.
Chart layout
The chart layout determines how data is displayed and how the different chart elements are arranged. You can choose layout options manually or select from one of the predefined chart layouts in the Charts Layout group.
Fill handle
The fill handle is located in the lower right corner of an active cell. Click and then drag the fill handle to copy the cell contents. Copying formulas using the fill handle will adjust the cell addresses in the formulas relative to their new column and row location.
Formula bar
The formula bar displays the underlying value of the cell, which may be text, numbers, or calculations.
Underlying data
The formula being used to calculate the displayed data in a cell is the underlying data. For example, =B5+c7 is underlying data. The result, 24, would be the displayed data.
Row height
The height can be adjusted to give emphasis to the data in the row.
Row
The horizontal location of data that is labeled with numbers is a row.
Cell
The intersection of a column and a row is a cell.
Legend
The legend identifies the labels or colors assigned to the data series.
Mini toolbar
The mini toolbar is a toolbar with common formatting functions that appears by your mouse pointer.
Name box
The name box displays the name or address of the active cell. It also allows you to quickly go to a desired cell by typing the cell name and pressing the Enter key.
Range
The range is a group of two or more adjacent cells that have been selected. In the cell address box you would identify the top left of the range and the bottom right of the range. For example, B5:C7 is a range.
Data point
The range used to create the chart is outlined in a blue border. Each cell within a data series contains a data point.
Value axis, or Y axis
The value axis, or Y axis, is located on the left side of the chart. This is the numerical scale based on the charted data.
Displayed data
The value you actually see in the cell is the displayed data.
Column
The vertical location of data that is labeled with letters is a column.
AVERAGE
This function calculates the average of the values found in a range.
MAX
This is the abbreviation for "maximum." You can use this when you want to find the largest number in a list.
MIN
This is the abbreviation for "minimum." You can use this when you want to find the smallest number in a list.
Alt+=
This is the shortcut for SUM.
Go to key
This is used to move immediately to any cell location. Click Find & Select on the Home tab and then select Go to. Enter any cell address. The shortcut for this option is F5.
Ctrl+End
This moves the active cell to the last row and column containing data.
Ctrl+Home
This returns the active cell to the first cell of the row.
Arrow keys
Use the arrow keys to move between cells.
Worksheet
Workbooks are made up of one or more individual worksheets. Individual worksheets can be accessed by using the tabs across the bottom.
Enter
You can use the Enter key on your keyboard to move to the next row when entering data.
Merge & Center
You can use the Merge & Center button to combine cells for holding a title and centering text on the line.
SUM
You can use the SUM function when you want to get a total of several numbers. Use the drop-down menu next to the sum function to access the other commonly used functions.
Tab
You can use the Tab key on your keyboard to move to the next column when entering data.
Selecting a range
You can use the mouse to select a range by clicking and dragging the alphabetical column headings or row numbers.
COUNT
You can use this when you want to find how many cells have numbers in them.
Insert column or row
You may insert a column or a row by right-clicking the column name or row number and choosing Insert.
What is a workbook?
an electronic book used to organize data
The columns are named with what?
letters of the alphabet
The rows are named with what?
numbers
What is a worksheet?
one page inside the workbook