Computer interview questions – page 40

The easiest way to modify slightly a cell that contains a long label is to

1. A.Use an erase command to erase the cell and start over
2. B.Retype the correct entry
3. C.Use an edit command to edit the cell
4. D.None of these

To keep a portion of the worksheet fixed in place regardless a how the rest of the worksheet is moved, use

1. A.PROTECT command
2. B.WINDOW command
3. C.FIX command
4. D.TITLE command

Column-oriented recalculation will evaluate a formula in cell C3 before evaluating a formula in

1. A.Cell A2
2. B.Cell B5
3. C.Cell E3
4. D.Both (a) and (c)

If we wanted to perform a series of keystrokes more rapidly, we would use

1. A.A template
2. B.A macro
3. C."what if" feature
4. D.None of these

To print a worksheet, one must

1. A.Decide whether to print the cells as they appear in the display or as they are stored in memory
2. B.Specify the range of cells
3. C.Both (a) and (b)
4. D.None of these

When a new row is inserted

1. A.All preceding rows are moved toward the top of the worksheet
2. B.All following rows are shifted to the right
3. C.All following rows are moved towards the bottom of the worksheet
4. D.Both (a) and (c)

A cell may be used in a mathematical formula if it contains

1. A.A label
2. B.Numerical data
3. C.Both (a) and (b)
4. D.None of these

The status line

1. A.Allows to communicate with the program
2. B.Shows what options are available while you are giving a command
3. C.Tells co-ordinates, value rule, and format rule of a cell
4. D.All of these

To obtain length of an arc, use

1. A.DDMODIFY command
2. B.DIST command
3. C.ID command
4. D.LIST command on the arc

The command used to edit a spline object is

1. A.PEDITSPLINE
2. B.DDCHROP
3. C.DDMODIFY
4. D.SPLINDIT

To make a dependent object such as block or layer belonging to an external reference file, a permanent part of the current drawing file use

1. A.ATTACH command
2. B.XREF command
3. C.XBIND command
4. D.INSERT command

What is technique in which man and machine are blended into a problem solving team, intimately coupling the best characteristics of each?

1. A.CRT
2. B.CAM
3. C.CAD
4. D.None of these

Which of the following is normally used where a high degree no interaction is necessary?

1. A.Online processing
2. B.Intelligent terminal processing
3. C.Remote terminal processing
4. D.Batch mode processing

In the <b>paste</b> operation

1. A.Previous contents of the region where new entries are pasted is stored in a buffer
2. B.Tell the spreadsheet where to place new entries
3. C.Specify the range of cells to be moved
4. D.None of these

Typing a quotation mark in front of an entry tells the spreadsheet that the entry is a

1. A.Number
2. B.Formula
3. C.Label
4. D.None of these

A value tells the spreadsheet how to

1. A.Display the value
2. B.Calculate the cell's value
3. C.Both (a) and (b)
4. D.None of these

A root word dictionary

1. A.Accepts only exact matches
2. B.Strips prefixes and suffixes from words before checking them against the dictionary
3. C.Both (a) and (b)
4. D.Strips prefixes and suffixes from words before checking them against the dictionary

In word processing, the ability to adjust space between two characters is called

1. A.Soft hyphen
2. B.Micro spacing
3. C.Proportional spacing
4. D.Kerning

A on-screen formatter will not always provide an exact copy of what the text will look like on paper because

1. A.Display may not be capable of showing all the characters the printer can generate
2. B.Commands will be present in the file
3. C.Left and right margins will be different
4. D.All of these

Paragraph reforming

1. A.Sets paragraph margins
2. B.Changes the distance between lines from one paragraph to the next
3. C.Shifts words-up to fill shortened lines
4. D.All of these

If name "profit" is assigned to cell D5, then

1. A.Formula D5/2 may be written as "profit"/2
2. B.Value of D5 is "profit"
3. C.Both (a) and (b)
4. D.None of these

If a cell stores a formula, then it displays the

1. A.Result of computing the formula only it is the active cell
2. B.Formula
3. C.Result of computing the formula
4. D.None of these

If a formula should not be adjusted after it is copied, use

1. A.Absolute cell references
2. B.Mixed cell references
3. C.Relative cell references
4. D.None of these

Which of the following color graphics display adapter has the highest resolution?

1. A.VGA
2. B.CGA
3. C.SVGA
4. D.HGA

The command used to modify layer of an object is

1. A.Modify
2. B.CHPROP
3. C.Object
4. D.Layer

The system variable that control whether a dialog box requesting file information is displayed or not displayed is

1. A.FDIALOG
2. B.DIALOG
3. C.DDFILE
4. D.FILEDIA

The "slow sequential output by speech or manual actions" is a characteristic of man for the task method of

1. A.Information output
2. B.Information input
3. C.Error detection
4. D.Editing information

Light pen is

1. A.An output device especially designed to produce hardcopy of graphics
2. B.A television like device used to display data
3. C.Smallest part of a display screen that can be individually controlled
4. D.A light sensitive input device that when touched to the screen the presence of light used to select an entry or indicate a position

Cell B2 contains the formula +D5+F1. If cell B2 is evaluated after cells D5 and F1, then spreadsheet is using

1. A.Natural recalculation order
2. B.Column-oriented recalculation
3. C.Row-oriented recalculation
4. D.Circular references

Which of the following cannot be changed in a spreadsheet?

1. A.Length of a page while printing
2. B.Height of a cell
3. C.Width of a cell
4. D.All of these