In EXCEL, you can sum a large range of data by simply selecting a tool button called …..?


Options: AutoFill B. Auto correct C. Auto sum D. Auto format

Ans:– C ,


Description: mcqquestions

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

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


What is the default subnet mask for a class C network?
Options: 127.0.0.1,    255.0.0.0,    255.255.0.0,    255.255.255.0

Ans:D ,D


Excel probably considers the cell entry January 1, 2000 to be a
Options: a. Label b. Value c. Formula d. Text string

Ans:#8211; b,#8211; b


. Which of the following is a way to access secondary memory?

Options: A) Random access memory B) Action method C) Transfer method D) Density method

Ans:A,A


Which is NOT typically a Field Replaceable Unit?
Options: System ROM,    Power supply,    System chasis,    Video controller

Ans:C ,C


Indicate which of the following is not true about an interpreter?
Options: Interpreter generates an object program from the source program,    Interpreter is a kind of translator,    Interpreter analyses each source statement every time it is to be executed,    All of the above

Ans:A ,A


What is the main advantage of magnetic core memory over semiconductor RAM memory?
Options: more compact and smaller,    more economical,    a bit does not have to write after reading,    non volatile

Ans:D,D


Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';
Options: SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');,    SELECT NAME IN CUSTOMER WHERE STATE = 'VA';,    SELECT NAME IN CUSTOMER WHERE STATE = 'V';,    SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');

Ans:D ,D


What of the following tool is used to check and repair Linux file systems?
Options: mkfs,    fdisk,    fsck,    mount

Ans:C ,C


When did John Napier develop logarithm?
Options: 1416 B. 1614 C. 1641 D. 1804

Ans:– B ,


An application program interface (API) is which of the following?
Options: The same thing as ODBC.,    Middleware that does not provide access to a database.,    Middleware that provides access to a database.,    The same thing as JDBC.

Ans:C ,C


The operator used to get value at address stored in a pointer variable is
Options: *,    &,    &&,    ||

Ans:A ,A


. Slide sorter of PowerPoint is available on _____ menu.
Options: a. Insert b. File c. View d. Edit

Ans:3 – C ,3 – C


Relations are:
Options: two-dimensional tables.,    three-dimensional tables.,    four-dimensional tables.,    five-dimensional tables.

Ans:A ,A


What two disciplines are usually tied by a common data base?
Options: Documentation and geometric modeling,    Computer-aided design and computer-aided manufacturing,    Testing and analysis,    Drafting and documentation

Ans:B ,B


When using SQL*Plus, Oracle commands, column names, table names and all other database elements:
Options: are case insensitive.,    are case sensitive.,    must always be in lower case.,    must always be in upper case.

Ans:A ,A


An automatic machine that performs routine seemingly human tasks is
Options: KIPS,    AI,    PL,    Robot

Ans:D ,D


What happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table?
Options: a. A relationship is created b. Edit relationship dialog box appears c. Error occurs d. Nothing happens

Ans:ndash; b,ndash; b


. Which of the following is not the correct method of editing the cell content?
Options: a.  Press the Alt key b.  Press the F2 key c.  Click the formula bar d.  Double click the cell

Ans:– a,– a


Conversion of a hexadecimal number 3D16 to binary number is
Options: 1111012,    1100112,    110001102,    1100012

Ans:A ,A


What is the AutoComplete feature of Excel?
Options: It automatically completes abbreviated words B. It completes text entries that match an existing entry in the same column C. It completes text and numeric entries that match an existing entry in the same column D. It completes text entries that match an existing entry in the same worksheet

Ans:– B ,


Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship Command?
Options: a. Home Tab b. Create Tab c. External Data Tab d. Database Tab

Ans:ndash; d,ndash; d


. What program runs first aftercomputer is booted and loading GUI?
Options: a. Desktop Manager b. File Manager c. Windows Explorer d. Authentication

Ans: d, d


What should you replace if the brightness or contrast adjustments were malfunctioning on a laptop?
Options: fuse,    led display,    adjustment switch,    led display cable

Ans:B ,B


Trailer labels contain
Options: file identification,    retention period,    both (a) and (b),    neither (a) nor (b)

Ans:D ,D


To find out how much memory is available, you could type______.
Options: EMM,    MEM,    CHKDSK,    MEMMAKER

Ans:B ,B


The DROP TABLE statement:
Options: deletes the table structure only.,    deletes the table structure along with the table data.,    works whether or not referential integrity constraints would be violated.,    is not an SQL statement.

Ans:B ,B


Which major development led to the production of microcomputers?
Options: Magnetic disks,    Floppy disks,    Logic gates,    Integrated circuits

Ans:D ,D


Which of the following registers hold the information before it goes to the decoder
Options: control register,    data register,    accumulator,    address register

Ans:B ,B


The total time to prepare a disk drive mechanism for a block of data to be read from it is
Options: latency,    latency plus transmission time,    latency plus seek time,    latency plus seek time plus transmission time

Ans:C ,C


A memory that holds micro programs is
Options: Core memory,    ROM,    RAM,    Control memory

Ans:B ,B


. Which Disk Format can access by MS-Dos 6.0?
Options: OSX B. FAT C. NTFS D. EXT2

Ans:– B ,


. Which of the following function will use to find the highest number in a series of number?
Options: a. MAX(B1:B3) b. MAXIMUM (B1:B3) c. HIGH (B1:B3) d. HIGHEST(B1:B3)

Ans:– a,– a


Which of the following is not considered a tool at the system Design phase?
Options: Data-Flow Diagram,    Decision Table,    Pie chart,    System Flowchart

Ans:C ,C


What kind of battery is most likely included in a cordless electric knife?
Options: Zinc-carbon battery,    Mercury-cell battery,    Nicad battery,    Lead-acid battery

Ans:B ,B


Which of the following is not an alternative name for primary memory?
Options: Main memory,    Primary storage,    Internal storage,    Mass storage

Ans:D ,D


Which of the following may be classified as an automation system?
Options: automated warehouses,    numerically controlled machine tools,    robotics,    All of the above

Ans:D ,D


An operation that will increase the length of a list is
Options: Insert,    Look-up,    Modify,    All of the above

Ans:A ,A


On the feasibility committee, department representatives serve as:
Options: direct users of the new system,    liaison to their departments,    ready sources of information,    All of the above

Ans:D ,D


“Ctrl + Right Arrow” is used to
Options: a. Moves the cursor one word right b. Moves the cursor end of the line c. Moves the cursor end of the document d. Moves the cursor one Paragraph down

Ans:–  A,–  A


Robot motion:
Options: is the same for all robots,    usually imitates human motion,    is not dependent on the robot structure,    All of the above

Ans:B ,B


. How do you connect internet in your system?
Options: a. My computer >> dialup networking b. Control panel >> modem c. Network neighborhood d. None of above

Ans:3 – a ,3 – a


. Charles Babbage is considered the father of modern computers because
Options: A) of his difference engine B) of his analytical engine C) his concept of input, mill and output D) All of above

Ans:C,C


The default extension for an Oracle SQL*Plus file is:
Options: .txt.,    .pls.,    .ora.,    .sql.

Ans:D ,D


Your company is running IGRP using an AS of 10. You want to configure EIGRP on the network but want to migrate slowly to EIGRP and don't want to configure redistribution. What command would allow you to migrate over time to EIGRP without configuring redistribution?
Options: router eigrp 11,    router eigrp 10,    router eigrp 10 redistribute igrp,    router igrp combine eigrp 10

Ans:B ,B


Which of the following holds data and processing instructions temporarily until the CPU needs it?
Options: ROM,    control unit,    main memory,    coprocessor chips

Ans:C,C


Which of the following keys is used to overstrike a whole line?
Options: R,    v,    C,    u

Ans:A ,A


The first firm to mass-market a microcomputer as a personal computer was
Options: IBM,    Sperry Univac,    Radio Shack,    Data General Corporation

Ans:C,C


What do the following declaration signify? char *arr[10];
Options: arr is a array of 10 character pointers.,    arr is a array of function pointer.,    arr is a array of characters.,    arr is a pointer to array of characters.

Ans:A ,A


. EEPROM stands for
Options: A) Electrically Erasable Programmable Read Only Memory B) Easily Erasable Programmable Read Only Memory C) Electronic Erasable Programmable Read Only Memory D) None of the above

Ans:A,A


What will be the output of the program ? #include<stdio.h> int main() { int i=4, j=8; printf("%d, %d, %d\n", i|j&j|i, i|j&j|i, i^j); return 0; }
Options: 12, 12, 12,    112, 1, 12,    32, 1, 12,    -64, 1, 12

Ans:A ,A

www.000webhost.com