Which function is not available in the Consolidate dialog box?

Options: Pmt B. Average C. Max D. Sum

Ans:– A ,

Description: mcqquestions

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

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

Localizing an object in an image and selectively analyzing the object in a series of redundant layers is referred to as the:
Options: Turing test,    pyramid,    Gaussian pyramid,    Maxwell pyramid

Ans:C ,C

Storage on PC allows you to store files until something erases it, but memory loses its contents whenever its _____ is lost
Options: static,    disk space,    power,    both a and b above

Ans:C ,C

. 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

Which tab is not available on left panel when you open a presentation?
Options: a. Outline b. Slides c. Notes d. All of above are available

Ans:– C ,– C

Which is the best process to access number of records from the same file?
Options: a batch job,    a real-time job,    an on-line job,    All of the above

Ans:A ,A

A primary key in any table has the properties
Options: a. Not Null b. No Duplicates c. Both of above d. None of above

Ans:ndash; c,ndash; c

What command is used to summarize the disk usage?
Options: disk,    du,    fdisk,    chkdsk

Ans:B ,B

. Which of the following data type is used to store logical value in MS Access?
Options: a. True/False b. On/Off c. Yes/No d. All of Above

Ans:– c,– c

The requirements report includes
Options: a hierarchy chart showing the top-level modules,    a list of alternative solutions considered,    a data flow diagram describing the proposed new system.,    All of the above

Ans:C ,C

Which of the following is true concerning open-source DBMS?
Options: Is free or nearly free database software whose source code is publicly available,    Is free or nearly free database software whose source code is not publicly available,    Is not competitive against PC-oriented packages and is fully SQL compliant,    Is competitive against PC-oriented packages and is not fully SQL compliant

Ans:A ,A

CPU does not perform the operation
Options: a . data transfer b . logic operation c . arithmetic operation d . all of above


. An entire path name, consisting of several sub-directory name can contain up to
Options: a. 13 character b. 36 character c. 63 character d. 53 character

Ans:1 – c ,1 – c

Programmed instructions to the computer is known as
Options: Data,    Code,    Documentation,    Database

Ans:B ,B

Which of the following memory is capable of operating at electronics speed?
Options: Semiconductor memory,    Magnetic disks,    Magnetic drums,    Magnetic tapes


How many primary partitions can exist on one drive?
Options: 16,    4,    2,    1

Ans:B ,B

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

Ans:– B ,

The systems conversion technique of totally removing the existing system and immediately implementing the new system is called a
Options: pilot conversion,    crash conversion,    phased conversion,    parallel run

Ans:B ,B

A scheme describes
Options: data elements,    records and files,    record relationships,    All of the above

Ans:D ,D

If you want to insert some slides from other presentation into current one choose
Options: a. From Insert menu choose Slides from Files b. From Insert menu choose Slides from Presentation c. From Insert menu choose Slides d. None of above

Ans: – A , – A

Which of the following is true concerning personal computers?
Options: They decrease the demand for mainframe computers,    They have been most successful in the home,    The electronic spreadsheet has been a primary reason for their popularity,    Their future is not so bright owning to the improved cost-performance ratio of minis and mainframes

Ans:C ,C

Portrait and Landscape are
Options: a. Page Orientation b. Paper Size c. Page Layout d. All of above

Ans:– A,– A

Options: Programming language,    Low-level language,    Assembly language,    Machine language

Ans:A ,A

A devices that links two homogeneous packet-broadcast local networks, is
Options: hub,    bridge,    repeater,    gateway

Ans:B ,B

Page Down Key
Options: a. Moves the cursor one line down b. Moves the cursor one page down c. Moves the cursor one screen down d. Moves the cursor one paragraph down

Ans:–  C,–  C

.    Which command should be used to display all files within the specified subordinate directory of the subdirectory?
Options: a.    Dir pathname b.    Dir pathnamepathname c.    Dir / ch d.    Dir pathnamefilename

Ans:.b,Correct Answer: b. Dir pathnamepathname

In negative logic, the logic state 1 corresponds to
Options: negative voltage,    zero voltage,    more negative voltage,    lower voltage level

Ans:D ,D

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

What will be the output of the program? #include<stdio.h> #define SQUARE(x) x*x int main() { float s=10, u=30, t=2, a; a = 2*(s-u*t)/SQUARE(t); printf("Result = %f", a); return 0; }
Options: Result = -100.000000,    Result = -25.000000,    Result = 0.000000,    Result = 100.000000

Ans:A ,A

. Label name can be up to
Options: a. 10 character b. 63 character c. 11 character d. All of above

Ans:3 – c ,3 – c

.   The arrangement of elements such as Title and Subtitle text, pictures, tables etis called
Options: a. Layout b. Presentation c. Design d. Scheme

Ans:0 – A ,0 – A

Which device is on IRQ 6?
Options: Keyboard,    IDE,    Floppy drive,    Video card

Ans:C ,C

. Which of the following is default mode for Windows to start?
Options: a. Command Prompt b. Safe Mode c. Normal Mode d. None of above

Ans:9 – c ,9 – c

Which option is used with cmp command to give a detailed list of the byte number and the differing bytes in octal for each character that differs in both the files?
Options: -l,    -d,    -r,    -b

Ans:A ,A

What do the following declaration signify? char *scr;
Options: scr is a pointer to pointer variable.,    scr is a function pointer.,    scr is a pointer to char.,    scr is a member of function pointer.

Ans:C ,C

Instructions and memory address are represented by
Options: A) Character code B) Binary codes C) Binary word D) Parity bit


In which year were chips used inside the computer for the first time?
Options: 1964,    1975,    1977,    1981

Ans:B ,B

When a new trunk link is configured on an IOS-based switch, which VLANs are allowed over the link?
Options: By default, all VLANs are allowed on the trunk.,    No VLAN's are allowed, you must configure each VLAN by hand.,    Only configured VLAN's are allowed on the link.,    Only extended VLAN's are allowed by default.

Ans:A ,A

The Ziegler-Nichols method:
Options: is a graphical solution method,    can be used to determine gain factors of a PI loop,    is a method of control,    a and b above

Ans:D ,D

. Queries in access can be used as
Options: a. View, change and analyze data in different ways b. A source of records for forms and reports c. Only a d. Both a and b

Ans:4 – d ,4 – d

Videotex is a combination of
Options: television,    communication,    computer technology,    All of the above

Ans:D ,D

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


. Which of the following professions has not been affected by personal computers?
Options: A) Medical B) Clerical and law C) Accounting D) None of the above


When connecting a ribbon cable to a connector, how do you know which direction to plug it in?
Options: The red line in the cable goes to the highest pin number,    The colored line in the cable goes to pin #1,    It does not matter,    The blue or red line in the cable goes away from the power connector

Ans:B ,B

. Which of the following field properties enforces the use of parentheses when keying an area code?
Options: a. Field Size b. Format c. Input Mask d. Validation Rule

Ans:0 – c ,0 – c

. Ctrl + N
Options: Save Document B. Open Document C. New Document D. Close Document

Ans:– C ,

. Microprocessors can be used to make
Options: A) Computer B) Digital systems C) Calculators D) All of the above


. Which command allows you to create a root directory?
Options: a. MD b. Deltree c. Format d. All of above

Ans:1 – c ,1 – c

SQL*Plus will finish the statement and execute it when the user types in this:
Options: A left slash ( \ ) followed by [Enter].,    A colon ( : ) followed by [Enter].,    A semicolon ( ; ) followed by [Enter].,    A period ( . ) followed by [Enter].

Ans:C ,C

In a magnetic disk, data is recorded in a set of concentric tracks which are subdivided into
Options: periods,    sectors,    zones,    groups

Ans:B ,B

A periodic report can be used to
Options: identify the problem,    evaluate solutions,    identify solutions,    select solutions

Ans:A ,A