. Which of the following is correct?

Options: =POWER(2^3) B. =POWER(2,3)             C. =POWER(2#3) D. =POWER(2*3)

Ans:– B ,

Description: mcqquestions

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

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

During the planning phase, the main activity of the vice-president of information systems is one of
Options: planning,    control,    staffing,    support

Ans:D ,D

A byte consists of
Options: A) One bit B) Four bits C) Eight bits D) Sixteen bits


The systems conversion technique of totally removing the existing system and immediately implementing the new system is called a
Options: pilot conversion,    crash conversion,    phased conversion,    parallel run

Ans:B ,B

Modulation in which the two binary values are represented by two different amplitudes of the carrier frequency is known as
Options: Amplitude-shift keying,    Amplitude,    Amplitude modulation,    Aloha

Ans:A ,A

. Which command will you use to display the system date?
Options: a. Date b. Ver c. Dir d. Format

Ans:4 – a ,4 – a

You can show the shortcut menu during the slide show by
Options: a. Clicking the shortcut button on the formatting toolbar b. Right clicking the current slide c. Clicking an icon on the current slide d. a and b

Ans: – B , – B

Which of the following is not a factor to consider when switching from small to large block size?
Options: The length of all of the fields in a table row.,    The number of columns,    Block contention,    Random row access speed

Ans:B ,B

A lockbox service is used for
Options: depositing cash when bank is closed,    paying bank customer bills automatically,    storing papers in a bank vault,    depositing payments to bank customers

Ans:D ,D

. What does FAT stands for?
Options: a. File attribute type b. File allocation table c. Format All Tabs settings d. File for all type

Ans:0 – b ,0 – b

A device for converting handwritten impressions into coded characters & positional coordinates for input to a computer is
Options: Touch panel,    Mouse,    Wand,    Writing tablet


A person who has a high-school diploma would be least likely to obtain which of the following jobs?
Options: data-entry operator,    librarian,    computer operator,    programmer

Ans:D ,D

Latches constructed with NOR and NAND gates tend to remain in the latched condition due to which configuration feature?
Options: asynchronous operation,    low input voltages,    gate impedance,    cross coupling

Ans:D ,D

From which tag descriptive list starts ?
Options: LL,DS,DD,DL


. Data marker on a chart are linked to data points in a worksheet, therefore,
Options: a. You can automatically apply formatting to a data series b. You can change the position of a data marker and automatically change the data point value in the worksheet c. You can change a data print value and automatically are draw the chart d. a and b

Ans:– b,– b

During what phase, the requirement analysis is performed?
Options: system design phase,    system development phase,    system analysis phase,    system investigation phase

Ans:C ,C

17. What is the smallest width of a column?
Options: a. 0″ b. 0.5″ c. 1″ d. 1.5″

Ans:– B ,– B

What command would you type to list all of the files in the current directory?
Options: DIR,    LIST ALL,    SHOW,    SHOW ME

Ans:A ,A

18. Which command is used to delete all the files extension .txt on the current drive and directory?
Options: a. Del .txt b. Erase .txt c. Del *.txt d. Del *.*/p

Ans:Correct Answer: c ,Correct Answer: c

How many worksheets can a workbook have?
Options: 3 B. 8 C. 255 D. none of above

Ans:– D ,

A laser printer generates a totally black page, what is the cause?
Options: malfunctioning imaging laser,    low level in the toner cartridge,    no power to transfer corona,    no power to the primary corona

Ans:D ,D

. Tree structure displays the
Options: a. File only b. Directory only c. File and directory name d. None of above

Ans:2 – c ,2 – c

Which command is used to send the contents of file named REPORT/TXT to the standard printing device?

Ans:B ,B

. In MS Access, Text Data type may contain maximum character of
Options: a. 255 Character b. 256 Character c. 1064 Character d. No Limit

Ans:– a,– a

The chart wizard term data series refers to
Options: a. A chart legend b. A collection of chart data markers c. A set of values you plot in a chart d. A data label

Ans:#8211; b,#8211; b

  Slides can have
Options: title, text, graphs B. drawn objects, shapes C. clipart, drawn art, visual D. any of the above

Ans:– D ,

A relocate program form is one which
Options: cannot be made to execute in any area of storage other than the one designated for it at the time of its coding or translation.,    consists of a program and relevant information for its relocation.,    can itself performs the relocation of its address-sensitive portions.,    all of the above

Ans:B ,B

System Specifications are used to
Options: describe system flows,    get an accurate picture of the system,    avoids ambiguity,    Ail of the above

Ans:D ,D

In which of the following technologies is the term HFC used?
Options: DSL,    PPPoE,    Frame Relay,    Dedicated T1

Ans:D ,D

What is the jumper setting on a SCSI device to configure it to use the fourth SCSI id? Remember, SCSI ids start with zero.
Options: 010,    110,    011,    101

Ans:C ,C

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


The transmission signal coding method of TI carrier is called
Options: Bipolar,    NRZ,    Manchester,    Binary

Ans:A ,A

Which of the following commands is used to have a two-way communication with any person who is currently logged in?
Options: mail,    mesg,    write,    grep

Ans:C ,C

What will be the output of the program (myprog.c) given below if it is executed from the command line? cmd> myprog friday tuesday sunday /* myprog.c */ #include<stdio.h> int main(int argc, char *argv[]) { printf("%c", *++argv[1]); return 0; }
Options: r,    f,    m,    y

Ans:A ,A

Which file is the batch file that is read while booting a computer?
Options: a. Autoexec.bat b. Auto-batch c. Autoexecutive.bat d. Auto.bat

Ans:Correct Answer: a ,Correct Answer: a

________ is an open source DBMS product that runs on UNIX, Linux and Windows.
Options: MySQL,    JSP/SQL,    JDBC/SQL,    Sun ACCESS

Ans:A ,A

Suppose the peak value of a sinusoidal voltage is 50 V. What is the rms value?
Options: 37.4 V,    35.4 V,    38.74 V,    30.4 V

Ans:B ,B

A characteristic of card systems is:
Options: slowness in processing data,    using cards as records of transactions,    needing a larger DP staff,    all the above


Which of the following terms describe 1024 kilobytes?
Options: Kilobyte,    Megabyte,    Gigabyte,    Terabyte

Ans:B ,B

Two computers that communicate with each other use a simple parity check to detect errors for ASCII transmissions. Which of the following events will always lead to an undeleted error?
Options: one bit or any odd number of bits inverted in a block of data during transmission,    two bits or any even number of bits inverted in a block during transmission,    one bit or any odd number of bits inverted in a byte during transmission,    two bits or any even number of bits inverted in a byte during transmission

Ans:D ,D

Which of the following occurs when one transaction reads a changed record that has not been committed to the database?
Options: Nonrepeatable read,    Phantom read,    Dirty read,    Consistent read

Ans:C ,C

. Circular division of disks to store and retrieve data are known as

Options: A) tracks B) sectors C) cycles D) rings


What will be the output of the program ? #include<stdio.h> void fun(int **p); int main() { int a[3][4] = {1, 2, 3, 4, 4, 3, 2, 8, 7, 8, 9, 0}; int *ptr; ptr = &a[0][0]; fun(&ptr); return 0; } void fun(int **p) { printf("%d\n", **p); }
Options: 1,    2,    3,    4

Ans:A ,A

. You can install fonts from
Options: a. Add from control program b. Font setup files c. Font .ext files d. All of above

Ans:3 – d ,3 – d

Which of the following statements are correct about the program below? #include<stdio.h> int main() { int size, i; scanf("%d", &size); int arr[size]; for(i=1; i<=size; i++) { scanf("%d", arr[i]); printf("%d", arr[i]); } return 0; }
Options: The code is erroneous since the subscript for array used in for loop is in the range 1 to size.,    The code is erroneous since the values of array are getting scanned through the loop.,    The code is erroneous since the statement declaring array is invalid.,    The code is correct and runs successfully.

Ans:C ,C

The ALU and control unit of most of the microcomputers are combined and manufactured on a single silicon chip. What is it called?
Options: Monochip,    Microprocessor,    ALU,    Control Unit

Ans:B ,B

. What is the difference between ‘open’ and ‘open exclusively’
Options: a. Open statement opens access database files and open exclusively opens database files of other program like oracle b. Open exclusive locks whole database so that no one can access it whereas open locks only the record that is being accessed c. Both open and open exclusively are same d. Open exclusive command does not exist in MS Access

Ans:6 – b ,6 – b

A subquery in an SQL SELECT statement is enclosed in:
Options: braces -- {...}.,    CAPITAL LETTERS.,    parenthesis -- (...) .,    brackets -- [...].

Ans:C ,C

. How can you break the current column and start a new column immediately?
Options: a. Press Ctrl + Shift + Enter b. Press Alt + Enter c. Press Ctrl + Enter d. Press Alt + Shift + Enter

Ans:– A,– A

In vi editor, forward search is performed using the command.
Options: :pat,    ?pat,    /pat,    All of the above

Ans:C ,C

Each model of a computer has a unique
Options: Assembly language,    Machine language,    High level language,    All of the above