. Which of the following is correct syntax in Excel?

Options: =IF(LogicalTest, TrueResult, FalseResult) B. =IF(LogicalTest, (TrueResult, FalseResult)) C. =IF(LogicalTest, TrueResult) (LogicalTest, FalseResult) D. =IF(LogicalTest, TrueResult), IF(LogicalTest, FalseResult)

Ans:– A ,

Description: mcqquestions

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

Hits Today: 13528 | 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:

If you are to use [Control-c] as the interrupt key instead of [Del], then you will have to use
Options: tty ^c,    stty intr \^c,    stty echoe,    stty echo \^a

Ans:B ,B

. When sharing data in Office, the ________ document is the document in which the data was first entered.
Options: a. source b. destination c. original d. primary

Ans:–  A,–  A

The order entry subsystem creates a file of order records that are input to the
Options: production subsystem,    inventory subsystem,    control subsystem,    quality subsystem

Ans:B ,B

What layer in the TCP/IP stack is equivalent to the Transport layer of the OSI model?
Options: Application,    Host-to-Host,    Internet,    Network Access

Ans:B ,B

It is a database object to view, change, and analyze data in different ways
Options: a. query b. form c. report d. None of the above

Ans:ndash; a,ndash; a

If you want to group the records in the abc database, you could use the Jobcode as the _____.
Options: Delete,    Update,    Sort Key,    Index

Ans:C ,C

. The octal equivalence of 111010 is
Options: A) 81 B) 72 C) 71 D) None of above


A customer has just installed a new cd-rw. the system was working fine before the installation, but now the cdrom does not work, what should you suggest that the customer do?
Options: flash or upgrade the BIOS,    check the CONFIG.SYS,    add cdrw in the device manager,    check the jumper setting on the cd-rw

Ans:D ,D

What happens when you insert an AutoShape by simply clicking in the document?
Options: it appears near the insertion point B. it is inserted in its default size C. is selected D. all of the above

Ans: – C ,

. Which key do you press to check spelling?
Options: a. F3 b. F5 c. F7 d. F9

Ans:– c,– c

Who founded the Linux Kernel?
Options: Bill Gates,    Ben Thomas,    Richard Stallman,    Linus Torvalds

Ans:D ,D

. Where you can find the font?
Options: a. C:Font b. C:windowsfont c. C:control panelfont d. All of above

Ans:9 – b ,9 – b

. The computer code for the interchange of information between terminals is
Options: A) ASCII B) BCD C) EBCDIC D) All of above


. Which command is used to see the version of operating system?
Options: a. Vol b. Version c. Ver d. None of the above

Ans: c, c

Sort/Report generators
Options: a . are faster than index/report generators b . require more disk space than indexed/report generators c . do not need to sort before generating report d . both a and b

Ans:D,Both A and B

How many characters can be typed in a single cell in Excel?
Options: a. 256 b. 1024 c. 32000 d. 65535


. __________ is used to build ‘intuitive’ queries.
Options: a. SQL b. Xbase c. QBE d. XML

Ans:1 – c ,1 – c

Which Operating System doesn’t support networking between computers?
Options: Windows 3.1 B. Windows 95 C. Windows 2000 D. Windows NT

Ans:– A ,

. “Ctrl + Up Arrow” is used to
Options: Moves the cursor one page up B. Moves the cursor one line up C. Moves the cursor one screen up D. Moves the cursor one paragraph up

Ans:– D ,

. The system unit of a personal computer typically contains all of the following except:

Options: A) Microprocessor B) Disk controller C) Serial interface D) Modem


. Which of the following CANNOT be done to data using a Form?
Options: a. Store b. Sort c. Edit d. Print

Ans:9 – a ,9 – a

. Which of the following is not a class of computers based on size?
Options: A) Mainframe Computers B) Mini Computers C) Micro Computers D) Super Computers


Where can you change the vertical alignment?
Options:  A) Formatting toolbar, B) Paragraph dialog box, C) Page Setup dialog box, D) Standard toolbar,


A relation has which of the following properties?
Options: Each row is not unique.,    Attributes can have the same name within a given table.,    Each relation has a unique name.,    The order of the columns is significant.

Ans:C ,C

In which addressing mode, the effective address of the operand is generated by adding a constant value to the contents of a register?
Options: Absolute mode,    Indirect mode,    Immediate mode,    Index mode


Which of the following is not an input device?
Options: A) OCR B) Optical scanners C) Voice recognition device D) COM (Computer Output to Microfilm)


In a rule-based system, procedural domain knowledge is in the form of:
Options: production rules,    rule interpreters,    meta-rules,    control rules

Ans:A ,A

Which best describes a fragmented hard drive?
Options: The platters are bad,    Data files are corrupted,    Clusters of data are damaged,    Files are not stored in consecutive clusters

Ans:D ,D

Which of the following symbols is (are) not the Data Flow Diagram (DFD):
Options: a square,    an open rectangle,    a circle,    a triangle

Ans:D ,D

. Registers which are partially visible to users and used to hold conditional codes (bits set by the CPU hardware as the result of operations), are known as
Options: A) PC B) Flags C) Memory Address Registers D) General Purpose Registers


Location transparency allows for which of the following?
Options: Users to treat the data as if it is at one location,    Programmers to treat the data as if it is at one location,    Managers to treat the data as if it is at one location,    All of the above.

Ans:D ,D

What do you need to check serial and parallel port?
Options: Port adapter,    Logic probe,    Loopback plug,    All of the above

Ans:C ,C

What will be the output of the program? #include<stdio.h> #define SWAP(a, b) int t; t=a, a=b, b=t; int main() { int a=10, b=12; SWAP(a, b); printf("a = %d, b = %d\n", a, b); return 0; }
Options: a = 10, b = 12,    a = 12, b = 10,    Error: Declaration not allowed in macro,    Error: Undefined symbol 't'

Ans:B ,B

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

. Bold, Italic, Regular are known as
Options: a. font styles b. font effects c. word art d. text effects

Ans: – A , – A

. Which characteristic of computer distinguishes it from electronic calculators?

Options: A) Accuracy B) Storage C) Versatility D) Automatic


. How do you display current date only in MS Excel?
Options: a. date () b. Today () c. now () d. time ()

Ans:– b,– b

Switches operates in which layer of the OSI model?
Options: Physical layer B. Data link layer C. Network layer D. Transport layer

Ans:B,Data link layer

Websites without a database attached to them have which of the following characteristics?
Options: The ability to generate data via SQL.,    The inability to use a browser to display Web pages.,    Static information using HTML or JavaScript.,    The need to use TCP/IP as the network protocol.

Ans:C ,C

Which language is used in the areas of pattern recognition, artificial intelligence & for simulation of games.
Options: APL,    FORTH,    LISP,    CORAL

Ans:C ,C

The time taken for the read/write head to move to the correct track on the magnetic disk is called
Options: epoch delay,    latency delay,    seek time,    approach time

Ans:C ,C

. 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


. How can you show or hide the gridlines in Excel Worksheet?
Options: a.  Go to Tools >> Options >> View tab and mark or remove the check box named Gridline b.  Click Gridline tool on Forms toolbar c.  Both of above d.  None of above

Ans:– c,– c

Which of the following is true concerning a global transaction?
Options: The required data are at one local site and the distributed DBMS routes requests as necessary.,    The required data are located in at least one nonlocal site and the distributed DBMS routes requests as necessary.,    The required data are at one local site and the distributed DBMS passes the request to only the local DBMS.,    The required data are located in at least one nonlocal site and the distributed DBMS passes the request to only the local DBMS.

Ans:B ,B

Symbolic languages were developed in
Options: 1962,    1950,    1974,    1980


. Which of the following command is used to switch between the window programs?
Options: a. Alt+Tab b. Alt+F4 c. Ctrl+Tab d. None of the above

Ans:5 – a ,5 – a

. MKDIR is similar to
Options: a. MD b. File c. Folder d. Table

Ans:6 – a ,6 – a

Locations in the main memory of a computer are called
Options: Alphabets,    Words,    Data,    Characters

Ans:B ,B

. Edit >> Delete command
Options: a.  Deletes the content of a cell b.  Deletes Formats of cell c.  Deletes the comment of cell d.  Deletes selected cells

Ans:– d,– d

Data System management has long-term viability as a separate business function because
Options: It requires much technical knowledge,    It requires large investments,    Specialists in data systems cannot be integrated into a marketing or manufacturing organization,    An integrated database accessible to all requires independent management

Ans:D ,D