최신ECDL/ICDL Advanced - ECDL-ADVANCED무료샘플문제
문제1
Mark the option/button in the following image of the Layout tab to display a set of related data points that are plotted in a chart.
Mark the option/button in the following image of the Layout tab to display a set of related data points that are plotted in a chart.
정답:
Explanation:
A data series is a set of related data points that are plotted in a chart. It has a unique color or pattern in the chart and is represented in the chart legend. A user can plot one or more data series in a chart. Pie charts have only one data series. A user can specify where a specific data series appears within a chart.Take the following steps to display the data series of a chart:
1. Select the chart.
2. The green Chart Tools contextual tab appears at the top of the PowerPoint window.
3. Click on the Layout tab under Chart Tools. In the Labels group, click the Axis button.
4. The Axis drop-down list opens. Select the desired option to be applied.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Charts/Graphs
문제2
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 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:
정답:
Explanation:
The cropping is a process that trims vertical or horizontal edges of an object. The cropping feature is used to focus the attention on a particular area of an image. This feature helps to remove or mask areas of an image that a user can ungroup and manipulate as two or more objects or a file that stays as a single object. In PowerPoint 2010, the cropping feature has been enhanced, so that a user can now easily crop to a specific shape, crop to fit or fill a shape, or crop to a common picture aspect. Take the following steps to change the shape of an image:
1. Select the image.
2. Click the Format tab, and then click the Crop button.
3. The Crop drop-down list opens. Click the Crop to Shape option and select the shape.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Pictures, Images, Drawn Objects
문제3
Which of the following is a view in Microsoft Word 2010 that provides an easy way to move through a document and the drag and drop functionality to move sections in a document?
Which of the following is a view in Microsoft Word 2010 that provides an easy way to move through a document and the drag and drop functionality to move sections in a document?
정답: D
설명: (ITDumpsKR 회원만 볼 수 있음)
문제4
You work as an Office Assistant for Company Inc. You are creating a presentation in PowerPoint 2010. You have inserted some bullet points in the presentation. Now, you want to collapse the bullet points under the slide titles. 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 inserted some bullet points in the presentation. Now, you want to collapse the bullet points under the slide titles. Which of the following will you use to accomplish the task?
정답: B
설명: (ITDumpsKR 회원만 볼 수 있음)
문제5
Which of the following steps will you take to protect your worksheet from unauthorized access?
Which of the following steps will you take to protect your worksheet from unauthorized access?
정답: A
설명: (ITDumpsKR 회원만 볼 수 있음)
문제6
Which of the following Excel functions finds a value in the leftmost column of a named range and returns the value from the specified cell with the found value?
Which of the following Excel functions finds a value in the leftmost column of a named range and returns the value from the specified cell with the found value?
정답: C
설명: (ITDumpsKR 회원만 볼 수 있음)
문제7
Which of the following datatypes cannot be filtered by using common filters?
Each correct answer represents a complete solution. Choose two.
Which of the following datatypes cannot be filtered by using common filters?
Each correct answer represents a complete solution. Choose two.
정답: A,B
설명: (ITDumpsKR 회원만 볼 수 있음)
문제8
You work as an Office Assistant for Company Inc. You are creating a presentation in PowerPoint 2010. You have inserted some pictures in the presentation. You want PowerPoint 2010 to use the picture file names as a placeholder for the caption text. Mark the appropriate option/button that you will use to use the file names as the caption text.
You work as an Office Assistant for Company Inc. You are creating a presentation in PowerPoint 2010. You have inserted some pictures in the presentation. You want PowerPoint 2010 to use the picture file names as a placeholder for the caption text. Mark the appropriate option/button that you will use to use the file names as the caption text.
정답:
Explanation:
A PowerPoint photo album is a collection of photographic presentation slides. It is a presentation that a user can create to display his personal or business photographs. A user can either download PowerPoint photo album templates from Microsoft Office.com or create his own. By using a photo album, a user can use the picture file name as a placeholder for the caption text. Take the following steps to add captions to pictures:
Add a picture.
Click on the Insert tab. In the Images group, click the arrow under Photo Album, and then click the Edit Photo Album option.
In the Edit Photo Album dialog box, under Picture Options, select the Captions below ALL pictures check box. Click the Update button.
Note: By default, PowerPoint 2010 uses the picture file name as a placeholder for the caption text. In Normal view, click the caption text placeholder, and then type the caption.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Pictures, Images, Drawn Objects
문제9
Which of the following are the ways to create a new blank presentation?
Each correct answer represents a complete solution. Choose all that apply.
Which of the following are the ways to create a new blank presentation?
Each correct answer represents a complete solution. Choose all that apply.
정답: A,B,C
설명: (ITDumpsKR 회원만 볼 수 있음)
문제10
You work as an Office Assistant for Company Inc. You are preparing a presentation named AnnualReport.pptx through PowerPoint 2010. The presentation contains forty slides, and each slide contains the company logo in its background.
While reviewing the presentation, you noticed that the logo is placed incorrectly. Now, you want to change the formatting of the logo while saving time because you do not want to change the same logo on more than one slide. You click on the View tab. Mark the correct view for editing the logo.
You work as an Office Assistant for Company Inc. You are preparing a presentation named AnnualReport.pptx through PowerPoint 2010. The presentation contains forty slides, and each slide contains the company logo in its background.
While reviewing the presentation, you noticed that the logo is placed incorrectly. Now, you want to change the formatting of the logo while saving time because you do not want to change the same logo on more than one slide. You click on the View tab. Mark the correct view for editing the logo.
정답:
Explanation:
Here, if you switch your presentation from the Normal view to the Slide Master view, you can make universal style changes to every slide in your presentation. This view provides a key benefit of modifying and using slide masters, so that you can make changes to every slide in your presentation, including the ones added later to the presentation.
While using the Slide Master view, you can save time because you do not have to type the same information on more than one slide. It is the most useful view when you have extremely long presentations with lots of slides.
The Slide Sorter view is used for sorting and organizing the sequence of slides as you create your presentation, and then also as you prepare your presentation for printing.
The Notes Page view is used to edit speaker notes that will be edited while printing. It provides a small writing area to write some notes about a slide. Notes are shown on printouts, but not in slide shows.
The Slide Show view is used to deliver your presentation to your audience; this view takes up the full computer screen, like an actual presentation.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Design Considerations
문제11
Which of the following contextual tabs consists of controls to select the initial layout of a form and the default positions of controls on the form?
Which of the following contextual tabs consists of controls to select the initial layout of a form and the default positions of controls on the form?
정답: A
설명: (ITDumpsKR 회원만 볼 수 있음)
문제12
You want to group by Sales Region to see all records for each sales region together, with a total of sales for each region. Mark the button that you will click to accomplish the task.
You want to group by Sales Region to see all records for each sales region together, with a total of sales for each region. Mark the button that you will click to accomplish the task.
정답:
Explanation:
In order to accomplish the task, you should click the Group & Sort button in the Grouping & Totals group.
Reference:
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Report Design
문제13
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?
정답: C
설명: (ITDumpsKR 회원만 볼 수 있음)
문제14
You work as an Office Assistant for Company Inc. You are creating a presentation in PowerPoint 2010. You have inserted a photo album in it. Now, you want to change the color mode of the photos in the album to black and white. Choose and reorder the appropriate steps to change the pictures to black and white.
You work as an Office Assistant for Company Inc. You are creating a presentation in PowerPoint 2010. You have inserted a photo album in it. Now, you want to change the color mode of the photos in the album to black and white. Choose and reorder the appropriate steps to change the pictures to black and white.
정답:
1 - Click on the Insert tab.
2 - Click Photo Album
3 - Select Edit Photo Album.
4 - Select the All Pictures black adn white check box.
5 - Click the Update button.
Explanation:
A PowerPoint photo album is a collection of photographic presentation slides. It is a presentation that a user can create to display his personal or business photographs. A user can either download PowerPoint photo album templates from Microsoft Office.com or create his own. A user can change the pictures of a photo album to black and white by editing the photo album. Take the following steps to insert images in black and white:
Click on the Insert tab. Click Photo Album > Edit Photo Album.
The Edit Photo Album dialog box appears. Select the All Picture black and white check box. Click the Update button.
The Color button is used to change the color tone of a picture.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Slides