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

More MS-Excel Related questions:

Referential integrity means
Options: a. Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table b. Do not enter a value in the primary key field of child table if that value does not exist in  the primary key of the parent table c. Do not enter a value in the foreign key field of a parent table if that value does  not exist in the primary key of the child table d. All of above

Ans:ndash; a,ndash; 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

Backups should be done
Options: daily for most installations,    weekly for most installations,    as several image copies, followed by an incremental,    as several incrementals, followed by an image copy

Ans:D ,D

.  A(n) _______ is major object that completes an action or a set of actions.
Options: a.            event b.           property c.           procedure d.            macro

Ans:– d,– d

Which part of the laser printer should NOT be exposed to sunlight?
Options: Transfer corona assembly,    PC drum,    Primary corona wire,    Toner cartridge

Ans:B ,B

The storage locations in the interal storage of a CPU are called
Options: contents,    addresses,    locations,    mask

Ans:B ,B

Which JDBC driver Type(s) is(are) the JDBC-ODBC bridge?
Options: Type 1,    Type 2,    Type 3,    Type 4

Ans:A ,A

Which of the following store command to retrieve data from database?
Options: a. Forms b. Reports c. Queries d. Tables

Ans:ndash; c,ndash; c

Point out the error in the following program. #include<stdio.h> #include<string.h> int main() { char str1[] = "Learn through IndiaBIX\", str2[120]; char *p; p = (char*) memccpy(str2, str1, 'i', strlen(str1)); *p = '\0'; printf("%s", str2); return 0; }
Options: Error: in memccpy statement,    Error: invalid pointer conversion,    Error: invalid variable declaration,    No error and prints "Learn through Indi"

Ans:D ,D

How to insert Tables in Slide?
Options: Insert Table from Insert menu B. Click on Insert Table in content pane of blank slide C. Option A & B D. Tables cannot be inserted in slides

Ans:– C ,

With MS-DOS which command will divide the surface of the blank floppy disk into sectors and assign a unique address to each one?
Options: FORMAT command,    FAT command,    VER command,    CHKDSK command

Ans:A ,A

The term gigabyte refers to
Options: 1024 bytes,    1024 kilobytes,    1024 megabytes,    1024 gigabytes


12. Swapping
Options: a. Works best with many small partitions b. Allows many programs to use memory simultaneously c. Allows each program in turn to use the memory d. Does not work with overlaying

Ans:Correct Answer: c,Correct Answer: c

What do you mean by a Workspace?
Options: Group of Columns B. Group of Worksheets C. Group of Rows D. Group of Workbooks

Ans:– D ,

Excel uniquely identifies cells within a worksheet with a cell name
Options: Cell names,Column numbers and row letters,Column letters and row numbers,Cell locator coordinates

Ans:C,Column letters and row numbers

The word 'linear' in linear programming is used to describe:
Options: relationship among two or more variables in a straight line,    relationship among two or more variable which are directly proportional,    relationship among two or more variables is linear,    all of the above

Ans:B ,B

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


The output of a 2 input OR gate is 0 only when its
Options: both inputs are 0,    either input is 1,    both inputs are 1,    either input is 0


. Napier Bones were invented in
Options: A) 1614 B) 1617 C) 1620 D) None of above


A computer program that converts an entire program into machine language at one time is called a/an
Options: interpreter,    simulator,    compiler,    commander

Ans:C ,C

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


An ROP would be attached to a
Options: simplex channel,    duplex channel,    half duplex channel,    full duplex channel

Ans:A ,A

. Essential business letter elements include the _____.
Options: a. date line and inside address b. message c. signature block d. all of the above

Ans:– D,– D

. Portrait and Landscape are
Options: a. Page Orientation b. Paper Size c. Page Layout d. All of above

Ans:– A,– A

. The Cancel and Enter buttons appear in the:
Options: a. Title bar b. Formula bar c. Menu bar d. Sheet tabs

Ans:– b,– b

. DOS uses a special batch file named?
Options: a. Autoexec.bat b. Autoexe.bat c. Autoexecute.bat d. Auto.bat

Ans:5 – a ,5 – a

The three dimensions of system integrity do not include
Options: accuracy,    completeness,    security,    appropriateness

Ans:B ,B

. Which of the following methods CANNOT be used to copy a block of text from one part of a table to another?
Options: a. Press [Ctrl]+[C] and [Ctrl]+[V]. b. Right-click, choose from the shortcut menu Copy and Paste. c. Press [Ctrl]+[+] and [Ctrl]+[-]. d. From the ribbon, select Copy and Paste.

Ans:1 – c ,1 – c

DropCap means
Options:  A) All Caps, B) Small Caps, C) Title case, D) None of above,


A floppy disk contains
Options: Circular tracks only,    Sectors only,    Both circular tracks and sector,    All of the above

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

What is a TSR?
Options: test status request,    terminate and stay resident program,    take status request,    token set ready

Ans:B ,B

Microfilm reader is a
Options: OCR device,    COM device,    MICR device,    None of the above


. Which of the following items are examples of storage devices?
Options: A) Floppy / hard disks B) CD-ROMs C) Tape devices D) All of the above


_____ help prevent power surges.
Options: Surge suppressor,    Spike protector,    UPS system,    High-grade multi-meter

Ans:A ,A

. What is the symbol for dividing? A ./ B. % C. & D. #
Options: A ./ B. % C. & D. #

Ans:– A ,/

. We can replace a font on all sides with another font using the option :
Options: a. Edit –> Fonts b. Tools –> Fonts c. Tools -> Replace Fonts d. Format -> Replace Fonts

Ans:1 – D ,1 – D

What is the name of the operating system which was originally designed by scientists and engineers for use by scientists and engineers?
Options: XENIX,    UNIX,    OS/2,    MS DOS

Ans:B ,B

The binary system uses powers of
Options: 2,    10,    8,    16

Ans:A ,A

In the third generation of computers:
Options: distributed data processing first became popular,    an operating system was first developed,    high-level procedural languages were first used,    on-line, realtime systems first became popular

Ans:D ,D

What command is used to save the standard output in a file, as well as display it on the terminal?
Options: tee,    grep,    cat,    more

Ans:A ,A

Large collection of files are called
Options: a . fields b . records c . database d . sectors


The MAC (Media Access Control) address of the network card is used in both Ethernet and Token-Ring networks and is essential for communication. What does MAC provide?
Options: A logical address that identifies the workstation,    A physical address that is randomly assigned each time the computer is started,    A physical address that is assigned by the manufacturer,    The logical domain address for the workstation

Ans:C ,C

. The ALU of a computer normally contains a number of high speed storage element called
Options: A) Semiconductor memory B) Registers C) Hard disks D) Magnetic disk


Hardware _____ memory is seldom used in modern computers.
Options: ROM,    RAM,    LIFO,    PROM

Ans:C ,C

. To insert new slide in the current Presentation, we can choose:
Options: a. Ctrl+M b. Ctrl+N c. Ctrl+O d. Ctrl+F

Ans:7 – A ,7 – A

A  Animation Schemes can be applied to ________ in the presentation.
Options: a. All slides, B. Select slides, C. Current Slide, D. All of the above

Ans:D ,All of the above

The cp command uses:
Options: standard input file,    standard output file,    both input and output file,    neither standard input nor standard output file

Ans:D ,D

Problem analysis is done during
Options: system design phase,    systems analysis phase,    before system test,    All of the above

Ans:B ,B

What stage of the manufacturing process has been described as "the mapping of function onto form"?
Options: Design,    Distribution,    project management,    field service

Ans:A ,A