A chart plot area
A horizontal axis
The organization of individual values with a charts data series
The data range that supply chart data
B. A horizontal axis
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
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
Xls
Xlw
Wk1
123
towards the bottom right corner
towards the bottom left corner
towards the top right corner
towards the top left corner
Contents
Objects
Scenarios
All of the above
Press the Alt key
Press Tab
Press Enter
None of above
Geometric modeling tool
A cell that points to a drawing object
A formula that either directly or indirectly depends on itself
Always erroneous
Contents tab
Answer Wizard tab
Index tab
all of the above
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
Cut and Paste
Edit >> Paste Special >> Transpose
Both of above
None of above
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
work sheet
chart sheet
module sheet
data sheet
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
date ()
Today ()
now ()
time ()
Cells B7 and cell B9 only
Cells B7 through B9
Cell B8 only
None of the above
Title bar
Menu bar
Formula bar
Standard toolbar
Data, Sort
Data, Form
Data, Table
Data Subtotals
Copy cell contents
Move cell contents
Add cell contents
a and b
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
Apostrophe (&lsquo
Exclamation (!)
Hash (#)
Ampersand (&
Vertical scroll bar
Horizontal scroll bar
Formula bar
Standard toolbar
standard formulas
array formula
complex formulas
smart formula
Select Tools > Finder from the menu
Click the Find button on the standard toolbar
Select Insert > Find from the menu
Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
Apostrophe ( )
Exclamation ( ! )
Hash ( # )
Ampersand ( & )
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
5430
5436.80
5436.8
6.8
Save workbook
Modifiy the worksheet
Enter text and data
Copy the worksheet
Custom List
Auto Fill Options
Fill Across Worksheet
Fill Series
Labels, values, and formulas
Labels and values but not formulas
Values and formulas but not labels
Formulas only
Ctrl + R
Ctrl + Shift + R
Ctrl + H
Ctrl + F