Excel Mid Term Study

A _________ is a prewritten formula that is built into Excel

To start a new line in a cell, press the_________? Keys

Which of the following calculations multiplies 23 by 0.01?

When one or more arithmetic operator is involved in a formula, excel follows the same basic order of _____________

What happens when you enter a formulas into = g15 into a cell

Point mode allows you to_____________ as shown in the figure

The adjusted cell reference in a copied and pasted formula are called _________cell references

The __________ funtion displays the highest vaule in a range

Clicking the________ opens the insert funtion dialog box

The __________funtion determins the lowest number in a range

True or false: best fit means that thewidth of the column will be increased or decreased by the percentage you specify

True or false the range automatically selected by excel is always correct?

True or false, moving from left to right , the first calculation in order of operations is negation?

The equal sign (=) preceeds a formula, true or false?

True or false, excel has more then 400 functions that preform just about every type of calculation you can imagine

Point mode allows you to select cells for use in a formula by using your finger on the mouse, true or false

You can click the format cells dialog box launcher to open the Format cells dialog box.

True or false: you can not format an entire column at once?

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 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

Best fit means that the width of the column will be increased or decreased by a percentage that you specify true or false?

True or false moving from left to right, the first calculation in the order of operations is negation?

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,

_________ text often provides a strong visual appeal

To open the Format Cells Dialog box with the allignment sheet active, tap or click the allignment settings _________ _______ ________

Which of the following is an extension of the fill pattern Sunday Tuesday?

Which of the following patterns extends the fill series: 575, 550, 525,?

a:650, 600 b:625, 600

C: 560, 580 d: 500, 475

The increase indent button indents the content of a cell to the right by_____ spaces each time you vliv

Click it.

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?

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

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

Which of the following formulas contains an absolute cell reference?

A:=$ B4 B:=B $4

C:=$ B $4 D: =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?

True or false? The incorrect use of copying, deleting, inserting, and moving ranges of cells has the potential to render a worksheet useless.

The date stamp shows the date of work book, report, or other document was created or the time period it represents true or false?

When Excel cannot calculate a formula, it displays an error message in the cell 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 or false?

True or false you can select nonadjacent ranges using the Shift key?

When you change a value on which part is dependent, Excel and immediately redraws the chart based on the new value true or false?

A cell reference with only one dollar sign before either the column or the roll is called an absolute reference true or false?

The ^= comparison operator means less then or equal to . True or False

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

The first stepin creating a effective worksheet is to make sure you?

To enter data in a cell you must first select the _________

___________ is/are used to place a work sheet, column and row titles on a work sheet

Clicking the ____________ box completes an entry

The ___________ is a blinking vertical line that indicates where the next typed character will appear

The _____ feature works behind the scenes, fixing common typeing or spelling mistakes when you complete a text entry

Pressing the____ key to complete an entry activates the adjacent cell to the right

By default text is ________ in a cell

In excel a number can contain the characters

. $% Ee 2. 0123456789

3. + ( ) _ 4. All of the above

The ranfe of cells receiving copied content is called the _________ area

Both the cancle box and the enter box appear on the formula bar when you begin typing in a cell . True or false

True or false: you can clear cell content and formatting by tapping or clicking Clear Content on the clear button menu

True or false : you should push the spacebar to clear a cell

True or false: to clear the entire worksheet , tap or click the Clear All button on the work sheet

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 or false: you canturn off the bold formatting text by clicking the Romam button