What is the difference between a function and a formula? List two types of functions available in Excel. Describe how you would use the following functions: SUM, AVERAGE, COUNT, and MIN.
What will be an ideal response?
A formula is an equation used to calculate values in a cell. A function formula is a special formula that names a function instead of using operators to calculate a result. Statistical, mathematical, trigonometric, and logical functions are all types of functions available in Excel. * SUM is used to add the values in the specified range of cells.* AVERAGE totals the range of cells, and then divides the total by the number of entries in the specified range.* COUNT counts the number of cells with values in the specified range.* MIN shows the minimum value within the specified range of cells.
You might also like to view...
Hardware keyloggers provide screen-capture features, which users can utilize to view screenshot images of victim activity
Indicate whether the statement is true or false.
Sara, a security administrator, has generated a key pair for the company web server. Which of the following should she do next to ensure all web traffic to the company web server is encrypted?
A. Install both the private and the public key on the client machine. B. Install both the private and the public key on the web server. C. Install the public key on the web server and the private key on the client machine. D. Install the public key on the client machine and the private key on the web server.