12. You’ve created a pie chart in Excel and placed it in a PowerPoint presentation. When
you edit the pie chart in Excel, the pie chart in PowerPoint doesn’t retain the changes
you’ve made. This means that the object has been
A. hyperlinked. C. linked.
B. embedded. D. collaborated.
13. When you point to the bottom right-hand corner of a selected cell containing a formula
until you see a crosshair and drag it three cell to the right, you’re using Excel’s
_______ feature.
A. AutoFormat C. Copy
B. Paste D. Merge and Center
14. Which one of the following is a correctly written Excel formula?
A. =B*C4/2 C. B7>F12=
B. SUM(A5:A22) D. =C4*$G$18
15. You want colors, fonts, and other effects to be carried through all documents you
create in Word, PowerPoint, Excel, Publisher, and Access; therefore, you need to
create a custom
A. theme. C. layout.
B. AutoFormat. D. template.
16. If you wanted to locate and work with a list of all employees who earned more than
$25 per hour this month as recorded in the payroll worksheet, which one of the
following Excel features should you use?
A. Sort C. Find
B. AutoFilter D. 3-D Cell Reference
17. A table of contents for a report can be generated automatically only if you’ve
formatted your headings using
A. page numbers. C. themes.
B. links. D. styles.
18. To save yourself time so that you don’t have to key in your memo heading each time
you begin a new memo, create a
A. signature. C. Quick
Look up the terms here.
http://www.answers.com
http://www.webopedia.com/
This might help, too.
http://office.microsoft.com/en-us/support/getting-started-with-office-2010-FX101822272.aspx
Choose which program you need help with -- list at the left.
12. The correct answer is C. linked. When a chart is linked between Excel and PowerPoint, any changes made to the chart in Excel will be reflected in the chart in PowerPoint. If the changes made in Excel are not being retained in PowerPoint, it indicates that the chart is not linked.
To link a chart from Excel to PowerPoint, you can follow these steps:
1. Create your chart in Excel.
2. Copy the chart by selecting it and pressing Ctrl+C.
3. In PowerPoint, go to the slide where you want to place the chart.
4. Use the "Paste Options" button or right-click and select "Paste" to paste the chart.
5. Choose the "Link" option to establish the link between the Excel chart and the PowerPoint chart.
13. The correct answer is C. Copy. When you point to the bottom right-hand corner of a selected cell containing a formula until you see a crosshair and drag it to another cell, you are using Excel's Copy feature. This allows you to copy the formula from the original cell to the destination cell, adjusting the references accordingly.
To use the Copy feature in Excel, you can follow these steps:
1. Select the cell containing the formula you want to copy.
2. Move your cursor to the bottom right-hand corner of the selected cell until it turns into a crosshair cursor.
3. Click and drag the crosshair cursor to the destination cell(s) where you want to copy the formula.
4. Release the mouse button to paste the formula into the destination cell(s), adjusting the references relative to the new location.
14. The correct answer is B. SUM(A5:A22). This is a correctly written Excel formula to calculate the sum of values in cells A5 to A22.
To understand the structure of a basic formula in Excel:
- The equal sign (=) is used to indicate the start of a formula.
- Functions like SUM are written as the name of the function, followed by parentheses ().
- Cell references are used to specify the range of cells or individual cells that should be included in the calculation.
15. The correct answer is A. theme. To carry colors, fonts, and other effects through all documents in Word, PowerPoint, Excel, Publisher, and Access, you need to create a custom theme. A theme is a set of predefined formatting options that you can apply to your documents consistently.
To create a custom theme in Microsoft Office:
1. Choose any of the Office applications (Word, PowerPoint, Excel, Publisher, Access) and open a new or existing document.
2. Go to the "Design" tab or menu (location may vary depending on the application).
3. Select "Customize" or "Customize Themes" option.
4. From the dialog box, you can modify colors, fonts, effects, and other formatting options to create your custom theme.
5. Save the custom theme for future use.
16. The correct answer is B. AutoFilter. To locate and work with a list of all employees who earned more than $25 per hour this month, you can use Excel's AutoFilter feature. AutoFilter allows you to filter data based on specific criteria, such as in this case, filtering employees with earnings greater than $25 per hour.
To use AutoFilter in Excel:
1. Select the range of cells containing your data, including the headers.
2. Go to the "Data" tab and click on the "Filter" button.
3. Filter arrows will appear in the header row of each column.
4. Click on the desired column's filter arrow and choose the criteria to filter by, such as greater than $25.
5. Excel will filter the data and display only the rows that match the specified criteria.
17. The correct answer is D. styles. To generate an automatic table of contents for a report, you need to format your headings using styles in Word. Styles are pre-designed formatting options that control the appearance of headings and other text in your document.
To format headings using styles in Word:
1. Select the text that you want to format as a heading.
2. Go to the "Home" tab and use the "Styles" group to choose a heading style, such as Heading 1 or Heading 2.
3. Apply the selected style to the selected text.
4. Repeat the process for all the headings in your document.
5. Once all headings are formatted using styles, you can generate the table of contents by going to the "References" tab and selecting "Table of Contents," then choosing the desired table of contents style.
18. The correct answer is D. template. To save time and avoid the need to key in memo headings for every new memo, you can create a template. A template is a pre-designed document that includes placeholders for specific information and can be used as a starting point for creating similar documents.
To create a template in Microsoft Office applications (such as Word, Excel, PowerPoint):
1. Open a new or existing document that you want to use as a template.
2. Customize the document with the desired formatting, placeholders, and content.
3. Go to the "File" tab or menu and select "Save As."
4. Choose the template file format (e.g., .dotx for Word, .xltx for Excel, .potx for PowerPoint).
5. Specify a name and location for the template file and click "Save."
6. In the future, when you want to create a new document based on the template, open the template file, make any necessary changes, and save it as a new document.