Which of the following is correct?


Options: =AVERAGE(4, 5, 6, 7) B. =AVERAGE(A1, B1, C1)               C. =AVERAGE(A1:A9, B1:B9) D. =All of the above

Ans:– D ,


Description: mcqquestions

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

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


. What is System Analysis?
Options: The design of the screen the user will see and use to enter or display data B. System analysis defines the format and type of data the program will use C. System Analysis involves creating formal model of the problem to be solved D. None of the above

Ans: – C ,


The system unit of a personal computer typically contains all of the following except:
Options: microprocessor,    disk controller,    serial interface,    modem

Ans:D ,D


. Which of the following concept is best to preventing page faults?
Options: a. Paging b. The working set c. Hit ratios d. Address location resolution

Ans:8 – b ,8 – b


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

Ans:B ,B


When you connect to an online information service, you are asked to provide some kind of identification such as your name, an account number and a password. What is the name given to this brief dialogue between you and the information system?
Options: Security procedure,    Safeguard procedure,    Identification procedure,    Log-on procedure

Ans:D ,D


A byte is comprised of:
Options: One bit,    Four bits,    Eight bits,    Sixteen bits

Ans:C,C


Which SQL-92 standard SQL command can be used to change a table name?
Options: RENAME TABLE,    CHANGE TABLE,    ALTER TABLE,    None of the above is correct.

Ans:D ,D


What will be the output of the program ? #include<stdio.h> int main() { union a { int i; char ch[2]; }; union a u; u.ch[0]=3; u.ch[1]=2; printf("%d, %d, %d\n", u.ch[0], u.ch[1], u.i); return 0; }
Options: 3, 2, 515,    515, 2, 3,    3, 2, 5,    515, 515, 4

Ans:A ,A


You record the algorithm in the _____ column of the IPO chart.
Options: Input,    Output,    Processing,    Purpose

Ans:C ,C


Ethernet networks can be cabled in a number of topologies, depending on what works best in each environment. As more nodes are added, the efficiency of Ethernet decreases. Select the best answer as to why Ethernet becomes less efficient as size increases.
Options: Network collisions occur,    Repeaters cannot increase the signal strength sufficiently,    Cable terminators do not reflect the signal properly,    Cable terminators do not absorb the signal properly

Ans:A ,A


Change the _____ to create a document in wide format
Options: a. Page Orientation b. Page margins c. Paper Style d. Paper Source

Ans:– A,– A


. Which technology is used in Compact disks?
Options: A) Mechanical B) Electrical C) Electro Magnetic D) Laser

Ans:D,D


A WATS arrangement
Options: is always less expensive than flat-rate service,    is less expensive than flat-rate service only when the number of calls is large and the duration of each is short,    is less expensive than flat-rate service only when the number of calls is small and the duration of each is long,    is never less expensive than flat-rate service

Ans:B ,B


Which one of the following properties of a magnetic circuit can be directly compared to current in an electrical circuit?
Options: Number of lines of force,    Flux density,    Reluctance,    Magnetomotive force

Ans:A ,A


Database management systems are intended to:
Options: eliminate data redundancy,    establish relationships among records in different files,    manage file access,    maintain data integrity

Ans:E ,E


8. In a document what is the maximum number of columns that can be inserted in MS Word Table?
Options: a. 35 b. 15 c. 63 d. 65

Ans:#8211; C ,#8211; C


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

Ans:9 – c ,9 – c


The CPU chip used in a computer is partially made out of
Options: silica,    carbon,    copper,    gold

Ans:A,A


In which of the following can many entity instances of one type be related to many entity instances of another type?
Options: One-to-One Relationship,    One-to-Many Relationship,    Many-to-Many Relationship,    Composite Relationship

Ans:C ,C


. A zip is a program used to
Options: a. Speed up the computer memory b. Speed up the disk access c. Compress files d. All of above

Ans:7 – c ,7 – c


ART (Automatic Reasoning Tool) is designed to be used on:
Options: LISP machines,    personal computers,    microcomputers,    All of the above

Ans:A ,A


. What does the NOW() function return?
Options: a. It returns the serial number of the current date and time b. It returns the serial number of the current date c. It returns the serial number of the current time d. None of the above

Ans:– d,– d


.   Which of the following should you use to add shading to a drawing object on or an auto shape object?
Options: a. Text box tool b. Line tool c. Fill color d. B and c

Ans:2 – D ,2 – D


. Which colors are used to define a custom color?
Options: a. Red, Blue, Yellow b. Red, Green, Blue c. Blue, Green, Orange d. Green, Orange, Violet

Ans:0 – b ,0 – b


Which of the following refers to a cursor type that when the cursor is opened, a primary key value is saved for each row in the recordset; when the application accesses a row, the key is used to fetch the current values of the row?
Options: Forward only,    Static,    Keyset,    Dynamic

Ans:C ,C


. Cursor is a ____
Options: A) Pixel B) Thin blinking line C) Pointing device D) None of these

Ans:B,B


Two connected routers are configured with RIP routing. What will be the result when a router receives a routing update that contains a higher-cost path to a network already in its routing table?
Options: The updated information will be added to the existing routing table.,    The update will be ignored and no further action will occur.,    The updated information will replace the existing routing table entry.,    The existing routing table entry will be deleted from the routing table and all routers will exchange routing updates to reach convergence.

Ans:B ,B


A section of code to which control is transferred when a processor is interrupted is known as
Options: M,    SVC,    IP,    MDR

Ans:A,(Aanswer


________ is an object-oriented interface that encapsulates data-server functionality.
Options: ODBC,    OLE DB,    JPCD,    ADO

Ans:B ,B


When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
Options: transitive dependency.,    insertion anomaly.,    referential integrity constraint.,    normal form.

Ans:C ,C


At room temperature a conductor has low many holes?
Options: Same number as free electrons,    many,    Only those produced by thermal energy,    less than the free electrons

Ans:A ,A


. Which is not concerned with control panel?
Options: a. Printer b. Run application c. Font d. Keyboard

Ans:4 – b ,4 – b


Management by exception is based on a
Options: positive attitude towards problem recognition,    negative attitude toward problem recognition,    indifferent attitude toward problem recognition,    All of the above

Ans:A ,A


What will you do to treat the constant 3.14 as a long double?
Options: use 3.14LD,    use 3.14L,    use 3.14DL,    use 3.14LF

Ans:B ,B


A computer assisted method for the recording and analyzing of existing or hypothetical systems is
Options: Data transmission,    Data flow,    Data capture,    Data processing

Ans:B ,B


. What’s the best way to design the layout for your slides?
Options: a. Create layouts for slides, handouts and notes using the Master Layout dialog box in slide master view b. For each new slide, select a layout from the Slide Layout task pane c. Apply templates from the Slide Design task pane d. None of above

Ans:0 – B ,0 – B


In OSI network architecture, the dialogue control and token management are responsible of
Options: data link layer,    transport layer,    network layer,    session layer

Ans:D ,D


. 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


. A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?
Options: a. Go to File-Save As – Save As Type – Excel worksheet b. Right click on the spreadsheet tab and select DELETE c. Right click on the spreadsheet and select Insert – Entire Column d. None of above

Ans:– b,– b


Four necessary conditions for deadlock to exist are: mutual exclusion, no-preemption, circular wait and
Options: hold and wait,    deadlock avoidance,    race around condition,    buffer overflow

Ans:A ,A


The limits imposed by the firm itself or its environmental on the decision maker are called
Options: parameters,    constraints,    constructs,    perimeters

Ans:B ,B


. If you want to have a blank line after the title in a worksheet, what is the best thing for you to do?
Options: a. Re-format the spreadsheet b. Insert a row c. Increase the column width d. Use the spacebar

Ans:– b,– b


Point out the error in the following program. #include<stdio.h> int main() { char str[] = "IndiaBIX"; printf("%.#s %2s", str, str); return 0; }
Options: Error: in Array declaration,    Error: printf statement,    Error: unspecified character in printf,    No error

Ans:D ,D


. Which mode loadsminimal set of drivers when starting Windows?
Options: a. Safe Mode b. Normal Mode c. VGA Mode d. Network Support Mode

Ans: a, a


. WAN stands for
Options: A) Wap Area Network B) Wide Area Network C) Wide Array Net D) Wireless Area Network

Ans:5-B,5-B


What is the standard protocol for network management features?
Options: SNA,    FTP,    SNMP,    SMS

Ans:C ,C


Which type of entity cannot exist in the database unless another type of entity also exists in the database, but does not require that the identifier of that other entity be included as part of its own identifier?
Options: Weak entity,    Strong entity,    ID-dependent entity,    ID- independent entity

Ans:A ,A


During the MIS development process, progress reporting meeting are held
Options: daily,    weekly,    monthly,    all of the above

Ans:B ,B


What will be the output of the program ? #include<stdio.h> int main() { static int arr[] = {0, 1, 2, 3, 4}; int *p[] = {arr, arr+1, arr+2, arr+3, arr+4}; int **ptr=p; ptr++; printf("%d, %d, %d\n", ptr-p, *ptr-arr, **ptr); *ptr++; printf("%d, %d, %d\n", ptr-p, *ptr-arr, **ptr); *++ptr; printf("%d, %d, %d\n", ptr-p, *ptr-arr, **ptr); ++*ptr; printf("%d, %d, %d\n", ptr-p, *ptr-arr, **ptr); return 0; }
Options: 0, 0, 0 1, 1, 1 2, 2, 2 3, 3, 3,    1, 1, 2 2, 2, 3 3, 3, 4 4, 4, 1,    1, 1, 1 2, 2, 2 3, 3, 3 3, 4, 4,    0, 1, 2 1, 2, 3 2, 3, 4 3, 4, 5

Ans:C ,C


Which of the following is not true of a magnetic disk?
Options: It is expensive relative to magnetic tape,    It provides only sequential access to stored data,    Users can easily update records by writing over the old data,    It does not provide an automatic audit trail

Ans:B,B

www.000webhost.com