Page Break Preview
Page Orientation
Margins
Headers and Footers
A. Page Break Preview
The Alt key
The Tab key
The Enter key
None of the above
Delete the column from the worksheet
Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button
Select Data > Delete Record from the menu
Click the Delete button on the Standard toolbar
Number format
Border format
Font format
All of above
date ()
Today ()
now ()
time ()
Deletes the content of a cell
Deletes Formats of cell
Deletes the comment of cell
Deletes selected cells
work sheet
chart sheet
module sheet
data sheet
It can contain text and data
It can be modified
It can contain many sheets including worksheets and chart sheets
You have to work hard to create it
XY Chart
Line Chart
Pie Chart
Column Chart
Goal seek
Solver
Scenario manager
Auto Outline
Use the excel menu bar and toolbars inside the word application
Edit the hyperlink
Edit the data in a excel source application
Use the word menu bar and toolbars
Accessing
Referencing
Updating
Functioning
Workbooks
Worksheets
Charts
Worksheets and Charts
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
is defined by a bold border around the cell
Receives the data the user enters
It is the formula bar
Only A and B
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
COUNTA ()
function do?counts cells having alphabets
counts empty cells
counts cells having number
counts non-empty cells
The autosum button
The Formula button
The quicktotal button
The total button
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
Media player
Sound Recorder
Calculator
Macro Recorder
0
1
5
10
From Format Cells dialog box click on Merge Cells check box
From Format Cells dialog box select the Centered alignment
From Format Cells dialog box choose Merge and Center check box
Click on Merge and Center tool on formatting toolbar
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
128
256
512
1024
Title bar
Formula bar
Menu bar
Sheet tabs
=SUM(Sales)-A3
=SUM(A1:A5)*.5
=SUM(A1:A5)/(10-10)
=SUM(A1:A5)-10
256
1024
32000
65535
Multiply the selection by a copied value
Cell comments
Formatting options
The resulting values of a formula instead of the actual formula
Select the sheet, then choose Edit >> Delete Sheet
Select the sheet then choose Format >> Sheet >> Hide
Both of above
None of above
=10+50
10+50
=10+50
=B7+14
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