Goal seek
Solver
Scenario manager
Auto Outline
D. Auto Outline
Group of Columns
Group of Worksheets
Group of Rows
Group of Workbooks
Press Ctrl +Home
Press Home
Press Shift + Home
Press Alt + Home
format cells containing numbers
create and edit formula containing functions
enter assumptions data
copy a range of cells
Contents
Objects
Scenarios
All of the above
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
Press the Erase key
Press Esc
Press the Enter button
Press the Edit Formula button
Number
Character
Label
Date/time
work sheet
chart sheet
module sheet
data sheet
You can search for bold and replace with italics
You can decide whether to look for the whole word or not
You can search in formula too
You can search by rows or columns or sheets
Multiply the selection by a copied value
Cell comments
Formatting options
The resulting values of a formula instead of the actual formula
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
$
*
%
&
=SUM(Sales)-A3
=SUM(A1:A5)*.5
=SUM(A1:A5)/(10-10)
=SUM(A1:A5)-10
Area
Line
Pie
All of the above
The edit formula button
The cancel button
The enter button
All of the above
It can contain text and data
It can be modified
It can contain many sheets including worksheets and chart sheets
You have to work hard to create it
Select the column heading you want to delete and select the Delete Row button on the standard toolbar
Select the column heading you want to delete and select Insert Delete from the menu
Select the row heading you want to delete and select Edit>Delete from the menu
Right click the column heading you want to delete and select delete from the shortcut menu
When you use multiplication, division, or exponentiation in a formula
When you use addition and subtraction in a formula
Because excel uses hidden decimal places in computation
When you show the results of formulas with different decimal places that the calculated results
Media player
Sound Recorder
Calculator
Macro Recorder
Number
Character
Label
Date/Time
AutoFill
Auto correct
Auto sum
Auto format
!A!1
$A$1
#a#1
A1
Select the cell you want to place the formula into
Type the equals sign (=) to tell Excel that youre about to enter a formula
Enter the formula using any input values and the appropriate mathematical operators that make up your formula
Choose the new command from the file menu
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
F3
F5
F7
F9
Copy handle
Fill handle
Insert handle
Border
Double click the object
Select the object by clicking it
Press the Shift + Delete keys
Select it and then press the delete key
double clicking on the column name on column header
Double click on the cell pointer in worksheet
Double clicking on column right border on column header
Double clicking on the column left border of column header
Geometric modeling tool
A cell that points to a drawing object
A formula that either directly or indirectly depends on itself
Always erroneous
By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
By dragging a range of excel data to the word button on the taskbar while pressing Shift key
By dragging a range of excel data to the word button on the taskbar while pressing Alt key
None of above