Which of the following function will return a value of 8?


Options: ROUNDUP(8.4999, 0) B. ROUNDDOWN(8.4999, 0) C. ROUND(8.4999, 0) D. Only B and C

Ans:– D ,






More MS-Excel Related questions:


What is the turns ratio of a power transformer that shows 50 V at its secondary winding when you apply 150 V to its primary winding?
Options: 1/4,    1/3,    2,    3

Ans:D ,D


Which of the following is not the required condition for binary search algorithm?
Options: a. The list must be sorted b. there should be the direct access to the middle element in any sublist c. There must be mechanism to delete and/or insert elements in list d. none of above

Ans:- c,- c


Which of the following allow you to select more than one slide in a presentation?
Options: a. Alt + Click each slide b. Shift + drag each slide c. Shift + Click each slide d. Ctrl + Click each slide

Ans: – C , – C


_____ is an application of the computer where the computer makes decisions or judgments that appear to require human intuition, reasoning and intelligence.
Options: AI,    ES,    KBS,    Base-rule

Ans:A ,A


It is most common type of query. It retrieves records from one or more tables and then displays the
Options: a. Parameter b. Select c. crosstab d. All of above

Ans:ndash; b,ndash; b


In ODBC, a data source that is local to a single computer is called a:
Options: system data source.,    file data source.,    user data source.,    SQL text file.

Ans:A ,A


Which symbol is used to separate more than one command in the same command line?
Options: $,    #,    :,    ;

Ans:D ,D


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


HIMEM.SYS controls:
Options: DOS=HIGH,    RMDRIVE.SYS,    SMARTDRV.SYS,    Extended Memory

Ans:D ,D


The north pole of a magnet is the one:
Options: that has its molecules arranged in a random pattern,    that would be attracted to the earth's north magnetic pole,    that would be repelled by the south pole of another magnet,    that would be attracted to the earth's south magnetic pole

Ans:B ,B


When you create a subdirectory within a directory, the process is known as _____
Options: directing,    making,    backing,    nesting

Ans:D ,D


. Each excel file is called a workbook because
Options: a. It can contain text and data b. It can be modified c. It can contain many sheets including worksheets and chart sheets d. You have to work hard to create it

Ans:– c,– c


You have linked SQL*Plus to an external text editor. To invoke the text editor for use within SQL*Plus, which command do you use?
Options: Open [FileName],    Show [FileName],    Alter [FileName],    Edit [FileName]

Ans:D ,D


A _____ means that one record in a particular record type is related to only one record of another record type.
Options: One-to-one relationship,    One-to-many relationship,    Many-to-one relationship,    Many-to-many relationship

Ans:A ,A


Microsoft Access is a
Options: a. RDBMS b. OODBMS c. ORDBMS d. Network database model

Ans:ndash; a,ndash; a


If you wanted to deny FTP access from network 200.200.10.0 to network 200.199.11.0 but allow everything else, which of the following command strings is valid?
Options: access-list 110 deny 200.200.10.0 to network 200.199.11.0 eq ftp access-list 111 permit ip any 0.0.0.0 255.255.255.255,    access-list 1 deny ftp 200.200.10.0 200.199.11.0 any any,    access-list 100 deny tcp 200.200.10.0 0.0.0.255 200.199.11.0 0.0.0.255 eq ftp,    access-list 198 deny tcp 200.200.10.0 0.0.0.255 200.199.11.0 0.0.0.255 eq ftp access-list 198 permit ip any 0.0.0.0 255.255.255.255

Ans:D ,D


What does MSCDEX.EXE do?
Options: Configures hard drives,    it's a SCSI driver,    BIOS setup,    it's a CD-ROM DOS driver

Ans:D ,D


The most important part of a multiple DHCP configurations is to make sure you don't have which of the following in the different scopes? Select the best answer.
Options: Duplicate addresses,    Duplicate pools,    Duplicate subnets,    Duplicate default gateways

Ans:A ,A


Which of the following is considered a high-level language?
Options: Machine language,    FORTRAN,    Assembly language,    All of the above

Ans:B ,B


. In Computer System Memory management operations are performed by
Options: User B. Hardware       C. Programmer D. Operating system

Ans:– D ,


Which device uses a DMA channel?
Options: Modem,    Network Card,    Sound Card,    All of the above

Ans:C ,C


Which of the following function is more appropriate for reading in a multi-word string?
Options: printf();,    scanf();,    gets();,    puts();

Ans:C ,C


Which of the following is a component of an expert system?
Options: explanation module,    knowledge base,    natural language interface for the user,    inference machine

Ans:E ,E


1 Microfarad is the same as:
Options: 1 millionth of a picofarad,    1000 millifarads,    1 million picofarads,    1 million farads

Ans:C ,C


_____________ refers to the correctness and completeness of the data in a database?
Options: Data security B. Data integrity C. Data constraint D. Data independence

Ans:– B ,


. Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?
Options: a. Use Ctrl to select all three cells, then click the paste button on the standard toolbar b. Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify c. Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to d. All of above

Ans:– c,– c


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


The designer of a form includes
Options: filed designators,    prompts,    data,    both (a) and (b)

Ans:D ,D


The first electronic general purpose digital computer built by Mauchly and Eckert called ENIAC did not work on the stored program principle. How many numbers could it store in its internal memory?
Options: 100,    20,    40,    80

Ans:B ,B


Which of are following internal commands is used in mail to forward mail to user in user-list?
Options: r user-list,    m user-list,    d user-list,    e user-list

Ans:B ,B


Which one of the following statements is true for the voltage in a parallel RL circuit?
Options: The voltage always has the same amplitude and phase for every part of the circuit,    The total voltage is equal to the sum of the voltages across the resistance and inductance,    The total voltage lags the total current by less than 90,    The total voltages is less than the sum of the voltages across the resistance and inductance

Ans:A ,A


. Which of the following action removes a sheet from workbook?
Options: a.  Select the sheet, then choose Edit >> Delete Sheet b.  Select the sheet then choose Format >> Sheet >> Hide c.  Both of above d.  None of above

Ans:– a,– a


. Which of the following is/are external commands?
Options: a. Edit b. Label c. Sys d. All of above

Ans: d, d


. Which of the following programming language started from second generation?
Options: A) COBOl B) BASIC C) C D) LISP

Ans:A,A


. When was Apple Macintosh II microcomputer introduced in the market?
Options: A) 1964 B) 1970 C) 1983 D) 1986

Ans:C,C


Which type of entity has its relationship to another entity determined by an attribute in that other entity called a discriminator?
Options: Supertype entity,    Subtype entity,    Archetype entity,    Instance entity

Ans:B ,B


Which of the following statement is correct prototype of the malloc() function in c ?
Options: int* malloc(int);,    char* malloc(char);,    unsigned int* malloc(unsigned int);,    void* malloc(size_t);

Ans:D ,D


A condition that led to the development of databases was:
Options: the proliferation of data files,    an increase in the amount of data handled by organizations,    a demand for more data to support informational needs,    all the above.

Ans:D ,D


What TCP/IP protocol is used for file transfer with minimal capability and minimal overhead?
Options: TELNET,    TFTP,    FTP,    RARP

Ans:B ,B


What is the first thing you could do to check for damage to a printer after receiving it?
Options: Run MSD diagnostics,    Attach it to a PC and print something,    Check the cables,    Unbox it and examine it for physical damage

Ans:D ,D


Which of the following indicates the minimum number of entities that must be involved in a relationship?
Options: Minimum cardinality,    Maximum cardinality,    ERD,    Greater Entity Count (GEC)

Ans:A ,A


Cisco's Unified Wireless Solution provides a mesh solution. What devices do you absolutely need to purchase to run a Cisco solution? WCS Controller Access point Bridge
Options: 1 and 2,    2 and 3,    1 and 4 only,    4 only

Ans:B ,B


How many digits of the DNIC (Data Network Identification Code) identify the country?
Options: first three,    first four,    first five,    first six

Ans:A ,A


Which command is used to delete the directory and all its contents in one step?
Options: DEL *.*,    RD,    DELTREE,    CD

Ans:C ,C


36. When typing in a word field manually, what must you press to insert the code’s braces?
Options: a. Ctrl + F6 b. Ctrl + F9 c. Alt + F11 d. Shift + F12

Ans:–  B ,–  B


After doing a low-level format, what would be the next step in configuring the hard drive in a system?
Options: Format DOS partition,    Install operating system,    Configure DMA channel and back-up interrupt,    Partition had disk

Ans:A ,A


Which menu do you choose to shade words and paragraph?
Options: format, borders and shading, insert, borders and shading, view, shading,none of the above

Ans:D ,


What TCP/IP protocol is used for transferring electronic mail messages from one machine to another?
Options: FTP,    SNMP,    SMTP,    RPC

Ans:C ,C


Pictographs, called _____ help systems to be more user friendly.
Options: people,    icons,    information system,    on-line

Ans:B ,B


Which of the following is not available on the Ruler of MS Word screen?
Options:  A) Tab stop box, B) Left Indent, C) Right Indent, D) Center Indent, E) All of them are available on ruler

Ans:-D,-D

www.000webhost.com