Which is an example of a function?


Options: =add(A1:A2) B. =A1+A2 C. =SUM(A1:A2) D. A1+A2

Ans:– C ,






More MS-Excel Related questions:


In the PROLOG language system, facts are manipulated by:
Options: algorithms,    rules,    memory,    simulations

Ans:B ,B


What is the total resistance of a parallel circuit that contains two resistors having values of 220 ohm and 470 ohm?
Options: 220 ohm,    150 ohm,    445 ohm,    690 ohm

Ans:B ,B


The basic unit within a computer store capable of holding a single unit of data is
Options: Register,    ALU,    Control unit,    Store location

Ans:D ,D


A memory that does not change its contents without external causes is known as
Options: Dynamic memory,    Static memory,    RAM,    EEPROM

Ans:B,(Banswer


. What is the second generation computers made?
Options: Resistors B. Transistors C. Vacuum tubes D. Integrated Circuits

Ans:– B ,


. A hard copy would be prepared on a
Options: A) Line printer B) Dot matrix Printer C) Typewriter terminal D) All of the above

Ans:1-D,1-D


A database language concerned with the definition of the whole database structure and schema is ________
Options: a. DCL b. DML c. DDL d. All of above

Ans:ndash; c,ndash; c


Any storage device added to a computer beyond the immediately usable main storage is known as
Options: Floppy disk,    Hard disk,    Backing store,    Punched card

Ans:C ,C


What is the difference between ‘Open’ and ‘Open Exclusively’?
Options: a. Open statement opens access database files and Open Exclusively opens database files of other program like Oracle b. Open Exclusive locks whole database so that no one can access it whereas Open locks only the record that is being accessed c. Both Open and Open Exclusively are same d. Open Exclusive command does not exist in MS Access

Ans:ndash; b,ndash; b


Which is another name for functional language?
Options: Machine,    Application language,    Low-level language,    High-level language

Ans:B ,B


. The first digital computer built with IC chips was known as
Options: A) IBM 7090 B) Apple ? 1 C) IBM System / 360 D) VAX-10

Ans:C,C


Plotter accuracy is measured in terms of repeatability and
Options: buffer size,    resolution,    vertical dimension,    intelligence

Ans:B ,B


. Which of the following can be used to navigate documents?
Options: a. frames b. hyperlinks c. web toolbar d. all of the above

Ans: –  B , –  B


What will be the output of the program if the array begins at address 65486? #include<stdio.h> int main() { int arr[] = {12, 14, 15, 23, 45}; printf("%u, %u\n", arr, &arr); return 0; }
Options: 65486, 65488,    65486, 65486,    65486, 65490,    65486, 65487

Ans:B ,B


. In the datasheet formatting dialogue box, which is not an option in the border and line styles dropdown list box?
Options: a. datasheet border b. datasheet underline c. Column Header underline d. vertical gridline

Ans:– c,– c


What is the alternative name for a diskette?
Options: Floppy disk,    Hard disk,    Flexible disk,    Winchester disk

Ans:A ,A


A Turnaround document
Options: is circulated among all the staff of an organization.,    is circulated among all the heads of departments of an organization.,    is output at one point which later comes back as an input,    All of the above

Ans:C ,C


The range of frequencies available for data transmission is known as
Options: Baud,    Bandwidth,    Byte,    Bits

Ans:B ,B


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

Ans:A ,A


. What does an inner join display?
Options: a. Records from the second recordset and only records from the first recordset where the common fields are equal b. Records from the first recordset and only records from the second recordset where the common fields are equal c. Records that have the same value in the common field d. Records from the first recordset only

Ans:8 – c ,8 – c


Which Motherboard form factor uses one 20 pin connector
Options: ATX,    AT,    BABY AT,    All of the above

Ans:A ,A


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

Ans:C ,C


. A ….allows you to write on screen with a digital pen and convert that writing into characters that the PC can process
Options: a. Monitor RS b. Tablet PC c. Database manager d. Media Center

Ans:7 – b ,7 – b


In MODEMS
Options: Several digital signals are multiplexed,    A digital signal changes some characteristic of a carrier wave,    Digital signal is amplified,    All of the above

Ans:B ,B


Which method is frequently used, especially in the early stages of design?
Options: The iterative design method,    The direct method,    The design selection method,    All of the above

Ans:A ,A


20. Which command is used to display a list of deleted files that DOS can undelete?
Options: a. Undelete *.* b. Undelete/all c. Undelete/list d. None of the above

Ans:Correct Answer: c ,Correct Answer: c


Relay ladder logic is used in a PC because:
Options: it is impossible to write a control program for a machine in any other logic,    it is the best industrial control language ever developed.,    most industrial control personnel are familiar with relay ladder logic diagrams and this is the easiest for them to use,    All of the above

Ans:C ,C


. What was the expected feature of fifth generation computers when Japan started FGCS?
Options: A) Operating Systems B) Paralled Processing C) ULSI D) None of above

Ans:B,B


. A ….is a pointing device
Options: a. Monitor b. Mouse c. Keyboard d. None of these

Ans:1 – b ,1 – b


Which of the following is not the part of standard office suite?
Options:  A) Word Processor, B) Database, C) Image Editor, D) File manager, 

Ans:-D,-D


Sequential retrieval on a primary key for sequential file storage has which of the following features?
Options: Very fast,    Moderately fast,    Slow,    Impractical

Ans:A ,A


Batch files contain a group of MS-DOS commands that are run in successive order. What filename extension identifies batch files?
Options: COM,    BAT,    EXE,    SYS

Ans:B ,B


. Which of the following is NOT possible when printing Forms?
Options: a. Print page 1, 3, and 5 b. Print pages 1 through 5 c. Print selected records d. Print only the third record

Ans:5 – a ,5 – a


. Digital devices are
Options: A) Digital Clock B) Automobile speed meter C) Clock with a dial and two hands D) All of them

Ans:2-A,2-A


Segmentation of a data stream happens at which layer of the OSI model?
Options: Physical,    Data Link,    Network,    Transport

Ans:D ,D


What Oracle backup and recover file contains user and system data?
Options: Control file,    Datafile,    OnLine ReDo file,    Offline ReDo file

Ans:B ,B


Who was the father of Punched Card Processing?
Options: J Presper Eckert,    Charles Babbage,    Dr. Herman Hollerith,    Blaise Pascal

Ans:C ,C


What is the name given to the software which can be legally compiled and often used for free?
Options: Shareware program,    Public domain program,    Firmware program,    Mindware

Ans:B ,B


Order-filling activity in the physical system is triggered by the
Options: manufacturing information system,    order entry subsystem,    billing subsystem,    accounts receivable subsystem

Ans:C ,C


A network schema
Options: restricts the structure to a one-to-many relationship,    permits many-to-many relation¬ships,    stores data in tables,    All of the above

Ans:B ,B


What is the name given to the 8-bit unit used for coding data?
Options: block of characters,    byte,    word,    K

Ans:B ,B


.  To open the existing presentation, press
Options: Ctrl + L B. Ctrl + N C. Ctrl + A D. Ctrl + O

Ans: – D ,


An error detecting code is which code is the remainder resulting from dividing the bits to be checked by a predetermined binary number, is known as
Options: Cyclic redundancy check,    Checksum,    Error detecting code,    Error rate

Ans:A ,A


Identify which of the following are declarations 1 : extern int x; 2 : float square ( float x ) { ... } 3 : double pow(double, double);
Options: 1,    2,    1 and 3,    3

Ans:C ,C


. Long text can be broken down into many lines within a cell. You can do this through
Options: a.  Wrap Text in Format >> Cells b.  Justify in Edit >> Cells c.  Text Wraping in Format >> Cells, Layout tab d.  All of above

Ans:– a,– a


While working with MS-DOS, which command is used to specify the colour display, 40 columns and color?
Options: MODE COLOUR,    MODE/C,    MODE CO40,    MODE CHANGE

Ans:C ,C


What is the name given to the molecular-scale computer?
Options: Femtocomputer,    Nanocomputer,    Supercomputer,    Microcomputer

Ans:B ,B


In what file can you specify which users are not allowed to access a system via FTP?
Options: /etc/ftpusers,    /etc/hosts.deny,    /etc/ftpaccess,    All of the above

Ans:A ,A


. The __________ field is used to hold a yes or no answer.
Options: a. object b. number c. text d. logical

Ans:9 – d ,9 – d


Who is called a supervisor of computer activity? A)  Memory B)  Operating System C)  I/O Devices D)  Control Unit
Options:

Ans:– B ,

www.000webhost.com