You are editing an worksheet that you had previously saved. If you want to save the edited sheet without losing the original one, which command should you use?


Options: New B. Save As C. Edit D. Save

Ans:– B ,


Description: mcqquestions

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

Hits Today: 11454 | 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 mouse pointer moves erratically, what is the possible cause? The mouse
Options: ball is dirty,    is not connected,    driver is not installed properly,    has an incorrect IRQ setting

Ans:A ,A


What does the following declaration mean? int (*ptr)[10];
Options: ptr is array of pointers to 10 integers,    ptr is a pointer to an array of 10 integers,    ptr is an array of 10 integers,    ptr is an pointer to array

Ans:B ,B


. Print options can be changed in the Print ____.
Options: a. tab b. layout mode c. setup routine d. dialog box

Ans:2 – d ,2 – d


What command is used to hand up a MODEM when using the "AT Answer Command set"?
Options: ATZ,    ATD,    ATR,    ATH

Ans:D ,D


A word field may consist of an optional field instruction called a(n) ______
Options: subdocument B. symbol C. signal D. switch

Ans:– D ,


What is stderr ?
Options: standard error,    standard error types,    standard error streams,    standard error definitions

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


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


A part located in the central processing unit that stores data & information is known as
Options: Core memory,    PROM,    EPROM,    ROM

Ans:A ,A


The input unit of a computer
Options: feeds data to the CPU or memory,    retrieves data from CPU,    directs all other units,    All of the above

Ans:A ,A


How do you display current date only in MS Excel?
Options: date () B. Today () C. now () D. time ()

Ans:– B ,


An entity type is which of the following?
Options: A major category of data about people, place, and things,    The various departments of an organization,    The application software,    The business processes the support the mission of an organization

Ans:A ,A


Which of the following is not a type of page margin?
Options:  A) Left, B) Right, C) Center, D) Top, 

Ans:-C,-C


In ODBC, a data source that is local to a single computer is called a:
Options: system data source.,    file data source.,    user data source.,    SQL text file.

Ans:A ,A


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

Ans:B ,B


In laser technology, what happens during the transfer stage?
Options: Residual toner is transferred to the waste receptacle,    The laser transfers the image from the drum to the paper,    The image is transferred from the drum to the paper,    A negative charge is transferred to the surface of the drum

Ans:C ,C


A design that consists of a hierarchy of modules; each module has a single entry and a single exit subroutine, is known as
Options: hierarchy structure,    top-down design,    Tuple,    Turnaround

Ans:B ,B


The difference between memory and storages is that memory is _____ and storage is _____
Options: Temporary, permanent,    Permanent, temporary,    Slow, fast,    AH of the above

Ans:A ,A


Using the following illustration, what would be the IP address of E0 if you were using the eighth subnet? The network ID is 192.168.10.0/28 and you need to use the last available IP address in the range. The zero subnet should not be considered valid for this question.
Options: 192.168.10.142,    192.168.10.66,    192.168.100.254,    192.168.10.143

Ans:A ,A


    Who invented Analytical engine?
Options: Blaise Pascal B. George Bool C. Charles Babbage D. Dr. Herman Hollerith

Ans:– C ,


. When you quickly press and release the left mouse button twice you are
Options: a. Primary clicking b. Pointing c. Double clicking d. Secondary clicking

Ans:1 – c ,1 – c


. Which of the following options is NOT a part of an option group?
Options: a. Option button label b. Option group frame c. Option group label d. Option group button

Ans:– d,– d


In which way(s) can a macro processor for assembly language be implemented?
Options: independent two-pass processor,    independent one-pass processor,    processor incorporated into pass of a standard two-pass assembler,    All of the above

Ans:D ,D


Synchronous protocols
Options: transmit characters one at a time,    allow faster transmission than asynchronous protocols do,    are generally used by personal computers,    are more reliable

Ans:B ,B


Which of the following functions is/ are performed by the loader?
Options: Allocate space in memory for the programs and resolve symbolic references between object decks,    Physically place the machine instructions and data into memory,    Adjust all address dependent locations, such as address constants, to correspond to the allocated space,    All of the above

Ans:D ,D


The term scheme means
Options: the relationship service bureau,    a map of overall structure of a database.,    a parent with no owners,    two dimensional table

Ans:B ,B


Which of the following TCP/IP protocol allows an application program on one machine to send a datagram to an application program on another machine?
Options: UDP,    VMTP,    X.25,    SMTP

Ans:A ,A


Which of the following is not a way to complete a cell entry?
Options: a. Pressing enter b. Pressing any arrow key on the keyboard c. Clicking the Enter button on the Formula bar d. Pressing spacebar

Ans:8211; d,8211; d


Which protocol does DHCP use at the Transport layer?
Options: IP,    TCP,    UDP,    ARP

Ans:C ,C


In Cisco's Unified Wireless Solution, what is the split-MAC architecture?
Options: The split-MAC architecture uses MAC addresses to create a forward/filter table and break up collision domains.,    The split-MAC architecture allows the splitting of 802.11 protocol packets between the AP and the controller to allow processing by both devices.,    The split-MAC architecture uses MAC addresses on the wireless network and IP addresses on the wired network.,    The split-MAC architecture uses MAC addresses to create a forward/filter table and break up broadcast domains.

Ans:B ,B


To duplicate a controls formatting you can use___
Options: a. Manager b. Wizard c. Painter d. Control

Ans:ndash; c,ndash; c


. Which of the following is not a valid size of a Floppy Disk?
Options: A) 8? B) 5 ¼? C) 3 ½? D) 5 ½?

Ans:D,D


A chart comprised of bars, each representing a period of time, is called a
Options: cent chart,    gault chart,    gantt chart,    grand chart

Ans:C ,C


Which is the first compiler-level language developed by a team of IBM programmers led by John Backus and unveiled in 1957?
Options: BASIC,    PL/1,    FORTRAN,    APL

Ans:C ,C


The strategy for eliciting information regarding the user's requirements is (are)
Options: asking questions,    obtaining information from the present system,    prototyping,    All of the above

Ans:D ,D


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


52. Ctrl + B
Options: a. Search the selected text b. Paste the selected text c. Bold the selected text d. Open the specified file

Ans:–  C ,–  C


. Before moving a subdocument to another location within a master document, you must switch to _________
Options: a. Normal View b. Outline View c. Web Layout View d. Print Layout View

Ans: –  B , –  B


How many primary partitions can exist on one drive?
Options: 16,    4,    2,    1

Ans:B ,B


. A page fault occurs when
Options: a. the Deadlock happens b. the Segmentation starts c. the page is found in the memory d. the page is not found in the memory

Ans: d, d


In order to edit a chart, you can
Options: a. Triple click the chart object b. Click and drag the chart object c. Double click the chart object d. Click the chart object

Ans: – C , – C


. Which of the following syntax is correct regarding to SUM function in Excel?
Options: =SUM (A1, B1) B. =SUM (A1:B9) C. =SUM (A1:A9, B1:B9) D. All of the above

Ans:– D ,


Which of the following can store information in the form of microscopic pits on metal disks.
Options: Laser disks,    Tape cassettes,    RAM cartridge,    Punched cards

Ans:A ,A


. Floppy disks are available in

Options: A) Single side single density B) Single side double density C) Both of above D) None of above

Ans:C,C


A static jolt of as little of _____ volts can fry most any PC integrated circuit.
Options: 200,    30,    1000,    200

Ans:B ,B


_______ provides a connection-oriented reliable service for sending messages
Options: TCP B. IP C. UDP D. All of the above

Ans:– A ,


Who launched IBM's First PC in 1981?
Options: Dean Cline,    C.B. Rogers Jr.,    John F. Akers,    David Svenson

Ans:B ,B


The two functional areas concerned with material flow are
Options: production and marketing,    manufacturing and purchasing,    marketing and finance,    manufacturing and finance

Ans:A ,A


The register which holds the address of the location to or from which data are to be transferred is known as
Options: index register,    instruction register,    memory address register,    memory data register

Ans:C ,C


While working with MS-DOS, which command will you use to display the version?
Options: DATE Command,    VER Command,    DISK Command,    FORMAT Command

Ans:B ,B

www.000webhost.com