Which option of Freeze Panes will you use to freeze a row in a worksheet?

Which option of Freeze Panes will you use to freeze a row in a worksheet?A . Unfreeze PanesB . Freeze ColumnC . Freeze Selected RowD . Freeze Top RowView AnswerAnswer: D Explanation: Take the following steps to freeze a row in a worksheet: Go to the Freeze Panes drop down...

September 30, 2023No CommentsREAD MORE +

You work as an Office Assistant for Company Inc. You create a presentation and insert an image from a file in it.

You work as an Office Assistant for Company Inc. You create a presentation and insert an image from a file in it. Now, you want to change the shape of the image, as shown in the following image: You have clicked the Format tab under Picture Tools. Mark the option/button...

September 30, 2023No CommentsREAD MORE +

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...

September 30, 2023No CommentsREAD MORE +

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....

September 30, 2023No CommentsREAD MORE +

Which of the following form contextual ribbons includes groups that can manage control groups, set text margins and padding for controls, toggle the Snap to the Grid layout feature, set tab order, align controls, and display Property Sheet?

Which of the following form contextual ribbons includes groups that can manage control groups, set text margins and padding for controls, toggle the Snap to the Grid layout feature, set tab order, align controls, and display Property Sheet?A . FormatB . ArrangeC . DesignD . Page SetupView AnswerAnswer: B Explanation:...

September 30, 2023No CommentsREAD MORE +

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...

September 30, 2023No CommentsREAD MORE +

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. You have added a title in the presentation. Now, you want to change the effect of the title to Accent 1, as shown in the following image: Which of the following will you...

September 30, 2023No CommentsREAD MORE +

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...

September 30, 2023No CommentsREAD MORE +

Mark the option/button in the following image of the Format tab on which you will click to apply the effect to a textbox.

Mark the option/button in the following image of the Format tab on which you will click to apply the effect to a textbox. View AnswerAnswer: Explanation: A text box is a control that is rectangular in shape. A text box has a border that separates it from the rest of...

September 30, 2023No CommentsREAD MORE +

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...

September 29, 2023No CommentsREAD MORE +