Spreadsheet interview questions – page 4

Any device that performs signal conversion is

1. Plotter
2. Keyboard
3. Modulator
4. Modem

How many characters are there in a cell?

1. 255
2. 257
3. 258
4. 355

A grid of cells with a programmable calculator attached to each cell is a

1. Data sheet
2. Spreadsheet
3. Visible calculator
4. Computer

Which icon is used to change the font colour in Star Office Calc?

1. Justify
2. Bold
3. Font colour
4. Change font

Which identifies each cell?

1. Location address
2. Cell address
3. Row address
4. Pointer

_____ is the most popular Spreadsheet Program.

1. MS-Excel
2. Dbase
3. Lotus 1-2-3
4. Star Office Calc

_____ addressing is the default type of cell address used in the StarCalc.

1. Data cell
2. Function cell
3. Relative cell
4. Absolute cell

Which option is used to save the worksheet created?

1. Save
2. Save As
3. Save or Save As
4. File

Spreadsheets can movie information by

1. Cutting and pasting areas of the worksheet
2. Exchanging the order of columns
3. Exchanging the order of rows
4. All of these

Which is not a feature of spreadsheets?

1. Split windows
2. Word wrap
3. Sort
4. GO TO

The rectangular highlight that appears on the commands is called

1. Menu pointer
2. Indicator
3. Menu
4. Cell pointer

A template does not contain

1. Labels to be provided by the user
2. Formulas to be provided by the user
3. Numerical data to be provided by the user
4. All of these

Which one of the following is not a Spreadsheet program?

1. Quattro Pro
2. MS-DOS
3. Lotus 1-2-3
4. VisiCalc

The bar used to display the current cell and its contents is

1. Menu bar
2. Function bar
3. Formula bar
4. Object bar

A spreadsheet template is

1. A What if feature
2. Formulas and data relationships ready to be calculated as soon as data are entered
3. A clear plastic sheet divided into rows and columns that fits over the computer screen
4. None of these

To calculate the effect of interest rates on sums of money over time, we should use a

1. String function
2. Financial function
3. Statistical function
4. Mathematical function

An electronic spreadsheet consist of

1. Rows
2. Columns
3. Cells
4. All of these

Which one of the following operation is executed first in Mathematics?

1. Multiplication
2. Exponentiation
3. Subtraction
4. Addition

A keyword menu bar

1. is usually activated by typing a slash
2. require only a single screen line
3. gives each command a single letter
4. both (a) and (b)

G7 is an example of a

1. Cell address
2. Macro
3. Template
4. None of these

(B2+C2) is considered as a/an

1. Numeric data
2. Formula
3. Address
4. None of these

AA, AB and BZ are examples of

1. Column labels
2. Templates
3. Macros
4. Cell addresses

Which was the first electronic Spreadsheet?

1. Slide rule
2. Software
3. Quantum Pro
4. Visible calculator

Spreadsheets are made up of

1. Rows
2. Columns
3. Cells
4. Rows and columns

Which company has introduced Quattro pro?

1. Microsoft International
2. Borland International
3. Sun Micro Systems
4. AT&T Corporation

VisiCalc is a

1. Analysis
2. Inventory control
3. Financial analysis
4. Program

StarCalc is a powerful

1. Table
2. Project
3. Spreadsheet program
4. Worksheet program

Operations on text are performed by

1. Financial functions
2. Logical functions
3. Data functions
4. String functions

What computer program lets we use an electronic ledger sheet for financial analysis?

1. Worksheet program
2. Word processors
3. Spreadsheet program
4. Menu driven program

A typical spreadsheet software allows at least

1. 64 columns
2. 128 columns
3. 256 columns
4. 8192 columns