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


Any type of storage that is used for holding information between steps in its processing is
Options: CPU,    Primary storage,    Intermediate storage,    Internal storage

Ans:C ,C


Which of the following is not one of the three ‘Mail Merge Helper’ steps?
Options: a. merge the two files b. create the main document c. set the mailing list parameters d. create the data source

Ans:– C,– C


. Home Key
Options: Moves the cursor beginning of the document B. Moves the cursor beginning of the paragraph C. Moves the cursor beginning of the screen D. Moves the cursor beginning of the line

Ans:– D ,


The journal voucher file includes
Options: general ledger accounts involved,    date of entry,    rupees posted to each account,    All of the above

Ans:B ,B


Piece of code that only one thread can execute at a time is called
Options: Mutual Exclusion B. Critical Section C. Synchronization D. All of them

Ans:– B ,


How many non-overlapping channels are available with 802.11h?
Options: 3,    12,    23,    40

Ans:C ,C


SQL stands for ________ .
Options: Structured Query Language,    Sequential Query Language,    Structured Question Language,    Sequential Question Language

Ans:A ,A


You just installed a new IDE hard drive, but your system BIOS will not recognize the new drive, what should you check first.
Options: cable sequence,    jumpers on the hard drive,    drivers that need to be loaded,    hard drive manufacturer web site information

Ans:B ,B


Point out the error in the program. #include<stdio.h> int main() { const int k=7; int *const q=&k; printf("%d", *q); return 0; }
Options: Error: RValue required,    Error: Lvalue required,    Error: cannot convert from 'const int *' to 'int *const',    No error

Ans:D ,D


Which of the following function returns t if the object is a number in LISP?
Options: (number <object>),    (numberp <object>),    (numericp <object>),    (numeric <object>)

Ans:B ,B


A variable that has no physical meaning and is used to obtain an initial basic feasible solution to a linear programming problem is known as:
Options: basis,    algorithm,    artificial variable,    basic variable

Ans:D ,D


. Which of the following disk is fixed disk?
Options: A) Hard Disks B) Flash Disks C) Blu-Ray Disks D) DVDs

Ans:A,A


In magnetic disks, data is organized on the platter in a concentric sets of rings called
Options: sector,    track,    head,    block

Ans:B ,B


Structured design produces computer programs that are:
Options: easily maintained,    easily understood,    tested in a bottom-up fashion,    a and b only

Ans:D ,D


Primary memory stores
Options: Data alone B. Programs alone C. Results alone D. All of these

Ans:– D ,


In which of the following situations might a blind search be acceptable?
Options: real-life situation,    complex game,    small search space,    All of the above

Ans:C ,C


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 ,


. In a worksheet you can select
Options: a. The entire worksheet b. Rows c. Columns d. a, b, and c

Ans:– d,– d


Which of the following is not a level of information handling:
Options: Decision Support System (DSS),    Operations Assistance System,    Transaction Processing System (IPS),    Office Automation System.

Ans:B ,B


Which of the following devices have a limitation that we can only store information to it but cannot erase or modify it?
Options:  Floppy Disk B.  Hard Disk C.  Tape Drive D.  CDROM

Ans:– D ,


What will be the output of the program given below in 16-bit platform ? #include<stdio.h> int main() { enum value{VAL1=0, VAL2, VAL3, VAL4, VAL5} var; printf("%d\n", sizeof(var)); return 0; }
Options: 1,    2,    4,    10

Ans:B ,B


In analog computer
Options: Input is first converted to digital form,    Input is never converted to digital form,    Output is displayed in digital form,    All of the above

Ans:B ,B


Which of the following signs is used to back up over typing errors in vi?
Options: @,    #,    $,    !

Ans:B ,B


Which of the following is used when a company goes outside its organization to develop a new system?
Options: data flow diagram,    systems flowchart,    project dictionary,    request for proposal

Ans:D ,D


. Which of the following data types automatically generates a consecutive number?
Options: a. Autonumber b. Memo c. Number d. Text

Ans:7 – a ,7 – a


Compared to an open-loop system, a closed-loop control system is:
Options: more accurate,    more complex,    more stable,    All of the above

Ans:D ,D


A shared database should:
Options: be accurate and available.,    provide for backup and recovery.,    be secure.,    All of the above.

Ans:D ,D


Management's decision to rent a computer system may be based upon
Options: tax advantages,    desire to avoid a large one-time payment,    operational flexibility in changing hardware,    All of the above

Ans:D ,D


. Which criteria do not return the position “Officer” as a match?
Options: a. position = “*ff*” b. position = “O??icer” c. position = ” ?ff*” d. position = “O#r”

Ans:– d,– d


. All attachment fields display as a(n) ____ in Datasheet View.
Options: a. icon b. button c. thumb tack d. paperclip

Ans:3 – d ,3 – d


When did Hewlett-Packard Inc. Introduce its first HP-110 laptop computer?
Options: 1984,    1986,    1990,    1995

Ans:A ,A


. What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
Options: a. An absolute cell address is created. b. Cell address will change when it is copied to another cell. c. The sheet tab is changed. d. The status bar does not display the cell address.

Ans:– a,– a


. If you need to edit a relationship
Options: a. Right click the relationship line and choose edit relationship b. Double click the relationship line c. Both of above d. None of above

Ans:5 – c ,5 – c


Does there any function exist to convert the int or float to a string?
Options: Yes,    No,    ,    

Ans:A ,A


What will be the output of the program? #include<stdio.h> #include<math.h> int main() { printf("%d, %d, %d\n", sizeof(3.14f), sizeof(3.14), sizeof(3.14l)); return 0; }
Options: 4, 4, 4,    4, 8, 8,    4, 8, 10,    4, 8, 12

Ans:C ,C


Which elements of a worksheet can be protected from accidental modification?
Options: Contents B. Objects C. Scenarios D. All of the above

Ans:– D ,


A high-pass filter:
Options: passes lower-frequency signals and reduces higher-frequency signals,    passes higher-frequency signals and reduces lower-frequency signals,    has no effect on ac signals,    increases the level of all frequencies by a significant amount

Ans:B ,B


Which of the following columns is(are) are required in a table?
Options: A foreign key,    An alternate key,    A primary key,    A surrogate key.

Ans:C ,C


. An online backing storage system capable of storing larger quantities of data is
Options: A) CPU B) Memory C) Mass storage D) Secondary storage

Ans:C,C


The primary advantage of key-to-tape data-entry systems is:
Options: A large percentage of editing can be performed at the time of data entry,    Key verification is easily performed,    The tape is reusable,    Keying errors can be detected as they occur

Ans:C ,C


Which of the following is not Modification of the Database
Options: Deletion B. Insertion C. Sorting D. Updating

Ans:– C ,


A stand-alone system which produces one page of printed output at a time is
Options: Page printer,    Line printer,    Laser printer,    Dot matrix printer

Ans:A,(Aanswer


If you need to change the typeface of a document, which menu will you choose?
Options:  A) Edit, B) View, C) Format, D) Tools, 

Ans:-C,-C


A microprocessor unit, a memory unit, and an input/output unit form a:
Options: CPU,    compiler,    microcomputer,    ALU

Ans:C ,C


A microprogram written as string of 0s and 1s is a 
Options: a . symbolic microinstruction b . binary microinstruction c . symbolic microprogram d . binary microprogram

Ans:8.d,8.d


A BI reporting system does not ________ .
Options: create meaningful information,    deliver information to users on a timely basis,    use statistical procedures to predict future events,    use disparate data sources

Ans:C ,C


Database Management Systems are featured with:
Options: a. The facility to easy editing, spelling check, auto pagination, lay out and printing reports b. The ability to store large amount of data to facilitate easy update, sort and retrieval c. The ability to calculate efficiently with the help of built-in functions and analyze d. All of above

Ans:ndash; b,ndash; b


If in a computer, 16 bits are used to specify address in a RAM, the number of addresses will be
Options: A) 216 B) 65,536 C) 64K D) Any of the above

Ans:-B,-B


What command is used to remove a file?
Options: del,    mv,    rm,    remove

Ans:C ,C


. The most open source DBMS.
Options: a. Microsoft SQL Server b. Microsoft Access c. MySQL d. Oracle

Ans:9 – c ,9 – c

www.000webhost.com