Input cells
Constraints
Target cell
Changing cells
A. Input cells
Title bar
Menu bar
Formula bar
Standard toolbar
The Alt key
The Tab key
The Enter key
None of the above
Replace cell references
Return ASCII values of characters
Concatenate and manipulate text
Show formula error value
Edit >> Delete
Edit >> Clear >> Contents
Edit >> Clear >> All
Data >> Delete
Solver
Goal seek
Scenario Manager
All of above
Shorten the label
Increase the column width
Decrease the column width
Adjust the row height
Apostrophe ( )
Exclamation ( ! )
Hash ( # )
Tilde ( ~ )
Ctrl + R
Ctrl + Shift + R
Ctrl + H
Ctrl + F
You can Find and Replace within the sheet or workbook
Excel does not have option to match case for find
Both are valid
None are valid
Values but not cell references
Cell references but not values
Values or cell references although not both at the same time
Value and cell references
Cells B7 and cell B9 only
Cells B7 through B9
Cell B8 only
None of the above
Select Edit > Select > Column from the menu
Click the column heading letter
Hold down the shift key as you click anywhere in the column
Hold down the Ctrl key as you click anywhere in the column
Dialog box
Worksheet
Clipboard
Toolbar
Pmt
Average
Max
Sum
Input cells
Constraints
Target cell
Changing cells
Page Break Preview
Page Orientation
Margins
Headers and Footers
Custom List
Auto Fill Options
Fill Across Worksheet
Fill Series
Multiplication and division exponentiation positive and negative values
Multiplication and division, positive and negative values, addition and subtraction
Addition and subtraction, positive and negative values, exponentiation
All of above
Choose required color form Patterns tab of Format Cells dialog box
Choose required color on Fill Color tool in Formatting toolbar
Choose required color on Fill Color tool in Drawing toolbar
All of above
Title Bar
Menu Bar
Formula Bar
Standard Tool Bar
F3
F5
F7
F9
Select the cells containing the title text plus the range over which the title text is to be centered
Widen the columns
Select the cells containing the title text plus the range over which the title text is to be enfettered
Format the cells with the comma style
standard formulas
array formula
complex formulas
smart formula
Group of Columns
Group of Worksheets
Group of Rows
Group of Workbooks
Logical
Math & Trigonometry
Statistical
Financial
Excel erases the original copy of the formula
Excel edits cell references in the newly copied formula
Excel adjusts absolute cell references
Excel doesnt adjust relative cell references
Visual Basic
C
Visual C++
Java
Label
Value
Formula
Text string
Sheet tabs can be colored
Some picture can be applied as a background of a sheet
You can set the column width automatically fit the amount of text
The width of a row and be specified manually or fit automatically
One sheet is selected
When many sheets are selected
When no sheet is selected
None of above