Exam 10: Data Analysis With Power Tools and Creating Macros
Exam 1: Creating a Worksheet and a Chart66 Questions
Exam 2: Formulas, Functions, and Formatting68 Questions
Exam 3: Working With Large Worksheets, Charting, and What-If Analysis75 Questions
Exam 4: Financial Functions, Data Tables, and Amortization Schedules70 Questions
Exam 5: Working With Multiple Worksheets and Workbooks72 Questions
Exam 6: Creating, Sorting, and Querying a Table63 Questions
Exam 7: Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots64 Questions
Exam 8: Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers67 Questions
Exam 9: Formula Auditing, Data Validation, and Complex Problem Solving74 Questions
Exam 10: Data Analysis With Power Tools and Creating Macros68 Questions
Exam 11: User Interfaces, Visual Basic for Applications Vba, and Collaboration Features in Excel56 Questions
Select questions type
To allow a person viewing a document to insert a picture,add a picture content control.
Free
(True/False)
4.8/5
(41)
Correct Answer:
True
To add a content control that allows a person to enter text or choose from a list of text options,insert a combo box content control.
Free
(True/False)
4.9/5
(34)
Correct Answer:
True
Dan needs to ensure that changes people make to a document are tracked using track changes.He should allow which type of editing after applying editing restrictions?
Free
(Multiple Choice)
4.9/5
(44)
Correct Answer:
A
To create a content control that allows people to enter plain text,insert a Date Picker Content Control.
(True/False)
4.8/5
(31)
Kendall wants people viewing a document to only be able to leave comments.She should allow which type of editing after applying editing restrictions?
(Multiple Choice)
4.9/5
(39)
To allow a person viewing a document to enter specific text from a list of choices,insert a drop-down content control.
(True/False)
4.7/5
(38)
To add a content control that allows a person to enter text or choose from a list of text options,which of the following should be inserted?
(Multiple Choice)
4.9/5
(38)
To add a content control that allows users to select from a variety of AutoText options,which of the following should be done?
(Multiple Choice)
4.9/5
(24)
To bring a picture in front of another picture in a document,which of the following should be done?
(Multiple Choice)
4.7/5
(36)
Sharron needs to create a letter envelope using Word.In order to ensure the envelope prints properly,she should do which of the following?
(Multiple Choice)
4.8/5
(36)
To modify the fill of a rich text content control,which of the following should be done?
(Multiple Choice)
4.8/5
(32)
Two pictures in a document are overlapping.To move the topmost picture behind the other picture,which of the following should be done?
(Multiple Choice)
4.8/5
(33)
To create a dashed line around a shape,which of the following should be done?
(Multiple Choice)
5.0/5
(35)
Jeremy needs to prevent people from modifying the formatting of a document.He should do which of the following?
(Multiple Choice)
4.9/5
(41)
A picture that should be in the background is obscuring several shapes.To move the picture to the back,which of the following should be done?
(Multiple Choice)
4.8/5
(31)
To create a content control that allows people to enter formatted text,insert a Rich Text Content Control.
(True/False)
4.8/5
(34)
To create a page color,which of the following should be done?
(Multiple Choice)
5.0/5
(37)
Adam needs people viewing a document to be able to place a check mark in a box.He should do which of the following?
(Multiple Choice)
4.7/5
(39)
To create a content control that allows people to place a check in a box,which of the following should be done?
(Multiple Choice)
4.9/5
(36)
Showing 1 - 20 of 68
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)