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: 14066 | 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:

Which of the following printers, are you sure will not to use if your objective is to print on multicarbon forms?
Options: daisy wheel,    dot-matrix,    laser,    thimble

Ans:C ,C

  Which option can be used to create a new slide show with the current slides but presented in a different order?
Options: Rehearsal B. Custom Slide show C. Slide Show Setup D. Slide Show View

Ans:– B ,

Which of the following capabilities is required for a system program to execute more than one program at a time?
Options: word processing,    compiling,    virtual memory,    multitasking

Ans:D ,D

Each data item in a record may be a group item composed of sub-items; those items which are indecomposable are called
Options: a. elementary items b. atoms c. scalars d. all of above

Ans: d, d

You can have EISA and MCA devices in the same PC.
Options: True,    False,    ,    

Ans:B ,B

. Which of the following is not an option of the spelling dialog box?
Options: a. Ignore b. Ignore all c. Edit d. Change

Ans:– c,– c

19. Which command displays the list of all previous commands entered by the used?

Ans:Correct Answer: C,Correct Answer: C

A computer consists of
Options: A) A central processing unit B) A memory C) Input and output unit D) All of the above


A factor which might cause an individual to consider using a computer in criminal activities is:
Options: The computer's access to large sums of money,    The speed with which the crime can be accomplished,    EFTS (Electronic Funds Transfer System),    All the above

Ans:D ,D

When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
Options: LIKE only.,    IN only.,    NOT IN only.,    Both IN and NOT IN.

Ans:D ,D

What will be the output of the program ? #include<stdio.h> int main() { union var { int a, b; }; union var v; v.a=10; v.b=20; printf("%d\n", v.a); return 0; }
Options: 10,    20,    30,    0

Ans:B ,B

. The programs which are as permanent as hardware and stored in ROM is known as
Options: A) Hardware B) Software C) Firmware D) ROM ware


Which of the following is used for input and output both
Options: Graph plotter,    Teletype terminal,    Line printer,    All of the above

Ans:B ,B

Bit map terminal
Options: support displays containing multiple windows,    requires considerable amount of video RAM,    requires tremendous amount of copying and hence low performance,    All of the above

Ans:D ,D

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

. MICR stands for
Options: A) Magnetic Ink Character Reader B) Magnetic Ink Code Reader C) Magnetic Ink Cases Reader D) None


Probabilities range from
Options: .00 to .1,    .00 to 1.00,    00 to 100,    All of the above

Ans:B ,B

. The three parts of an IIF function are separated by _____.
Options: a. dashes b. asterisks c. semicolons d. commas

Ans:8 – d ,8 – d

An intelligent robot can:
Options: make decisions,    handle only small payloads,    walk,    speak

Ans:A ,A

The highest level in the hierarchy of data organization is called
Options: a. data bank b. data base c. data file d. data record


Which of the following FRUs would be considered both an input/output device?
Options: Video board,    SCSI host adapter,    System board CPU,    All of the above

Ans:B ,B

The first microprocessor built by the Intel Corpn. was called
Options: 8008,    8080,    4004,    8800


. Queries in access can be used as
Options: a. View, change and analyze data in different ways b. A source of records for forms and reports c. Only a d. Both a and b

Ans:4 – d ,4 – d

A self check digit is useful in detecting
Options: transcription errors only,    transposition errors only,    Random errors only,    All of the above

Ans:D ,D

The transport layer protocol is connectionless.
Options: NVT,    FTP,    TCP,    UDP

Ans:D ,D

The methods used by COBOL to define that structure of a data item in terms of characters, digits, etc. is
Options: Password,    Pointer,    Picture,    Overlay

Ans:C ,C

What command is used to display the top of the file?
Options: grep,    more,    head,    cat

Ans:C ,C

The first set of the three permissions (rw) pertains to the owner of the file, indicating that the owner has
Options: executable permission only,    write and executable permissions,    both read and executable permissions.,    both read and write permissions

Ans:D ,D

The formula for memory capacity is:
Options: MC = N/2,    MC = 2/N,    MC = N squared.,    MC -2 to the Nth power

Ans:D ,D

Data structuring is refined through a process called
Options: structuring process,    hierarchical structure,    normalization,    Relation structure

Ans:C ,C

Concatenation of text can be done using
Options: a. Apostrophe ,b. Exclamation, c. Hash , d. Ampersand


What is the keyboard shortcut for creating a chart from the selected cell range?
Options: A. F2 B. F4 C. F8 D. F11

Ans:– D ,F11

. To delete records or perform calculations on a table, the best tool to use is a __________.
Options: a. query b. filter c. form d. report

Ans:0 – a ,0 – a

What will be the output of the program? #include<stdio.h> int main() { float f=43.20; printf("%e, ", f); printf("%f, ", f); printf("%g", f); return 0; }
Options: 4.320000e+01, 43.200001, 43.2,    4.3, 43.22, 43.21,    4.3e, 43.20f, 43.00,    Error

Ans:A ,A

A heterogeneous distributed database is which of the following?
Options: The same DBMS is used at each location and data are not distributed across all nodes.,    The same DBMS is used at each location and data are distributed across all nodes.,    A different DBMS is used at each location and data are not distributed across all nodes.,    A different DBMS is used at each location and data are distributed across all nodes.

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

A high-pass filter:
Options: passes lower-frequency signals and reduces higher-frequency signals,    passes higher-frequency signals and reduces lower-frequency signals,    has no effect on ac signals,    increases the level of all frequencies by a significant amount

Ans:B ,B

. All of the following are task performed by the operating system except
Options: a. Managing hardware on the computer b. Controlling the access that application program has to the CPU c. Performing housekeeping task like file compression and disk defragmentation d. Provides an interface for user to interact with computer

Ans:1 – c ,1 – c

Number cruncher is the informal name for
Options: Mini computer,    Super computer,    Micro computer,    Mainframe computer

Ans:B ,B

What is bytecode?
Options: Machine-specific code,    Java code,    Machine-independent code,    None of the above is correct.

Ans:C ,C

The name box
Options: a. Shows the location of the previously active cell b. Appears to the left of the formula bar c. Appears below the status bar d. Appears below the menu bar

Ans:#8211; b,#8211; b

The silicon chips used for data processing are called
Options: RAM chips,    ROM chips,    Micro processor,    PROM chips

Ans:C ,C

What is the name given to the organized collection of software that controls the overall operation of a computer?
Options: Working system,    Peripheral system,    Operating system,    Controlling system

Ans:C ,C

. It was in 2028 BS the _________ was brought in to calculate census data.
Options: A) IBM 1400 B) IBM 1401 C) ICL 2950 D) None of above


60. You need to jump to the next column breaking current column right at the cursor position. How can you break column?
Options: a. Pressing Ctrl+Enter b. Pressing Alt+Shift+Enter c. Break command from Insert menu d. Both b and c

Ans:– C ,– C

A central purpose of most decision-support systems is
Options: to build a model of the decision¬making problem,    to design a data-base manage¬ment system,    to build an expert system,    to determine the key decisions in the problem area

Ans:A ,A

Symbolic languages were developed in
Options: 1962,    1950,    1974,    1980


When using ODBC, which of the following processes ODBC requests and submits specific SQL statements to a given type of data source?
Options: Data source,    Driver,    Driver manager,    DBMS

Ans:B ,B

The simultaneous transmission of data to a number of stations is known as
Options: broadcast,    Band width,    Aloha,    Analog transmission

Ans:A ,A

Which command would you use to apply an access list to a router interface?
Options: ip access-list 101 out,    access-list ip 101 in,    ip access-group 101 in,    access-group ip 101 in

Ans:C ,C