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 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-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

Which keystroke shortcut should you use to display all worksheet formulas instantly?

Ch9 Part 2 Q4 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 in a worksheet that prevents a user from entering data if the worksheet is protected.Locked cellA cell in a worksheet that prevents a user from entering data if the worksheet is protected.Press space or enter to grab It simply prevents users from modifying locked cells within the worksheet.Protect sheetIt simply prevents users from modifying locked cells within the worksheet.Press space or enter to grab To lock your file so that other users can’t open it.Protect workbookTo lock your file so that other users can’t open it.

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.