. 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: 13567 | 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:

Symbolic languages were developed in
Options: 1962,    1950,    1974,    1980

Ans:B ,B

. It was in 2028 BS the _________ was brought in to calculate census data.
Options: A) IBM 1400 B) IBM 1401 C) ICL 2950 D) None of above


Offline device is
Options: a device which is not connected to CPU,    a device which is connected to CPU,    a direct access storage device,    an I/O device

Ans:A ,A

One solution to the multivalued dependency constraint problem is to:
Options: split the relation into two relations, each with a single theme.,    change the theme.,    create a new theme.,    add a composite key.

Ans:A ,A

Which of the following network types have a designated router and a backup designated router assigned? Broadcast Point-to-point NBMA NBMA point-to-point
Options: 1, 2 and 3,    1 and 3,    3 and 4,    All of the above

Ans:B ,B

It is most important that the data produced by a payment system be
Options: accurate,    authoritative,    relevant,    newsworthy

Ans:A ,A

What type of computer programming is used for airplane ticket reservation system?
Options: Multi programming,    Real time programming,    Time sharing,    Batch programming


If a sine wave has a frequency of 500 Hz, the period in seconds of the sine wave is:
Options: 5000,    0.003,    0.02,    0.002.

Ans:D ,D

High density double sided floppy disks could store _____ of data
Options: A) 1.40 MB B) 1.44 GB C) 1.40 GB D) 1.44 MB


Which are considered the methods of NAT? Static IP NAT pool Dynamic NAT double-translation Overload
Options: 1 and 6,    3 only,    1, 3 and 5,    All of the above

Ans:C ,C

. Identify the correct statement
Options: A) IBM PCs used RISC CPU designs B) Macintosh used CISC CPU design C) IBM used CISC CPU design D) None of above is true


. Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?
Options: a. Use Ctrl to select all three cells, then click the paste button on the standard toolbar b. Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify c. Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to d. All of above

Ans:– c,– c

Which of the following statements are true regarding the command ip route The command is used to establish a static route. The default administrative distance is used. The command is used to configure the default route. The subnet mask for the source address is
Options: 1 and 2,    2 and 4,    3 and 4,    All of the above

Ans:A ,A

Each answer below shows example data from a table. Which answer is an example of the missing values problem?
Options: Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.,    Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.,    Three rows have the values Brown, NULL, and Blue in the same column.,    One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.

Ans:C ,C

. The actual execution of instructions happens in

Options: A) ALU B) CU C) Memory D) None of above


Which input device is able to scan & interpret an entire page that is typed in a special font
Options: Floppy disk,    Page reader,    Paper tape punch,    Optical card readers

Ans:B ,B

. The command center of access file that appears when you create or open the MS Access database file.
Options: a. Database window b. Query window c. Design view window d. Switchboard

Ans:8 – a ,8 – a

Which of the following is not valid version of MS Office?
Options: a. Office XP b. Office Vista c. Office 2007 d. None of above

Ans:– B,– B

Ctrl + M
Options: a. New Document b. Close Document c. Right Indent d. Left Indent

Ans:–  D,–  D

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

Ans:C ,C

What does the command o/r 0x2142 provide?
Options: It is used to restart the router.,    It is used to bypass the configuration in NVRAM.,    It is used to enter ROM Monitor mode.,    It is used to view the lost password.

Ans:B ,B

. Selecting text means, selecting?
Options: a. a word b. an entire sentence c. whole document d. any of the above

Ans: –  D , –  D

AutoCorrect was originally designed to replace _________ words as you type.
Options: a. short, repetitive b. grammatically incorrect c. misspelled d. none of the above

Ans:– C,– C

To make possible the efficient on-line servicing of many teleprocessing system users on large computer systems, designers are developing
Options: communication systems,    multiprogramming systems,    virtual storage systems,    All of the above

Ans:D ,D

. By using RD command, directory with files can be removed or not
Options: a. Removed b. Not removed c. Both a and b d. None of above

Ans:1 – b ,1 – b

What is the name of the logic circuit which can add two binary digits?
Options: Full adder,    Half adder,    Buffer,    Register


Which bar is usually located below that Title Bar that provides categorized options?
Options: Menu bar B. Status Bar C. Tool bar D. Scroll bar

Ans:– A ,

What will be the output of the program in DOS (Compiler - Turbo C)? #include<stdio.h> double i; int main() { (int)(float)(char) i; printf("%d", sizeof((int)(float)(char)i)); return 0; }
Options: 1,    2,    4,    8

Ans:B ,B

Which of the following terms is the most closely related to main memory?
Options: nonvolatile,    permanent,    control unit,    temporary

Ans:D ,D

In MS Word, Ctrl+S is for …..
Options: a. Scenarios b. Size c. Save d. Spelling Check

Ans:–  C,–  C

A zener diode has a voltage of 10 V and a current of 20 mA. What is the power dissipation?
Options: 200 mW,    300 mW,    20 mW,    10 mW

Ans:A ,A

Which device does the general population associate most with automation?
Options: Flexible manufacturing,    Robots,    Numerical control machine,    Computer graphics workstation

Ans:B ,B

. The _____ is a short horizontal line indicating the conclusion of a document.
Options: a. insertion point b. end mark c. status indicator d. scroll box

Ans:– B,– B

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

Ans:1 – c ,1 – c

. To start Microsoft PowerPoint application
Options: a.  Click on Start >> Programs >> All Programs >> Microsoft PowerPoint b.  Hit Ctrl + R then type ppoint.exe and Enter c.  Click Start >> Run then type powerpnt then press Enter d.  All of above

Ans:1 – C ,1 – C

. The term GIGO is related to
Options: A) Accuracy B) Reliability C) Versatility D) Automatic


Which of the following is not true of immediate processing?
Options: It is often used in real-time applications,    It can occur with either sequential of direct-access files,    It can be used in an airline-reservation system,    Transactions are processed shortly after a real-world event occurs

Ans:B ,B

What is meant by quad-density (QD) diskette?
Options: It is double-sided disk,    It is double density disk,    It has double the number of tracks per inch,    All of the above


. What is the use of “Hide Slide” option?
Options: a. to hide the selected slides during Presentation b. to hide the selected slides during Editing c. to hide the selected slides during Printing d. to hide the selected slides during Deleting

Ans:8 – A ,8 – A

A WATS arrangement
Options: is always less expensive than flat-rate service,    is less expensive than flat-rate service only when the number of calls is large and the duration of each is short,    is less expensive than flat-rate service only when the number of calls is small and the duration of each is long,    is never less expensive than flat-rate service

Ans:B ,B

The Fdisk command in DOS _____ .
Options: Partitions the hard drive for use,    Fixes erroneous hard drive,    Formats data sectors on a hard drive,    Checks hard drive for lost clusters

Ans:A ,A

What is the shortcut key for “Superscript ” the selected text?
Options: Ctrl + = B. Ctrl + – C. Ctrl + Shift + = D. Ctrl + Shift + –

Ans:– C ,

Options: is a natural consequence of virtual memory systems,    can always be avoided by swapping,    always occurs on large computers,    can be caused by poor paging algorithms

Ans:D ,D

The technique of assigning a memory address to each I/O device in the SAM system is called:
Options: wired I/O,    I/O mapping,    dedicated I/O,    memory-mapped I/O

Ans:D ,D

A processing unit that coordinates networks and data communication is known as
Options: Control unit,    Communications processor,    Register unit,    CPU

Ans:B ,B

9. What is the name of the batch file that is automatically run when MSDOS is booted?
Options: a. Run.bat b. Config.sys c. Config.bat d. Autoexec.bat

Ans:Correct Answer: d ,Correct Answer: d

The task of arranging data in order is called
Options: a. Searching b. Sorting c. Ordering d. Shorting

Ans:ndash; b,ndash; b

What is the most significant difference between the USB and IEEE1394 standards?
Options: IEEE 1394 is faster,    USB does not support USB,    USB is plug and play,    IEEE 1394 is hot swappable

Ans:A ,A

. What is an intersection of a row and a column?
Options: a. Form b. Cursor c. Cell d. Record

Ans:– c,– c

This is the stage in database design where one gathers and lists all the necessary fields for the database project.
Options: a. data definition b. data refinement c. establishing relationship d. none of the above

Ans:ndash; a,ndash; a