In the formula, which symbol specifies the fixed columns or rows?


Options: $ B. * C. % D. &

Ans:– A ,


Description: mcqquestions

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

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


What scheduling algorithm allows processes that are logical runnable to be temporarily suspended?
Options: preemptive scheduling,    non-preemptive scheduling,    FIFO,    FCFS

Ans:A ,A


A communications medium that uses pulses of laser light in glass fibers. Select the best fit for answer:
Options: Fiber optic cables,    Cellular phone systems,    Telecommunications processors,    Telecommunications software

Ans:A ,A


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


A device that converts chemical energy to electrical energy is called a:
Options: solar cell,    thermocouple,    chemical cell,    electric device

Ans:C ,C


Which of the following, is necessary to work on a computer
Options: Compiler,    Operating system,    Assembly,    Interpreter of the above

Ans:B ,B


The difference between a multiplexer and a statistical multiplexer is
Options: Statistical multiplexers need buffers while multiplexers do not need buffers,    Multiplexer use X.25 protocol, while statistical multiplexers use the Aloha protocol,    Multiplexers often waste the output link capacity while statistical multiplexers optimize its use,    Multiplexers use Time Division Multiplexing (TDM) while statistical multiplexers use Frequency Division Multiplexing (FDM)

Ans:A ,A


A small square or rectangular piece of silica on which several layers of an integrated circuit are etched or imprinted is called
Options: VLSI,    micro,    wafer,    chip

Ans:D ,D


. The octal equivalence of 111010 is
Options: A) 81 B) 72 C) 71 D) None of above

Ans:6-B,6-B


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

Ans:D ,D


Which of the following command options are displayed when you use the Router# show frame-relay ? command? dlci neighbors lmi pvc map
Options: 1 only,    2 and 4,    3, 4 and 5,    All of the above

Ans:C ,C


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


  To print the PowerPoint presentation, press
Options: Ctrl + T B. Ctrl + E C. Ctrl + S D. Ctrl + P

Ans:– D ,


In this world of fast changing computer technology, one of the most important factor to be considered while purchasing a PC is, it should have a provision for
Options: high level integration,    self upgradability,    intelligent sensors,    faster data access

Ans:B ,B


The barrier potential accross each depletion layer is
Options: 0,    0.8 V,    0.7 V,    20 V

Ans:C ,C


Algorithm and Flow chart help us to
Options: Know the memory capacity B. Identify the base of a number system C. Direct the output to a printer D. Specify the problem completely and clearly

Ans:– D ,


Both conditions display on the same row in the design grid when ___operator is in use
Options: a. OR b. IN c. AND d. LIKE

Ans:ndash; c,ndash; c


Acceptance testing is
Options: running the system with line data by the actual user,    making sure that the new programs do in fact process certain transactions according to Specifications,    is checking the logic of one or more programs in the candidate systems,    testing changes made in an existing or a new program

Ans:A ,A


What is the name given to the exchange of control signals which is necessary for establishing a connection between a modem and a computer at one end of a line and another modem and computer at the other end?
Options: Handshaking,    Modem options,    Protocol,    Duplexing

Ans:A ,A


What is (void*)0?
Options: Representation of NULL pointer,    Representation of void pointer,    Error,    None of above

Ans:A ,A


Storage capacity of magnetic disk depends on
Options: A) tracks per inch of surface B) bits per inch of tracks C) disk pack in disk surface D) All of above

Ans:D,D


What command is used to count just the number of characters in a file?
Options: wc - r,    wc - w,    wc - c,    wc - 1

Ans:C ,C


To _____ is to decide in advance on a course of action.
Options: master,    decision,    plan,    control

Ans:C ,C


. Slides can have
Options: a. title, text, graphs b. drawn objects, shapes c. clipart, drawn art, visual d. any of the above

Ans:9 – D ,9 – D


A feature of MS Word that saves the document automatically after certain interval is available on
Options:  A) Save tab on Options dialog box, B) Save As dialog box, C) Both of above, D) None of above, 

Ans:-A,-A


What are two purposes for segmentation with a bridge? To add more broadcast domains. To create more collision domains. To add more bandwidth for users. To allow more broadcasts for users.
Options: 1 only,    2 and 3,    2 and 4,    4 only

Ans:B ,B


Which one of the following phrases most accurately describes a purely inductive circuit?
Options: Resistances provide the only opposition to current flow,    Inductive reactance provides the only opposition to current flow,    Combinations of resistance and inductive reactance provide any opposition to current flow,    The ac voltage lags the current by 90 degree

Ans:B ,B


. A spooler is a
Options: a. Location in memory that maintains the contents of documents until it prints out b. Queue of print job that are waiting to print c. Program that coordinates the print job that are waiting to process d. Message sent from the printer to the operating system when a print job is completed

Ans:1 – c ,1 – c


Convert the CHARI h#000F, s assembly language instructions into hexadecimal machine language:
Options: 0111EF,    9001E6,    DA000F,    40

Ans:C ,C


When a host knows its physical address but not its IP address, it can use _____.
Options: RARP,    ARP,    IGMP,    ICMP

Ans:A ,A


Which of the following is not a characteristic of a daisy chaining priority control scheme?
Options: priority is programmable,    it is relatively easy to add more devices to the chain,    the failure of one device may affect other devices on the chain,    the number of control lines is independent of the number of devices on the chain

Ans:A ,A


External data is stored in the
Options: market forecast file,    forecast allocation file,    customer file,    All of the above

Ans:A ,A


. The _____ function returns a string that has been converted to uppercase text.
Options: a. AllCap b. UCase c. UpCase d. Upper

Ans:2 – b ,2 – b


Database management systems are intended to:
Options: eliminate data redundancy,    establish relationships among records in different files,    manage file access,    maintain data integrity

Ans:E ,E


Which of the following is not used as secondary storage
Options: Semiconductor memory,    Magnetic disks,    Magnetic drums,    Magnetic tapes

Ans:A ,A


What command is used with vi editor to delete three words?
Options: 3$d,    3 dw,    3 x,    3 dd

Ans:B ,B


The primary memory of a personal computer consists of:
Options: ROM only,    RAM only,    Both ROM and RAM,    Memory module

Ans:C ,C


. What is a portion of a document in which you set certain page formatting options?
Options: a. Page b. Document c. Section d. Page Setup

Ans:– C,– C


What will be the output of the program (sample.c) given below if it is executed from the command line? cmd> sample 1 2 3 cmd> sample 2 2 3 cmd> sample 3 2 3 /* sample.c */ #include<stdio.h> int main(int argc, char *argv[]) { printf("%s\n", argv[0]); return 0; }
Options: sample 3 2 3,    sample 1 2 3,    sample,    Error

Ans:C ,C


Accessing records from a file directly without searching from the beginning of the file is
Options: Time sharing,    Random,    Direct access,    Access time

Ans:C ,C


Which of the following operations can be performed on the file "NOTES.TXT" using the below code? FILE *fp; fp = fopen("NOTES.TXT", "r+");
Options: Reading,    Writing,    Appending,    Read and Write

Ans:D ,D


. For which of the following computers can’t be used?

Options: A) gathering data B) calculating data C) comparing data D) Arranging data

Ans:A,A


ICMP (Internet Control Message Protocol) is
Options: a TCP/IP protocol used to dynamically bind a high level IP Address to a low-level physical hardware address,    a TCP/IP high level protocol for transferring files from one machine to another,    a protocol used to monitor computers,    a protocol that handles error and control messages

Ans:D ,D


Underlined character on the menu or dialog box known as
Options: a. Hot spot, b. Hot key, c. Pane, d. Underline word

Ans:b,Hot key


. The command to display the contents of a file fast.it
Options: a. TYPE it fast b. COPY fast.it CON c. COPY CON fast.it d. None of above

Ans:3 – c ,3 – c


Which of the following best describes the scopes on each DHCP server, in the absence of configuration problems with DHCP addresses, if you use multiple DHCP servers in your environment?
Options: Unique to that subnet only,    For different subnets,    For no more than two subnets,    For no subnets

Ans:B ,B


In analyzing the compilation of PL/I program, the description "resolving symbolic address (labels) and generating machine language" is associated with
Options: Assembly and output,    Code generation,    Storage assignment,    Syntax analysis

Ans:A ,A


The physical system of the firm may be regarded as a flow of
Options: manpower, machines, material, and money,    information only,    manpower, machines, material, money, and information,    manpower, machines, material, money, and data

Ans:A ,A


The physical layer of a network
Options: constructs packets of data and sends them across the network,    controls error detection and correction,    defines the electrical characteristics of signals passed between the computer and communication devices,    All of the above

Ans:C ,C


The earliest calculating devices are
Options: Abacus B. Clock C. Difference Engine D. None of these

Ans:– A ,


Which of the following command lists the last 10 lines of a file?
Options: grep,    tail,    head,    cat

Ans:B ,B

www.000webhost.com