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


Distinguishing between the different levels of management can be accomplished by analyzing,
Options: types of decision made,    frequency with which decisions are made,    time frame considered in making decisions,    types of report information needed to make decisions

Ans:E ,E


A device used to bring information into a computer is
Options: ALU,    Input device,    Control unit,    Output device

Ans:B ,B


Some advantages of the database approach include all, but:
Options: minimal data redundancy.,    improved data consistency.,    improved data sharing.,    program-data dependency.

Ans:D ,D


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

Ans:C ,C


What is the process lag?
Options: The time it takes for the sensor to respond to a changed.,    The lag in the error signal when the setpoint is changed.,    The time it takes for the mass of the process to respond to an input change.,    All of the above

Ans:C ,C


. The Name box
Options: a. Shows the location of the previously active cell b. Appears t the left of the formula bar c. Appears below the status bar d. Appears below the menu bar

Ans:– b,– b


.   Which of the following views is the best view to use when setting transition effects for all slides in a presentation
Options: a. Slide sorter view b. Notes page view c. Slide view d. Outline view

Ans:9 – A ,9 – A


What will be the output of the program? #include<stdio.h> #define FUN(i, j) i##j int main() { int va1=10; int va12=20; printf("%d\n", FUN(va1, 2)); return 0; }
Options: 10,    20,    1020,    12

Ans:B ,B


Copy and Xcopy are same in the sense
Options: a. Both are internal command of DOS b. Both are external commands of DOS c. Both can be used to copy file or group of files d. Both a and b

Ans:Correct Answer: c ,Correct Answer: c


.   To create a PowerPoint presentation from a template
Options: a. Click File, New, select the presentations tab and choose a template b. Click File, New Template and choose a template c. Import a presentation template from PowerPoint’s template wizard d. Click Create Template from scratch, Now

Ans:1 – A ,1 – A


Which of the following digits are known as the terminal number of the Network User Address (NUA)?
Options: 5-7,    1-4,    8-12,    13-14

Ans:C ,C


. Who invented the microprocessor?
Options: A) Marcian E Huff B) Herman H Goldstein C) Joseph Jacquard D) All of above

Ans:A,A


age break is not a Section break
Options: True B. False

Ans:– A ,


Which of the following is an unary operation?
Options: a. Selection operation b. Generalized selection c. Primitive operation d. Projection operation

Ans:– b ,


Which of the following indicates the maximum number of entities that can be involved in a relationship?
Options: Minimum cardinality,    Maximum cardinality,    ERD,    Greater Entity Count (GEC)

Ans:B ,B


. Daisy wheel printer is a type of

Options: A) Matrix printer B) Impact printer C) Laser printer D) Manual printer

Ans:B,B


Which one of the following statements is true for the voltage in a parallel RC circuit?
Options: The voltage always has the same amplitude and phase for every part of the circuit,    The total voltage is equal to the sum of the voltages across the resistance and capacitance,    The total voltage leads the total current by less than 90 degree,    The total voltage is less than the sum of the voltages across the resistance and capacitance

Ans:A ,A


Which of the following is NOT a type of SQL constraint?
Options: PRIMARY KEY,    FOREIGN KEY,    ALTERNATE KEY,    UNIQUE

Ans:C ,C


What is the first octet range for a class A IP address?
Options: 1 - 126,    192 - 255,    192 - 223,    1 - 127

Ans:A ,A


What is the term which represents the use of links between information of all sorts whether text, graphics, video oi audio-based?
Options: Hypertext,    Hypermedia,    HyperCard,    Wildcard

Ans:B ,B


. Where will store data first time when you copy
Options: a. Clipboard b. Clipbook c. Hard disk d. CD

Ans:1 – a ,1 – a


The first machine to successfully perform a long series of arithmetic and logical operations was:
Options: ENIAC,    Mark I,    Analytic engine,    UNIVAC-I

Ans:B ,B


Which menu do you choose to create footer? (in MS Office 2003)
Options: format, header and footer B. view, footer C. insert, header and footer D. view, header and footer

Ans:– D ,


What is the default subnet mask for a class A network?
Options: 127.0.0.1,    255.0.0.0,    255.255.255.0.0,    255.255.255.0

Ans:B ,B


The receiving data system involves which of the following files?
Options: vendor,    inventory,    purchasing,    All of the above

Ans:D ,D


If no multivalued attributes exist in a relation, then the relation is in what normal form?
Options: First normal form,    Second normal form,    Third normal form,    Fourth normal form

Ans:A ,A


The data base be prepared until
Options: the computer has been selected,    the MIS staff has been acquired and organized,    the preparation of physical facilities,    All of the above

Ans:A ,A


Which of the following systems software does the job of merging the records from two flies into one?
Options: Documentation system,    Utility program,    Networking software,    Security software

Ans:B ,B


Expand EDVAC
Options:

Ans:Electronic Discrete Variable Automatic Computer,


In most of the IBM PCs, the CPU, the device drivers, memory, expansion slots and active components are mounted on a single board. What is the name of the board?
Options: A) Motherboard B) Daughterboard C) Bredboard D) Fatherboard

Ans:-A,-A


Automation normally means:
Options: a net loss of jobs.,    a net increase in jobs.,    no change in jobs.,    All of the above

Ans:B ,B


. 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


Underlined character on the menu or dialog box known as
Options: a. Hot spot, b. Hot key, c. Pane, d. Underline word

Ans:b,Hot key


Which of the following command is used to mount NFS filesystems?
Options: nfsmount,    knfsd,    mount,    All of the above

Ans:C ,C


All worksheet formula
Options: a. Manipulate values b. Manipulate labels c. Return a formula result d. Use the addition operator

Ans:#8211; c,#8211; c


Three-tier architecture includes which of the following?
Options: Three server layers,    A client layer and two server layers,    Two client layers and one server layer,    Three client layers

Ans:B ,B


. Desktop is a
Options: a. Provides workspace b. Screen saver c. Display program d. Working with my document

Ans:0 – a ,0 – a


The examination and changing of single bits or small groups of his within a word is called
Options: Bit,    Byte,    Bit manipulation,    Bit slice

Ans:C ,C


. The problem with …file is that they slow your computer’s operation
Options: a. Fragmented b. Formatted c. Program d. All of above

Ans:2 – a ,2 – a


. The ....is the drive containing the files to be copied
Options: a. Source drive b. Destination drive c. USB drive d. None of the above

Ans: a, a


Which of the following is major activities of an operating system in regard to secondary-storage management?
Options: Free-space management B. Storage allocation C. Disk scheduling D. All of the above

Ans:– D ,


RFM analysis uses customers' purchasing patterns to ________ .
Options: record transactions,    analyze and rank customers,    predict future sales using regression techniques,    perform OLAP

Ans:B ,B


In Microsoft PowerPoint the entry effect as one slide replaces another in a show is called a (an)
Options: a. animation b. slide transition c. custom animation d. preset animation

Ans: – B , – B


. The capacity of 3.5 inch floppy disk is

Options: A) 1.40 MB B) 1.44 GB C) 1.40 GB D) 1.44 MB

Ans:D,D


Your router has the following IP address on Ethernet0: 172.16.2.1/23. Which of the following can be valid host IDs on the LAN interface attached to the router? 172.16.1.100 172.16.1.198 172.16.2.255 172.16.3.0
Options: 1 only,    2 and 3 only,    3 and 4 only,    None of the above

Ans:C ,C


. Which of the following is not valid statement?
Options: A) Hard is referred to mean something temporary B) Hard is used to mean something tangible C) Soft is used to mean something permanent D) Soft is used to mean something tangible

Ans:1-B,1-B


How many bytes are occupied by near, far and huge pointers (DOS)?
Options: near=2 far=4 huge=4,    near=4 far=8 huge=8,    near=2 far=4 huge=8,    near=4 far=4 huge=8

Ans:A ,A


In a 1:N relationship, the foreign key is placed in:
Options: either table without specifying parent and child tables.,    the parent table.,    the child table.,    either the parent table or the child table.

Ans:C ,C


CD-ROM is a
Options: Semiconductor memory,    Memory register,    Magnetic memory,    All of the above

Ans:E ,E


The file created yesterday is called the
Options: "son" file,    "father" file,    "mother" file,    "grandfather file"

Ans:B ,B

www.000webhost.com