Which of the following is used for recognizing a pattern in the first cell and suggesting data for the remaining rows in a column? AutoFilter Advanced Filter Flash Fill PivotTable
Added by Marina R.
Close
Step 1
Step 1: Flash Fill is used for recognizing a pattern in the first cell and suggesting data for the remaining rows in a column. Show more…
Show all steps
Your feedback will help us improve your experience
Madhur L and 71 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
Amelia has created filters but still feels the need to keep sorting and scrolling to refine her results. How can she refine her results more efficiently? - Redo the original filter. - Sort and then save as a Filter. - Create a custom filter. - Add a column to include additional data. 2. Yuji wants to use a formula as part of filtering variables of the same type in her spreadsheet. This type of data filtering is known as a _____. - Collective array formula - Basic Excel formula - Dynamic array formula - Group summary formula 3. You want to create picklists for a data-heavy spreadsheet. Which approach should you take when creating the specific items for each picklist? - Use the Advanced Filter and set the range for the entire spreadsheet. - Use the Advanced Filter to get a list of Unique Records for each data range. - Sort the entire spreadsheet, and then delete all duplicates until you get to a unique list. - Sort through each column of data to get to the Top 10.
Madhur L.
the -----feature of ms excel quickly completes a series of data
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