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

Which of the following commands connect access list 110 inbound to interface ethernet0?
Options: Router(config)# ip access-group 110 in,    Router(config)# ip access-list 110 in,    Router(config-if)# ip access-group 110 in,    Router(config-if)# ip access-list 110 in

Ans:C ,C

A required characteristic of an online real-time system is:
Options: more than one CPU,    offline batch processing,    no delay in processing,    All of the above

Ans:C ,C

Strong AI is
Options: the embodiment of human intellectual capabilities within a computer.,    a set of computer programs that produce output that would be considered to reflect intelligence if it were generated by humans.,    the study of mental faculties through the use of mental models implemented on a computer.,    All of the above

Ans:A ,A

. Which key should be pressed to start a new paragraph in MS-Word?
Options: a. Down Cursor Key b. Enter Key c. Shift + Enter d. Ctrl + Enter

Ans:–  B,–  B

. Which is not an option for customizing a datasheet window?
Options: a. change one row’s height b. hide one column c. change one column’s width d. freeze one column

Ans:– a,– a

Which of the following are integrity controls that a DBMS may support?
Options: Assume a default value in a field unless a user enters a value for that field.,    Limit the set of permissible values that a field may assume.,    Limit the use of null values in some fields.,    All of the above.

Ans:D ,D

Which of the following statements is correct?
Options: Terminal section of a synchronous modem contains the scrambler,    Receiver section of a synchronous modem contains the scrambler,    Transmission section of a synchronous modem contains the scrambler,    Control section of a synchronous modem contains the scrambler

Ans:C ,C

. Where can you define the permanent path for DOS?
Options: a. Io.sys b. Config.sys c. Autoexec.sys d. Command . com

Ans:6 – c ,6 – c

The difference between a multiplexer and a statistical multiplexer is
Options: Statistical multiplexers need buffers while multiplexers do not need buffers,    Multiplexer use X.25 protocol, while statistical multiplexers use the Aloha protocol,    Multiplexers often waste the output link capacity while statistical multiplexers optimize its use,    Multiplexers use Time Division Multiplexing (TDM) while statistical multiplexers use Frequency Division Multiplexing (FDM)

Ans:A ,A

What will be the output of the program? #include<stdio.h> #define MESS junk int main() { printf("MESS\n"); return 0; }
Options: junk,    MESS,    Error,    Nothing will print

Ans:B ,B

. A flashing or blinking light on the screen is called
Options: a. An icon b. A pixel c. A cursor d. None of the above

Ans:9 – c ,9 – c

In negative logic, the logic state 1 corresponds to
Options: negative voltage,    zero voltage,    more negative voltage,    lower voltage level

Ans:D ,D

Block caches or buffer caches are used
Options: to improve disk performance,    to handle interrupts,    to increase the capacity of the main memory,    to speed up main memory read operation

Ans:A ,A

    Which command lists the contents of current directory of a disk
Options: a.    Copy b.    Tree c.    Cd d.    Dir

Ans:D,Correct Answer: Dir

What will be the output of the program? #include<stdio.h> #define SQUARE(x) x*x int main() { float s=10, u=30, t=2, a; a = 2*(s-u*t)/SQUARE(t); printf("Result = %f", a); return 0; }
Options: Result = -100.000000,    Result = -25.000000,    Result = 0.000000,    Result = 100.000000

Ans:A ,A

. Boot startup process
Options: a. Loads system files to RAM b. Checks the computer connections c. Clean up the computer memory d. Prepare the computer ready

Ans:5 – a ,5 – a

Auto clipart is a feature that
Options: a. Automatically places clipart in your presentation b. Scans your presentation for incorrect spelling in your words on each slide c. Scans your presentation for incorrect spelling in Word Arts objects d. All of above

Ans: – D , – D

. To create queries in access
Options: a. You can drag and drop fields on query builders b. You can type the sql command in sql view c. You can use query wizard or design view d. All of above

Ans:5 – d ,5 – d

The ALU of a computer normally contains a number of high speed storage elements called
Options: semiconductor memory,    registers,    hard disk,    magnetic disk

Ans:B ,B

An electronic circuit with about 20 transistors fabricated on a silicon chip is known as
Options: SSI,    MSI,    DPS,    RJE

Ans:A ,A

Which part of the system performs the "housekeeping" chores?
Options: operating system,    compiler,    interpreter,    translator

Ans:A ,A

Most data communications involving telegraph lines use:
Options: simplex lines,    wideband channels,    narrowband channels,    dialed service

Ans:C ,C

Acceptance testing is
Options: running the system with line data by the actual user,    making sure that the new programs do in fact process certain transactions according to Specifications,    is checking the logic of one or more programs in the candidate systems,    testing changes made in an existing or a new program

Ans:A ,A

Which of the following is used to insure the high quality of computer output?
Options: computer output microfilm,    output controls,    voice output systems,    liquid crystal display

Ans:B ,B

When a bearing in the power supply fan goes out, what should you replace?
Options: fan,    case,    bearing,    power supply

Ans:D ,D

In the language of the computer profession, one thousand position of main storage is represented with the letter
Options: K,    L,    M,    C

Ans:A ,A

What will be the output of the program? #include<stdio.h> int main() { typedef int LONG; LONG a=4; LONG b=68; float c=0; c=b; b+=a; printf("%d,", b); printf("%f\n", c); return 0; }
Options: 72, 68.000000,    72.000000, 68,    68.000000, 72.000000,    68, 72.000000

Ans:A ,A

In immediate addressing the operand is placed
Options: a . in the CPU register b . after OP code in the instruction c . in memory d . in stack 


Which of the following statements are correct about the program? #include<stdio.h> int main() { printf("%p\n", main()); return 0; }
Options: It prints garbage values infinitely,    Runs infinitely without printing anything,    Error: main() cannot be called inside printf(),    No Error and print nothing

Ans:B ,B

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

Ans:– B ,

. Which of the following is not true regarding Conditional Formatting?
Options: a. You can add more than one condition to check b. You can set condition to look for Bold and apply Italics on them. c. You can apply Font, border and pattern formats that meets the specified conditions d. You can delete any condition from Conditional Formatting dialog box if it is not requried

Ans:– b,– b

Indicate which of the following is not true about 4GL?
Options: 4GL does not support a high-level of screen interaction,    Many database management system packages support 4GLs,    A 4GL is a software tool which is written, possibly, in some third generation language,    All of the above

Ans:A ,A

. What does an inner join display?
Options: a. Records from the second recordset and only records from the first recordset where the common fields are equal b. Records from the first recordset and only records from the second recordset where the common fields are equal c. Records that have the same value in the common field d. Records from the first recordset only

Ans:8 – c ,8 – c

The 2's complement of a binary no. is obtained by its 1's complement.
Options: 0 ,    1,    10,    12

Ans:B ,B

Which prefixes are available to Oracle triggers?
Options: :new only,    :old only,    Both :new and :old,    Neither :new nor :old

Ans:C ,C

. What is the short cut key to replace a data with another in sheet?
Options: a.  Ctrl + R b.  Ctrl + Shift + R c.  Ctrl + H d.  Ctrl + F

Ans:– c,– c

Summarized information is used more than detailed information on the
Options: top management level,    middle management level,    lower management level,    All of the above

Ans:A ,A

In Word, the default alignment for paragraphs is _____.
Options: a. left-aligned, or flush margins at the left edge and uneven edges at the right edge b. centered, or equidistant from both the left edge and the right edge c. right-aligned, or flush margins at the right edge and uneven edges at the left edge d. justified, or flush margins at both the left and right edges

Ans:– A,– A

Which is used to perform what if analysis?
Options: a. Solver b. Goal seek c. Scenario Manager d. All of above

Ans:#8211; d,#8211; d

What is the name given to the software which can be legally compiled and often used for free?
Options: Shareware program,    Public domain program,    Firmware program,    Mindware

Ans:B ,B

Which file starts MS Word?
Options: a. winword.exe b. word.exe c. msword.exe d. word2003.exe

Ans:– A,– A

In Microsoft PowerPoint, two kinds of sound effects files that can be added to the presentation are
Options: a. .wav files and .mid files b. .wav files and .gif files c. .wav files and .jpg files d. .jpg files and .gif files

Ans: – A , – A

. A zip is a program used to
Options: a. Speed up the computer memory b. Speed up the disk access c. Compress files d. All of above

Ans:7 – c ,7 – c

The Personal Consultant is based on:
Options: EMYCIN,    OPS5+,    XCON,    All of the above

Ans:D ,D

Data has to be _____ before it can be converted into information.
Options: transformed,    processed,    changed,    engineered

Ans:B ,B

. Which command is used to open the directory?
Options: a. Open b. Chdir c. Move d. All of above

Ans:2 – b ,2 – b

. Computers built before the First Generation of computers were:

Options: A) Mechanical B) Electro-mechanical C) Electrical D) None of these


Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:
Options: GROUP BY.,    WHERE.,    ORDER BY.,    FROM.

Ans:C ,C

A workstation has just been installed on an Ethernet LAN, but cannot communicate with the network. What should you check first?
Options: reinstall the network protocols,    reinstall the network interface card driver,    verify the ip configuration on the workstation,    verify the link status on the computer's network card

Ans:D ,D

After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?
Options: a. You need to delete the whole tablThere is no method to remove a particular field only. b. Delete all the fields from third downwards and reenter the required fields again. c. Select the third column in datasheet view then  Delete d. Select the third row in table design view then Delete

Ans:ndash; d,ndash; d