CPSC 2200 Exam 1 Study Guide

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

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


Ensembles d'études connexes

ECON 410 Zhang review for test 2

View Set

Legal Environment of Business Final Exam

View Set

Microbiology - Ch. 7: Microbial Genetics

View Set

SECTION 7 - ALABAMA REAL ESTATE LAW VIOLATIONS

View Set

Implicit Bias/Health Disparities

View Set

Chapter 6: Introduction to Consumer Credit

View Set