What will be the output if you format the cell containing 5436.8 as ‘#,##0.00’?


Options: 5,430.00 B. 5,436.80 C. 5,436.8 D. 6.8

Ans:– B ,


Description: mcqquestions

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

Hits Today: 17804 | Level: Moderate


******************************************************

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

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




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




More MS-Excel Related questions:


  Who is credited for using punch cards to control patterns of a weaving machine?
Options:  Blaise Pascal B.  Herman Hollerith         C.  Jacquard D.  Charles Babbage

Ans:– C ,


The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?
Options: a. None of these b. Select Format > Money from the menu c. Click the Currency Style button on the formatting toolbar d. You have to retype everything and manually add the dollar signs, commas, and decimals.

Ans:#8211; c,#8211; c


. Which of the following is not a feature of first generation computers

Options: A) They used vacuum tubes or valves as main electronic component B) They consumed lots of electricity and produced excessive heat C) They used machine language and assembly language to program the machine D) None of above

Ans:C,C


Which of the following is true when describing a unique local address?
Options: Packets addressed to a unicast address are delivered to a single interface.,    These are your typical publicly routable addresses, just like a regular publicly routable address in IPv4.,    These are like private addresses in IPv4 in that they are not meant to be routed.,    These addresses are meant for nonrouting purposes, but they are almost globally unique so it is unlikely they will have an address overlap.

Ans:D ,D


. The translator program used in assembly language is called
Options: A) Compiler B) Interpreter C) Assembler D) Translator

Ans:C,C


What device separates a single network into two segments but lets the two segments appear as one to higher protocols?
Options: Switch,    Bridge,    Gateway,    Router

Ans:B ,B


hich of the following is true regarding page Orientation of a Document?
Options: Page Orientation can be change at any time B. Page Orientation of document determines by printer C. Page Orientation must be set before start typing D. Page Orientation of a document cannot be changed.

Ans:– A ,


. Which of the following statements about a tab control in a form is incorrect?
Options: a. It can contain only one object. b. It defines a layered space. c. It is a control object. d. It is created in multipage forms.

Ans:– a,– a


A memory in which the information is stored last is on top & is retrieved first is known as
Options: PROM,    Buffer,    Stack,    RAM

Ans:C ,C


Which type of entity has its relationship to another entity determined by an attribute in that other entity called a discriminator?
Options: Supertype entity,    Subtype entity,    Archetype entity,    Instance entity

Ans:B ,B


 This task pane shows the design that is currently being used in a presentation.
Options:  Slide Show B.  Slide Style C.  Slide Design D.  Slide Format

Ans: – C ,


The flow and timing to data to and from the microprocessor is regulated by
Options: control pins,    address pins,    data pins,    power pins

Ans:A ,A


A memory space used for the temporary storage of data is
Options: PROM,    SAM,    Scratchpad storage,    Buffer

Ans:C ,C


. What is the maximum zoom percentage in Microsoft PowerPoint?
Options: a. 100 b. 200 c. 300 d. 400

Ans:7 – D ,7 – D


What do you call the translator which takes assembly language program as input & produce machine language code as output?
Options:  Compiler B.  Interpreter C.  Debugger D.  Assembler

Ans:– D ,


Data items grouped together for storage purposes are called a
Options: record,    title,    list,    string

Ans:A ,A


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


7. …is the first program run on a computer when the computer boots up
Options: a. System software b. Operating system c. System operations d. None

Ans:Correct Answer: b,Correct Answer: b


  After choosing a predefined template, which option has to be chosen to change the background color?
Options: Design Template B. Color Scheme C. Animation Scheme D. Color Effects

Ans:– B ,


A section of code that may only be executed by one process at any one time is
Options: CPM,    Critical resource,    Critical region,    Gray code

Ans:C ,C


. In Excel, the Fill Color button on the Formatting toolbar is used for what?
Options: a. 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,– d


The Primary job of the operating system is A)  Manage Commands B)  Manage Users         C)  Manage Programs D)  Manage Resources
Options:

Ans:– D ,


. Which command is used to copy the file myfile.doc from floppy disk to hard disk?
Options: a. Copy a:myfile.doc c: b. Copy c:myfile.doc a: c. Copy a: c:myfile.doc d. None of the above

Ans:5 – a ,5 – a


If your routing table has a static, a RIP, and an IGRP route to the same network, which route will be used to route packets by default?
Options: Any available route,    RIP route,    Static route,    IGRP route

Ans:C ,C


A resistor has a rated value of 100 ohm and a tolerance of 10%. What is its minimum and maximum allowable resistance value?
Options: 90 Ohm - 101 ohm,    90 Ohm - 110 ohm,    98 Ohm - 100.1 ohm,    99 Ohm - 102 ohm

Ans:B ,B


What is “Motion Path” in PowerPoint?
Options: A path to move items on a slide B. A path where PowerPoint file saved C. A path where PowerPoint Program installed D. None of above

Ans:– A ,


. An example of a digital device can be
Options: A) Digital clock B) Automobile speed meter C) Clock with a dial and two hands D) All of the above

Ans:A,A


Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur?
Options: Read committed,    Read uncommitted,    Repeatable read,    Serializable

Ans:B ,B


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


A large computer information system maintains many different computer files. Which amongst them is called a perpetual file?
Options: Specialized file,    Log file,    Master file,    Update file

Ans:C ,C


A customer attached an external drive to his notebook computer but the computer is not recognizing it. What should be considered?
Options: The cables are attached firmly,    The external drive has been pre¬loaded with the appropriate software,    The external drive was attached before the computer was on,    The external drive is turned on

Ans:All of the above,E


Which type of computers uses the 8-bit code called EBCDIC?
Options: A) Minicomputers B) Microcomputers C) Mainframe computers D) Super computer

Ans:-C,-C


The first computer introduced in Nepal was
Options: A) IBM 1400 B) IBM 1401 C) IBM 1402 D) IBM1402

Ans:-B,-B


Which of the following function returns t if the object is a number in LISP?
Options: (number <object>),    (numberp <object>),    (numericp <object>),    (numeric <object>)

Ans:B ,B


.   To adjust the width of table columns, you
Options: a. Click table menu. Column width, then make adjustments b. Drag the vertical gridline between two columns c. Drag the column markers on the table ruler bar d. b and c

Ans:7 – D ,7 – D


Which is an example of a formula?
Options: =A1+A2 B. =add(A1:A2) C. A1+A2 D. SUM(A1:A2)

Ans:– A ,


What device protects against line deficiencies?
Options: Surge protector,    UPS,    Logic probe,    Capacitor

Ans:B ,B


The calculation of expected outcomes in intended to help the manager
Options: identify problems,    identify solutions,    evaluate solutions,    All of the above

Ans:C ,C


Scissoring enables
Options: a part of data to be displayed,    entire data to be displayed,    full data display on full area of screen,    no data to be displayed

Ans:A ,A


Which of the following views is the best view to use when setting transition effects for all slides in a presentation?
Options: a. Slide sorter view b. Notes pages view c. Slide view d. Outline view

Ans: – A , – A


. Which of the following is not a form of data?
Options: A) numbers and characters B) images C) sound D) none of above

Ans:D,D


.   Which of the following feature allows you to select more than one slide in slide sorter view?
Options: a. Alt + Click each slide b. Shift + drag each slide c. Shift + Click each slide d. Ctrl + Click each slide

Ans:6 – C ,6 – C


Holes are the minority carriers in which type of semiconductor?
Options: Extrinsic,    Intrinsic,    n-type,    p-type

Ans:C ,C


What does MSCDEX.EXE do?
Options: Configures hard drives,    it's a SCSI driver,    BIOS setup,    it's a CD-ROM DOS driver

Ans:D ,D


What happens if you mark on Hidden check box of Font dialog box after you select some text?
Options:  A) The text is deleted from document and you need to bring from Recycle Bin if required again., B) The text is hidden and you need to bring it by removing the check box if needed again, C) The text is deleted and cannot be returned back, D) The text is hidden and cannot be returned back,

Ans:-B,-B


The MAC (Media Access Control) address of the network card is used in both Ethernet and Token-Ring networks and is essential for communication. What does MAC provide?
Options: A logical address that identifies the workstation,    A physical address that is randomly assigned each time the computer is started,    A physical address that is assigned by the manufacturer,    The logical domain address for the workstation

Ans:C ,C


Which of the following would be a good starting point for troubleshooting if your router is not translating?
Options: Reboot.,    Call Cisco.,    Check your interfaces for the correct configuration.,    Run the debug all command.

Ans:C ,C


Suppose that you have a customer who has a central HQ and six branch offices. They anticipate adding six more branches in the near future. They wish to implement a WAN technology that will allow the branches to economically connect to HQ and you have no free ports on the HQ router. Which of the following would you recommend?
Options: PPP,    HDLC,    Frame Relay,    ISDN

Ans:C ,C


To record a sequence of keystrokes and mouse actions to play back later we use:
Options: Media player B. Sound Recorder C. Calculator D. Macro Recorder

Ans:– D ,


Which bitwise operator is suitable for turning on a particular bit in a number?
Options: && operator,    & operator,    || operator,    | operator

Ans:D ,D

www.000webhost.com