Data, Sort
Data, Form
Data, Table
Data Subtotals
A. Data, Sort
With the right drag method
With a hyperlink
With the copy and paste special commands
With the copy and paste buttons on the standard toolbar
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
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
AA
A1
Aa
A0
extends a sequential series of data
automatically adds range of cell values
applies a boarder around the selected cells
none of the above
Edit >> Delete
Edit >> Clear >> Contents
Edit >> Clear >> All
Data >> Delete
Destination and users of the output data
Source of input data
Information on the purpose of the workbook
All of the above
Copy cell contents
Move cell contents
Add cell contents
a and b
A command used for data modeling
A range of values such as from 23 to 234
A group of cells
A group of worksheets
standard formulas
array formula
complex formulas
smart formula
Workbooks
Worksheets
Charts
Worksheets and Charts
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
Apostrophe ( )
Exclamation ( ! )
Hash ( # )
Tilde ( ~ )
F3
F5
F7
F9
Double CAL indicator on status bar
Go to Tools >> Options >> Calculation and mark the corresponding radio button
Both of above
None of above
Goal seek
Solver
Scenario manager
Auto Outline
128
256
512
1024
click the edit comment command on the insert menu
click the display comment command on the window menu
position the mouse pointer over the cell
click the comment command on the view menu
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
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
Shorten the label
Increase the column width
Decrease the column width
Adjust the row height
Press the Alt key
Press Tab
Press Enter
None of above
5430
5436.80
5436.8
6.8
To insert a background
To add borders
To select a distribution of figures
To add shading or color to a cell range
Multiplication and division exponentiation positive and negative values
Multiplication and division, positive and negative values, addition and subtraction
Addition and subtraction, positive and negative values, exponentiation
All of above
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
Press the Alt key
Press the F2 key
Click the formula bar
Double click the cell
!A!1
$A$1
#a#1
A1
date ()
Today ()
now ()
time ()
End key
Shift key
Ctrl key
Esc key