hello quizlet
Home
Subjects
Expert solutions
Create
Study sets, textbooks, questions
Log in
Sign up
Upgrade to remove ads
Only $35.99/year
Other
Computer Skills
Kwanekqua,Lesson Five Test Review A
Flashcards
Learn
Test
Match
Flashcards
Learn
Test
Match
Terms in this set (16)
When a formula contains references that allow both the address to adjust and the reference to remain constant, what is this type of reference considered?
Mixed cell reference.
Which built-in Excel feature ensures that data entered into a cell range of cells within limits?
Validation.
When a formula is copied from one cell to another, what allows the cell address to adjust the column letter and row number to the new copy location?
Relative Cell Reference.
What part of the formula is entered directly as a value?
Constant.
When Copying values in excel, which feature automatically adjusts cell references for the new copy location?
Relative Reference.
Which command on the home tab displays the total of the selected cells directly after the selected cells?
Sum.
Where can you find the insert function button in excel?
Formula bar
What command totals related data in several rows by inserting totals for selected cells?
Subtotals.
Which command on the formulas ribbon enables a user to specify when a formula is computed?
Calculation.
What type of formula in cell reference instructs excel to keep the cell reference constant in the formula as it copies it to the destination area?
Absolute.
What message does excel display to indicate a cell reference error?
#REF!
Which of the following is made up of two values and a relational operator and is true or false for each cell in the range?
Condition.
What tool do you use to check which cells are referenced in formulas that are assigned active cell?
Range Finder.
When typing a function into a worksheet cell, what provides a description of currently selected functions?
Screen tip.
Which option button provides a list of error-checking options following the assignment of an invalid formula to a cell?
Trace error.
Which mode enables you to use the mouse to select cell for use in a formula>
Point mode.
Other sets by this creator
Lesson 6
12 terms
Kwanekqua Lesson 5
15 terms
Lesson 4 Kwanekqua
9 terms
KWanekqua lesson 3
12 terms