MS-Excel interview questions

To displays the Find and Replace dialog box, with the Find tab selected press

1. Alt + F
2. Tab + F
3. Esc + F
4. Ctrl + F

Press ______ to displays the format cell dialog box in MS Excel.

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

Pre-defined and built in formulas in Excel are known as

1. Autosheets
2. Charts
3. Functions
4. Tables

Press ______ to saves the active file with its current file name, location, and file format.

1. Ctrl + S
2. Alt + S
3. Ctrl + Alt + Esc
4. Alt + Tab + Esc

Use the _____ to join, or concatenate, one or more text strings to produce a single piece of text.

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

______ inserts a new worksheet.

1. Alt + Shift + F1
2. Alt + Shift + F2
3. Alt + Shift + F3
4. Alt + Shift + F4

_____ creates a chart of the data in the current range.

1. Alt + F1
2. Ctrl + F1
3. Ctrl + Alt + F1
4. Esc + F1

Which sign is used for absolute addressing?

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

Press ______ to open the Excel formula window.

1. Shift + F3
2. Shift + F4
3. Shift + F5
4. Shift + F6

A spreadsheet is a sheet which is spread in such a way that it divides itself into the various _____ and ______

1. Horizontal columns, vertical row
2. Horizontal table, vertical cell
3. Horizontal cell, vertical table
4. Horizontal row, vertical columns

Press ______ to displays the Print dialog box in MS Excel.

1. Alt + P
2. Ctrl + P
3. Esc + P
4. Tab + P

VisiCalc is a program developed by

1. Charles Hokens in 1977
2. Steve Mc Neon in 1989
3. Operah Helen in 1986
4. Dan Bricklin in 1979

To displays the open dialog box to open or find a file, press

1. Alt + O
2. Ctrl + O
3. Esc + O
4. Tab + O

Which of the following function used to adds the values in the function argument or the values in the all references in the argument?

1. ADD
2. SUM
3. TOTAL
4. LIST

When a chart is placed on this, it is much larger and there is no other data on it.

1. Reference sheet
2. Primary sheet
3. Exclusive sheet
4. Chart sheet

What are commonly be used to performs many different types of calculations?

1. Word document
2. Slides
3. Spreadsheets
4. All of these

Which of the following term is related with legends?

1. Operator
2. Chart
3. Word art
4. Clipart

Press _____ to undo in MS excel.

1. Ctrl + C
2. Ctrl + U
3. Ctrl + X
4. Ctrl + Z

______ moves to the previous cell in a worksheet or the previous option in a dialog box.

1. Alt + Tab
2. Ctrl + Tab
3. Esc + Tab
4. Shift + Tab

Repeats the last command or action

1. Ctrl + C
2. Ctrl + R
3. Ctrl + U
4. Ctrl + Y

_____ are equations that perform calculations on values in your worksheet.

1. Functions
2. References
3. Formulas
4. Constants

Press _____ to bring up search box.

1. Shift + F3
2. Shift + F4
3. Shift + F5
4. Shift + F6

In ______ tab you will find AutoSum button.

1. Formatting tab
2. Formulas tab
3. Standard tab
4. Clipboard tab

Press _____ to create a chart.

1. F1
2. F5
3. F11
4. F12

The view that puts a blue line around each page that would be printed is the

1. Split view
2. Page break preview
3. Print preview
4. Normal view

Cuts the selected cells

1. Ctrl + X
2. Ctrl + C
3. Ctrl + V
4. Ctrl + B

Press the ______ key to move the insertion point to the first cell in a row in Excel.

1. Page Up
2. Page Down
3. Home
4. Tab

______ of the worksheet appear vertically and are identified by letters at the top of the worksheet window.

1. Columns
2. Cells
3. Rows
4. Headings

Press _____ to select all rows and columns in the worksheet.

1. Ctrl + A
2. Ctrl + B
3. Ctrl + C
4. Ctrl + D

Which one of the following software applications would be the most appropriate for performing numerical and statistical calculations?

1. Graphics package
2. Spreadsheet
3. Document processor
4. Database