In Excel, the Fill Color button on the Formatting toolbar is used for what?


Options: To insert a background. B. To add borders. C. To select a distribution of figures. D. To add shading or color to a cell range.

Ans:– D ,


Description: mcqquestions

Asked in: KCC-2018   |   JOA 556-2018  |  HRTC JTO-2017

Hits Today: 14340 | Level: Moderate




Got some suggestion about this question or to make this site better? Please leave your comments below.


Want to see where do you stand among other aspirants in "Computer" Category?

Click Here to take quick 5 mins MCQ test to find out.

More MS-Excel Related questions:


. Which command is used to open the directory?
Options: a. Open b. Chdir c. Move d. All of above

Ans:2 – b ,2 – b


IGRP uses which of the following as default parameters for finding the best path to a remote network? Hop count MTU Cumulative interface delay STP Path bandwidth value
Options: 1 and 3,    3 and 5,    2, 3 and 5,    All of the above

Ans:B ,B


In SQL, which command is used to select data in rows and column from one or more tables?
Options: CHOOSE,    SELECT,    LIST,    BROWSE

Ans:B ,B


Impact printers
Options: strike a ribbon against the paper to produce character images,    include ink-jet and thermal devices,    are more expensive than Laser printers,    use optical technology

Ans:A ,A


A hashing scheme is used with
Options: sequential file organization,    direct file organization,    indexed sequential file organization,    partitioned file organization

Ans:B ,B


With MS-DOS which command will divide the surface of the blank floppy disk into sectors and assign a unique address to each one?
Options: FORMAT command,    FAT command,    VER command,    CHKDSK command

Ans:A ,A


What is invoked via HTTP on the Web server computer when it responds to requests from a user's Web browser?
Options: A Java application,    A Java applet,    A Java servlet,    None of the above is correct.

Ans:C ,C


. You created a query with two tables that have relationship of One-To-Many with referential rules applied. The first table has 3 records and the second has 8. With using a right outer join, how many records will the resulting recordset have?
Options: a. 5 b. 8 c. 24 d. Not enough information to tell

Ans:9 – c ,9 – c


Which one of the following statements most accurately reflects the nature of ac power?
Options: The current in an ac circuit flows in one direction, but changes value periodically,    The current in an ac circuit flows in one direction at a steady level,    The current in an ac circuit changes direction periodically,    The current in an ac circuit flows in two directions at the same time

Ans:C ,C


. Generally quick launch toolbar is displayed on
Options: a. the left side of taskbar b. the right side of taskbar c. on the middle of taskbar d. a bar out of taskbar

Ans:4 – a ,4 – a


The OCR reading unit attached to a POS terminal is called a
Options: light pen,    wand,    cursor,    All of the above

Ans:B ,B


Compared to humans, machines:
Options: can make more complex decisions based on unexpected circumstances,    can work in harsher environments,    make fewer errors,    (a) and (c)

Ans:D ,D


Which of the following statement obtains the remainder on dividing 5.5 by 1.3 ?
Options: rem = (5.5 % 1.3),    rem = modf(5.5, 1.3),    rem = fmod(5.5, 1.3),    Error: we can't divide

Ans:C ,C


Which of the following is not a major subsystem part providing an opportunity for system design controls
Options: data base,    model base,    both (a) and (b),    neither (a) nor (b)

Ans:D ,D


A list consists of last names, first names, addresses, and pin codes if all people in the list have the same last and the same pin code, a useful key would be
Options: the pin code,    the last name,    a compound key consisting of the first name and the last name,    All of the above

Ans:C ,C


When the graph of current versus voltage is a straight line, the device is referred to as
Options: Active,    Linear,    Nonlinear,    Bipolar

Ans:B ,B


The disadvantages of "Compile and Go" loading scheme is (are):
Options: a portion of memory is wasted because the core occupied by the assembler is unavailable to the object program.,    it is necessary to retranslate the user's program deck every time it is run.,    it is very difficult to handle multiple segments, especially if the source programs are in different languages, and to produce orderly modular programs.,    all of the above

Ans:D ,D


In raster-scan colour monitors, colour can be intensified by:
Options: grouping the phosphor dots in a circular pattern,    having each electron gun controlled by a composite signal,    using an in-line gun arrangement with a solid metal mesh,    having each electron gun controlled by separate signal

Ans:D ,D


The most important part of a multiple DHCP configurations is to make sure you don't have which of the following in the different scopes? Select the best answer.
Options: Duplicate addresses,    Duplicate pools,    Duplicate subnets,    Duplicate default gateways

Ans:A ,A


. The short cut key Ctrl + R is used in Excel to
Options: a.  Right align the content of cell b.  Remove the cell contents of selected cells c.  Fill the selection with active cells to the right d.  None of above

Ans:– c,– c


Which of the following is not essential component to perform a mail merge operation?
Options: a. Main document b. Data source c. Merge fields d. Word fields

Ans:– D,– D


While working with MS-DOS, which command is used to restore files that were backed up using the BACKUP command?
Options: COPY,    DISKCOPY,    RESTORE,    STORE

Ans:C ,C


.   The Microsoft clip gallery allows you to
Options: a. Add word art images to a slide b. Spell check your presentation c. Add clip art images to a slide or slides d. Add slides to a presentation

Ans:3 – C ,3 – C


Strategic Planning factors do not include which of the following?
Options: Organizational goals,    Critical success factors,    Information engineering,    Problem areas

Ans:C ,C


When mapping a binary many-to-many relationship into a relation which of the following is true?
Options: One relation is created.,    Two relations are created.,    Three relations are created.,    Four relations are created.

Ans:C ,C


In 1985, the famous chess player David Levy beat a world champion chess program in four straight games by using orthodox moves that confused the program. What was the name of the chess program?
Options: Kaissa,    CRAY BLITZ,    Golf,    DIGDUG

Ans:B ,B


Which is considered a direct entry input device?
Options: Optical scanner,    Mouse,    Light pen,    Digitizer

Ans:E ,E


. What is the shortcut key to insert new sheet in current workbook?
Options: a. F11 b. Alt + F11 c. Ctrl + F11 d. Shift + F11

Ans:– d,– d


Which of the following FRUs would be considered both an input/output device?
Options: Video board,    SCSI host adapter,    System board CPU,    All of the above

Ans:B ,B


Which of the following is not a term of MS-Excel?
Options: Cells B. Rows C. Columns D. Document

Ans:– D ,


Intranets and extranets can use their network fire walls and other security features to establish secure Internet links within an enterprise or with its trading partners. Select the best fit for answer:
Options: Network Server,    Virtual Private Network,    Network operating system,    OSI

Ans:B ,B


First-in-First-Out (FIFO) scheduling is
Options:  Non Preemptive Scheduling B.  Preemptive Scheduling C.  Fair Share Scheduling D.  Deadline Scheduling

Ans:– A ,


Who is considered the 'father' of the minicomputer and one of the founder fathers of the modern computer industry world-wide?
Options: George Tate,    Kenneth H. Olsen,    Seymour Cray,    Basic Pascal

Ans:B ,B


An index register that is automatically incremented or decremented with each use is
Options: Auto index,    Asynchronous,    Assembler,    Compiler

Ans:A ,A


The type of information most restricted by a poor interface between generalized data base management systems and special computing system languages is
Options: supervisory,    planning,    priority setting,    limitation

Ans:B ,B


Which of the following is not Computer Hardware?
Options: Mouse B. Monitor C. Antivirus D. Printer

Ans:– C ,


Which command is used to concatenate all files beginning with the string 'emp' and followed by a non-numeric characters?
Options: cat emp[!0-9],    more [emp][!0-9],    cat emp[x-z],    cat emp[a-z]

Ans:A ,A


To return the remainder after a number is divided by a divisor in EXCEL we use the function?
Options: ROUND ( ) B. FACT ( ) C. MOD ( ) D. DIV ( )

Ans:– C ,


. Who developed a mechanical device in the 17th century that could add, subtract, multiple, divide and find square roots?
Options: A) Napier B) Babbage C) Pascal D) Leibniz

Ans:D,D


Which command will show you the IOS version running on your router?
Options: sh IOS,    sh flash,    sh version,    sh running-config

Ans:C ,C


The difference between memory and storage is that memory is _____ and storage is __
Options: A) Temporary, permanent B) Permanent, temporary C) Slow, fast D) All of above

Ans:-A,-A


. Offline device is
Options: A) A device which is not connected to CPU B) A device which is connected to CPU C) A direct access storage device D) An I/O device

Ans:A,A


In which mode, each user has a local input/output device.
Options: Interactive,    Time sharing mode,    Batch processing mode,    All of the above

Ans:B ,B


Which of the following are TCP/IP protocols used at the Application layer of the OSI model? IP TCP Telnet FTP TFTP
Options: 1 and 3,    1, 3 and 5,    3, 4 and 5,    All of the above

Ans:C ,C


The first microprocessors produced by Intel Corpn. and Texas Instruments were used primarily to control small
Options: microwave ovens,    washing machines,    calculators,    personal computers

Ans:C ,C


How many symbols exist in Baudot code?
Options: 42,    116,    58,    76

Ans:C ,C


The reserved word enum is used for which of the following?
Options: To define a range for an attribute.,    To define a range for a class.,    To define a range for a relationship.,    All of the above.

Ans:A ,A


Which command is used to move all files to the bin sub-directory of the parent directory?
Options: mv *.* /bin/,    mv * /bin/*,    mv * ../bin,    mv * ../bin *.*

Ans:C ,C


21. What is the smallest and largest font size available in Font Size tool on formatting toolbar?
Options: a. 8 and 72 b. 8 and 64 c. 12 and 72 d. None of above

Ans:– A ,– A


Which of the following languages is more suited to a structured program?
Options: PL/1,    FORTRAN,    BASIC,    PASCAL

Ans:D,(Danswer

www.000webhost.com