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 remove the line around a table,which of the following should be done?
(Multiple Choice)
4.8/5
(31)
To uniquely identify a content control in a document,which of the following should be done?
(Multiple Choice)
4.7/5
(38)
To allow a person viewing a document to enter specific text from a list of choices without the option to enter custom text,which of the following kinds of content control should be inserted?
(Multiple Choice)
4.9/5
(33)
To prevent people from modifying the formatting of a document,which of the following should be done?
(Multiple Choice)
4.8/5
(38)
To insert content controls,ensure that the Developer tab is displayed.
(True/False)
4.8/5
(35)
Samantha created a survey for distribution.She wants to ensure people taking the survey are only able to fill in the form,without making changes to the form itself.She should apply which type of editing restrictions?
(Multiple Choice)
4.7/5
(35)
To save a Word document as a template,which of the following should be done?
(Multiple Choice)
4.8/5
(28)
Two shapes in a document are overlapping.To move the topmost shape behind the other shape,align the shape to the bottom.
(True/False)
5.0/5
(33)
To create a content control that allows people to enter formatted text,which of the following should be done?
(Multiple Choice)
4.9/5
(37)
To remove restrictions from a document,which of the following should be done?
(Multiple Choice)
4.9/5
(38)
Henry needs to create a tabloid-sized poster using Word.In order to ensure the poster prints properly,he should do which of the following?
(Multiple Choice)
4.8/5
(30)
A picture that should be in the background is obscuring several shapes.To move the picture to the back,change the alignment.
(True/False)
4.9/5
(34)
To change the color of a drop-down list content control,which of the following should be done?
(Multiple Choice)
4.9/5
(24)
To restrict editing to filling in forms,which type of editing after applying editing restrictions should be allowed?
(Multiple Choice)
4.8/5
(35)
Jasmine needs to add choices to a drop-down list content control.She should do which of the following?
(Multiple Choice)
4.9/5
(46)
To add a content control that allows users to select from a variety of AutoText options,add a plain text content control.
(True/False)
4.8/5
(29)
To prevent people from editing a document,which of the following should be done?
(Multiple Choice)
4.9/5
(29)
To add repeating pieces of information to a form,insert a repeating section content control.
(True/False)
4.8/5
(35)
To edit the placeholder text of a plain text content control,enter Design mode.
(True/False)
4.9/5
(31)
To add choices to a drop-down content control,which of the following should be done?
(Multiple Choice)
4.8/5
(33)
Showing 41 - 60 of 68
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)