A command used for data modeling
A range of values such as from 23 to 234
A group of cells
A group of worksheets
C. A group of cells
Label
Value
Formula
Text string
Press the Alt key
Clicking the formula bar
Pressing the F2 key
Double clicking the cell
Edit >> Clear >> Contents
Edit >> Clear >> All
Edit >> Delete
All of above
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
Smart tip
Cell tip
Web tip
Soft tip
date ()
Today ()
now ()
time ()
Title Bar
Menu Bar
Formula Bar
Standard Tool Bar
One sheet is selected
When many sheets are selected
When no sheet is selected
None of above
Format, cells, font
Format, cells, protection
Format, cells, number
Format, cells, alignment
Wrap Text in Format >> Cells
Justify in Edit >> Cells
Text Wraping in Format >> Cells, Layout tab
All of above
Format > window
View > window > split
Window > split
View > split
Accessing
Referencing
Updating
Functioning
Contents
Objects
Scenarios
All of above
Logical
Math & Trigonometry
Statistical
Financial
Click the object command on the insert menu
Click the office links button on the standard toolbar
Click the create worksheet button on the formatting toolbar
Click the import excel command on the file menu
From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK
From Edit menu choose Move of Copy then choose (Move to end) and click OK
From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
None of above
Select Tools > Finder from the menu
Click the Find button on the standard toolbar
Select Insert > Find from the menu
Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
Formula Bar
Status Bar
Tool Bar
None of above
Add
Subtract
Divide
SQRT
Ctrl + R
Ctrl + Shift + R
Ctrl + H
Ctrl + F
Click the save button on the standard toolbar from the menu
Press Ctrl+F5
Click Save on the Windows Start button
Select Edit>Save
Go to Tools >> Options >> View tab and mark or remove the check box named Gridline
Click Gridline tool on Forms toolbar
Both of above
None of above
Data, Sort
Data, Form
Data, Table
Data Subtotals
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
Pmt
Average
Max
Sum
Goal seek
Solver
Scenario manager
Auto Outline
Word
Smart cell
Excel
Lotus 1-2-3
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
Linear
Growth
Autofill
Time
256
1024
32000
65535