The cell reference for cell range of G2 to M12 is_


Options: A. G2.M12, B. G2;M12, C. G2:M12 ,D. G2-M12

Ans:C ,G2:M12


Description: mcqquestions

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

Hits Today: 7292 | Level: Moderate




Got some suggestion about this question or to make this site better? Please leave your comments below.


Want to see where do you stand among other aspirants in "Computer" Category?

Click Here to take quick 5 mins MCQ test to find out.

More MS-Excel Related questions:


A diode is in series with 220W. If the voltage across the resister is 4V, what is the current through the diode?
Options: 55 A,    55.86 A,    18.2 mA,    16.3 mA

Ans:C ,C


. The difference between Slide Design and Auto Content Wizard is
Options: a.  Both are same b.  AutoContent Wizard is just the wizard version of Slide Design c.  Slide Design does not provide sample content but Auto Content Wizard provides sample content too! d.  Slide Design asks your choice in steps but Auto Content Wizard does not let you make choices

Ans:6 – C ,6 – C


Microsoft Excel is a powerful………..
Options: Word processing package B. Spreadsheet package C. Communication S/W Package D. DBMS package

Ans:– B ,


The language used in application programs to request data from the DBMS is referred to as the
Options: DML,    DDL,    query language,    All of the above

Ans:A ,A


Any piece of equipment forming an interface to a data communication system is
Options: DTE,    DTA,    CSA,    DCA

Ans:B ,B


The chunks of a memory are known as
Options: Sector B. Offset C. Page D. Frame

Ans:– D ,


Which of the following statements should be used to obtain a remainder after dividing 3.14 by 2.1 ?
Options: rem = 3.14 % 2.1;,    rem = modf(3.14, 2.1);,    rem = fmod(3.14, 2.1);,    Remainder cannot be obtain in floating point division.

Ans:C ,C


. Tape speed is measured in

Options: A) Feet per second B) Inch per second C) Meter per second D) Centimeter per second

Ans:B,B


. Anything you cut or copy on to the clipboard remains there until you
Options: a. Change it b. Clear c. Exit windows d. All of the above

Ans:3 – d ,3 – d


What command is used to halt a Linux system?
Options: init 0,    Shutdown -t,    Shutdown -g -y0,    Ctrl+Alt+Del

Ans:A ,A


. Which of the following database objects extracts information from one or more tables or queries?
Options: a. Forms b. Queries c. Reports d. Tables

Ans:8 – b ,8 – b


Which of the following technique is used for Time-To-Line (TTL)?
Options: a technique used in best-effort delivery system to avoid endlessly looping packets.,    a technique used by protocols in which a lower level protocol accepts a message from a higher level protocol and places it in the data portion of the low level frame,    One of the pieces that results when an IP gateway divides an IP datagram into smaller pieces for transmission across a network that cannot handle the original datagram size.,    All of the above

Ans:A ,A


You have a system that periodically locks up. You have ruled out software, and now suspect that it is hardware. What should you do first that could help you narrow it down to the component at fault?
Options: rotate the RAM,    replace the RAM,    replace the level 2 cache SIMM,    disable the CPU cache in CMOS

Ans:D ,D


  Which PowerPoint feature adds special effects to modify the appearance of the slides and the timing between each slide?
Options: Color Schemes B. Animation C. Transition Settings D. Handouts

Ans:– C ,


A hand-held device which reads marks or characters on paper by detecting photo-sensitivity is known as
Options: Light pen,    Optical-wand,    Plotter,    All of the above

Ans:B ,B


. 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


A systems programming language for microcomputers in the Intel family is
Options: PL/C,    PL/CT,    PL/M,    PLA

Ans:C ,C


Access time is the highest in the case of
Options: floppy disk,    cache,    swapping devices,    magnetic disk

Ans:D ,D


A financial modeling package for a PC is similar to a spreadsheet package, but it can handle larger data files than a spreadsheet, and it has a built-in _____ seeking function.
Options: aim,    target,    goal,    plan

Ans:C ,C


The input unit of a computer
Options: feeds data to the CPU or memory,    retrieves data from CPU,    directs all other units,    All of the above

Ans:A ,A


. The proper definition of a modern digital computer is
Options: A) An electronic automated machine that can solve problems involving words and numbers B) A more sophistic and modified electronic pocket calculator C) Any machine that can perform mathematical operations D) A machine that works on binary code

Ans:5-A,5-A


What is the administrative distance of OSPF?
Options: 90,    100,    110,    120

Ans:C ,C


We have Market Basket data for 1,000 rental transactions at a Video Store. There are four videos for rent -- Video A, Video B, Video C and Video D. The probability that Video D will be rented given that Video C has been rented is known as ________ .
Options: the basic probability,    support,    lift,    confidence

Ans:D ,D


. Which is an internal command?
Options: a. Scandisk b. XCOPY c. Deltree d. None of the above

Ans:1 – d ,1 – d


A distributed database is which of the following?
Options: A single logical database that is spread to multiple locations and is interconnected by a network,    A loose collection of file that is spread to multiple locations and is interconnected by a network,    A single logical database that is limited to one location.,    A loose collection of file that is limited to one location.

Ans:A ,A


Which of the following abilities is/are required for both the system programmer and the EDP auditor?
Options: knowledge in computer science,    knowledge in accounting applications,    two of the above,    knowledge in information systems

Ans:A ,A


. When you cut or copy the text or picture, it stores temporarily in the
Options: a. File b. Clipboard c. Icon d. All of above

Ans:3 – b ,3 – b


A rectangle represents which of the following in an ERD?
Options: Attribute,    Entity,    Optional One,    Relationship

Ans:B ,B


While working with MS-DOS, which command is used to switch to the monochrome display from color display?
Options: MODE BLACK,    MODE B/W,    MODE MONO,    MODE CO40

Ans:C ,C


What should you do if you require pasting the same format in many places?
Options:  A) Click the Format painter and go on pasting in many places holding Alt Key, B) Double click the format painter then go on pasting in many places, C) Click the format painter then go on pasting to many places holding Ctrl Key, D) All of above,

Ans:-B,-B


. A whole document can be formatted using the commands on the
Options: a. File menu b. Help menu c. Format menu d. Tools menu

Ans:9 – c ,9 – 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


Which of the following statement is false?
Options:  A) You can set different header footer for even and odd pages, B) You can set different page number formats for different sections, C) You can set different header footer for first page of a section, D) You can set different header and footer for last page of a section,

Ans:-D,-D


Which of the following digits are known as the terminal number of the Network User Address (NUA)?
Options: 5-7,    1-4,    8-12,    13-14

Ans:C ,C


The register which holds the address of the location to or from which data are to be transferred is known as
Options: index register,    instruction register,    memory address register,    memory data register

Ans:C,C


Which part of the system allows the user to interact with the compiler? (a) Memory
Options: Translator,    Communications processor,    Interpreter,    None of the above

Ans:D ,D


. Which of the following is true regarding page Orientation of a Document?
Options: a. Page Orientation can be change at any time b. Page Orientation of document determines by printer c. Page Orientation must be set before start typing d. Page Orientation of a document cannot be changed.

Ans:–  A,–  A


.   PowerPoint can display data from which of the following add-in software of MS-Office
Options: a. Equation editor b. Organization chart c. Photo album d. All of these

Ans:5 – D ,5 – D


. ______ shares characteristics with both hardware and software
Options: a. Operating system b. Software c. Data d. None

Ans:4 – a ,4 – a


Which of the following printer can be classified as a page-at-a-time printer?
Options: Laser printer,    Dot-matrix printer,    Thermal printer,    Inkjet printer

Ans:A,A


What are the most likely conditions for ESD?
Options: Hot and dry,    Hot and wet,    Cold and dry,    Cold and wet

Ans:B ,B


Which menu do you choose to create header? (in MS Office 2003)
Options: format, header and footer B. view, header C. insert, header and footer D. view, header and footer

Ans:– A ,


What is the Demilitarized Zone?
Options: The area between firewall & connection to an external network B. The area between ISP to Military area             C. The area surrounded by secured servers D. The area surrounded by the Military

Ans:– A ,


Credit checking is done in the
Options: order processing system,    quotation system,    order entry system,    any of the above

Ans:C ,C


Which of the following special shell variables is used to process number of the last background job?
Options: $!,    $#,    $0,    $*

Ans:A ,A


A relationship should be specified how in the ODL?
Options: One direction starting with the first class,    One direction starting with the second class,    Neither direction.,    Both directions.

Ans:D ,D


Interconnected networks need communication processors such as switches, routers, hubs, and gateways. Select the best fit for answer:
Options: TCP/IP,    Protocol,    Open Systems,    Internetwork processor

Ans:D ,D


    Which command lists the contents of current directory of a disk
Options: a.    Copy b.    Tree c.    Cd d.    Dir

Ans:D,Correct Answer: Dir


.   Which of the following tools enable you to add text to a slide without using the standard placeholders?
Options: a. Text box tool b. Line tool; c. Fill color d. Auto shapes tool

Ans:3 – A ,3 – A


An inventory management system should answer the questions
Options: what and why,    when and how much,    who and why,    where and when

Ans:B ,B

www.000webhost.com