Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Action Explanation Filter by number of ratings Remove entries for restaurants with no customer ratings Filter by payment type Remove entries for restaurants that do not accept credit cards Sort by rating Sort the rows in the spreadsheet on column D from greatest to least ssume that applying either of the filters will not change the relative order of the rows remaining in the spreadsheet. hich of the following sequences of steps can be used to identify the desired restaurant? I. Filter by number of ratings, then filter by payment type, then sort by rating II. Filter by number of ratings, then sort by rating, then filter by payment type II. Sort by rating, then filter by number of ratings, then filter by payment type A I and Il only I and III only Il and III only I, II, and III

Action Explanation Filter by number of ratings Remove entries for restaurants with no customer ratings Filter by payment type Remove entries for restaurants that do not accept credit cards Sort by rating Sort the rows in the spreadsheet on column D from greatest to least ssume that applying either of the filters will not change the relative order of the rows remaining in the spreadsheet. hich of the following sequences of steps can be used to identify the desired restaurant? I. Filter by number of ratings, then filter by payment type, then sort by rating II. Filter by number of ratings, then sort by rating, then filter by payment type II. Sort by rating, then filter by number of ratings, then filter by payment type A I and Il only I and III only Il and III only I, II, and III

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question

Answer correct answer.

Action Explanation Filter by number of ratings Remove entries for restaurants with no customer ratings Filter by payment type Remove entries for restaurants that do not accept credit cards Sort by rating Sort the rows in the spreadsheet on column D from greatest to least Assume that applying either of the filters will not change the relative order of the rows remaining in the spreadsheet. Which of the following sequences of steps can be used to identify the desired restaurant? I. Filter by number of ratings, then filter by payment type, then sort by rating II. Filter by number of ratings, then sort by rating, then filter by payment type II. Sort by rating, then filter by number of ratings, then filter by payment type I and Il only I and III only Il and III only D I, II, and II
Transcribed Image Text:Action Explanation Filter by number of ratings Remove entries for restaurants with no customer ratings Filter by payment type Remove entries for restaurants that do not accept credit cards Sort by rating Sort the rows in the spreadsheet on column D from greatest to least Assume that applying either of the filters will not change the relative order of the rows remaining in the spreadsheet. Which of the following sequences of steps can be used to identify the desired restaurant? I. Filter by number of ratings, then filter by payment type, then sort by rating II. Filter by number of ratings, then sort by rating, then filter by payment type II. Sort by rating, then filter by number of ratings, then filter by payment type I and Il only I and III only Il and III only D I, II, and II
A large spreadsheet contains the following information about local restaurants. A sample portion of the spreadsheet is shown below. D E A B Number of Average Accepts Restaurant Name Price Range Customer Ratings Customer Rating Credit Cards 1 Joey Calzone's Pizzeria lo 182 3.5 false 2 78th Street Bistro med 41 4.5 false 3 Seaside Taqueria med 214 4.5 true 4 Delicious Sub Shop II lo 202 4.0 false Rustic Farm Tavern hi 116 4.5 true ABC Downtown Diner med -1.0 true • In column B, the price range represents the typical cost of a meal, where "lo" indicates under $10, "med" indicates $11 to $30, and "hi" indicates over $30. • In column D, the average customer rating is set to -1.0 for restaurants that have no customer ratings. A student is developing an algorithm to determine which of the restaurants that accept credit cards has the greatest average customer rating. Restaurants that have not yet received any customer ratings and restaurants that do not accept credit card are to be ignored. Once the algorithm is complete, the desired restaurant will appear in the first row of the spreadsheet. If there are multiple entries that fit the desired criteria, it does not matter which of them appears in the first row. The student has the following actions available but is not sure of the order in which they should be executed.
Transcribed Image Text:A large spreadsheet contains the following information about local restaurants. A sample portion of the spreadsheet is shown below. D E A B Number of Average Accepts Restaurant Name Price Range Customer Ratings Customer Rating Credit Cards 1 Joey Calzone's Pizzeria lo 182 3.5 false 2 78th Street Bistro med 41 4.5 false 3 Seaside Taqueria med 214 4.5 true 4 Delicious Sub Shop II lo 202 4.0 false Rustic Farm Tavern hi 116 4.5 true ABC Downtown Diner med -1.0 true • In column B, the price range represents the typical cost of a meal, where "lo" indicates under $10, "med" indicates $11 to $30, and "hi" indicates over $30. • In column D, the average customer rating is set to -1.0 for restaurants that have no customer ratings. A student is developing an algorithm to determine which of the restaurants that accept credit cards has the greatest average customer rating. Restaurants that have not yet received any customer ratings and restaurants that do not accept credit card are to be ignored. Once the algorithm is complete, the desired restaurant will appear in the first row of the spreadsheet. If there are multiple entries that fit the desired criteria, it does not matter which of them appears in the first row. The student has the following actions available but is not sure of the order in which they should be executed.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS