MS-Excel interview questions – page 2

The default file extension of MS Excel is

1. Xlr
2. Exe
3. Xls
4. Exl

By default the cell content alignment is

1. Text left aligned and number right alignment
2. Text right aligned and numbers left alignment
3. Left aligned
4. Centrally aligned

To select the entire column, press

1. Tab + C
2. Tab + E
3. Alt + Space
4. Ctrl + Space

What is a valid version of MS Excel?

1. MS Excel 2007
2. MS Excel 20.16
3. MS Excel XP
4. MS Excel 20.0.1

In A3 cell edit = A1 + A2 refers to

1. Addition of A1 and A3 will display in A2
2. Addition of A1 and A2 will display in A3
3. Addition of A1 and A2 will not display in A3
4. Addition of A2 and A3 will display in A1

______ specify the type of calculation that you want to perform on the elements of a formula.

1. Constants
2. References
3. Operators
4. All of these

When you enter text in a cell in Excel. It also appears in the

1. Status bar
2. Formula bar
3. Row heading
4. Name box

While selecting multiple worksheets in Excel, the following key must also be used when clicking the sheet tab.

1. Alt
2. Ctrl
3. Shift
4. Insert

This dialog box specifies or modifies the worksheet cell range containing data to be charted.

1. Chart Location
2. Chart Style
3. Chart Options
4. Chart Source Data

Which of the following is the purpose of AutoSum?

1. Display the sum of the selected cells directly after the selected cells
2. Display the sum of the selected cells directly before the selected cells
3. Don’t add the grand total
4. All of these

DOS based spreadsheet package is

1. Smartsheet
2. Excel
3. Spread PRO
4. Lotus 1-2-3

When we can create a chart on a separate sheet in the same workbook, it is called a

1. Chart sheet
2. Embedded chart
3. View sheet
4. View chart

____ sign is used to create an absolute cell reference.

1. $
2. @
3. &
4. %

# VALUE! Refers to ___

1. Font value
2. Error in value
3. Subscript of the number value
4. Addition of value

You can undo and redo up to ____ action in Microsoft Office Excel, even after a worksheet is saved.

1. 50
2. 99
3. 100
4. 500

To display the save as dialog box, press

1. F2
2. F3
3. F5
4. F12

The default file extension of MS-Excel is

1. xlr
2. xls
3. exe
4. exl

Which command is used to close the window of Excel?

1. Alt + F4
2. Ctrl + W
3. Ctrl + R
4. Ctrl + C

What is the default column width of MS Excel?

1. 5.5
2. 2.98
3. 6.49
4. 8.43

Press ____ to make the text bold in MS Excel.

1. Ctrl + 1
2. Ctrl + 2
3. Ctrl + 3
4. Ctrl + 4

A ____ is rectangular grid of rows and columns used to enter data.

1. Cell
2. Spreadsheet
3. Worksheet
4. Workspace

How many rows are there in old version of MS Excel?

1. 65536
2. 65535
3. 65534
4. 65533

____ was the first spreadsheet on a microcomputer.

1. VisiCalc
2. Excel
3. Lotus 1-2-3
4. StarCalc

Press ____ to close the window of MS Excel.

1. Esc
2. Ctrl + Alt + C
3. Alt + F4
4. Ctrl + W

Which Excel feature enables predefined layouts to selected tables in the worksheet?

1. Autograph
2. Autoformat
3. Header and Footer
4. Spelling and Grammar

The fill series dialog box in Excel has ____ sections.

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

Which of the following is an active cell in excel?

1. Cell address
2. Range
3. Formula
4. Current cell

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