Docstoc

abc

Document Sample
abc Powered By Docstoc
					1.The ____cell is the cell in which you are currently working.

2.The____bar allows you to display all areas of the spreadsheet.

3.The point at which a column and a row intersect is called_____(cell??)

4.By default,a workbook contains_____worksheet(s).

5.As you type a formula of function, it is displayed in the ____bar.

6.A group of cells is called a____.

7.You can quickly select a cell with you mouse by____.

8.A_____is NOT data type that can be entered into a spreadsheet.

9.Individual worksheets are stored in a_____.

10.Formulas are entered in the worksheet cell and must begin by what?

11.The keyboard shortcut Ctrl +____moves to the last cell with data in a row.

12.Pressing the Page Up button moves the active cell_____.

13.Pressing the F5 function key opens the dialog box.

14.The____displays the content of the active cell.

15.A____is a built-in formula.

16.You would use buttons from the____toolbar to change number formats in a spreadsheet.

17.It is an equation that performs operations on worksheet data.

18.It is a management software containing worksheet organized in rows and columns.

19.A sign or symbol that specifies the type of calculation such as addition, subtraction or
multiplication to perform on the elements of a formula.

20.A pre-written formula that takes a value or values, performs an operation, and returns a Value
or values. It also simplifies and shorten formulas.

21.Function used to return the smallest number in a set of values.

22.A function that return one value if a condition you specify evaluates to TRUE or FALSE.
TRUE OR FALSE

1.    It is difficult to calculate information once it has been placed in a spreadsheet.

2.    Spreadsheet software can be used to identify trends.

3.    A spreadsheet and a worksheet are the same thing

4.    A cell has a name that reflects the respective column number and row letter.

5.    You can use the Tab key to move to the next cell.

6.    A label is alphabetical text and aligns at the right side of a cell.

7.    You can combine cell references and functions into one formula.

8.    The IF function returns a total for a range of cells.

9.    To enter a function, you first type the = (equal) sign.

10.    A function is a simple calculation.

11. The function or formula you type displays in the formula bar.

12. The Copy and Paste commands are not available in Excel.

13. Cell references automatically adjust to new locations when you copy formulas from one row
to another.

14. To create an absolute cell reference, type % (percent) before the column and/or row number

15. Text in cells can be wrapped by selecting Cells on the Format menu

16. Use Count to get the number of entries in a number field in a range or array of numbers.

17. You can use the arrow keys, enter key or simply click your mouse to move around the Excel
workbook.

18. The IF condition will return one value if a condition you specify evaluates to True and
another value if it evaluates to False.

19. To select an entire column, click the row heading.

20. The Min function will return the smallest value in a set of values.

Answers:
1. active
2. scroll
3. cell
4. three
5. formula
6. range
7. dragging
8. date/Time
9. workbook
10. equal mark (=)
11. End
12. one screen up
13. Goto dialog box
14. formula bar
15. function
16. formatting
17. formula
18. Excel
19. operator
20. function
21. =min()
22. =if()

True and False
1. False
2. True
3. True
4. False (column letter and row number)
5. True
6. False (aligns left side of cell)
7. True
8. False
9. False (multiple functions can be inserted. To start a formula you require to begin with equal
sign.)
10. True
11. True
12. False
13. True (if the references are relative)
14. False (use $ symbol)
15. True
16. True
17. True
18. True
19. False (click column heading)
20. True

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:42
posted:7/12/2011
language:English
pages:4