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 f...
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller CertifiedGrades. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.99. You're not tied to anything after your purchase.
