You can search for bold and replace with italics
You can decide whether to look for the whole word or not
You can search in formula too
You can search by rows or columns or sheets
D. You can search by rows or columns or sheets
Delete contents
Delete notes
Delete cells
Delete formats
is defined by a bold border around the cell
Receives the data the user enters
It is the formula bar
Only A and B
Can only add values in a range of cells
Provides a quick way to view the result of an arithmetic operation on a range of cells
Automatically creates formulas and adds them to a worksheet
A and c
Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells
Pressing the Ctrl key while dragging over the desired cells
Pressing the Shift key and an arrow key
Dragging over the desired cells
Input cells
Constraints
Target cell
Changing cells
Press the Alt key
Clicking the formula bar
Pressing the F2 key
Double clicking the cell
Labels, values, and formulas
Labels and values but not formulas
Values and formulas but not labels
Formulas only
Click the save button on the standard toolbar from the menu
Press Ctrl+F5
Click Save on the Windows Start button
Select Edit>Save
By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
By dragging a range of excel data to the word button on the taskbar while pressing Shift key
By dragging a range of excel data to the word button on the taskbar while pressing Alt key
None of above
Press the Erase key
Press Esc
Press the Enter button
Press the Edit Formula button
Format -> Window
View -> Window-> Split
Window -> Split
View > Split
extends a sequential series of data
automatically adds range of cell values
applies a boarder around the selected cells
none of the above
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
=SUM(Sales)-A3
=SUM(A1:A5)*.5
=SUM(A1:A5)/(10-10)
=SUM(A1:A5)-10
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
128
256
512
1024
auto formatting
applying styles
changing fonts
all of above
Page Break Preview
Page Orientation
Margins
Headers and Footers
=10+50
10+50
=10+50
=B7+14
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
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
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
Ctrl+C
Ctrl+Enter
Ctrl+Page Up
Ctrl+Space Bar
Text
Drawing objects
Pictures
All of above
Efficiency
Aditibility
Description
Clarity
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
$
*
%
&
Title Bar
Menu Bar
Formula Bar
Standard Tool Bar
COUNTA ()
function do?counts cells having alphabets
counts empty cells
counts cells having number
counts non-empty cells
Excel 2000
Excel 2002
Excel ME
Excel XP