How do you display current date only in MS Excel?


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

Ans:– B ,






More MS-Excel Related questions:


Which two files are used during operation of the DBMS?
Options: query language and utilities,    data manipulation language and query language,    data dictionary and transaction log,    data dictionary and query language

Ans:C ,C


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 title bar always displays on
Options: a. Top of the open windows b. Left side of the open window c. Right side of the open window d. All of above

Ans:3 – a ,3 – a


In LISP, which of the following function assigns the value 10 to the symbol a?
Options: (setq a 10),    (a = b) where b = 10,    (a = 10) (d) (setq 10 a),    None of the above

Ans:A ,A


Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?
Options: MUST COVER,    MUST NOT,    Both of the above.,    None of the above is correct.

Ans:A ,A


What will be the output of the program ? #include<stdio.h> int main() { static int arr[] = {0, 1, 2, 3, 4}; int *p[] = {arr, arr+1, arr+2, arr+3, arr+4}; int **ptr=p; ptr++; printf("%d, %d, %d\n", ptr-p, *ptr-arr, **ptr); *ptr++; printf("%d, %d, %d\n", ptr-p, *ptr-arr, **ptr); *++ptr; printf("%d, %d, %d\n", ptr-p, *ptr-arr, **ptr); ++*ptr; printf("%d, %d, %d\n", ptr-p, *ptr-arr, **ptr); return 0; }
Options: 0, 0, 0 1, 1, 1 2, 2, 2 3, 3, 3,    1, 1, 2 2, 2, 3 3, 3, 4 4, 4, 1,    1, 1, 1 2, 2, 2 3, 3, 3 3, 4, 4,    0, 1, 2 1, 2, 3 2, 3, 4 3, 4, 5

Ans:C ,C


. Which unit is known as nerve center of computer?
Options: A) ALU B) CU C) Memory D) Registers

Ans:B,B


. Which command will divide the surface of the blank floppy disk into sector and assign a unique address to each one?
Options: a. Ver b. Format c. FAT d. CHKDSK

Ans:4 – b ,4 – b


A Winchester disk is a
Options: Disk Stack,    Removable disk,    Flexible disk,    All of the above

Ans:A ,A


A single packet on a data link is known as
Options: Path,    Frame,    Block,    Group

Ans:B ,B


.   Which key on the keyboard can be used to view slide show
Options: a. F1 b. F2 c. F5 d. F10

Ans:6 – C ,6 – C


Conversion of a hexadecimal number 4E16 to binary number is
Options: 10011012,    10011102,    11011002,    1101112

Ans:B ,B


When sharing data in Office, the ________ document is the document in which the data was first entered.
Options: source B. destination C. original D. primary

Ans:– A ,


Time during which a job is processed by the computer is
Options: Delay time,    Real time,    Execution time,    Down time

Ans:C,C


A popular technique for forecasting is
Options: correlation analysis,    regression analysis,    linear programming,    Monte Carlo

Ans:B ,B


Which of the following is not a logical data-base structure?
Options: tree,    relational,    network,    chain

Ans:D ,D


As compared to diskettes, the hard disks are
Options: more expensive,    more portable,    less rigid,    slowly accessed

Ans:A,A


61. In Word you can force a page break
Options: a. By positioning your cursor at the appropriate place and pressing the F1 key b. By using the Insert/Section break on the Insert tab c. By positioning your cursor at the appropriate place and pressing Ctrl+Enter d. By changing the font size of your document

Ans:– C ,– C


What does COUNTA () function do?
Options: counts cells having alphabets B. counts empty cells C. counts cells having number D. counts non-empty cells

Ans:– D ,


What do the following declaration signify? char *arr[10];
Options: arr is a array of 10 character pointers.,    arr is a array of function pointer.,    arr is a array of characters.,    arr is a pointer to array of characters.

Ans:A ,A


. Charles Babbage is considered the father of modern computers because
Options: A) of his difference engine B) of his analytical engine C) his concept of input, mill and output D) All of above

Ans:C,C


The primary job of the operating system of a computer is to
Options: command resources,    manage resources,    provide utilities,    be user friendly

Ans:B ,B


30. Ctrl + Z
Options: a. Undo the last Action b. Redo the last Action c. Add the new page d. Paste the contents from clipboard

Ans:–  A ,–  A


The two functional areas concerned with material flow are
Options: production and marketing,    manufacturing and purchasing,    marketing and finance,    manufacturing and finance

Ans:A ,A


A pricing strategy model would function most effectively as a
Options: transaction processing model,    batch model,    time sharing model,    realtime model

Ans:C ,C


A network with named nodes and labeled arcs that can be used to represent certain natural language grammars to facilitate parsing.
Options: Tree Network,    Star Network,    Transition Network,    Complete Network

Ans:C ,C


The first microprocessor built by the Intel Corpn. was called
Options: 8008,    8080,    4004,    8800

Ans:C ,C


Press _____ to create a line break, which advances the insertion point to the beginning of the next physical line – ignoring any paragraph formatting instructions.
Options: a. shift+enter b. ctrl+enter c. shift+tab d. ctrl+tab

Ans:– a,– a


In a _____ one module of the new information system is activates at a time.
Options: System Development Life Cycle,    CASE tool,    Phased Conversion,    Success factors

Ans:C ,C


External data is stored in the
Options: market forecast file,    forecast allocation file,    customer file,    All of the above

Ans:A ,A


In a PC to telephone hookup for long distance communication, modem is connected between the telephone line and
Options: PC,    synchronous port,    crossover cable,    asynchronous port

Ans:D ,D


Which of the following are TCP/IP protocols used at the Application layer of the OSI model? IP TCP Telnet FTP TFTP
Options: 1 and 3,    1, 3 and 5,    3, 4 and 5,    All of the above

Ans:C ,C


. FORTRAN is a programming language. What does FORTRAN stand for?
Options: A) File Translation B) Format Translation C) Formula Translation D) Floppy Translation

Ans:C,C


Which of the following is not a type of relationship that can be applied in Access database
Options: a. One to One b. One to Many c. Many to Many d. All of above can be applied

Ans:ndash; d,ndash; d


What is the standard protocol for network management features?
Options: SNA,    FTP,    SNMP,    SMS

Ans:C ,C


Which are considered the methods of NAT? Static IP NAT pool Dynamic NAT double-translation Overload
Options: 1 and 6,    3 only,    1, 3 and 5,    All of the above

Ans:C ,C


A  Animation Schemes can be applied to ________ in the presentation.
Options: a. All slides, B. Select slides, C. Current Slide, D. All of the above

Ans:D ,All of the above


You have a network that needs 29 subnets while maximizing the number of host addresses available on each subnet. How many bits must you borrow from the host field to provide the correct subnet mask?
Options: 2,    3,    4,    5

Ans:D ,D


. Which of the following functions is used to all the values in a numeric field?
Options: a. Num b. Count c. Sum d. Total

Ans:6 – b ,6 – b


. The selected design template can be applied
Options: a.  To current slide only b.  To all the slides c.  To all the new presentation you create d.  All of above

Ans:5 – D ,5 – D


.  A ____ is a major database object used to display information in a printable page format.
Options: a. form b. query c. report d. table

Ans:6 – c ,6 – c


What is the notation for following functions? 1. int f(int a, float b) { /* Some code */ } 2. int f(a, b) int a; float b; { /* Some code */ }
Options: 1. KR Notation 2. ANSI Notation,    1. Pre ANSI C Notation 2. KR Notation,    1. ANSI Notation 2. KR Notation,    1. ANSI Notation 2. Pre ANSI Notation

Ans:C ,C


The marketing authority contributing the most to a definition of a structure for the marketing information system is
Options: Philip Vegas,    F.A. Fisher,    Philip Kotler,    Roger McSack

Ans:C ,C


Point out the error in the following program (if it is compiled with Turbo C compiler). #include<stdio.h> int main() { display(); return 0; } void display() { printf("IndiaBIX.com"); }
Options: No error,    display() doesn't get invoked,    display() is called before it is defined,    None of these

Ans:C ,C


.   You can edit an embedded organization chart object by
Options: a. Clicking the edit object b. Double clicking the organization chart object c. Right clicking the chart object, then clicking edit MS-Organization Chart object d. B and c

Ans:0 – D ,0 – D


What are the types of linkages?
Options: Internal and External,    External, Internal and None,    External and None,    Internal

Ans:B ,B


. Which tab in Font dialog box contain options to apply font effects?
Options: a. Font tab b. Character Spacing c. Text Effects d. Standard Toolbar

Ans: – A , – A


Which of the following TCP/IP protocol allows an application program on one machine to send a datagram to an application program on another machine?
Options: UDP,    VMTP,    X.25,    SMTP

Ans:A ,A


A capacitor is measured in which of the following units?
Options: Volts,    Ohms,    Farads,    Resistance

Ans:C ,C


The background and experience of analyst include;
Options: a background in systems theory and organization behavior,    familiarity with the makeup and inner workings of major application areas such as financial accounting, personnel administration, marketing and sales, operations management, model building, and production control.,    competence in system tools and methodologies and a practical knowledge of one or more programming and data base languages.,    All of the above

Ans:D ,D

www.000webhost.com