how does access indicate that a filter has been applied to a specific column? !) an arrow is displayed in the field name 2) the data is in italics 3) a funnel is displayed in the field name 4) the column header is bolded
Added by Natasha M.
Step 1
Step 1: Understand the context of the question, which is about how Microsoft Access indicates that a filter has been applied to a specific column. Show more…
Show all steps
Your feedback will help us improve your experience
Narayan Hari and 83 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Narayan H.
6. On the My Car Data worksheet, use Advanced Filter to copy a subset of data to another location on this worksheet. a. Copy cells A1:Q1 and paste them in row 50. b. In cell A49, type: Criteria c. Apply the Accent 3 cell style to cell A49. d. Set up the criteria in the row(s) below row 50. Find cars where the value in the Cert Region column is CA and the value in the Hwy MPG column is greater than 80. e. In cell A53, type: Filtered Data f. Apply the Accent 3 cell style to cell A53. g. Autofit column A. h. Use Advanced Filter to find the rows that meet the criteria and copy the filtered data to another location beginning in cell A54. i. Twelve rows should have been copied from the main data set to cells A55:Q66. 7. Format the filtered data set (cells A54:Q66) as a table. Use White, Table Style Light 1 (the first table style in the gallery). Be careful not to include row 53 in the table data range. 8. Insert a new column to the left of the Greenhouse Gas Score column. Hint: Be sure to add a column to the worksheet, not just the table. a. Copy the values from cells O55:O66 to P55:P66. b. Type this column label in cell P54: Cmb MPG Icon 9. Apply a new custom conditional formatting rule to cells P55:P66 to show the 4 Ratings icon set. Show the icon only. Accept the default Values and Types. 10. Continue working with the filtered data that has the conditional formatting applied. Sort the table first alphabetically by the values in the Model column and then by icon in the Cmb MPG Icon column so the Signal Meter With Four Filled Bars icon appears at the top. 11. Go back to the main data set at the top of the My Car Data worksheet and add subtotals for each change in Model to calculate the average for the following: Air Pollution Score, City MPG, Hwy MPG, and Cmb MPG. 12. Collapse the data to show just the total rows.
Akash M.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD