Ch9 Part 2 Q1 Match the words with the concept:Drag and drop options on the right-hand side and submit. For keyboard navigation...SHOW MOREPress space or enter to grab A cell containing a formula that relies on other cells to obtain its value.Dependent cellA cell containing a formula that relies on other cells to obtain its value.Press space or enter to grab A cell that is referenced by a formula in another cell.Precedent cellA cell that is referenced by a formula in another cell.

Ch9 Part 2 Q2 Match the words with the concept:Drag and drop options on the right-hand side and submit. For keyboard navigation...SHOW MOREPress space or enter to grab An area that displays the workbook name worksheet name cell addresses values and formulas so you can monitor and examine formula calculations involving cells not immediately visible on the screen.Watch WindowAn area that displays the workbook name worksheet name cell addresses values and formulas so you can monitor and examine formula calculations involving cells not immediately visible on the screen.Press space or enter to grab Occurs when a formula contains a direct or an indirect reference to the cell containing the formula.Circular referenceOccurs when a formula contains a direct or an indirect reference to the cell containing the formula.

Ch9-Q3 Match the words in the appropriate concepts.Drag and drop options on the right-hand side and submit. For keyboard navigation...SHOW MOREPress space or enter to grab 3-D ReferenceAn link that when clicked goes to another location in the same or a different worksheet opens another file opens a webpage in a Web browser or opens an email client and inserts an email address into the To box.3-D ReferencePress space or enter to grab GroupingA reference within a formula or function on one worksheet that includes the name of another worksheet column letter and row number located within a workbook.GroupingPress space or enter to grab HyperlinkThe process of selecting two or more worksheets so that you can perform the same action at the same time on all selected worksheets.Hyperlink

Ch9 Part 2 Q3 Match the words with the concept:Drag and drop options on the right-hand side and submit. For keyboard navigation...SHOW MOREPress space or enter to grab It is a value in a Cell shown after a formula is executed.Error alertIt is a value in a Cell shown after a formula is executed.Press space or enter to grab A message that displays when the user enters invalid data in a cell containing a validation rule.Input messageA message that displays when the user enters invalid data in a cell containing a validation rule.Press space or enter to grab When you save your file with an innapropriate name.When you save your file with an innapropriate name.Press space or enter to grab Descriptive text or instructions that inform a user about the restrictions for entering data in a cell.Descriptive text or instructions that inform a user about the restrictions for entering data in a cell.

In Calc, when you copy or move the formula to the other cells, the reference cellautomatically gets changed is called ____

Which of the following displays the contents of a selected cell? 1. Gridlines 2. Formula bar 3. Name box 4. Cell reference