To select an entire column in MS-EXCEL, press?

Options: CTRL + C B. CTRL + Arrow key C. CTRL + S D. None of the above

Ans:– D ,

Description: mcqquestions

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

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

. to activate the previous cell in a pre-selected range, press
Options: a. the Alt key b. the Tab key c. the Enter key d. none of above

Ans:– d,– d

You have an interface on a router with the IP address of Including the router interface, how many hosts can have IP addresses on the LAN attached to the router interface?
Options: 6,    8,    30,    32

Ans:A ,A

What is proportional control?
Options: It has a discrete output for each error value,    The controller output varies continuously over a range,    The gain is independent of offset error.,    All of the above

Ans:B ,B

The computer is a part of the firm's
Options: physical system,    conceptual system,    both (a) and (b),    neither (a) nor (b)

Ans:C ,C

A type of channel used to connect a central processor and peripherals which uses multipling is known as
Options: Modem,    Network,    Multiplexer,    All of the above


. … show characteristics with both hardware and software
Options: a. Operating system b. Software c. Data d. None

Ans:3 – a ,3 – a

Logical design of database is called
Options: Database Instance B. Database Snapshot C. Database Schema D. All of the above

Ans:– C ,

Which of the following statement is true?
Options: A switch creates a single collision domain and a single broadcast domain. A router creates a single collision domain.,    A switch creates separate collision domains but one broadcast domain. A router provides a separate broadcast domain.,    A switch creates a single collision domain and separate broadcast domains. A router provides a separate broadcast domain as well.,    A switch creates separate collision domains and separate broadcast domains. A router provides separate collision domains.

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 of the following commands is used to have a two-way communication with any person who is currently logged in?
Options: mail,    mesg,    write,    grep

Ans:C ,C

How many truth table entries are necessary for a four-input circuit?
Options: 4,    8,    12,    16

Ans:D ,D

What command is used to terminate a process?
Options: kill,    cancel,    haltsys,    shutdown

Ans:A ,A

The four icons used in building Data Flow Diagram are
Options: Flow, Source, Store, Process,    Flow, Process, Source, Store,    Flow, Process, Source/Destination, Store,    Source, Process, Destination, Store

Ans:C ,C

. What does FAT stands for?
Options: a. File attribute type b. File allocation table c. Format All Tabs settings d. File for all type

Ans:0 – b ,0 – b

Which of the following describe router functions?
Options: Packet switching,    Packet filtering,    Internetwork communication,    Path selection

Ans:E ,E

Relocation bits used by relocating loader are specified (generated) by
Options: Relocating loader itself,    Linker,    Assembler or translator,    Macro processor

Ans:B ,B

Corporate modeling software can be used for
Options: cash planning,    operational budgeting,    capital budgeting,    All of the above

Ans:D ,D

. Which of the following is a class of computers based on model?
Options: A) Digital Computer B) Hybrid Computers C) Analog Computers D) AT Computers


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

Back-up procedure helps in
Options: restoring the operation whenever there is a disk failure,    restoring both application and system software whenever there is disk corruption.,    restoring the data files whenever there is a system crash,    All of the above

Ans:D ,D

. Copy con ram.txt is
Options: a. Copy the entire data b. Deletes the data c. Controlling the enter data d. All of above

Ans:8 – a ,8 – a

. We can save and protect the workbook by
Options: Write Reservation Password B. Protection Password C. Read-only Recommended D. Any of the above

Ans: – D ,

hat is the shortcut key to split a table?
Options: Ctrl + Alt + Enter B. Ctrl + Shift + Enter C. Alt + Shift + Enter D. Alt + Space + Enter

Ans:– B ,

The fundamental requirements of private-to-public network interconnection methods which need to be provided in gateways is/are
Options: universal accessibility for private network Data Terminal Equipment (DTE),    adequate cost control mechanisms for administration of the private networks,    to assign address to private network DTEs,    a and b both

Ans:D ,D

The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in
Options: a tree file,    an indexed file,    a hashed file,    a sequential file

Ans:C ,C

What will be the output of the program (sample.c) given below if it is executed from the command line? cmd> sample friday tuesday sunday /* sample.c */ #include<stdio.h> int main(int sizeofargv, char *argv[]) { while(sizeofargv) printf("%s", argv[--sizeofargv]); return 0; }
Options: sample friday tuesday sunday,    sample friday tuesday,    sunday tuesday friday sample,    sunday tuesday friday

Ans:C ,C

Baseband is
Options: transmission of signals without modulation,    a signal all of whose energy is contained within a finite frequency range,    the simultaneous transmission of data to a number of stations,    All of the above

Ans:A ,A

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

Ans:–  D,–  D

. Which of the following action removes a sheet from workbook?
Options: a.  Select the sheet, then choose Edit >> Delete Sheet b.  Select the sheet then choose Format >> Sheet >> Hide c.  Both of above d.  None of above

Ans:– a,– a

Which of the following enables you to make multiple changes in a document at once?
Options: find command B. Replace command C. Drag and Drop D. copy command

Ans:– B ,

In SQL, which command is used to add new rows to a table?

Ans:C ,C

. The first cell in EXCEL worksheet is labeled as
Options: a. AA b. A1 c. Aa d. A0

Ans:– b,– b

Which of the following computer language is used for artificial intelligence?
Options: FORTRAN,    PROLOG,    C,    COBOL

Ans:B ,B

    In Ms-Dos what command you will use to display system date?
Options: a.    Date command b.    Ver command c.    Disk command d.    Format command

Ans:.e,Correct Answer: a. Date command

A character that is raised and smaller above the baseline is known as
Options:  A) Outlined, B) Raised, C) Superscript, D) Subscript,


Batch files contain a group of MS-DOS commands that are run in successive order. What filename extension identifies batch files?
Options: COM,    BAT,    EXE,    SYS

Ans:B ,B

Which of the following is not a type of relationship that can be applied in Access database
Options: a. One to One b. One to Many c. Many to Many d. All of above can be applied

Ans:ndash; d,ndash; d

Right clicking something in Excel:
Options: a. Deletes the object b. Nothing the right mouse button is there for left handed people c. Opens a shortcut menu listing everything you can do to the object d. Selects the object

Ans:#8211; c,#8211; c

A _____ is a program that serves as an interface between application program and a set of coordinated and integrated files called a database.
Options: DDS,    DBMS,    MIS,    Control

Ans:B ,B

A system program that sets up an executable program in main memory ready for execution is
Options: assembler,    linker,    loader,    compiler

Ans:C ,C

Suppose a current source has an Ideal current of 10 mA and an internal resistance of 20 MW. For what values of load resistance will the current source appear stiff?
Options: 20 k Ohm or more,    200 k Ohm or less,    200 k Ohm or more,    20 km or less

Ans:B ,B

The physical equipment made oi various metals, silicon and plastic components that make up the parts of a computer is called
Options: micro,    peripheral,    hardware,    disk drive

Ans:C ,C

The logical data structure with a one-to-many relationship is a :
Options: network,    tree,    chain,    relational

Ans:B ,B

Which of the following statements is true concerning routines and triggers?
Options: Both consist of procedural code.,    Both have to be called to operate.,    Both run automatically.,    Both are stored in the database.

Ans:A ,A

The process of reading a database schema and producing a data model from that schema is known as:
Options: data modeling.,    database design.,    reverse engineering.,    None of the above is correct.

Ans:C ,C

A KES knowledge base contains information in the form of:
Options: associations,    actions,    free text,    schema

Ans:E ,E

. You can automatically adjust the size of text in a cell if they do not fit in width by
Options: a. Double clicking on the right border of column header b. From Format choose Columns and then Autofit Selection c. From Format Cells dialog box mark Shrink to fit check box d. All of above

Ans:– c,– c

Poor data administration can lead to which of the following?
Options: A single definition of the same data entity,    Familiarity with existing data,    Missing data elements,    All of the above.

Ans:C ,C

What will be the output of the program #include<stdio.h> void fun(int); int main(int argc) { printf("%d ", argc); fun(argc); return 0; } void fun(int i) { if(i!=4) main(++i); }
Options: 1 2 3,    1 2 3 4,    2 3 4,    1

Ans:B ,B

An instruction that transfers program control to one or more possible paths is known as
Options: Utility program,    System software,    Broadband channel,    Application program

Ans:C ,C