A:A is the list of all Students' names with the format: Lastname Midname Firstname (i.e: Tran Van Thu) To count how many students with firstname as 'Van', the BEST function to use is:

A. =COUNTIF(A:A, "Van*")
B. =COUNTIF(A:A, "*Van")
C. =COUNTIF(A:A, "Van")
D. =COUNTIF(A:A, "&Van*")


B. =COUNTIF(A:A, "*Van")

Computer Science & Information Technology

You might also like to view...

Authentication makes use of the _________ message authentication code.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

Print a screen dump of your favorite Web browser. With a pencil, label the navigational aids that help build context for a user.

What will be an ideal response?

Computer Science & Information Technology

Which of the following is NOT true about OOP languages?

A. A disadvantage of OOP is that you cannot reuse or modify existing objects.  B. An IDE contains tools for building GUIs, editor, a compiler and/or interpreter, and a debugger. C. An object represents a real person, place, event, or transaction. D. Java and C++ are examples of OOP languages. 

Computer Science & Information Technology

____, which runs under the Linux operating system, can report similar information as NetStumbler, such as the SSID.

A. Kismet B. KisMAC C. WZC D. GPSMac

Computer Science & Information Technology