CPSC 2200 Exam 1 Study Guide
Cell reference
= (Cell)
Formula Bar
A bar that shows the contents (text, value, date, formula, or function) stored in the active cell
Workbook
A collections of one or more related worksheets contained within a single file
Name Box
A rectangular area that displays the address or name of the active cell, selected chart, or selected table. Used to go to a cell or table, select a range, or assign a name to one or more cells
Worksheet
A spreadsheet that usually contains descriptive labels, numeric values, formulas, functions, and charts
AVERAGE function
Calculates the arithmetic mean, or average, of values in a range.
Move or Copy Worksheet
Click and drag a worksheet tab left or right to move it to a new location. right click sheet tab to copy
Spreadsheet
Electronic file that contains a grid of columns and rows to organize related data and to display results or calculations
Column Heading
Letter used to identify a column in a worksheet
lookup and reference
Looks up values, creates links to cells, or provides references to cells in a worksheet
Merge Cells
Merge and center to combine selected cells, used for centering titles over groups of related columns
math and trig
Performs standard math and trigonometry calculations
Sheet Tab
Shows the name of a worksheet contained in the workbook
MINA function
Statistical: Returns the smallest value in a list of arguments, including numbers, text, and logical values
Paste Options
a button that enables the user to apply different paste options
Cell Style
a collection of format characteristics
nonadjacent range
a collection of multiple ranges
Insert Function
a command that displays the insert function dialog box to search for and select a function to insert into the active cell
Enter
a command used to accept data typed in the active and keep the current cell active
New Sheet
a command used to insert a new worksheet to the right of the current worksheet
mixed references
a designation that combines an absolute cell reference with a relative cell reference
Relative references
a designation that indicates a cell's relative location from the original cell containing the formula; reference changes when the formula is copied
absolute references
a designation that indicates a constant reference to a specific cell location; the cell reference does not change when you copy the formula
autofill
a feature that completes a sequence of months, abbreviated months, quarters, weekdays, weekday abbreviations, or values. also fills or copy a formula down a column or across a row
Formula AutoComplete
a feature that displays a list of functions and defined names that match letters as you type a formula
autocomplete
a feature that searches for and automatically displays any other text in that column that matches the letters you type
Flash fill
a feature that uses data from other columns to determine a pattern as you type and fills in results in the remaining rows based on that pattern
indent
a format that offsets data from its default alignment
MEDIAN function
a function that finds the numerical midpoint value
MAXA function
a function that returns the largest number in a range of numbers evaluating any text value as a zero
range
a group of adjacent or contiguous cells in a worksheet
Excel Border
a line that surrounds a cell or a range of cells to offset particular data from the rest of the data in a worksheet
Go to
a navigation feature to go to a specific page in word or a specific cell in excel
Accounting number format
a number format that displays $ on the left side of a cell, formats a value with a comma for every three digits on the left side of the decimal point, and displays two digits to the right side of the decimal point
currency format
a number format that displays $ to the immediate left of the value, formats a value with a comma for every three digits on the left side of the decimal point, and displays two digits to the right side of the decimal point
percent style
a number format that displays a value as if it were multiplied by 100 and with the % symbol
Comma Style
a number format that formats a value with a comma for every three digits on the left side of the decimal point and displays two digits to the right of the decimal point
Values
a number that represents a quantity or a measurable amount
row heading
a number used to identify a row in a worksheet
excel arguments
a positional reference contained within parentheses in a function such as a cell reference or value, required to complete a function and produce output
MIN function
a predefined formula that displays the lowest value in a range
input area
a range of cells in a worksheet used to store and change the variables used in calculations
Order of operations
a set of rules that controls the sequence in which arithmetic operations
Number format
a setting that controls how a value appears in a cell
Sum functions
a stat function that calculates the total of values contained in one or more cells(=SUM(A2:A14))
page break preview
a view setting that displays page breaks within the worksheet
Page layout view
a view setting that displays the worksheet data, margins, headers, and footers
AutoSum
a way to quickly apply basic aggregate functions to a continuous array of values
Wrap Text
alignment option that word-wraps data on multiple lines within a cell
text
any combinations of letter, numbers, symbols, and spaces
Entering a number as a text
apostrophe and the number
view and zoom controls
buttons that enable you to change to normal, page layout, or page break view to display the worksheet
Formula
combines cell references, arithmetic operations, values, and/or functions used in a calculation
Cancel
command used to cancel date being entered or edited into the active cell
Page tab
contains options to select the orientation and paper size
Display Cell formulas
ctrl "`"
Changing reference types
ctrl F4
Active cell
current cell in a worksheet
print area
designates the selected range to print instead of printing the entire worksheet
size
displays a list of standard paper sizes
breaks
displays a menu to insert or remove page breaks
Margins
displays a menu to select predefined margin settings, can also be used to set custom margins
orientation
displays orientation options (default portrait)
background
enables you to select an image as the background behind the worksheet data when viewed onscreen
print titles
enables you to select column headings and row labels to repeat on multiple-page printouts
AVERAGEA function
evaluates any cell containing text (such as N/A) as a zero value but includes items in the divisor
fill handle
fill handle and drag it to repeat the contents of the cell to other cells or to copy a formula in the active to adjacent cells down the column or across the row
Hiding and Unhiding a column or row
format in cell group and hide/unhide
Adjust row height
height should be taller than font size, right click and adjust row height
Increasing or Decreasing decimal places
increase decimal or decrease decimal place in the number group
Brackets []
indicates optional arguments (do not include [ ] in the argument)
#NAME?
mistyped function name
statistical
performs common statistical calculations such as averages and standard deviation
financial
performs financial calculations, such as payments, rates, present value, and future value
logical
performs logical tests and returns the value of the tests (AND, OR, NOT)
Horizontal alignment
placement of cell data between the left and right cell margins (default text left aligned and default values are right aligned)
Vertical Alignment
placement of cell data between the top and bottom cell margins
function
predefined computation that simplifies creating a complex calculation and produces a result based on inputs known as arguments
Precision selecting
process of deselecting a range of selected cells (ctrl click and drag)
date and time
provides methods for manipulating date and time values
output area
range of cells in an excel worksheet that contain formulas dependent on the values in the input area
Sheet Tab Page Setup
repeat rows containing column labels at the top of each page
Increasing column width
right and adjust column width (if column is too narrow (####) is displayed)
Insert Rows or Columns
right click active cell and select insert sheet column or row
renaming worksheets
right click and rename
Moving a range
select a range, cut and paste
Adjusting all columns and rows
select all function
Deleting rows or columns
select column or row heading and then click delete, existing data moves up
syntax
set of rules that governs the structure and components for properly entering a function
set margins tab
sets specific margins and centers the worksheet data horizontally or vertically
Function ScreenTip
small pop-up description that displays the function arguments
Fill Color
the background color that displays behind the data in a cell so that the data stand out
active sheet
the currently displayed worksheet
Normal view
the default view of a worksheet that shows worksheet data but not margins, headers, footers, or page breaks
Cell
the intersection of a column and a row is a cell
Excel Alignment
the placement of data within the boundaries of a cell
Semi-Selection/Pointing
the process of using the pointer to select cells while building a formula
cell address
the unique identifier of a cell, starting with the column letter and then the row number
Select All
triangle at the intersection of the row and column headings in the top-left corner of the worksheet used to select everything contained in the active worksheet
Sheet tab scroll controls
used to scroll through sheet tabs