Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
58 Cards in this Set
- Front
- Back
A _________ is a prewritten formula that is built into Excel |
Funtion |
|
To start a new line in a cell, press the_________? Keys |
ALT +ENTER |
|
Which of the following calculations multiplies 23 by 0.01? |
23% |
|
When one or more arithmetic operator is involved in a formula, excel follows the same basic order of _____________ |
Operations |
|
What happens when you enter a formulas into = g15 into a cell |
Excel assigns a vaule in cell g15 to the active cell |
|
Point mode allows you to_____________ as shown in the figure |
Select cells for use in a formula using the mouse |
|
The adjusted cell reference in a copied and pasted formula are called _________cell references |
Relative |
|
The __________ funtion displays the highest vaule in a range |
Max |
|
Clicking the________ opens the insert funtion dialog box |
Insert funtion box in the formula bar |
|
The __________funtion determins the lowest number in a range |
Min |
|
True or false: best fit means that thewidth of the column will be increased or decreased by the percentage you specify |
False |
|
True or false the range automatically selected by excel is always correct? |
False |
|
True or false, moving from left to right , the first calculation in order of operations is negation? |
True |
|
The equal sign (=) preceeds a formula, true or false? |
True |
|
True or false, excel has more then 400 functions that preform just about every type of calculation you can imagine |
True |
|
Point mode allows you to select cells for use in a formula by using your finger on the mouse, true or false |
True |
|
You can click the format cells dialog box launcher to open the Format cells dialog box. |
True |
|
True or false: you can not format an entire column at once? |
False |
|
To select a number format, you can choose a category in the number tab in the formula cells dialog box and then select the number of decimal places, whether or not a dollar sign should be displayed, and how negative numbers should appear. True or false |
True |
|
True or false? The percent style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100 ,rounding the result to the nearest percent, and adding a % sign |
True |
|
Best fit means that the width of the column will be increased or decreased by a percentage that you specify true or false? |
False |
|
True or false moving from left to right, the first calculation in the order of operations is negation? |
Truth |
|
If you enter 90 in the degrees box the _______ area of the format cells dialog box, text will appear vertically and read from bottom to top in the cell, |
Orientation |
|
_________ text often provides a strong visual appeal |
Rotated |
|
To open the Format Cells Dialog box with the allignment sheet active, tap or click the allignment settings _________ _______ ________ |
Dialog box launcher |
|
Which of the following is an extension of the fill pattern Sunday Tuesday? |
Thursday, Saturday, Monday |
|
Which of the following patterns extends the fill series: 575, 550, 525,? a:650, 600 b:625, 600 C: 560, 580 d: 500, 475 |
B |
|
The increase indent button indents the content of a cell to the right by_____ spaces each time you vliv Click it. |
Two |
|
The Copy button copies the content and format of the source area to the office?, a temporary storage area in the computer's memory A ribbon. B clipboard. C folder. D file? |
Clipboard |
|
In the context of copying a range of cells to a non adjacent location, an alternative to clicking the paste button is to press what key? A ,
A:enter B:ALT C:CTRL D :SHIFT |
A:Enter |
|
Its formula is located in other cell reference cells in a deleted row or column, Excel does not adjust the cell references but instead displays the? Error message |
#Ref! |
|
Which of the following formulas contains an absolute cell reference? A:=$ B4 B:=B $4 C:=$ B $4 D: =B 4 |
C $ B $4 |
|
True or false? If you drag the fill handle to the left or up, Excel will increment the series rather than the decrement series? |
False |
|
True or false? The incorrect use of copying, deleting, inserting, and moving ranges of cells has the potential to render a worksheet useless. |
True |
|
The date stamp shows the date of work book, report, or other document was created or the time period it represents true or false? |
True |
|
When Excel cannot calculate a formula, it displays an error message in the cell true or false? |
True |
|
When you rest the mouse pointer over a chart item, such as a legend, Excel displays a chart tip containing the name of the item? True or false? |
True |
|
True or false you can select nonadjacent ranges using the Shift key? |
False |
|
When you change a value on which part is dependent, Excel and immediately redraws the chart based on the new value true or false? |
True |
|
A cell reference with only one dollar sign before either the column or the roll is called an absolute reference true or false? |
False |
|
The ^= comparison operator means less then or equal to . True or False |
True |
|
True or false? When you rest the mouse pointer over a chart item, such as a legend, Excel displays a chart tip containing the name of the item |
True |
|
The first stepin creating a effective worksheet is to make sure you? |
Understand what is required |
|
To enter data in a cell you must first select the _________ |
Cell |
|
___________ is/are used to place a work sheet, column and row titles on a work sheet |
Text |
|
Clicking the ____________ box completes an entry |
Enter |
|
The ___________ is a blinking vertical line that indicates where the next typed character will appear |
Insertion point |
|
The _____ feature works behind the scenes, fixing common typeing or spelling mistakes when you complete a text entry |
Autocorrect |
|
Pressing the____ key to complete an entry activates the adjacent cell to the right |
Right arrow key |
|
By default text is ________ in a cell |
Left aligned |
|
In excel a number can contain the characters . $% Ee 2. 0123456789 3. + ( ) _ 4. All of the above |
All of the above |
|
The ranfe of cells receiving copied content is called the _________ area |
Paste |
|
Both the cancle box and the enter box appear on the formula bar when you begin typing in a cell . True or false |
True |
|
True or false: you can clear cell content and formatting by tapping or clicking Clear Content on the clear button menu |
True |
|
True or false : you should push the spacebar to clear a cell |
False |
|
True or false: to clear the entire worksheet , tap or click the Clear All button on the work sheet |
False |
|
True or false: if a major error is made when typeing data into a cell, tap or click the cancle box in the formula bar or press the ESC key to erase the entire entry, and then re-enter the data from the begining |
True |
|
True or false: you canturn off the bold formatting text by clicking the Romam button |
False |