. How to restrict the values of a cell so that only whole numbers between 9 and 99 can be entered in a cell.


Options: The Settings tab under the menu Format -> Cells B. The Settings tab under the menu Data -> Validation C. The Settings tab under the menu Data -> Filter -> Advanced Filter D. the Settings tab under the menu Format -> Conditional Formatting

Ans:– B ,


Description: mcqquestions

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

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


  How can you stop a slide show?
Options: Press the right arrow B. Press Escape C. Press the left arrow D. Press the down arrow

Ans:– 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


81. Which of the following option is not available in Insert >> Picture ?
Options: a. Chart b. Word Art c. Clip Art d. Graph

Ans:– D ,– D


. When you point to a text entry in the Office Clipboard gallery in the Clipboard task pane, _____.
Options: a. the first several characters of text in the item display as a ScreenTip b. the text entry is deleted from the Office Clipboard gallery c. the text entry is pasted into the document at the location of the insertion point d. all of the above

Ans: – A , – A


Which of the declaration is correct?
Options: int length;,    char int;,    int long;,    float double;

Ans:A ,A


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


Bring a page into memory only when it is needed is called
Options: Demand Memory B. Demand Paging C. Page Fault D. Page Segmentation

Ans:– B ,


    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


The main electronic component used in first generation computers was
Options: A) Transistors B) Vacuum Tubes and Valves C) Integrated Circuits D) None of above

Ans:-B,-B


A proxy server is used for which of the following?
Options: To provide security against unauthorized users,    To process client requests for Web pages,    To process client requests for database access,    To provide TCP/IP

Ans:A ,A


Which of the following is invalid filename?
Options: shutry,    TRY,    trial,    my .file

Ans:E ,E


. While Finding and Replacing some data in Excel, which of the following statement is valid?
Options: a.  You can Find and Replace within the sheet or workbook b.  Excel does not have option to match case for find c.  Both are valid d.  None are valid

Ans:– a,– a


Which of the following services dynamically resolves NetBIOS-to-IP resolution?
Options: DNS,    DHCP,    WINS,    LMHOSTS

Ans:C ,C


Before a disk drive can access any sector record, a computer program has to provide the record's disk address. What information does this address specify?
Options: Track number,    Sector number,    Surface number,    All of the above

Ans:D ,D


Which of the following layer of OSI model also called end-to-end layer?
Options: Presentation layer B. Network layer C. Session layer D. Transport layer

Ans: – D ,


Which key is used to increase left indent?
Options: Ctrl+I B. Ctrl+M C. Alt+I D. F10

Ans:– B ,


Which one of the following kinds of materials has the lowest permeability?
Options: A diamagnetic material,    A paramagnetic material,    A feiTomagnetic material,    All of the above

Ans:A ,A


. In Excel, a Data Series is defined as what?
Options: a. A type of chart. b. A cell reference. c. A collection of related data d. A division of results

Ans:– c,– c


Which is a permanent database in the general model of compiler?
Options: Literal Table,    Identifier Table,    Terminal Table,    Source code

Ans:C ,C


Which of the following are layers in the TCP/IP model? Application Session Transport Internet Data Link Physical
Options: 1 and 2,    1, 3 and 4,    2, 3 and 5,    3, 4 and 5

Ans:B ,B


A part located in the central processing unit that stores data & information is known as
Options: Core memory,    PROM,    EPROM,    ROM

Ans:A ,A


Which of the following statements is true concerning subqueries?
Options: Involves the use of an inner and outer query.,    Cannot return the same result as a query that is not a subquery.,    Does not start with the word SELECT.,    All of the above.

Ans:A ,A


An aneroid barometer
Options: is very unreliable,    can measure only atmospheric pressure,    measures pressure by sensing deflection of an evacuated chambers.,    can be used to measure gas or liquid flow rates

Ans:C ,C


The control unit of a microprocessor
Options: stores data in the memory,    accepts input data from a keyboard,    Performs arithmetic / logic / functions,    none of the above

Ans:D,None of the above


What will be the output of the program? #include<stdio.h> #define MAX(a, b) (a > b ? a : b) int main() { int x; x = MAX(3+2, 2+7); printf("%d\n", x); return 0; }
Options: 8,    9,    6,    5

Ans:B ,B


An operation that will increase the length of a list is
Options: Insert,    Look-up,    Modify,    All of the above

Ans:A ,A


Which of the following describe the DHCP Discover message? It uses FF:FF:FF:FF:FF:FF as a layer 2 broadcast. It uses UDP as the Transport layer protocol. It uses TCP as the Transport layer protocol. It does not use a layer 2 destination address.
Options: 1 only,    1 and 2,    3 and 4,    4 only

Ans:B ,B


Which of the following is not a factor to consider when switching from small to large block size?
Options: The length of all of the fields in a table row.,    The number of columns,    Block contention,    Random row access speed

Ans:B ,B


Which one of the following equations most directly leads to the resistance of an ordinary household light bulb, assuming that you know the power and voltage rating?
Options: R = E2/P,    P = PR,    P = E2/R,    I = P/E

Ans:A ,A


Which of the following name does not relate to stacks?
Options: a. FIFO lists b. LIFO list c. Piles d. Push-down lists

Ans: a, a


What is the process lag?
Options: The time it takes for the sensor to respond to a changed.,    The lag in the error signal when the setpoint is changed.,    The time it takes for the mass of the process to respond to an input change.,    All of the above

Ans:C ,C


The transfer of data from a CPU to peripheral devices of a computer is achieved through
Options: modems,    computer ports,    interfaces,    buffer memory

Ans:B ,B


. 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


Which of the following refers to something that can be identified in the users' work environment, something that the users want to track?
Options: Entity,    Attribute,    Identifier,    Relationship

Ans:A ,A


Transmission of computerised data from one location to another is called
Options: data transfer,    data flow,    data communication,    data management

Ans:C ,C


A word field may consist of an optional field instruction called a(n) ______
Options: subdocument B. symbol C. signal D. switch

Ans:– D ,


. Where can you define the permanent path for DOS?
Options: a. Io.sys b. Config.sys c. Autoexec.sys d. Command . com

Ans:6 – c ,6 – c


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


.   What is the term used when a clip art image changes the direction it faces?
Options: a. Group b. Flip c. Rotate d. a and b

Ans:2 – D ,2 – D


In a step-down transformer, which is larger?
Options: Primary voltage,    Secondary voltage,    Neither,    Impossible to say

Ans:A ,A


In which of the following technologies is the term HFC used?
Options: DSL,    PPPoE,    Frame Relay,    Dedicated T1

Ans:D ,D


1. What is contained in the page table?
Options: a. Base address of each frame and corresponding page number b. Memory address and corresponding page number c. File name and corresponding page number d. None of Above

Ans:1 – a ,1 – a


. Which of the following file pattern encompasses the filenames having second character b ?
Options: a. *b??????.txt b. ?b******.txt c. 2b*.txt d. ?b*.txt

Ans:2 – d ,2 – 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


. What is ‘Motion Path’ in PowerPoint?
Options: a. A path to move items on a slide b. A path where PowerPoint file saved c. A path where PowerPoint Program installed d. None of above

Ans:9 – A ,9 – A


. Which of the following disk is fixed disk?
Options: A) Hard Disks B) Flash Disks C) Blu-Ray Disks D) DVDs

Ans:A,A


You are working with a network that has the network ID 192.168.10.0 and require nine subsets for your company and the maximum number of hosts. What subnet mask should you use?
Options: 255.255.255.192,    255.255.255.224,    255.255.255.240,    255.255.255.248

Ans:C ,C


Which one of the following phrases best describes residual magnetism?
Options: Magnetism that remains in the core of an electromagnet after the current through the coil is turned off,    The force of attraction between the poles of a permanent and temporary magnetic field,    The amount of magnetic flux that is not confined to the core material of an electromagnet,    The circular magnetic field that surrounds a conductor carrying a current

Ans:A ,A


. Which device can understand difference between data & programs?
Options: A) Input device B) Output device C) Memory D) Microprocessor

Ans:D,D


. .... is the layer of a computer system between the hardware and the user program
Options: a. Operating environment b. Operating system c. System environment d. None of these

Ans: b, b

www.000webhost.com