. What is the quickest way to select entire worksheet?

Options: Choose Edit -> Select all from the Menu B. Click on the first column, press Ctrl, and then click on the last column C. Click on the first column, press Shift, and then click on the last column D. Click on the rectangle box on the upper left corner where column headings and row headings meet

Ans:– D ,

Description: mcqquestions

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

Hits Today: 13400 | 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:

Whenever you have a hardware resource conflict, it will more likely be an IRQ conflict rather than an i/o conflict because:
Options: there are a lot more I/O addresses than IRQs.,    the BIOS sometimes has more of a problem controlling IRQs,    I/O addresses cannot conflict,    software tends to correct I/O conflicts

Ans:A ,A

A modern electronic computer is a machine that is meant for
Options: Doing quick mathematical calculations,    Input storage, manipulation of outputting of data,    Electronic data processing,    Performing repetitive tasks accurately

Ans:B ,B

Which command is used to backup in DOS 6+ Version
Options: a. BACKUP b. MSBACKUP c. MSBACKEDUP d. All of the above

Ans:Correct Answer: b ,Correct Answer: b

A Microsoft Windows is .....a(n)
Options: a. Operating system b. Graphic program c. Word Processing d. Database program


Doubling the operating frequency of an inductive circuit:
Options: has no effect on the inductive reactance,    doubles the amount of inductive reactance,    multiplies the inductive reactance by 6.28,    cuts the inductive reactance in half

Ans:B ,B

. Which of the following term means to reckon?
Options: A) putare B) com C) computa D) computar


. To clear the content of recent opening files from document folder
Options: a. Start >> setting >> choose taskbar and start menu b. Start >> program and choose clear content c. Both of above d. None of above

Ans:8 – a ,8 – a

An operating system intended for use on microprocessor based systems that support a single user is
Options: PC-DOS,    MS-DOS,    UNIX,    CP/M


. Which operating system can you give smallest file name?
Options: a. Ps/2 b. Dos c. Windows d. Windows NT

Ans: b, b

How many bits in a byte?
Options: 16,    8,    255,    10

Ans:B ,B

Graphic interfaces were first used in a Xerox product called:
Options: InterLISP,    Ethernet,    Smalltalk,    ZetaLISP

Ans:C ,C

A circuit has two different voltage sources that are connected in a series-opposing form. If the sources are rated at 6 V and 9 V, what is the total source voltage?
Options: 3 V,    16 V,    7.5 V,    8 V

Ans:A ,A

The emitter diode is usually
Options: Forward-biased,    Reverse-biased,    Nonconducting,    Operating in the breakdwon region

Ans:A ,A

Comments can be added to cells using …..
Options: Edit -> Comments B. Insert -> Comment     C. File -> Comments D. View –> Comments

Ans:– B ,

How many protons does the nucleus of a silicon atom contain?
Options: 4,    29,    14,    48

Ans:C ,C

Which of the following items would require you to comply with EPA disposal guidelines?
Options: Keyboard,    System board,    Power supply,    Battery

Ans:D ,D

A device mounted on a communication satellite which receives, amplifies and re-transmits signals from earth station is
Options: Track,    Transponder,    Transistor,    Terminal

Ans:B ,B

The primary job of the operating system of a computer is to
Options: command resources,    manage resources,    provide utilities,    be user friendly

Ans:B ,B

A lockbox service is used for
Options: depositing cash when bank is closed,    paying bank customer bills automatically,    storing papers in a bank vault,    depositing payments to bank customers

Ans:D ,D

Usually, it takes 10-bits to represent one character. How many characters can be transmitted at a speed of 1200 BPS?
Options: 10,    12,    120,    1200

Ans:C ,C

Which one of the following statements is true for the impedance of a series RC circuit?
Options: The impedance is greater than the sum of the resistance and capacitive reactance,    The impedance is equal to the sum of the resistance and capacitive reactance,    The impedance is greater than either the resistance or capacitive reactance but less than their sum,    The impedance is less than the sum of the resistance and capacitive reactance

Ans:C ,C

. A name or number used to identify storage location devices?
Options: A) A byte B) A record C) An address D) All of above


Which command is used to count just the number of characters in a file?
Options: wc - 1,    wc -c,    wc -w,    wc -r

Ans:B ,B

A wrist grounding strap contains which of the following:
Options: Surge protector,    Capacitor,    Voltmeter,    Resistor

Ans:D ,D

. What is the process of eliminating redundant fields by separating data into tables called?
Options: a. Renormalizations b. Filtering c. Normalization d. Sorting

Ans:4 – c ,4 – c

. A word processor would most likely be used to do
Options: a. keep an account of money spent b. do a computer search in media center c. maintain an inventory d. type a biography

Ans:– D,– D

What is the shortcut key you can press to create a copyright symbol?
Options:  A) Alt+Ctrl+C, B) Alt + C, C) Ctrl + C, D) Ctrl + Shift + C,


What is the i/o address for com1?
Options: 3e8,    3bc,    5f8,    3f8

Ans:D ,D

Which protocol does DHCP use at the Transport layer?
Options: IP,    TCP,    UDP,    ARP

Ans:C ,C

. Which mode loadsminimal set of drivers when starting Windows?
Options: a. Safe Mode b. Normal Mode c. VGA Mode d. Network Support Mode

Ans: a, a

Which of following provides reliable communication?
Options: TCP B. IP C. UDP D. All of the above

Ans:– A ,

. Where can you change automatic or manual calculation mode in Excel?
Options: a.  Double CAL indicator on status bar b.  Go to Tools >> Options >> Calculation and mark the corresponding radio button c.  Both of above d.  None of above

Ans:– b,– b

A 6-MHz channel is used by a digital signaling system utilizing 4-level signals. What is the maximum possible transmission rate?
Options: 1.5 Mbaud/sec,    6 Mband/sec,    12 Mbaud/sec,    24 Mbaud/sec

Ans:C ,C

. Microsoft Access is a
Options: a. Rdbms b. Oodbms c. Ordbms d. Network database model

Ans:5 – a ,5 – a

Which of the following provides a storage mechanism for incoming mail but does not allow a user to download messages selectively?
Options: SMTP,    DHCP,    IMAP,    POP3

Ans:D ,D

0. What is a file extension of Templates in Microsoft Word?
Options: .Dtep B. .Dott C. .Dotx D. .Doct

Ans: – C ,

. Swapping
Options: a. Works best with many small partitions b. Allows many programs to use memory simultaneously c. Allows each program in turn to use the memory d. Does not work with overlaying

Ans:1 – c ,1 – c

. A name or number used to identify a storage location is called
Options: A) A byte B) A record C) An address D) All of above


Main storage is also called
Options: Accumulator,    Control unit,    Register unit,    memory

Ans:D ,D

A file organization component of a VSAM file is:
Options: relative record data set,    keyed sequential data set,    entry sequential data set,    all of the above

Ans:D ,D

You telnet into a remote device and type debug ip rip, but no output from the debug command is seen. What could the problem be?
Options: You must type the show ip rip command first.,    IP addressing on the network is incorrect.,    You must use the terminal monitor command.,    Debug output is sent only to the console.

Ans:C ,C

Part of a program where the shared memory is accessed and which should be executed invisibly, is called
Options: semaphores,    directory,    critical section,    mutual exclusion

Ans:C ,C

What is the IP Address range of APIPA?
Options: to B. to C. to D. to

Ans:– C ,

. To show/hide the grid lines in Microsoft Excel 2007
Options: a. Page Layout -> Grid lines -> View b. Insert -> Grid lines -> View c. View -> Grid lines -> View d. Edit -> Grid lines -> View

Ans:– a,– a

. A(n)_______ is a major object that can run independent of a control.
Options: a.            event b.           property c.           procedure d.            macro

Ans:– d,– d

. What type of relationship is created when you select a primary key in both related tables?
Options: a. One-To-One b. Indeterminate c. One-To-Many d. Many-To-Many

Ans:7 – a ,7 – a

________ is an interface by which application programs can access and process SQL databases in a DBMS-independent manner.
Options: ODBC,    OLE DB,    JPCD,    ADO

Ans:A ,A

Automation means:
Options: assisting or replacing humans with machines.,    workers controlling machines.,    increased productivity.,    All of the above

Ans:D ,D

Why are vacuum tubes also called valves?
Options: A) Because they can amplify the weak signals and make them strong B) Because they can stop or allow the flow of current C) Both of above D) None of above


.   Which of the following fill effects can you use for the slide background?
Options: a. Gradient b. Texture c. Picture d. All of the above

Ans:7 – D ,7 – D