. How to specify cell range from A9 to A99 in Excel?


Options: (A9, A99) B. (A9 to A99) C. (A9 : A99) D. (A9 – A99)

Ans:– C ,


Description: mcqquestions






More MS-Excel Related questions:


. Got functions? No? You need the insert function dialog box. How do you get it?
Options: a. Right click a cell and then click insert b. Click the insert menu and then click function c. Type = in a cell d. All of the above

Ans:– b,– b


Data base preparation would be most difficult in a(n)
Options: college or university,    supermarket,    hospital,    bank

Ans:D ,D


A compound key
Options: is made up a several pieces of information,    uniquely identifies an item in a list,    both (a) and (b),    is a combination of each unique key

Ans:C ,C


. What type of memory is not directly addressable by the CPU and requires special softw3are called EMS (expanded memory specification)?
Options: A) Extended B) Expanded C) Base D) Conventional

Ans:B,B


Waveforms are graphs that show:
Options: frequency on the vertical axis and amplitude on the horizontal axis,    amplitude on the vertical axis and frequency on the horizontal axis,    amplitude on the vertical axis and the passage of time on the horizontal axis,    the passage of time on the vertical axis and amplitude on the horizontal axis

Ans:C ,C


Which of the following is not used for storage purposes with main frame computers?
Options: removable disks,    fixed disks,    mass storage systems,    diskettes

Ans:D,D


The records in a file on magnetic tape
Options: can only be accessed serially,    are meant for backup,    cannot be transformed to a disk file,    have to be arranged in a key sequence

Ans:A ,A


Which of the following is true regarding page Orientation of a Document?
Options: a. Page Orientation can be change at any time b. Page Orientation of document determines by printer c. Page Orientation must be set before start typing d. Page Orientation of a document cannot be changed.

Ans:–  A,–  A


. The _____ Symbol Smart Tag launches Microsoft Explorer and obtains a stock quote.
Options: a. MSN Money b. Portfolio c. Financial d. Stock

Ans:7 – c ,7 – c


Which of the following statements is the most accurate?
Options: The degree to which information needs to be summarized increases as one moves up through the management levels,    Low-level managers made unstructured decisions,    Upper managers make unstructured decisions,    Low-level managers need general information about operating activities.

Ans:A ,A


. MSI stands for

Options: A) Medium Scale Integrated Circuits B) Medium System Integrated Circuits C) Medium Scale Intelligent Circuit D) Medium System Intelligent Circuit

Ans:A,A


What is proportional control?
Options: It has a discrete output for each error value,    The controller output varies continuously over a range,    The gain is independent of offset error.,    All of the above

Ans:B ,B


What technology is used for flat panel displays?
Options: Solid state,    RBG monitor,    VLSI,    Direct view storage tube

Ans:A,A


Which of the following filename extension suggests that the file is a backup copy of another file?
Options: BAK *,    BAS,    COM,    TXT

Ans:A ,A


. To place something in the same position on every slide of presentation automatically, insert into
Options: a. Slide master b. Notes master c. Handout master d. None of the above

Ans:3 – A ,3 – A


Avalanche photodiode receivers can detect hits of transmitted data by receiving
Options: 100 photons,    200 photons,    300 photons,    400 photons

Ans:B ,B


Which of the following may not be a database?
Options: a. Data presented in table in MS Word document b. Data entered in Excel spreadsheet c. A presentation created in PowerPoint d. A telephone diary

Ans:ndash; c,ndash; c


The disadvantage of dynamic RAM over static RAM is
Options: higher power consumption,    variable speed,    need to refresh the capacitor charge every once in two milliseconds,    higher bit density

Ans:C ,C


A memory that holds micro programs is
Options: Core memory,    ROM,    RAM,    Control memory

Ans:B ,B


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


Which is an Office feature that makes it easy to edit embedded objects?
Options: pasting B. visual editing C. tools, update, links D. edit, links

Ans:– B ,


The octal representation 652 indicates
Options: Execute permission for the owner,    Write permission for others,    Read and write permission of groups,    All of the above

Ans:B ,B


Which command is used to establish a link between a source document and a destination document?
Options: Tools, Link, Documents B. Tools, Link C. Edit, Link D. Edit, Paste Special

Ans:– D ,


A _____ is responsible for the design and control of a company's data base
Options: DBA,    DBM,    DPMA,    EDP auditor

Ans:A ,A


Which of the following is true when describing a link-local address?
Options: Packets addressed to a unicast address are delivered to a single interface.,    These are your typical publicly routable addresses, just like a regular publicly routable address in IPv4.,    These are like private addresses in IPv4 in that they are not meant to be routed.,    These addresses are meant for nonrouting purposes, but they are almost globally unique so it is unlikely they will have an address overlap.

Ans:C ,C


What is (void*)0?
Options: Representation of NULL pointer,    Representation of void pointer,    Error,    None of above

Ans:A ,A


The access method used for cassette tape is
Options: Direct,    Random,    Sequential,    All of the above

Ans:C ,C


A magnetic tape volume that is used on a data processing operation without any change to its contents is
Options: Magnetic disk,    Punched paper tape,    Master tape,    Card reader

Ans:C ,C


Which command is used with vi editor to move the cursor to the left?
Options: i,    j,    k,    h

Ans:D ,D


The relational model consists of:
Options: data in the form of tables.,    data redundancy.,    operations using non-SQL languages.,    unorganized data.

Ans:A ,A


.  A report module includes code for all event _______ triggered by events occurring on a specific report or its controls.
Options: a.            properties b.           procedures c.           macros d.            commands

Ans:– b,– b


A single packet on a data link is known as
Options: Path,    Frame,    Block,    Group

Ans:B,(Banswer


It is possible to _______ a data source before performing a merge.
Options:  A) Create, B) Modify, C) Sort, D) all of the above,

Ans:-D,-D


. When you see a cell with a red triangle in the top right corner, what does this signify?
Options: a. There is an error in the cell b. There is a comment associated with the cell c. The font color for text in the cell is red d. A formula cannot be entered into the cell

Ans:– b,– b


Mistakes made in the system analysis stage show up in :
Options: implementation,    system design,    system developments,    All of the above

Ans:A ,A


To prevent toner from sticking to a laser printer's heat rollers, apply which of the following:
Options: Alcohol,    Oil,    Ammonia,    Beer or Jack Daniels

Ans:B ,B


In a PowerPoint presentation
Options: a. Sound clips can be inserted but not movie clips b. Movie clips can be inserted but not sound clips c. Both cannot be inserted d. Both can be inserted

Ans: – D , – D


17. Which command is used to set a name to a disk in DOS?
Options: a. VOLUME b. VOL c. LABEL d. DISKLABEL

Ans:Correct Answer: c,Correct Answer: c


What is the shortcut key to display field codes?
Options: a. Alt + F9 b. Ctrl + F9 c. Shift + F9 d. Space + F9

Ans:–  A,–  A


A cursor type in which the application can only move forward through the recordset is called:
Options: forward only.,    static.,    keyset.,    dynamic.

Ans:A ,A


.   After choosing a predefine template, ….. option has to be chosen to change a background color
Options: a. Design template b. Color scheme c. Animation scheme d. Color effects

Ans:0 – B ,0 – B


. Which is the shortcut key to jump to the first slide of the presentation?
Options: a. Home b. Alt + Home c. Ctrl + Home d. Shift + Home

Ans:1 – C ,1 – C


An IRQ allow interface cards to:
Options: Interrupt the CPU to request service,    Pass data to the CPU to be processed,    Pass data from one card to another,    Pass data to the computers memory

Ans:A ,A


What will be the output of the program ? #include<stdio.h> int main() { int a[5] = {5, 1, 15, 20, 25}; int i, j, m; i = ++a[1]; j = a[1]++; m = a[i++]; printf("%d, %d, %d", i, j, m); return 0; }
Options: 2, 1, 15,    1, 2, 5,    3, 2, 15,    2, 3, 20

Ans:C ,C


In Computer System Scanner is ______ Device?
Options: Input B. Output         C. Both D. None

Ans:– A ,


.   Ellipse Motion is a predefined ….
Options: a. Design template b. Color scheme c. Animation scheme d. None of these

Ans:1 – C ,1 – C


What is the full form of AT in the IBM PC-AT?
Options: A. Applied Technology B. Advance Technology C. Additional Technology D. None of the Above

Ans:B,


A decrease in magnitude of current, voltage, a power of a signal in transmission between points, is known as
Options: Attenuation,    Amplitude,    Aloha,    Carrier

Ans:A ,A


A rectangle represents which of the following in an ERD?
Options: Attribute,    Entity,    Optional One,    Relationship

Ans:B ,B


What multicast addresses does RIPng use?
Options: FF02::A,    FF02::9,    FF02::5,    FF02::6

Ans:B ,B

www.000webhost.com