Upgrade to remove ads
Terms in this set (14)
How do you create a new style?
Home- Cell Styles_ New Cell Style
What is a function?
a function performs a calculation that results in a single value.
What is an absolute cell reference?
an absolute cell reference contains a dollar sign in front of both the column letter and row number.
How do you select a function?
Select a function in the select a function list and then OK to display the Function arguments dialog box for the function.
The formula includes a range of values and the range does not include a value in an adjacent cell.
Formula Omits Adjacent Cells
What does the Round Function do?
The Round Function changes a value by rounding it to a specific number of decimal places.
What is sorting?
Arranging data in a specified order
What does the IF Function do
The IF function is used to make a decision based on a comparison.
What do you do if the paper had too many columns to print?
you can adjust them to make them smaller.
What is an amortization table?
It displays the interest and principle amounts for each payment of an installment loan.
What can multiple sheets in a workbook help with?
It can be used to organize, store, and link related information.
What is used to help move and copy data between sheets?
Cut, Copy, and Paste
What is a static?
When the data doesn't change when the source data changes.
What is a spreadsheet model?
a worksheet that includes related data and formulas for analyzing the data.
Sets with similar terms
SQ3R Chapter 6
BITM 215 Test 2
Excel Module 2
BA 213 Test 1
Other sets by this creator
Econ Final Exam ch. 1 and 2
Other Quizlet sets
Review of THEO 201 for Finale Exam
PSY 101 - personality
Advanced Microanatomy Exam 1
Chapter 15/16 set 2