Exam 6: Creating, Sorting, and Querying a Table
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
Karen needs to find a recipient in a recipient list whose last name is Brady.The list also contains recipients whose first name is Brady.She should do which of the following?
(Multiple Choice)
4.8/5
(38)
Jordan has an open document that he needs to use in a mail merge.He should select which of the following options in the Mail Merge Wizard?
(Multiple Choice)
4.8/5
(37)
Jasmine needs to locate a recipient in a mail merge recipient list.She should do which of the following?
(Multiple Choice)
4.7/5
(39)
Ian wants to create a mail merge document based on a template from Office.com.He should select which of the following options when starting the mail merge?
(Multiple Choice)
4.7/5
(43)
To follow a step-by-step process for creating a mail merge,start the Mail Merge Wizard.
(True/False)
4.8/5
(38)
To enable people viewing a document to enter a date,which of the following should be done?
(Multiple Choice)
4.9/5
(52)
Jacki has a document on her Desktop that she needs to use in a mail merge.She should select which of the following options in the Mail Merge Wizard?
(Multiple Choice)
4.9/5
(37)
Joanne needs to have text inserted in a mail merge document if the recipient's city is "Fairview." She should do which of the following?
(Multiple Choice)
4.9/5
(41)
To add a greeting line to a mail merge document,insert the Title merge field.
(True/False)
4.8/5
(36)
To set a document's page layout to landscape,change the page orientation.
(True/False)
4.8/5
(39)
To specify which recipients to include in a mail merge,select mail merge recipients.
(True/False)
4.8/5
(34)
Daniel needs to enable people viewing a document to enter a date.He should do which of the following?
(Multiple Choice)
4.8/5
(31)
Karen is working on a mail merge document and needs to add the text "Dear," followed by the recipient's name and a comma.She should do which of the following?
(Multiple Choice)
4.8/5
(36)
Amed needs his mail merge document to print alphabetically according to the City field.He should do which of the following?
(Multiple Choice)
4.8/5
(42)
Tim needs to view how a mail merge document will appear after merge fields have been filled.He should do which of the following?
(Multiple Choice)
4.8/5
(39)
To arrange recipients in a mail merge alphabetically by last name,which of the following should be done?
(Multiple Choice)
4.9/5
(33)
To align document text to the bottom of the page,which of the following should be done?
(Multiple Choice)
4.9/5
(43)
To individually modify the results of a mail merge,which of the following options should be selected?
(Multiple Choice)
4.9/5
(32)
Susan needs to send the results of a mail merge to clients who may or may not have Microsoft Office installed.She wants clients to be able to open a viewable version of the document.She should do which of the following?
(Multiple Choice)
4.8/5
(40)
Laura is working on a mail merge with hundreds of recipients.The address of one of the recipients needs to be corrected.She should locate the recipient by doing which of the following?
(Multiple Choice)
4.9/5
(31)
Showing 41 - 60 of 63
Filters
- Essay(0)
- Multiple Choice(48)
- Short Answer(0)
- True False(15)
- Matching(0)