. 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: 16668 | 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:


The rms value of a sine waveform is:
Options: the number of cycles completed in one second,    the time required to complete one full cycle,    equal to 0.707 times the peak amplitude,    equal to 1.41 times the peak amplitude

Ans:C ,C


. The key F12 opens a
Options: a. Save As dialog box b. Open dialog box c. Save dialog box d. Close dialog box

Ans:– A,– A


When determining the efficiency of algorithm, the space factor is measured by
Options: A)Counting the maximum memory needed by the algorithm b.Counting the minimum memory needed by the algorithm c.Counting the average memory needed by the algorithm d.Counting the maximum disk space needed by the algorithm

Ans:A,Counting the maximum memory needed by the


What will be the output of the program? #include<stdio.h> int main() { int i; char c; for(i=1; i<=5; i++) { scanf("%c", &c); /* given input is 'b' */ ungetc(c, stdout); printf("%c", c); ungetc(c, stdin); } return 0; }
Options: bbbb,    bbbbb,    b,    Error in ungetc statement.

Ans:C ,C


What is the term used when you press and hold the left mouse key and move the mouse around the slide?
Options: a. Highlighting b. Dragging c. Selecting d. Moving

Ans: – B , – B


. Which feature helps you to inserts the contents of the Clipboard as text without any formatting
Options: Paste Special B. Format Painter C. Page Setup D. Styles

Ans:– A ,


How many times the program will print "IndiaBIX" ? #include<stdio.h> int main() { printf("IndiaBIX"); main(); return 0; }
Options: Infinite times,    32767 times,    65535 times,    Till stack overflows

Ans:D ,D


A small film-plate which is used for microfilming the output from a microcomputer screen is called
Options: microfilm,    microfiche,    film card,    COM

Ans:B ,B


Which of the following disallows both dirty reads and nonrepeatable reads, but allows phantom reads?
Options: Read committed,    Read uncommitted,    Repeatable read,    Serializable

Ans:C ,C


Declare the following statement? "An array of three pointers to chars".
Options: char *ptr[3]();,    char *ptr[3];,    char (*ptr[3])();,    char **ptr[3];

Ans:B ,B


A magnetic storage device on which data is stored on a cylindrical drum, subdivided into tracks is known as
Options: Punched card,    Magnetic disk,    Magnetic tape,    Drum

Ans:D ,D


Which is the acronym for Algol extended for design.
Options: AFIPS,    ADP,    AED,    CAI

Ans:C ,C


What of the following tool is used to check and repair Linux file systems?
Options: mkfs,    fdisk,    fsck,    mount

Ans:C ,C


When mapping a binary many-to-many relationship into a relation which of the following is true?
Options: One relation is created.,    Two relations are created.,    Three relations are created.,    Four relations are created.

Ans:C ,C


28. What do you call ‘a collection of character and paragraph formatting commands’?
Options: a. the defaults b. a template c. a style d. a boilerplate

Ans:–  C ,–  C


You have a 15 pin female connector with the pins in two rows. What could you connect with this?
Options: Serial device,    Parallel device,    MIDI device,    Joystick

Ans:Joystick,D


A database management system based on the concept of ownership is
Options: Network topology,    Network layer,    Network database system,    Network license system

Ans:C ,C


. The Name box on to the left of formula bar
Options: a.  shows the name of workbook currently working on b.  shows the name of worksheet currently working on c.  shows the name of cell or range currently working on d.  None of above

Ans:– c,– c


Which of the following is the fastest?
Options: CPU,    magnetic tapes and disks,    video terminal,    sensors, mechanical controllers

Ans:A ,A


. Which of the following statements regarding charts is incorrect?
Options: a. It can be inserted into a form only. b. It can be designed as a stand-alone object. c. It can be linked to the object in which it is placed. d. It is a control linked to a data source.

Ans:– a,– a


Which of the following is not the part of standard office suite?
Options:  A) Word Processor, B) Database, C) Image Editor, D) File manager, 

Ans:-D,-D


From which menu you can access Picture, Test Box, Chart etc?
Options: a. File b. Edit c. Insert d. View

Ans: – C , – C


How many tables may be included with a join?
Options: One,    Two,    Three,    All of the above.

Ans:D ,D


. In order to play and hear sound on a computer, one needs:

Options: A) a sound card and speakers B) a microphone C) all of them required D) none of them required

Ans:A,A


Which of the following function key activates the speller?
Options:  A) F5, B) F7, C) F9, D) Shift + F7,

Ans:-B,-B


Which enables us to send the same letter to different persons?
Options: a. macros b. template c. mail merge d. none

Ans:–  C,–  C


. Which of the following database object produces the final result to present?
Options: a. Forms b. Reports c. Queries d. Tables

Ans:5 – b ,5 – b


What is the port number for HTTP?
Options: 99,    86,    80,    23

Ans:C ,C


. The ....is the drive containing the files to be copied
Options: a. Source drive b. Destination drive c. USB drive d. None of the above

Ans: a, a


Which EIGRP information is held in RAM and maintained through the use of Hello and update packets? Neighbor table STP table Topology table DUAL table
Options: 2 only,    4 only,    1 and 3,    All of the above

Ans:C ,C


The complete picture of data stored in database is known as
Options: Record,    Schema,    System flowchart,    DBMS

Ans:B ,B


To edit in an embedded excel worksheet object in a word document
Options: a. Use the excel menu bar and toolbars inside the word application b. Edit the hyperlink c. Edit the data in a excel source application d. Use the word menu bar and toolbars

Ans:#8211; a,#8211; a


The Turnaround is
Options: the elapsed time between the receipt of the input and the availability of the output,    a group of related fields,    the key information of programming,    a program statement that violates one or more rules of the language in which it is written

Ans:A ,A


What happens if you mark on Hidden check box of Font dialog box after you select some text?
Options:  A) The text is deleted from document and you need to bring from Recycle Bin if required again., B) The text is hidden and you need to bring it by removing the check box if needed again, C) The text is deleted and cannot be returned back, D) The text is hidden and cannot be returned back,

Ans:-B,-B


What command is used to list contents of directories?
Options: tar,    dir,    lp,    ls

Ans:D ,D


. Presentation designs regulate the formatting and layout for the slide and are commonly called
Options: a. Design templates b. Templates c. Placeholders d. Blueprints

Ans:4 – B ,4 – B


The working set theory of programming behaviour of processes running within an operating system involves
Options: the collection of pages that a process accesses,    disk scheduling mechanisms,    coalescing holes in memory,    assigning the CPU to processes

Ans:A ,A


Multiplication of 1112 by 1012 is
Options: 1100112,    1000112,    1111002,    0001012

Ans:B ,B


Linked lists are best suited
Options: A)for relatively permanent collections of data b.for the size of the structure and the data in the structure are constantly changing c.for both of above situation d.for none of above situation

Ans:B, For the size of the structure and the data in the structure are constantly changing


What is the standard protocol for network management features?
Options: SNA,    FTP,    SNMP,    SMS

Ans:C ,C


In which circumstance are multiple copies of the same unicast frame likely to be transmitted in a switched LAN?
Options: During high-traffic periods,    After broken links are reestablished,    When upper-layer protocols require high reliability,    In an improperly implemented redundant topology

Ans:D ,D


An unloaded zener regulator has a source voltage of 20 V, a series resistance of 330 W, and a zener voltage of 12 V, What is the Zener current?
Options: 28.4 mA,    24.2 mA,    34.4 mA,    68.4 mA

Ans:B ,B


The DROP TABLE statement:
Options: deletes the table structure only.,    deletes the table structure along with the table data.,    works whether or not referential integrity constraints would be violated.,    is not an SQL statement.

Ans:B ,B


The model for a record management system might be
Options: handwritten list,    a Rolodex card file,    a business form,    All of the above

Ans:D ,D


The 2's complement of a binary no. is obtained by adding.....to its 1's complement.
Options: 0 ,    1,    10,    12

Ans:B,(Banswer


RAM is used as a short memory because it is
Options: Volatile,    Has small capacity,    Is very expensive,    Is programmable

Ans:A ,A


If the ASCII character G is sent and the character D is received, what type of error is this?
Options: single-bit,    multiple-bit,    burst,    recoverable

Ans:C ,C


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 ,


A float occupies 4 bytes. If the hexadecimal equivalent of these 4 bytes are A, B, C and D, then when this float is stored in memory in which of the following order do these bytes gets stored?
Options: ABCD,    DCBA,    0xABCD,    Depends on big endian or little endian architecture

Ans:D ,D


Which of the following is not an output device of a computer?
Options: Printer,    keyboard,    VDU,    CRT screen

Ans:B ,B

www.000webhost.com