MS-Excel interview questions – page 3

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

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

What refers to the horizontal cells which can contain information?

1. Ribbon
2. Rows
3. Columns
4. Horizontal scrollbar

Today motherboard typically use

1. 70 pin modules
2. 72 pin modules
3. 74 pin modules
4. 76 pin modules

To minimize the currently selected window, press

1. Ctrl+ F11
2. Ctrl+ F12
3. Ctrl+ F9
4. Ctrl+ F10

To maximize the currently selected window, press

1. Ctrl+ F9
2. Ctrl+ F10
3. Ctrl+ F11
4. Ctrl+ F12

Which of the following is the default numbers of worksheet in MS Excel?

1. 2
2. 3
3. 4
4. 5

Formulas in Excel are made up of ___

1. Arithmetical operators and functions
2. Only arithmetic operators
3. Only symbols
4. Only functions

The result is a ___ value either TRUE or FALSE.

1. Logical
2. Arithmetic
3. Algorithm
4. Logarithm

Which of the following is the comparison operator?

1. *
2. ^
3. =
4. +

On an Excel sheet, the active cell is indicated by

1. A dark wide border
2. A dotted border
3. A blinking border
4. None of the above