Question

The spreadsheet below shows the names years in office, and number of terms for five US presidents

President
George W. Bush
3 Jimmy Carter
4 George Washington
5 Martin Van Buren
6 Ulysses S. Grant
Years in Office Number of Terms
2001-2009
1977-1981
1789-1797
1837-1842
1869-1877
Which tool could be used to display only rows containing presidents who served two terms?
filter
find and replace
sort ascending
go to

Answer 1

Filter

Step-by-step explanation:

If you filter out all the presidents that did not serve two terms so you would be left with the presidents that served two terms.

Answer 2

Which parameter would display only rows 2, 4, and 6 by using the filter tool?

✔ 2

Which tool would you use to organize the presidents alphabetically from A to Z?

✔ sort ascending A-Z

Which tool would you use to organize the presidents chronologically from most recent to oldest?

✔ sort descending

Which tool would you use to change to data in row 6 to President James Madison?

✔ Find and replace

Step-by-step explanation:

Completed it on Edge