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 ,






More MS-Excel Related questions:


Which of the following is not a characteristic of a system?
Options: operates for some purpose,    has homogeneous components,    operates within a boundary,    has interacting components

Ans:B ,B


Operating system
Options: links a program with the subroutines it references,    provides a layered, user-friendly interface,    enables the programmer to draw a flowchart,    all of the above

Ans:B ,B


Which of the following operations can be performed on the file "NOTES.TXT" using the below code? FILE *fp; fp = fopen("NOTES.TXT", "r+");
Options: Reading,    Writing,    Appending,    Read and Write

Ans:D ,D


. Ctrl + O
Options: Save Document B. Print Document C. Close Document D. Open Document

Ans:– D ,


A port can be:
Options: strictly for input,    strictly for output,    bidirectional,    all the above

Ans:C ,C


. Which of the following field properties enforces the use of parentheses when keying an area code?
Options: a. Field Size b. Format c. Input Mask d. Validation Rule

Ans:0 – c ,0 – c


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


Which of the following is a layer 2 protocol used to maintain a loop-free network?
Options: VTP,    STP,    RIP,    CDP

Ans:B ,B


Which of the following would be a logical first step in troubleshooting a PC?
Options: Check the computer CMOS,    Define the circumstances of the problem,    Call the vendor,    Define what applications are being used

Ans:B ,B


A laser printer generates a totally black page, what is the cause?
Options: malfunctioning imaging laser,    low level in the toner cartridge,    no power to transfer corona,    no power to the primary corona

Ans:D ,D


97. What is the shortcut key for “Find and Replace” dialog box?
Options: a. Ctrl + F b. Ctrl + R c. Ctrl + H d. Ctrl + Shift + F

Ans:–  C ,–  C


An unloaded zener regulator has a source voltage of 20 V, a series resistance of 330 W, and a zener voltage of 12 V, What is the Zener current?
Options: 28.4 mA,    24.2 mA,    34.4 mA,    68.4 mA

Ans:B ,B


The practice of "bundling" refers to
Options: selling computers alone,    selling peripheral devices with computer,    selling software to run on computers,    giving away software with a computer purchase

Ans:D ,D


When UPC is used, the price of the item is located
Options: on the item,    on the item and on the shelf,    in computer storage,    on the shelf and in computer storage

Ans:D ,D


The selection of the solution technique to the implemented by a computing system should be made by
Options: an operations research expert,    a computer programmer,    system analysts,    a computing system user

Ans:D ,D


Which output device is used for translating information from a computer into pictorial form on paper.
Options: Mouse,    Plotter,    Touch panel,    Card punch

Ans:B,(Banswer


ASCII stands for
Options: American standard code for information interchange,    All purpose scientific code for information interchange,    American security code for information interchange,    American Scientific code for information interchange

Ans:A,(Aanswer


Which of the following is correct way to define the function fun() in the below program? #include<stdio.h> int main() { int a[3][4]; fun(a); return 0; }
Options: void fun(int p[][4]) { } ,    void fun(int *p[4]) { } ,    void fun(int *p[][4]) { } ,    void fun(int *p[3][4]) { }

Ans:A ,A


17. Which command is used to create root directory and FAT on disk?
Options: a. Chkdsk b. Command.com c. Format d. Fat

Ans:Correct Answer: c ,Correct Answer: c


Historically, central systems were used because:
Options: semiconductor memory was not available,    memory was very expensive,    memory consumed a large amount of power,    All of the above

Ans:D ,D


You can edit a cell by
Options: a. Clicking the formula button b. Double clicking the cell to edit it in-place c. Selecting Edit>Edit Cell from the menu d. None of above

Ans:#8211; b,#8211; b


. You can use print manage window
Options: a. To checkstatus of files in the print queue b. To cancel the print job c. To interrupt printing d. All of the above

Ans: d, d


An audit trail
Options: a . is used to make backup copies b . is the recorded history of operations performed on a file c . can be used to restore lost information d . none of the aobve

Ans:B, is the recorded history


Frames from one LAN can be transmitted to another LAN via the device
Options: Router,    Bridge,    Repeater,    Modem

Ans:B ,B


. The term GIGO is related to which characteristics of computers?
Options: A) Speed B) Automatic C) Accuracy D) Reliability

Ans:2-C,2-C


What is the size of MAC Address?
Options: 16-bits B. 32-bits C. 48-bits D. 64-bits

Ans:– C ,


If your router is facilitating a CSU/DSU, which of the following commands do you need to use to provide the router with a 64000bps serial link?
Options: RouterA(config)#bandwidth 64,    RouterA(config-if)#bandwidth 64000,    RouterA(config-if)#clock rate 64,    RouterA(config-if)#clock rate 64000

Ans:D ,D


. __________ is used to build ‘intuitive’ queries.
Options: a. SQL b. Xbase c. QBE d. XML

Ans:1 – c ,1 – c


Which of the following is a block device
Options: mouse,    printer,    terminals,    disk

Ans:D ,D


The pending invoice file should be stored on a DASD (Direct: Access Storage Device) if
Options: payment execution is batch,    invoice data entry is one-line,    inquiries concerning payable are to be answered on-line,    All of the above

Ans:C ,C


. _______ controls all the main slide control tasks for your presentation.
Options: a.  Task Pane b.  Task Bar c.  Control Panel d.  None of above

Ans:4 – A ,4 – A


. What is the shortcut key to insert a new comment in a cell?
Options: F2 B. Alt + F2 C. Ctrl + F2 D. Shift + F2

Ans:– D ,


Upper Memory blocks are located where?
Options: Conventional Memory,    Extended Memory,    Expanded memory,    Reserved Memory

Ans:D ,D


. The category of operating system that you most likely have running on your PDA computer is a_________Operating system
Options: a. Real time b. Single user, single task c. Single user, multitask d. Multiuser, multitask

Ans:5 – b ,5 – b


The operating system of a computer serves as a software interface between the user and
Options: hardware,    peripheral,    memory,    screen

Ans:A ,A


Ctrl + J
Options: a. Align Justify b. Insert Hyperlink c. Search d. Print

Ans:–  A,–  A


Which of the following is most responsible for the inability of auditors to uncover computer crimes?
Options: the auditor's lack of knowledge in computer technology,    the prohibitively expensive audit procedures needed to detect computer frauds,    the client's concern that the public will learn of the crime,    the relatively small average take of computer frauds

Ans:B ,B


A Turnaround document
Options: is circulated among all the staff of an organization.,    is circulated among all the heads of departments of an organization.,    is output at one point which later comes back as an input,    All of the above

Ans:C ,C


The octal representation 652 indicates
Options: Execute permission for the owner,    Write permission for others,    Read and write permission of groups,    All of the above

Ans:B ,B


The three different types of pen plotter technology are flatbed, drum, and:
Options: electrostatic,    thermal,    pinch roller,    impact

Ans:C ,C


On a systems flowchart, the online manual keeping of input data is identified by using the
Options: online storage symbol,    Online keyboard symbol,    keeping operation symbols,    manual operation symbols

Ans:B ,B


. Which of the following is not a view for interacting with a form object?
Options: a. Datasheet view b. Design view c. Form view d. Layout view

Ans:– d,– d


Non-volatility is an important advantage of
Options: CCD's,    Magnetic tapes and disks,    Magnetic bubbles,    Both (b) and (c)

Ans:D ,D


3. The primary purpose of an operating system is…..
Options: a. To make the most efficient use of the computer hardware b. To allow people to use the computer c. To keep systems programmers employed d. To make computers easier to use

Ans:Correct Answer: a,Correct Answer: a


Reverse video is a technique of
Options: showing data with half brightness,    showing data upside down on the screen,    hiding confidential data on the screen,    emphasizing data by reversing the foreground and background

Ans:D ,D


The device that can both feed data into and accept data from a computer is
Options: ALU,    CPU,    Input-Output device,    All of the above

Ans:C ,C


What will be the output of the program if the array begins at address 65486? #include<stdio.h> int main() { int arr[] = {12, 14, 15, 23, 45}; printf("%u, %u\n", arr, &arr); return 0; }
Options: 65486, 65488,    65486, 65486,    65486, 65490,    65486, 65487

Ans:B ,B


. Intel corporation produces chips for which computers?
Options: A) IBM PCs B) Apple/Macintosh PCs C) Both of above D) None of above

Ans:A,A


When mapping a multivalued attribute 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:B ,B


Data Manipulation Language enables users to
Options: Retrieval of information stored in database B. Insertion of new information into the database C. Deletion of information from the database D. All of the above

Ans:– D ,

www.000webhost.com