. How to restrict the values of a cell so that only whole numbers between 9 and 99 can be entered in a cell.
Options: The Settings tab under the menu Format -> Cells
B. The Settings tab under the menu Data -> Validation
C. The Settings tab under the menu Data -> Filter -> Advanced Filter
D. the Settings tab under the menu Format -> Conditional Formatting
Ans:– B ,
Which of the following conditions is used to transmit two packets over a medium at the same time?
Options: Information about a route should not be sent back in the direction from which the original update came., It splits the traffic when you have a large bus (horizon) physical network., It holds the regular updates from broadcasting to a downed link., It prevents regular update messages from reinstating a route that has gone down.
What is the difference between ‘Open’ and ‘Open Exclusively’?
Options: a. Open statement opens access database files and Open Exclusively opens database files of other program like Oracle
b. Open Exclusive locks whole database so that no one can access it whereas Open locks only the record that is being accessed
c. Both Open and Open Exclusively are same
d. Open Exclusive command does not exist in MS Access
Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)?
Options: Each vendor desiring to be ODBC-complaint provides an ODBC driver., Requires certain criteria to be met in order to establish an ODBC connection., Provides a programming interface that provides a common language for application programs to access and process SQL databases independent of the RDBMS accessed., All of the above.
. You can embed a Microsoft Word tale in a slide by
Options: a. Clicking the insert new slide button on the standard toolbar, then double clicking table b. Clicking the insert Microsoft word table button on the formatting toolbar c. Clicking the insert Microsoft word table button on the standard toolbar d. A and c
Options: a. If you choose to select from one of the pre-made slide layouts, you can change the positioning b. If you choose to select from the pre-made slide layouts, you cannot delete the objects in the layout. c. Blank Slide is at the top of the ‘Content Layouts’ area in the Slide Layout panel. d. All of above are false statements
Which of the following describe the DHCP Discover message? It uses FF:FF:FF:FF:FF:FF as a layer 2 broadcast. It uses UDP as the Transport layer protocol. It uses TCP as the Transport layer protocol. It does not use a layer 2 destination address.