. How do you rearrange the data in ascending or descending order?


Options: Data, Sort B. Data, Form C. Data, Table D. Data Subtotals

Ans: – A ,


Description: mcqquestions






More MS-Excel Related questions:


What will be the output of the program? #include<stdio.h> #define MAN(x, y) ((x)>(y)) ? (x):(y); int main() { int i=10, j=5, k=0; k = MAN(++i, j++); printf("%d, %d, %d\n", i, j, k); return 0; }
Options: 12, 6, 12,    11, 5, 11,    11, 5, Garbage,    12, 6, Garbage

Ans:A ,A


A modern electronic computer is a machine that is meant for
Options: Doing quick mathematical calculations,    Input storage, manipulation of outputting of data,    Electronic data processing,    Performing repetitive tasks accurately

Ans:B ,B


. What is the shortcut key to insert a new comment in a cell?
Options: a. F2 b. Alt + F2 c. Ctrl + F2 d. Shift + F2

Ans:– d,– d


For what purposes are views used?
Options: To hide columns only,    To hide rows only,    To hide complicated SQL statements only,    All of the above are uses for SQL views.

Ans:D ,D


. which of the following is not a database object?
Options: a. Tables b. Queries c. Relationships d. Reports

Ans:9 – c ,9 – c


. Whenever you move a directory from one location to another
Options: a. All files inside the directory are moved b. All the subdirectory inside that directoryare moved c. The directory is moved the source file is not moved d. Both a and b

Ans: d, d


How can you define a field so that when entering data for that field it will display ****** instead of actual typed text
Options: a. Input mask b. Validation Rule c. Indexed d. IME Mode

Ans:ndash; a,ndash; a


The most structured marketing problems are likely to be those dealing with
Options: product,    promotion,    place,    price

Ans:C ,C


Working at home might seem like an interesting option. However, _____ contact with other co-workers does have advantages.
Options: tele conferencing,    communication,    face-to face,    top-to-bottom

Ans:C ,C


. What does the disk drive of a computer do?
Options: A) Rotate the disk B) Read the disk C) Load a program from the disk into the memory D) Both b and c

Ans:D,D


The fastest type of memory from the following list is
Options: tape,    semiconductor memory,    disk,    bubble memory

Ans:B ,B


Most continuous control actuators:
Options: are of the time proportioning type,    use a 4 to 20 mA current loop input,    are used with standard continuous control loop,    (b) and (c) above

Ans:D ,D


. Which of the following is a class of computers based on model?
Options: A) Digital Computer B) Hybrid Computers C) Analog Computers D) AT Computers

Ans:D,D


. The Search tool is best used when searching for ______ data.
Options: a. simple b. multiple c. unique d. formatted

Ans:6 – a ,6 – a


Networks that follow the 802.5 standard appear to be in a star topology but are actually operating in what type of topology?
Options: Linear bus,    Modified star,    Modified ring,    Ring

Ans:D ,D


Which of the following database object hold data?
Options: a. Forms b. Reports c. Queries d. Tables

Ans:ndash; d,ndash; d


. The act of retrieving existing data from memory is called
Options: A) Read-out B) Read from C) Read D) All of above

Ans:D,D


A device which converts human readable data into machine language is
Options: Card reader,    Card punch,    Punched paper tape,    Character reader

Ans:D ,D


In the instruction, 500 SUBA # 50 the command field is:
Options: 500,    # 50000,    SUBA,    (b) and (c)

Ans:C ,C


. The basic elements of a form or a report are called:
Options: a. Controls b. Objects c. Windows d. Properties

Ans:– a,– a


. A DBMS that runs on many different operating systems is said to be __________.
Options: a. scalable b. robust c. platform independent d. distributed

Ans:0 – c ,0 – c


Which of the following is the address of the router?
Options: The IP address,    The TCP address,    The subnet mask,    The default gateway

Ans:D ,D


The hardware features of LISP machines generally include:
Options: large memory and a high-speed processor,    letter-quality printers and 8-inch disk drives,    a mouse and a specialized keyboard,    both (a) and (c)

Ans:D ,D


. In a datasheet, what does each row represent?
Options: a. Record b. Field c. Database d. Table

Ans:– a,– a


Report generators are used to
Options: store data input by a user,    retrieve information from files,    answer queries,    both (b) and (c)

Ans:D ,D


A computer-controlled device for training exercises that duplicates the work environment is a:
Options: simulator,    duplicator,    trainer,    COM device

Ans:A ,A


Which of the following is true regarding VLANs?
Options: You must have at least two VLANs defined in every Cisco switched network.,    All VLANs are configured at the fastest switch and, by default, propagate this information to all other switches.,    You should not have more than 10 switches in the same VTP domain.,    VTP is used to send VLAN information to switches in a configured VTP domain.

Ans:D ,D


The computer program language which is widely used in computer science and engineering and also in business is
Options: COBOL,    FORTRAN,    PASCAL,    LISP

Ans:C ,C


. The question mark (?) indicates in file searching
Options: a. A single character b. A group of character c. Questions d. None of above

Ans:8 – a ,8 – a


Which of the following is a group of one or more attributes that uniquely identifies a row?
Options: Key,    Determinant,    Tuple,    Relation

Ans:A ,A


. How can you show or hide the gridlines in Excel Worksheet?
Options: a.  Go to Tools >> Options >> View tab and mark or remove the check box named Gridline b.  Click Gridline tool on Forms toolbar c.  Both of above d.  None of above

Ans:– c,– c


The commonly used UNIX commands like date, ls, cat, etc. are stored in
Options: /dev directory,    /bin and /usr/bin directories,    /tmp directory,    /unix directory

Ans:B ,B


What will be the output of the program (myprog.c) given below if it is executed from the command line? cmd> myprog 1 2 3 /* myprog.c */ #include<stdio.h> #include<stdlib.h> int main(int argc, char **argv) { int i, j=0; for(i=0; i<argc; i++) j = j+atoi(argv[i]); printf("%d\n", j); return 0; }
Options: 123,    6,    Error,    "123"

Ans:B ,B


In Prototyping
Options: BASIC is used,    COBOL is used,    4GLs are used,    system is documented

Ans:C ,C


A machine that connects to two or more electronic mail systems and transfers mail messages among them is known as
Options: Gateways,    mail gateway,    bridges,    User Agent

Ans:B ,B


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 can a Report Wizard NOT do?
Options: a. Add summary functions b. Create groups c. Group fields into more than one Control Layout d. Select fields

Ans:3 – c ,3 – c


The working principles of today's computers were provided by an English mathematician
Options: Charles Babbage,    Dr. Hollerith,    Donald Reach,    Ken Reider

Ans:A ,A


While creating relationship, when you drag a field of a field to drop into another table the mouse pointer changes into
Options: a. a doctor’s sign b. thin + sign c. outline rectangle d. None of above

Ans:ndash; c,ndash; c


Which of the following situation requires the use of ID-dependent entities?
Options: Association relationships only,    Multivalued attributes only,    Archetype/instance relationships only,    All of the above use ID dependent entities

Ans:D ,D


What does protocol defines?
Options: Protocol defines what data is communicated. B. Protocol defines how data is communicated. C. Protocol defines when data is communicated. D. All of above

Ans:– D ,


. Relationship can be establish between two tables by
Options: a. Drag Primary key of a table into Foreign key of another table b. Drag Foreign key of a table into Primary key of another table c. Drag any key of a table into any key of another table d. All of the above

Ans:– a,– a


Which of the following is directry controlled from a keyboard.
Options: Card punch,    Punched paper tape,    Magnetic disk,    Magnetic tape

Ans:A ,A


The memory sizes in mainframe computers and advanced technology micro computers are expressed as
Options: Bytes,    Kilo-bytes,    Bits,    Megabytes

Ans:D,D


A 32 bit microprocessor has the word length equal to
Options: 2 bytes,    32 bytes,    4 bytes,    8 bytes

Ans:C ,C


. Which of the following shortcuts can be used to insert a new line in the same cell?
Options: Enter B. Alt + Enter C. Ctrl + Enter D. Shift + Enter

Ans:– B ,


  Which access method is used to access cassette tape? A.  Direct B.  Sequential         C.  Both of the above D.  None of the above
Options: Keyboard B. System Bus C. Monitor D. Memory

Ans:– B ,


. The meaning of Straight-through Cable is
Options: Four wire pairs connect to the same pin on each end B. The cable Which Directly connects Computer to Computer C. Four wire pairs not twisted with each other D. The cable which is not twisted

Ans: – A ,


44. Which feature is used to replace straight quotes with smart quotes as you type?
Options: a. Auto Correct as you type b. Auto Change as you type c. Auto Format as you type d. Smart Tags as you type

Ans:–  C ,–  C


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

Ans:A ,A

www.000webhost.com