What is represented by the small, black square in the lower-right corner of an active cell or range?


Options: Copy handle B. Fill handle C. Insert handle D. Border

Ans:– B ,


Description: mcqquestions

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

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


The workspace required for a robot:
Options: is less than that of a human performing the same task,    depends upon the robot used,    is not dependent on the application.,    must be enclosed by a fence

Ans:B ,B


A _____ DBMS distributes data processing tasks between the workstation and a network server.
Options: Network,    Relational,    Client Server,    Hierarchical

Ans:C ,C


Which is the Shortcut key to start a presentation from the beginning?
Options: A. F5 B. ALT + F5 C. CTRL + F5 D. SHIFT + F5

Ans:– A ,F5


In his landmark book Cybernetics, Norbert Wiener suggested a way of modeling scientific phenomena using not energy, but:
Options: mathematics,    intelligence,    information,    history

Ans:C ,C


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


One approach to standardization storing of data?
Options: a. MIS b. structured programming c. CODASYL specification d. none of the above

Ans:.c,.c


When assessing the table structure of an acquired set of tables with data, counting the number of table rows is (part of) the:
Options: first step.,    second step.,    third step.,    fourth step.

Ans:A ,A


. SQL stands for __________.
Options: a. Standard Query Language b. Structured Query Language c. Simplified Query Language d. Static Query Language

Ans:5 – b ,5 – b


. All Computers (Mainframe, Mini or Micro) must have
Options: ALU B. Control Unit C. Primary Storage D. All of above

Ans:– D ,


A thermistor:
Options: is a pressure sensing device,    has a voltage output,    measures temperature,    All of the above

Ans:C ,C


Which of the following is not a font style?
Options: a. Bold b. Italics c. Regular d. Superscript

Ans:– D,– D


A drum timer is a good example of:
Options: an output actuator,    an input sensor,    a position sensor,    a sequence controller

Ans:D ,D


In which addressing mode, the effective address of the operand is generated by adding a constant value to the contents of register?
Options: absolute mode,    indirect mode,    immediate mode,    index mode

Ans:D ,D


If a piece of data is stored in two places in the database, then 
Options: a . storage space is wasted b . changing the data in one spot will cause data inconsistency c . in can be more easily accessed d . both and b

Ans:.d,.d


An error in computer data is called
Options: Chip,    Bug,    CPU,    Storage devices

Ans:B ,B


Instructions and memory address are represented by
Options: A) Character code B) Binary codes C) Binary word D) Parity bit

Ans:-B,-B


What is the shortcut key to “Insert Hyperlink ” in a document?
Options: Ctrl + H B. Ctrl + L C. Ctrl + K D. None of above

Ans:– C ,


_____ is the use of a model in an attempt to identify and/or reflect the behaviour of a real person, process, or system.
Options: master,    decision,    plan,    simulation

Ans:D ,D


. Which is not the one of view options provided by PowerPoint to look at and modify presentation?
Options: a. Slide Show b. Format Slide c. Slide Sorter d. Normal

Ans:2 – B ,2 – B


Who is considered the 'father' of the minicomputer and one of the founder fathers of the modern computer industry world-wide?
Options: George Tate,    Kenneth H. Olsen,    Seymour Cray,    Basic Pascal

Ans:B ,B


Several objectives are required to achieve a successful data base management program. These are availability of data, quality of data, and
Options: compatibility of data,    transmission of data,    desirability of data,    up-to-date data

Ans:D ,D


_____________ refers to the correctness and completeness of the data in a database?
Options: Data security B. Data integrity C. Data constraint D. Data independence

Ans:– B ,


  Who is credited for using punch cards to control patterns of a weaving machine?
Options:  Blaise Pascal B.  Herman Hollerith         C.  Jacquard D.  Charles Babbage

Ans:– C ,


Which short cut key inserts a new slide in current presentation?
Options: a. Ctrl+N b. Ctrl+M c. Ctrl+S d. All of above

Ans: – B , – B


Which of the following is private IP address?
Options: 12.0.0.1,    168.172.19.39,    172.15.14.36,    192.168.24.43

Ans:D ,D


Which of the following terminals' output most closely resembles the output produced by a plotter?
Options: graphics terminal,    POS terminal,    hardcopy terminal,    all the above

Ans:A ,A


The structure chart is:
Options: a document of what has to be accomplished,    a hierarchical partitioning of the program,    a statement of information-processing requirements,    All of the above

Ans:B ,B


During the planning phase, the main activity of the vice-president of information systems is one of
Options: planning,    control,    staffing,    support

Ans:D ,D


Part of a program where the shared memory is accessed and which should be executed invisibly, is called
Options: semaphores,    directory,    critical section,    mutual exclusion

Ans:C ,C


  Ellipse Motion is a predefined ________
Options: Design Template B. Color Scheme C. Animation Scheme D. None of these

Ans:– C ,


The speed at which the monitor accepts data is called:
Options: bandwidth,    response time,    interlacing,    scanning

Ans:A ,A


How to remove the unwanted action from recorded macro without recording the whole macro again?
Options: By using the Find and Edit Action Option B. By clicking on the Refresh button in the Macro toolbar C. By edit the macro in the Visual Basic Editor D. Macro cannot be edited.

Ans:– C ,


The software used to drive microprocessor-based systems is called:
Options: assembly language programs,    firmware,    BASIC interpreter instructions,    flowchart instructions

Ans:A ,A


What will be the output if you format the cell containing 5436.8 as ‘#,##0.00′?
Options: a. 5430 b. 5436.8 c. 5436.80 d. 6.8

Ans:B,– b


  To insert new slide in the current Presentation, we can choose:
Options: Ctrl+M B. Ctrl+N C. Ctrl+O D. Ctrl+F

Ans:– A ,


Error reports are an example of:
Options: scheduled reports,    demand reports,    exception reports,    predictive reports

Ans:C ,C


What is an interpreter?
Options:  An interpreter does the conversion line by line as the program is run B.  An interpreter is the representation of the system being designed C.  An interpreter is a general purpose language providing very efficient execution D.  None of the above

Ans:– B ,


A device used to bring information into a computer is
Options: ALU,    Input device,    Control unit,    Output device

Ans:B ,B


A typical modern computer uses
Options: LSI chips,    Vacuum tubes,    Valves,    All the above

Ans:A ,A


A device that transmits messages in verbal form is
Options: Audit trail,    Card punch,    Audio response unit,    Magnetic tape

Ans:C ,C


What
Options: place your PC on a rubber mat,    wear leather soled shoes,    periodically touch a safe ground point on the PC to discharge yourself,   wear an ESD wrist strap

Ans:D,wear an ESD wrist strap


. Which of the following statement is true?
Options: a. Foreign key fields don’t allow duplicate values b. In primary key field you can enter duplicate value c. In an indexed field you may or may not enter duplicate value depending upon setting d. All statements are true

Ans:3 – c ,3 – c


. Selecting the Column G & H then choose Insert->ColumnWhat will happen?
Options: a. 2 Columns will be inserted after Column F b. 2 Columns will be inserted after Column G c. 2 Columns will be inserted after Column H d. 2 Columns will be inserted after Column I

Ans:– a,– a


How many addresses are required for 25 x 40 video RAM?
Options: 2000,    1920,    1000,    2000

Ans:C ,C


Which of the following is considered to be the destination host after translation?
Options: Inside local,    Outside local,    Inside global,    Outside global

Ans:D ,D


Which files will get closed through the fclose() in the following program? #include<stdio.h> int main() { FILE *fs, *ft, *fp; fp = fopen("A.C", "r"); fs = fopen("B.C", "r"); ft = fopen("C.C", "r"); fclose(fp, fs, ft); return 0; }
Options: "A.C" "B.C" "C.C",    "B.C" "C.C",    "A.C",    Error in fclose()

Ans:D ,D


When operating above its resonant frequency, a parallel RLC circuit has the characteristics of a:
Options: parallel RL circuit,    parallel RC circuit,    parallel RLC circuit operated above its resonant frequency,    purely resistive circuit

Ans:B ,B


. AutoCorrect was originally designed to replace _________ words as you type.
Options: a. short, repetitive b. grammatically incorrect c. misspelled d. none of the above

Ans:– C,– C


. You can merge the main document with data source in Excel. In mail merge operation, Word is usually
Options: a.  server b.  source c.  client d.  none

Ans:– c,– c


A program that is employed in the development, repair or enhancement of other programs is known as
Options: System software,    Software tool,    Applications program,    Utility program

Ans:B ,B

www.000webhost.com