Computer Science > EXAM > Final Exam Computer Applications / WITH COMPLETE SOLUTIONS (All)

Final Exam Computer Applications / WITH COMPLETE SOLUTIONS

Document Content and Description Below

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 usi ... ng 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]

Last updated: 3 years ago

Preview 1 out of 4 pages

Buy Now

Instant download

We Accept: