What is global formatting? - ANS -assigns formatting to all cells in a worksheet in a workbook
what does the range finder do? - ANS -highlight the cells that provide data to the formula
When using a cell name in a
...
What is global formatting? - ANS -assigns formatting to all cells in a worksheet in a workbook
what does the range finder do? - ANS -highlight the cells that provide data to the formula
When using a cell name in a formula, what symbol is used to represent a space? - ANS -(_) underscore
What is the PMT function? - ANS --PMT(rate/12,12*years,loan_amount)
When entering a formula into a cell what does excel display? - ANS -screen tip
What is a data table? - ANS -a range of cells that shows the answers generated by formulas in which different values have been submitted
what are the two types of data tables? - ANS -one-input data table and two-input data table
how many active data tables are allowed in a worksheet? - ANS -one
What is the ROUND function? - ANS -=ROUND(number,number of digits)
What is consolidation? - ANS -the process of summarizing data included on multiple worksheets on a worksheet
what is a template? - ANS -a special workbook you can create and then use as a pattern to create new, similar workbooks
if you want to display a future date such as one week from today, what function would you use? - ANS -=NOW()+7
how do you switch from enter mode to point mode? - ANS -=clicking cells for function
what is drilling an entry - ANS -enter information and have it appear on multiple sheets
what is dummy data? - ANS -sample data used to create and test templates
what is the difference between a rocord and a row? - ANS -none
can excel perfom database operations - ANS -yes
what is the difference between merge and center and center across selection - ANS -merge and center ties the cells together
[Show More]