AGBE 3200
You can activate a cell by ?
All of the above
Which of these will not select all the cells in a document ?
Clicking three times with the right mouse button in the spreadsheet
How do you change column width to fit the contents ?
Double click the boundary to the right of the column heading
Which among following is not associated with spelling dialogue box ?
Edit
If you press ___, the cell accepts your typing as its contents ?
Enter
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
What is shortcut to enter current date in cell in excel ?
CTRL + ;
To drag a selected range of data to another worksheet in the same workbook, use the ?
CTRL Key
Shortcut to edit the selected cell ?
F2
You can convert existing Excel worksheet data and charts to HTML document by using the ?
Internet Assistant Wizard
Which function in excel counts the numbers of characters in a cell ?
LT
What term describes explanatory text attached to a cell ?
comment
Shortcut to delete the selected column ?
ctrl + -
Which shortcut can be used to Switch between open workbooks ?
ctrl + F6
Which of the following keyboard shortcut can be used for creating a chart from the selected cells ?
f11
A function inside another function is known as ?
Nested Function
The default style for new data keyed in a new workbook is ?
Normal
Which function calculates your monthly mortgage payment ?
PMT
The accounting style shows negative numbers in ?
Parentheses
To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called ?
Pivot Table Report
A Spreadsheet contains ?
Rows and columns
How is data organized in a spreadsheet ?
Rows and columns
VLOOKUP function used to ?
Finds related records
what term describes a background that appears as a grainy, non smooth surface ?
Gradient
To insert three columns between columns A and B you would
Select B
Except which of the following function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result ?
IF
Which function is used for creating a data table
Table
How we can view a cell comment ?
position the mouse pointer over the cell
Which among following wildcard characters are recognized by excel ?
* and ?
Which of the following is not a valid Zoom percentage in Excel ?
500
With which of the following all formulas in excel starts ?
=
On an excel sheet the active cell in indicated by ?
A Blinking Border
Which types of charts can excel produce ?
Bar charts, line graphs, and pie charts
You can check the conditions against _____ when applying conditional formatting ?
Both of above (cell value & formula)
A value used in a formula that does not change is called a ?
Constant
Which function converts miles to kilometers ?
Convert
Formula palette is used to ?
Create and edit formulas containing functions
What excel feature can you use if you want to work with one record at a time ?
Data Form
3-D reference in a formula ?
Spans Worksheet
Which among following is associated with excel ?
Spreadsheet
To open an existing workbook, click the Open button on the ___ toolbar ?
Standard
Macros can be executed from the which of the following menu ?
Tools
Protection and the Protect Sheet options can be selected from ?
Tools
What function displays row data in a column or column data in a row ?
Transpose
How can we set Page Border in Excel ?
You can not set a page border in Excel
