Introduction to Computers for Healthcare Professionals Chapter 7
AutoFill
A built-in, time-saving feature in which Excel automatically inserts data by following a pattern you have begun in a worksheet.
workbook (notebook)
A collection of spreadsheet pages.
worksheet
A file made up of labels (letters), values (numbers), lines or borders, and formulas. It can also contain charts, illustrations, tables, links, and special text like WordArt and text boxes.
range (block)
A group of cells defined by the upper-left and lower-right corners.
scenario
A type of what-if analysis tool and set of values that Excel saves and can substitute automatically in the worksheet. Used to forecast the outcome of a worksheet model.
Filtering data
Ability to select specific records for review. Located in the Data tab, Sort and Filter group.
AutoSum
Allows user to sum data by highlighting the cells for summation and including a blank space at the end of the series.
Graphing data
Allows you to represent data in graphic form using the Charting features. Located in the Insert tab, Chart group.
"Fluent User Interface"
Another name for the ribbon.
Chart Tools tab
Appears on the right side of the ribbon as long as a chart is selected in a worksheet.
Insert Chart dialogue box
Appears when you insert a chart type in the worksheet and provides access to Design, Layout, and Format contextual tabs for customizing charts.
Relative Addresses
Cell addresses in formulas that are designed to change when the formula is copied to other cells.
Absolute Addresses
Cell addresses in formulas that remain the same despite other changes in the worksheet. Indicated by a dollar sign ($) preceding the part that is to remain absolute.
C$R
Column address changes, row address remains the same.
=Average(range)
Function that averages the indicated values.
=STDEV(range)
Function that computes the standard deviation for the range of numbers.
=Count(range)
Function that counts the number of cells within a range that contains numbers.
=VAR(range)
Function that determines the variance for the range of numbers.
=IF(condition, true, false)
Function that returns a true value if conditions are met; returns a false value if conditions are not met.
=Max(range)
Function that returns the largest value within a range of numbers.
=Min(range)
Function that returns the smallest value within a range of numbers.
=SUM(range)
Function that sums the indicated values.
Page Layout tab
Includes the groups of Themes, Page Setup, Scale to Fit, Sheet Options, and Arrange.
Home key
Key that moves active cell to the beginning of the row.
Arrow keys
Keys which move one cell in the direction indicated.
Quick Access Toolbar
Located above the ribbon in the Title bar; you can move it below the tabs and customize it to suit your preferences.
Shift+Tab
Move one cell to the left.
Ctrl+Home
Move to beginning of worksheet.
Page Up/Down
Move to the cell one screen up/down in the same column.
Ctrl+End
Move to the intersection of last row and column containing data.
Alt+Page Up/Down
Move to the left/right one screen in same row.
cell
Placeholder for data. Occurs at a specific intersection of row and column.
little black plus sign
Pointer used to AutoFill contents of a cell to another cell or range of cells. It appears in the lower right corner of a cell when you are over the little square.
four-headed arrow
Pointer used to move cells or groups of cells from one place to another.
wide white plus sign
Pointer used to select cells that you want to work with in the spreadsheet. Used to select a range of cells.
two headed arrow with vertical bar
Pointer used to widen rows or columns. Appears when you are on the border between columns or rows.
templates
Predesigned (formatted) documents or files used as a starting point for creating output; they are used in Word, Excel, and PowerPoint to save the user from having to redesign the document or file each time it is used.
$CR
Row address changes, column address remains the same.
$C$R
Row and column addresses remain the same.
rows
Run horizontally across the spreadsheet. Beginning with 1, they are numbered down the left side of the spreadsheet.
columns
Run vertically down the spreadsheet. They are labeled from A to Z going from left to right.
Saving worksheets
Select File tab, Save
message area
Shows which actions will occur when a function or button is activated. It may also show error messages. It is usually at the bottom left of the status bar.
Data tab
Tab that allows you to import external data, view linked spreadsheets, sort and filter data, and use data tools.
View tab
Tab that contains groups that refer to how spreadsheets are viewed in preparation for printing, as drafts, or arranged in the window.
Home tab
Tab that has the most commonly used commands and features in Excel.
Formulas tab
Tab that is used to build formulas, check formulas, and create names for cells and tables. Includes the groups of Function Library, Defined Names, Formula Auditing, and Calculation.
Review tab
Tab that provides functions relating to proofing, commenting, and protecting or sharing the contents of the active Excel sheet.
Insert
Tab that provides quick access to groups related to tables, illustrations, charts, hyperlinks, and text objects.
Sorting data
The ability to specify the order of the data in the columns. Can be done alphabetically or numerically. Located in the Home tab, Editing group.
active cell
The cell in use; the program outlines or highlights it so you can locate it quickly on the worksheet.
cell address (cell reference)
The label for each cell (A1, B12, etc.).
Backstage view
The screen default when you click the File tab; this helps you work with your document.
formula bar
The toolbar at the top of the spreadsheet. The entered data or formula appears in this location on the screen for the active cell.
Tab key
This key moves one cell to the right.
Building a Formula/Function
Type = sign, type formula/function name, Enter.
Clipboard group
Under the Home tab. Contains the Cut, Copy, and Paste commands.
Proofing group
Under the Review tab. Includes Spelling, Research, Thesaurus, and Translate features.
