Mr.G
2014-03-11 17:56:53 UTC
A. the order in which worksheets are printed.
B. the order in which calculations are performed.
C. the properties of the cell reference.
D. how values are divided and multiplied.
12. You've been asked to find the average of a range of numbers. Which of the following could you use to
find the average of cells A1:A10?
A. =AVG(A1:A10)
B. =MAX(A1:A10)
C. =Min(A1:A10)
D. =SUM(A1:A10)
13. Which of the following processes should Angel use to merge cells A1:D4 to create a title?
A. Highlight cells A1:D4, click on the Home tab, and click on the Merge cells icon in the Styles group.
B. Highlight cells A1:D4, right-click and select Format Cells, click Number, and choose the Merge cells option.
C. Highlight cells A1:D4, right-click and select Format Cells, click Alignment, and choose the Merge cells option.
D. Highlight cells A1:D4, click on the Home tab, and click on the Wrap text icon in the Alignment group.
14. A feature in Excel that allows you to graphically display in a single cell the trend across a range of cells
is called a
A. pivot point.
B. pivot line.
C. sparkline.
D. spark point.
15. A rectangular range of cells with headings to describe the cells' contents is referred to as a
A. table.
B. bar chart.
C. complex formula.
D. sparkline.
16. You plan to use the Fill Down feature on a formula and you need to keep a cell reference the same.
Which one of the following formats will allow you to keep the same cell reference?
A. E19
B. $E19
C. E$19
D. $E$19
17. Sidney works in the accounting department. His boss just assigned him a task that involves creating
budget formulas for the company's payroll expense reports. Sidney will be using Excel spreadsheets to
calculate the company's payroll expense reports. In Excel, what does Sidney need to consider when
creating formulas?
A. Excel has limited capabilities, so it would be easier to use payroll software for this application.
B. Excel has third-party formulas you can purchase from Microsoft.
C. Excel has predefined formulas, so you don't have to create any formulas from scratch.
D. Excel performs operations based on the order of precedence.
18. Helga needs to lay out her newly created pivot table. What are the two ways she can set up a pivot
table?
A. Helga can check the field or type in the data in the pivot table.
B. Helga can slide cells to the four boxes or double-click properties to choose from a list of pivot table options.
End of exam
C. Helga can drag the fields to the four boxes in the pivot table field list or right-click a field name and choose its location from
the shortcut menu.
D. When Helga created the pivot table, Excel automatically put the fields to the appropriate cells of the pivot table. There aren't
two ways to set up a pivot table.
19. Which of the following is a group of cells chosen to perform an action?
A. Group
B. Command
C. Range
D. Data series
20. After inputting a formula or a piece of data into a cell, what happens to the cell pointer when you press
Enter?
A. It moves down one cell.
B. It moves to the next adjacent cell to the right.
C. It moves to the last cell in the column.
D. It moves up one cell