How do you display current date and time in MS Excel?


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

Ans:– C ,


Description: mcqquestions

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

Hits Today: 8152 | 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 ODBC core API consists of which of the following functions?
Options: Commit or rollback transactions only,    Connect to data sources with driver-specific information only,    Connect to data sources only,    Both 1 and 3 above are in the OBDC core API.

Ans:D ,D


The cp command uses:
Options: standard input file,    standard output file,    both input and output file,    neither standard input nor standard output file

Ans:D ,D


A modulator converts a _____ signal to a(n) _____ signal.
Options: FSK; PSK,    PSK; FSK,    analog; digital,    digital; analog

Ans:D ,D


Which of the following is a disadvantage of replication?
Options: Reduced network traffic,    If the database fails at one site, a copy can be located at another site.,    Each site must have the same storage capacity.,    Each transaction may proceed without coordination across the network.

Ans:C ,C


After installing a sound card, the system locks up when a parallel port tape backup unit is also used. What is most likely the problem?
Options: IRQ,    DMA,    defective LPT port,    defective tape driver

Ans:A ,A


What type of RJ45 UTP cable do you use to connect a PC's COM port to a router or switch console port?
Options: Straight-through,    Crossover cable,    Crossover with a CSU/DSU,    Rolled

Ans:D ,D


Which of the following products was the first to implement true relational algebra in a PC DBMS?
Options: IDMS,    Oracle,    dBase-II,    R:base

Ans:D ,D


What is the address range of a Class B network address in binary?
Options: 01xxxxxx,    0xxxxxxx,    10xxxxxx,    110xxxxx

Ans:C ,C


Excel probably considers the cell entry January 1, 2000 to be a
Options: a. Label b. Value c. Formula d. Text string

Ans:#8211; b,#8211; b


In synchronous transmission data from various users
Options: Require header,    Do not require header,    Sometimes require header,    All of the above

Ans:B ,B


. FORTRAN is
Options: A) File Translation B) Format Translation C) Formula Translation D) Floppy Translation

Ans:8-C,8-C


. The ribbon in Word 2007 consists of a series of
Options: a. Gates b. Smaller ribbons c. Tabs d. Icons

Ans: – C , – C


What will be the output of the program? #include<stdio.h> #define str(x) #x #define Xstr(x) str(x) #define oper multiply int main() { char *opername = Xstr(oper); printf("%s\n", opername); return 0; }
Options: Error: in macro substitution,    Error: invalid reference 'x' in macro,    print 'multiply',    No output

Ans:C ,C


. You can open the scenario Manager dialog box by choosing scenarios from the ….. menu.
Options: a. View b. Insert c. Format d. Tools

Ans:– d,– d


. Who developed a mechanical device in the 17th century that could add, subtract, multiple, divide and find square roots?
Options: A) Napier B) Babbage C) Pascal D) Leibniz

Ans:D,D


Which of the following method is used the results of a design analysis as a base for redesign decisions?
Options: The iterative design method,    The direct method,    The design selection method,    All of the above

Ans:A ,A


One millisecond is
Options: A) 1 second B) 10th of a seconds C) 1000th of a seconds D) 10000th of a seconds

Ans:-C,-C


The % key allows you
Options: to move the cursor to a matching delimiter, when a delimiters a parenthesis, a bracket, or a brace.,    to move the cursor to the upperleft corner of the screen,    to move the cursor backward to the beginning of a word,    to move the cursor to the first column in the current line

Ans:A ,A


The process of reading a database schema and producing a data model from that schema is known as:
Options: data modeling.,    database design.,    reverse engineering.,    None of the above is correct.

Ans:C ,C


The computer graphics system called SKETCHPAD was demonstrated at
Options: Massachusetts Institute of Technology in 1963,    Imperial college of Science and Technology, London, 1973,    University of Aston, Birmingham, 1960,    Cranfield Institute of Technology, London, 1962

Ans:A ,A


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

Ans:D ,D


Which of the following registers is used to keep track of address of the memory location where the next instruction is located?
Options: Memory Address Register,    Memory Data Register,    Instruction Register,    Program Counter

Ans:D ,D


A modern electronic computer is a machine that is meant for
Options: Doing quick mathematical calculations,    Input storage, manipulation of outputting of data,    Electronic data processing,    Performing repetitive tasks accurately

Ans:B ,B


. The Stepped Reckoner was invented by

Options: A) John Napier B) William Oughtred C) Gottfried Leibnitz D) Blaise Pascal

Ans:C,C


Advantage(s) of using assembly language rather than machine language is/are:
Options: It is mnemonic and easy to read,    Addresses any symbolic, not absolute,    Introduction of data to program is easier,    All of the above

Ans:D ,D


Which of the following, is necessary to work on a computer
Options: Compiler,    Operating system,    Assembly,    Interpreter of the above

Ans:B ,B


57. To move the cursor page to page of document
Options: a. Ctrl+PgDn b. Ctrl+PgUp c. Both of above d. None of above

Ans:– C ,– C


If a load resistance is 1 kW, a stiff voltage source has a resistance of
Options: At least 10 Ohm,    less than 10 Ohm,    More than 100 k Ohm,    Less than 100 k Ohm

Ans:B ,B


The reservation system of Indian railways is an example of
Options: transaction processing system,    Interactive decision support system,    management controls system,    expert system

Ans:A ,A


. Which of the following is an important attribute of RAM memory?
Options: Volatile B. Non-Volatile C. Random access D. Sequential access

Ans:– A ,


Repeaters are often used on an 802.3 network to help strengthen the signals being transmitted. As with the length of segments and the number of segments, a limit exists as to how many repeaters can be used between any two nodes. What is the maximum number of repeaters that can be used?
Options: Five,    Two,    Four,    Six

Ans:C ,C


. The ability of a database to grow as the data tracking needs grow is its __________.
Options: a. scalability b. expandability c. maintainability d. platform-independence

Ans:8 – a ,8 – a


Which two commands enable you to move between directories?
Options: CD,    CHDIR,    MOVE,    MOVE DIR

Ans:A ,A


The accuracy of the floating point numbers representable in two 16 bit words of a computer is approximately
Options: 16 digits,    6 digits,    4 digits,    All of the above

Ans:B ,B


The DC voltage on most circuit boards is:
Options: -12 volts,    0 volts,    +5 volts,    +12 volts

Ans:C ,C


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


Which file executes commands in DOS?
Options: MS-DOS.SYS,    CONFIG.SYS,    COMMAND.COM,    SYSTEM.INI

Ans:C ,C


. What type of memory is not directly addressable by the CPU and requires special softw3are called EMS (expanded memory specification)?
Options: A) Extended B) Expanded C) Base D) Conventional

Ans:B,B


. The maximum size of a write file is limited to only
Options: a. Name of the file b. Extension of the file c. The amount of memory in your computer d. All of above

Ans: c, c


. What produces useful information out of data?
Options: A) Computer B) Processing C) Programming D) none of above

Ans:B,B


. Which of the following is first generation computer?
Options: A) EDSAC B) IBM 1401 C) CDC 1604 D) ICL 2950

Ans:0-A,0-A


Where can you find the Draw Table tool button?
Options:  A) Standard toolbar, B) Formatting toolbar, C) Drawing toolbar, D) Tables and Formatting toolbar, 

Ans:-D,-D


How many IRQs does a chain of USB devices require?
Options: 1,    2,    3,    4

Ans:A ,A


What will be the output of the program (16-bit platform)? #include<stdio.h> #include<stdlib.h> int main() { int *p; p = (int *)malloc(20); printf("%d\n", sizeof(p)); free(p); return 0; }
Options: 4,    2,    8,    Garbage value

Ans:B ,B


. What do we call a computer program that organizes data in rows and columns of cells? You might use this type of program to keep a record of the money you earned moving lawns over the summer.
Options: a. Spreadsheet program b. Database program c. Word processor program d. Desktop publisher program

Ans:– a,– a


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


.   Which types of fonts are best suitable for titles and headlines
Options: a. serif fonts b. sans serif fonts c. text fonts d. picture fonts

Ans:3 – B ,3 – B


Which of the following memories needs refresh?
Options: DRAM B. SRAM C. ROM D. All of above

Ans:– A ,


Typewriter terminals can print computer-generated data at a rate of
Options: 10 characters per second,    120 characters per second,    120 characters per minute,    1200 characters per minute

Ans:B ,B


. Which of the following is not a part of the control panel?
Options: a. Date and time b. My documents c. Add or remove program d. Display

Ans:3 – b ,3 – b

www.000webhost.com