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: 17920 | 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 word 'Computer' usually refers to the Central Processor Unit plus
Options: External memory,    Internal memory,    Input devices,    Output devices

Ans:B ,B


Which one of the following statements best applies to a series RLC circuit?
Options: The voltage waveform for each component always has the same amplitude and phase as the applied voltage,    The current waveform for each component always has the same amplitude and phase as the applied current,    All of the above,    The sum of the current is always less than the applied current

Ans:B ,B


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


In SQL, which command(s) is(are) used to enable/disable all triggers on a table?
Options: ALTER TRIGGERS,    ALTER TABLE,    MODIFY TRIGGERS IN TABLE,    All of the above

Ans:B ,B


  Which option can be used to create a new slide show with the current slides but presented in a different order?
Options: Rehearsal B. Custom Slide show C. Slide Show Setup D. Slide Show View

Ans:– B ,


Which of the following is not one of the stages in the evolution of distributed DBMS?
Options: Unit of work,    Remote unit of work,    Distributed unit of Work,    Distributed request

Ans:A ,A


The third generation of computers covers the period:
Options: 1971-1982,    1982-1994,    1959-1964,    1965-1971

Ans:D ,D


Operational budgeting require how many data files that would not otherwise be needed?
Options: 3,    2,    1,    0

Ans:D ,D


The access method used for cassette tape is
Options: Direct,    Random,    Sequential,    All of the above

Ans:C,C


. 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


X.21 is
Options: a method of determining which device has access to the transmission medium at any time,    a method access control technique for multiple-access transmission media,    a very common bit-oriented data link protocol issued by ISO,    network access standard for connecting stations to a circuit-switched network

Ans:D ,D


Which memory system is not as a mass memory medium?
Options: semiconductor memory,    magnetic tape,    magnetic disk,    magnetic drum

Ans:A ,A


. A Pixel is __________
Options:  A computer program that draws picture B.  A picture stored in secondary memory C.  The smallest resolvable part of a picture D.  None of these

Ans: – C ,


In LISP, the function evaluates both <variable> and <object> is
Options: set,    setq,    add,    eva

Ans:A ,A


What is the shortcut key to “Center Align ” the selected text?
Options: Ctrl + C B. Ctrl + E C. Ctrl + F D. None of above

Ans:– B ,


What is the size of Network bits & Host bits of Class A of IP address?
Options: Network bits 7, Host bits 24 B. Network bits 8, Host bits 24 C. Network bits 7, Host bits 23 D. Network bits 8, Host bits 23

Ans:– A ,


.   What is the term used to described the separation of a clip art object into different parts so that it becomes a PowerPoint object?
Options: a. Embedding b. Regrouping c. Ungrouping d. Grouping

Ans:7 – C ,7 – C


What is the usable size of Network bits in Class B of IP address?
Options: 04 B. 08 C. 14 D. 16

Ans:– C ,


In help menu of Excel, which of the following tabs are found?
Options: Contents tab B. Answer Wizard tab C. Index tab D. all of the above.

Ans:– D ,


Can you use the fprintf() to display the output on the screen?
Options: Yes,    No,    ,    

Ans:A ,A


Ctrl + R
Options: a. Re-Open the last closed document b. Re-Print the last printed page c. Re-Apply the last paragraph formatting d. Right align the selected Paragraph

Ans:–  D,–  D


. The term GIGO is related to which characteristics of computers?
Options: A) Speed B) Automatic C) Accuracy D) Reliability

Ans:2-C,2-C


Which of the following provides a storage mechanism for incoming mail but does not allow a user to download messages selectively?
Options: SMTP,    DHCP,    IMAP,    POP3

Ans:D ,D


Examples are packet switching using frame relay, and cell switching using ATM technologies. Select the best fit for answer:
Options: Bandwidth alternatives,    Switching alternating,    Inter organizational networks,    Extranets

Ans:B ,B


Which of the following database object hold data?
Options: a. Forms b. Reports c. Queries d. Tables

Ans:ndash; d,ndash; d


The total time to prepare a disk drive mechanism for a block of data to be read from it is
Options: latency,    latency plus transmission time,    latency plus seek time,    latency plus seek time plus transmission time

Ans:C ,C


. In maximum, how many sheets can be set as default while creating new workbook?
Options: 254 B. 255 C. 256 D. No Limit

Ans:– B ,


Which of the following encapsulates PPP frames in Ethernet frames and uses common PPP features like authentication, encryption, and compression?
Options: PPP,    PPPoA,    PPPoE,    Token Ring

Ans:C ,C


A receiving host has failed to receive all of the segments that it should acknowledge. What can the host do to improve the reliability of this communication session?
Options: Send a different source port number.,    Restart the virtual circuit.,    Decrease the sequence number.,    Decrease the window size.

Ans:D ,D


.   One thing the common tasks button allows you to do is
Options: a. Apply a design template to a slide b. Insert a new slide c. Choose a new layout for a slide d. All of above

Ans:7 – D ,7 – D


. Floppy disks typically in diameter
Options: A) 3 B) 5.25 C) 8 D) All of above

Ans:D,D


. The translator program used in assembly language is called
Options: A) Compiler B) Interpreter C) Assembler D) Translator

Ans:C,C


A set of programs that handle a firm's data base responsibilities is called a
Options: Data Base Management System (DBMS),    Data Base Processing System (DBPS),    Data Management System (DMS),    All of the above

Ans:D ,D


5. Which of the following statements in regard to directories is false?
Options: a. Directories can exist inside directories b. The root directory is always at the highest level c. Directories with files can be deleted d. Directories cannot be renamed

Ans:Correct Answer: d,Correct Answer: d


In which of the following technologies is the term HFC used?
Options: DSL,    PPPoE,    Frame Relay,    Dedicated T1

Ans:D ,D


Corporate modeling languages often do provide for
Options: model definition,    DML commands,    editing,    report specification

Ans:A ,A


How many copies of the database schema are typically used in the redesign process?
Options: One,    Two,    Three,    Four

Ans:C ,C


. What do you call a collection of records matching parameters of a query?
Options: a. Field b. Record c. Query d. Dynaset

Ans:– d,– d


Doubling the operating voltage of a purely capacitive circuit:
Options: has no effect on the capacitive reactance,    doubles the amount of capacitive reactance,    multiplies the capacitive reactance by 7,    cuts the capacitive reactance in half

Ans:A ,A


In ROM BIOS, the acronym BIOS stands for:
Options: Basic Intuitive Output Set,    Basic Input Organizational System,    Basic Input Output System,    Basic Industry Operating System

Ans:C ,C


The structure chart is
Options: a document of what has to be accomplished,    a statement of information processing requirement,    a hierarchical partitioning of the program,    All of the above

Ans:C ,C


What will be the output of the program? #include<stdio.h> typedef struct error {int warning, err, exception;} ERROR; int main() { ERROR e; e.err=1; printf("%d\n", e.err); return 0; }
Options: 0,    1,    2,    Error

Ans:B ,B


A thermistor:
Options: is a pressure sensing device,    has a voltage output,    measures temperature,    All of the above

Ans:C ,C


An ODBC data structure that identifies a database and the DBMS that processes it is called a(n):
Options: data source.,    driver manager.,    driver.,    API.

Ans:A ,A


Which command is used to link the files?
Options: lk,    ln,    cp,    tar

Ans:B ,B


Which of the following is a block device
Options: mouse,    printer,    terminals,    disk

Ans:D ,D


. Scandisk analyze and repair damage to which of the following?
Options: a. Physical clusters b. FAT c. Lost clusters d. All of the above

Ans:6 – d ,6 – d


.  What do you do to start the slide show?
Options: Click on Go B. Turn on transition C. Click on the Slide Show icon D. All of the above

Ans: – C ,


The data recording area between the blank gaps on magnetic tape is called a/ an:
Options: Record,    Block,    Field,    Database

Ans:B,B


The major responsibilities of the data-base administrator are all of the following except:
Options: analyzing application systems,    advising programmers,    designing data base,    developing data dictionaries

Ans:A ,A

www.000webhost.com