How do you display current date only in MS Excel?


Options: date () B. Today () C. now () D. time ()

Ans:– B ,


Description: mcqquestions

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

Hits Today: 16988






More MS-Excel Related questions:


. Dcl provides commands to perform actions like
Options: a. Change the structure of tables b. Insert, update or delete records and data values c. Authorizing access and other control over database d. None of above

Ans:6 – c ,6 – c


People often call ______ as the brain of computer system
Options: A) Control Unit B) Arithmetic Logic Unit C) Central Processing Unit D) Storage Unit

Ans:-C,-C


If routers in a single area are configured with the same priority value, what value does a router use for the OSPF Router ID in the absence of a loopback interface?
Options: The lowest IP address of any physical interface,    The highest IP address of any physical interface,    The lowest IP address of any logical interface,    The highest IP address of any logical interface

Ans:B ,B


16. How much space in minimum must be provided between columns?
Options: a. 0″ b. 0.5″ c. 1″ d. 1.5″

Ans:– A ,– A


A acronym for the organisation that publishes programming language standard is
Options: ASCn,    BCD,    ANSI,    EBCDIC

Ans:C ,C


Which type of system hoard is the MOST likely candidate for processor upgrading if you want maximum performance and future compatibility?
Options: ML,    PCI,    ISA,    EISA

Ans:B ,B


How much should an organisation spend for information can be determined by some type of a:
Options: cost analysis,    benefit analysis,    cost-benefit analysis,    any of the above

Ans:C ,C


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


. Which of the cell pointer indicate that you can move the content to other cell?
Options: a.  Doctor’s symbol (Big Plus) b.  small thin plus icon c.  Mouse Pointer with anchor at the tip d.  None of above

Ans:– c,– c


. Which of the following is not one of the three ‘Mail Merge Helper’ steps?
Options: a. merge the two files b. create the main document c. set the mailing list parameters d. create the data source

Ans:– C,– C


Duplicate data often results in loss of data integrity because:
Options: the data formats may be inconsistent.,    data values may not agree.,    Both A & B.,    Neither A & B.

Ans:C ,C


Which statement will you add in the following program to work it correctly? #include<stdio.h> int main() { printf("%f\n", log(36.0)); return 0; }
Options: #include<conio.h>,    #include<math.h>,    #include<stdlib.h>,    #include<dos.h>

Ans:B ,B


The accuracy of the floating-point numbers representable in two 16-bit words of a computer is approximately
Options: A) 16 digits B) 6 digits C) 9 digits D) All of above

Ans:-B,-B


.   To insert a new slide in the current presentation, we can choose
Options: a. Ctrl + M b. Ctrl + N c. Ctrl + O d. Ctrl + F

Ans:6 – A ,6 – A


. Which of the following is the file extension for an Extensible Markup Language?
Options: a. EML b. HTML c. XML d. XSD

Ans:6 – c ,6 – c


What does FSF stand for?
Options: Free Software File,    File Server First,    First Serve First,    Free Software Foundation

Ans:D ,D


Which of the following affects the extent to which you are involved with the system development life cycle in your company?
Options: your job description,    size of the organization,    your relevant experience,    All of the above

Ans:E ,E


Who invented Java?
Options: Netscape,    Microsoft,    Sun,    None of the above is correct.

Ans:C ,C


. To display system boot menu which of the following command you must press?
Options: a. F4 b. F7 c. F8 d. F5

Ans:7 – c ,7 – c


. Shimmer, Sparkle text, Blinking Background etc. are known as
Options: a. font styles b. font effects c. word art d. text effects

Ans: – D , – D


Which language was devised by Dr. Seymour Aubrey Papert?
Options: APL,    COBOL,    LOGO,    FORTRAN

Ans:C ,C


What are the decimal and hexadecimal equivalents for the binary number 10110111?
Options: 69/0x2102,    183/B7,    173/A6,    83/0xC5

Ans:B ,B


Which is the first program run on a computer when the computer boots up?
Options: System software B. Operating system C. System operations D. None

Ans:– B ,


Minimal Superkeys are called
Options: Schema keys B. Candidate keys C. Domain keys D. Attribute keys

Ans:– B ,


Files created with Lotus 1-2-3 have an extension
Options: a. DOC b. XLS c. 123 d. WK1

Ans:#8211; c,#8211; c


. Programs designed to perform specific tasks is known as
Options: A) system software B) application software C) utility programs D) operating system

Ans:B,B


Convert the 48 machine language instructions into assembly language, assuming that they were not generated by pseudo-ops:
Options: ASRA,    LOADA h#OD4E, i,    STOREA h#014B, d,    ADDA h#01FE, i

Ans:A ,A


The key F12 opens a
Options:  A) Save As dialog box, B) Open dialog box, C) Save dialog box, D) Close dialog box, 

Ans:-A,-A


Memory
Options: is a device that performs a sequence of operations specified by instructions in memory.,    is the device where information is stored,    is a sequence of instructions,    is typically characterized by interactive processing and time-slicing of the CPU's time to allow quick response to each user.

Ans:B ,B


In which mode can two or more applications be stored in memory at the same time?
Options: Segmented Mode,    Unprotected Mode,    Real Mode,    Protected Mode

Ans:D ,D


An operational system is which of the following?
Options: A system that is used to run the business in real time and is based on historical data.,    A system that is used to run the business in real time and is based on current data.,    A system that is used to support decision making and is based on current data.,    A system that is used to support decision making and is based on historical data.

Ans:B ,B


Which one of the following is a statement of KirchhofFs voltage law?
Options: The total voltage in a parallel circuit is less than the value of the smallest voltage,    The algebraic sum of voltages in a loop is equal to zero,    The voltage drop across a resistance is proportional to the value of resistance and the amount of current flowing through it,    The algebraic sum of voltages entering and leaving a point is equal to zero

Ans:B ,B


The terms "red book", "yellow book", and "orange book" refer to:
Options: SCSI,    ide,    floppy drive technology,    CD-ROM standards

Ans:D ,D


While buying a PC system, you should first
Options: shop for application programs,    identify your hardware components,    define your computing needs,    call for tenders

Ans:C ,C


What is the maximum data rate for the 802.11b standard?
Options: 6Mbps,    11Mbps,    22Mbps,    54Mbps

Ans:B ,B


The third stage in designing a database is when we analyze our tables more closely and create a ___________ between tables
Options: a. relationship b. Join c. Query d. None of these

Ans:dash; a,dash; a


Which statement is valid about computer program?
Options: A) It is understood by a computer B) It is understood by programmer C) It is understood user D) Both a & b

Ans:-D,-D


41. How many different documents you can open at one time?
Options: a. No more than three b. Only one c. As many as your computer memory will hold d. As many as your taskbar can display

Ans:– C ,– C


. IBM 7000 digital computer
Options: A) Belongs to second generation B) Uses VLSI C) Employs semiconductor memory D) Has modular constructions

Ans:6-D,6-D


. According to the Leszynski Naming Conventions, which of the following is the prefix for a text box control?
Options: a. txt b. txb c. tbc d. tex

Ans:1 – a ,1 – a


A teleprocessing system may consist of
Options: user systems,    communications systems,    computer center systems,    All of the above

Ans:D ,D


Checking the quality of software in both simulated and line environments, is known as
Options: checking,    usability,    validity,    validation

Ans:D ,D


. Which of the following is correct acronym of VGA?
Options: A) Video Graphics Array B) Visual Graphics Array C) Volatile Graphics Array D) Video Graphics Adapter

Ans:A,A


Which of the following is the most critical requirement of a Passenger Reservation System?
Options: ease of programming,    response time,    graphical user Interface,    printing of tickets

Ans:B ,B


To set up a bulletin board system you need
Options: a smart modem with auto-answer capabilities,    a telephone line,    a personal computer,    All of the above

Ans:D ,D


To install a second IDE drive into a computer, you must:
Options: Set the master-slave jumper to slave on the second drive,    Use the IDE configuration software to set the new drive as slave,    Verify that you define the new drive as D: in the CMOS setup,    Verify that you attach the drive to the connector at the end of the ribbon cable

Ans:A ,A


. What is the name of the computer terminal which gives paper printout?
Options: A) Display screen B) Soft copy terminal C) Hard copy terminal D) Plotter

Ans:C,C


A form of modulation In which the amplitude of a carrier wave is varied in accordance with some characteristic of the modulating signal, is known as
Options: Aloha,    Angle modulation,    Amplitude modulation,    modem

Ans:C ,C


To create an installation boot floppy disk from Linux (or another Unix) machine, what command could you use?
Options: fdisk,    fsck,    dd,    rawrite

Ans:C ,C


Filename extensions help identify certain files. What filename extension identifies executable files?
Options: INF,    PRO,    EXE,    SYS

Ans:C ,C

www.000webhost.com