Standard Formulas
Array Formula
Complex Formulas
Smart Formula
B. Array Formula
From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK
From Edit menu choose Move of Copy then choose (Move to end) and click OK
From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
None of above
CTRL + C
CTRL + Arrow key
CTRL + S
None of the above
Click the save button on the standard toolbar from the menu
Press Ctrl+F5
Click Save on the Windows Start button
Select Edit>Save
From Edit menu choose Clear and then Formats
From Edit menu choose Delete
Click on Remove Formatting tool on Standard Toolbar
Double click the Format Painter and then press Esc key in keyboard
Ctrl + R
Ctrl + Shift + R
Ctrl + H
Ctrl + F
Select the sheet, then choose Edit >> Delete Sheet
Select the sheet then choose Format >> Sheet >> Hide
Both of above
None of above
Deletes the content of a cell
Deletes Formats of cell
Deletes the comment of cell
Deletes selected cells
The autosum button
The Formula button
The quicktotal button
The total button
A type of chart
A cell reference
A collection of related data
A division of results
Area
Line
Pie
All of the above
Copy handle
Fill handle
Insert handle
Border
Save workbook
Modifiy the worksheet
Enter text and data
Copy the worksheet
Cells
Rows
Columns
Document
Delete contents
Delete notes
Delete cells
Delete formats
Wrap Text in Format >> Cells
Justify in Edit >> Cells
Text Wraping in Format >> Cells, Layout tab
All of above
To insert a background
To add borders
To select a distribution of figures
To add shading or color to a cell range
Shorten the label
Increase the column width
Decrease the column width
Adjust the row height
Cut and Paste
Edit >> Paste Special >> Transpose
Both of above
None of above
Apostrophe (&lsquo
Exclamation (!)
Hash (#)
Ampersand (&
Input cells
Constraints
Target cell
Changing cells
Select File > Properties form the menu and type 3 in the Copies to print text box
Select File > Print from the menu and type 3 in the Number of copies text box
Click the Print button on the standard toolbar to print the document then take it to Kinkos and have 2 more copies made
Press Ctrl+P+3
Smart Tip
Cell Tip
Web Tip
Soft Tip
Edit, Chart
Insert, Chart
Tools, Chart
Format, Chart
Efficiency
Aditibility
Description
Clarity
Press the Alt key
Clicking the formula bar
Pressing the F2 key
Double clicking the cell
Pressing an arrow key
Pressing the Tab key
Pressing the Esc key
Clicking on the formula bar
Dialog box
Worksheet
Clipboard
Toolbar
F8
F9
F10
F11
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
Data, Sort
Data, Form
Data, Table
Data Subtotals