Practice ECDL ECDL-ADVANCED Exam Questions

Which of the following queries is used to see the relationship of data between two fields?

Order List You have created an arithmetic expression in an Access query to compute the results that determine fees based on a contract amount. When you run this query, Access performs the calculations and displays the results. Choose and re - order the steps that you will take to create the calculated field 1 Answer: Explanation: Take the following steps to create a calculated field: Put the insertion point in the Field row of a blank column in the Design grid. Click the Builder button. 2 Double - click the field to be used in the calculation. Build an expression using the operator buttons and elements area. Type other values required to be included in the expression. Click the OK button. Click the Run button. Reference: http://office.microsoft.com/en - us/access Chapter: DATABASE, ADVANCED - LEVEL Objective: Query Design

You work as an Office Assistant for Company Inc. You are creating a presentation in PowerPoint 2010. 3 You have created a button in the presentation. You want a program to run when you click on the button or hover your mouse over it during the slide show. Which of the following will you use to accomplish the task?

Mark the option/button in the following image of the Format tab on which you will click to apply the effect to a textbox. Answer: 4 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 the interface. A user can type the text inside a text box and resize it also according to his need. Take the following steps to add shape effects to a text box: Select the text box. Click the Format tab under Drawing Tools. Click the Shape Effect button in the Shape Styles group. The Shape Effects drop - down list opens. Select an effect to be applied. Chapter: PRESENTATION, ADVANCED - LEVEL Objective: Slides

Which of the following is a list of the references in a legal document, such as cases, statutes, and rules, along with the page numbers on which the references appear? 5