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.
Question
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.
Solution
The text seems to be a bit jumbled, but I'll do my best to match the concepts with their definitions:
-
It is a value in a Cell shown after a formula is executed - This is likely referring to the "Result of a Formula". When you input a formula into a cell in a spreadsheet program like Excel, the result of that formula is displayed in the cell.
-
Error alert - This is a message that displays when the user enters invalid data in a cell containing a validation rule. It's a feature in spreadsheet programs that helps prevent incorrect data entry.
-
Input message - This is descriptive text or instructions that inform a user about the restrictions for entering data in a cell. It's another feature in spreadsheet programs that helps guide users in their data entry.
-
When you save your file with an inappropriate name - This doesn't match with any of the provided concepts, but it seems to be referring to a "File Naming Error". This would occur if you try to save a file with a name that is not allowed by the operating system or software you're using.
Similar Questions
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 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-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 of the following correctly result in the message box output provided on the right side of the arrow with the event on the left side of the arrow when the ErrorOops sub is run? Multiple correct answers are possible.Cancel button on input box is clicked --> 3 displayed in the message box Cancel button on input box is clicked --> 1 displayed in the message boxOK button on input box is clicked when "hi" is entered --> 3 displayed in the message box 3 is entered into the input box --> 1 is displayed in the message box2 is entered into the input box --> 4 is displayed in the message box
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.