Cell names
Column numbers and row letters
Column letters and row numbers
Cell locator coordinates
C. Column letters and row numbers
Workbooks
Worksheets
Charts
Worksheets and charts
The edit formula button
The cancel button
The enter button
All of the above
format cells containing numbers
create and edit formula containing functions
enter assumptions data
copy a range of cells
Select the cells containing the title text plus the range over which the title text is to be centered
Widen the columns
Select the cells containing the title text plus the range over which the title text is to be enfettered
Format the cells with the comma style
Edit -> Comments
Insert -> Comment
File -> Comments
View > Comments
Apostrophe (&lsquo
Exclamation (!)
Hash (#)
Ampersand (&
WINDOWS
DOS
UNIX
OS/2
A command used for data modeling
A range of values such as from 23 to 234
A group of cells
A group of worksheets
None of these
Select Format > Money from the menu
Click the Currency Style button on the formatting toolbar
You have to retype everything and manually add the dollar signs, commas, and decimals
Smart tip
Cell tip
Web tip
Soft tip
Data, Sort
Data, Form
Data, Table
Data Subtotals
Media player
Sound Recorder
Calculator
Macro Recorder
Contents
Objects
Scenarios
All of above
The autosum button
The Formula button
The quicktotal button
The total button
Page Break Preview
Page Orientation
Margins
Headers and Footers
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
AutoFill
Auto correct
Auto sum
Auto format
Xls
Xlw
Wk1
123
Input cells
Constraints
Target cell
Changing cells
Number
Character
Label
Date/time
=SUM(Sales)-A3
=SUM(A1:A5)*.5
=SUM(A1:A5)/(10-10)
=SUM(A1:A5)-10
Logical
Math & Trigonometry
Statistical
Financial
A type of chart
A cell reference
A collection of related data
A division of results
5430
5436.80
5436.8
6.8
3
8
255
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
DOC
XLS
123
WK1
Accessing
Referencing
Updating
Functioning
Contents tab
Answer Wizard tab
Index tab
all of the above
Copy the cells in row, select the same number of cells in row and paste
Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK
Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK
Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK