Bus 101
Which section in the Share pane displays the names of people with whom the current notebook has been shared?
This notebook shared with
To make changes to the appearance or structure of a table, use the Table Tools Design and _____ tabs.
Layout
Which button do you use to change the way text wraps around a picture that you inserted into a document?
Layout Options
Which button would you use to change the spacing before and after paragraphs?
Line and Paragraph Spacing
_____ allows you to see the effect of a change before applying the option.
Live preview
Which button in the Function Library group on the Formulas tab would you use to start an IF statement?
Logical
Which check box would you click to play the audio inserted on a slide continuously during the slide show until the slide is advanced?
Loop until Stopped
Which action do you do first to add a new page to a notebook?
Make the desired section active
When you add a comment to selected text, the comment balloon appears in the
Markup Area
Which window button expands the window to fill the entire screen?
Maximize
Which feature is often used to center a worksheet title in a worksheet?
Merge & Center
Which of the following is not a button in the Number group on the Home tab used to change the appearance of numeric entries in a worksheet?
Merge & Center
Which button would you use to combine two or more cells into one?
Merge Cells
Which button would you use to combine two or more table cells into one?
Merge Cells
Which button centers text vertically within a cell?
Middle Align
What is the name of the toolbar that appears after text is selected?
Mini toolbar
Which window button is used to reduce the window to a button on the taskbar?
Minimize
Which option would you choose from the Number Format drop-down list to open the Format Cells dialog box to format cells with dates?
More Number Formats
You have a large worksheet and notice that when you scroll down, the column headings in rows 1 and 2 are not visible. What can you do to fix rows 1 and 2 in place?
Move the active cell to A3 and then use the Freeze Panes option.
To name a cell or a selected range, type the descriptive label in the
Name box
What is the name of the pane that displays when you click the Find button in the Editing group on the Home tab?
Navigation
Templates for creating a résumé or cover letter are available in the _____ backstage area.
New
Add new records to a table by opening the table datasheet and clicking the _____ button.
New (blank) record
Which button would you click on the Record Navigation bar in a form to add a new record?
New (blank) record
Which button would you click in the New group on the Home tab in File Explorer to create a new folder?
New folder
You have a table for invoices with a field name Paid? that displays a check box in the datasheet. Checked boxes mean that the invoice is paid. What would you type in the Criteria box in a query to instruct Access to show you only those records where the check box is empty (not paid)?
No
Select the correct statement about the formatting and page layout guidelines for MLA.
No title page is required unless specifically requested by the instructor.
A new notebook is created by clicking the Show Notebooks button and then clicking the
Notebook button.
Which slides option in the Settings category prints one slide per page with notes, if notes exist, in the bottom half?
Notes Pages
When multiple criteria are on different rows in the query design grid, it is referred to as a(n) _____ statement, meaning that any criterion can be met for a record to be selected.
OR
If any criterion can be met for a record to be selected, it is called a(n)
OR statement.
The Office suite can be purchased as a one-time purchase for installation on a computer, or via a subscription called
Office 365.
A OneNote notebook created in the OneNote Windows app is stored on
OneDrive
In OneNote for Windows 10, where is a OneNote notebook stored?
OneDrive
_____ is cloud storage available to individuals signed in with a Microsoft account.
OneDrive
_____ is cloud storage where you save files that can be accessed from any other internet-connected device
OneDrive
What does OneNote do automatically after you create a new notebook?
OneNote makes the new notebook active.
Which button in the Images group on the Insert tab is used to find a suitable image from an online resource?
Online Pictures
Which of the following is not a Word view?
Online view
You need to insert a not equal symbol (≠) in a document. The symbol is not shown in the Symbol drop-down gallery. What can you do?
Open the Symbol dialog box to browse more symbols.
If you need to send a Word document to someone who does not have Word, you can save it as a _____ document, which is an open standard for exchanging files electronically.
When exchanging documents electronically, use this open standard format, developed by Adobe Systems, to save a copy of the file formatted as it would look if the document were printed in the application in which it was created.
Which button on the Insert tab would you click to embed a copy of the content in a file on the current page?
Which of the following functions is not considered a statistical function?
PMT
Which of the following is the financial function that calculates a payment for a loan?
PMT
You want to be prepared to discuss financing options with a sales person after test driving a new car. Which Excel function can help you estimate a loan payment amount?
PMT
Add a border around the edges of a page using the _____ button.
Page Borders
When adding a header to a worksheet, click in the Header pane using which view?
Page Layout
Which view allows you to preview page layout options and also edit the worksheet?
Page Layout view
Open the _____ dialog box with the Margins tab active to center a worksheet horizontally.
Page Setup
Which dialog box do you open to change the vertical alignment of a page to center the page between the top and bottom edges?
Page Setup
Which dialog box would you open to instruct Excel to print worksheet comments on a separate page after the worksheet is printed?
Page Setup
To insert a page break, use the Page Break button in the _____ group on the _____ tab.
Pages; Insert
Which button appears below pasted text?
Paste Options
When an image is selected, which tab becomes active?
Picture Tools Format
Which button in the Images group on the Insert tab is used to add an image to a slide from a file stored on the PC?
Pictures
You have a digital photograph of a computer you want to insert in OneNote for use in an assignment. Which button on the Insert tab would you use?
Pictures
Excel offers three types of sparkline charts. Which of the following is not one of them?
Pie
Which option on the Audio Tools Playback tab will cause the music that starts at Slide 1 to play through the remaining slides?
Play Across Slides
After a video is added to a slide, use options on the Video Tools Format and Video Tools _____ tabs to change the video's appearance or play settings.
Playback
Before printing a table or query results datasheet, adjust the page orientation using the
Portrait or Landscape button on the Print Preview tab
What is the first step performed to edit text?
Position the insertion point.
Which view would you use to display a slide show when you want to see a preview of the next slide in the presentation on a second monitor?
Presenter view
You are about to begin a presentation to your class. Two monitors are available connected to the video display equipment. You have notes to yourself on each slide and want to see a preview of the next slide while you are speaking. Which view are you likely to use to deliver your presentation?
Presenter view
The format for audience handouts or speaker notes is set at the _____ backstage area.
Which SmartArt layout category is used to show a sequential series of steps to complete a process or task?
Process
Which of the following applications is not included in the Microsoft Office suite?
Project
Which button is used to format a calculated field?
Property Sheet
Which task pane do you open to change the format of a calculated field to Currency?
Property Sheet
Format a selected range as a table using the _____ button.
Quick Analysis
Which button that appears when you select a range is used to produce a chart?
Quick Analysis
What is the default view in which a File Explorer window opens?
Quick access view
To add a new record to a table, open the table and click the New (blank) record button in the
Record Navigation bar.
In which group on the Home tab will you find the Delete button to delete the selected record from the database?
Records
To add the author for quoted text in a research paper, position the insertion point where a citation is needed and use the Insert Citation button on which tab?
References
To create a reference, position the insertion point where a citation is needed and use the Insert Citation button on which tab?
References
Tools for adding and managing the sources for an academic paper are located on the _____ tab.
References
Which button is used to change the name of a folder in File Explorer?
Rename
Access changes all occurrences of a field value automatically when the _____ command is selected.
Replace All
Two options at the bottom of a comment balloon are Reply and
Resolve
When an application window has been maximized, which button replaces the Maximize button?
Restore Down button
Which ribbon tab would you click to attach a comment to the active cell?
Review
The _____ button is used to change the display of the ribbon.
Ribbon Display Options
The _____ function adds a column or row of numbers.
SUM
workbook.
SUM
Which feature should be used to remove a USB flash drive?
Safely Remove Hardware and Eject Media
_____ refers to the number of pixels that make up the image shown on the display.
Screen resolution
When building a query using the Simple Query Wizard, which list box determines the order of the fields in the query results?
Selected Fields
What is one reason that the Office suite is popular?
Several features are common to all applications within the suite.
Which button is used to draw your own graphics on a slide?
Shapes
Which button on the Insert tab provides tools to draw a line, rectangle, oval, star, or block arrow?
Shapes
You are planning a trip to Europe with six members of your extended family. How can you best use OneNote to let each person contribute ideas or information about the trip?
Share the notebook with each person.
Which button on the Header & Footer Tools Design tab inserts a code that prints the worksheet name in the active box in the Header pane?
Sheet Name
The New sheet button is located on the
Sheet tab bar.
A printed copy of a worksheet shows formula results unless the display has been changed using the _____ button.
Show Formulas
Click the _____ button in the Paragraph group on the Home tab, to display the hidden formatting symbols.
Show/Hide
The _____ helps you create a query by asking you for information in a series of dialog boxes.
Simple Query Wizard
You want to add a slide in an existing presentation and have the new slide appear after slide 4. Which slide will you make active before clicking the New Slide button on the Home tab?
Slide 4
To exit Slide Master view, click the _____ tab and then click the _____ button.
Slide Master; Close Master View
You can delete a slide in either Normal view or _____ view.
Slide Sorter
_____ describes the arrangement of placeholders and type of content included in a slide.
Slide layout
_____ help you align, space, or size placeholders or objects evenly.
Smart guides
A feature that lets you illustrate graphically a relationship between list items or a process is called
SmartArt
Which feature uses graphics to visually communicate relationships in lists, processes, cycles, and hierarchies?
SmartArt
You want to sort a worksheet by the data in column B and then by the data in column E. Which dialog box do you open to specify the sort columns after selecting the range?
Sort
To change the order of the records by the active field, click the Ascending or Descending button in the _____ group on the Home tab.
Sort & Filter
You have a range selected in the current worksheet and want Excel to arrange the data alphabetically in descending order by the first column in the range. Which option do you choose from the Sort & Filter drop-down list?
Sort Z to A
Each Office application opens at a(n) _____ screen.
Start
Which keyboard shortcut is pressed on the keyboard to bring up the Start menu?
Start
Which entry would display the current date in the active cell?
TODAY()
To move to the next cell in a table using the keyboard, press the _____ key(s).
Tab
When a form is open, what key(s) would you press to start a new blank record after typing the last entry in the current form?
Tab
Format a selected range as an independent group of cells that can be analyzed separately from other cells by clicking the _____ tab from the Quick Analysis button.
Tables
The ribbon in an Office application displays individual ____, each of which is divided into groups of related buttons.
Tabs
Which view shows all open apps as thumbnails and includes a timeline?
Task View
In which text box would you type a word or phrase to access Help resources?
Tell Me
In Chapter 6, you will create documents from a blank page and from the _____ gallery.
Template
Word provides several _____ to help you build job search documents.
Templates
The Action Center panel is open on the desktop. What action caused the panel to appear?
The Notifications icon was clicked.
Which of the following is not an indicator that some rows of data in a table are temporarily hidden?
The Title bar has an asterisk after the file name.
Choose the true statement about text in a WordArt object.
The WordArt object is modified using buttons on the Drawing Tools Format
How can you tell which placeholder on a slide is the active placeholder?
The active placeholder displays with a border and selection handles
Which symbol appears across a cell when the column width is too narrow to show the entries?
# pound
To see all the records for library fines issued on the first day of March in 2021, you type March 1, 2021 in the Criteria box of the DateIssued field. How does Access display your entry after you press Enter?
#3/1/2021#
Typing April 3, 2021 in a date field in a query is converted by Access into which entry?
#4/3/2021#
Which symbol precedes a column letter or row number in an absolute address?
$ (dollar sign
Which code in a header converts to the worksheet name when you click outside the header section?
&[Tab]
Which of the following is not a valid entry for a formula?
(A1+A2)*A3
While reading a document you notice a comment but the text in the comment box is dimmed. What does this mean?
The comment has been marked as being resolved.
Which button displays the Notebooks list?
. Show Notebooks
Each time you click the Increase Indent button, the paragraph indents _____ inch(es).
0.5
Which of the following is not a default print option for a worksheet in Excel?
1-inch left and right margins
Which of the following is not a valid cell reference?
15BZ
Which handout option prints horizontal lines next to each slide for handwritten notes?
3 Slides
The formula =IF(F4>=500,F4*10%,0) is in cell H4. F4 contains the value 600. What result will Excel display in H4?
60
Which character separates the top left cell reference from the lower right cell reference when specifying a range?
: (colon)
Which symbol is the first character typed when creating a formula?
= (equals)
Which of the following formulas provides the arithmetic mean of a range?
=AVERAGE(A2:A25)
Which of the following shows the correct function to calculate an average from a group of values?
=AVERAGE(A2:A25)
Which of the following entries is not a valid date entry?
=DATE(11-19-2021)
Which of the following formulas is a valid IF statement?
=IF(F4>500,F4*SaveRate,0)
Which expression would you enter in a field named Quantity to see only those records with a quantity of 5 or more?
>=5
After the last slide in a slide show has been viewed, which of the following actions happen?
A black screen is shown.
How can you tell if a comment is attached to a slide?
A comment balloon appears in the top left corner of the slide.
How can you tell when a record is being edited?
A pencil appears left of the first column.
How can you tell when a column's width has been made too narrow to show all the characters?
A series of pound symbols (#####) display in the cells within the column.
Select the correct statement about tables in Word.
A table is created by clicking a square in a drop-down grid that represents the desired number of columns and rows.
A(n) ____statement means that multiple criteria in the same Criteria row must be met to select a record.
AND
When multiple criteria are on the same row in the query design grid, it is referred to as a(n) _____ statement, meaning that all criterion must be met for a record to be selected.
AND
To create a self-running presentation, each slide requires a time entered in the _____ text box in the Timing group on the Transitions tab.
After
Which of the following statements regarding the Undo feature is not true?
All actions can be reversed with Undo.
You are working on a worksheet that currently has data in rows 1 through 25. You delete row 10. What happens to the data in rows 11 through 25 after row 10 is deleted?
All data shifts up to fill the space; the last row with data is now row 24.
Which of the following is a valid query expression to calculate an amount by multiplying the value in the field named Qty times the value in the field name Price and title the column Amount?
Amount: [Qty]*[Price]
Which option from the Orientation button rotates the text within the cell boundaries 45 degrees?
Angle Counterclockwise
_____ involves adding a special effect to an object on a slide that causes the object to move or change in some way.
Animation
The _____ button copies animation effects and options from one object to another.
Animation Painter
Choose the _____ to copy the animation effect and effect options from one object to another.
Animation Painter button
Which of the following statements is true about styles?
The document will change in appearance if you change the style set after applying styles.
Why might a supervisor instruct you not to delete records in a database?
The records need to be kept for historical purposes.
You notice a word typed in a document displays with a red wavy line below it. What does the red wavy line indicate?
The word is a possible spelling error.
Click the _____ button in the Media group on the Insert tab to add sound to a slide.
Audio
Add sound from a file stored on a computer by clicking the Audio button in the Media group on the Insert tab and then choosing
Audio on My PC.
The _____ feature can enter many common text or number series in adjacent cells based on the entry in the active cell.
Auto Fill
What is the name of the feature that changes the width of a column to fit the contents of the active cell?
AutoFit
Use the ____ button to add a column or row of numbers.
AutoSum
Which Start option do you choose to have a video begin playing as soon as the slide displays in a slide show?
Automatically
Which of the following is not an option accessed from the Chart Elements button for a pie chart?
Axis Options
Which of the following is not one of the options for paragraph alignment in Word?
Balanced
Which button would you click in the Column Width dialog box to adjust the width to the length of the longest entry in the field?
Best Fit
Which feature adjusts the width of the column to accommodate the longest entry?
Best Fit
Which button is used to generate a References page for an APA paper?
Bibliography
In Word, you can search for an image on the web in the Online Pictures dialog box, which provides image search results from the _____ search engine.
Bing
Which search engine is used within the Online Pictures dialog box to find a suitable image online?
Bing
Which option in the Set Up Show dialog box would you choose to set up a self-running presentation?
Browsed at a kiosk (full screen)
How can you tell if two tables are connected with a relationship while you are building a query?
They have a join line between the two table field list boxes.
The default font in a new document is 11-point
Calibri
Which feature applies a set of predefined formatting options to the active cell?
Cell Styles
What is the advantage to formatting a worksheet using Cell Styles?
Cell Styles promote consistency in formatting headings, totals, and accented cells.
Which of the following is not an option for modifying or customizing a table on a slide?
Change the row height for a cell using a button on the Table Tools Alignment tab.
Which of the following statements regarding slide masters is not true?
Changes made to the slide master affect all presentations.
Which of the following is not one of the three buttons that display next to a chart that are used for modifying the chart?
Chart Gallery
Which tab would you activate to find the Change Colors button to change the color scheme for a chart?
Chart Tools Design tab
The Editor task pane is open in the current document. Which button caused the pane to open?
Check Document
Begin editing an existing citation by positioning the insertion point within the citation and then clicking the
Citation Options arrow
You want to type a numbered list that displays a bracket instead of a period after each number. For example, 1) instead of 1. What will you do before typing the first entry in the list?
Click the Numbering option arrow to choose the bracketed numbers option in the Numbering Library.
You have started a new document based upon a template. What does the entry [phone] near the top of the document indicate to you?
Click the entry and then type a telephone number.
The insertion point is currently positioned in the first word in a bulleted list. You want to change the font for the entire bulleted list placeholder. How can you remove the insertion point in the placeholder before changing the font?
Click the placeholder border.
You want to change the color of all text in a placeholder to red. Which action will you perform first?
Click to select the placeholder.
Perform a copy task by first selecting the file to be copied and then using the Copy and Paste buttons in the _____ group.
Clipboard
Which feature is useful for a document that will be reviewed by multiple readers?
Comments
An existing bulleted list on a slide can be converted to a SmartArt graphic using which button?
Convert to SmartArt
Which button do you click to start a new document based upon the template you are currently previewing in the New backstage area?
Create
You are at the preview screen for a cover letter template. You decide you like the template. Which button do you click in the preview window to start a new document based on the template?
Create
Select more than one slide to delete by holding down the _____ key while clicking other slides.
Ctrl
Which of the following is not one of the options used to narrow the scope of a search?
Current Note
Which button in the Clipboard group on the Home tab is used to move selected text to another location?
Cut
Which button moves the insertion point or text back to the previous tab in a bulleted list?
Decrease List Level
On which tab in the Smart Lookup task pane in Word could you read a definition of a word?
Define
To change a presentation's theme or color scheme after the presentation has been created, begin by clicking the _____ tab.
Design
After a presentation has been created, change the theme by using the
Design tab
Which view is used to set up the structure or layout of an object?
Design view
Once a table has been inserted into a document, use buttons on the Table Tools _____ tab and the Table Tools _____ tab to format and modify it.
Design; Layout
Which Word view hides print elements, such as headers and footers?
Draft view
Which option from the shortcut menu on a selected slide makes an exact replica of the slide?
Duplicate Slide
What is meant by the term banded rows?
Every other row has the same formatting applied.
Zoom In, Zoom Out, and the Zoom slider bar function the same in Word, PowerPoint, and _____ to increase or decrease magnification of the content.
Excel
What does Excel do when a chart is moved to its own chart sheet?
Excel scales the chart to fill a letter-size page in landscape orientation.
Which option do you click from the File tab to create a PDF copy of the active worksheet?
Export
What is the keyboard shortcut to edit the text in the current field?
F2
Which key can be used to open a field for editing in a table?
F2
An exclamation point precedes a column letter or row number in an absolute address.
False
True or false: If you customize the Quick Access Toolbar in Word, the changed toolbar carries over to the other applications within the Office suite.
False
Which field property box specifies the maximum number of characters allowed in the ID field?
Field Size
Which window would you open to browse the files and folders stored on a USB flash drive?
File Explorer
The_____ button in the Editing group on the Home tab presents options to copy an entry or formula across or down to other cells.
Fill
Which feature would you use to temporarily hide the records of all people who live in Tulsa?
Filter
Which feature can you use to search for a record by a name or ID number?
Find
Which feature highlights all occurrences of a word or phrase in the active document?
Find
You opened a table with thousands of records and need to locate one specific person to edit his phone number. What feature will you use to move to the correct record quickly?
Find
Which button is used to access the Go To command?
Find & Select
Which scaling option shrinks the size of text so that all of the active worksheet prints on one page?
Fit Sheet on One Page
Which feature will automatically fill data as soon as a pattern is recognized?
Flash Fill
Which pane do you open to add page numbers to the bottom of a document?
Footer
You notice the dates displayed along the bottom of a line chart were converted incorrectly when the chart was graphed. Which task pane would you open to correct the dates?
Format Axis
Which dialog box would you use to change the display of the entry 12/20/2021 to 20-Dec-21?
Format Cells
Which feature is used to copy formatting options from the selected text or object to other text or another object?
Format Painter
In a large worksheet, use the _____ option to fix rows or columns in place for scrolling in the viewing area.
Freeze Panes
By default, cells in a new worksheet have no specific appearance options because they are all in the _____ format
General
You want to display your company name at the bottom of each slide. Which dialog box will you open to type this text?
Header and Footer
Which SmartArt layout category would be best for showing an organizational chart?
Hierarchy
Which button would you click in the Editor task pane while reviewing spelling errors detected by Word when a word is not found in the dictionary but is spelled correctly, such as a proper name?
Ignore All
You have checked a document for spelling errors and the word Hillmane is shown as a possible spelling error. Hillmane is the name of a doctor where you work and her name is spelled correctly. Which button would you click in the Editor task pane?
Ignore All
Which button moves an entry approximately one character width inward from the left edge of a cell?
Increase Indent
Which button moves the text in a cell approximately one character width inward from the left edge of the cell?
Increase Indent
Which button causes the text on a slide to move to the next tab to the right and change the bullet symbol?
Increase List Level
To add text below the selected image, click the References tab and then click the _____ button.
Insert Caption
To add a clustered column chart to a slide, which icon do you click in the content placeholder?
Insert Chart
Which button appears after you insert a new row or column with options to apply formatting from adjacent rows or columns?
Insert Options
Which option is used to embed a copy of content from a file onto the current page?
Insert Printout from PDF
Which of the following statements about the Mini toolbar is true?
It contains frequently used formatting commands.
After choosing the Browsed at a kiosk (full screen) option in the Set Up Show dialog box, what happens to the slide show?
It continuously loops the slide show until stopped.
What does OneNote do when you type a web address?
It formats the web address as a hyperlink
How can you tell which cell is the active cell in a worksheet?
It has a green border
Select the correct statement about the Find feature.
It highlights all occurrences of a word or phrase in the document.
Select the true statement about WordArt.
It is text created and formatted as a graphic object.
When you type a keyword or phrase in the search text box, what does OneNote automatically do?
It searches for matches in all notebooks
Select the correct statement about paragraph formatting.
Justified text has left and right margins that are even.
Which tag adds an interactive check box to the left of the note text?
To-Do
Which button is used to the clear the filter in the active datasheet?
Toggle Filter
Use the _____ button to change the starting or ending point in a video to play only a portion of the video during a slide show.
Trim Video
Which button would you use to change the ending time for a video during the video playback during a slide show?
Trim Video
A primary key is a field that contains the data that uniquely identifies each record in a table.
True
Features in Word allow you to format a document for a special purpose, such as a research paper.
True
Increase List Level causes the text on a slide to move to the next tab to the right and change the bullet symbol.
True
Slide layout describes the arrangement of placeholders and type of content included in a slide.
True
True or false: Every computing device needs an operating system (OS).
True
Which option on a tile's shortcut menu turns off the display of notifications on the tile?
Turn Live Tile off
When you open the Start menu, you want the Calendar tile to show you reminders for the current day. Which option do you need to activate if the tile does not currently show reminders?
Turn Live Tile on
You want to find a name within a long passage of text copied from a web page but you are not sure of the correct spelling. How can you use the search feature to find the name?
Type the first few characters in the name that you know are correct.
To reverse an action, use the _____ command.
Undo
Which shortcut menu option removes a tile from the Start menu?
Unpin from Start
When a logical test proves true, Excel calculates the statement in which box of the Function Arguments dialog box?
Value_if_true
Which option box do you use in the Page Setup dialog box with the Layout tab active to center the text on a page between the top and bottom margins?
Vertical alignment
Change to Slide Master view by clicking the
View tab, Slide Master button.
What is an implication of using Windows with a local account?
Windows and browser settings are not shared with other devices.
Which application can be used to create text in outline format for new slides in PowerPoint?
Word
Which application in the Microsoft Office suite is used to create documents that are composed mostly of text?
Word
_____ is text that is created and formatted as a graphic object.
WordArt
What is the default color applied to selected text when you use the Highlight button?
Yellow
What do you type in the Criteria box for a field with the title FinePaid? to indicate you want to see only those records where the fine has been paid (a check mark is in the check box)?
Yes
You are entering a new record in a datasheet and notice one column has a blank check box. This indicates a field that is set up to store one of two possible values, which are
Yes or No.
You changed the font color to red for the title placeholder on the slide master. You notice afterwards that the title slide (slide 1) does not display the title in red font. What happened?
You did not change the font color on the title slide master.
Which scenario is not likely to be an example of when you would use the Comments feature?
You want to add some additional text about the slide content for the audience to view during the slide show.
Which file type packages and compresses a group of files into an archive file?
ZIP file
Which dialog box would you open to choose a custom magnification option for the work area?
Zoom`
A tag is
a category assigned to a note.
A column chart is well suited to show
a comparison of values over time.
What does the Accounting Number Format include that the Comma Style does not?
a currency symbol
Which symbol represents the Important tag?
a gold star
What feature can you use to reference a cell that makes creating and understanding a formula that uses the cell easier?
a range name
What appears next to a note container when you rest the mouse pointer on text?
a selection handle
A new row is inserted _____ in which the active cell is located.
above the row
A cell referenced with a range name automatically becomes a(n) _____ reference.
absolute
To create formulas correctly in Excel requires an understanding of two types of references: relative and
absolute
The AutoFit feature automatically changes the column width to fit the contents of the
active cell.
A new slide is inserted
after the active slide
Which locations are searched by default when you type text in the search text box in OneNote?
all pages within all notebooks
A Works Cited page is organized
alphabetically by author's name
In the Customize Quick Access Toolbar drop-down list, items displayed with a check mark are
already added to the toolbar.
To create a presentation that advances through slides automatically, you will need to set up for each slide a(n)
amount of time for the slide to display.
Which special effect was used when an object on a slide swiveled during a slide show?
animation
Which type of special effect can be used to focus attention to an object on a slide as it displays in the slide show?
animation
Most lending institutions express the interest rate in which time period?
annually
At the settings window, the app buttons below the background thumbnails are used to change the
apps that give notifications on the Lock screen image.
Which of the following refers to the parameters for a function?
argument
The inputs you supply for a function are referred to as parameters or
arguments
You type https://paradigmeducation.com on a page in OneNote. How does OneNote display this entry?
as a hyperlink
How are slides displayed in Slide Sorter view?
as slide thumbnails
You changed the Color option to red in the Settings app. Where will you see the new color appear as you work with Windows 10?
as the background color for Windows app tiles on the Start screen
When you add a new button to the Quick Access Toolbar, the button appears Select one:
as the last button on the toolbar.
You added a new button to the Quick Access Toolbar. Where will the new button appear on the toolbar?
at the end
A new column is inserted _____ in which the active cell is located.
at the left of the column
Where does the text known as a header appear?
at the top of each page
The contents of a document can be embedded as a PDF printout on a page, or the document can be inserted as a(n) _____ that links to the source file.
attachment
You typed adn, pressed the spacebar and Word automatically converted the text to and. What is the name of the feature that caused this to happen?
auto correct
You typed 3/4, pressed the spacebar, and Word automatically converted the text to a fraction (¾). What is the name of the feature that was in effect?
auto format
The Fill Color button applies color to the _____ of a cell.
background
In all Office applications, the _____ is where file management commands, such as Open, Save, Save As, Print, and Close are located.
backstage area
When every other row of a table has a different background color applied, it is said to have _____ rows.
banded
In Normal view, the notes pane appears
below the slide pane.
Each note on a page is stored within a note container, which is a(n)
box surrounding the text
How do you display the Header and Footer dialog box from the Print backstage area?
by clicking the Edit Header & Footer hyperlink
How is a OneNote notebook organized?
by sections
How can you tell that a cell has a comment attached to it?
by the red triangle in the upper right corner of the cell
In a table, the box that is the intersection of a row and a column is called a table
cell
Changing the font is referred to as _____ formatting
character
Which of the following options is not a method used to switch to another open app?
click the app in the Action Center panel
A shape can be drawn on a slide by dragging the crosshairs until the shape is the desired height and width on the slide or by
clicking on the slide to insert the shape at the default size.
Signing out of a Windows session
closes all apps and documents.
Web-based productivity software and storage technologies are called _____ computing.
cloud
OneNote can be used to collaborate on and share ideas, research, and
content
All of the following are examples of activities that involve using a database except
copying an image from your camera to use in a flyer.
Which button do you select when you want to move a file from one location to another?
cut
Which of the following documents would not be suited for creation with Word?
data from a nationwide survey
Which option can you add to a pie chart to add context with the size of each pie slice?
data labels
To sort, calculate, and verify data you should choose the most appropriate _____ for each field.
data type
Data that is stored in an organized manner is called a
database
Microsoft Access is a database application referred to as a
database management system
What does DBMS stand for?
database management system
Query results display in a
datasheet
Which of the following is not one of the arguments required by the PMT function?
date of first payment
A valid time entered into a cell is stored as a _____ representing a fraction of a day.
decimal value
Which tab in the Smart Lookup task pane would you choose to read a definition of the searched word?
define
Every Access object has at least two views: a data view and a(n) _____ view.
design
Options in the Paste Options gallery let you change the appearance or behavior of pasted text in the
destination location.
What term is used to describe the type of application that is Microsoft OneNote?
digital notebook
Note-taking software like OneNote is categorized as a(n)
digital notebook.
A change made to a document after the document has been typed is referred to as
editing
Begin a simple query by choosing the table name and the required order of the _____ you want to view from the table.
fields
The down-pointing arrow at the top of a table column next to the column title is called the _____ arrow.
filter
Which Excel feature temporarily hides rows with data that does not meet a criterion so that you can examine a subset of data?
filter
Pressing the Tab key creates a _____ indent.
first line
You changed the style set in the current document that has several styles applied to text. You will notice text with styles applied changed in appearance with respect to paragraph formatting or _____ formatting options.
font
Which object is preferred for editing or deleting records because only one record at a time displays?
form
The process of changing the appearance of the text in a document is referred to as
formatting
Begin displaying a slide show starting at Slide 1 by clicking the _____ button on the Slide Show tab.
from beginning
Which Excel library is frequently updated and expanded?
function library
A live preview, which displays formatting as it will look if applied to a selected text or object, occurs when you point to an option in a
gallery
On a Windows touch-enabled device, the term for an action or motion you perform with your finger(s), thumb, or stylus is a
gesture
Tap, double-tap, swipe, and slide are actions called
gestures.
A _____ indent is where the first line of the paragraph remains at the left margin, but subsequent lines are indented.
hanging
A paragraph in which all lines are indented except the first line is called a(n)
hanging indent
A page break that you insert manually is referred to as a _____ page break.
hard
Page numbering in a document is added within a
header or footer.
Which button on the Help tab opens the Help task pane at the right side of the window?
help
The Show/Hide button turns on or off the display of
hidden formatting symbols.
In addition to displaying a list of pages where the search text has been found, OneNote
highlights matches to the search text
In a column chart, the category axis is also referred to as the _____ or the _____ axis.
horizontal; x
Clicking the File button on the Insert tab adds content to the current page as a(n)
icon linked to the source file.
When a gold star tag is next to note text, it means that the item was flagged as
important
You have a slide with a title placeholder and a large chart taking up most of the space below the title. You want to add a brief sentence below the chart that describes the source for the data that has been graphed. How will you add the text below the chart?
in a text box
You can browse and preview available templates on the Word Start screen or
in the New backstage area
You want to insert a registered trademark(®) character in a document. Where will you look for the special character?
in the Symbol gallery
Where on the desktop will you find the Speaker icon to adjust the volume on your PC?
in the notification area at the right end of the taskbar
A chart can be created on a slide by clicking the Chart button on the ribbon or by clicking the Insert Chart icon
in the slide's content placeholder.
Where do you type the data to be graphed in a chart on a slide?
in the small worksheet with placeholder data
After tagging an item in the notebook with a To-Do tag, OneNote
inserts a blank check box at the left of the insertion point.
What does the Run button on the Query Tools Design tab do?
instructs Access to produce the query results
In which page orientation does the document have a 9-inch line length with the standard left and right margin setting?
lanscape
Access sorts query results by the _____ column in the query design grid with Ascending or Descending in the Sort box.
leftmost
In a cell reference, a _____ identifies the column and a _____ identifies the row.
letter, number
The default settings in Word for new documents create a _____ page in _____ orientation with _____ inch margins at the left, right, top, and bottom.
letter-sized; portrait; one-
Which type of chart helps a reader identify trends, growth spurts, dips, or unusual points in a data series?
line
Which type of chart would be best suited to illustrate an unusual growth spurt in a data series?
line chart
Which of the following is not likely to be presented to an audience using a PowerPoint presentation?
list of customers for a mailing
When you type an entry in the search text box, OneNote
lists pages with matches in a search results list.
You need to step away from your desk for a brief period, but you do not want to close the apps and documents you have open. What can you do to protect your work while you are gone?
lock the PC
You need to leave your desk for about ten minutes while you escort a guest to the Human Resources office. What should you do on your PC so that your email messages cannot be seen by people who may walk by your desk while you are away?
lock the computer
A statement to evaluate a comparison for Excel to perform one of two actions is called a(n)
logical test.
Each time you click the Decrease Indent button, the paragraph
moves 0.5 inch closer to the left margin.
A slide contains text and
multimedia.
When a formula is copied, a dollar symbol in front of a column letter or row number in the source cell means that the address will
not update
Content in a notebook is placed inside a box called a
note container.
Speaker notes refer to text typed in the _____ pane.
notes
What is the name of the area on the taskbar where the date and time are displayed?
notification area
In the current document you want to type 10 steps that are a sequence of actions. You want the list of steps to be set apart from the text above and below. Which feature will you use to type a sequential list?
numbering
Where are the tabs to navigate between worksheets located?
on the Sheet tab bar
When you have multiple Office applications open at the same time, a button for each application will display
on the taskbar.
Generally, a form displays
one record at a time, in a columnar layout.
A _____ relationship means that two tables are joined on the primary key in each table.
one-to-one
Within a section of a OneNote notebook, you add a _____ to place content in the notebook.
page
After choosing a section, click the Page button in the ______ to add a new page.
page pane
After selecting and copying a file, navigate to the destination device and folder and then click the _____ button to complete the copying process.
paste
Which of the following is not a function of the operating system (OS) software?
perform a spelling and grammar check in text documents
Screen resolution refers to the number of horizontal and vertical
pixels
When you have added sound to a slide, a sound icon and _____ appear on the slide.
playback tools
Add a new worksheet by clicking the New sheet button, which displays as a(n)
plus symbol inside a circle
A mouse, trackball, and touchpad are all examples of a(n)
pointing device
A(n) _____ is a field that contains the data that uniquely identifies each record in a table.
primary key
StudentID is an example of a field that is often a(n)
primary key
Choose the device to print the current document in the _____ section of the Print backstage area.
printer
When you are finished building a query, which object shows you the query results?
query results datasheet
File Explorer opens by default in a view called _____ in Windows 10.
quick acess
A predefined and formatted table with sample data that you replace with your own text is a
quick table
A rectangular-shaped group of cells is called a(n)
range
Change to Slide Sorter view to
rearrange the order of the slides.
All of the data about one person, place, event, or item is called a
record
To select a record for deletion, click in the _____ next to the record to be removed from the table.
record selector bar
Typing April 3, 2021 in a date field in a query is converted by Access into which entry?
record selector bar
Files and folders deleted from a hard disk drive are moved to the
recycle bin
In a formula in which both addresses are _____, the column letter and row number in each reference will update when the formula is copied to a new location.
relative
Which of the following features can automatically change all occurrences of a word or phrase with another word or phrase?
replace
You want to change all occurrences of James Smith to Peter Jones in the current document. Which feature will you use to do this automatically?
replace
Some people use OneNote as a ______ to collect all the data about a subject in one place.
repository
The Show Formulas button switches the display back and forth between showing the formulas in cells and showing _____ in cells.
results
Which of the following methods is not used to switch from one open application window to another?
right-click the desktop and click Switch to
In the Results group on the Query Tools Design tab, click the _____ button to view the query results.
run
What is the name of the screen element in an Office application with arrow buttons at the top and bottom or left and right, that let you move the viewing area displayed in the current document?
scroll bar
The first step to creating a pie chart is to
select the data you want Excel to represent in the chart.
What is the first step to sort worksheet data by more than one column?
select the range
Begin resizing an inserted photograph by dragging a
selection handle
The active placeholder displays with a border and
selection handles
You are setting up a presentation to be used at a trade show where the slide show will run continuously for people to watch as they walk by the booth. What is the term used to describe the delivery method for this type of presentation?
self-running presentation
Adding color behind text to make it stand out from the rest of the document is referred to as
shading
Adding color behind text is called
shading.
Which term describes a collection of slides?
slide deck
Which term refers to the arrangement of placeholders on a slide?
slide layout
The best way to change the font color for all slide titles is to make the color change on the
slide master
When you create a new chart on a slide, you type the chart's source data in a
small worksheet with placeholder data.
A colored horizontal or vertical dashed line that appears when you move or resize a placeholder to help you align and space close objects evenly is called a
smart guide.
Which feature is used to move an image on a slide and align it with the top of a bulleted list?
smart guides
What is the name of the feature that lets you dock a window to one side of the screen?
snap
Clicking the left part of the Bullets button indents and inserts a _____ bullet.
soild round
A citation is used to tell the reader the _____ of material quoted or paraphrased in the document.
source
Which of the following is the term for a miniature chart embedded in a cell?
sparkline chart
In PowerPoint, notes are generally referred to as _____ notes.
speaker
A program in which the data is organized in a grid of columns and rows is referred to as a(n) _____ application.
spreadsheet
A field name used in a formula to calculate a field in a query is enclosed within
square brackets [ ].
A set of predefined formatting options that can be applied in one step is called a
style
What type of resource helps you format an essay?
style guide
A folder created inside another folder is sometimes called a
subfolder
A title slide has a placeholder for a title and a(n)
subtitle.
A _____ is used to organize and present data in columns and rows.
table
Which Access object is the building block for all other objects and must be created first?
table
In which Access object is data stored?
tables
A One Note notebook is organized into sections, which are accessed by
tabs in the Section page.
A One Note notebook is organized into sections, which are accessed by
tabsin the Section page
A _____ is a category assigned to a note that allows you to identify the note later.
tag
Clicking a dialog box launcher on the ribbon causes a dialog box or a _____ to appear.
task pane
A _____ is a document that has been created with formatting options already applied.
template
A change made to a document after the document has been typed is referred to as
template
Which of the following refers to a Word document that is already set up with text or formatting options?
template
Which of the following is not considered multimedia added to a slide to engage an audience?
text
Type text inside a rectangular-shaped box in a document by clicking the _____ button.
text box
A rectangular box containing text that can be moved independently on a slide is called a(n)
text box.
The Convert to SmartArt button converts existing _____ to a SmartArt graphic
text in a bulleted list
During a slide show, a video can play on a slide that is stored at YouTube, at another online source, or on
the PC on which the slide show is running.
Type text to be inserted in a SmartArt object directly within a shape or within
the Text pane
What is displayed on the screen when you click to exit at the end of a slideshow?
the presentation, in Normal view
What does the value you enter for Pv when calculating a loan payment represent?
the principal (amount to be borrowed)
The Loop until Stopped option means that an audio file will play continuously until
the slide is advanced during the slide show.
You have a presentation with 25 slides in the slide deck. You decide to change the font for all the titles. Which slide should you display first before changing the font?
the slide master
When you turn the power on to your PC, the OS displays _____ when the computer is ready for you to begin a task.
the user interface
Every _____ includes a color scheme and a font scheme that affect style options.
theme
The formatting that is applied to text by a style is dependent on the active
theme
A variant is a different style or color scheme within the same
theme family.
Pointing to an application button on the taskbar causes a(n) _____ to appear above the button with a preview of open file(s).
thumbnail
A _____ is a square or rectangle on the Start menu that is used to launch an app or application.
tile
Changing to another desktop color option in Windows changes the color for _____ and window accents.
tiles
Click the Start button and then click _____ to change the picture that appears on the Lock screen.
tiles
The first slide in a new presentation is a
title slide.
Which of the following is not one of the reasons why you might want to copy files from your PC to OneDrive?
to take advantage of the extra features of Microsoft's web-based application
Buttons that operate as either on or off are called _____ buttons.
toggle
A special effect that occurs when one slide is removed from the screen and the next slide appears is called a(n)
transition
A(n) _____ is a special effect that appears as one slide is removed from the screen and the next slide appears.
transition
A font includes the design and shape of characters of a specific
typeface.
Add text inside a SmartArt shape by typing in the Text pane or by
typing in the text placeholder within the shape.
When a new row or column is inserted, cell references in formulas that are affected by the change are automatically
updated
A different color scheme and style within the same theme is called a(n)
variant.
Column charts display each data point in a colored bar, with the height of the bar representing the data point's value on which axis?
vertical axis
How does someone know a notebook has been shared with him or her?
via email message
How is a person notified when a notebook has been shared with him or her?
via email message
Which of the following is not an Access object?
wizard
The Word feature that moves text to a new line automatically when you reach the end of the current line is called
wordwrap
A file that you save in Excel is called a(n)
workbook
A file saved in Excel that contains a collection of worksheets is called a(n)
workbook.
A primary key is a field that contains the data that uniquely identifies each record in a table.
workbook.
In Excel, the structure in which you enter and edit data is called a
worksheet
What is another name for the category axis in a column chart?
x-axis
How can you tell if an option is already added to the Quick Access Toolbar in the Customize Quick Access Toolbar drop-down list?
It displays with a check mark.
Which option do you choose after opening the Settings app to change the Lock screen image?
Personalization
The process of signing out of your PC is also referred to as
logging off
A switch to turn on or turn off a notification is located in the _____ app
settings
To select multiple files to copy that are adjacent in the current list, hold down the _____ key while clicking each file name.
shift
Which action in Windows 10 ensures that all Windows files are properly closed?
shut down the computer
You can use any of the following methods to start an Office 2019 application except
type the application name in the Settings app window.
Which option do you click from the desktop shortcut menu to change the screen resolution setting?
Display settings
Which of the following is not a size option for a tile on the Start menu?
Extra Wide
Which of the following buttons would be considered a toggle button, operating as "on" or "off"?
Format Painter
Copy formatting options using the
Format Painter button
When you start your PC from a no-power state, the _____ appears after a few seconds.
Lock screen
A tile can be added to the Start menu by right-clicking the application name in the application list and then choosing _____ on the shortcut menu.
Pin to Start
Files and folders deleted from the local hard disk of your computer are moved to the
Recycle Bin.
Which command would you use to save a copy of a file in the same folder but with a different file name?
Save as
The _____ command is used to save a copy of a document in another location or to save a copy of a document in the same location but with a different name.
SaveAs
Which option would you choose in the Tell Me drop-down list to view in a task pane web resources related to the term?
Smart Lookup
What is the name of the feature at work when a window is snapped to one side of the screen, leaving the other half empty?
Snap Assist
A document or image stored in electronic format is called a(n)
file
Which term describes a document, spreadsheet, presentation, or photo saved in a digital format?
file
What is the name given to a placeholder or container in which a group of related files is stored?
folder
You have a new USB and want to set up an organizational structure for storing documents. You would begin by creating
folders
The Airplane mode tile located in the Network & Internet settings section at the bottom of the Network panel is an example of a(n) _____ tile.
quick action
What is the term for the circles that display around a selected object?
selection handles