Exam 7: Developing an Excel Application

To save a workbook with macros,the default Excel Workbook format needs to change to a macro-enabled workbook,which has the _____ file extension.

To open the Data Validation dialog box,click the Data tab on the Ribbon,and then click Authentication in the Data Tools group._________________________

Every cell in a workbook has a(n)locked property that determines whether or not changes can be made to that cell._________________________

Case 7-2 Rina has just completed some coursework in Excel application writing and wants to begin developing her own macros to share more widely.She knows that she has to learn more about digital signatures in order to make her plan a reality. -What phrase could Rina use to best describe a digital signature? 

_____ messages appear as ScreenTips next to the active cell.

Every cell in a workbook has a(n)_____ property that determines whether or not changes can be made to that cell.

In the Allow list box in the Data Validation dialog box,the _____ option means that the cell will accept only times.

A(n)_____ certificate is another name for a digital ID.

Any blanks or parentheses in row or column labels are changed to underscore characters in defined names._________________________

To remove workbook protection,click the Unprotect Workbook button in the _____ group on the Review tab.

Which of the following is NOT a valid defined name? 

In the Allow list box in the Data Validation dialog box,the ____________________ option means that the cell will accept any value entered into the cell.

Case 7-1 Ted knows that macros can be helpful to him in his work with Excel spreadsheets,but he also knows they have their hazards,so he comes to you for guidance about what kind of security settings he should put in place,and at what times. -While just getting his feet wet with Excel,you suggest to Ted that he might want to begin without having his installation of Excel have any macros run at all.Which of the following options would he select in the Trust Center? 

The Excel data _____ feature restricts data entry to follow a defined set of rules.

Each macro must have a unique name that begins with a letter.

After the comments,in VBA code the next item is the _____ of the macro.

Case 7-2 Rina has just completed some coursework in Excel application writing and wants to begin developing her own macros to share more widely.She knows that she has to learn more about digital signatures in order to make her plan a reality. -By digitally signing a workbook that contains a macro that she intends to publicly distribute,Rina assures her audience _____.

When Excel creates a macro button,the Assign Macro dialog box opens with the button's default name showing._________________________

Protecting the _____ prohibits users from renaming,deleting,hiding,or inserting worksheets.

Input messages appear as ____________________ next to the active cell.