Give me an example of a cell address.


Options: 11 25 B. 911 C. 41A D. A21

Ans:– D ,


Description: mcqquestions

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

Hits Today: 5941 | 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 to create additional Guide Lines?
Options: by holding Ctrl key, click on existing Guide Line and drag B. by holding Alt key, click on existing Guide Line and drag C. by holding Ctrl + Alt key, click on existing Guide Line and drag D. Additional Guide Lines cannot be created

Ans:– A ,


. The shortcut key to open a task manager is:
Options: a. Alt + F1 b. Alt + Ctrl + Delete c. Alt + Tab d. F1

Ans:0 – b ,0 – b


. Which was the world’s first minicomputer and when was it introduced?
Options: A) PDP-I, 1958 B) IBM System/36, 1960 C) PDP-II, 1961 D) VAX 11/780, 1962

Ans:A,A


PowerPoint Application allows you to produce
Options: Animated Presentations B. Paper Printouts of Slides C. Notes for the Speaker D. All of the above.

Ans:– D ,


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


NOT, AND, OR and XOR are
Options: Logical Operators B. Arithmetic operators C. Relational operators D. None of the above

Ans:– A ,


Which command of DOS is used to compare two floppy disks?
Options: DISKCOPY,    DISKCOMP,    DISKCOPY A: B/V,    FORMAT A: B:

Ans:B ,B


ISDN uses _____ technology.
Options: only digital,    digital and analog,    only analog,    neither digital nor analog

Ans:A ,A


What file contains commands that configure systems devices?
Options: Command.com,    Config.sys,    Autoexec.bat,    Win.ini

Ans:B ,B


What is a common language that computers use to talk with one another on a network
Options: client,    adapter,    protocol,    operating systems

Ans:C ,C


The equipment with which the computer talks to its users is called a
Options: word processor,    peripheral,    software,    diskette

Ans:B,B


Which of the following is true concerning the mainframe?
Options: It is the same thing as client/server.,    Requires someone to decide which code should be on the workstation or the server.,    Mission-critical systems have tended to remain there.,    All of the above.

Ans:C ,C


To add a header or footer to your handout, you can use
Options: a. The title master b. The slide master c. The handout master d. All of above

Ans: – C , – C


MAC is
Options: a method of determining which device has access to the transmission medium at any time,    a method access control technique or multiple-access transmission media,    a very common bit-oriented data link protocol issued to ISO.,    network access standard for connecting stations to a circuit-switched network

Ans:A ,A


Where can you change the vertical alignment?
Options:  A) Formatting toolbar, B) Paragraph dialog box, C) Page Setup dialog box, D) Standard toolbar,

Ans:-C,-C


What is the maximum number of IP addresses that can be assigned to hosts on a local subnet that uses the 255.255.255.224 subnet mask?
Options: 14,    15,    16,    30

Ans:D ,D


. Which of the following storage device can store the largest amount of data?
Options: A) Hard Disks B) Flash Disks C) Blu-Ray Disks D) DVDs

Ans:8-A,8-A


The component of an ICAI (Intelligent Computer-Asslsted Instruction) presenting information to the student is the:
Options: student model,    problem-solving expertise,    tutoring module,    All of the above

Ans:C ,C


An oval represents which of the following in an EER?
Options: Attribute,    Entity,    Optional One,    Relationship

Ans:A ,A


On PC power supplies, the wire attached to pin one is usually:
Options: blue or red,    blue or white,    red or black,   white or orange

Ans:white or orange,D


. Internet Explorer is
Options: a. an Internet browser b. provided by Windows OS c. an access point for Word Wide Web d. All of above

Ans:7 – d ,7 – d


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

Ans: – C , – C


The application layer of a network
Options: establishes, maintains, and terminates virtual circuits,    defines the user's port into the network,    consists of software being run on the computer connected to the network,    All of the above

Ans:C ,C


As compared to diskettes, the hard disks are
Options: more expensive,    more portable,    less rigid,    slowly accessed

Ans:A,A


Press _____ to create a line break, which advances the insertion point to the beginning of the next physical line – ignoring any paragraph formatting instructions.
Options: a. shift+enter b. ctrl+enter c. shift+tab d. ctrl+tab

Ans:– a,– a


. Which of the following parameters decided the performance of the memory?
Options: Latency B. Cycle time C. Transfer rate D. All of the above

Ans:– D ,


What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?
Options: Full backup,    Consistent backup,    Inconsistent backup,    Differential backup

Ans:B ,B


. What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
Options: a. An absolute cell address is created. b. Cell address will change when it is copied to another cell. c. The sheet tab is changed. d. The status bar does not display the cell address.

Ans:– a,– a


The Software which contains rows and columns is called ______
Options: Database B. Drawing C. Spreadsheet D. Word processing

Ans:– C ,


A common use of computer in office is for
Options: Distributed,    Word processing,    Data,    All of the above

Ans:B ,B


Fragmentation of the file system
Options: occurs only if the file system is used improperly,    can always be prevented,    can be temporarily removed by compaction,    is a characteristic of all file systems

Ans:C ,C


What command will display the line, protocol, DLCI, and LMI information of an interface?
Options: sh pvc,    show interface,    show frame-relay pvc,    show run

Ans:B ,B


61. In Word you can force a page break
Options: a. By positioning your cursor at the appropriate place and pressing the F1 key b. By using the Insert/Section break on the Insert tab c. By positioning your cursor at the appropriate place and pressing Ctrl+Enter d. By changing the font size of your document

Ans:– C ,– C


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


In communication satellite, multiple repeaters are known as
Options: detector,    modulator,    stations,    transponders

Ans:D ,D


. The first general purpose electronic digital computer in the world was
Options: A) UNIVAC B) EDVAC C) ENIAC D) All of above

Ans:C,C


Which command is used to change directory to the name beginning with a 'p'?
Options: cd p,    cd p?,    cd p*,    cd [p]

Ans:C ,C


The digital multimeter is set for DC, Ohm and 20k. You will read _____ while measuring a good 2 amp fuse.
Options: 0.00,    0.02,    0.20,    2.00

Ans:A ,A


A computer has a 1024K memory. What does the letter K stand for
Options: Kilometre,    Thousand,    1024,    MB

Ans:C,C


How many non-overlapping channels are available with 802.11b?
Options: 3,    12,    23,    40

Ans:A ,A


SQL views can be used to hide:
Options: columns and rows only.,    complicated SQL syntax only.,    both of the above can be hidden by an SQL view.,    None of the above is correct.

Ans:C ,C


When did IBM close the last of its punched card manufacturing plant?
Options: June, 1989,    December, 1984,    March, 1982,    November, 1979

Ans:B,B


. UNIVAC is
Options: A) Universal Automatic Computer B) Universal Array Computer C) Unique Automatic Computer D) Unvalued Automatic Computer

Ans:A,A


Which of the following are the two main components of the CPU?
Options: control unit and registers,    registers and main memory,    control unit and ALU,    ALU and bus

Ans:C,C


A standards manual specifies standards that are to be followed in
Options: system design,    system operation,    both (a) and (b),    neither (a) nor (b)

Ans:C ,C


Which of the following is not a relational database?
Options: dBASE IV,    4th Dimension,    FoxPro,    Reflex

Ans:D ,D


In LISP, the function (copy-list <list>)
Options: returns a new list that is equal to <list> by copying the top-level element of <list>,    returns the length of <list>,    returns t if <list> is empty.,    All of the above

Ans:A ,A


Which of the following is a function of the process step of data processing?
Options: protect,    index,    retrieval,    update

Ans:C ,C


.Each array declaration need not give, implicitly or explicitly, the information about
Options: A)the name of array b.the data type of array c.the first data from the set to be stored d.the index set of the array

Ans:C,C


. Which of the following does not occur during the power-on-self-test (POST)?
Options: a. The scandisk utility begins to run b. The video card and video memory are tested c. The BIOS identification process occurs d. Memory chipare checked to ensure that they are working properly

Ans: a, a

www.000webhost.com