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

You are trying to decide which type of network you will use at your office, and you want the type that will provide communication and avoid collisions on the cable. Which of the following is the best choice?
Options: Token-Ring,    CSMA/CD,    Ethernet,    CSMA/CA

Ans:A ,A

Which of the following creates a drop down list of values to choose from a list?
Options: a. OLE Object b. Hyperlink c. Memo d. Lookup Wizard

Ans:ndash; d,ndash; d

in which year was UK’s premier computing event called ?The which computer? started?
Options: A) 1980 B) 1985 C) 1986 D) 1987


Computer-based controllers:
Options: should be built in a modular fashion wherever possible,    are very difficult to change,    are very flexible,    (a) and (c) above

Ans:D ,D

. Which of the following is not a type of Software

Options: A) System Software B) Application Software C) Utility Software D) Entertainment Software


What is the minimum header size of an IP packet?
Options: 16 bytes B. 10 bytes             C. 20 bytes D. 32 bytes

Ans:– C ,

The first firm to mass-market a microcomputer as a personal computer was
Options: A) IBM B) Super UNIVAC C) Radio Shaks D) Data General Corporation


Which of the following applies to a class rather than an object?
Options: Query,    Update,    Scope,    Constructor

Ans:C ,C

Auto text and Auto correct are ___________ tools.
Options: styling B. editing B. designing D. none of the above

Ans:– B ,

Compared to an open-loop system, a closed-loop control system is:
Options: more accurate,    more complex,    more stable,    All of the above

Ans:D ,D

How many broadcast domains are created when you segment a network with a 12-port switch?
Options: 1,    2,    5,    12

Ans:A ,A

. What does ‘apply design template’ do?
Options: a. 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:6 – C ,6 – C

Which of the following would be a logical first step in troubleshooting a PC?
Options: Check the computer CMOS,    Define the circumstances of the problem,    Call the vendor,    Define what applications are being used

Ans:B ,B

A tool that can help designers understand the dependencies of database structures is a:
Options: dependency graph.,    data model.,    graphical display.,    None of the above is correct.

Ans:A ,A

A system design aid should primarily
Options: help analyse both data and activities,    help in documentation,    generate code,    using a graphical user interface

Ans:A ,A

. The most commonly used standard data code to represent alphabetical, numerical and punctuation characters used in electronic data processing system is called
Options: A) ASCII B) EBCDIC C) BCD D) All of above


Point out the error in the following program. #include<stdio.h> #include<stdlib.h> int main() { int *a[3]; a = (int*) malloc(sizeof(int)*3); free(a); return 0; }
Options: Error: unable to allocate memory,    Error: We cannot store address of allocated memory in a,    Error: unable to free memory,    No error

Ans:B ,B

PowerPoint presentations are widely used as
Options: a. note outlines for teachers b. project presentations by students c. communication of planning d. All of above

Ans:– D ,– D

1. What is contained in the page table?
Options: a. Base address of each frame and corresponding page number b. Memory address and corresponding page number c. File name and corresponding page number d. None of Above

Ans:1 – a ,1 – a

Database management systems are intended to 
Options: a. eliminate data redundancy b. establish relationship among records in different files c. manage file access D. all of the above 

Ans:D,All of above

Which of the following is not processing?
Options: A) arranging B) manipulating C) calculating D) gathering


Which of the following decides which systems development projects to work on first ?
Options: data diagram,    project dictionary,    systems flowcharts,    steering committee

Ans:A ,A

Which of the following commands is used to view your file 24 lines at a time?
Options: pg,    cat,    lp,    /p

Ans:A ,A

. The ….provides information about hardware installation, configuration and hardware status
Options: a. Device manager b. Control panel c. Add new hardware d. Program manager

Ans:4 – a ,4 – a

Which bar is usually located below that Title Bar that provides categorized options?
Options: Menu bar B. Status Bar C. Tool bar D. Scroll bar

Ans:– A ,

In OSI network architecture, the dialogue control and token management are responsible of
Options: data link layer,    transport layer,    network layer,    session layer

Ans:D ,D

Which approach to speech recognition avoids the problem caused by the differences in the way words are pronounced according to context?
Options: continuous speech recognition,    connected word recognition,    isolated word recognition,    speaker-dependent recognition

Ans:C ,C

The ODBC Level 1 API contains which of the following functions?
Options: Browse possible connections and data sources only,    Connect to data sources with driver-specific information only,    Process a scrollable cursor only,    Both 1 and 3 above are in the OBDC Level 1 API.

Ans:B ,B

When did IBM close the last of its punched card manufacturing plant?
Options: June, 1989,    December, 1984,    March, 1982,    November, 1979

Ans:B ,B

A process that is repeated, evaluated, and refined is called:
Options: diagnostic,    descriptive,    interpretive,    iterative

Ans:D ,D

The records in a file or magnetic tape
Options: can only be accessed serially,    have to be arranged in a key sequence,    are meant for backup,    cannot be transferred to a disk file

Ans:A ,A

. What is the use of “Hide Slide” option?
Options: a. to hide the selected slides during Presentation b. to hide the selected slides during Editing c. to hide the selected slides during Printing d. to hide the selected slides during Deleting

Ans:8 – A ,8 – A

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

. Which of the following is not a feature of first generation computers

Options: A) They used vacuum tubes or valves as main electronic component B) They consumed lots of electricity and produced excessive heat C) They used machine language and assembly language to program the machine D) None of above


. Microsoft Excel is a powerful………..
Options: a. Word processing package b. Spreadsheet package c. Communication S/W Package d. DBMS package

Ans:– b,– b

The component of Widows that lets you to transfer contents from one document to another
Options: a. Briefcase b. Clipboard c. Document d. Boot

Ans: b ,Clipboard

The central processor of a modern digital computer consists of
Options: control unit,    primary memory,    control unit and primary memory,    All of the above

Ans:C ,C

. Ctrl + T
Options: a. Hanging Indent b. Left Indent c. Open Tabs Dialog box d. Terminate all opened Dialog box

Ans:–  A,–  A

A time sharing system imply
Options: a . more than one processor in the system b . more than one program in memory c . more than one memory in the system d. None of above


Which of the following is used when a company goes outside its organization to develop a new system?
Options: data flow diagram,    systems flowchart,    project dictionary,    request for proposal

Ans:D ,D

An entity type is which of the following?
Options: A major category of data about people, place, and things,    The various departments of an organization,    The application software,    The business processes the support the mission of an organization

Ans:A ,A

Which command is used with file named 'note' to remove the executable permission from the user and assign read permission to the group and others?
Options: chmod u-x, go+r note,    chmod go+r, u+x note,    chmod g-x, uo+r note,    chmod go+x, u-x note

Ans:A ,A

One byte can be used to encode any integer between 'O' and -inclusive
Options: 16,    256,    128,    255

Ans:D ,D

A regular TV set can be hooked up to a computer so as to received computer signal instead of a television program. This hooking up is achieved with the help of a
Options: modem,    adapter,    cable,    aerial

Ans:B ,B

Which JDBC driver Type(s) is(are) the JDBC-ODBC bridge?
Options: Type 1,    Type 2,    Type 3,    Type 4

Ans:A ,A

0. End Key
Options: Moves the cursor end of the line B. Moves the cursor end of the document C. Moves the cursor end of the paragraph D. Moves the cursor end of the screen

Ans: – A ,

What is the name given to the 8-bit unit used for coding data?
Options: block of characters,    byte,    word,    K

Ans:B ,B

Small squares, called _____, on the selection rectangle that surrounds a graphic can be used to change the dimensions of the graphic.
Options: a. scroll boxes b. sizing handles c. status indicators d. move handles

Ans:– B,– B

For what purposes are views used?
Options: To hide columns only,    To hide rows only,    To hide complicated SQL statements only,    All of the above are uses for SQL views.

Ans:D ,D

Control of computer system or subsystem operation by an operator who may intervene at arbitrary times is
Options: Manual control,    Mapping,    Shift register,    ALU

Ans:A ,A