ribbon - ANSWER a set of menus at the top of the Excel program window
context menu - ANSWER set of options that appear when u right-click on an
object
formula bar - ANSWER appears below the ribbon and above the spreadsheet
Function structure - ANSWER =FUNCTION NAME(Argument 1, Argument
2,...)
Entering and formatting data in a spreadsheet - ANSWER "activate" a cell by
left-clicking on it with your mouse and start typing
Move on to next cell by pressing
> tab key (moves to right)
> enter key (moves to cell below
>left-clicking in another cell
referencing - ANSWER -aka "soft-coding"
-using a cell's address (B2) rather than its value in a formula
[typing numbers directly into a formula is "hard-coding"]
Referencing advantages over hard-coding - ANSWER 1. Keeps complex
formulas more organized
2. Allows a model builder to add notes and documentation to explain
assumptions about an input value
3. Creates a general equation, like an algebraic formula, which is useful as a
tool to compute an output for many possible input values
4. When an input value is used repeatedly in an analysis, referencing to a single
source value prevents errors if the numerical value needs to change
5. Enables the use of other Excel features such as Goal Seek and Data Tables
Power Query - ANSWER -aka Get & Transform
- u can import or connect to external data, and then shape that data
-for ex remove a column, change a data type, or merge tables, etc
, Freeze Panes - ANSWER keep an area of a workheet visible while you scroll
to another area of the wkst
Data Validation - ANSWER Restricts the type of data or the value that users
enter into a cell, like a dropdown lit
COUNTBLANK(range) - ANSWER count the number of empty cells in a.
range of cells
UNIQUE() - ANSWER return a list of unique values in a list or range
ROUND() - ANSWER round a number to a specified number of digits
NOT() - ANSWER when you want to make sure one value is not equal to
another
Conditional formatting - ANSWER make patterns and trends in your data
more apparent
Autofill - ANSWER fill cells with data that follows a pattern or are based on
data in other cells
FLash Fill - ANSWER automatically fills your data when it senses a pattern
Excel Error messages - ANSWER #VALUE!
#NAME?
####
#DIV/0!
#REF!
#NULL!
#N/A
#NUM!
#VALUE! - ANSWER error when it finds spaces, characters, or text in a
formula where it I expecting a number
context menu - ANSWER set of options that appear when u right-click on an
object
formula bar - ANSWER appears below the ribbon and above the spreadsheet
Function structure - ANSWER =FUNCTION NAME(Argument 1, Argument
2,...)
Entering and formatting data in a spreadsheet - ANSWER "activate" a cell by
left-clicking on it with your mouse and start typing
Move on to next cell by pressing
> tab key (moves to right)
> enter key (moves to cell below
>left-clicking in another cell
referencing - ANSWER -aka "soft-coding"
-using a cell's address (B2) rather than its value in a formula
[typing numbers directly into a formula is "hard-coding"]
Referencing advantages over hard-coding - ANSWER 1. Keeps complex
formulas more organized
2. Allows a model builder to add notes and documentation to explain
assumptions about an input value
3. Creates a general equation, like an algebraic formula, which is useful as a
tool to compute an output for many possible input values
4. When an input value is used repeatedly in an analysis, referencing to a single
source value prevents errors if the numerical value needs to change
5. Enables the use of other Excel features such as Goal Seek and Data Tables
Power Query - ANSWER -aka Get & Transform
- u can import or connect to external data, and then shape that data
-for ex remove a column, change a data type, or merge tables, etc
, Freeze Panes - ANSWER keep an area of a workheet visible while you scroll
to another area of the wkst
Data Validation - ANSWER Restricts the type of data or the value that users
enter into a cell, like a dropdown lit
COUNTBLANK(range) - ANSWER count the number of empty cells in a.
range of cells
UNIQUE() - ANSWER return a list of unique values in a list or range
ROUND() - ANSWER round a number to a specified number of digits
NOT() - ANSWER when you want to make sure one value is not equal to
another
Conditional formatting - ANSWER make patterns and trends in your data
more apparent
Autofill - ANSWER fill cells with data that follows a pattern or are based on
data in other cells
FLash Fill - ANSWER automatically fills your data when it senses a pattern
Excel Error messages - ANSWER #VALUE!
#NAME?
####
#DIV/0!
#REF!
#NULL!
#N/A
#NUM!
#VALUE! - ANSWER error when it finds spaces, characters, or text in a
formula where it I expecting a number
