When you copy a formula
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
Correct Answer :
B. Excel edits cell references in the newly copied formula
Related Questions
In a worksheet you can select
The entire worksheet
Rows
Columns
All of the above
You can merge the main document with data source in Excel. In mail merge operation, Word is usually
server
source
client
none
You can use the formula palette to
Format cells containing numbers
Create and edit formulas containing functions
Enter assumptions data
Copy a range of cells
You can set Page Border in Excel from
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
What will be the output if you format the cell containing 5436.8 as #,##0.00'?
5430
5436.80
5436.8
6.8
To delete an embedded objects, first
Double click the object
Select the object by clicking it
Press the Shift + Delete keys
Select it and then press the delete key
The first cell in EXCEL worksheet is labeled as
AA
A1
Aa
A0
The Delete key of keyboard is assigned to which command in Excel?
Edit >> Clear >> Contents
Edit >> Clear >> All
Edit >> Delete
All of above
MS-EXCEL is based on .........?
WINDOWS
DOS
UNIX
OS/2
Hyperlinks can be
Text
Drawing objects
Pictures
All of above
Excel files have a default extension of
Xls
Xlw
Wk1
123
You can auto fit the width of column by
double clicking on the column name on column header
Double click on the cell pointer in worksheet
Double clicking on column right border on column header
Double clicking on the column left border of column header
To save a workbook, you:
Click the save button on the standard toolbar from the menu
Press Ctrl+F5
Click Save on the Windows Start button
Select Edit>Save
Files created with Lotus 1-2-3 have an extension
DOC
XLS
123
WK1
Excel probably considers the cell entry January 1, 2000 to be a
Label
Value
Formula
Text string
Which menu option can be sued to split windows into two
Format > window
View > window > split
Window > split
View > split
Concatenation of text can be done using
Apostrophe ( )
Exclamation ( ! )
Hash ( # )
Ampersand ( & )
Which of the following is a popular DOS based spreadsheet package?
Word
Smart cell
Excel
Lotus 1-2-3
We can save and protect the workbook by
Write Reservation Password
Protection Password
Read-only Recommended
Any of the above
While Finding and Replacing some data in Excel, which of the following statement is valid?
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
Documentation should include
Destination and users of the output data
Source of input data
Information on the purpose of the workbook
All of the above
The Cancel and Enter buttons appear in the:
Title bar
Formula bar
Menu bar
Sheet tabs
Which of the following is not a way to complete a cell entry?
Pressing enter
Pressing any arrow key on the keyboard
Clicking the Enter button on the Formula bar
Pressing spacebar
Which of following is Not one of Excels what-if function?
Goal seek
Solver
Scenario manager
Auto Outline
When integrating word and excel, word is usually the
Server
Destination
Client
Both b and c
Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?
work sheet
chart sheet
module sheet
data sheet
How can you print three copies of a workbook?
Select File > Properties form the menu and type 3 in the Copies to print text box
Select File > Print from the menu and type 3 in the Number of copies text box
Click the Print button on the standard toolbar to print the document then take it to Kinkos and have 2 more copies made
Press Ctrl+P+3
How do you select an entire column?
Select Edit > Select > Column from the menu
Click the column heading letter
Hold down the shift key as you click anywhere in the column
Hold down the Ctrl key as you click anywhere in the column
Right clicking something in Excel:
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
When a range is selected, how can you activate the previous cell?
Press the Alt key
Press Tab
Press Enter
None of above