Computer interview questions – page 121

What is the pictorial representation of worksheet data?

1. Chart
2. Clipart
3. WordArt
4. All of these

Which function displays row data in a column or column data in a row?

1. Rows
2. Transpose
3. Hyperlink
4. Index

___ operator, combines multiple references into one reference.

1. Ampersand
2. Space
3. Comma
4. Colon

Excel is a program that is used to prepare a

1. Slide presentation
2. Spreadsheet
3. Text document
4. Database

In which tab wrap text feature is present in MS Excel 2007?

1. Formulas
2. View
3. Insert
4. Home

Which of the following identifies a cell in Excel?

1. Address
2. Formula
3. Name
4. Label

Which term is used to join the selected cells in to one cell?

1. Filter
2. Wrap
3. Pivot
4. Merge

Which of the following Excel charts represents only one value for each variable?

1. Bar
2. Pie
3. Line
4. Function

A formula in Excel always begins with an ____

1. Equal sign
2. Colon
3. Comma
4. Space

Press ___ to close an open menu or submenu, dialog box, or message window.

1. Tab+ctrl+6
2. Esc
3. Alt+ 5
4. Ctrl+ 1

To insert nonadjacent columns, hold down ____ while you select nonadjacent columns.

1. Space
2. Ctrl
3. Tab
4. Alt

In a spreadsheet program, the ___ contains related worksheets and documents.

1. Cell
2. Formula
3. Column
4. Workbook

Forms that are used to organise business data into rows and columns are called

1. Spreadsheets
2. Business forms
3. Registers
4. Transaction sheet

Which of the following characteristics is used to compute dynamically the results from Excel data?

1. Chart
2. Formula and Function
3. Table
4. Diagram

____ is a powerful tool used to create and format spreadsheets.

1. Adobe Photoshop CS
2. Mozilla Firefox
3. Microsoft Office PowerPoint
4. Microsoft Office Excel

Workbook is a collection of

1. Worksheets
2. Page set-up
3. Buttons
4. Diagrams

The worksheet names appear on tabs at the ____ of the workbook window.

1. Bottom right
2. Bottom left
3. Top left
4. Top right

The result of a formula in a cell is the

1. Displayed value
2. Range
3. Value
4. Label

____ is the intersection of a row with a column.

1. Cell
2. Row
3. Column
4. All of these

A data structure in which linear sequence is maintained by pointers is known as

1. Array
2. Stack
3. Linked list
4. Pointer-based data structure

Which of the following data structure works on the principle of First Come First Serve?

1. Priority queue
2. Heap
3. Stack
4. Queue

A  ____ is a linear collection of self-referential structures, called nodes, connected by pointer links.

1. Queue
2. Linked list
3. Tree
4. Stack

A queue where all elements have equal priority is a

1. ILFO data structure
2. LILO data structure
3. FIFO data structure
4. LIFO data structure

A file that is only read by a program is known as ____

1. Input file
2. Temporary file
3. Work file
4. Input/output file

Which of the following is not an open addressing technique to resolve collisions?

1. Linear probing
2. Cubic probing
3. Double hashing
4. Quadratic probing

Which of the following is not a term pertaining to spreadsheets?

1. Cell
2. Character
3. Browser
4. Formula

Another name for a pre-programmed formula in Excel is

1. Cell
2. Graph
3. Function
4. Range

Typed text showed in active cell and also in ___

1. Formula bar
2. Ribbon
3. Title bar
4. Scroll bar

What is the default row height of MS Excel?

1. 10
2. 12
3. 13
4. 15

Excel documents are stored as files called

1. Workgroups
2. Worktables
3. Worksheets
4. Workforce