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


Description: mcqquestions

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

Hits Today: 14730 | 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 first general purpose electronic digital computer in the world was
Options: A) UNIVAC B) EDVAC C) ENIAC D) All of above

Ans:C,C


. What does the expression [detail] ! [product] * 1.30 do?
Options: a. multiplies the contents of detail and product fields by 1.3 b. First divides detail by product and then multiplies by 1.3 c. multiplies the contents of detail in the product table by 1.3 d. multiplies the contents of product in the detail table by 1.3

Ans:– d,– d


. 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


. Which technology is more reliable?
Options: A) Mechanical B) Electro-Mechanical C) Electronic D) For reliability it does not matter. So all of above are reliable

Ans:3-C,3-C


What will be the output of the program in DOS (Compiler - Turbo C)? #include<stdio.h> double i; int main() { (int)(float)(char) i; printf("%d", sizeof((int)(float)(char)i)); return 0; }
Options: 1,    2,    4,    8

Ans:B ,B


When the minimum number of instances of an entity is one, you know which of the following?
Options: Mandatory one,    Optional one,    Mandatory many,    Cannot tell

Ans:D ,D


High-level languages are not concerned with computer but with
Options: Assembler,    Machine code,    Compiler,    All of the above

Ans:A ,A


. Which of the following terms is the most closely related to main memory?
Options: A) Non volatile B) Permanent C) Control unit D) Temporary

Ans:D,D


. Start/restart the computer is called
Options: a. Exit b. Run c. Option d. Boot

Ans:7 – d ,7 – d


Each entity is represented as a(n):
Options: tuple.,    table.,    attribute.,    file.

Ans:B ,B


. To select an entire column in MS-EXCEL, press?
Options: a. CTRL + C b. CTRL + Arrow key c. CTRL + S d. None of the above

Ans:– d,– d


Information in a memory that is no longer valid or wanted is known as
Options: non-volatile,    volatile,    surplus,    garbage

Ans:D ,D


The hardware features of LISP machines generally include:
Options: large memory and a high-speed processor,    letter-quality printers and 8-inch disk drives,    a mouse and a specialized keyboard,    both (a) and (c)

Ans:D ,D


Client-side extensions:
Options: add functionality to the server.,    add functionality to the browser.,    add functionality to the firewall.,    add functionality to the network.

Ans:B ,B


In the IBM PC-AT, what do the words AT stand for?
Options: Additional terminals,    Advance technology,    Applied technology,    Advanced terminology

Ans:B ,B


Which of the following digits are known as the terminal number of the Network User Address (NUA)?
Options: 5-7,    1-4,    8-12,    13-14

Ans:C ,C


Which command will delete the contents of NVRAM on a router?
Options: delete NVRAM,    delete startup-config,    erase NVRAM,    erase start

Ans:D ,D


What will be the output of the program under DOS? #include<stdio.h> int main() { char huge *near *far *ptr1; char near *far *huge *ptr2; char far *huge *near *ptr3; printf("%d, %d, %d\n", sizeof(ptr1), sizeof(**ptr2), sizeof(ptr3)); return 0; }
Options: 4, 4, 4,    4, 2, 2,    2, 8, 4,    2, 4, 8

Ans:B ,B


If you want all of the white cats grouped together in the database, you need to sort by ________.
Options: Color, then Gender B. Pet Type, then Color C. Pet Type, then Gender D. Color, then Pet Name

Ans:– B ,


In digital data transmission
Options: Baud rate in equal to bit rate,    Baud rate is always smaller than the bit rate,    Baud rate is always higher than the bit rate,    None of the above

Ans:D,None of the above


The benefits of object-oriented modeling are which of the following?
Options: The ability to tackle more challenging problems,    Reusability of analysis, design, and programming results,    Improved communication between users, analysts, etc.,    All of the above.

Ans:D ,D


. Which of the following operating system reads and reacts in actual time?
Options: a. Quick Response System b. Real Time System c. Time Sharing System d. Batch Processing System

Ans: b, b


Which of the following in not a function of DBA?
Options: Network Maintenance B. Routine Maintenance C. Schema Definition D. Authorization for data access

Ans:– A ,


What is the byte capacity of a drum which is 5 inch high, 10 inch diameter, and which has 60 tracks per inch and bit density of 800 bits per inch?
Options: 942000 bytes,    9712478 bytes,    192300 bytes,    14384 bytes

Ans:A ,A


IBM 7000 digital computer
Options: belongs to second generation,    uses VLSI,    employs semi conductor memory,    has modular construction

Ans:D ,D


.   The best way to insert a new slide in a presentation is to use the
Options: a. Normal view b. Special view c. Slide show view d. Slide sorter view

Ans:4 – D ,4 – D


. The ....is the drive containing the files to be copied
Options: a. Source drive b. Destination drive c. USB drive d. None of the above

Ans: a, a


Which of the field has width 8 bytes?
Options: a. Memo b. Number c. Date/Time d. Hyperlink

Ans:ndash; c,ndash; c


Which command will be used to display a column file compression ratio for each file of Double spaced disk?
Options: DIR/W,    DIR/S,    DIR/B,    DIR /C (/C switch introduced in DOS version 6.00)

Ans:D ,D


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

Ans:– B ,


Two connected routers are configured with RIP routing. What will be the result when a router receives a routing update that contains a higher-cost path to a network already in its routing table?
Options: The updated information will be added to the existing routing table.,    The update will be ignored and no further action will occur.,    The updated information will replace the existing routing table entry.,    The existing routing table entry will be deleted from the routing table and all routers will exchange routing updates to reach convergence.

Ans:B ,B


To test the IP stack on your local host, which IP address would you ping?
Options: 127.0.0.0,    1.0.0.127,    127.0.0.1,    127.0.0.255

Ans:C ,C


Which two files are used during operation of the DBMS?
Options: query language and utilities,    data manipulation language and query language,    data dictionary and transaction log,    data dictionary and query language

Ans:C ,C


The hardware in which data may be stored for a computer system is called
Options: Registers,    Bus,    Control unit,    Memory

Ans:D ,D


To open Columns dialog box quickly
Options:  A) double click on the left margin area of ruler, B) double click the space between area on ruler, C) double click the right margin in ruler, D) All of above, 

Ans:-B,-B


The activity of a file
Options: is a low percentages of number of records added or deleted from a file,    if high, reduces processing efficiency for sequential and nonsequential files,    is a measure of the percentage of existing records updated during a run,    refers to how closely the files fits into the allocated

Ans:A ,A


In an Entity-Relationship Diagram “Diamonds” represents
Options: Attributes B. Multi-valued attributes C. Weak entity set D. Relationship sets

Ans:– D ,


Getting data from a cell located in a different sheet is called….
Options: Accessing B. Referencing C. Updating D. Functioning

Ans:– B ,


A network administrator needs to configure a router with a distance-vector protocol that allows classless routing. Which of the following satisfies those requirements?
Options: IGRP,    OSPF,    RIPv1,    EIGRP

Ans:D ,D


Point out the error in the program. #include<stdio.h> int main() { const int k=7; int *const q=&k; printf("%d", *q); return 0; }
Options: Error: RValue required,    Error: Lvalue required,    Error: cannot convert from 'const int *' to 'int *const',    No error

Ans:D ,D


During the maintenance phase
Options: System requirements are established,    System analysis is carried out,    Programs are tested,    All of the above

Ans:E ,E


. Fifth generation computer is also known as
Options: A) Knowledge information processing system B) Very large scale integration (VLSI) C) Both of above D) None of above

Ans:A,A


In analyzing the compilation of PL/I program, the description "creation of more optimal matrix" is associated with
Options: Assembly and output,    Code generation,    Syntax analysis,    Machine independent optimization

Ans:D ,D


The most common input device used today is
Options: Motherboard,    Track ball,    Scanner,    Mouse

Ans:A,Motherboard


. A paper printout of a document is known as
Options: A) Softcopy output B) Hardcopy output C) Permanent Output D) All of above

Ans:B,B


Daisy chain is a device for
Options: connecting a number of controllers to a device,    connecting a number of devices to a controller,    interconnecting a number of devices to a number of controllers,    all of the above

Ans:B ,B


Which of the following will not advance the slides in a slide show view?
Options: a. Esc key b. The spacebar c. The Enter key d. The mouse button

Ans: – A , – A


The terminal device that functions as a cash register, computer terminal, and OCR reader is the:
Options: Data collection terminal,    OCR register terminal,    Video display terminal,    POS terminal

Ans:D ,D


    In MS-Dos 6.22, which part identifies the product uniquely  
Options: a.    MS b.    DOS c.    Ms-DOS d.    6.22

Ans:.b,Correct Answer: d. 6.22


The table created by lexical analysis to describe all literals used in the source program, is
Options: Terminal table,    Literal table,    Identifier table,    Reductions

Ans:B ,B

www.000webhost.com