Excel 1
An Excel _____ allows data to be summarized and charted easily.
What is a worksheet:
A ____ is a prewritten formula that is built into Excel.
What is a Function?
Cell references in a formula are called ____.
What is Assumptions?
reduces the electricity consumed and environmental waste generated when using technology such as a computer
What is Green Computing?
the long edge is at the top of the paper; the printed page is wider than it is tall
What is Landscape Orientation?
The _____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.
What is AutoCorrect?
Which of the following calculations multiplies 23 by 0.01?
A. =23-1%
B. =23+1%
C. =23*0.01
D. =23/0.01
What is C?
Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle?
A. Quarter 2
B. Qtr2
C. Qt2
D. Qtr 2
What is B?
defines the color of the characters
What is font color?
the short edge is at the top of the printout; the printed page is taller than it is wide
What is portrait orientation?
You _____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
What is Format?
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ___ that you use in algebra.
What is Operations?
Which of the following is an extension of the fill pattern Sunday, Tuesday?
A. Thursday, Saturday, Monday
B. Wednesday, Thursday, Friday
C. Monday, Tuesday, Wednesday
D. Saturday, Sunday, Monday
What is A?
consists of cell references, numbers, and arithmetic operators that instruct Excel to perform a calculation
What is a Formula?
when a formula refers to the same cell in which it is entered
What is Direct circular reference?
The date you change a file is an example of a(n) ______ property.
What is automatically updated?
The ___ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.
What is AVERAGE?
Using the mouse to move or copy cells is called _____.
What is drag and drop?
sums the numbers in a specified range then divides the sum by the number of cells with numeric values in the range
What is AVERAGE function?
when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell
What is Indirect circular references?
The _____ area on the status bar includes six command as well as the result of the associated calculation on the right side of the menu.
What is AutoCalculate?
The ___ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.
What is Formula?
When assigned to a cell, the _____ function returns a number that corresponds to the system date and time beginning with December 31, 1899.
What is NOW?
excel displays the error message #REF! in those cells to indicate a cell reference error
What is #REF! ?
is one in which the action to be taken for the true or false cases includes yet another IF function
What is IF function?