Excel - Ch 1 Flashcards
Electronic file that contains grid of columns/rows used to organize related data ; displays results of calculations, enabling interpretation of quantitative data for decision making
Spreadsheet
Single spreadsheet that typically includes labels, numeric values, formulas, functions, and graphical representations of data
Worksheet
Collection of 1+ related worksheets; housed within single file to keep organized
Workbook
Element located below Ribbon, displays address of the current active cell (can use to go to cell, assign name to cell, select function)
Name Box
Dialogue box that pops up, used to search for & select a function into the active cell
Insert Function
Below ribbon, right of insert function; shows content of active cell; enter/edit here or in cell directly
Formula Bar
Letters A - Z, AA - ZZ, etc.
Column Headings (Horizontal)
Numbers 1 - x
Row Headings (Vertical)
Current Cell, indicated by a dark green border
Active Cell
Visual Label, looks like folder tab; can be renamed and coloured
Sheet Tab
Display at bottom of Excel; shows info of selected command / operation in progress
Status Bar
Normal. Page Layout, Page Break Preview
View Controls
Displays worksheet without margins, headings, footers, page breaks
Normal View
Shows margins, header/footer area, ruler
Page Layout View
Indicates where worksheet will be divided into pages
Page Break View
Intersection of columns/row
Cell
Identified by column letter/row number; unique
Cell Address
Moves to Cell A1
Ctrl+Home
Moves to last cell with data
Ctrl+End
Region in the worksheet to contain formulas dependant on values in input area
Output Area
Region in worksheet to store & change variables used on calculations
Input Area
Any combination of letters/numbers/symbols/spaces not used in a calculation
Text
Searches/Automatically displays any other label in same column that matches
Autocomplete
Helps you complete sequence of word/values (days, months, other key words)
Autofill
Small green square in bottom-right corner of active cell
Fill Handle
Uses data in previous columns as you type in a new label in an adjoining column to determine what to fill in
Flash Fill
Numbers that represent a quantity or measurable amount; align at right of cell margin
Value
Combines cell references, arithmetic operations, values, and/or functions used in calculations; use to help analyze how results change as input changes
Formulas
Order of Operations [ ( ) , ^ , * , / , + , - ]
PEDMAS
Process of selecting cell/ranges of cells for entering cell references as you create formulas
Semi-Selection
Horizontal measurements of a column in table worksheet
Column Width
How to fix ###### in a cell
Double Click to AutoAdjust
Vertical measurement of row; should always be bigger than font size
Row Height
Refers to group of adjacent/contiguous cells in a worksheet; may be 1 cell or many long; specified by indicating top left & bottom right cells
Range
Contains multiple ranges, not connected
Nonadjacent Range
Paste Options - Formulas but no Formatting
Paste Formulas
Paste Options - Formula & Number Formatting (Currency, etc.) but not Font
Paste Formulas & Number Formatting
Paste Options - Cell contents & Formatting from copied cells
Paste Keep Source Formatting
Paste Options - Cell contents, number formatting, and text except borders
Paste No Borders
Paste Options - Cell contents, number & text formatting, and column width of source data
Paste Keep Source Column Widths
Paste Options - Changes data from rows to columns
Paste Transpose
Paste Options - Unformatted values that are result of formulas (not the formulas)
Paste Values
Paste Options - Values that are results from formulas (but not the formulas); preserves number but not text formatting
Paste Values & Number Formatting
Paste Options - Values that are results from formulas (not actual formulas); fa dfjafo ajfl
Paste Values & Source Formatting
Paste Options - Number & text formatting only from copied cells; no cell contents
Paste Formatting
Paste Options - Creates reference to source cells, not cell contents; preserves # format but not text format
Paste Link
Paste Options - Creates picture image of copied data; pasted data is not editable
Paste Picture
Paste Options - Creates picture with reference to copied cells; changes if original changes
Paste Linked Picture
Paste Options - Opens special paste dialogue box
Paste Special
Collection of format settings to provide consistent appearance (font, font colour, font size, borders/fill borders, alignment, number formatting)
Cell Style
How data is positioned in boundaries of cell; different defaults depending on data (text = left ; dates/values = right)
Alignment
How to create titles; select the cells you want included
Merge (& Center; Across)
Specifies position of data between left/right margins
Horizontal Alignment
Specifies position of data between top/bottom of cell margins (Bottom alignment is default)
Vertical Alignment
Make data appear on multiple lines
Wrap Text
Change to offset data from current alignment (left or right)
Indent
Line that surrounds cell or range of cells; can use to offset data from the rest
Border
Background colour that displays behind data in cells to standout; should contrast w/ cell font colour
Fill Colour
Settings that control how value is displayed in cell
Number Formats
Number Formats : number shows as entered originally (##)
Number Formats : General
Number Formats : number without comma, with decimal points at end; negatives are -
Number Formats : Number
Number Formats : has $ and commas where appropriate ; 2 decimal places by default
Number Formats : Currency
Number Formats : $ is on left margin, separate from the number; 2 decimal places
Number Formats : Accounting
Number Formats : formatted with comma every 3 digits
Number Formats : Comma Style
Number Formats : Long Date (October 15th 1990) or Short Date (10/15/1990)
Number Formats : Date
Number Formats : standard or military
Number Formats : Time
Number Formats : value as it would be multiplied by 100 with %
Number Formats : Percentage
Number Formats : number as fraction
Number Formats : Fraction
Number Formats : number as decimal fraction followed by whole exponent of 10
Number Formats : Scientific
Number Formats : data left aligned; useful for numerical vales that have leading zeros (address, phone #)
Number Formats : Text
Number Formats : number w/ editing characters (like hyphens); used for SIN, phone #, etc)
Number Formats : Special
Number Formats : predefined customized # formats or special symbols; create your own
Number Formats : Custom
.75” top/bottom ; .70” left/right
Margin Defaults
Header/Footer Elements : &[Page]
Header/Footer Elements : Page #
Header/Footer Elements : &[Date]
Header/Footer Elements : Current Time
Header/Footer Elements : &[Pages]
Header/Footer Elements : Display Total # of Pages to Print
Header/Footer Elements : &[File]
Header/Footer Elements : Displays File Name
Header/Footer Elements : &[Path] &[File]
Header/Footer Elements : Displays File Path & Name
Header/Footer Elements : &[Tab]
Header/Footer Elements : Displays Sheet Tab Name
Header/Footer Elements : &[Picture]
Header/Footer Elements : Display & Print Picture as Background