Spreadsheets and Data Management Assignment

Using the drop-down menus, choose the term that best matches the description. The process of working with data efficiently:______________ A procedure used to display relevant information, and temporarily hide unnecessary information:_______________ More than one criteria used to locate, sort, or filter data:_______________ A tool that allows you to navigate to a specific cell, page, or object within a spreadsheet:_______________ A tool that puts arrows in the first row of each column, allowing you to select parameters to display data that matches your specifications:______________ One condition used to locate, sort, or filter data:______________ A data management procedure with options that include ascending, descending, and custom:________________

data management filter multiple parameters Go To filter simple parameters sort

Which of the following is an advantage of using the filter procedure? Check all that apply.

displays only the data you would like to view saves time prevents you from having to create multiple tables to analyze data

You have a spreadsheet with the names and birthdays of your siblings, parents, grandparents, cousins, aunts, and uncles. If you want to display only those family members with birthdays in January so you know whom to buy gifts for, which tool would you use?

filter

The spreadsheet below shows the results of your research on dog breeds. You've chosen five top breeds (1 is most; 5 is least) that you'd consider owning someday. You've included whether the breeds are good with kids, max weight in pounds, and max height in inches. Use this spreadsheet to answer the following questions to the right. Which tool would you use to display only the breeds that are good with kids? Which filter parameter would display only rows 3 and 6? Which tool would organize the list from most preferred to least preferred? Which tool would organize the list from lightest breeds to heaviest breeds? __________________ is/are needed to organize the list so that it shows only dog breeds that are good with kids and less than 25 inches tall.

filter No sort sort Multiple parameters

You have a spreadsheet with population counts for major cities in the United States. Population counts are given in different columns to show breakdown by age groups and gender. The names of cities are listed in rows. You need the population count in column 45 for the city in row 30. What tool could you use to navigate to the cell quickly?

locate

Which of the following is an advantage of using the sort procedure? Check all that apply.

preserves cell formatting and formulas saves time avoids copy-paste organizes data so it is easier to draw comparisons

You have a spreadsheet containing survey results from high school students who rated the quality of cafeteria meals. Each menu item is given a score from 1 (poor) to 5 (excellent). Which tool would you use to organize the list according to the items students liked the best?

sort

Your friend decides to create a spreadsheet containing vocabulary terms and their definitions to help prepare for the unit test in Spanish class. If your friend wants to organize the terms alphabetically from A to Z, which spreadsheet tool should be used?

sort

In what ways can you sort data by using the sort procedure? Check all that apply.

sort ascending sort descending sort by font color sort by background color sort by rows sort by columns

The spreadsheet below shows a list of fruits with their calorie count, grams of sugar, dietary fiber, and protein. Use this information to answer the questions to the right. Which tool would you use to organize the list from fewest calories to most calories? Which tool would you use to organize the list from most protein to least protein? Which tool would you use to show only fruits with 4 or more grams of dietary fiber? Which tool would you use to navigate to C5, the cell containing the grams of sugar for an orange?

sort by calories from smallest to largest sort by protein from largest to smallest filter Go To

What types of data can you filter using the AutoFilter tool? Check all that apply.

text numeric data

The spreadsheet below shows the names, years in office, and number of terms for five US presidents. Using this information, answer the questions to the right. Which parameter would display only rows 2, 4, and 6 by using the filter tool? Which tool would you use to organize the presidents alphabetically from A to Z? Which tool would you use to organize the presidents chronologically from most recent to oldest? Which tool would you use to change to data in row 6 to President James Madison?

2 sort ascending A-Z sort descending Find and replace