Title: Module 2 Exam
Course: CGS1061: Introduction to Computers > Section: Presentations and Database

Q: C.J. wants to modify a table in his database. C.J. wants to easily edit the field properties in his table. He should work in view.
- Table
- Normal
- Design
- Datasheet
A: Design

Q: C.J. wants to change the default Field Size property for a field with the Text data type from characters to 50.
- 8
- 55
- 100
- 255
A: 255

Q: The above figure shows a table in view.
- Normal
- Layout
- Design
- Datasheet
A: Design

Q: Pilar is creating a new database for her business. Pilar wants to store information about customers’ orders, as well as product details of her inventory. She should create separate _ for each.
- tables
- fields
- records
- databases
A: tables

Q: When the command is turned off, Access ignores capitalization in a search.
- Any Part of Field
- Match Case
- Search Fields
- All Caps
A: Match Case

Q: When you create a(n) _ you can locate multiple records that match specified criteria.
- datasheet
- report
- form
- query
A: query

Q: When you work with a form, view is used for adding, editing, and viewing data.
- Form
- Datasheet
- Layout
- Design
A: Form

Q: The Find button is located on the tab.
- Home
- Database Tools
- Table Tools Layout
- Fields
A: Home

Q: The circles and squares at the edge of the graphic are called handles.
- drawing
- placement
- sizing
- selection
A: sizing

Q: When drawing a shape, the pointer changes to a(n) .
- arrow
- pencil
- crosshair
- four-headed arrow
A: crosshair

Q: Timothy is new to PowerPoint and is learning about the PowerPoint window. Timothy knows that the PowerPoint window includes all of the following elements, EXCEPT:
- Name box
- Quick Access Toolbar
- Ribbon
- Notes pane
A: Name box

Q: Madeleine is formatting a presentation for her Intro to Computers class. Madeleine wants to add her name in a footer on all slides. She does this in view.
- Slide Show
- Slide Sorter
- Slide Master
- Normal
A: Normal

Q: Which of the following is NOT true about databases?
- Like spreadsheets, databases are composed of rows and columns.
- Like Word and Excel, Access has a standard document view.
- Access offers more comprehensive functions for manipulating data than Excel.
- In Access you can import or link data from other Access databases.
A: Like Word and Excel, Access has a standard document view.

Q: A makes it easy for you to view, enter, and edit data.
- table
- form
- report
- query
A: form

Q: Which of the following is NOT one of the animation categories?
- Entrance
- Emphasis
- Exit
- Spin
A: Spin

Q: Which of the following is NOT true about intellectual property?
- Intellectual property is information, material, or processes that were created by and belong to a person or corporation.
- Information that is on the Internet is in the public domain.
- Give credit to those who own material you use by citing sources in the slide show and presentation handout.
- Recipes, codes, and manufacturing processes are trade secrets.
A: Information that is on the Internet is in the public domain.

Q: The figure above shows a presentation in view.
- Slide Sorter
- Slide Show
- Outline
- Normal
A: Slide Sorter

Q: Rajit wants to display the data in his worksheet using graphics. Rajit decides to show snapshots of the data for each row in his worksheet. He inserts
- functions
- sparklines
- charts
- graphics
A: sparklines

Q: Which of the following is NOT true about the contents of column F in the accompanying figure?
- They can be used to show a trend.
- You can use built-in formats to apply a color scheme.
- You can customize the graphic to choose a color for high, low, first, and last values.
- All of the above are true.
A: All of the above are true.

Q: Which of the following is NOT true about charts?
- Charts are used to draw or present conclusions about data.
- If a chart is not set up correctly, the representation can be confusing or misleading.
- The first step is to decide what type of chart you want to create.
- All charts have a horizontal and vertical axis.
A: All charts have a horizontal and vertical axis.

Q: Which of the following is NOT true about delivering a slide show?
- You can use the Pen Options Tool to highlight slide text as you would text on paper.
- You cannot keep the ink annotations you make during a presentation.
- You can toggle off the Pen Options Tool by pressing Esc.
- You can toggle a white screen on and off by pressing W.
A: You cannot keep the ink annotations you make during a presentation.

Q: Which of the following is NOT a method to advance to the next slide in Slide Show view?
- Click the left mouse button.
- Press Enter.
- Press the spacebar.
- Press the up arrow key.
A: Press the up arrow key.

Q: Which of the following is NOT true about Slide Masters?
- When you update a Slide Master element, the edits will be reflected on all the slides in the presentation.
- To access the Slide Master, click a button on the View tab.
- You can use the Slide Master to include a company name on all the slides.
- Slides Master information can include formatting, bullets, backgrounds, and graphics.
A: You can use the Slide Master to include a company name on all the slides.

Q: Which of the following is NOT true about editing slide content?
- If you accidentally delete contents, you can undo your edits.
- If you select a layout that does not have placeholders for the text and content in the original slide, elements of the slide may overlap.
- If you change the slide layout, the content and formatting will also change.
- If you accidentally undo a change, you can redo it.
A: If you change the slide layout, the content and formatting will also change.

Q: In the accompanying figure, the space to the right of “fx” is called the
- name box
- active cell
- title bar
- formula bar
A: formula bar

Q: When you move the mouse pointer over the formula bar, the mouse pointer changes to a(n) .
- one-sided arrow
- double-sided arrow
- white plus sign
- I-beam
A: I-beam

Q: When you move the mouse pointer over the cells in the worksheet window, the mouse pointer changes to (a)n _
- one-sided arrow
- double-sided arrow
- white plus sign
- I-beam
A: white plus sign

Q: Excel refers to a spreadsheet as a _
- worksheet
- workbook
- table
- database
A: worksheet

Q: Cate has finished entering data and formatting her worksheet and is ready to print and share it with others. Cate wants to share her workbook electronically, but doesn’t want the recipients to be able to modify the data. One of her options is to save it as a(n) file.
- PDF
- HTML
- .xlsx
- template
A: PDF

Q: Which of the following is NOT true about table styles?
- If you convert the table to a regular range, the table style formatting is removed.
- A table style is a set of predefined formats you can apply to worksheet data.
- You can choose from 60 table styles in the Quick Styles gallery.
- All of the above are true.
A: If you convert the table to a regular range, the table style formatting is removed.

Q: A(n) is the design of the typeface.
- point
- style
- font
- format
A: font

Q: When you columns and/or rows, you lock them so you can keep an area visible as you scroll through the
worksheet.
- split
- freeze
- hide
- unhide
A: freeze

Q: Alaina wants to print selected data from the database so she can distribute it to donors. She creates a _
- form
c. query
- report
d. table
A: report
d. table

Q: Alaina is working on creating a large database for a non-profit organization she works for. Alaina has a lot of data to enter, and wants to make it easy to enter. She creates a(n) _
- form
- report
- query
- table
A: form

Q: Juan is working with a large database and trying to locate information in it. Juan wants to locate all records that contain a certain postal code, and display them all at once. He creates a _
- table
- report
- form
- query
A: query

Q: Which of the following is NOT true about getting help in Microsoft Office?
- The first source of help should be the Help features in each Office application.
- Navigating the Help screens is much like navigating a Web page.
- If your computer is connected to the Internet, you will also have access to the Microsoft Office.com Web site.
- All of the above are true.
A: All of the above are true.

Q: When you first start Word, a new blank document appears and is automatically titled
- Document1
- Word1
- File1
- Normal1
A: Document1

Q: To view multiple running application windows at the same time, click the command
- Display all
- Show windows
- Show desktop
- Cascade windows
A: Cascade windows

Q: To quickly insert a manual column break, press _
- Ctrl+Enter
- Ctrl+Shift+Enter
- Ctrl+Tab
- Ctrl+Shift+Tab
A: Ctrl+Shift+Enter

Q: When you a graphic, you cut off portions that you do not want to show.
- resize
- outcrop
- crop
- select
A: crop

Q: After converting a range of cells to an Excel database, you can manage and calculate the data independently.
- true
- false
A: false

Q: Rows in a worksheet appear vertically and are identified by letters.
- true
- false
A: false

Q: The AutoComplete feature enables you to repeat the same data in a column or row.
- true
- false
A: false

Q: Clip art is a graphic that is ready to insert in a document.
- true
- false
A: true

Q: The WordArt graphic is created in a text file.
- true
- false
A: false

Q: Font styles, text color, and underline are all examples of document formats.
- true
- false
A: false

Q: When the Track Changes feature is toggled on, all insertions, deletions, and format changes are indicated with
revision marks.
- true
- false
A: true

Q: When you highlight text, you identify a block of text you want to edit.
- true
- false
A: false