experiment

合集下载

1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。

Project 1 Technology Enhanced Presentations
Choice
1. To begin a presentation:
a.choose the New menu, then choose New.
b.choose the File menu, then choose New Presentation.
c.choose the File menu, then choose New.
d.click the New Slide button on the toolbar.
2. To insert footer into the slide presentation:
a.click the Header/Footer button on the toolbar.
b.choose the View menu, choose Master, then choose Slide Master.
c.choose the Edit menu, then choose Header/Footer.
d.choose the View menu, then choose Header/Footer.
3. The type of animation that is caused by the change from one slide to another is a(n):
a.action setting.
b.custom animation.
c.slide transition.
d.preset animation.
4. To set a transition:
a.choose the Slide Show menu, then choose Transition.
b.choose the Slide Show menu, then choose Slide Transition.
c.click the Transition button on the toolbar.
d.choose the Format menu, then choose Transition.
5. What is the first step in setting a custom animation?
a.Clicking the Animation button on the toolbar.
b.Choosing the Slide Show menu.
c.Clicking the mouse on a part of the text to be animate
d.
d.Clicking the Add Effect button on the toolbar.
Essay Questions
What is the purpose of having a clear beginning and ending to a presentation?
Project 2 Web/HTML Project Using Microsoft Word
Choice
1. Which statement is false regarding Web pages?
a.Navigating specific parts of the same Web page is sometimes
needed for long Web pages.
b.It is better to have several short Web pages instead of one
long page.
c.To print linked pages, the page must first be displaye
d.
d.Links allow users to quickly jump to specific parts of a long
Web page.
2. Which command is not a selection in the Paragraph window?
a.Alignment
b.Indentation
c.Spacing
d.Fonts
3. To center the text in table cells:
a.choose the Format menu, then choose Paragraph.
b.choose the Table menu, then choose Alignment.
c.choose the Format menu, then choose Alignment.
d.click the Alignment button on the toolbar, then click Center.
4. To test your links, which key do you hold while clicking on the links?
a.<Alt>
b.<Shift>
c.<Link>
d.<Ctrl>
5. Which phrase do you enter first when linking to an e-mail address?
a.mail:
b.html://
c.mailto:
d.email://
Essay Questions
What is the greatest advantage and disadvantage of creating a Web page using Microsoft Word?
Project 3 Web/HTML Project Using Notepad
Choice
1．Which section of an HTML document includes the title of the Web page?
a.Header
b.Footer
c.Head
d.Body
2．Which of the following lines of code represents an anchor command?
a.<anchor> name=”top_of_page”
b.<anchor> name=”top_of_page”<anchor>
c.<a>name=”top_of_page”</a>
d. <a name=”top_of_page”>
3. Which statement is false regarding lists?
a.<ol> begins an ordered list.
b.Your code must include the numbering sequence.
c.Each item in the list begins with <li>.
d.Each item in the list ends with </li>.
4. The code that represents the insertion of an additional blank line is:
a.<br>
b.<br></br>
c.<li>
d.<li></li>
5. What two commands must be included at the end of the Web page for the code to be interpreted correctly?
a.<html> and <head>
b.</html> and <body>
c.<title> and </end>
d.</body> and </html>
Essay Questions
Why should managers be informed consumers of the Web page development process?
Projects 4 & 5 Web/HTML Customer Satisfaction Form
Web/HTML Computer Purchase Form
Choice
1. Which statement is false regarding drop-down menus?
a.Drop-down menus offer mutually exclusive choices.
b.Drop-down menus take up more space on the screen than do radio
buttons.
c.Drop-down menus are superior to radio buttons when there are
numerous choices.
d.Drop-down menus do not display all of the choice options on
the screen.
2. Which command instructs the Web browser that the user will type text into an input field?
a.<textarea name=”Comments” rows=5 cols=45 wrap=”yes”>
b.<input> type=”text” name=”CustomerName” size=30 </input>
c.<input type=”text” name=”CustomerName” size=30>
d.<input type=”checkbox” name=CustomerName” size=30>
3. Which statement is false concerning radio buttons?
a.The default value for a radio button should read, value=”none”
b.To declare a radio button the code should read …typed=”radio”‟.
c.All of the available choices are shown on the form.
d.The user is allowed to accept more than one choic
e.
4. Which command has the word excellent as a choice in a drop-down list?
a.<option value=”Excellent”>excellent</option>
b.<option> value=”Excellent”</option>
c.<input type=”drop-dow n list” name=Excellent>
d.<input type=”option” name=”Excellent”>
5. Which command is not required for the text area input technique?
a.Text area name
b.Number of rows
c.Number of columns
d.Default text in the text area field
Essay Questions
What are the five most common techniques for capturing information from a Web site?
Project 6 Spreadsheet Basics
Choice
1. If a customer is charged 1% interest for an invoice that is 30 days, and the invoice amount is in Cell F8, the formula for the new invoice total would be:
a.=F8*101%.
b.=F8*1%.
c.=F8*.01
d.=F8*1.01%
2. Which command deletes datasheets?
a.Choose Edit, then choose Delete.
b.Choose Format, then choose Delete Sheet.
c.Choose Edit, then choose Delete Sheet.
d.Right click on the sheet, then choose Delet
e.
3. To format data to appear as currency:
a.choose View, Format, then choose Currency.
b.choose Cells, Format, then choose Currency.
c.choose Format, Cells, Number, then choose Currency.
d.choose Format, Cells, then choose Currency.
4. Which of the following values is an example of a currency format with two decimals?
a. $2207.27
b.2207.27
c.$2,207.27
d.2,207.27
5. Which of the following cell references refers to a datasheet other than the one where the formula is being typed?
a.Discount#$A$4
b.Discount$A$4
c.Discount@$A$4
d.Discount!$A$4
Essay Questions
W hy is the ordering in nested “IF” statements critical?
Projects 7 & 8 Spreadsheets with Data Capture –Minivan Example & Computing Example
Choice
1. The first step in creating a data capture control is to:
a.choose Tools, View, then Control Toolbox.
b.choose Tools, Toolbox, then Forms.
c.choose View, Tools, then Forms.
d.choose View, Tools, then Control Toolbox.
2. Which is the correct PMT function given that cell F1 contains the interest rate, cell F2 contains the # of periods, cell A8 contains the present value, and monthly payments are to be made?
a.=PMT(F1,F2,A8)
b.=PAYMENT(F1/12,F2,A8)
c.=PMT(F1/12,F2,A8)
d.=PMT((F1/12),F2,A8)
3. After drawing a control such as the drop-down menu, which command do you choose?
a.Format, then Control.
b.Right-click on the control, then choose Format.
c.Format, Control, then choose the Control tab.
d.Format, Cells, then choose the Control tab.
4. What is the command to begin a Macro?
a.Right-click on the cell, then choose Record
b.Choose Tools, Macro, Record
c.Choose Tools, Macro, Record New Macro
d.Choose Tools, Macro, Record Macro
5. The last command to finish recording a macro is:
a.right-click on the cell, then choose Stop Recording.
b.choose Tools, Macro, then Stop Recording.
c.choose Tools, Macro, then Stop.
d.right-click on the cell, choose Macro, then choose Stop. Essay Questions
Why are recording macros by keystrokes important to the manager?
Project 9 Database Forms and Reports
Choice
1. Which of the following is not a method of creating a form?
a.Clicking the New button on the toolbar
b.Double-clicking “Create form in Design view”
c.Double-clicking “Create form by using wizard”
d.Double-clicking “Create form by entering data”
2. To enter a validation rule from the form‟s design view:
a.choose Edit, then choose validation rule.
b.choose View, then choose Properties.
c.right-click on the field label, then click Properties.
d.right-click on the data field, then click Properties.
3. Information that is to be written only once at the top of the report is referred to as the:
a.page header.
b.report header.
c.header.
d.page titl
e.
4. The first step in creating a form using the wizard is to:
a.choose the fields.
b.choose the correct table.
c.change the name of the form.
d.choose the form layout.
5. I n the Summary Options of a report, which is not an option?
a.Sum
b.Count
c.Min
d.Max
Essay Questions
How can data entry be aided by the use of a form?
Projects 10 & 11 Database Queries
Choice
1. Which of the following statements is false regarding Access queries?
a.QBE is a format where a user can specify what is desired without
having to write computer code to retrieve records from the
database.
b.The top row is where the table name is displayed.
c.The third row provides an option of sorting the results.
d.The last row is for “or” criteria to be typed.
2. The correct method of writing a query so that the results produce the prices that are greater than or equal to $50 but less than or equal to $75 is:
a.>=50 Or <=75.
b.>=$50 And <=$75.
c.>=50 And <=75.
d.>$50 And <$75.
3. Which criterion is correct for writing a parameter query?
a.<(price should be below)
b.<price is less than>
c.price is <?
d.<[price should be below]
4. Which of the following is an incorrect use of wildcard characters?
a.Like “#i*”
b.Like “*Management”
c.Like “?i*”
d.Like “*Management*”
5. Which command is needed to concatenate a FirstName field and a LastName fie ld, so that the results show “Jordan, Michael” in a new field named “Name?”
:(LastName) & (FirstName)
b.FieldName:[LastName] & …,‟ & [FirstName]
:[LastName] & …,‟ & [FirstName]
:(LastName) & …,‟ & (FirstName)
Essay Questions
Why is it important for decision makers to be able to generate their own queries?
Project 12 Reports Based on Queries
Choice
1. Which statement is false regarding reports?
a.Reports based on query results must usually be modified to
create visually appealing reports.
b.Data is the essential tool of a decision maker.
c.The understanding of the database gained by writing queries
trains a decision maker to use that tool better.
d.Creating reports based upon query results is valuable so that
the decision maker can produce documents for his or her
subordinates.
2. Which of the following is not a choice in the Join Properties dialog box when the table names are CLASS and INTERSECTION?
a.Only include rows where the joined fields from both tables are
equal.
b.Include ALL records from …CLASS‟ and on ly those records from
…INTERSECTION‟ where the joined fields are equal.
c.Include ALL records from …INTERSECTION‟ and only those records
from …CLASS‟ where the joined fields are equal.
d.Only include rows from …CLASS‟ where the joined fields from
both tables are equal.
3. Which of the following is the correct format to take the fourth character from within a text field?
a.Level:Mid(CLASS.ClassNumb,4,1)
b.Level:Mid$([CLASS.ClassNumb],4,1)
c.Level:Mid$[CLASS.ClassNumb,4,1]
d.Level:Mid([CLASS.ClassNumb],4,1)
4. Which of the following is the correct format to pass a parameter value to a report?
a.>=[What is the minimum book price?]
b.>=(What is the minimum book price?)
c.Minimum:[What is the minimum book price?]
d.Minimum:(What is the minimum book price?)
5. Which toolbox i con is represented by “ab|”?
bel
b.Text Box
c.Option Group
d.Unbound Option Frame
Essay Questions
Why should a parameter value be placed in a title?。