. Worksheet can be renamed by


Options: Adding ? symbol at the end of filename while saving workbook B. Click on Worksheet tab by Holding CTRL Key and type new name C. Double Click on the Worksheet tab and type new name D. Worksheet cannot renamed

Ans:– C ,






More MS-Excel Related questions:


In comparison to the internal (main) memory, tape or disk memory is
Options: slower and more expensive,    slower and less expensive,    faster and more expensive,    faster and less expensive

Ans:B,B


“Ctrl + PageDown” is used to
Options: a. Moves the cursor one Paragraph Down b. Moves the cursor one Page Down c. Moves the cursor one Line Down d. Moves the cursor one Screen Down

Ans:–  B,–  B


Which SQL Query is use to remove a table and all its data from the database? a. Create Table b. Alter Table c. Drop Table d. None of these
Options: Every primary-key value must match a primary-key value in an associated table B. Every primary-key value must match a foreign-key value in an associated table C. Every foreign-key value must match a primary-key value in an associated table D. Every foreign-key value must match a foreign-key value in an associated table

Ans:– c ,


Which of the plotters listed below eliminates media size limitations?
Options: Drum,    Flatbed,    Electrostatic,    Pinch roller

Ans:A ,A


Acceptance testing is
Options: running the system with line data by the actual user,    making sure that the new programs do in fact process certain transactions according to Specifications,    is checking the logic of one or more programs in the candidate systems,    testing changes made in an existing or a new program

Ans:A ,A


Which statement(s) about IPv4 and IPv6 addresses are true? An IPv6 address is 32 bits long, represented in hexidecimal. An IPv6 address is 128 bits long, represented in decimal. An IPv4 address is 32 bits long, represented in decimal. An IPv6 address is 128 bits long, represented in hexidecimal.
Options: 1 and 3 only,    2 only,    3 and 4,    2 and 4

Ans:C ,C


Which one of the following statements is true for the currents in a series RC circuit?
Options: The current always has the same amplitude and phase for every part of the circuit,    The total current is equal to the sum of the currents for the resistance and capacitance,    The total current is greater than the sum of the currents for the resistance and capacitance,    The total current is less than the sum of the currents for the resistance and capacitance

Ans:A ,A


    If you need to duplicate the entire disk, which command will you use?
Options: a.    Copy b.    Diskcopy c.    Chkdsk d.    Format

Ans:.d,Correct Answer: b. Diskcopy


A network consists of eight NT servers. You are planning to move servers to different segments of your network, what utility should be used at each server to determine which server generates the most traffic?
Options: NBTSTAT,    NETSTAT.EXE,    Performance Monitor,    Network Monitor

Ans:D ,D


Point out the error in the program in 16-bit platform? #include<stdio.h> int main() { struct bits { int i:40; }bit; printf("%d\n", sizeof(bit)); return 0; }
Options: 4,    2,    Error: Bit field too large,    Error: Invalid member access in structure

Ans:C ,C


. 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


. Shortcut key to insert a hyperlink in a slide
Options: a. Ctrl + H b. Ctrl + K c. Hyperlinks can’t be inserted in slides d. None of the above

Ans:5 – B ,5 – B


. 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


In LISP, the function X (x). (2x+l) would be rendered as
Options: (lambda (x) (+(*2 x)l)),    (lambda (x) (+1 (* 2x),    (+ lambda (x) 1 (*2x)),    (* lambda(x) (+2x1)

Ans:A ,A


2. ….is the layer of a computer system between the hardware and the user program
Options: a. Operating environment b. Operating system c. System environment d. None

Ans:Correct Answer: b,Correct Answer: b


An encoder:
Options: is used to send telegraph signals,    converts an input to a binary number,    converts a binary number to a decimal number.,    can have only four keys

Ans:B ,B


The time factor when determining the efficiency of algorithm is measured by
Options: a. Counting microseconds b. Counting the number of key operations c. Counting the number of statements d. Counting the kilobytes of algorithm  

Ans:b,b


Speed of Laser Printer is measured in
Options: LPM B. PPM C. DPI D. DPS

Ans:– B ,


. How to fit long texts in a single cell with multiple lines?
Options: Start typing in the cell and press the Enter key to start another line B. Use the Wrap Text option in the Format -> Alignment menu C. Use the Shrink to Fit option in the Format -> Cells -> Alignment menu D. All of above

Ans:– B ,


If the current gain is 200 and the collector current is 100 mA, the base current is
Options: 2 mA,    0.5 mA,    2 A,    200 A

Ans:B ,B


What  is the name given to something that the  computer  will automatically use unless you tell it otherwise?
Options: a. a specification b. a wildcard c. a default d. a rule

Ans:6 c.  ,6 c. 


A beam of light used to record and retrieve data on optical disks is known as
Options: polarized light,    unpolarized concentric light,    laser,    coloured light

Ans:C ,C


What is the shortcut key you can press to create a copyright symbol?
Options:  A) Alt+Ctrl+C, B) Alt + C, C) Ctrl + C, D) Ctrl + Shift + C,

Ans:-A,-A


87. Which of the following is not available in Font Spacing?
Options: a. Normal b. Loosely c. Condensed d. Expanded

Ans:– B ,– B


Point out the odd item amongst the following
Options: Computer mouse,    Touchpad,    Light pen,    Printer

Ans:D ,D


Which of the following column properties would be used to specify that cells in a column must contain a monetary value that is less than another monetary value in the same row?
Options: Null status,    Data type,    Default value,    Data constraints

Ans:D ,D


A constraint that does not, affect the feasible solution region is known as
Options: redundant constraint,    unbounded solution,    slack variable,    surplus variable

Ans:A ,A


Sequential retrieval on a primary key for sequential file storage has which of the following features?
Options: Very fast,    Moderately fast,    Slow,    Impractical

Ans:A ,A


A traditional data administrator performs which of the following roles?
Options: Tune database performance,    Establish backup and recovery procedures,    Resolve data ownership issues,    Protect the security of the database.

Ans:C ,C


What is the use of Notes in slides?
Options: It will be displays at the time of Slide Presentation B. This is just Note about the slide       C. This is just for printing purpose only D. Notes cannot be inserted in Slides

Ans:– B ,


Which of the following refers to a cursor type that when the cursor is opened, a primary key value is saved for each row in the recordset; when the application accesses a row, the key is used to fetch the current values of the row?
Options: Forward only,    Static,    Keyset,    Dynamic

Ans:C ,C


Assembler is
Options: a program that places programs into memory and prepares them for execution.,    a program that automate the translation of assembly language into machine language.,    a program that accepts a program written in a high level language and produces an object program.,    is a program that appears to execute a source program as if it were machine language.

Ans:B ,B


Suppose a voltage source has an ideal voltage of 12V and an internal resistance of 0.5W. For what values of load resistance will the voltage source appear stiff?
Options: 5 Ohm,    50 Ohm or more,    100 Ohm,    6 Ohm

Ans:B ,B


The elements of an array are stored successively in memory cells because
Options: a. by this way computer can keep track only the address of the first element and the addresses of other elements can be calculated b. the architecture of computer memory does not allow arrays to store other than serially c. both of above d. none of above

Ans:a,a


Point out the error in the program? typedef struct data mystruct; struct data { int x; mystruct *b; };
Options: Error: in structure declaration,    Linker Error,    No Error,    None of above

Ans:C ,C


An Audit trial is
Options: a feature of data processing systems that allows for the study of data as processed from step to step; and auditor can then trace all transactions that affect an account.,    a data item that characterizes an object,    two or more data items handled as a unit,    All of the above

Ans:A ,A


A program used to detect overall system malfunction is
Options: System analysis,    System software,    Utilities,    System diagnostics

Ans:D ,D


When using the loopback address, if TCP/IP is installed correctly, when should you receive a response?
Options: Immediately,    Only if the address fails,    After the next host comes online,    Within two minutes

Ans:A ,A


. What is a portion of a document in which you set certain page formatting options?
Options: a. Page b. Document c. Section d. Page Setup

Ans:– C,– C


A modulator converts a _____ signal to a(n) _____ signal.
Options: FSK; PSK,    PSK; FSK,    analog; digital,    digital; analog

Ans:D ,D


Updating a database means
Options: revising the file structure,    reorganizing the database,    modifying or adding record occurrences,    All of the above

Ans:C ,C


You have purchased a MAU (Multistation Access Unit) from your computer supplier and now must decide what type of network card you should install in the workstations. Which of the following would be the most appropriate?
Options: Fast SCSI Wide,    Token-Ring,    ArcServe,    Ethernet

Ans:B ,B


. Which one is not a system tool?
Options: a. Backup b. Disk defragment c. Virus scanning d. All of the above

Ans: c, c


A physical connection between the microprocessor memory and other parts of the microcomputer is known as
Options: A) Path B) Address bus C) Route D) All of the above

Ans:-B,-B


Which of the following is characteristic of an operating system?
Options: resource management,    error recovery,    memory management,    All the above

Ans:D ,D


. Which of the following is machine independence program?
Options: A) High level language B) Low level language C) Assembly language D) Machine language

Ans:A,A


. Which of following are not PowerPoint views?
Options: a. Page View b. Print View c. Normal View d. Outline View

Ans:2 – A ,2 – A


While working with MS-DOS, which command is used to display the contents of a file and pause the display after each screenful of information?
Options: TYPE filename | MORE,    CAT filename | MORE,    CAT filename | pg,    MORE filename

Ans:A ,A


For a type 1 system, the steady-state:
Options: error for a step input is always zero,    error for a velocity input is always zero,    input for acceleration input is always non-zero,    (a) and (c)

Ans:D ,D


The MAC (Media Access Control) address of the network card is used in both Ethernet and Token-Ring networks and is essential for communication. What does MAC provide?
Options: A logical address that identifies the workstation,    A physical address that is randomly assigned each time the computer is started,    A physical address that is assigned by the manufacturer,    The logical domain address for the workstation

Ans:C ,C

www.000webhost.com