Unit 2 Flashcards
By default text in a cell is aligned to the ________.
By default a value in a cell is aligned to the ________.
Values include: ________, ________ & ________.
Left
Right
Numbers, formulas, functions
Text in a cell can be any ________ and you can change text ________.
Excel recognizes cell data as a value when it is a ________ or when it begins with __, __, __, __, __ or __.
__ at beginning of a cell means cell will contain a ________.
Length, format
Number, +, -, =, @, # or $
Formula
If text doesn’t fit in a cell it will appear to go ________ the _________ cell if the adjacent cell is ________.
If there is ________ in the adjacent cell, the overflowing text will be ________ to fit the ________ of the cell.
If long value doesn’t fit, Excel will show a row of ___ ________.
Into, next, empty
Data, truncated, width
characters
Num lock key is only on ________ ________ computers.
Num lock key is located in ________ ________ corner of the ________.
Num lock key switches key pad from ________ to ________.
Desk top
Upper left, keypad
Numeric, navigation
3 ways to edit a cells contents:
- Select cell and ________ ________ ________.
- Click ________ bar, make ________ & press ________.
- ________ click cell to place the ________ ________ in it, make _______ and press ________.
Type new data
Formula, edits, enter
Double, insertion point, edits, enter
To select multiple cells, hold down ________ key, then ________ each cell to select the cells you want.
To select contiguous range of cells, click _______ cell in range and hold down the ________ key and click the ________ cell in the range.
Or ________ across cells to ________ them.
Control, click
First, shift, last
Drag, select
Press ________ to move insertion point to the ________ of the ________ in a cell.
When using control key to select cells, an ________ box ________ the ________ cell.
When 2 cells are selected: ________ key deletes active cell, ________ key deletes both cells.
End, end, text
Outline, surrounds, active
Backspace, delete
Use ________ feature to enter a ________ of #’s, days of week or other ________ data.
Auto fill, series, sequential
The ________ handle is a small ________ in the _____ _____ corner of a selected cell or _____ of cells.
When you point to the _____ handle, the pointer changes to a __ sign.
You drag the pointer _____ to fill a _____ with data.
Fill, square, lower right, range
Fill, +, downwards, range
For _____ & _____ you can select 2 cells with a _____ range, and autofill will _____ with the same _____.
When auto filling, as you drag, a _____ _____ appears around the _____ you’re filling.
As you drag past a cell, a _____ _____ displays the next _____ that will be entered into that cell.
’s, dates, desired, continue, increments
Shaded outline, range
Screen tip, text
Formulas perform _____ _____, such as _____, _____ & _____.
All _____ in Excel starts with an __ _____.
A formula can refer to a _____, a cell _____ or another _____,
Numeric calculations, adding, multiplying, averages
Formula, = sign
Value, address, formula
_____ are predefined formulas that perform _____ or _____, from simple to complex.
Many formulas contain _____: characters that indicate the type of _____ operation the _____ will perform.
Functions, operations, calculations
Operating, arithmetic, formula
To enter a formula _____ the _____ where you want the _____ to appear, _____ the _____ and press enter.
_____ are based on the _____ contained in the cells in your worksheet.
_____ bar show the formula, not the _____.
Select, cell, result, type, formula
Formulas, values
Formula, results
Excel performs calculations in the following order:
- __
- __
- __, __
- __, __
%, ^, * /, + -
If operators with same precedent (*,/) appear in the same formula excel performs those calculations from _____ to _____.
Use () to to change the _____ of _____.
Use () around the part of the formula to be _____ _____.
Left, right
Order, operation
Calculate, first
