. Which option allows you to Bold all the negative values within the selected cell range:


Options: Zero Formatting B. Conditional Formatting       C. Compare Formatting D. Negative Formatting

Ans:– B ,






More MS-Excel Related questions:


Which of the following are valid ways to refer only to host 172.16.30.55 in an IP access list? 172.16.30.55 0.0.0.255 172.16.30.55 0.0.0.0 any 172.16.30.55 host 172.16.30.55 0.0.0.0 172.16.30.55 ip any 172.16.30.55
Options: 1 and 4,    2 and 4,    1, 4 and 6,    3 and 5

Ans:B ,B


When the minimum number of instances of an entity is one, you know which of the following?
Options: Mandatory one,    Optional one,    Mandatory many,    Cannot tell

Ans:D ,D


The shifting of a program from one of the memory addresses to another is
Options: Data transmission,    Data collection,    Relocation,    Database

Ans:C ,C


“Ctrl + Left Arrow” is used to
Options: a. Moves the cursor beginning of the Line b. Moves the cursor one word left c. Moves the cursor one paragraph up d. Moves the cursor one paragraph down

Ans:–  B,–  B


Computers in a LAN can be interconnected by radio and infrared technologies.
Options: Wireless LANs,    Network Topologies,    Multiplexer,    Modem

Ans:A ,A


Conversion of an octal number 738 to binary number is
Options: 1101112,    1111002,    1100102,    1110112

Ans:D ,D


The size of a field with Number data type can not be
Options: a. 2 b. 4 c. 8 d. 16

Ans:ndash; d,ndash; d


Assuming 100% efficiency, what is the power being applied to the primary winding of the transformer described in the above question?
Options: 200 W,    1000 W,    20 W,    100 W

Ans:A ,A


You record the algorithm in the _____ column of the IPO chart.
Options: Input,    Output,    Processing,    Purpose

Ans:C ,C


. Personal computers used a number of chips mounted on a main circuit board. What is the common name for such boards?

Options: A) Daughterboard B) Motherboard C) Father board D) Childboard

Ans:B,B


Claude Shannon described the operation of electronic switching circuits with a system of mathematical logic called:
Options: LISP,    XLISP,    Boolean algebra,    neural networking

Ans:C ,C


Which one of the following statements is true for voltage in a parallel circuit?
Options: The total voltage in a parallel circuit is equal to the average value of the individual voltages,    The total voltage in a parallel circuit is always less than the value of the smallest voltage,    The total voltage is equal to the sum of the voltages across the individual branches in a parallel circuit,    The total voltage of a parallel circuit is the same as the voltages across each branch

Ans:D ,D


A directly accessible appointment calendar is a feature of a _____ resident package.
Options: CPU,    Memory,    Buffer,    ALU

Ans:B,B


What technology is used for flat panel displays?
Options: Solid state,    RBG monitor,    VLSI,    Direct view storage tube

Ans:A ,A


A dot-matrix printer
Options: is an input device,    is an output device,    cannot print alphabet,    has a speed of 1000 cps

Ans:B ,B


What TCP/IP protocol is used for remote terminal connection service?
Options: UDP,    RARP,    FTP,    TELNET

Ans:D ,D


What would you ask to determine if the display is working?
Options: Is there a video cursor or action on the screen?,    Did the computer beep or chime?,    Is there high voltage static on the screen,    All of the above

Ans:D ,D


PowerPoint Application allows you to produce
Options: Animated Presentations B. Paper Printouts of Slides C. Notes for the Speaker D. All of the above.

Ans:– D ,


12. While working with MS-DOS which command is used to copy all files with extension .txt into one file named all.txt?
Options: a. Copy a: *.txt b. Copy *.txt a: c. Copy *.txt c: d. Copy *.txt all.txt

Ans:Correct Answer: d,Correct Answer: d


. In which language is source program written?
Options: A) English B) Symbolic C) High level D) Temporary

Ans:C,C


36. When typing in a word field manually, what must you press to insert the code’s braces?
Options: a. Ctrl + F6 b. Ctrl + F9 c. Alt + F11 d. Shift + F12

Ans:–  B ,–  B


A loadstone is:
Options: a natural magnet,    a temporary magnet,    an artificial magnet,    a paramagnetic alloy

Ans:A ,A


A hierarchical chart that divides a large program into modules, in which greater details is designed in successively lower programming levels, is called a
Options: Scheme,    sub-schema,    Structure,    All of the above

Ans:C ,C


What is the output of the program #include<stdio.h> int main() { extern int fun(float); int a; a = fun(3.14); printf("%d\n", a); return 0; } int fun(int aa) { return (int)++aa; }
Options: 3,    3.14,    0 ,    4

Ans:E ,E


A modem that is attached to the telephone system by jamming the phone's handset into two flexible receptacles in the coupler?
Options: gateway,    bridge,    acoustic coupler,    time-division multiplexer

Ans:C ,C


The average time necessary for the correct sector of a disk to arrive at the read write head is _____
Options: Down time,    Seek time,    Rotational delay,    Access time

Ans:C ,C


What is the standard code the computer industry created to represent characters?
Options: DASI,    ASSH,    ASCII,    BASCII

Ans:C ,C


. A(n) ____ is the default control for a Yes/No field.
Options: a. check box b. option button c. toggle button d. list box

Ans:– a,– a


What is the impedance of a circuit composed of a 100 ohm resistor connected in parallel with an inductor that has a reactance of 200 W?
Options: 77.7 ohm,    89.3 ohm,    88.8 ohm,    224 ohm

Ans:B ,B


The engineering change control system makes changes in the
Options: operations file,    production schedule,    work force data,    All of the above

Ans:A ,A


What is the control units function in the CPU?
Options: a. To transfer data to primary storage b . to store program instruction c . to perform logic operations d . to decode program instruction

Ans:2.d,2.d


Which command is used to send the contents of file named REPORT/TXT to the standard printing device?
Options: TYPE REPORT.TXT TO PRINTER,    TYPE REPORT.TXT > PRN,    TYPE REPORT.TXT | PRN,    TYPE REPORT.TXT | PRINTER

Ans:B ,B


What protocol is used between E-Mail servers?
Options: FTP,    SMTP,    SNMP,    POP3

Ans:B ,B


Which of the following are not likely to be found on a PC main circuit board
Options: RAM chips,    Microprocessor chips,    ROM chips,    LCD clocks

Ans:D ,D


. MKDIR is similar to
Options: a. MD b. File c. Folder d. Table

Ans:6 – a ,6 – a


. Label name can be up to
Options: a. 10 character b. 63 character c. 11 character d. All of above

Ans:3 – c ,3 – c


The punched card used in the IBM System/3 contains
Options: 80 columns,    120 columns,    96 columns,    126 columns

Ans:C ,C


In comparison with static RAM memory, the dynamic RAM memory has
Options: lower bit density and higher power consumption,    higher bit density and higher power consumption,    lower bit density and lower power consumption,    higher bit density and lower power consumption

Ans:D,D


During boot-up, the memory test:
Options: Is a superfluous step that should be ignored,    Checks and verifies that contiguous memory is installed,    Is an operational error,    Displays what memory is installed, but nothing else

Ans:B ,B


Which command is used to delete the directory that is empty?
Options: a. Del *.* b. RD c. Erase d. MD

Ans:Answer: b. RD,Answer: b. RD


A special type of device which uses an ordinary telephone with a computer is
Options: Light pen,    Mouse,    Acoustic couple,    Touch panel

Ans:C ,C


Robots can increase productivity because:
Options: they do not take a vacation,    they do not get tired,    production quality is uniform,    All of the above

Ans:D ,D


Which of the following is not a font style?
Options:  A) Bold, B) Italics, C) Regular, D) Superscript, 

Ans:-D,-D


Which symbol must all formula begin with?
Options: a. = b. + c. ( d. @

Ans:#8211; a,#8211; a


. Which of the following is an example of utility?
Options: a. Antivirus b. Word c. Operating system d. Data recovery

Ans:9 – a ,9 – a


Which of the following special shell variables is used to process number of the last background job?
Options: $!,    $#,    $0,    $*

Ans:A ,A


. Which language is directly understood by the computer without translation program?
Options: A) Machine language B) Assembly language C) High level language D) None of above

Ans:A,A


What was the computer conceived by Babbage?
Options: Analytical Engine,    Arithmetic Machine,    Donald Knuth,    All of the above

Ans:A ,A


Which statement about sequences is not true?
Options: A sequence is an object that generates a sequential series of unique numbers.,    Sequences are most often used to provide values for surrogate keys.,    NextVal and CurrVal are both sequence methods.,    Sequences guarantee valid surrogate key values.

Ans:D ,D


The truth table for an S-R flip-flop has how many VALID entries?
Options: 3,    1,    4,    2

Ans:A ,A

www.000webhost.com