Which elements of a worksheet can be protected from accidental modification?


Options: Contents B. Objects C. Scenarios D. All of the above

Ans:– D ,


Description: mcqquestions

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

Hits Today: 9287 | Level: Moderate


******************************************************

Want to see where do you stand among other aspirants in "Computer" category?

Click Here to take quick 10 mins MCQ test to find out.




Got some suggestion about this question or to make this site better? Please leave your comments below.




More MS-Excel Related questions:


An information processor includes
Options: the data base and the model base,    the central processing unit,    incoming data and outgoing information,    incoming data, the central processing unit, the model base, outgoing information, and the data base

Ans:D ,D


Most current PC CAD systems are used for producing:
Options: solids modeling,    2-D drawings,    circuit simulation,    finite element analysis

Ans:B ,B


The HAVING clause does which of the following?
Options: Acts like a WHERE clause but is used for groups rather than rows.,    Acts like a WHERE clause but is used for rows rather than columns.,    Acts like a WHERE clause but is used for columns rather than groups.,    Acts EXACTLY like a WHERE clause.

Ans:A ,A


What will be the output of the program (sample.c) given below if it is executed from the command line? cmd> sample "*.c" /* sample.c */ #include<stdio.h> int main(int argc, int *argv) { int i; for(i=1; i<argc; i++) printf("%s\n", argv[i]); return 0; }
Options: *.c,    "*.c",    sample *.c,    List of all files and folders in the current directory

Ans:A ,A


When connecting two internal SCSI hard disks to a computer, where do you connect the second hard drive?
Options: Any open SCSI port on the computer,    A Serial port on the first host adapter,    An open parallel port on the computer,    An open SCSI port on the first hard drive

Ans:A ,A


How much space in minimum must be provided between columns?
Options:  A) 0", B) 0.5", C) 1", D) 1.5", 

Ans:-A,-A


Which is the acronym for Algol extended for design.
Options: AFIPS,    ADP,    AED,    CAI

Ans:C ,C


What keystroke will terminate setup mode?
Options: Ctrl+Z,    Ctrl+^,    Ctrl+C,    Ctrl+Shift+^

Ans:C ,C


. Command Interpreter is also known as
Options: a. Prompt b. Shell c. Command d. DOS Prompt

Ans:0 – b ,0 – b


You are working on a router that has established privilege levels that restrict access to certain functions. You discover that you are not able to execute the command show running-configuration. How can you view and confirm the access lists that have been applied to the Ethernet 0 interface on your router?
Options: show access-lists,    show interface Ethernet 0,    show ip access-lists,    show ip interface Ethernet 0

Ans:D ,D


Which generation of computer is still under development
Options: A) Fourth Generation B) Fifth Generation C) Sixth Generation D) Seventh Generation

Ans:-B,-B


. In Computer System Memory management operations are performed by
Options: User B. Hardware       C. Programmer D. Operating system

Ans:– D ,


In a transistor operates at the middle of the load line, an increase in the base resistance will move the Q point
Options: down,    up,    nowhere,    off the load line

Ans:A ,A


ART (Automatic Reasoning Tool) is designed to be used on:
Options: LISP machines,    personal computers,    microcomputers,    All of the above

Ans:A ,A


When did Hewlett-Packard Inc. Introduce its first HP-110 laptop computer?
Options: 1984,    1986,    1990,    1995

Ans:A,A


If the values Earliest time and Latest time of an event are not equal then such events are referred to as:
Options: critical,    optimum,    non-critical,    All of the above

Ans:C ,C


18. Which command is used to delete all the files extension .txt on the current drive and directory?
Options: a. Del .txt b. Erase .txt c. Del *.txt d. Del *.*/p

Ans:Correct Answer: c ,Correct Answer: c


. An error in software or hardware is called a bug. What is the alternative computer jargon for it?
Options: A) Leech B) Squid C) Slug D) Glitch

Ans:D,D


System generation:
Options: is always quite simple,    is always very difficult,    varies in difficulty between systems,    requires extensive tools to be understandable

Ans:C ,C


How many JDBC driver types does Sun define?
Options: One,    Two,    Three,    Four

Ans:D ,D


8. Which type of command in DOS needs additional files for their execution?
Options: a. Internal commands b. External commands c. Batch commands d. Redirectors

Ans:Correct Answer: b,Correct Answer: b


The symbols used in describing the syntax of a programming language are
Options: 0,    {},    "",    <>

Ans:D ,D


You are testing the resistance in Ohms of a fuse on a 15K amp system. If the fuse is good, the meter should read?
Options: 0.0,    0.2,    5.0,    2.0

Ans:A ,A


Telecommunication networks frequently interconnect an organization with its customers and suppliers. Select the best fit for answer:
Options: Bandwidth alternatives,    Switching alternating,    Inter organizational networks,    Extranets

Ans:C ,C


Which indent marker controls all the lines except first line?
Options:  A) First Line Indent Marker, B) Left Indent Marker, C) Hanging Indent Marker, D) Right Indent Marker,

Ans:-B,-B


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


A computer with CPU speed around 100 million instructions per second & with the word length of around 64 bits is known as
Options: Super computer,    Mini computer,    Micro computer,    Micro computer

Ans:A ,A


Which language has been selected as the basis for the Japanese "fifth generation" computers.
Options: ALGOL,    COBOL,    PROLOG,    C

Ans:C ,C


A device designed to read information encoded into a small plastic card is
Options: Magnetic tape,    Badge reader,    Tape puncher,    Card puncher

Ans:B,(Banswer


Which programming language is much in vogue among users of microcomputers
Options: ALGOL,    APL,    LOGO,    FORTH

Ans:D ,D


The primary advantage of key-to-tape data-entry systems is:
Options: A large percentage of editing can be performed at the time of data entry,    Key verification is easily performed,    The tape is reusable,    Keying errors can be detected as they occur

Ans:C ,C


A storage system for small amounts of data is
Options: Magnetic card,    Magnetic tape,    Punched card,    Optical mark reader

Ans:A ,A


Which of the following is valid SQL for an Index?
Options: CREATE INDEX ID;,    CHANGE INDEX ID;,    ADD INDEX ID;,    REMOVE INDEX ID;

Ans:A ,A


The average time necessary for the correct sector of a disk to arrive at the read write head is _____
Options: Down time,    Seek time,    Rotational delay,    Access time

Ans:C,(Canswer


. Who is called a supervisor of computer activity?
Options: a. Memory b. Operating System c. I/O Devices d. Control Unit

Ans:5 – b ,5 – b


The pieces of equipment which are attached to the CPU of a computer and which it can access are called
Options: output devices,    control units,    hardware,    disk drive

Ans:E ,E


How will you free the allocated memory ?
Options: remove(var-name);,    free(var-name);,    delete(var-name);,    dalloc(var-name);

Ans:B ,B


. Home Key
Options: Moves the cursor beginning of the document B. Moves the cursor beginning of the paragraph C. Moves the cursor beginning of the screen D. Moves the cursor beginning of the line

Ans:– D ,


What will be the output of the program? #include<stdio.h> int main() { typedef float f; static f *fptr; float fval = 90; fptr = &fval; printf("%f\n", *fptr); return 0; }
Options: 9,    0,    90.000000,    90

Ans:C ,C


Customer data (name and address, shipping instructions, credit terms, etc.) is provided by the:
Options: manufacturing information system,    order entry subsystem,    billing subsystem,    marketing information system

Ans:C ,C


Operations Research came into being due to:
Options: medical reasons,    military reasons,    educational reasons,    to improve transportation

Ans:B ,B


Versatile report generators can provide
Options: Columnar totals,    Subtotals,    Calculations,    All of the above

Ans:D ,D


What is the term used to describe addresses available on a DHCP server?
Options: Pools,    Scopes,    Ranges,    Notes

Ans:B ,B


A Database Management System (DBMS) is
Options: Collection of interrelated data B. Collection of programs to access data C. Collection of data describing one particular enterprise D. All of the above

Ans:– D ,


In a worksheet you can select
Options: a. The entire worksheet b. Rows c. Columns d. All of the above

Ans:#8211; b,#8211; b


The MIS should be developed by
Options: the manager,    the information specialist,    both (a) and (b),    neither a or b

Ans:C ,C


Which of the following are not likely to be found on a PC main circuit board
Options: RAM chips,    Microprocessor chips,    ROM chips,    LCD clocks

Ans:D ,D


You can show the shortcut menu during the slide show by
Options: a. Clicking the shortcut button on the formatting toolbar b. Right clicking the current slide c. Clicking an icon on the current slide d. a and b

Ans: – B , – B


A secondary key is which of the following?
Options: Nonunique key,    Primary key,    Useful for denormalization decisions,    Determines the tablespace required

Ans:A ,A


Personnel activity reports are produced from the
Options: personnel transactions file,    employee file,    applicant file,    jobs files

Ans:A ,A

www.000webhost.com