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
Katie needs to create hundreds of labels for a project.She plans to create a mail merge document to do so.She should select which of the following options in the Mail Merge Wizard?
Free
(Multiple Choice)
4.7/5
(39)
Correct Answer:
D
Which of the following is an important factor in deciding whether to create envelopes via mail merge or mailing labels via mail merge?
Free
(Multiple Choice)
4.7/5
(40)
Correct Answer:
A
Jane needs to print her mail merge.She should do which of the following?
Free
(Multiple Choice)
4.9/5
(41)
Correct Answer:
B
To ensure a mail merge document is free of errors,inspect the document.
(True/False)
4.8/5
(42)
Shannon needs the labels in a mail merge document to match the content and formatting of the first label.She should do which of the following?
(Multiple Choice)
4.9/5
(30)
Laila needs to correct an entry in the recipient list of a mail merge document.She should do which of the following?
(Multiple Choice)
4.8/5
(43)
Jasmine needs to insert the text "Illinois" when the State field is blank.She should do which of the following?
(Multiple Choice)
4.8/5
(26)
Which of the following fields do you need to include in a mailing envelope?
(Multiple Choice)
4.8/5
(40)
Which of the following describes the purpose of changing the vertical alignment of the page?
(Multiple Choice)
4.8/5
(31)
To create envelopes using the Mail Merge Wizard,which of the following options should be selected?
(Multiple Choice)
4.8/5
(40)
Which of the following is a reason to sort a mail merge recipient list?
(Multiple Choice)
4.9/5
(39)
To locate a recipient in a mail merge recipient list,which of the following should be done?
(Multiple Choice)
4.8/5
(41)
Kevin needs to center text between the top and bottom of a page.He should do which of the following?
(Multiple Choice)
4.7/5
(33)
Which of the following describes how to use the "Otherwise insert this text:" box when inserting an IF field in a mail merge document?
(Multiple Choice)
4.7/5
(37)
Which of the following describes a reason to insert an IF field in a mail merge document?
(Multiple Choice)
4.8/5
(33)
To exclude certain recipients from a mail merge list,sort the recipient list.
(True/False)
5.0/5
(28)
Susie is creating a recipient list for a mail merge document.She has information that she wants stored in a field called "Status." She should do which of the following?
(Multiple Choice)
4.8/5
(25)
Which of the following describes the purpose of inserting a Date Picker content control?
(Multiple Choice)
4.9/5
(36)
Showing 1 - 20 of 63
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)