Exam 12: Templates, styles, and Macros
Exam 1: Introduction to Excel100 Questions
Exam 2: Formulas and Functions100 Questions
Exam 3: Charts100 Questions
Exam 4: Datasets and Tables100 Questions
Exam 5: Subtotals, Pivot-tables, and Pivot-charts100 Questions
Exam 6: What-If Analysis100 Questions
Exam 7: Specialized Functions100 Questions
Exam 8: Statistical Functions100 Questions
Exam 9: Multiple-Sheet Workbook Management98 Questions
Exam 10: Imports, xml, and Power Add-Ins95 Questions
Exam 11: Collaboration and Workbook Distribution96 Questions
Exam 12: Templates, styles, and Macros97 Questions
Exam 13: Office 2016 Common Features100 Questions
Select questions type
The ________ directs Excel to trust files in particular folders or created by certain users.
(Short Answer)
4.8/5
(38)
You can pause the Macro Recorder in the middle of the recording process to edit mistakes.
(True/False)
4.8/5
(40)
What tool is best for automating the completion of repetitive tasks in Excel?
(Multiple Choice)
4.8/5
(40)
Data and Model,Titles and Headings,and Good,Bad,and Neutral are examples of predefined Cell ________.
(Short Answer)
4.8/5
(39)
A password on a protected workbook can be ________ characters long.
(Short Answer)
4.8/5
(38)
Correctly match the following File extensions to its best description of file type:
Correct Answer:
Premises:
Responses:
(Matching)
5.0/5
(41)
Which of the following is not a good guideline for creating a template?
(Multiple Choice)
4.9/5
(43)
Use these instead of numbers in formulas in templates whenever possible.
(Multiple Choice)
4.9/5
(42)
What line of code do you to add at the beginning of a procedure if your worksheet (Sheet 2)is protected and your procedure alters the locked cell H4,if your password is ExcelIsFun?
(Multiple Choice)
5.0/5
(33)
To modify a style,right-click the style and then select ________.
(Multiple Choice)
4.8/5
(38)
Match each of the following concepts to its best description:
Correct Answer:
Premises:
Responses:
(Matching)
4.9/5
(43)
If you forget your Excel password,you can recover it with your Microsoft account password.
(True/False)
4.8/5
(34)
Showing 61 - 80 of 97
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)