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.