Which of the following is not a valid data type in Excel?


Options: Number B. Character C. Label D. Date/Time

Ans:– B ,


Description: mcqquestions

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

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


The logic gate that will have HIGH or "1" at its output when any one of its inputs is HIGH is a(n):
Options: OR gate,    AND gate,    NOR gate,    NOT gate

Ans:A ,A


When did arch rivals IBM and Apple Computers Inc. decide to join hands?
Options: 1978,    1984,    1990,    1991

Ans:D ,D


What happens when you insert an AutoShape by simply clicking in the document?
Options: it appears near the insertion point B. it is inserted in its default size C. is selected D. all of the above

Ans: – C ,


Which of the following is used for modulation and demodulation?
Options: modem,    protocols,    gateway,    multiplexer

Ans:A ,A


The difference between a high-technology and a medium-technology robot is the:
Options: speed of movement,    range of motion of the robot,    accuracy of the robot,    complexity of the task it can perform.

Ans:D ,D


. Ctrl + J
Options: Align Justify B. Insert Hyperlink C. Search D. Print

Ans: – A ,


Physical connection between Microprocessor Memory and other parts is called _________
Options: A. Path B. Hub C. Address bus D. None of the above

Ans:C,


Impact printers
Options: strike a ribbon against the paper to produce character images,    include ink-jet and thermal devices,    are more expensive than Laser printers,    use optical technology

Ans:A ,A


A turnkey package includes
Options: software,    hardware,    training,    All of the above

Ans:D ,D


A transformer has a primary voltage of 120 V rms and a secondary voltage of 25 V rms. If the secondary current is 1A rms, what is the primary current?
Options: 7.8 mA,    208 mA,    200 mA,    300 mA

Ans:B ,B


. When you add fields in ____, a Field List pane displays.
Options: a. Design View b. Layout View c. Print Preview d. Report View

Ans:0 – b ,0 – b


Benefits from a computerised MIS include:
Options: higher returns on short-term investments,    less frequent and smaller short-term loans,    lower rates of interest,    All of the above

Ans:D ,D


What will be the output of the program in Turb C (under DOS)? #include<stdio.h> int main() { int arr[5], i=0; while(i<5) arr[i]=++i; for(i=0; i<5; i++) printf("%d, ", arr[i]); return 0; }
Options: 1, 2, 3, 4, 5,,    Garbage value, 1, 2, 3, 4,,    0, 1, 2, 3, 4,,    2, 3, 4, 5, 6,

Ans:B ,B


Which of the following statements is correct for the use of packet switching?
Options: the subdivision of information into individually addressed packets in conjunction with alternative routing arrangement enabled the transmission path to be altered in the event of congestion or individual link failure,    the employment of additional intelligence within the network enabled more sophisticated error control and link control procedures to be applied,    by employing wide bandwidth circuits for the trunk networks substantial economies through extensive sharing of capacity could be achieved.,    All of the above

Ans:D ,D


A global network of millions of business, government, educational, and research networks; computer systems; database; and end users. Select the best fit for answer:
Options: Internet works,    The Internet,    Internet revolution,    Internet technologies

Ans:B ,B


.   Which types of fonts are best suitable for titles and headlines
Options: a. serif fonts b. sans serif fonts c. text fonts d. picture fonts

Ans:3 – B ,3 – B


Which program is used to schedule particular jobs or programs at particular times on the system?
Options: vi,    Outlook,    Scheduler,    cron

Ans:D ,D


In LISP, the function returns the list that results after the first element is removed (the rest f the list), is
Options: car,    last,    cons,    cdr

Ans:D ,D


. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
Options: Logical B. Math & Trigonometry C. Statistical D. Financial

Ans: – D ,


You type show running-config and get this output: [output cut] Line console 0 Exec-timeout 1 35 Password BIXPASSWD Login [output cut] What do the two numbers following the exec-timeout command mean?
Options: If no command has been typed in 35 seconds, the console connection will be closed.,    If no router activity has been detected in 1 hour and 35 minutes, the console will be locked out.,    If no commands have been typed in 1 minute and 35 seconds, the console connection will be closed.,    If you're connected to the router by a Telnet connection, input must be detected within 1 minute and 35 seconds or the connection will be closed.

Ans:C ,C


. A factor which would strongly influence a business person to adopt a computer is its

Options: A) Accuracy B) Reliability C) Speed D) All of above

Ans:D,D


  What does “apply design template” do?
Options: Changes the content of the slide B. Adds functionality to the slide C. Changes the look of the slide without changing the content D. None of the above

Ans:– C ,


Program execution time would be minimum if the programs are written in
Options: Machine Language,    Assembly language,    High level language,    All of the above

Ans:A ,A


Which computer has been designed to be as compact as possible?
Options: Mini,    Super computer,    Micro computer,    Mainframe

Ans:C ,C


Data security threats include
Options: hardware failure,    privacy invasion,    fraudulent manipulation of data,    All of the above

Ans:B ,B


hich of the following is not the Section Break Option?
Options: Next Page B. Previous Page C. Odd Page D. Even Page

Ans:– B ,


Which of the following is a type of preventative maintenance used on a hard drive?
Options: Disk check diagnostics,    Head alignment diagnostics,    Initializing,    Uninstalling programs

Ans:A ,A


The dialogue techniques for terminal use do not include
Options: questions and answers,    open-ended questions,    form fillings,    menu display

Ans:B ,B


36. When typing in a word field manually, what must you press to insert the code’s braces?
Options: a. Ctrl + F6 b. Ctrl + F9 c. Alt + F11 d. Shift + F12

Ans:–  B ,–  B


An important first step in troubleshooting which component in a laser printer is causing a jam is to:
Options: note where in the paper path the paper stops,    check all voltages,    look up error codes,    turn the printer off, then on again

Ans:A ,A


What will be the output of the program? #include<stdio.h> #define MAX(a, b, c) (a>b ? a>c ? a : c: b>c ? b : c) int main() { int x; x = MAX(3+2, 2+7, 3+7); printf("%d\n", x); return 0; }
Options: 5,    9,    10,    3+7

Ans:C ,C


What two multicast addresses does OSPFv3 use? FF02::A FF02::9 FF02::5 FF02::6
Options: 2 only,    3 only,    1 and 3,    3 and 4

Ans:D ,D


. An error in computer data is called
Options: A) Chip B) Bug C) CPU D) Storage device

Ans:6-B,6-B


Which is NOT typically a Field Replaceable Unit?
Options: System ROM,    Power supply,    System chasis,    Video controller

Ans:C ,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


The Storage-to-Storage instructions
Options: have both their operands in the main store.,    which perform an operation on a register operand and an operand which is located in the main store, generally leaving the result in the register, expect in the case of store operation when it is also written into the specified storage location.,    which perform indicated operations on two fast registers of the machine and have the result in one of the registers,    all of the above

Ans:A ,A


.   The quickest way to create a PowerPoint presentation is to use the
Options: a. Word for windows templates b. Auto creation wizard c. Auto content wizard d. Presentation wizard

Ans:7 – C ,7 – C


What will be the output of the program? #include<stdio.h> int main() { int i; i = scanf("%d %d", &i, &i); printf("%d\n", i); return 0; }
Options: 1,    2,    Garbage value,    Error: cannot assign scanf to variable

Ans:B ,B


. A real time operating system is most likely to be used for which of the following task?
Options: a. Controlling access to a shared printer in a network b. Ensuring that system clock works correctly on server c. Managing the access to system files in a laptop computers d. Controlling the fuel injection system of an automobile engines

Ans:1 – d ,1 – d


The systems conversion technique of totally removing the existing system and immediately implementing the new system is called a
Options: pilot conversion,    crash conversion,    phased conversion,    parallel run

Ans:B ,B


. Press ____ key while booting to display Advanced Boot Menu
Options: a. F5 b. F6 c. F8 d. Del

Ans:8 – c ,8 – c


. The handout master contains placeholders for all of the following except
Options: a. Slide number b. Title c. Footer d. Header

Ans:9 – B ,9 – B


. You created a query with two tables that did NOT have a join line. The first table has 12 records and the second has 5. The resulting recordset would have how many records?
Options: a. 7 b. 17 c. 60 d. Not enough information to tell

Ans:5 – c ,5 – c


. Registers which are partially visible to users and used to hold conditional codes (bits set by the CPU hardware as the result of operations), are known as
Options: A) PC B) Flags C) Memory Address Registers D) General Purpose Registers

Ans:B,B


A subquery in an SQL SELECT statement is enclosed in:
Options: braces -- {...}.,    CAPITAL LETTERS.,    parenthesis -- (...) .,    brackets -- [...].

Ans:C ,C


If communication software can be called the "traffic cop" of a micro communication system, then what should the modem be called?
Options: Park,    Bridge,    Interface,    Link

Ans:B ,B


Vision sensors:
Options: will remain very costly,    can not improve much in the next decade,    will more closely match the capabilities of the human eye,    All of the above

Ans:C ,C


. The _____ Builder is an Access tool for selecting colors from a palette or creating custom colors.
Options: a. Color b. Expression c. Palette d. Property

Ans:5 – a ,5 – a


A specific part of an arithmetic & logic unit that is used to perform the operation of multiplication is
Options: Multiplier,    Multiplener,    Multivibrator,    Quantization

Ans:A ,A


What will be the output of the program in 16-bit platform (under DOS)? #include<stdio.h> int main() { struct node { int data; struct node *link; }; struct node *p, *q; p = (struct node *) malloc(sizeof(struct node)); q = (struct node *) malloc(sizeof(struct node)); printf("%d, %d\n", sizeof(p), sizeof(q)); return 0; }
Options: 2, 2,    8, 8,    5, 5,    4, 4

Ans:A ,A

www.000webhost.com