Edit -> Comments
Insert -> Comment
File -> Comments
View > Comments
B. Insert -> Comment
=
+
(
@
Right align the content of cell
Remove the cell contents of selected cells
Fill the selection with active cells to the right
None of above
Edit, Chart
Insert, Chart
Tools, Chart
Format, Chart
Page Break Preview
Page Orientation
Margins
Headers and Footers
Cells
Rows
Columns
Document
Text
Drawing objects
Pictures
All of above
Press the Alt key
Press the F2 key
Click the formula bar
Double click the cell
Contents
Objects
Scenarios
All of the above
Option buttons
List boxes
Text boxes
Combo boxes
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
Format -> Window
View -> Window-> Split
Window -> Split
View > Split
Workbooks
Worksheets
Charts
Worksheets and Charts
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
Title Bar
Menu Bar
Formula Bar
Standard Tool Bar
Label
Value
Formula
Text string
server
source
client
none
standard formulas
array formula
complex formulas
smart formula
XY Chart
Line Chart
Pie Chart
Column Chart
Linear
Growth
Autofill
Time
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
One sheet is selected
When many sheets are selected
When no sheet is selected
None of above
Word processing package
Spreadsheet package
Communication S/W Package
DBMS package
Use =if() function to format the required numbers red
Apply Conditional Formatting command on Format menu
Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
All of above
Visual Basic
C
Visual C++
Java
Split a worksheet into two panes
View different rows and columns edit the contents of a cell
Edit the contents of a cell
view different worksheets
Go to Tools >> Options >> View tab and mark or remove the check box named Gridline
Click Gridline tool on Forms toolbar
Both of above
None of above
ROUND ( )
FACT ( )
MOD ( )
DIV ( )
Data will be entered in the adjacent cells
No data will be entered in the adjacent cells
There is no suitable abbreviation of the text
There is not time to format the next
Replace cell references
Return ASCII values of characters
Concatenate and manipulate text
Show formula error value
When you use multiplication, division, or exponentiation in a formula
When you use addition and subtraction in a formula
Because excel uses hidden decimal places in computation
When you show the results of formulas with different decimal places that the calculated results