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

The advantage of optimistic locking is that:
Options: the lock is obtained only after the transaction has processed.,    the lock is obtained before the transaction has processed.,    the lock never needs to be obtained.,    transactions that are best suited are those with a lot of activity.

Ans:A ,A

The physical arrangement of equipment in a network is called:
Options: topology,    pairing,    queuing,    logic

Ans:A ,A

Assembly code data base is associated with
Options: a permanent table which lists all key words and special symbols of the language in symbolic form,    a permanent table of decision rules in the form of patterns for matching with the uniform symbol table to discover syntactic structure,    consists of a full or partial list or the tokens as they appear in the program. Created by Lexical analysis and used for syntax analysis and interpretation,    assembly language version of the program which is created by the code generation phase and is input to the assembly phase

Ans:D ,D

What are the two main types of access control lists (ACLs)? Standard IEEE Extended Specialized
Options: 1 and 3,    2 and 4,    3 and 4,    1 and 2

Ans:A ,A

Which of the following is used as a primary storage device?
Options: Magnetic drum,    PROM,    Floppy disk,    All of the above

Ans:B ,B

. To change the volume label
Options: a. Vol b. Label c. Scandisk d. None

Ans:5 – b ,5 – b

To get the Norton current, you have to
Options: Short the load resistor,    Open the load resistor,    Short the voltage source,    Open the voltage source

Ans:C ,C

. Holding down the Shift key and rotate the image will rotate in increments of
Options: a. 10 degrees b. 15 degrees c. 20 degrees d. 25 degrees

Ans:8 – B ,8 – B

The use of computers in data processing has had several impacts on business. Which of the following is not one of them?
Options: easier business growth,    fewer clerical workers,    increased data-processing costs,    more and better information

Ans:C ,C

It is most common type of query. It retrieves records from one or more tables and then displays the
Options: a. Parameter b. Select c. crosstab d. All of above

Ans:ndash; b,ndash; b

. What is represented by the small, black square in the lower-right corner of an active cell or range?
Options: a. Copy handle b. Fill handle c. Insert handle d. Border

Ans:– b,– b

A semijoin is which of the following?
Options: Only the joining attributes are sent from one site to another and then all of the rows are returned.,    All of the attributes are sent from one site to another and then only the required rows are returned.,    Only the joining attributes are sent from one site to another and then only the required rows are returned.,    All of the attributes are sent from one site to another and then only the required rows are returned.

Ans:C ,C

Slide Transaction can be apply to
Options: Current Slide B. Selected Slides C. All Slides D. All of the above

Ans:– D ,

If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you:
Options: a. Press the Erase key b. Press Esc c. Press the Enter button d. Press the Edit Formula button

Ans:#8211; b,#8211; b

Point out the error in the following program. #include<stdio.h> #include<stdarg.h> int main() { void display(int num, ...); display(4, 12.5, 13.5, 14.5, 44.3); return 0; } void display(int num, ...) { float c; int j; va_list ptr; va_start(ptr, num); for(j=1; j<=num; j++) { c = va_arg(ptr, float); printf("%f", c); } }
Options: Error: invalid va_list declaration,    Error: var c data type mismatch,    No error,    No error and Nothing will print

Ans:B ,B

Which command is used to display the subdirectory structure of the currently logged drive and pause the screen display after each screenful of information?
Options: TREE,    DELTREE/F,    DIR | MORE,    TREE | MORE

Ans:D ,D

A program in execution is called
Options:  A Paging B.  A Process C.  A virtual memory D.  A Demand Page

Ans: – B ,

. Which statement is valid about magnetic tape?
Options: A) It is a plastic ribbon B) It is coated on both sides with iron oxide C) It can be erased and reused D) All of above


What are the requirements for the solution to critical section problem?
Options: Mutual Exclusion B. Progress C. Bounded Waiting D. All of Above

Ans:– D ,

You just added a new user, kara, to the system. What group is kara added to by default?
Options: root,    kara,    group,    user

Ans:B ,B

What will be the output of the program? #include<stdio.h> #include<stdarg.h> void fun1(char, int, int *, float *, char *); void fun2(char ch, ...); void (*p1)(char, int, int *, float *, char *); void (*p2)(char ch, ...); int main() { char ch='A'; int i=10; float f=3.14; char *p="Hello"; p1=fun1; p2=fun2; (*p1)(ch, i, &i, &f, p); (*p2)(ch, i, &i, &f, p); return 0; } void fun1(char ch, int i, int *pi, float *pf, char *p) { printf("%c %d %d %f %s \n", ch, i, *pi, *pf, p); } void fun2(char ch, ...) { int i, *pi; float *pf; char *p; va_list list; printf("%c ", ch); va_start(list, ch); i = va_arg(list, int); printf("%d ", i); pi = va_arg(list, int*); printf("%d ", *pi); pf = va_arg(list, float*); printf("%f ", *pf); p = va_arg(list, char *); printf("%s", p); }
Options: A 10 3.14 A 10 3.14,    A 10 10 3.140000 Hello A 10 10 3.140000 Hello,    A 10 Hello A 10 Hello,    Error

Ans:B ,B

A primary key is which of the following?
Options: Any attribute,    An attribute that uniquely identifies each row,    An attribute that uniquely identifies each column,    A derived attribute

Ans:B ,B

. What should be the extension to execute files?
Options: EXE B. BAT C. COM D. All of the above

Ans: – D ,

What is the uses of subnetting?
Options: It divides one large network into several smaller ones B. It divides network into network classes C. It speeds up the speed of network D. None of above

Ans:– A ,

. The short cut key Ctrl + R is used in Excel to
Options: a.  Right align the content of cell b.  Remove the cell contents of selected cells c.  Fill the selection with active cells to the right d.  None of above

Ans:– c,– c

How long is an IPv6 address?
Options: 32 bits,    128 bytes,    64 bits,    128 bits

Ans:D ,D

. The formats defined by _____ include character formatting, such as the font and font size; paragraph formatting, such as line spacing and text alignment; table formatting; and list formatting.
Options: a. options b. styles c. toolbars d. tabs

Ans: – B , – B

After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?
Options: a. You need to delete the whole tablThere is no method to remove a particular field only. b. Delete all the fields from third downwards and reenter the required fields again. c. Select the third column in datasheet view then  Delete d. Select the third row in table design view then Delete

Ans:ndash; d,ndash; d

In OSI model, which of the following layer transforms information from machine format into that understandable by user
Options: application,    presentation,    session,    physical

Ans:B ,B

A modern digital computer has
Options: Extremely high speed,    Large memory,    Almost unlimited array,    All of the above


The data appearing first in the left portion of punched card is
Options: descriptive data,    coded data,    quantitative data,    All of the above

Ans:B ,B

. Workgroup means
Options: a. Computer in network b. Individual user c. Connection d. All of the above

Ans:5 – a ,5 – a

The difference between linear array and a record is
Options: a. An array is suitable for homogeneous data but hte data items in a record may have different data type b. In a record, there may not be a natural ordering in opposed to linear array. c. A record form a hierarchical structure but a lienear array does not d. All of above  


What should be the first step while OS upgrading? A)  Delete old Operating System B)  Backup old Operating System C)  Backup Critical Data D)  Format Hard Disks

Ans:– C ,

. 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

. Which report section only prints one time at the end of the report?
Options: a. Report Header b. Page Header c. Report Footer d. Page Footer

Ans:6 – c ,6 – c

Hard disks and diskettes are:
Options: Direct access storage devices,    Sequential access storage devices,    Rarely used with microcomputers,    Both (a) and (c)

Ans:A ,A

. When a peripheral device needs immediate attention from the operating system, it generatesa(n)
Options: a. Interrupt b. Spool c. Stack d. Page file

Ans: a, a

Which of the following statements is true
Options: as parallel run involves two different terminals accessing a common database,    computers are essential for systems Analysis,    Flow of information in an organization is always vertical,    alpha testing is the verification process a system goes through for the first time

Ans:D ,D

An electronic circuit with about 20 transistors fabricated on a silicon chip is known as
Options: SSI,    MSI,    DPS,    RJE

Ans:A ,A

One popular classification technique in Business Intelligence (BI) reporting is ________ .
Options: cluster analysis only,    regression analysis only,    RFM analysis only,    both cluster analysis and regression analysis

Ans:C ,C

Which of the following is not considered as a tool at the system design phase?
Options: piechart,    data-flow diagram,    decision table,    systems flowchart

Ans:A ,A

The disk concept for reducing time lost from rotational delay is:
Options: fixed block addressing,    cylinder, track, sector data,    staggered addressing,    graduated block identification

Ans:C ,C

The program execution time:
Options: must be slower than the fastest mechanical operation that is to be controlled,    will vary depending on the language used,    cannot be changed once the program is written,    All of the above

Ans:B ,B

. A __ name must be unique within a database
Options: a. Table b. Field c. Record d. Character

Ans:5 – a ,5 – a

. Batch file is used to
Options: a. Run program b. Show the contents c. run commands automatically d. All of above

Ans:1 – c ,1 – c

The FIFO algorithm
Options: executes first the job that last entered the queue,    executes first the job that first entered the queue,    execute first the job that has been in the queue the longest,    executes first the job with the least processor needs

Ans:B ,B

To insert slide numbers
Options: a. Insert a text box and select Insert >> Page Number b. Insert a textbox and select Insert >> Number >> PageNumber c. Choose Insert >> Slide Number d. Insert a new text box and select Insert >> slide Number

Ans: – D , – D

Parity bit is
Options: an error-detecting code based on a summation operation performed on the bits to be checked.,    a check bit appended to an array of binary digits to make the sum of all the binary digits.,    a code in which each expression conforms to specific rules of construction, so that if certain errors occur in an expression, the resulting expression will not conform to the rules of construction and thus the presence of the errors in detected,    the ratio of the number of data units in error to the total number of data units

Ans:B ,B

Which of the following function key activates the speller?
Options:  A) F5, B) F7, C) F9, D) Shift + F7,