Matching
Match the report problems with the probable solution.
Premises:
Each wedge represents total quarterly sales for a company.
Switch to Report Design View to open more report sections and add controls.
An expression wasn't entered correctly in a text box in Design View
Each section represents monthly sales by representative, stacked to show cumulative total sales.
Numbers should be formatted with a Currency format.
Create an expression in a text box to combine the first and last names, needs to be entered in one text box.
Each point represents monthly sales over 12 months.
Each bar represents annual sales for a different product over 12 months.
Responses:
Bar
The report contains no title or page numbers
Area
Line
Numbers do not appear with $
An #Error message appears where a calculation should appear in Print Preview
Names appear in two columns with big gaps of white space between the first and last names
Pie
Correct Answer:
Premises:
Responses:
Each wedge represents total quarterly sales for a company.
Switch to Report Design View to open more report sections and add controls.
An expression wasn't entered correctly in a text box in Design View
Each section represents monthly sales by representative, stacked to show cumulative total sales.
Numbers should be formatted with a Currency format.
Create an expression in a text box to combine the first and last names, needs to be entered in one text box.
Each point represents monthly sales over 12 months.
Each bar represents annual sales for a different product over 12 months.
Premises:
Each wedge represents total quarterly sales for a company.
Switch to Report Design View to open more report sections and add controls.
An expression wasn't entered correctly in a text box in Design View
Each section represents monthly sales by representative, stacked to show cumulative total sales.
Numbers should be formatted with a Currency format.
Create an expression in a text box to combine the first and last names, needs to be entered in one text box.
Each point represents monthly sales over 12 months.
Each bar represents annual sales for a different product over 12 months.
Responses:
Related Questions
Q61: In a report, the Narrow margin option
Q64: The Remove Layout button is provided for
Q66: You can open and close the Group
Q67: Explain the purpose of grouping controls together
Q68: A date formatted as 19-Apr-16 has a
Q74: The text in a form or report
Q75: All charts are modified in the _
Q76: The chart type that shows cumulative totals
Q81: Suzy has created a report that tracks
Q86: Aaron has created a report that tracks
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents