. A smart tag will be removed from a cell when


Options: the cell is moved B. the cell is hidden C. the data in the cell is changed or deleted D. the formatting of the cell is changed

Ans:– C ,






More MS-Excel Related questions:


What MySQL property is used to create a surrogate key in MySQL?
Options: UNIQUE,    SEQUENCE,    AUTO_INCREMENT,    None of the above -- Surrogate keys are not implemented in MySQL.

Ans:C ,C


In SQL, GRANT command is used to
Options: allow user to access databases,    allow user to create databases,    grant system privileges, roles, and object privileges to uses and roles,    choose auditing for specific SQL commands

Ans:C ,C


The integrated circuit was invented by Jack Kilby of:
Options: MIT,    Texas Instruments,    Xerox,    All of the above

Ans:B ,B


To select a block of text, click at the beginning of the selection, scroll to the end of the selection, position the mouse pointer at the end of the selection, hold down the _____ key, and then click (or drag through the text).
Options: a. ctrl b. alt c. shift d. tab

Ans:– c,– c


. What do you mean by Memory Compaction?
Options: a. Combine multiple equal memory holes into one big hole b. Combine multiple small memory holes into one big hole c. Divide big memory hole into small holes d. Divide memory hole by 2

Ans:9 – b ,9 – b


59. Which of the following enables you to paste data multiple times?
Options: a. Windows Clipboard b. Office Clipboard c. Both Windows & Office Clipboard d. None of the all

Ans:–  C ,–  C


. What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changed
Options: a. Format Report b. Pivot Table c. Refresh Data d. Show Detail

Ans:– c,– c


. To undo the last work, press …..
Options: Ctrl+U B. Ctrl+Y C. Ctrl+Z D. Ctrl+W

Ans: – C ,


How many buses are connected as part of the 8085 microprocessor?
Options: 2,    3,    5,    8

Ans:B ,B


. Which file keeps commands to execute automatically when OS is started?
Options: a. command . com b. any batch file c. autoexec.bat d. config.sys

Ans:9 – c ,9 – c


The general type of process found in industry is:
Options: discrete parts,    continuous,    batch,    All of the above

Ans:D ,D


Which of the following is a machine for reading documents that are encoded in a way that is readable by person and machine.
Options: Document reader,    Distributed system,    Artificial intelligence,    Document sorter

Ans:A ,A


With respect to data input, the most accurate description of batch control is
Options: dividing documents to be entered into batches,    controlling the input of each input clerk,    comparing to a pre-calculated figure the total of a data item summed across a batch records put into the system,    All of the above

Ans:C ,C


In simplex transmission
Options: Data format is simple,    Data transmission is one way,    Data can be transmitted to small distances only,    All of the above

Ans:B,B


The formula for memory capacity is:
Options: MC = N/2,    MC = 2/N,    MC = N squared.,    MC -2 to the Nth power

Ans:D ,D


Which of the following is not considered to be a basic element of an enterprise-class database system?
Options: Users,    Database applications,    DBMS,    COBOL programs

Ans:D ,D


A wrist grounding strap contains which of the following:
Options: Surge protector,    Capacitor,    Voltmeter,    Resistor

Ans:D ,D


Which command is used to make all files and sub-directories in the directory (progs) executable by all users?
Options: chmod -R a+x progs,    chmod -R 222 progs,    chmod -1 a+x progs,    chmod -x a+x progs

Ans:A ,A


In precedence of set operators the expression is evaluated from
Options: a. Left to Left b. Left to Right c. Right to Right d. Right to Left

Ans:– b ,


Who coordinates the sequencing of events within the central processor of a computer?
Options: Logic unit,    Arithmetic unit,    Register,    Control unit

Ans:D ,D


When connecting two internal SCSI hard disks to a computer, where do you connect the second hard drive?
Options: Any open SCSI port on the computer,    A Serial port on the first host adapter,    An open parallel port on the computer,    An open SCSI port on the first hard drive

Ans:A ,A


. MS-EXCEL can be used to automate
Options: a. Financial statements, Business forecasting b. Transaction registers, inventory control c. Accounts receivable, accounts payable d. Any of the above

Ans:– d,– d


Computer memory consists of
Options: RAM,    ROM,    PROM,    All of the above

Ans:D ,D


It is used to calculate and restructure data for easier analysis of your data. It calculates the sum,
Options: a. Parameter b. Select c. crosstab d. Append

Ans:ndash; c,ndash; c


Locations in the main memory of a computer are called
Options: Alphabets,    Words,    Data,    Characters

Ans:B ,B


What is the output of the program? #include<stdio.h> int main() { extern int a; printf("%d\n", a); return 0; } int a=20;
Options: 20,    0,    Garbage Value,    Error

Ans:A ,A


A translator which reads an entire programme written in a high level language and converts it into machine language code is:
Options: assembler,    translator,    compiler,    system software

Ans:C ,C


The benefits of a standard relational language include which of the following?
Options: Reduced training costs,    Increased dependence on a single vendor,    Applications are not needed.,    All of the above.

Ans:A ,A


In which mode can 2 or more applications be stored in memory at the same time?
Options: Segmented Mode,    Unprotected Mode,    Real Mode,    Protected Mode

Ans:D ,D


Which of the following statements are correct about 6 used in the program? int num[6]; num[6]=21;
Options: In the first statement 6 specifies a particular element, whereas in the second statement it specifies a type.,    In the first statement 6 specifies a array size, whereas in the second statement it specifies a particular element of array.,    In the first statement 6 specifies a particular element, whereas in the second statement it specifies a array size.,    In both the statement 6 specifies array size.

Ans:B ,B


. Which command will you use to transfer a specific file from one disk to another disk?
Options: a. Time b. Diskcopy c. Copy d. Rename

Ans:7 – c ,7 – c


ODL supports which of the following types of association relationships?
Options: Unary,    Unary and Binary,    Unary and Binary and Ternary,    Unary and Binary and Ternary and higher

Ans:B ,B


. What is the date when Babbage conceived Analytical engine
Options: A) 1642 B) 1837 C) 1880 D) 1850

Ans:0-B,0-B


. Which of the following field properties is an expression that specifies criteria or requirements for entering data?
Options: a. Field Size b. Format c. Input Mask d. Validation Rule

Ans:1 – d ,1 – d


In order to increase the amount of memory available for a system, what is the maximum size of a swap partition (with kernel version 2.2.x)?
Options: 2GB,    128MB,    64MB,    32MB

Ans:A ,A


In CRC there is no error if the remainder at the receiver is _____.
Options: equal to the remainder at the sender,    zero,    nonzero,    the quotient at the sender

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


Which of the following services use TCP? DHCP SMTP HTTP TFTP FTP
Options: 1 and 2,    2, 3 and 5,    1, 2 and 4,    1, 3 and 4

Ans:B ,B


What is the general name of the device which produces hardcopy graphics?
Options: COM,    Plotter,    Printer,    Microfilm

Ans:B,B


In notes master view, how do you modify the font size of text for all hte4 notes of a presentation?
Options: a. Modify the slide design b. Modify the notes master layout c. Modify the text within the body placeholder d. All of the above

Ans: – C , – C


The equivalent of 1 kV is:
Options: 1.00 V,    1000 V,    100 mV,    1000 mV

Ans:B ,B


.Finding the location of the element with a given value is:
Options: A)Traversal b.Search c.Sort d.None of above

Ans:B,B


A robot's "arm" is also known as its:
Options: end effector,    actuator,    manipulator,    servomechanism

Ans:C ,C


Which of the following are advantages of using NAT? Translation introduces switching path delays. Conserves legally registered addresses. Causes loss of end-to-end IP traceability. Increases flexibility when connecting to the Internet. Certain applications will not function with NAT enabled. Reduces address overlap occurrence.
Options: 1, 3 and 4,    3, 5 and 6,    5 and 6,    2, 4 and 6

Ans:D ,D


Which command is used to remove the read permission of the file 'note' from both the group and others?
Options: chmod go+r note,    chmod go+rw note,    chmod go-x note,    chmod go-r note

Ans:D ,D


. What is the latest write-once optical storage media?
Options: A) Digital paper B) Magneto-optical disk C) WORM disk D) CD-ROM disk

Ans:D,D


. Bit stands for
Options: A) Binary digits B) bit of system C) a part of byte D) All of above

Ans:A,A


. The date and time displays on
Options: a. Taskbar b. Status bar c. System tray d. Launch pad

Ans: c, c


. If you select Insert >> Picture >> From File
Options: a.  You can insert pictures and clipArts b.  You can insert clipArts only c.  You can insert pictures only d.  None of above

Ans:6 – C ,6 – C


You have a network ID of 134.57.0.0 with 8 subnets. You need to allow the largest possible number of host IDs per subnet. Which subnet mask should you assign?
Options: 255.255.224.0,    255.255.240.0,    255.255.248.0,    255.255.252.0

Ans:B ,B

www.000webhost.com