Getting data from a cell located in a different sheet is called….


Options: Accessing B. Referencing C. Updating D. Functioning

Ans:– B ,


Description: mcqquestions

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

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


. 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 difference between memory and storages is that memory is _____ and storage is _____
Options: Temporary, permanent,    Permanent, temporary,    Slow, fast,    AH of the above

Ans:A ,A


Which of the following technique is used for fragment?
Options: a technique used in best-effort delivery systems 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:C ,C


What is the name of the computer which was first used for programming and playing of music?
Options: ELLIAC,    ENIAC,    UNIVAC,    All of the above

Ans:A,A


A hybrid computer uses a _____ to convert digital signals from a computer into analog signals.
Options: Modulator,    Demodulator,    Modem,    Decoder

Ans:C,(Canswer


Most current PC CAD systems are used for producing:
Options: solids modeling,    2-D drawings,    circuit simulation,    finite element analysis

Ans:B ,B


You need to configure a router for a Frame Relay connection to a non-Cisco router. Which of the following commands will prepare the WAN interface of the router for this connection?
Options: Router(config-if)#encapsulation frame-relay q933a,    Router(config-if)#encapsulation frame-relay ansi,    Router(config-if)#encapsulation frame-relay ietf,    Router(config-if)#encapsulation frame-relay cisco

Ans:C ,C


A required characteristic of an online real-time system is:
Options: more than one CPU,    offline batch processing,    no delay in processing,    All of the above

Ans:C ,C


In laser technology, what happens during the transfer stage?
Options: Residual toner is transferred to the waste receptacle,    The laser transfers the image from the drum to the paper,    The image is transferred from the drum to the paper,    A negative charge is transferred to the surface of the drum

Ans:C ,C


When used with I/O devices, the term intelligent implies
Options: a color output capability,    speech processing capability,    high speed printing capability,    feature to support offline and online tasks

Ans:D ,D


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

Ans:A ,A


. If the cell B1 contains the formula = $A$1, which of the following statements is true
Options: There is a relative reference to cell A1 B. There is an absolute reference to cell A1 C. Further changes in value of A1 will not affect the value of B1 D. Further changes in value of B1 will affect the value of A1

Ans:– B ,


. What type of device is computer keyboard?
Options: A) Memory B) Output C) Storage D) Input

Ans:D,D


The three key elements for a graphics workstation include the host processor, display controller, and:
Options: mouse,    keyboard,    CRT,    digitizer

Ans:C ,C


A characteristic of card systems is:
Options: slowness in processing data,    using cards as records of transactions,    needing a larger DP staff,    all the above

Ans:D ,D


. When we double click on my computer
Options: a. Show the content of your saved files b. Show the list of your computer drive c. List of deleted files and folders d. All of the above

Ans:0 – b ,0 – b


ODBC core SQL grammar contains which of the following?:
Options: INSERT, UPDATE, DELETE only,    Stored procedures only,    Full SELECT (includes subqueries) only,    Both 1 and 3 above are contained in the ODBC core SQL.

Ans:D ,D


Point out the error in the program #include<stdio.h> int f(int a) { a > 20? return(10): return(20); } int main() { int f(int); int b; b = f(20); printf("%d\n", b); return 0; }
Options: Error: Prototype declaration,    No error,    Error: return statement cannot be used with conditional operators,    None of above

Ans:C ,C


Your customer tells you the print quality of their dot matrix printer is light then dark. Which of the following could cause the problem.
Options: Paper slippage,    Improper ribbon advancement,    Paper thickness,    Head position

Ans:B ,B


. Which of the following command is used to move the pointer from one pane to next pane?
Options: a. F3 b. F4 c. F5 d. F6

Ans:9 – d ,9 – d


The brain of any computer system is
Options: ALU,    Memory,    CPU,    Control unit

Ans:C,(Canswer


As alternatives are evaluated, the best one is recognized as the one
Options: best enabling the system to meet its objectives,    representing lowest cost,    with the most advantages,    with the least disadvantages

Ans:A ,A


One million bytes of information is abbreviated as
Options: Bit,    MB,    KB,    GB

Ans:B ,B


. When integrating Ms-Word and Excel, Word is usually the
Options: a. Server b. Source c. Client d. None

Ans:– c,– c


A semi-continuous operation means:
Options: the operation is continuous each shift, but stops between shifts,    coffee breaks are allowed for the operator,    a computer is a required part of the machine,    each operation in a sequence is continuous, but subsequent operations in the sequence may be different.

Ans:D ,D


When applying a square waveform to a capacitor, the circuit tends to:
Options: peak the voltage and round off the current waveforms,    peak the current and round off the voltage waveforms,    round off both the voltage and current waveforms,    peak both the voltage and current waveforms

Ans:B ,B


What will be the output of the program ? #include<stdio.h> int main() { enum status {pass, fail, absent}; enum status stud1, stud2, stud3; stud1 = pass; stud2 = absent; stud3 = fail; printf("%d %d %d\n", stud1, stud2, stud3); return 0; }
Options: 0, 1, 2,    1, 2, 3,    0, 2, 1,    1, 3, 2

Ans:C ,C


A JSP is transformed into a(n):
Options: Java applet.,    Java servlet.,    Either 1 or 2 above.,    Neither 1 nor 2 above.

Ans:B ,B


. Hard disk is coated in both side with
Options: A) Magnetic metallic oxide B) Optical metallic oxide C) Carbon layer D) All of the above

Ans:5-A,5-A


. Which of the following are word processing software?
Options: a. WordPerfect b. Easy Word c. MS Word d. All of above

Ans:– D,– D


What does Belady’s Anomaly related to?
Options: Page Replacement Algorithm B. Memory Management Algorithm C. Deadlock Prevention Algorithm D. Disk Scheduling Algorithm

Ans:– A ,


. Can you tell what passes into and out from the computer via its ports?
Options: A) Data B) Bytes C) Graphics D) Pictures

Ans:A,A


Which of the following describes the operation of a positive edge-triggered D-type flip-flop?
Options: If both inputs are HIGH, the output will toggle.,    The output will follow the input on the leading edge of the clock.,    When both inputs are LOW, an invalid state exists.,    The input is toggled into the flip-flop on the leading edge of the clock and is passed to the output on the trailing edge of the clock.

Ans:B ,B


You are troubleshooting a connectivity problem in your corporate network and want to isolate the problem. You suspect that a router on the route to an unreachable network is at fault. What IOS user exec command should you issue?
Options: Router> ping,    Router> trace,    Router> show ip route,    Router> show interface

Ans:B ,B


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

Ans:B ,B


Which disk interface standard includes support for up to eight peripheral devices?
Options: ST50G/412,    IDE,    SCSI,    ESDI

Ans:C ,C


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

Ans:C ,C


A 4 KHz noise less channel with one sample ever 125 per sec is used to transmit digital signals. Differential PCM with 4 bit relative signal value is used. Then how many bits per second are actually sent?
Options: 32 Kbps,    64 Kbps,    8 Kbps,    128 Kbps.

Ans:A ,A


Which one of the following statements is true for the voltage in a parallel RL circuit?
Options: The voltage always has the same amplitude and phase for every part of the circuit,    The total voltage is equal to the sum of the voltages across the resistance and inductance,    The total voltage lags the total current by less than 90,    The total voltages is less than the sum of the voltages across the resistance and inductance

Ans:A ,A


What will be the output of the program? #include<stdio.h> int main() { float d=2.25; printf("%e,", d); printf("%f,", d); printf("%g,", d); printf("%lf", d); return 0; }
Options: 2.2, 2.50, 2.50, 2.5,    2.2e, 2.25f, 2.00, 2.25,    2.250000e+000, 2.250000, 2.25, 2.250000,    Error

Ans:C ,C


. In a datasheet, what does each row represent?
Options: a. Record b. Field c. Database d. Table

Ans:– a,– a


The result of a SQL SELECT statement is a(n) ________ .
Options: report,    form,    file,    table

Ans:D ,D


Which program is used to schedule particular jobs or programs at particular times on the system?
Options: vi,    Outlook,    Scheduler,    cron

Ans:D ,D


. What is placed to the left of horizontal scroll bar
Options: a. Tab stop buttons b. View buttons c. Split buttons d. Indicators

Ans:– B,– B


. The acronym of WORM in a Computer System is
Options: Write Only Read Only B. Write Once Read Many C. Write Only Read Memory D. Write Once Read Memory

Ans:– B ,


What are the columns in a Microsoft Access table called?
Options: a. Rows b. Records c. Fields d. Columns

Ans:ndash; c,ndash; c


An example of digital, rather than analog, communication is
Options: DDD,    DDS,    WATS,    DDT

Ans:B ,B


. second generation computers were developed during
Options: A) 1949 to 1955 B) 1956 to 1965 C) 1965 to 1970 D) 1970 to 1990

Ans:8-B,8-B


Which DOS command is used to detect, diagnose and repair logical and physical disk errors on both, uncompressed and Double space compressed drive?
Options: DEFRAG,    DBLSPACE,    SCANDISK,    MSAV

Ans:C ,C


Which command will clear all the translations active on your router?
Options: show ip nat translations,    show ip nat statistics,    debug ip nat,    clear ip nat translations *

Ans:D ,D

www.000webhost.com