Case-Based Critical Thinking Questions Case 3-1 Mrs

question 41

Multiple Choice

Case-Based Critical Thinking Questions Case 3-1 Mrs. Godwin's high school Environmental Science class has collected historical weather data for the months of January, February, and March for three cities.  The data has been entered into a database.  Mrs. Godwin has asked the students to answer the following questions using the Access database.
What was the highest recorded wind speed?
Which city had the highest temperature and what was the highest temperature?

Figure Case 3-1-1

Figure Case 3-1-2
Using the datasheet in Figure 3-1-1, which is the quickest method to help students determine the highest wind speed from the recorded data?

• A) create a query that includes the fields: City and Wind mph
• B) sort the Wind mph field in Datasheet view using the largest to smallest AutoFilter option
• C) use the Ascending sort option from the Sort & Filter group on the Ribbon to sort the City field
• D) create a query that includes all fields in the table and sort the Wind mph field

---

Definitions:

Date of Record

The cut-off date set by a company in order to determine which shareholders are eligible to receive a dividend or distribution.

Three-For-One Split

A stock split in which each shareholder receives three new shares for each share they currently own.

Stock Price

The stock price is the cost of a single share of a company's stock, reflecting the market's value and investors' perceptions of the company's future prospects.

Shares Outstanding

Shares outstanding refer to the total number of shares of a company’s stock that are currently owned by all its shareholders, including shares held by institutional investors and restricted shares owned by the company’s officers and insiders.