Simnet EXCEL Verified Answers
accounting with no $ sign ✅comma format
autosum ✅sigma
quick analysis tool ✅1. select cells
2. button appears in corner with tools
display characteristics in the status bar ✅1. right click status bar
2. add min, max, count, avg, etc
format painter ✅1. copies formatting from current cell
2. click cell you want with the same format
count function ✅counts the number of cells that contains numbers within the specified range of cells
counta function ✅counts the number of cells that are not blank within the specified range of cells
countblank function ✅counts the number of cells that are blank within the specified range
min & max function ✅finds the min/max within a specified range
now and today functions ✅update every time the workbook is opened
now: time and date
today: date
, naming cells ✅rename in name box
naming many cells ✅1. formulas -> create from selection
2. name based off column titles
rename ✅1. formulas -> name manager
2. look for duplicate names
this becomes a problem when referencing
payment function ✅PMT(interest rate, # of loan pmts, loan principal amt)
* to calc monthly pmts, divide interest rate by 12
VLookup entries ✅lookup_value
table_array
col_index_num
range_lookup (optional)
lookup_value ✅value you are looking up to find something about it -> must be in the first column
table_array ✅range name
col_index_num ✅the column it will be found in
range_lookup ✅type FALSE if you want an exact match
freeze ✅if you want to always see the top row/left column
1. view -> window -> freeze panes
*freeze panes (1st option) will freeze both
accounting with no $ sign ✅comma format
autosum ✅sigma
quick analysis tool ✅1. select cells
2. button appears in corner with tools
display characteristics in the status bar ✅1. right click status bar
2. add min, max, count, avg, etc
format painter ✅1. copies formatting from current cell
2. click cell you want with the same format
count function ✅counts the number of cells that contains numbers within the specified range of cells
counta function ✅counts the number of cells that are not blank within the specified range of cells
countblank function ✅counts the number of cells that are blank within the specified range
min & max function ✅finds the min/max within a specified range
now and today functions ✅update every time the workbook is opened
now: time and date
today: date
, naming cells ✅rename in name box
naming many cells ✅1. formulas -> create from selection
2. name based off column titles
rename ✅1. formulas -> name manager
2. look for duplicate names
this becomes a problem when referencing
payment function ✅PMT(interest rate, # of loan pmts, loan principal amt)
* to calc monthly pmts, divide interest rate by 12
VLookup entries ✅lookup_value
table_array
col_index_num
range_lookup (optional)
lookup_value ✅value you are looking up to find something about it -> must be in the first column
table_array ✅range name
col_index_num ✅the column it will be found in
range_lookup ✅type FALSE if you want an exact match
freeze ✅if you want to always see the top row/left column
1. view -> window -> freeze panes
*freeze panes (1st option) will freeze both
