{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

MS Excel Test

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

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

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

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

View Full Document
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
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

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

View Full Document
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.
/ Question 10 0 out of 10 points The entry in cell E5 in the figure above is a ____________. Answer Selected Answer: a. calculation

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

View Full Document
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)
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

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

View Full Document
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?
Answer 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

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

View Full Document
Selected Answer: True Question 10 10 out of 10 points Using the order of precedence for arithmetic operators, these two formulas will calculate the same result: =22/2*5 =22/(2*5).
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}