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

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

View Full Document Right Arrow Icon
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 
Background image of page 1

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

View Full DocumentRight Arrow Icon
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. 
Background image of page 2
Background image of page 3

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

View Full DocumentRight Arrow Icon
Background image of page 4
Background image of page 5
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

This note was uploaded on 04/21/2010 for the course CHE 2160 taught by Professor Cygan during the Fall '09 term at LSU.

Page1 / 5

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

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online