Critical Thinking Questions Case 2 Anna is a competitive runner. She wants to improve her performance and decides to keep track of data for six months to determine if the time of day or year affects performance numbers. On a single worksheet, she labels the columns B through E as follows: (B) Start Time, (C) End Time, (D) Total Time, (E) Distance. The rows are labeled: (2) Date, (3) Maximum, (4) Average, (5) Minimum. When she sets up the worksheet, Anna wants to the know the average distance she runs. What should she do in cell E4 to determine the average distance?
A) Enter the text =av and then select the AVERAGE function from the AutoComplete list; then enter the cell range.
B) Enter the text E2:E9 and then enter the cell range.
C) Enter the text =function and then select the AVERAGE function from the AutoFunction list; then enter the cell range.
D) Enter the text E2:E9/9 and then enter the cell range.
Correct Answer:
Verified
Q86: The TOTAL function sums the numbers in
Q87: Discuss the relationship of debugging and displaying
Q88: The HIGHVALUE function displays the highest value
Q89: A fixed dollar sign appears to the
Q90: The AVERAGE function displays the lowest value
Q92: Excel's strength lies in its handling of
Q93: The _ of a worksheet is the
Q94: A theme is a predefined set of
Q95: _ is the process of finding and
Q96: Discuss how to use conditional formatting, which
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents