excell test

excell test - Question 1 Multiple Choice Which of the...

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

View Full Document Right Arrow Icon
Question 1 Multiple Choice 3 of 3 points Which of the following statements is true? Selected Answer: An Excel workbook contains one or more worksheets. Correct Answer: An Excel workbook contains one or more worksheets. Question 2 Multiple Choice 3 of 3 points A predefined computational task is referred to as a(n): Selected Answer: function. Correct Answer: function. Question 3 Multiple Choice 3 of 3 points Which of the following may NOT be included in a formula? Selected Answer: Text constants Correct Answer: Text constants Question 4 Multiple Choice 0 of 3 points Which of the following is NOT a valid mathematical operator in Excel? Selected Answer: / Correct Answer: \ Question 5 Multiple Choice 0 of 3 points Given the formula =B5*B6+C3/D4^2, which expression would be evaluated first? Selected Answer: It is impossible to determine. Correct Answer: D4^2 Question 6 Multiple Choice 3 of 3 points Which part of the formula +E12/6+(G7*SUM(H9:H11) is considered a constant? Selected Answer: 6 Correct Answer: 6 Question 7 Multiple Choice 3 of 3 points Which of the following commands will remove cells, rows, or columns from a worksheet? Selected Answer: Delete Correct Answer: Delete Question 8 Multiple Choice 3 of 3 points Which of the following is considered an absolute cell reference?
Background image of page 1

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

View Full DocumentRight Arrow Icon
Selected Answer: $B$4 Correct Answer: $B$4 Question 9 Multiple Choice 3 of 3 points Cell E3 contains the function =AVERAGE(A3:D3). If the contents of cell E3 are copied to cell E4, what will be the contents of cell E4? Selected Answer: =AVERAGE(A4:D4) Correct Answer: =AVERAGE(A4:D4) Question 10 Multiple Choice 3 of 3 points Cell E3 contains the function =AVERAGE($A$3:$D$3). If the contents of cell E3 are copied to cell E4, what will be the contents of cell E4? Selected Answer: =AVERAGE($A$3:$D$3) Correct Answer: =AVERAGE($A$3:$D$3) Question 11 Multiple Choice 3 of 3 points How would the number .3333 be displayed if "percentage format with 2 decimal places" were specified? Selected Answer: 33.33% Correct Answer: 33.33% Question 12 Multiple Choice 3 of 3 points The fill handle is used for: Selected Answer: copying the contents of a cell to adjacent cells.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/01/2011 for the course CIS 105 taught by Professor - during the Summer '07 term at Shoreline.

Page1 / 6

excell test - Question 1 Multiple Choice Which of the...

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

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