You are working on a spreadsheet that contains many different kinds of calculations. Your supervisor knows that Excel has built-in functions for many of the calculations.
Your spreadsheet contains a set of test results, and your supervisor needs to know information such as the average, maximum, and minimum. Which set of functions should you use in your spreadsheet?

What will be an ideal response?


You should use the statistical set of functions to calculate statistical values, such as the AVERAGE, MIN, and MAX of a set of data.

Computer Science & Information Technology

You might also like to view...

Files static method ________ receives a Path and returns a boolean indicating whether that Path represents a directory on disk.

a. isDiskDirectory b. isDirectory c. isFileDirectory d. isPath

Computer Science & Information Technology

Before converting a range to a table, you should make a copy of the worksheet, since you CANNOT convert a table back into a range

Indicate whether the statement is true or false

Computer Science & Information Technology

A user called to inform you that the laptop she purchased yesterday is malfunctioning and will not connect to her wireless network. You personally checked to verify that the wireless worked properly before the user left your office. The user states she rebooted the computer several times but the problem still persists.   Which of the following is the first step you should take to assist the user in resolving this issue?

A. Inform the user she will need to return the laptop so you can replace the internal Wi-Fi card and verify wireless functionality. B. Have the user press the appropriate function key combination to enable the wireless radio and then attempt to connect to the wireless network. C. Instruct the user on how to reseat the internal mini-PCIe wireless adapter and try to connect to the wireless network. D. Ask the user to turn on the laptop’s airplane mode and attempt to reconnect to the wireless network.

Computer Science & Information Technology

What is the Linux/Mac OS equivalent of tracert?

A. ipconfig B. traceroute C. tracert D. telnet

Computer Science & Information Technology