Exam 8: Performing What-If Analyses
Exam 1: Getting Started With Excel94 Questions
Exam 2: Formatting Workbook Text and Data55 Questions
Exam 3: Performing Calculations With Formulas and Functions69 Questions
Exam 4: Analyzing and Charting Financial Data41 Questions
Exam 5: Generating Reports From Multiple Worksheets and Workbooks69 Questions
Exam 6: Managing Data With Data Tools120 Questions
Exam 7: Summarizing Data With Pivottables43 Questions
Exam 8: Performing What-If Analyses62 Questions
Exam 9: Exploring Financial Tools and Functions62 Questions
Exam 10: Analyzing Data With Business Intelligence Tools64 Questions
Exam 11: Exploring Pivottable Design88 Questions
Exam 12: Developing an Excel Application103 Questions
Select questions type
Export form data to a(n) _____ file to present the data as a webpage for a person, not a program, to read.
(Multiple Choice)
5.0/5
(75)
If you export form data as a(n) _____ file, you can view the data but not change it.
(Multiple Choice)
4.9/5
(79)
After you export report data to an HTML document, you can _____ the data in a browser.
(Multiple Choice)
4.7/5
(65)
If an HTML file uses _____ tags to structure its data, you can import the data as a new Access table.
(Multiple Choice)
4.8/5
(70)
An HTML document is a text file that uses _____ to mark up content stored in the file.
(Multiple Choice)
4.9/5
(71)
The _____ property indicates which field serves the link between the main form and subform.
(Multiple Choice)
4.8/5
(85)
A(n) _____ chart typically shows cumulative totals, such as combined sales totals for store locations.
(Multiple Choice)
5.0/5
(86)
Run the steps in a saved export using the _____ button on the External Data tab.
(Multiple Choice)
4.7/5
(74)
If you export report data as an RTF or XML file, you can open the exported file in a browser.
(Short Answer)
4.9/5
(75)
To export a report as an email attachment, click the _____ button in the Export group on the External Data tab.
(Multiple Choice)
4.9/5
(77)
To insert a page break in a report in Report Design view, click a section, and then press the CTRL+ENTER keys.
(True/False)
4.8/5
(89)
When you export an Access table to a(n) _____ file, you have the option to preserve the formatting and layout of the table.
(Multiple Choice)
4.9/5
(70)
In a CSV text file, a comma often separates each field value from another field value.
(True/False)
4.9/5
(91)
A chart is a visual representation of numeric data that helps users see comparisons, patterns, and trends in the data.
(True/False)
4.9/5
(88)
Which two properties control how a form and subform are linked?
(Multiple Choice)
4.8/5
(85)
You can create a mail merge in Word using name and address data stored in Access.
(True/False)
4.8/5
(89)
An advantage of emailing query results as a PDF file is that _____.
(Multiple Choice)
4.8/5
(88)
Mail fields are codes that Word replaces with field values when processing a mail merge.
(Short Answer)
4.8/5
(83)
A(n) _____ chart best illustrates the contribution of three products to total company sales in a year.
(Multiple Choice)
4.9/5
(73)
Showing 41 - 60 of 62
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)