Which of the following is not a term of MS-Excel?

Options: Cells B. Rows C. Columns D. Document

Ans:– D ,

Description: mcqquestions

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

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

. 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 ,

. The delete confirmation generated by …switch
Options: a. /p b. /b c. /w d. /c

Ans:4 – a ,4 – a

. Superscript, subscript, outline, emboss, engrave are known as
Options: a. font styles b. font effects c. word art d. text effects

Ans: – B , – B

Which is the first compiler-level language developed by a team of IBM programmers led by John Backus and unveiled in 1957?
Options: BASIC,    PL/1,    FORTRAN,    APL

Ans:C ,C

What value will display if the formula = “$55.00″+5 is entered into a cell?
Options: $60 B. 60 C. “$55.00″+5 D. $60.00

Ans:– B ,

Point out the error in the program? #include<stdio.h> int main() { struct bits { float f:2; }bit; printf("%d\n", sizeof(bit)); return 0; }
Options: 4,    2,    Error: cannot set bit field for float,    Error: Invalid member access in structure

Ans:C ,C

A 'number crunching' computer is one that can handle
Options: large spreadsheets,    large alphanumeric data,    large volume of numbers,    only numbers


. How to restrict the values of a cell so that only whole numbers between 9 and 99 can be entered in a cell.
Options: a. The Settings tab under the menu Format -> Cells b. The Settings tab under the menu Data -> Validation c. The Settings tab under the menu Data -> Filter -> Advanced Filter d. the Settings tab under the menu Format -> Conditional Formatting

Ans:– b,– b

. Which of the following toolbars provides different options in various master views?
Options: a. Common tasks toolbar b. Drawing toolbar c. Formatting toolbar d. Standard toolbar

Ans:7 – A ,7 – A

The _____ is a business-oriented data-processing association which publishes a monthly journal, Data Management.
Options: DPMA,    CDP,    CISA,    ACM

Ans:A ,A

. Which of the cell pointer indicate that you can move the content to other cell?
Options: a.  Doctor’s symbol (Big Plus) b.  small thin plus icon c.  Mouse Pointer with anchor at the tip d.  None of above

Ans:– c,– c

. Which is not a command that is selectable from right click menu of a field column?
Options: a. Hide columns b. Rename columns c. freeze columns d. sort descending

Ans:– b,– b

Does there any function exist to convert the int or float to a string?
Options: Yes,    No,    ,    

Ans:A ,A

. From where do you change mouse setting?
Options: a. Setting >> mouse b. Hardware setting c. Control panel >> mouse d. None of the above

Ans:1 – c ,1 – c

A manager would use a file manipulation language such as APL to cause the computer to
Options: produce pre-computed information, such as ratios,    perform screening and selection of data from the data base,    both (a) and (b),    neither (a) nor (b)

Ans:B ,B

The terminal device often used in checking charge cards that offers both a limited keyboard input and visual output is the:
Options: Intelligent terminal,    POS terminal,    Video display terminal,    Audio response unit

Ans:C ,C

. Who invented EDSAC?
Options: A) John v. Neumann B) J.p. Eckert and John Mauchley C) Maurice Wilkes D) Howard Aiken


The earliest device that qualifies as a digital computer is
Options: EDSAC,    Abacus,    ENIAC,    EDVAC

Ans:B ,B

Software that's loaded into a computer primary storage area is known as
Options: Memory-resident package,    File management system,    Electronic spread sheet program,    Utilities

Ans:A ,A

What is meant by quad-density (QD) diskette?
Options: It is double-sided disk,    It is double density disk,    It has double the number of tracks per inch,    All of the above

Ans:D ,D

Which of the following systems software does the job of merging the records from two flies into one?
Options: Documentation system,    Utility program,    Networking software,    Security software

Ans:B ,B

. When you add fields in ____, a Field List pane displays.
Options: a. Design View b. Layout View c. Print Preview d. Report View

Ans:0 – b ,0 – b

How can you remove tab stop markers from ruler?
Options:  A) Double click the tab marker and choose Clear All, B) Drag the tab stop marker out of the ruler, C) Right click the tab stop marker and choose remove, D) All of above,


Which of the following commands is used to identify the type of file by context?
Options: ls,    cat,    file,    more

Ans:C ,C

The type of information most restricted by a poor interface between generalized data base management systems and special computing system languages is
Options: supervisory,    planning,    priority setting,    limitation

Ans:B ,B

Which command displays current directory name or change from one to another?
Options: a. Chdir b. Cd c. Mkdir d. Both a and b

Ans:d. Both a and b,d. Both a and b

While working with MS-DOS, which command is used to move file from one directory to another?
Options: RENAME,    COPY,    MOVE,    CP

Ans:C ,C

If a robot can alter its own trajectory in response to external conditions, it is considered to be:
Options: intelligent,    mobile,    open loop,    non-servo

Ans:A ,A

Waveforms are graphs that show:
Options: frequency on the vertical axis and amplitude on the horizontal axis,    amplitude on the vertical axis and frequency on the horizontal axis,    amplitude on the vertical axis and the passage of time on the horizontal axis,    the passage of time on the vertical axis and amplitude on the horizontal axis

Ans:C ,C

Which of the following registers is used to keep track of address of the memory location where the next instruction is located?
Options: a. Memory Address Register b. Memory Data Register c. Instruction Register d. Program Register


Database redesign is not terribly difficult if the:
Options: database is structured.,    database is well-designed.,    database has no data.,    database is relatively small.

Ans:C ,C

. which of the following is problem oriented language?
Options: A) High level language B) Machine language C) Assembly language D) Low level language


In a punched card system, data is processed by a
Options: keypunch machine, sorter, and posting machine,    accounting machine, posting machine, and billing machine,    sorter, posting machine, and billing machine,    accounting machine, keypunch machine, and sorter


Which of the following best illustrates the default subnet mask for a class A,B, and C Network?

Ans:C ,C

Which of the following abilities is/are required for both the system programmer and the EDP auditor?
Options: knowledge in computer science,    knowledge in accounting applications,    two of the above,    knowledge in information systems

Ans:A ,A

Which of the following is true concerning personal computers?
Options: They decrease the demand for mainframe computers,    They have been most successful in the home,    The electronic spreadsheet has been a primary reason for their popularity,    Their future is not so bright owning to the improved cost-performance ratio of minis and mainframes

Ans:C ,C

.    Which command displays only file and directory names without size, date and time information?
Options: a.    Dir/w b.    Dir a: c.    Dir /b d.    Dir /s

Ans:c,Correct Answer: dir/b

Assuming 100% efficiency, what is the power being applied to the primary winding of the transformer described in the above question?
Options: 200 W,    1000 W,    20 W,    100 W

Ans:A ,A

Queries in Access can be used as
Options: a. view, change and analyze data in different ways b. a source of records for forms and reports c. Only a d. Both a and b

Ans:ndash; d,ndash; d

CHKDSK command is used to
Options: a. Analyze the hard disk error b. Diagnose the hard disk error c. Report the status of files on disk d. All of the above

Ans:Correct Answer: d ,Correct Answer: d

Which setting you must modify to print a worksheet using letterhead?
Options: Paper B. Margin C. Layout D. Orientation

Ans:– B ,

What is the name of the computer terminal which gives paper printout?
Options: Display screen,    Soft copy terminal,    Hard copy terminal,    Plotter

Ans:C ,C

. Scandisk
Options: a. Checks the disk b. Give information about disk c. Run from DOS mode d. All of the above

Ans:9 – d ,9 – d

Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?
Options: DEFINE TABLE,    MODIFY TABLE,    ALTER TABLE,    All of the above

Ans:C ,C

A transaction for which all committed changes are permanent is called:
Options: atomic.,    consistent.,    isolated.,    durable.

Ans:D ,D

Software is:
Options: printer output,    a set of instructions,    tape input.,    a programming language

Ans:B ,B

Holding down the Shift key and rotate the image will rotate in increments of
Options: 10 degrees B. 15 degrees C. 20 degrees D. 25 degrees

Ans: – B ,

.   The auto shapes tool provides you with
Options: a. Fancy text to place on your slide b. Commonly found shapes c. Any shape you want to add on a slide d. Clip art that is related to your presentation

Ans:8 – B ,8 – B

The accuracy of a pick-and-place robot can be as good as:
Options: + 0.0005 inches,    + 0.05 inches,    0.008 inches,    + 3%

Ans:A ,A

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

Ans:C ,C