UNIT E EXCEL Flashcards
COMPUTERS UNIT E EXCEL
Convert text to column
breaks data fields in one column into separate columns
Delimiter
separator, such as space, comma or semicolon used to separate data elements
PROPER function
capitalizes the first letter of a word in a column example: =PROPER(A1)
Data Tab
lets you work with conversion
UPPER
converts text to all caps
LOWER
converts text to all lowercase
IF commands
are used based on different conditions
Consolidate
summarizes similar data that exist in different sheets
Link
allows you to references data in other sheets or in other workbooks
External reference indicator
cells referenced are outside of the active sheet
IFEROR
displays a message or value that you specify, rather than the one automatically generated by Excel
Circular reference
contains a formula that refers to its own cell location
DIV/O!
a number is divided by 0
NA
a value in a formula is not available
3-D reference
reference other sheets - which creates another dimension