HCM 320 Checkpoint Questions
If a date is typed as 4-27-17, Excel will display the date as •4-27-17 •4-27-2017 •4/27/17 •4/27/2017
4/27/2017
To find all records where the Amountfield was less than $1000, enter _____ in the Criteriacell for the Amountfield. •1000 •>1000 •<1000 •<>1000
<1000
When you open a form from the Navigation pane, it opens in which view? A.Form B.Design C.Datasheet D.Report
A.Form
This number format applies a currency symbol, adds two decimal places, and changes the cell's alignment. •Accounting •Number •Percent •General
Accounting
The _____ feature enables you to create a series of entries down a column or across a row. •Copy •Auto Fill •Templates •Clear
Auto Fill
The _____ feature helps you size a row or column automatically. •Format Painter •wrap text •Format Cells •AutoFit
AutoFit
To edit a form, use _______ view. A.Header/Footer B.Layout C.Design D.Form
C.Design
This setting may include font, border, fill, and other formatting settings. •Wrap Text •Merge & Center •Borders •Cell Styles
Cell Styles
Which field data type would you use to store dollar amounts? A.Text B.Number C.AutoNumber D.Currency
D.Currency
Which action selects an entire record? A.pressing the Tab key B.clicking the Record button C.clicking the first field in the record D.clicking the record selector bar
D.clicking the record selector bar
The _____ group on the Home tab contains choices for formatting the datasheet. •Formatting •Datasheet •Design •Text Formatting
Design
When using the Report Wizard, click the _____ button to accept the report and view it in Print Preview. •Done •OK •Finish •Report
Finish
Use the _____ feature to combine multiple cells into a single cell. •wrap text •Merge & Center •borders •cell styles
Merge & Center
Which is NOT true of themes? •Themes provide colors, fonts, and graphical elements. •Themes can be applied to all slides in a presentation. •Only one theme can be applied to a presentation. •Theme variants are available to modify the theme color scheme.
Only one theme can be applied to a presentation
Click the Print option on the File tab to display printing choices in the •Print backstage area. •Print Preview view. •Print dialog box. •Page Layout tab.
Print backstage area.
The best view to use to reorganize slides is the •Reorganize Slides view. •Normal view. •Slide Sorter view. •Slide Show view.
Slide Sorter view
To move one sheet before another use: •Alt + Tab •The Page Layout tab •The View tab •The Move or Copy command
The Move or Copy command
Conditional formatting returns a specific result when •you create a bar chart. •a specific condition is met. •working with a small range of cells. •you apply a theme to cell contents.
a specific condition is met.
Transitions are effects that occur a.when you move from one slide to another. b.when you click an animation button. c.when you display bullet points on a slide. d.if you play several animations on one slide.
a. when you move from one slide to another
The _____ group on the Home tab contains the tools for copying and pasting. a.Clipboard b.Font c.Number d.Editing
a.Clipboard
The Share option is located on this tab. a.File b.Home c.Insert d.Review
a.File
The AutoSum button is located on this tab. a.Home b.Insert c.Page layout d.Data
a.Home
One way to manually advance from one slide to the next is to a.click the left mouse button. b.press Backspace. c.press Esc. d.click the left mouse button, press Backspace, or press Esc.
a.click the left mouse button.
The capital letters across the top of the worksheet are called a.column headings b.row headings c.cells d.active cells
a.column headings
If you want your slide presentation to run continuously, you must a.confirm that the Using Timings If Present option is selected in the Advance Slides section. b.deselect the Use Timings If Present option. c.log in to your Windows account. d.create a custom show.
a.confirm that the Using Timings If Present option is selected in the Advance Slides section.
The Italic button is located a.in the Font group on the Home tab b.on the View tab c.on the Design tab d.in the Font dialog box
a.in the Font group on the Home tab
When you are in Slide Master view, you can •only add a theme. •only change the color palette. •only change the font for slides that use the Two Content layout. •add a theme, change the color palette, and change the font for slides that use the Two Content layout.
add a theme, change the color palette, and change the font for slides that use the Two Content layout
To do a keyword search for a picture that is not on your computer or storage medium, click the _____ button. a.Images b.Online Pictures c.Shapes d.Pictures
b. Online Pictures
The Insert Video button is located a.on the Video Tools Playback tab. b.in a content placeholder. c.in the Video options group. d.on the Insert tab.
b. in a content placeholder
You can edit a cell's content directly in the cell by double-clicking the cell or by making the cell active and then pressing this key. a.F1 b.F2 c.F3 d.F4
b.F2
If you want the spelling checker to leave all instances of a spelling alone, click _____ when that word is selected during a spelling check. a.Ignore b.Ignore All c.Change d.Change All
b.Ignore All
When you want a reference to remain unchanged when you copy a formula, use this type of reference. a.fixed b.absolute c.relative d.circular
b.absolute
The length of time a sound is played a.is always the same as the length of the sound. b.can be modified by changing the duration setting. c.is always the same as the length of the slide show. d.changes depending on the transition chosen.
b.can be modified by changing the duration setting.
Start every formula by typing this. a. + b. @ c. = d. -
c. =
Most functions require one or more _____ that specify what to calculate. a. lists b. rows c. arguments d. lists, rows, and arguments
c. arguments
Animations affect a.what appears when you move from one slide to another. b.transition sounds. c.how the content appears on a slide. d.videos inserted into your presentation.
c.how the content appears on a slide.
The Navigation pane lists all _____ in the database. a.records b.worksheets c.objects d.macros
c.objects
A group of related fields, such as all the information about one employee, is stored in a a.field. b.column. c.record. d.row.
c.record.
The column letter and row number make up the cell reference or •value •range name •cell address •formula
cell address
Which chart type would best compare the attendance at an annual meeting for the past four years? •column •line •pie •bar
column
You can format a picture by a.adding borders. b.adding special effects. c.changing the picture size. d.adding borders, adding special effects, and resizing the picture.
d. adding borders, adding special effects, and resizing the picture.
You select animation effects to apply to objects on your slide using the a.Transitions gallery. b.Design gallery. c.Animations gallery. d.Effects Options button.
d.Effects Options button.
The Show Formulas button is located on this tab. a.Home b.Insert c.Page Layout d.Formulas
d.Formulas
You can insert a function using buttons in the Function Library group on this tab. a.Home b.Insert c.Page layout d.Formulas
d.Formulas
The Rehearse Timings button is located in the Set Up group on this tab. a.Insert b.Design c.Animations d.Slide Show
d.Slide Show
In PowerPoint you can print a.only full-page slides. b.only handouts. c.only notes. d.full-page slides, handouts, and notes.
d.full-page slides, handouts, and notes.
Which of the following is not a valid method for moving between cells in a table? a.pressing Tab b.pressing the Right Arrow key c.clicking a cell d.pressing the Backspace key
d.pressing the Backspace key
Doing this to a row or column removes it and its contents. •inserting •copying •deleting •summing
deleting
Which action temporarily displays records matching the criteria you specify for one or more fields? •sort •hide •filter •parse
filter
The Hide background graphics check box is located •on the View tab. •in the Format Shape pane. •on the Slide Show tab. •in the Format Background pane.
in the Format Background pane.
When data is modified, the chart automatically updates because it is to the worksheet data. •merged •pasted •copied •linked
linked
Which chart type would best show how much of a company's total salary budget was spent on each department in the company? •pie •column •line •bar
pie
Which of the following asks a question of a database? •table •form •query •report
query
When you create a query in Design view, you use the _____ to create the query. •Query Wizard dialog boxes •query design grid •layout design grid •Print Preview window
query design grid
To explode a pie slice, •select it and then drag it away from the other slices. •double-click it. •rotate it 220 degrees. •add data labels.
select it and then drag it away from the other slices.
The spelling checker can find errors in these types of entries. •text •values •dates •worksheet names
text
An efficient way to add a graphic to every slide in a presentation is place it on •every slide. •the top (largest) slide in a slide master set. •every slide in a slide master set. •the first slide in the presentation.
the top (largest) slide in a slide master set
Footers on slides have this many placeholders by default. •two •three •five •none
three
A descriptive heading for a chart is a chart •layout •label •legend •title
title
The default slide master •is the first theme you create. •is created by the first theme you apply. •uses the Office Theme. •always uses a custom theme.
uses the Office Theme
When creating a worksheet, you can improve readability by •making each column a different color. •using borders to help organize the worksheet into sections. •applying the Accounting format to entries that represent dates. •always making very wide columns.
using borders to help organize the worksheet into sections.
To access the New Slide button, display this tab. •Insert •View •Home •Slide Show
•Home
Which button changes the print orientation from the default setting of portrait orientation? •Group & Sort •Themes •Landscape •Print
•Landscape
The notes pane appears in •Slide Show view. •Normal view. •Slide Sorter view. •Reading view
•Normal view.
A content placeholder is formatted to contain this by default. •a numbered list •clip art •a slide title •a bulleted list
•a bulleted list
Layouts can include •only content placeholders. •only title placeholders. •only subtitle placeholders. •content, title, and subtitle placeholders.
•content, title, and subtitle placeholders.