1. For cell and range names, names of 5 to 15 characters are considered practical, although names can be up to 255 characters. 2. Defined names are automatically substituted for existing range references in a formula. 3. The Stop alert prevents an entry from being stored in the cell. 4. Even when the worksheet is unprotected, the locked property determines whether or not changes can be made to a given cell. 5. Validation rules come into play only during data entry 6. Each macro must have a unique name that begins with a letter. 7. Running a macro means Excel performs a portion of the steps that were recorded. 8. Cell and range references do not indicate what data is stored in those cells. 9. Any blanks or parentheses in row or column labels are changed to underscore characters in defined names. 10. The Name dialog box lists all of the names currently defined in the workbook, including Excel table names. 11. To open the Data Validation dialog box, click the Data tab on the Ribbon, and then click Authentication in the Data Tools group 12. Every cell in a workbook has an locked property that determines whether or not changes can be made to that cell. 13. A digital certificate confirms that the macro created by the signer has not been altered since the digital certificate was created 14. The Visual Basic Editor is a separate application that works with Excel and all of the Office products to edit and manage VBA code. 15. One way to run a macro is to assign it to a(n) button that is placed directly on the worksheet. 16. When Excel creates a macro button, the Assign Macro dialog box opens with the button's default name showing

Statement number 3 is incorrect because the "Stop" alert is used to prevent a change or entry from being made in a cell, not to store an entry in a cell.

Statement number 8 is incorrect because cell and range references do indicate what data is stored in those cells.

Statement number 11 is incorrect because the Data Validation dialog box is accessed from the Data tab in the Data Tools group, not the Authentication group

To Know More About Authentication, Check Out

https://brainly.com/question/28398310

#SPJ4