1.
With which of the following all formulas in excel starts ?
- /
- *
- $
- =
2.
On an excel sheet the active cell is indicated by ?
A dark
wide border
3.
What term describes explanatory text attached to a cell ?
Comment
4.
How we can view a cell comment ?
position
the mouse pointer over the cell
5.
Which of these will not select all the cells in a document ?
- Using the Edit � Select All menu
- Pressing Ctrl + A on the keyboard
- Clicking three times with the right mouse button in the spreadsheet
6.
The default style for new data keyed in a new workbook is ?
Normal
7.
If you press ___, the cell accepts your typing as its contents ?
Enter
8.
Which of the following keyboard shortcut can be used for creating a chart from
the selected cells ?
1.
F11
- F10
- F4
- F2
9.
Formula palette is used to ?
create and
edit formulas containing functions
10.
A value used in a formula that does not change is called a ?
Constant
11.
A Spreadsheet contains ?
rows and
columns
12.
To open an existing workbook, click the Open button on the ___ toolbar ?
Standard
13.
Which among following is not associated with spelling dialogue box ?
1.
Edit
- Ignore
- Ignore All
- Change
14.
what term describes a background that appears as a grainy, non smooth surface ?
Gradient
15.
Which among following is associated with excel ?
- Graphic program
- Word Processor
- Presentation
- Spreadsheet
16.
The cell reference for a range of cells that starts in cell C1 and goes over to
column H and down to row 10 is ?
C1:H10
17.
You can convert existing Excel worksheet data and charts to HTML document by
using the ?
Internet
Assistant Wizard
18.
To create an interactive Pivot Table for the web, you use a Microsoft Office
Web component called ?
Pivot
Table Report
19.
What function displays row data in a column or column data in a row ?
Transpose
20.
Except which of the following function, a formula with a logical function shows
the word "TRUE" or "FALSE" as a result ?
- NOT
- OR
- IF
- AND
Back Part 1 2 3 4
