. What is the shortcut key to insert a new comment in a cell?


Options: F2 B. Alt + F2 C. Ctrl + F2 D. Shift + F2

Ans:– D ,


Description: mcqquestions






More MS-Excel Related questions:


. how would you create the following diagram in PowerPoint
Options: a. Use auto shapes and the drawing toolbar to create the diagram and design it b. Open the diagram gallery from the drawing toolbar and choose this diagram type c. Use the chart command on the insert menu to import the diagram d. All of above

Ans:3 – B ,3 – B


A 25-pin female connector on the back of your computer will typically be:
Options: Serial port 1,    A parallel port,    Docking,    COM2 port

Ans:B ,B


. The basic elements of a form or a report are called:
Options: a. Controls b. Objects c. Windows d. Properties

Ans:– a,– a


MSD exe does not have information on:
Options: cache,    video,    operation system,    com ports

Ans:A ,A


In Word, the default alignment for paragraphs is _____.
Options: a. left-aligned, or flush margins at the left edge and uneven edges at the right edge b. centered, or equidistant from both the left edge and the right edge c. right-aligned, or flush margins at the right edge and uneven edges at the left edge d. justified, or flush margins at both the left and right edges

Ans:– A,– A


A supertype/subtype hierarchy is which of the following?
Options: Each subtype has only one attribute.,    Each supertype has only one attribute.,    Each subtype has only one supertype.,    Each supertype has only one subtype.

Ans:C ,C


A ternary relationship involves how many entities?
Options: 3 or less,    3,    More than 3,    3 or more

Ans:B ,B


The index consists of
Options: a list of keys,    pointers to the master list,    both (a) and (b),    All of the above

Ans:C ,C


When you connect to an online information service, you are asked to provide some kind of identification such as your name, an account number and a password. What is the name given to this brief dialogue between you and the information system?
Options: Security procedure,    Safeguard procedure,    Identification procedure,    Log-on procedure

Ans:D ,D


What is the smallest width of a column?
Options:  A) 0", B) 0.5", C) 1", D) 1.5", 

Ans:-B,-B


. Which report section prints once at the bottom of every printed page?
Options: a. Detail b. Page Header c. Page Footer d. Report Header

Ans:5 – c ,5 – c


Convert the 11014B machine language instructions into assembly language, assuming that they were not generated by pseudo-ops:
Options: ASRA,    LOADA h#OD4E, i,    STOREA h#014B, d,    ADDA h#01FE, i

Ans:C ,C


Which tab in Font dialog box contains options to apply font effects?
Options:  A) Font tab, B) Character Spacing, C) Text Effects, D) Standard Toolbar,

Ans:-A,-A


How can you delete a record?
Options: a. Delete the column from the worksheet b. Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button c. Select Data > Delete Record from the menu d. Click the Delete button on the Standard toolbar

Ans:#8211; b,#8211; b


A 6xx indicates a problem with the:
Options: floppy drive,    hard drive,    keyboard,    CD ROM

Ans:A ,A


To center worksheet titles across a range of cells, you must
Options: a. Select the cells containing the title text plus the range over which the title text is to be centered b. Widen the columns c. Select the cells containing the title text plus the range over which the title text is to be enfettered d. Format the cells with the comma style

Ans:#8211; a,#8211; a


A program that converts computer data into some code system other than the normal one is known as
Options: Encoder,    Simulation,    Emulator,    Coding

Ans:A ,A


What switch would you use to view Smartdrive statistics?
Options: /x,    /e:,    /s,    /o:n

Ans:C ,C


Which transmission mode is used for data communication along telephone lines?
Options: Parallel,    Serial,    Synchronous,    Asynchronous

Ans:B ,B


IBM released its first PC in 1981. Can you name the operating system which was most popular at that time?
Options: MS-DOS,    PC-DOS,    OS/360,    CP/M

Ans:D ,D


The first large scale electronic computer which became operational in 1946 and contained approximately 18000 vacuum tubes and could perform 300 multiplications per second was known as
Options: ILLIAC,    ENIAC,    JOHNIAC,    EDSAC

Ans:B ,B


The processing, which normally consists of a small computer with one or more peripheral devices, connected via a high-speed line to the large control computer is known as
Options: On-line processing,    Remote-terminal processing,    Batch mode processing,    Intelligent terminal Processing

Ans:D ,D


Modern Computers are very reliable but they are not
Options: A) Fast B) Powerful C) Infallible D) Cheap

Ans:-C,-C


. If 4/6 entered in a cell without applying any formats, Excel will treat this as
Options: Fraction B. Number C. Text D. Date

Ans:– D ,


. The content and application of the Search tool CANNOT be retained when you ______.
Options: a. format an object b. resize a column c. use Datasheet View d. close an object

Ans:1 – d ,1 – d


. When was the transistors invented?

Options: A) 1948 B) 1938 C) 1958 D) 1968

Ans:A,A


In which of the following, each data item contains at most 2 points
Options: List structure,    LISP,    List sorting,    List head

Ans:B ,B


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

Ans:D ,D


In pen plotters, "resolution" refers to the shortest possible line, but in electrostatic plotters it refers to:
Options: the number of dots per inch,    the speed per inch,    dual-axis tracking,    how accurately the plotter returns to a specific point

Ans:A ,A


What is the standard code the computer industry created to represent characters?
Options: DASI,    ASSH,    ASCII,    BASCII

Ans:C ,C


When was the first successful industrial robot installed in the General Motors Plant in USA?
Options: 1960,    1961,    1963,    1967

Ans:B ,B


Which of the following is a special purpose language used to describe to a computer's operating system.
Options: LOGO,    APL,    ICL,    CORAL

Ans:C ,C


. What does DMA stand for?
Options: A) Distinct Memory Access B) Direct Memory Access C) Direct Module Access D) Direct Memory Allocation

Ans:B,B


.Arrays are best data structures
Options: A)for relatively permanent collections of data b.for the size of the structure and the data in the structure are constantly changing c.for both of above situation d.for none of above situation

Ans:A,A


The fastest read/write time and most efficient data storage of any disk array type is:
Options: RAID-0.,    RAID-1.,    RAID-2.,    RAID-3.

Ans:A ,A


ODBC minimum SQL grammar contains which of the following?
Options: INSERT, UPDATE, DELETE only,    Stored Procedures only,    Literals for date, time and timestamp only,    CREATE VIEW, DROP VIEW only

Ans:A ,A


What is the turns ratio of a power transformer that shows 50 V at its secondary winding when you apply 150 V to its primary winding?
Options: 1/4,    1/3,    2,    3

Ans:D ,D


To get the Norton current, you have to
Options: Short the load resistor,    Open the load resistor,    Short the voltage source,    Open the voltage source

Ans:C ,C


The reports generated by a reporting system are usually not delivered in which of the following media?
Options: Web portal,    Commercial courier service,    Digital dashboard,    E-Mail

Ans:B ,B


In analyzing the compilation of PL/I program, the term "Syntax analysis" is associated with
Options: recognition of basic syntactic constructs through reductions,    recognition of basic elements and creation of uniform symbols,    creation of more optional matrix,    use of macro processor to produce more optimal assembly code

Ans:A ,A


What does DMA stand for?
Options: Distinct Memory Access B. Direct Memory Access C. Direct Module Access D. Direct Memory Allocation

Ans:– B ,


Which is a device that changes information into digital form?
Options: Modem,    Digitizer,    Mouse,    Light pen

Ans:B,(Banswer


. This database has only one table.
Options: a. relational b. large c. flat-file d. DBMS

Ans:8 – c ,8 – c


. Which do you click to display the table’s primary key and indexes in a separate window?
Options: a. indexes button b. primary key button c. view datasheet button d. view design button

Ans:– a,– a


Binary numbers need more places for counting because
Options: They are always big numbers,    Any no. of 0's can be added in front of them,    Binary base is small,    0's and l's have to be properly spaced apart

Ans:C ,C


What will be the output of the program? #include<stdio.h> int main() { int i; i = printf("How r u\n"); i = printf("%d\n", i); printf("%d\n", i); return 0; }
Options: How r u 7 2,    How r u 8 2,    How r u 1 1,    Error: cannot assign printf to variable

Ans:B ,B


Which of following is/are the advantage(s) of modular programming?
Options: The program is much easier to change,    Modules can be reused in other programs,    Easy debugging,    Easy to compile

Ans:A ,A


. Which device is used as the standard pointing device in a Graphical User Environment?
Options: A) Keyboard B) Mouse C) Joystick D) Track ball

Ans:B,B


While working with MS-DOS, which command is used to restore files that were backed up using the BACKUP command?
Options: COPY,    DISKCOPY,    RESTORE,    STORE

Ans:C ,C


. Which of the following uses the spelling and grammar feature to indicate an incorrect spelling?
Options: a. The incorrect word appears in all capital letters b. The incorrect word has a wavy red line under it c. The incorrect word appears italicized d. The incorrect word appears bold

Ans:7 – B ,7 – B

www.000webhost.com