Study sets, textbooks, questions
Upgrade to remove ads
Kwanekqua,Lesson Five Test Review A
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?
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?
When Copying values in excel, which feature automatically adjusts cell references for the new copy location?
Which command on the home tab displays the total of the selected cells directly after the selected cells?
Where can you find the insert function button in excel?
What command totals related data in several rows by inserting totals for selected cells?
Which command on the formulas ribbon enables a user to specify when a formula is computed?
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?
What message does excel display to indicate a cell reference error?
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?
What tool do you use to check which cells are referenced in formulas that are assigned active cell?
When typing a function into a worksheet cell, what provides a description of currently selected functions?
Which option button provides a list of error-checking options following the assignment of an invalid formula to a cell?
Which mode enables you to use the mouse to select cell for use in a formula>
Other sets by this creator
Kwanekqua Lesson 5
Lesson 4 Kwanekqua
KWanekqua lesson 3