Number
Character
Label
Date/Time
B. Character
COUNTA ()
function do?counts cells having alphabets
counts empty cells
counts cells having number
counts non-empty cells
Edit -> Comments
Insert -> Comment
File -> Comments
View > Comments
date ()
Today ()
now ()
time ()
standard formulas
array formula
complex formulas
smart formula
Title bar
Menu bar
Formula bar
Standard toolbar
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
Formula bar
Status Bar
Name Box
Title Bar
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
Labels, values, and formulas
Labels and values but not formulas
Values and formulas but not labels
Formulas only
Allow you to view a different worksheet
Allow you to view additional worksheet rows down
Allow you to view additional worksheet columns to the right
Allow you to view additional sheets tabs
Open the font dialog box
Apply double underline for the active cell
Fill down in the selection
None of above
Efficiency
Aditibility
Description
Clarity
CTRL + C
CTRL + Arrow key
CTRL + S
None of the above
The entire worksheet
Rows
Columns
All of the above
Select the sheet, then choose Edit >> Delete Sheet
Select the sheet then choose Format >> Sheet >> Hide
Both of above
None of above
Copy handle
Fill handle
Insert handle
Border
You can use the format painter button on ly one time when you click it
Double clicking the format painter button
Pressing the Ctrl key and clicking the format painter button
Pressing the Alt key and clicking the format painter button
Goal seek
Solver
Scenario manager
Auto Outline
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
Format -> Window
View -> Window-> Split
Window -> Split
View > Split
A chart plot area
A horizontal axis
The organization of individual values with a charts data series
The data range that supply chart data
Custom List
Auto Fill Options
Fill Across Worksheet
Fill Series
Ctrl+C
Ctrl+Enter
Ctrl+Page Up
Ctrl+Space Bar
Choose None on Border tab of Format cells
Open the list on Border tool in Formatting toolbar then choose first tool (no border)
Both of above
None of above
Multiply the selection by a copied value
Cell comments
Formatting options
The resulting values of a formula instead of the actual formula
5430
5436.80
5436.8
6.8
Press the Alt key
Clicking the formula bar
Pressing the F2 key
Double clicking the cell
Geometric modeling tool
A cell that points to a drawing object
A formula that either directly or indirectly depends on itself
Always erroneous
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
Apostrophe (&lsquo
Exclamation (!)
Hash (#)
Ampersand (&