To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called?
A. Pivot Table Report
B. Pivot Table List
C. Pivot Table Field List
D. HTML
Which among following is not associated with spelling dialogue box?
A. Edit
B. Ignore All
C. Ignore
D. Change
Top open an existing workbook, click the open button on the___________toolbar?
A. form
B. standard
C. Drawing
D. Formatting
If you press ___, the cell accepts your typing as its contents ?
A. Tab
B. Ctrl+Enter
C. Enter
D. Alt+Enter
The default style for new data keyed in a new workbook is ___________?
A. Comma
B. Normal
C. Currency
D. Percent
How we can view a cell comment ?
A. position the mouse pointer over the cell
B. click the comment command on the view menu
C. click the edit comment commands on the Insert menu
D. click the Display comment command on the window menu
Which of these will not select all the cells in a document ?
A. Using the Edit – Select All menu
B. Pressing Ctrl + A on the keyboard
C. Clicking three times with the right mouse button in the spreadsheet
D. None of These
In a computer spreadsheet rows are labeled ________ ?
A. by letters
B. by numbers
C. by cell references
D. by symbols
Basic unit of a computer worksheet in which you enter text and numbers is known as __________ ?
A. workbook
B. column
C. row
D. cell
Computer spreadsheet cell that is highlighted with a heavy border is a _________ ?
A. Active cell
B. Cell containing a formula
C. Locked cell
D. Cell
In a computer spreadsheet, which is true if current or active cell is B4 and you pressed Enter key?
A. you will be in the cell A1
B. you will be in the cell B5
C. you will be in the cell B3
D. you will be in the cell B6
Main window in a computer spreadsheet is called ___________ ?
A. Work book
B. Work
C. Account book
D. Work sheet
Which of the following will not enter data in a cell?
A. Pressing the Esc key
B. Pressing the Tab Key
C. Both of these
D. None of above
In a computer spreadsheet, cell range A3 through G3 should be keyed in as _________ ?
A. A3-G3
B. A3:G3
C. A3?.G3
D. A3 to G3