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
A _____ chart typically shows trends over time.
Free
(Multiple Choice)
4.8/5
(88)
Correct Answer:
B
A(n) _____ file contains field values separated by a common character such as a comma or tab.
Free
(Multiple Choice)
4.8/5
(91)
Correct Answer:
A
What Access tool helps you import an HTML document as a new Access table?
Free
(Multiple Choice)
4.9/5
(77)
Correct Answer:
B
Before using the Chart Wizard, you should plan which fields you want the chart to display.
(True/False)
5.0/5
(83)
To share form data among two or more programs, export the form as a(n) _____ file.
(Multiple Choice)
4.9/5
(79)
A(n) _____ is a template for creating a table that contains fields and specifies their data types.
(Multiple Choice)
5.0/5
(79)
Which of the following are ways you can import a CSV file into Access? Select all the options that apply.
(Multiple Choice)
4.7/5
(84)
Export query data as a(n) _____ file if you want to open the file in a browser.
(Multiple Choice)
4.8/5
(81)
_____ connects an Access database to data in an external file such as an Outlook folder.
(Multiple Choice)
4.8/5
(84)
The chart type that uses slices to show parts of a whole is a _____ chart.
(Multiple Choice)
4.9/5
(65)
An XML file is a text file containing Extensible Markup Language tags that identify field names and data.
(True/False)
4.8/5
(81)
A SharePoint list is a collection of data that you can share with other people who use the SharePoint site.
(True/False)
4.7/5
(77)
When you export table data to a PDF file, you need software such as _____ to view the data.
(Multiple Choice)
4.7/5
(82)
You use _____ to mark up structured data so you can easily share the data with other programs.
(Multiple Choice)
4.9/5
(72)
You can use the Chart Wizard to add a chart to a form or query.
(Short Answer)
5.0/5
(83)
When you copy data from an external file into an Access database, you are importing the data.
(True/False)
4.8/5
(71)
An Access chart displays data in rows and columns, similar to a spreadsheet.
(True/False)
4.8/5
(94)
Showing 1 - 20 of 62
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)