In Excel, a Data Series is defined as what?


Options: A type of chart. B. A cell reference. C. A collection of related data D. A division of results

Ans:– C ,


Description: mcqquestions

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

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


Who launched IBM's First PC in 1981?
Options: Dean Cline,    C.B. Rogers Jr.,    John F. Akers,    David Svenson

Ans:B ,B


. 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 of the following resources must be protected by the operating system?
Options: a. I/O b. Memory c. CPU d. All of the above

Ans:9 – d ,9 – d


Systems that supply data for operations execution or supervision all concern
Options: exception reports,    computing systems,    orders,    All of the above

Ans:C ,C


What will be the output of the program? #include<stdio.h> int main() { int y=128; const int x=y; printf("%d\n", x); return 0; }
Options: 128,    Garbage value,    Error,    0

Ans:A ,A


What will be the output of the program (sample.c) given below if it is executed from the command line (Turbo C in DOS)? cmd> sample 1 2 3 /* sample.c */ #include<stdio.h> int main(int argc, char *argv[]) { int j; j = argv[1] + argv[2] + argv[3]; printf("%d", j); return 0; }
Options: 6,    sample 6,    Error,    Garbage value

Ans:C ,C


Who coordinates the sequencing of events within the central processor of a computer?
Options: Logic unit,    Arithmetic unit,    Register,    Control unit

Ans:D ,D


. 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


The model for a record management system might be
Options: a. handwritten list b. a Rolodex card file c. a business form d. all of above

Ans:d,All of above


In Word, the mailing list is known as the ____________.
Options:  A) Data sheet, B) Source, C) Data source, D) Sheet,

Ans:-C,-C


To use your keyboard instead of the mouse to select tools on the ribbon, you display the KeyTips by pressing the _____________key?
Options: a. Alt b. Ctrl c. Shift+Enter d. Alt+Enter

Ans:– A,– A


Which of the following is the latest version of Excel
Options: a. Excel 2000 b. Excel 2002 c. Excel ME d. Excel XP

Ans:#8211; d,#8211; d


What will be the output of the program in Turbo C (under DOS)? #include<stdio.h> int main() { struct emp { char *n; int age; }; struct emp e1 = {"Dravid", 23}; struct emp e2 = e1; strupr(e2.n); printf("%s\n", e1.n); return 0; }
Options: Error: Invalid structure assignment,    DRAVID,    Dravid,    No output

Ans:B ,B


What command is used to set user and group quotas?
Options: /sbin/usrquota,    /sbin/edquota,    /sbin/quotaon,    /sbin/quota

Ans:B ,B


An index register that is automatically incremented or decremented with each use is
Options: Auto index,    Asynchronous,    Assembler,    Compiler

Ans:A ,A


Which symbol will be used with grep command to match the pattern pat at the end of a line?
Options: ^pat,    $pat,    pat$,    pat^

Ans:C ,C


Needing to using more complicated SQL in database applications is a(n) ________ of normalization.
Options: advantage,    disadvantage,    either an advantage or disadvantage,    neither an advantage nor disadvantage

Ans:B ,B


  Which PowerPoint feature allows the user to create a simple presentation without having to spend too much time on it?
Options: AutoContent Wizard B. Animation C. Color Schemes D. Chart Wizard

Ans:– A ,


A set of programs that handle a firms database responsibilities is called
Options: a. database management system (DBMS) b. database processing system (DBPS) c. data management system (DMS) d. all of above

Ans:.d,.d


. The translator program used in assembly language is called
Options: A) Compiler B) Interpreter C) Assembler D) Translator

Ans:C,C


Binary search algorithm can not be applied to
Options: a. sorted linked list b. sorted binary trees c. sorted linear array d. pointer array  

Ans:a,a


  The arrangement of elements such as Title and subtitle text, pictures, tables etc. is called :
Options: Layout B. Presentation C. Design D. Scheme

Ans:– A ,


Which of the following is still useful for adding numbers?
Options: EDSAC,    ENIAC,    Abacus,    UNIVAC

Ans:C,(Canswer


What was the name of the Japanese worker who was killed by an industrial robot at the Akashi plant of Kawasaki Heavy Industries in Japan?
Options: M. Shubhagya,    Harun Shimada,    Kenji Urada,    K. Miceni

Ans:C ,C


On the feasibility committee, department representatives serve as
Options: ready source of information,    liason to their departments,    direct users of the new system,    both (a) and (c)

Ans:A ,A


Which of the following is not true about documentation?
Options: Documentation, of a system, should be as clear and direct as possible,    Documentation increases the maintenance time and cost,    Documentation gives better understanding of the problem,    All of the above

Ans:B ,B


. Using windows explorer, a plus (+) sign in front of a folder indicates
Options: a. An open folder b. The folder contains subfolder c. A text file d. A graphic file

Ans:7 – b ,7 – b


Which of the following is true concerning Web services standards?
Options: Led by only one group.,    Helped by cooperation between companies.,    Not necessary at this time.,    Important so that the web can flourish.

Ans:D ,D


Which of the following is not an Schema?
Options: Database Schema B. Physical Schema C. Critical Schema D. Logical Schema

Ans:– C ,


The File that contains a set of instructions which are performed when a user logs in, is
Options: .exrc,    .profile,    .autoexec,    autoexec.bat

Ans:B ,B


The physical components of a computer system is
Options: Human ware,    Firm ware,    Hardware,    Software

Ans:C ,C


The first firm to mass-market a microcomputer as a personal computer was
Options: IBM,    Sperry Univac,    Radio Shack,    Data General Corporation

Ans:C,C


To conserve battery power on your laptop computer. What DOS v6.x command should you use?
Options: Powermon.exe,    Power.exe,    Idel.com,    Pw.sys

Ans:B ,B


. Which types of charts can excel produce?
Options: a. Line graphs and pie charts only b. Only line graphs c. Bar charts, line graphs and pie charts d. Bar charts and line graphs only

Ans:– c,– c


Business Intelligence (BI) systems do not obtain their data by which of the following means?
Options: Read and process data from an operational database,    Process transactions,    Process extracts from operational databases,    Process data purchased from data vendors

Ans:B ,B


.   The size of an organization chart object
Options: a. Is determined by the presentation design and cannot be changed b. Is determined by the presentation design but can be changed in PowerPoint c. Is dependent on the amount of text within the organization chart d. B and c

Ans:5 – D ,5 – D


Which of the following is true for a relational database?
Options: Data is represented by tables.,    It is difficult to access data.,    Complex programs have to be written for simple queries.,    All of the above.

Ans:A ,A


. Which data type is better to use for storing phone number in the following format “977-1-1234567”?
Options: a. Text b. AutoNumber c. Number d. Currency

Ans:– a,– a


What type of control pins are needed in a microprocessor to regulate traffic on the bus, in order to prevent two devices from trying to use it at the same time?
Options: Bus control,    Interrupts,    Bus arbitration,    Status

Ans:C ,C


What is split horizon?
Options: Information about a route should not be sent back in the direction from which the original update came.,    It splits the traffic when you have a large bus (horizon) physical network.,    It holds the regular updates from broadcasting to a downed link.,    It prevents regular update messages from reinstating a route that has gone down.

Ans:A ,A


A common boundary between two systems is called
Options: Interdiction,    Interface,    Surface,    None of the above

Ans:B,(Banswer


  What does “apply design template” do?
Options: Changes the content of the slide B. Adds functionality to the slide C. Changes the look of the slide without changing the content D. None of the above

Ans:– C ,


The south pole of a magnet is the one:
Options: that would be attracted to the earths north magnetic pole,    that has its molecules arranged in a random pattern,    that would be attracted to the earth's south magnetic pole,    that would be repelled by the north pole of another magnet

Ans:C ,C


14. While working with MS-DOS, which command is used to rename a file named file1.doc to file2.doc from a different directory called dir1?
Options: a. Ren2.doc dirfile1.doc b. Ren file1.doc file2.doc c. Ren .docdir.doc d. Ren dir1file1.doc file2.doc

Ans:Correct Answer: d,Correct Answer: d


What does OSS stand for?
Options: Open System Software,    Original Source Software,    Open Source Software,    Original System Server

Ans:C ,C


A framework in which circuit boards can he mounted is
Options: Switch circuit,    Chip,    Card cage,    Bar code

Ans:C ,C


. Which command is used to display the contents of the text file of DOS?
Options: a. Copy con b. Copy c. Type d. Dir

Ans: c, c


The relational model uses some unfamiliar terminology. A tuple is equivalent to a:
Options: record,    field,    file,    data base

Ans:A ,A


A _____ DBMS distributes data processing tasks between the workstation and a network server.
Options: Network,    Relational,    Client Server,    Hierarchical

Ans:C ,C


17. Which command is used to create root directory and FAT on disk?
Options: a. Chkdsk b. Command.com c. Format d. Fat

Ans:Correct Answer: c ,Correct Answer: c

www.000webhost.com