. When a row of data is to be converted into columns
Options: a. Â Copy the cells in row, select the same number of cells in row and paste
b. Â Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK
c. Â Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK
d. Â Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK.
The advantage of a command processor running only built-in commands is:
Options: flexibility to the users in running lists of commands by simply collecting them in named batch command files, the command set being common across different hardware configurations, users can create system programs and run them as commands, the processing is much faster than would other-wise be the case when user defined commands are used
Each answer below shows example data from a table. Which answer is an example of the inconsistent values problem?
Options: Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row., Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column., Three rows have the values Brown, NULL, and Blue in the same column., One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.
Options: All switches are VTP servers by default., All switches are VTP transparent by default., VTP is on by default with a domain name of Cisco on all Cisco switches., All switches are VTP clients by default.
. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
Options: a. Use =if() function to format the required numbers red
b. Apply Conditional Formatting command on Format menu
c. Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
d. All of above
.The Average case occur in linear search algorithm
Options: A)When Item is somewhere in the middle of the array
b.When Item is not in the array at all
c.When Item is the last element in the array
d.When Item is the last element in the array or is not there at all