. What is the correct way to refer the cell A10 on sheet3 from sheet1?


Options: sheet3!A10 B. sheet1!A10 C. Sheet3.A10 D. A10

Ans: – A ,


Description: mcqquestions

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

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


What could cause a fixed disk error.
Options: No-CD installed,    bad ram,    slow processor,    Incorrect CMOS settings

Ans:D ,D


What is the notation for following functions? 1. int f(int a, float b) { /* Some code */ } 2. int f(a, b) int a; float b; { /* Some code */ }
Options: 1. KR Notation 2. ANSI Notation,    1. Pre ANSI C Notation 2. KR Notation,    1. ANSI Notation 2. KR Notation,    1. ANSI Notation 2. Pre ANSI Notation

Ans:C ,C


. which function will calculate the number of workdays between 6/9/2004 and 8/12/2004?
Options: a. Workday b. Date c. Networkdays d. All of the above

Ans:– d,– d


A memory that does not change its contents without external causes is known as
Options: Dynamic memory,    Static memory,    RAM,    EEPROM

Ans:B ,B


When was punched-card equipment used for the first time to process the British census?
Options: 1910,    1907,    1911,    1914

Ans:C ,C


Which of the following hardware components is the most important to the operation of a database management system?
Options: high-resolution video display,    printer,    high speed, large-capacity disk,    plotter

Ans:C ,C


Communication ports are found on the back of microcomputers. They are used to connect the computer to _____
Options: printers,    modems,    other hardware,    All of the above

Ans:D,D


Which was the world's first minicomputer and when was it introduced?
Options: PDP-1, 1958,    1MB System/36, 1960,    PDP-11 1961,    VAX 11/780, 1962

Ans:A ,A


. If you are typing paragraph that is double line spaced and press enter to start new paragraph, the new paragraph will be
Options: a. Quarter space b. Single space c. Half space d. Double space

Ans:2 – d ,2 – d


A factor which would strongly influence a businessperson to adopt a computer is its:
Options: Accuracy,    Reliability,    Speed,    All of the above

Ans:D ,D


Which of the following persons probably has the least amount of technical knowledge?
Options: User,    Computer Operator,    System Analyst,    Programmer

Ans:A ,A


The manager attempts to expedite, or speed up, the flow of
Options: machines,    manpower,    material,    All of the above

Ans:C ,C


The engineering change control system makes changes in the
Options: operations file,    production schedule,    work force data,    All of the above

Ans:A ,A


You can embed a MS-Organization Chart in a slide by
Options: a. Clicking the object command on the edit menu b. Clicking the object command on the edit menu c. Clicking the insert new slide button the standard toolbar, then double click the organization chart button on the formatting toolbar d. Clicking the MS-Organization Chart button on the standard toolbar

Ans: – B , – B


A quotation system obtains potential delivery time data from the
Options: production schedule file,    inventory file,    product catalog file,    All of the above

Ans:B ,B


Direct Numerical Control means:
Options: using several computers to control one large machine,    using one computer to control several machines,    complete elimination of a need for a human operator.,    eliminating computers from the manufacturing process

Ans:B ,B


An Enterprise Resource Planning application is an example of a(n) ________ .
Options: single-user database application,    multiuser database application,    e-commerce database application,    data mining database application

Ans:B ,B


The time taken for the read/write head to move to the correct track on the magnetic disk is called
Options: epoch delay,    latency delay,    seek time,    approach time

Ans:C,C


. Which of the following is the structure of the Database?
Options: a. Table b. Schema c. Relation d. None of these

Ans: – b ,


In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
Options: all columns of the table are to be returned.,    all records meeting the full criteria are to be returned.,    all records with even partial criteria met are to be returned.,    None of the above is correct.

Ans:A ,A


In the relational model, relationships between relations or tables are created by using:
Options: composite keys.,    determinants.,    candidate keys.,    foreign keys.

Ans:D ,D


. LSI, VLSI & ULSI chips were used in which generation?

Options: A) First B) Second C) Third D) Fourth

Ans:D,D


. Microprocessors can be used to make
Options: A) Computer B) Digital systems C) Calculators D) All of the above

Ans:1-D,1-D


. Which command is used to copy system files?
Options: a. Sys b. Command c. MD d. Move

Ans:9 – a ,9 – a


When a router is connected to a Frame Relay WAN link using a serial DTE interface, how is the clock rate determined?
Options: Supplied by the CSU/DSU,    By the far end router,    By the clock rate command,    By the Physical layer bit stream timing

Ans:A ,A


The ALU of a computer responds to the commands coming from
Options: primary memory,    control section,    external memory,    cache memory

Ans:B,B


While working with MS-DOS, which command will you use to transfer a specific file from one disk to another?
Options: COPY,    DISKCOPY,    TIME,    RENAME

Ans:A ,A


Telecommunications networks come in a wide range of speed and capacity capabilities. Select the best fit for answer:
Options: Bandwidth alternatives,    Switching alternating,    Inter organizational networks,    Extranets

Ans:A ,A


Which language is used in the areas of pattern recognition, artificial intelligence & for simulation of games.
Options: APL,    FORTH,    LISP,    CORAL

Ans:C ,C


Which file keeps commands to execute automatically when OS is started?
Options: command.com B. any batch file C. autoexec.bat D. config.sys

Ans:– C ,


In a computer _____ is capable to store single binary bit.
Options: Capacitor B. Flip flop C. Register D. Inductor

Ans:– B ,


Union officials receive the same type of education as
Options: top level managers,    the rank and file employees,    low level managers,    All of the above

Ans:C ,C


. EPROM can be used for
Options: A) Erasing the contents of ROM B) Reconstructing the contents of ROM C) Erasing and reconstructing the contents of ROM D) Duplicating ROM

Ans:C,C


. You have field ‘Sex’ of type Byte Number. How to limit its value to 0 and 1 only?
Options: a. By setting required to ‘Yes’ b. By using default value c. By defining validation rule d. By using format

Ans:– c,– c


Which of the following allows a simple email service and is responsible for moving messages from one mail server to another?
Options: IMAP,    DHCP,    SMTP,    FTP

Ans:C ,C


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

Ans:A ,A


Which of the following software types is used to simplify using systems software?
Options: spreadsheet,    operating environment,    timesharing,    multitasking

Ans:C ,C


To record a sequence of keystrokes and mouse actions to play back later we use:
Options: Media player B. Sound Recorder C. Calculator D. Macro Recorder

Ans:– D ,


The expert system developed at MIT to solve mathematical problems is known as:
Options: RAND,    ISIS,    MACSYMA,    MOLGEN

Ans:C ,C


. When you open my computer on desktop you see the information of
Options: a. Hard disk b. CD c. Removable disk d. All of the above

Ans:0 – d ,0 – d


Inventory lead time can be broken into:
Options: review, order, manufacturing or purchasing and receiving,    order, manufacturing or purchasing, and receiving,    order, receiving,    All of the above

Ans:A ,A


Which of the following statements correct about the below program? #include<stdio.h> int main() { union a { int i; char ch[2]; }; union a u1 = {512}; union a u2 = {0, 2}; return 0; } 1: u2 CANNOT be initialized as shown. 2: u1 can be initialized as shown. 3: To initialize char ch[] of u2 '.' operator should be used. 4: The code causes an error 'Declaration syntax error'
Options: 1, 2,    2, 3,    1, 2, 3,    1, 3, 4

Ans:C ,C


.   The arrangement of elements such as Title and Subtitle text, pictures, tables etis called
Options: a. Layout b. Presentation c. Design d. Scheme

Ans:0 – A ,0 – A


Messages from one computer terminal can be sent to another by using data networks. The message to be sent is converted to an electronic digital signal, transmitted via a cable, telephone or satellite and then converted back again at the receiving end. What is this system of sending messages called?
Options: Paperless office,    Electronic mail,    Global network,    Electronic newspaper

Ans:B ,B


A modern electronic computer is a machine that is meant for
Options: Doing quick mathematical calculations,    Input storage, manipulation of outputting of data,    Electronic data processing,    Performing repetitive tasks accurately

Ans:B ,B


The hardware device Jhat acts as both a switching and connecting unit is called a(n):
Options: concentrator,    RS-232C port,    multiplexer,    communications processor

Ans:C ,C


What are the most likely conditions for ESD?
Options: Hot and dry,    Hot and wet,    Cold and dry,    Cold and wet

Ans:B ,B


. To prevent the addition and deletion of files on a disk or tape we use
Options: a. Format b. Write protect c. Create back up d. None of above

Ans:6 – b ,6 – b


RAM is also known as
Options: Read-only memory,    Programmable read-only memory,    Read/Write memory,    Erasable programmable read-only memory

Ans:C ,C


The first step of the implementation phase is
Options: select the computer,    announce the implementation project,    implementation planning,    prepare physical facilities

Ans:C ,C

www.000webhost.com