Edit, Chart
Insert, Chart
Tools, Chart
Format, Chart
B. Insert, Chart
data will be entered in the adjecent cells
no data will be entered in the adjacent cells
there is no suitable abbrevition for the text
there is not time to format the text
Accessing
Referencing
Updating
Functioning
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
You can add more than one condition to check
You can set condition to look for Bold and apply Italics on them
You can apply Font, border and pattern formats that meets the specified conditions
You can delete any condition from Conditional Formatting dialog box if it is not requried
An absolute cell address is created
Cell address will change when it is copied to another cell
The sheet tab is changed
The status bar does not display the cell address
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
Input cells
Constraints
Target cell
Changing cells
A command used for data modeling
A range of values such as from 23 to 234
A group of cells
A group of worksheets
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
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
3
8
255
none of above
A type of chart
A cell reference
A collection of related data
A division of results
Edit > Comments
Insert > Comments
File > Comments
View > Comments
$
*
%
&
Copy the cells in row, select the same number of cells in row and paste
Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK
Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK
Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK
A chart plot area
A horizontal axis
The organization of individual values with a charts data series
The data range that supply chart data
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
0
1
5
10
Press Ctrl +Home
Press Home
Press Shift + Home
Press Alt + Home
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
Deletes the object
Nothing the right mouse button is there for left handed people
Opens a shortcut menu listing everything you can do to the object
Selects the object
Edit >> Clear >> Contents
Edit >> Clear >> All
Edit >> Delete
All of above
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
Press the Erase key
Press Esc
Press the Enter button
Press the Edit Formula button
Click the save button on the standard toolbar from the menu
Press Ctrl+F5
Click Save on the Windows Start button
Select Edit>Save
Text
Drawing objects
Pictures
All of 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
256
1024
32000
65535
Number format
Border format
Font format
All of above
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