The ________ function is used to calculate the average of a range of cells that meet one criterion
A) AVERAGEIFS
B) AVERAGE
C) AVG
D) AVERAGEIF
Answer: D
You might also like to view...
How many host bits are borrowed if four subnets are created?
What will be an ideal response?
Read the following scenario. Provide the command(s) in the context of the environment established in the scenario. Write your answers on the line under each question.
- Assuming the date string is Wed Nov 29 14: 00: 52 EDT 2005 1. Write the output of the command: date +%H 2. Write the output of the command: date '+DATE: %m %d %y' 3. Write the output of the following commands: Y=`date +%y` echo $Y 4. Write the command(s) to display the sum of the variables x and y 5. Write the command(s) to display the product of the variables x and y 6. Write the command that makes the file called Xfile an executable file - Assume you have a script file called testing. You execute testing as follows: testing one two three and the rest Write the output of the following commands 7. echo $0 8. echo $2 9. echo $# 10. echo $@ 11. echo $* 12. Write the script that displays "hi" five times, using the for loop 13. Write the script that displays "hi" five times, using the while loop 14. Write the script that displays "hi" five times, using the until loop 15. Write the script that reads your name from the keyboard and displays (echoes) it on the screen. 16. Write a script file called cm (change mode) that changes the specified file mode to executable. The filename is specified on the command line as follows: cm xyz 17. Write a script file called sdate that reads the system date and displays the date string in the following format: Time: Day: Month: Year:
All of the following are popular video container formats EXCEPT ____.
A. MP3 B. MPEG C. ASF D. Flash video
A fingerprint lock will keep the computer more secure by allowing
A) Only preconfigured fingerprints to unlock the screen B) Only family members' fingerprints to unlock the computer C) Only a computer technician unlock the computer D) Facial recognition as well as fingerprints to unlock the PC