- All Exams Instant Download
Which of the following is used for extraction from one or more tables in a database that can be used as the basis of a report or as a standalone information source?
Which of the following is used for extraction from one or more tables in a database that can be used as the basis of a report or as a standalone information source?A . QueryB . FormC . Pivot TableD . Reference TableView AnswerAnswer: A Explanation: A query is used for...
You work as an Office Assistant for Company Inc. You are creating a presentation in Microsoft PowerPoint 2010. You have inserted a chart in your presentation. After creating the presentation, you want to change the chart type, so that the chart will work well with the format of the presentation. Choose and reorder the steps that you will take to change the chart type.
You work as an Office Assistant for Company Inc. You are creating a presentation in Microsoft PowerPoint 2010. You have inserted a chart in your presentation. After creating the presentation, you want to change the chart type, so that the chart will work well with the format of the presentation....
Mark the option/button in the following image of the design tab to apply a set of coloring attributes to a chart with one shortcut command.
Mark the option/button in the following image of the design tab to apply a set of coloring attributes to a chart with one shortcut command. View AnswerAnswer: Explanation: Chart styles are a set of formatting attributes that can be applied to a chart with one shortcut command. These styles use...
Mark the option/button in the following image of the Format tab on which you will click to apply the denim texture to the wall of a chart.
Mark the option/button in the following image of the Format tab on which you will click to apply the denim texture to the wall of a chart. View AnswerAnswer: Explanation: A user can change the format of individual chart elements such as the chart area, plot area, data series, axes,...
Mark the option/button in the following image of the Format tab on which you will click to apply the denim texture to the wall of a chart.
Mark the option/button in the following image of the Format tab on which you will click to apply the denim texture to the wall of a chart. View AnswerAnswer: Explanation: A user can change the format of individual chart elements such as the chart area, plot area, data series, axes,...
Which of the following will you use to accomplish the task?
You work as an Office Assistant for Company Inc. You are creating a presentation in PowerPoint 2010. The presentation comprises various objects. You insert a hyperlink in the presentation. Now, you want to add a screen tip that is used to see the path of the hyperlinked file while delivering...
You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based computer with Microsoft Office 2010 installed on it. The computer contains a database named Staffs created in Microsoft Access 2010. The database contains a report named StaffsInfo. You have to set page layout, margins, page size, and zooming options for your report. Mark the appropriate view that you will choose to open your report.
You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based computer with Microsoft Office 2010 installed on it. The computer contains a database named Staffs created in Microsoft Access 2010. The database contains a report named StaffsInfo. You have to set page layout, margins,...
Which of the following steps will you take to enforce referential integrity for an existing relationship?
Which of the following steps will you take to enforce referential integrity for an existing relationship? Each correct answer represents a part of the solution. Choose all that apply.A . Select the Enforce Referential Integrity check box.B . Click the Edit Relationships button in the Tools group.C . Click the...
Which of the following functions will you use to count the number of cells that meet multiple criteria within a range?
Which of the following functions will you use to count the number of cells that meet multiple criteria within a range?A . COUNTAB . COUNTIFSC . ABSD . COUNTView AnswerAnswer: B Explanation: The COUNTIFS function is used to count the number of cells that meet multiple criteria within a range....
Which of the following relationships will you build between both tables?
You have two tables named table1 and table2 in your database, which is stored in Microsoft Office Access 2007. You have to perform the following tasks: Divide table1 with many columns. Isolate part of table1 for security reasons. Store information that applies only to a subset of table2. Which of...
