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: 14524






More MS-Excel Related questions:


. Which is not a valid file system?
Options: a. FAT 16 b. FAT 32 c. NTFS d. FXZ

Ans:5 – d ,5 – d


In LISP, the function evaluates <object> and assigns this value to the unevaluated <sconst>.
Options: (constant <sconst> <object>),    (defconstant <sconst> <object>),    (eva <sconst> <object>),    (eva <object> <sconst>)

Ans:B ,B


If both data and database administration exist in an organization, the database administrator is responsible for which of the following?
Options: Data modeling,    Database design,    Metadata,    All of the above.

Ans:B ,B


. Which is an item of storage medium in the form of circular plate?

Options: A) Disk B) CPU C) Printer D) ALU

Ans:A,A


What will be the output of the program? #include<stdio.h> int main() { int X=40; { int X=20; printf("%d ", X); } printf("%d\n", X); return 0; }
Options: 40 40,    20 40,    20,    Error

Ans:B ,B


A group of 2m - 1 routers are interconnected in a centralized binary tree, with router at each tree node. Router I communicate with router J by sending a message to the root of the tree. The root then sends the message back down to J. Then find the mean router-router path length.
Options: 2 (m - 2),    2 (2m - 1),    m - 1,    (2m - l)/mJ

Ans:A ,A


The language used application programs to request data from the DBMS is referred to as the
Options: a. DML b. DDL c. query language d. any of the above

Ans:.a,.a


13. Which command can be used to create the disk’s tracks and sectors?
Options: a. Fdisk b. Format c. Chkdsk d. Attrib

Ans:Correct Answer: b ,Correct Answer: b


. The command to display the contents of a file fast.it
Options: a. TYPE it fast b. COPY fast.it CON c. COPY CON fast.it d. None of above

Ans:3 – c ,3 – c


What command can be used to get information about yourself?
Options: which,    pwd,    i /4,    who am i

Ans:D ,D


In which mode can two 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 special symbol allowed in a variable name?
Options: * (asterisk),    | (pipeline),    - (hyphen),    _ (underscore)

Ans:D ,D


You can convert existing excel worksheet data an charts to an HTML document by using
Options: a. FTP wizard b. Internet assistant wizard c. Intranet wizard d. Import wizard

Ans:#8211; b,#8211; b


In a document what is the maximum number of columns that can be inserted in MS Word Table?
Options:  A) 35, B) 15, C) 63, D) 65, 

Ans:-C,-C


Which of the following is not a key component of the evaluation process in building a DSS?
Options: criteria for evaluation,    means of measuring system-development time spent on the project,    means of monitoring the progress of the DSS,    formal review process

Ans:B ,B


By default, your document prints with:
Options: 1 inch top and bottom margins B. a portrait orientation C. 1.25 inches left and right margins D. all of the above

Ans:D,


A reflective marker that indicates the end of the usable tape is
Options: End user,    End-of-tape,    Optical mark reader,    FAX

Ans:B ,B


In which addressing mode the contents of a register specified in the instruction are first decremented, and then these contents are used as the effective address of the operands?
Options: index addressing,    indirect addressing,    auto increment,    auto decrement

Ans:D ,D


While working with MS-DOS, which command is used to specify the size of the disk to format.
Options: FORMAT/F : size,    FORMAT/N : sector,    FORMAT/T : tracks,    FORMAT/V

Ans:A ,A


Needing to assess the validity of assumed referential integrity constraints on foreign keys is a(n) ________ of normalization.
Options: advantage,    disadvantage,    either an advantage or disadvantage,    neither an advantage nor disadvantage

Ans:D ,D


The complete information about an entity in a database is called
Options: a. Data b. Information c. Field d. Record

Ans:ndash; d,ndash; d


Microsoft Excel is a powerful………..
Options: Word processing package B. Spreadsheet package C. Communication S/W Package D. DBMS package

Ans:– B ,


Which of the following elements can be used with a TI510 FC?
Options: Drum timer,    Metronome,    Cymbal timer,    Flashing light

Ans:A ,A


In an absolute loading scheme, which loader function is accomplished by loader?
Options: Reallocation,    Allocation,    Linking,    Loading

Ans:D ,D


. You have field ‘Sex’ of type Byte Number. How to limit its value to 0 and 1 only?
Options: a. By setting required to ‘Yes’ b. By using default value c. By defining validation rule d. By using format

Ans:– c,– c


1024 bytes represent a
Options: Megabyte,    Gigabyte,    Kilobyte,    None of the above

Ans:C ,C


A _____ decision is routine one that's made following the completion of a preplanned series of steps.
Options: strategic,    structured,    simulation,    tactical

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


Which standard govern parallel communications?
Options: RS232,    RS-232a,    CAT 5,    IEEE 1284

Ans:D ,D


A number which is stored and processed but not in the standard exponential form is called
Options: Floating point number,    Fixed point number,    Octal number,    Decimal number

Ans:B,(Banswer


Which of the following applies to external DOS commands?
Options: External commands reside in RAM until called,    External commands are stored on disk separately from COMMAND.COM,    External commands must always be used with the /e switch,    External commands can only be executed from a batch file.

Ans:B ,B


To _____ is to decide in advance on a course of action.
Options: master,    decision,    plan,    control

Ans:C ,C


.   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


The complexity of the average case of an algorithm is
Options: a. Much more complicated to analyze than that of worst case b. Much more simpler to analyze than that of worst case c. Sometimes more complicated and some other times simpler than that of worst case d. None or above  

Ans:a,a


After searching the current directory where does command.com search next?
Options: C:\DOS\UTILITIES,    Config.sys,    Autoexec.bat,    The Path Statement

Ans:D ,D


Which device is used to backup the data?
Options: Floppy Disk B. Tape C. Network Drive D. All of the above

Ans:– D ,


What is the initial value of the semaphore to allow only one of the many processes to enter their critical section?
Options: 8,    1,    16,    0

Ans:B ,B


Which of the following creates a drop down list of values to choose from a list?
Options: a. OLE Object b. Hyperlink c. Memo d. Lookup Wizard

Ans:ndash; d,ndash; d


The essential features of a number system are
Options: Radix,    Set of distinct counting digits,    bits,    Both (a) & (b)

Ans:D ,D


The most common systems security method is
Options: passwords,    encryption,    firewall,    all of the above

Ans:A ,A


What would you ask to determine if the display is working?
Options: Is there a video cursor or action on the screen?,    Did the computer beep or chime?,    Is there high voltage static on the screen,    All of the above

Ans:D ,D


If a table has been normalized so that all determinants are candidate keys, then that table is in:
Options: 1NF.,    2NF.,    3NF.,    BCNF.

Ans:D ,D


Which DOS driver is used to emulate expanded memory?
Options: Himem.sys,    EMM386.exe,    Mem386.sys,    Ramdrive.sys

Ans:B ,B


What does the passive command provide to dynamic routing protocols?
Options: Stops an interface from sending or receiving periodic dynamic updates.,    Stops an interface from sending periodic dynamic updates but not from receiving updates.,    Stops the router from receiving any dynamic updates.,    Stops the router from sending any dynamic updates.

Ans:B ,B


The background and experience of analyst include;
Options: a background in systems theory and organization behavior,    familiarity with the makeup and inner workings of major application areas such as financial accounting, personnel administration, marketing and sales, operations management, model building, and production control.,    competence in system tools and methodologies and a practical knowledge of one or more programming and data base languages.,    All of the above

Ans:D ,D


Which of the following terminals' output most closely resembles the output produced by a plotter?
Options: graphics terminal,    POS terminal,    hardcopy terminal,    all the above

Ans:A,A


Intranets and extranets can use their network fire walls and other security features to establish secure Internet links within an enterprise or with its trading partners. Select the best fit for answer:
Options: Network Server,    Virtual Private Network,    Network operating system,    OSI

Ans:B ,B


. Where a row and a column meet, what do you call that?
Options: a. A cell b. A block c. A box d. None of the above

Ans:– a,– a


. Edit >> Delete command
Options: a.  Deletes the content of a cell b.  Deletes Formats of cell c.  Deletes the comment of cell d.  Deletes selected cells

Ans:– d,– d


. What is the number of read-write heads in the drive for a 9-trac magnetic tape?
Options: A) 9 B) 16 C) 18 D) 27

Ans:A,A

www.000webhost.com