Paper
Margin
Layout
Orientation
B. Margin
=
+
(
@
Accessing
Referencing
Updating
Functioning
!A!1
$A$1
#a#1
A1
Formula bar
Status Bar
Name Box
Title Bar
Open the font dialog box
Apply double underline for the active cell
Fill down in the selection
None of above
Smart Tip
Cell Tip
Web Tip
Soft Tip
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
Square
Percentage
Goal Seek
Divide
auto formatting
applying styles
changing fonts
all of above
Press the Alt key
Press the F2 key
Click the formula bar
Double click the cell
standard formulas
array formula
complex formulas
smart formula
F8
F9
F10
F11
The autosum button
The Formula button
The quicktotal button
The total button
Shows the location of the previously active cell
Appears to the left of the formula bar
Appears below the status bar
Appears below the menu bar
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
Title Bar
Menu Bar
Formula Bar
Standard Tool Bar
Press the Alt key
Press Tab
Press Enter
None of above
Pressing the Tab key
Clicking the cell
Pressing an arrow key
All of the above
Apostrophe ( )
Exclamation ( ! )
Hash ( # )
Ampersand ( & )
Dialog box
Worksheet
Clipboard
Toolbar
Pressing an arrow key
Pressing the Tab key
Pressing the Esc key
Clicking on the formula bar
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
From Border tab in Format Cells dialog box
From Border tool in Formatting toolbar
From Line Style tool in Drawing toolbar
You can not set page border in Excel
F3
F5
F7
F9
With the copy, paste and cut commands on the edit menu
With commands on the shortcut menu
With buttons on the standard toolbars
All of the above
None of these
Select Format > Money from the menu
Click the Currency Style button on the formatting toolbar
You have to retype everything and manually add the dollar signs, commas, and decimals
Apostrophe ( )
Exclamation ( ! )
Hash ( # )
Tilde ( ~ )
Press the Erase key
Press Esc
Press the Enter button
Press the Edit Formula button
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
Standard Formulas
Array Formula
Complex Formulas
Smart Formula