{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

excel

# excel - a True b False answer False 7 Which of the...

This preview shows pages 1–5. Sign up to view the full content.

Test Problems Excel Problems  Final Exam: Thursday, December 10, 12:30 - 2:30 PM: 5 Lockett 1 . Explain what will be computed by the following Excel formulas: =SUM(A1:A10, B4:B10)  =AVERAGE(SUM(A1:A10), 24.3, 17)  =RAND()  =PI()  answers     answers     answers   2. What would be the result of evaluating the following formula?  =13+6*2/3*1/2  answers   3. Define the following Excel terms:  labels, constants, formulas                      answers   4. When you are typing an equation into a cell the first thing that must be entered is  a) the first cell referenced  b) parenthesis

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
c) quotation marks  d) an equal sign     answers   5. Labels are used in a spreadsheet to:  a)  tell the computer what we are doing.  b)  help us identify the information.  c)  do the calculations.  d)  set up the equations     answers      6. Formulas containing relative references do not change when copied.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: a) True b) False answer: False 7. Which of the following formulas is an absolute reference? a) A\$1 b) \$A1 c) \$A\$1 d) A1 answer: c Relative Address - a cell address relative to the current cell Absolute Address - a cell address that always refers to the same location. An absolute address has a dollar sign appended to the front of both column letter and row number. When a formula is copied to another cell, relative addresses are automatically readjusted to the cells relative to the current cell. 8. The formula =B2+A3 is located in cell b3 . If this was copied and pasted into cell D4 the resulting formula would be: A B C D 1 2 4 5 5 2 3 3 4 6 3 5 =B2+A3 3 8 4 4 3 4 ?????? ?? a) =C2+C3...
View Full Document

{[ snackBarMessage ]}