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: 9433 | 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:


An assembly language instruction:
Options: is written in ones and zeros,    corresponds to one computer operation,    does not require knowledge of the computer design,    All of the above

Ans:B ,B


Which term is not used to describe the memory component of a computer?
Options: ROM,    PROM,    RAM,    SAM

Ans:D ,D


. Which is NOT an option of the Picture Size Mode property?
Options: a. Clip b. Fit c. Stretch d. Zoom

Ans:7 – b ,7 – b


. How to fit long texts in a single cell with multiple lines?
Options: Start typing in the cell and press the Enter key to start another line B. Use the Wrap Text option in the Format -> Alignment menu C. Use the Shrink to Fit option in the Format -> Cells -> Alignment menu D. All of above

Ans:– B ,


The equivalent of 1 kV is:
Options: 1.00 V,    1000 V,    100 mV,    1000 mV

Ans:B ,B


When you create a subdirectory within a directory, the process is known as _____
Options: directing,    making,    backing,    nesting

Ans:D ,D


. The cell reference for cell range of G2 to M12 is _______
Options: a. G2.M12 b. G2;M12 c. G2:M12 d. G2-M12

Ans:– c,– c


Which of the following abilities is/are required for both the system programmer and the EDP auditor?
Options: knowledge in computer science,    knowledge in accounting applications,    two of the above,    knowledge in information systems

Ans:A ,A


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


. SQL stands for __________.
Options: a. Standard Query Language b. Structured Query Language c. Simplified Query Language d. Static Query Language

Ans:5 – b ,5 – b


Properly arranged data is called
Options: A) Field B) Words C) Information D) File

Ans:-C,-C


Which command is used to set the three permissions for all the three categories of users of a file?
Options: chgrp,    chown,    chmod,    chusr

Ans:C ,C


Which of the following types of decision-making would depend heavily on real-time information?
Options: strategic,    tactical,    operational,    nonprogrammable

Ans:C ,C


What command will permit SMTP mail to only host 1.1.1.1?
Options: access-list 10 permit smtp host 1.1.1.1,    access-list 110 permit ip smtp host 1.1.1.1,    access-list 10 permit tcp any host 1.1.1.1 eq smtp,    access-list 110 permit tcp any host 1.1.1.1 eq smtp

Ans:D ,D


. Which device is required for the Internet connection?

Options: A) Joystick B) Modem C) CD Drive D) NIC Card

Ans:B,B


Which of the following digits are known as the sub-address digits (for use by the user) of the Network User Address (NUA)?
Options: 5-7,    1-4,    8-12,    13-14

Ans:D ,D


An AI system developed by Terry A. Winograd to permit an interactive dialogue about a domain he called blocks-world.
Options: SHRDLU,    SIMD,    BACON,    STUDENT

Ans:A ,A


A transparent DBMS
Options: a. can not hide sensitive information from users b. keeps its logical structure hidden from users c. keeps its physical structure hidden from users d. both b and c 

Ans:.c,.c


. We can replace a font on all sides with another font using the option :
Options: a. Edit –> Fonts b. Tools –> Fonts c. Tools -> Replace Fonts d. Format -> Replace Fonts

Ans:1 – D ,1 – D


. Which OS deos not support networking between computers?
Options: a. Windows 3.1 b. Windows 95 c. Windows 2000 d. Windows NT

Ans: a, a


Which DOS command would allow you to redirect a printer?
Options: Type,    Capture,    Mode,    Print

Ans:C ,C


The software used to drive microprocessor-based systems is called:
Options: assembly language programs,    firmware,    BASIC interpreter instructions,    flowchart instructions

Ans:A ,A


What command is used to count just the number of lines contained in a file?
Options: wc - r,    wc - w,    wc - c,    wc - l

Ans:D ,D


Which of the following is not a way to complete a cell entry?
Options: a. Pressing enter b. Pressing any arrow key on the keyboard c. Clicking the Enter button on the Formula bar d. Pressing spacebar

Ans:8211; d,8211; d


Personnel activity reports are produced from the
Options: personnel transactions file,    employee file,    applicant file,    jobs files

Ans:A ,A


If a piece of data is stored in two places in the database, then 
Options: a . storage space is wasted b . changing the data in one spot will cause data inconsistency c . in can be more easily accessed d . both and b

Ans:.d,.d


.   Which of the following will not advance the slides in a slide show view?
Options: a. The esc key b. The space bar c. The enter key d. The mouse button

Ans:1 – A ,1 – A


40. When the same word is used in multiple locations or a word is used that was not quite appropriate, a thesaurus can be used to look up a (n) _____ or a word similar in meaning.
Options: a. synonym b. homonym c. antonym d. metronym

Ans:– A ,– A


The 2's complement of a binary no. is obtained by adding.....to its 1's complement.
Options: 0 ,    1,    10,    12

Ans:B ,B


. __________ is the clear leader for personal databases.
Options: a. Microsoft Access b. Microsoft FoxPro c. Borland dBase d. MySQL

Ans:5 – a ,5 – a


A number of related records that are treated as a unit is called
Options: file,    field,    data,    batch

Ans:A ,A


. When a key is pressed on the keyboard, which standard is used for converting the keystroke into the corresponding bits?

Options: A) ANSI B) ASCII C) EBCDIC D) ISO

Ans:A,A


. Which command is used to delete the directory and all of its contents in one step?
Options: a. Deltree b. CD c. Rd d. Dir *.*

Ans:5 – a ,5 – a


In which of the following situations might a blind search be acceptable?
Options: real-life situation,    complex game,    small search space,    All of the above

Ans:C ,C


. What is an interpreter?
Options: A) An interpreter does the conversion line by line as the program is run B) An interpreter is the representation of the system being designed C) An interpreter is a general purpose language providing very efficient execution D) None of the above

Ans:B,B


While running DOS on a PC, which command would be used to duplicate the entire diskette?
Options: COPY,    DISKCOPY,    CHKDSK,    TYPE

Ans:B ,B


To select one hyperlink after another during a slide presentation, what do you press?
Options: a. Tab b. Ctrl + K c. Ctrl + h d. All of above

Ans: – A , – A


________ is considered to be one of the foundations of data access in the Microsoft world.
Options: ODBC,    OLE DB,    JPCD,    ADO

Ans:B ,B


A printed document reader which scans the characters and then encodes them in a computer-compatible code for direct transmission to the computer is called
Options: Optical character reader,    Kurzweil Data Entry Machine (KDEM),    MICR,    Laser scanner

Ans:B ,B


Which of the following best describes a computer-based information system?
Options: A system in which a computer is used to turn data into information,    Inputting data,    Processing data,    Performing complex mathematical calculations

Ans:A ,A


. What is the short cut key to replace a data with another in sheet?
Options: a.  Ctrl + R b.  Ctrl + Shift + R c.  Ctrl + H d.  Ctrl + F

Ans:– c,– c


Which of the following statement is false?
Options: a. If you choose to select from one of the pre-made slide layouts, you can change the positioning b. If you choose to select from the pre-made slide layouts, you cannot delete the objects in the layout. c. Blank Slide is at the top of the ‘Content Layouts’ area in the Slide Layout panel. d. All of above are false statements

Ans: – B , – B


10. While working with MS-DOS which command is used to change the extension of all filenames ending with .txt to .doc?
Options: a. Ren *.doc *.txt b. Ren *.txt *.doc c. Ren file.doc file.txt d. Ren a: *.doc *.txt

Ans:Correct Answer: b,Correct Answer: b


Contention is
Options: One or more conductors that serve as a common connection for a related group of devices,    a continuous frequency capable of being modulated or impressed with a second signal,    the condition when two or more stations attempt to use the same channel at the same time,    a collection of interconnected functional units that provides a data communications service among stations attached to the network

Ans:C ,C


. Which of the following line spacing is invalid?
Options: a. Single b. Double c. Triple d. Multiple

Ans: – C , – C


The SQL statement to create a view is:
Options: CREATE VIEW.,    MAKE VIEW.,    SELECT VIEW.,    INSERT VIEW.

Ans:A ,A


Needing to using more complicated SQL in database applications is a(n) ________ of normalization.
Options: advantage,    disadvantage,    either an advantage or disadvantage,    neither an advantage nor disadvantage

Ans:B ,B


. While starting Window XP/7 extra booting options can be shown by pressing
Options: F1 B. F8 C. F9 D. F12

Ans:– B ,


. You want to record experiment information and create a chart that shows the rate of crystal growth over a period of timThe best application to use would be:
Options: a. word processing b. spreadsheet c. database d. graphics

Ans:– b,– b


How do you wrap the text in a cell?
Options: Format, cells, font B. Format, cells, protection C. format, cells, number D. Format, cells, alignment

Ans:– D ,

www.000webhost.com