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
Each page of a(n) _____ control is a container for other controls, such as text boxes or command buttons.
(Multiple Choice)
4.9/5
(75)
If you link data to an Access database, you can edit the data in the original file, but not in the Access database.
(True/False)
4.9/5
(73)
How can you send an open form as an email attachment when you are working in an Access database?
(Multiple Choice)
4.8/5
(69)
Which of the following chart types can you add to an Access report? Select all the options that apply.
(Multiple Choice)
4.9/5
(73)
When exporting to XML, Access creates an _____ helper file that contains a description of the data's characteristics.
(Multiple Choice)
4.8/5
(90)
_____ connects an Access database to data in an external file, such as an Excel spreadsheet or Outlook folder, but does not copy the data into the database.
(Multiple Choice)
4.9/5
(64)
To use data from an Access form on a webpage, you can _____.
(Multiple Choice)
4.8/5
(76)
Which of the following types of files does Access create when it exports data to the XML file format? Select all the options that apply.
(Multiple Choice)
4.8/5
(75)
How can you close a table named Services when it is displayed in Table Datasheet view?
(Multiple Choice)
4.8/5
(73)
A mail merge combines data from an Access table or form into a Word form letter.
(Short Answer)
4.7/5
(83)
When you use the Chart Wizard to add a chart to a report, your first step is to select _____.
(Multiple Choice)
4.9/5
(88)
Which of the following types of external files can you link to an Access database? Select all the options that apply.
(Multiple Choice)
4.9/5
(74)
If you export a report as a PDF file, other people can edit the report.
(True/False)
4.8/5
(89)
A delimited text file such as a CSV file stores one _____ on each line.
(Multiple Choice)
4.8/5
(73)
When you export a query as an HTML document, you are exporting the _____.
(Multiple Choice)
4.9/5
(78)
A line chart uses horizontal bars to compare values, such as annual sales for a company's sales representatives.
(Short Answer)
5.0/5
(87)
A(n) _____ file is a text file containing Extensible Markup Language tags that identify field names and data.
(Multiple Choice)
4.8/5
(73)
Showing 21 - 40 of 62
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)