Exam 8: Performing What-If Analyses
Exam 1: Getting Started With Excel85 Questions
Exam 2: Formatting Workbook Text and Data52 Questions
Exam 3: Performing Calculations With Formulas and Functions60 Questions
Exam 4: Analyzing and Charting Financial Data37 Questions
Exam 5: Generating Reports From Multiple Worksheets and Workbooks65 Questions
Exam 6: Managing Data With Data Tools118 Questions
Exam 7: Summarizing Data With Pivottables40 Questions
Exam 8: Performing What-If Analyses56 Questions
Exam 9: Exploring Financial Tools and Functions56 Questions
Exam 10: Analyzing Data With Business Intelligence Tools60 Questions
Exam 11: Exploring Pivottable Design78 Questions
Exam 12: Developing an Excel Application94 Questions
Select questions type
In a CSV text file,a comma often separates each field value from another field value.
(True/False)
4.9/5
(28)
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.8/5
(17)
What Access tool helps you import an HTML document as a new Access table?
(Multiple Choice)
4.9/5
(40)
Which of the following types of external files can you link to an Access database? Select all the options that apply.
(Multiple Choice)
4.7/5
(40)
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.8/5
(32)
The chart type that uses slices to show parts of a whole is a _____ chart.
(Multiple Choice)
4.8/5
(36)
Each page of a(n)_____ control is a container for other controls,such as text boxes or command buttons.
(Multiple Choice)
5.0/5
(34)
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.7/5
(32)
How can you send an open form as an email attachment when you are working in an Access database?
(Multiple Choice)
4.9/5
(39)
An XML file is a text file containing Extensible Markup Language tags that identify field names and data.
(True/False)
4.8/5
(28)
A delimited text file such as a CSV file stores one _____ on each line.
(Multiple Choice)
4.9/5
(35)
To use data from an Access form on a webpage,you can _____.
(Multiple Choice)
4.8/5
(32)
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
(34)
Run the steps in a saved export using the _____ button on the External Data tab.
(Multiple Choice)
4.9/5
(37)
When you export a query as an HTML document,you are exporting the _____.
(Multiple Choice)
4.7/5
(33)
When you use the Chart Wizard to add a chart to a report,your first step is to select _____.
(Multiple Choice)
4.8/5
(37)
Showing 21 - 40 of 56
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)