MS Excel Test

MS Excel Test - E xcel Unit A Quiz Question 1 0 out of 10...

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

View Full Document Right Arrow Icon
Excel Unit A Quiz Question 1 0 out of 10 points When the paper orientation is set on landscape, the contents will print across the width of the page. Answer Selected Answer: True Question 2 10 out of 10 points A named range may begin a letter or number. Answer Selected Answer: False Question 3 10 out of 10 points
Background image of page 1

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

View Full DocumentRight Arrow Icon
You use formulas in Excel to perform calculations such as adding, multiplying, and averaging. Answer Selected Answer: True Question 4 10 out of 10 points One of the ways to change your view of the worksheet window is by using the View tab on the Ribbon . Answer Selected Answer: True Question 5 10 out of 10 points ____ below the worksheet grid let you switch from sheet to sheet in a workbook. Answer
Background image of page 2
Selected Answer: d. Sheet tabs Question 6 10 out of 10 points Excel recognizes an entry as a value if it is a number or it begins with ____. Answer Selected Answer: d. All of the above Question 7 0 out of 10 points A(n) ____ is a built-in formula that uses arguments to calculate information. Answer
Background image of page 3

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

View Full DocumentRight Arrow Icon
Selected Answer: d. template Question 8 10 out of 10 points As shown in the figure above, item ____ points to the formula bar. Answer Selected Answer: c. 3 Question 9 10 out of 10 points The Excel operator for division is ____. Answer Selected Answer: d.
Background image of page 4
/ Question 10 0 out of 10 points The entry in cell E5 in the figure above is a ____________. Answer Selected Answer: a. calculation
Background image of page 5

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

View Full DocumentRight Arrow Icon
Excel Unit B Quiz Question 1 10 out of 10 points How can the order of precedence in this formula, =C12+C13*F4, be changed so that cells C12 and C13 are added together as the first operation that occurs? Answer Selected Answer: a. =(C12+C13)*F4 Question 2 10 out of 10 points In the formula =(G15-G14)*$M$3/4, which mathematical operation is performed first? Answer Selected Answer: c. (G15-G14)
Background image of page 6
Question 3 10 out of 10 points =D8+E8*0.5 is a complex formula. Answer Selected Answer: True Question 4 0 out of 10 points The Auto Fill feature of Excel only allows the user to fill cells with a series using the existing formatting options of the cell. Answer Selected Answer: True Question 5 0 out of 10 points
Background image of page 7

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

View Full DocumentRight Arrow Icon
The default file extension for an Excel 2010 workbook is ____. Answer Selected Answer: a. .xltx Question 6 10 out of 10 points The figure above illustrates which feature of Excel? Answer Selected Answer: a. SUM list pane with recent functions Question 7 10 out of 10 points An Excel user may paste a range of cells in which of the following locations?
Background image of page 8
Selected Answer: c. both a. and b. Question 8 0 out of 10 points Which formula contains a mixed cell reference? Answer Selected Answer: a. =($A$6+A7)*0.20 Question 9 10 out of 10 points Excel’s Formula AutoComplete feature suggests functions depending on the letters typed by the user. Answer
Background image of page 9

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

View Full DocumentRight Arrow Icon
Image of page 10
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 44

MS Excel Test - E xcel Unit A Quiz Question 1 0 out of 10...

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

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