Computer interview questions – page 22

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

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

The conversion of analog sound waves to a digital format is called

1. amplitude
2. sampling
3. pitch
4. frequency

Sound and video in multimedia application can be played _____ or by using a _____

1. inline, helper
2. help, online
3. onliner, help
4. inline, help

The act of allowing the users to participate actively are called _____ multimedia.

1. extractive
2. interactive
3. internal
4. external

Multimedia _____ are very effective in explaining difficult conceps and facts.

1. slides
2. simulations
3. program
4. presentation

While downloading on the web ____ the multimedia element, particularly videos in smaller windows.

1. display
2. exhibit
3. present
4. show

A ______ graphic is a visual representation of your information that you can fully customize in MS PowerPoint?

1. Rubber
2. Magic tool
3. SmartArt
4. All of these

______ is one of the most popular presentation programs supported by both Mac and PC platforms.

1. Avira
2. Adobe Reader
3. Windows Media Player
4. Microsoft PowerPoint