If you want to have a blank line after the title in a worksheet, what is the best thing for you to do?


Options: Re-format the spreadsheet B. Insert a row C. Increase the column width D. Use the spacebar

Ans:– B ,


Description: mcqquestions

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

Hits Today: 12666 | 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:


Which of the following file organizations is most efficient for a file with a high degree of file activity?
Options: sequential,    ISAM,    VSAM,    B-Tree index

Ans:A ,A


Now-a-days computers all over the world can talk to each other. Which is one of the special accessories essential for this purpose?
Options: Keyboard,    Modem,    Scanner,    Fax

Ans:B ,B


All mathematical models generally comprise which of the following types of variables;
Options: uncontrollable variables,    dependent variables,    decision variables,    All of the above

Ans:D ,D


A generalised software package produced to meet the bugs of a variety of data processing users is known as
Options: Utility programs,    System software,    Operating system,    Application package

Ans:D ,D


What is the control units function in the CPU?
Options: a. To transfer data to primary storage b . to store program instruction c . to perform logic operations d . to decode program instruction

Ans:2.d,2.d


Which of the following is not Unary operation?
Options: Select B. Project C. Rename D. Union

Ans:– D ,


. In a computer _____ is capable to store single binary bit.
Options: A) Capacitor B) Flip flop C) Register D) Inductor

Ans:B,B


. A bar that inform you the available options in your computer, opened applications, background running applications and can be used to switch between applications quickly is
Options: a. Menu bar b. Tool bar c. Status bar d. Task bar

Ans: d, d


What flavor of Network Address Translation can be used to have one IP address allow many users to connect to the global Internet?
Options: NAT,    Static,    Dynamic,    PAT

Ans:D ,D


. Which types of charts can excel produce?
Options: a. Line graphs and pie charts only b. Only line graphs c. Bar charts, line graphs and pie charts d. Bar charts and line graphs only

Ans:– c,– c


What do the following declaration signify? int *f();
Options: f is a pointer variable of function type.,    f is a function returning pointer to an int.,    f is a function pointer.,    f is a simple declaration of pointer variable.

Ans:B ,B


In the following program how long will the for loop get executed? #include<stdio.h> int main() { int i=5; for(;scanf("%s", &i); printf("%d\n", i)); return 0; }
Options: The for loop would not get executed at all,    The for loop would get executed only once,    The for loop would get executed 5 times,    The for loop would get executed infinite times

Ans:D ,D


The central processor of a modern digital computer consists of
Options: control unit,    primary memory,    control unit and primary memory,    All of the above

Ans:C,C


. A floppy disk contains

Options: A) Circular tracks only B) Sectors only C) Both circular tracks and sectors D) None of the above

Ans:C,C


Three-tier architecture includes which of the following?
Options: Three server layers,    A client layer and two server layers,    Two client layers and one server layer,    Three client layers

Ans:B ,B


A Transportation Problem in which the total supply available at the origins exactly satisfies the total demand required at the destinations is known as:
Options: Degenerate Solution,    Balanced Transportation Problem,    Unbalanced Transportation Problem,    All of the above

Ans:B ,B


Top-down programming is
Options: a group of related fields,    a map of the programmer's view of the data,    an approach in which the top module is first tested then program modules are added from the highest level to the lowest level,    a series or group of components that perform one or more operations of a more complex system

Ans:C ,C


The most commonly used standard data code to represent alphabetical, numerical and punctuation characters used in Electronic Data Processing system is called
Options: ASCII,    EBCDII,    BCD,    All of the above

Ans:A ,A


Procedure development occurs within the
Options: structured design phase,    conversion phase,    system building phase,    maintenance

Ans:C ,C


Which of the following products implemented the CODASYL DBTG model?
Options: IDMS,    DB2,    dBase-II,    R:base

Ans:A ,A


You can use the format painter multiple times before you turn it off by
Options: a. You can use the format painter button on ly one time when you click it b. Double clicking the format painter button c. Pressing the Ctrl key and clicking the format painter button d. Pressing the Alt key and clicking the format painter button

Ans:#8211; b,#8211; b


What kind of battery is most likely included in a cordless electric knife?
Options: Zinc-carbon battery,    Mercury-cell battery,    Nicad battery,    Lead-acid battery

Ans:B ,B


A data element in a record, that uniquely distinguishes the record, from all other records, is called
Options: response time,    Key,    System review,    test data

Ans:B ,B


How can you define a field so that when entering data for that field it will display ****** instead of actual typed text
Options: a. Input mask b. Validation Rule c. Indexed d. IME Mode

Ans:ndash; a,ndash; a


Which layers of the OSI model are host-to-host layers?
Options: Transport, Session, Persentation, Application B. Network, Transport, Session, Presentation C. Datalink, Network, Transport, Session D. Physical, Datalink, Network, Transport

Ans:– A ,


.   to save a presentation you
Options: a. click save on the windows start button b. press Ctrl + F5 c. select File, Save from the menu d. click the saver button on the formatting toolbar

Ans:2 – C ,2 – C


. Which is NOT an option of the Picture Size Mode property?
Options: a. Clip b. Fit c. Stretch d. Zoom

Ans:7 – b ,7 – b


A memory that does not change its contents without external causes is known as
Options: Dynamic memory,    Static memory,    RAM,    EEPROM

Ans:B,(Banswer


If both inputs of an S-R NAND latch are LOW, what will happen to the output?
Options: The output would become unpredictable.,    The output will toggle.,    The output will reset.,    No change will occur in the output.

Ans:A ,A


RAM is used as a short memory because it is
Options: Volatile,    Has small capacity,    Is very expensive,    Is programmable

Ans:A,(Aanswer


. Which of the following function will use to find the highest number in a series of number?
Options: a. MAX(B1:B3) b. MAXIMUM (B1:B3) c. HIGH (B1:B3) d. HIGHEST(B1:B3)

Ans:– a,– a


To avoid errors in transcription and transposition, during data entry, the System Analyst should
Options: provide for a check digit,    provide for a hash totals,    provide batch totals,    All of the above

Ans:D ,D


. Which option allows you to Bold all the negative values within the selected cell range:
Options: Zero Formatting B. Conditional Formatting       C. Compare Formatting D. Negative Formatting

Ans:– B ,


. Another word for a daisy wheel printer
Options: A) Petal printer B) Golf ball printer C) Laser printer D) Line printer

Ans:B,B


The physical system of the firm may be regarded as a flow of
Options: manpower, machines, material, and money,    information only,    manpower, machines, material, money, and information,    manpower, machines, material, money, and data

Ans:A ,A


While working with MS-DOS, which command is used to compare the disk in drive A with the disk in drive B, specifying to compare only first side of each disk, and only the first 8 sectors of each track?
Options: DISKCOPY A: B:/8,    DISKCOMP A: B:/l/8,    DISKCOMP A: B:/8,    DISKCOMP A: B:/l

Ans:B ,B


. To edit an already inserted embedded organization chart object by
Options: a. Double Click on the organization chart object b. CTRL + Click on the organization chart object c. SHIFT + Click on the organization chart object d. None of the above

Ans:4 – A ,4 – A


If the following program (myproc.c) is present in the directory "C:\TC" then what will be output of the program if run it from DOS shell? /* myproc.c */ #include<stdio.h> int main(int argc, char *argv[]) { printf("%s", argv[0]); return 0; }
Options: SAMPLE.C,    C:\TC\MYPROC.EXE,    C:\TC,    Error

Ans:B ,B


The data appearing first in the left portion of punched card is
Options: descriptive data,    coded data,    quantitative data,    All of the above

Ans:B ,B


Which of the following is not a worksheet design criterion?
Options: a. Efficiency b. Aditibility c. Description d. Clarity

Ans:#8211; c,#8211; c


What command is used to summarize the disk usage?
Options: disk,    du,    fdisk,    chkdsk

Ans:B ,B


. It is acceptable to let long text flow into adjacent cells on a worksheet when
Options: a.  data will be entered in the adjecent cells b.  no data will be entered in the adjacent cells c.  there is no suitable abbrevition for the text d.  there is not time to format the text

Ans:– b,– b


You are about to install a second IDE hard drive in a PC that has only one IDE adapter. Your first hard drive will still be the boot drive. How should the second drive be configured?
Options: as a master,    as a secondary,    as a slave,    as a primary

Ans:C ,C


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


If you want to organize a file in multiple ways, it is better to _____ the data rather than to sort it.
Options: Delete,    Update,    Sort Key,    Index

Ans:D ,D


The instruction register
Options: is a hardware memory device which denotes the location of the current instruction being executed.,    is a group of electrical circuits (hardware), that performs the intent of instructions fetched from memory.,    contains the address of the memory location that is to be read from or stored into.,    contains a copy of the designated memory location specified by the MAR after a "read" or the new contents of the memory prior to a "write".

Ans:B ,B


Adding a new account to the chart of accounts at the beginning of an accounting period is a
Options: simple revision,    moderately complex revision,    complex revision,    All of the above

Ans:B ,B


If the memory slots have 30 pins then the chip is a?
Options: DIMM,    SIMM,    SDRAM,    All of the above

Ans:B ,B


Which of the following statements are true regarding the command ip route 172.16.4.0 255.255.255.0 192.168.4.2? The command is used to establish a static route. The default administrative distance is used. The command is used to configure the default route. The subnet mask for the source address is 255.255.255.0.
Options: 1 and 2,    2 and 4,    3 and 4,    All of the above

Ans:A ,A


You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
Options: a. Pie chart b. Row chart c. Line chart d. Column chart

Ans:#8211; c,#8211; c

www.000webhost.com