Unit 2 Flashcards
(28 cards)
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
When saving a workbook for the first time, excel opens the ____ __ _____.
1st choose a _____, then _____ a name to the _____.
You can use the _____ __ _____ to create a new file based on a _____ file.
Save as screen
Location, assign, file
Save as screen, current
When you save a file it is a _____ _____ by default, however, you can also save it in a _____ of _____.
Excel workbook
Variety, formats
Format for Excel w/b is _____. Format is default w/b for _____ _____.
Format for Excel 97-2003 w/b is _____. This format can be _____ by earlier _____.
Format for XML data is _____. This format is useful for data _____ between _____.
.xlsx, Excel 2013
.xls, opened, versions
.xml, transferred, applications
Text format (_____ _____) is _____. This form can be opened by any _____ _____ or text _____.
CRV format (_____ _____) is _____. Data fields are _____ by _____.
Tab delimited, .txt, word processor, text editor
Comma delimited, .csv, delimited, commas
PDF format is _____. Any one with _____ can open it.
Web page format is _____. Enables _____ to be _____ as a _____ _____.
.pdf, Adobe
.html, w/b, published, web page
How to save a w/b for 1st time:
- Click _____ tab & choose _____ __ to open _____ __ _____ or press _____ to open _____ box.
- Navigate to _____ where you want to save the file.
- In the file _____ _____, enter a name for the w/b.
- If you want to save in a different format, select a file formate from the _____ __ _____ list.
- Click _____.
File, save as, save as screen, F12, dialog Location Name box Save as type Save
To save to a remote location, do so in the _____ __ section of the _____ tab, then select one of the following:
- _____. This is a service that hosts files _____ in _____storage and requires a _____ _____ account.
- _____ __ _____. Let’s you save to places from _____ _____, _____ or _____.
Save as, file
SkyDrive, online, cloud, Microsoft live
Add a place, office 365, share point, SkyDrive
W/b’s created in 2013 are compatible with excel _____ files, but not with Excel _____ w/b files.
However, you can save a w/b created in Excel _____ as an Excel _____ w/b to _____ people with _____ versions to _____ and _____ it.
2007, 97-2003
2013, 97-2003, enable, earlier, open, use
Not all _____ present in Excel _____ w/b can be saved to Excel _____ w/b format.
You can check which features are compatible with earlier versions of Excel by _____ the _____ _____.
On _____ tab, click _____, click the check for _____ _____ and choose check _____.
Features, 2013, 97-2003
Compatibility checker
File, info, issue button, compatibility
