Which setting you must modify to print a worksheet using letterhead?


Options: Paper B. Margin C. Layout D. Orientation

Ans:– B ,


Description: mcqquestions

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

Hits Today: 19135 | 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 instruction steps, would be written within the diamond-shaped box, of a flowchart?
Options: S = B - C,    IS A<10,    PRINT A,    DATA X,4Z

Ans:B ,B


The complexity of Bubble sort algorithm is
Options: A)O(n) b.O(log n) c.O(n2) d.O(n log n)

Ans:C, O(n2)


What could cause a fixed disk error.
Options: No-CD installed,    bad ram,    slow processor,    Incorrect CMOS settings

Ans:D ,D


The 2's complement number of 110010 is
Options: 001101,    110011,    010011,    All of the above

Ans:E ,E


Current is measured in units of:
Options: volts,    amps,    ohms,    farads

Ans:B ,B


When inorder traversing a tree resulted E A C K F H D B G; the preorder traversal would return
Options: a. FAEKCDBHG b. FAEKCDHGB c. EAFKHDCBG d. FEAKDCHBG

Ans: b, b


. Which is not utility program?
Options: a. Backup b. Scandisk c. Data recovery d. XCOPY

Ans:8 – d ,8 – d


Which best describes a fragmented hard drive?
Options: The platters are bad,    Data files are corrupted,    Clusters of data are damaged,    Files are not stored in consecutive clusters

Ans:D ,D


The keystrokes Ctrl + I is used to
Options:  A) Increase font size, B) Inserts a line break, C) Indicate the text should be bold, D) Applies italic format to selected text,

Ans:-D,-D


Where have the program and data to be located before the ALU and control unit of a computer can operate on it?
Options: Internal memory,    Secondary memory,    Microprocessor,    Magnetic tapes

Ans:A ,A


The first electronic general purpose digital computer built by Mauchly and Eckert called ENIAC did not work on the stored program principle. How many numbers could it store in its internal memory?
Options: 100,    20,    40,    80

Ans:B ,B


Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values?
Options: A domain constraint,    A range constraint,    An intrarelation constraint,    An interrelation constraint

Ans:A ,A


In OLE DB, a service provider:
Options: does not own data only.,    transforms data through OLE DB interfaces only.,    is both a consumer and a provider of data only.,    All of the above are true of an OLE DB service provider.

Ans:D ,D


The device that can both feed data into and accept data from a computer is
Options: ALU,    CPU,    Input-Output device,    All of the above

Ans:C ,C


Which of the following is not a factor affecting the processing capability or performance of a PC system?
Options: The clock speed of the microprocessor,    The revolutions per minute of the printer disk,    The primary storage capacity of the processor,    The built-in instruction set available to the microprocessor

Ans:B ,B


. Pick out odd
Options: a. Windows b. Window c. DOS d. Linux

Ans:5 – b ,5 – b


. Which of the following commands should you always use before submitting a document to others?
Options: a. find command b. Replace command c. Spelling and Grammar d. Thesaurus

Ans:–  C,–  C


A type of line printer that uses an embossed steel band to form the letters printed on the paper is
Options: Golf ball printer,    Dot-matrix printer,    Laser printer,    Band printer

Ans:D,D


Point out the error if any in the following program (Turbo C). #include<stdio.h> #include<stdarg.h> void display(int num, ...); int main() { display(4, 'A', 'a', 'b', 'c'); return 0; } void display(int num, ...) { char c; int j; va_list ptr; va_start(ptr, num); for(j=1; j<=num; j++) { c = va_arg(ptr, char); printf("%c", c); } }
Options: Error: unknown variable ptr,    Error: Lvalue required for parameter,    No error and print A a b c,    No error and print 4 A a b c

Ans:C ,C


SQL*Plus will finish the statement and execute it when the user types in this:
Options: A left slash ( \ ) followed by [Enter].,    A colon ( : ) followed by [Enter].,    A semicolon ( ; ) followed by [Enter].,    A period ( . ) followed by [Enter].

Ans:C ,C


Which WLAN IEEE specification allows up to 54Mbps at 2.4GHz?
Options: A,    B,    G,    N

Ans:C ,C


When a computer is first turned on or restarted, a special type of absolute loader is executed, called a
Options: "Compile and Go" loader,    Boot loader,    Bootstrap loader,    Relating loader

Ans:C ,C


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,    adjust all address dependent locations, such as address constants, to correspond to the allocated space.,    physically place the machine instructions and data into memory.,    All of the above

Ans:D ,D


What is the shortcut key for “Superscript ” the selected text?
Options: Ctrl + = B. Ctrl + – C. Ctrl + Shift + = D. Ctrl + Shift + –

Ans:– C ,


Scheduling is
Options: allowing jobs to use the processor,    unrelated to performance consideration,    not required in uniprocessor systems,    the same regard-less of the purpose of the system

Ans:A ,A


A _____ means that one record in a particular record type may be related to more than one record of another record type.
Options: One-to-one relationship,    One-to-many relationship,    Many-to-one relationship,    Many-to many relationship

Ans:B ,B


Which of the following range is a valid long double (Turbo C in 16 bit DOS OS) ?
Options: 3.4E-4932 to 1.1E+4932,    3.4E-4932 to 3.4E+4932,    1.1E-4932 to 1.1E+4932,    1.7E-4932 to 1.7E+4932

Ans:A ,A


Banker's algorithm for resource allocation deals with
Options: deadlock prevention,    deadlock avoidance,    deadlock recovery,    mutual exclusion

Ans:B ,B


Cost-Benefit analysis
Options: evaluates the tangible and non-tangible factors,    compares the cost, with the benefits, of introducing a computer-based system,    estimates the hardware and software costs,    All of the above

Ans:D ,D


Which of the following uses network address translation?
Options: Routers,    Network adapter drivers,    Hubs,    Windows 95

Ans:B ,B


In SQL, which command is used to add a column/integrity constraint to a table
Options: ADD COLUMN,    INSERT COLUMN,    MODIFY TABLE,    ALTER TABLE

Ans:D ,D


. The command center of access file that appears when you create or open the MS Access database file.
Options: a. Database window b. Query window c. Design view window d. Switchboard

Ans:8 – a ,8 – a


13. Which of the following operating does not implement multitasking truly?
Options: a. Windows 98 b. Windows NT c. Windows XP d. MS DOS

Ans:Correct Answer: d,Correct Answer: d


A device that converts one type of signal into another is called
Options: Modem,    Transducer,    Punched paper tape,    Punched card

Ans:B ,B


A computer assisted method for the recording and analyzing of existing or hypothetical systems is
Options: Data transmission,    Data flow,    Data capture,    Data processing

Ans:B,(Banswer


Which of the following is two way list?
Options: a. grounded header list b. circular header list c. linked list with header and trailer nodes d. none of above  

Ans:d,d


. Regarding data, computers are very good at
Options: A) store B) Processing C) retrieve D) All of above

Ans:D,D


How can you quickly reinstate a deleted footer placeholder in master view?
Options: a. Create a new slide master b. Re-apply the footer placeholder c. Re-apply the slide layout d. All of the above

Ans: – B , – B


What is the smallest and largest font size available in Font Size tool on formatting toolbar?
Options:  A) 8 and 72, B) 8 and 64, C) 12 and 72, D) None of above,

Ans:-A,-A


The transport layer protocol is connectionless.
Options: NVT,    FTP,    TCP,    UDP

Ans:D ,D


. Give me an example of a cell address.
Options: a. 11 25 b. 911 c. 41A d. A21

Ans:– d,– d


. What is the shortcut key to insert current date in a cell?
Options: CTRL + D B. CTRL + T C. CTRL + ; D. CTRL + /

Ans: – C ,


. Referential integrity means
Options: a. Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table b. Do not enter a value in the primary key field of chield table if that value does not exist in the primary key of the parent table c. Do not enter a value in the foreign key field of a parent table if that value does not exist in the primary key of the child table d. All of above

Ans:1 – a ,1 – a


Most important advantage of an IC is its
Options: Easy replacement in case of circuit failure,    Extremely high reliability,    Reduced cost,    Low power consumption

Ans:B ,B


. Which of the following is an essential file of a MS-DOS boot disk?
Options: a. COMMAND.COM b.START.COM c.TREE.COM d.VER.COM

Ans: a, a


.   Which of the following is not a way to create a new presentation?
Options: a. Using the Scan-In Slides feature b. From scratch (create a blank presentation c. Using a template d. Using the auto content wizard

Ans:6 – A ,6 – A


. To return the remainder after a number is divided by a divisor in EXCEL we use the function?
Options: a. ROUND ( ) b. FACT ( ) c. MOD ( ) d. DIV ( )

Ans:– c,– c


. Which of the following is a feature of fifth generation computers?
Options: A) Use of natural language B) artificial intelligence C) bio-chips D) All of above

Ans:D,D


19. Word is preset to use standard 8.5-by-11-inch paper with _____ margins.
Options: a. 1-inch left, right, top, and bottom b. 1.25-inch left, right, top, and bottom c. 1.25-inch left and right margins and 1-inch top and bottom d. 1-inch left and right margins and 1.25-inch top and bottom

Ans:– C ,– C


What is a brand?
Options: A) The name of companies that made computers B) The name of product a company gives to identify its product in market C) A name of class to indicate all similar products from different companies D) All of above

Ans:-B,-B

www.000webhost.com