Terms in this set (227)
You can switch to Details view or Large icons view in File Explorer by using the view buttons on the status bar.
When you move a folder, you also move all of the files contained in the folder.
When you delete a folder or file from the hard disk, it is permanently deleted immediately, and unrecoverable.
You organize files by storing them in ____.
A(n) ____ is an example of a fixed file storage system, permanently housed in a computer.
The hard disk is assigned to drive ____.
The left pane of the File Explorer window is the ____ pane.
A file ____ shows the location of a file or folder.
File Explorer displays the current file path in the ____ so you can keep track of your current location as you navigate
The default view of all folders except those in the Pictures Library is ____.
An example of sorting in ascending order is ____.
A to Z
You can sort files ____.
no matter which view you use
A file ____ includes the three or four characters that follow the dot in the filename and identify the file's type.
____ is not a valid file name.
When you save a new file, you use the ____ dialog box to provide a filename and select a location for the file.
When you edit a file you saved previously, you can use the application's ____ command to save your changes, keeping the same file name and location.
____ a file places a duplicate version of the file in a new location that you specify.
The ____ is a temporary Windows 10 storage area for files and information that you copy or move from one location to place in another.
In most cases, a file deleted from a USB drive ____.
is deleted permanently
Windows 10 stores compressed files in a special type of folder called a(n) ____.
As you type the body of a letter, Word automatically moves the insertion point to a new line when the current line is full.
Portrait orientation is the default page orientation for Word documents.
The _______ displays the name of the open file and the program.
In _______ Mode, extra space around the buttons on the ribbon allows your finger to tap the specific button you need.
Changing the _______ affects only the way the document is displayed on the screen.
The main difference among different types of business letters is _______.
how parts of the letter are indented from the left margin
To accept an AutoComplete suggestion, press the _______ key.
_______ is a Word feature that automatically inserts the dates and other regularly used items.
The letters you type appear at the current location of the _______.
Which keystroke(s) should you use to move the insertion point to the end of the line you are currently on?
To move the insertion point left or right one character at a time, you would press _______.
the left or right arrow key
To correct an error marked by either the spelling or grammar checker, you can right-click the error, and then select the correct replacement on the _______ menu.
A wavy _______ line appears if you type a word that is not in the dictionary at all.
Line spacing is the amount of space that appears between lines of text within a _______.
If you press the Shift+Enter keys at the end of a line, this inserts a _______ line break.
A method for selecting multiple lines of text is to _______.
click and drag in the white space to the left of the lines
By default Word documents include _______ margins on all sides of the document.
To be sure the document is ready to print, and to avoid wasting paper and time, you should first review it in _______ view.
Preformatted files in Word (e.g., fax cover sheets, memos) are known as _______.
You can click the Clear All Formatting button to restore selected text to the _______ font, font size, and color.
A _______ is a set of characters that uses the same typeface.
To select the entire document, press _______.
_______ is background color that you can apply to one or more paragraphs and can be used in conjunction with a border for a more defined effect.
To copy formatting from the selected text to other text in the document, use the _______ button.
A(n) _______ tab appears on the ribbon only when an object is selected.
You can copy selected text by pressing Ctrl + C.
Heading 1 is the highest level used for the major headings in a document and applies the most noticeable formatting.
Word inserts page number fields above the top margin, in the blank area known as the header or below the bottom margin, in the area known as the footer.
The shaded space between the first and second pages of a document indicates a ____ break.
Which of the following is NOT a way to move text in Word?
cut and copy
When Word copies text to another location, the item remains in its ____ location.
You typed a paragraph on page 2 that should appear on page 27. To move that paragraph to the correct place in your document, you should use ____.
cut and paste
To ____ means to insert a copy of whatever is on the Clipboard into the document.
To cut selected text, you can use the keyboard command ____.
If you press the ____ keys, the insertion point moves to the beginning of the document.
A ____ is a coordinated collection of fonts, colors, and other visual effects designed to give a document a cohesive, polished look.
In the world of academics, style guides emphasize the proper way to create ____.
With a ____ indent, all lines except the first line of the paragraph are indented from the left margin.
Although a citation looks like ordinary text, it is actually contained inside a ____, a special feature used to display information that is inserted automatically, and that may need to be updated later.
The term superscript means that the number is raised slightly above the line of text.
A SmartArt graphic contains placeholder text that you replace with your own text.
From the Navigation pane, you can ____ a subordinate heading to the next level up in the heading hierarchy.
In Microsoft Word, pressing the ____ key(s) will move the insertion point to the end of the document.
When you press the Tab key in the last cell in the table, ____.
you add a new row to the bottom of the table
To move the insertion point to the next cell to the right in a table, you can ____.
press the Tab key
To sort a table so that all names in its Last Name column appear in alphabetical order (A to Z), sort in ____ order.
If you position the mouse pointer over the border of a column and double-click it, ____.
the column will adjust to accommodate the widest entry in the column
Styles for formatting rows or columns in alternating colors are referred to as ____ rows or columns.
A(n) ____ is a location on the horizontal ruler where the insertion point moves when you press the Tab key.
Which of the following is not a major tab stop?
To clear a tab stop, ____.
drag it off the ruler
To organize large amounts of information, it is best to use ____.
To format part of a document in an orientation different from the rest of the document, you need to ____.
divide the document into sections
If the ____ button is selected in the Navigation group for the section 2 header, anything you add to that header will update in the section 1 header.
Link to Previous
Cover Page styles in the Cover Page gallery match the preformatted ____ styles in Word, making it easier to create a coherent style by choosing matching names.
A _____ is an explanatory comment or reference that appears at the bottom of a page.
To ensure a smoother right margin, you can turn on _____.
Desktop publishing is the process of preparing commercial-quality printed material
If you want the columns in a document to appear balanced on a page, you can insert a column section break at the end of the document.
Pictures and text boxes are separate from the document text; you need to adjust the way text flows, or _______, around them.
WordArt is considered a(n) _______ that can be manipulated independently of the text.
If you type :), then the symbol or character inserted will be _______.
Which of the text wrapping settings flows around the exact outline of an object?
To change an inline object to a floating object, you need to _______.
apply a text wrapping style to it
A special design element, called _______, draws the reader's attention to the beginning of an article.
a drop cap
To cut off part of the graphic in an illustration, you would _______ the illustration
_______ files are suitable for most types of simple line art, without complicated colors.
The _______ file format is similar to GIF files, but suitable for art containing a wider array of colors.
Emily has used this file format many times, as it is suitable for photographs, and highly compressed, which makes it a good idea when file storage is at a premium. What is this format?
The formula bar displays the value or formula of the active cell.
The sheets in a workbook are identified in the sheet tabs at the top of the workbook window
The AutoComplete feature automatically completes an entry based on previous entries in a column
The advantage of an electronic ____ is that the content can be easily edited and updated to reflect changing financial conditions.
"AZ" is an example of a ____
To make A1 the active cell, you should press which of the following keys?
Ctrl + Home
Each range is identified with a range reference that includes the cell reference of the upper-left cell of the rectangular block and the cell reference of the lower-right cell separated by a ____.
The characters +, -, *, and / are examples of ____.
An Excel formula always begins with a(n) ____.
The formula used to multiply cell A1 by cell C1 is ____.
What is the result of the expression =50+20/10*5?
To change the order of operations, enclose part of the formula in ____.
Excel makes reading formulas simpler by ____ each cell reference in the formula and its corresponding cell in the worksheet.
To switch to ____ mode, you double-click the cell.
____ enters text based on patterns it finds in the data.
You can ____ the width or the height of the printout so that all of the columns or all of the rows fit on a single page.
What is the syntax for a SUM formula adding the values of cell F6 to F9?
Whenever you click the Save button on the Quick Access Toolbar or press the ____ keys, the workbook file is updated to reflect the latest content.
Ctrl + S
Formatting changes only the appearance of data—it does not affect the data itself.
Changing the number of decimal places displayed in a cell does not change the value stored in the cell.
Page Break Preview identifies manual page breaks with a dotted blue line and automatic page breaks with a solid blue line.
By default, numbers appear in the _____ and generally display values exactly as you type them.
Because Excel stores dates and times as _____, you can apply different formats without affecting the date and time value.
In Excel, dates are _____-aligned in the cell by default, regardless of date format.
As a general rule, you should _____.
center column titles, left-align text, and right-align numbers
In the Format Cells dialog box, the _____ tab allows you to format currency by choosing decimal places, comma separators, and regular number displays.
When using the Format Painter, double-click the Format Painter button to paste the same format multiple times and click the Format Painter again to _____.
turn it off
_____ are an example of conditional formats in Excel.
One way to ensure that you are using consistent formats is to copy and paste your formats using the Format _____.
Fonts, colors, and cell styles are organized in _____ categories.
theme and non-theme
Setting the _____ to A1:L10 will print only data in those cells.
To avoid splitting a worksheet in awkward places, you can insert a _____ to specify a specific breaking point.
manual page break
Information that prints on each page, like a company name or logo, may be set as a _____.
The header and footer sections include a _____.
left, right, and center section
Header and footer elements such as worksheet name, current date, and time are _____ elements.
The Format Cells dialog box tab that provides options for locking or hiding cells to prevent other users from modifying their contents is _____.
The ____ category of Excel functions returns (true-false) values.
=ROUND(AVERAGE(A1:A100),2) is an example of a(n) ____ function.
The numbers, text, or cell references used by the function to return a value are called ____.
Which of the following is not a comparison operator?
In the following formula: =IF(A1="YES", "DONE", "RESTART"), what happens if A1= "NO"?
The formula returns the text "RESTART".
The ____ function returns the maximum value in the range.
One of the great advantages of ____ references is that you can quickly generate row and column totals without having to worry about revising the formulas as you copy them to new locations.
Absolute references are marked with a ____.
When you copy a formula that contains an absolute reference to a new location, the reference ____.
does not change
Another name for the middle value is the ____ value.
FUNCTION(argument1, argument2, ...) is ____.
the general syntax of all functions
If an optional argument is not included, Excel assumes a(n) ____ value for it.
Which function counts how many cells in a range contain numbers, where value1, value2, and so forth are text, numbers, or cell references?
Using the AutoFill Options button, the Fill Without Formatting option copies the ____ but not the formatting.
Using AutoFill, what would be the extended series of the initial entry Jan?
Feb, Mar, Apr
In the formula =IF(A1=B1, C1, C2), the result will be C2 if ____.
A does not equal B
____ references are seldom used other than when creating tables of calculated values such as a multiplication table in which the values of the formula or function can be found in the initial rows and columns of the table.
______ functions find values in tables of data and insert them in another location in the worksheet such as cells or in formulas.
One way to perform a _________ is by changing one or more of the input values to see how they affect the calculated results.
Case 3-2Susan is in charge of the inventory reports for her company. She will need to find specific inventory items as well as project increases in inventory costs. To get ready she will create a worksheet and use the Microsoft Excel 2016 Analysis tools. Susan wants to automate the trial-and-error process by allowing her to specify a value for a calculated item, which Excel uses to determine the input value needed to reach that goal. She can use ______.
Every chart contains elements that can be formatted, added to the chart, or removed from the chart.
A column chart turned on its side is called a bar chart, with the length of the bar determined by the data value.
The PMT function calculates the payment required in each period to pay back the loan.
Sparklines differ from data bars in that the sparklines are always placed in the cells containing the value they represent.
Line charts are best suited for representing data that follows some nonsequential order.
A ________ contains the actual values that are plotted on the chart.
Category values are usually located in the ____ of the data source.
either a or b
The ____ is the only one of the following charts to compare relative values from different categories to the whole.
Placing a chart in a ____ displays only the chart and no worksheet cells.
____provide descriptive text for the individual data markers, such as pie slices
A pie slice is a data marker that represents ____ from a data series.
only one value
To move one slice of a pie chart away from the pie creates a(n) ____.
exploded pie chart
The range of values or _______, of an axis is based on the values in the data source.
When combination charts have data series with vastly different values, you can create ____ charts.
The ____ identifies which data markers are associated with each data series.
The _______ displays the data series in separate columns side-by-side so that you can compare the relative heights of the columns in the three series.
clustered column chart
A database or a relational database is a collection of related tables.
A software program that lets the user create databases and then manipulate the data in the databases is called a database management system (DBMS).
Each row in an Access table datasheet displays which of the following?
Each column in an Access table datasheet represents a ____.
Which term identifies a field that appears in two separate tables and may be used to connect records in the separate tables?
What is the purpose of the primary key?
to uniquely identify each record in a table
Data organized as a collection of tables creates this type of data system.
relational database management system
Which Access database object(s) might be used to enter, edit, and view records in a database?
Which Access database object asks a question about the data stored in a database and displays specific fields and records that answer the question?
What function does compacting an Access database perform other than reducing the file size?
repairing the database
Which of the following is the file extension used for Access 2016 database files?
Which data type allows field values to contain letters, digits, and other characters?
Data redundancy should be avoided because it wastes storage space and might cause inconsistencies within the database.
In order to define table relationships, each table being joined must contain a common field
Access does not allow data to be imported from sources other than another Access database.
The ____ property allows the database designer to explain the purpose of a field or how a field is used.
A field used to connect one table logically with another table is called a ____ field.
A database system determines how to store, display, and process field values based on which of the following?
Which data type would be the best logical data type for a field named PaidDate?
The default character length for the Short Text data type is ____ characters.
A custom date format set for a Date/Time field that contains the symbols mmm/dd/yy would display the date as ____.
Which data type would be most logical to use for a field named BillPaid to indicate if an invoice has been paid?
Changing the order of fields in a database table is an example of changing a table's ____.
Which of the following would be a likely reason that an Import process from an Excel spreadsheet to an Access database might fail?
the Access field names and the Excel worksheet column headings do not match
By choosing the Definition Only option in the Import Objects dialog box, the ____ of a table is imported, but not the ____.
A value set in the Field Properties pane that appears in a field automatically is the ____ for the field.
It is important that data being imported from a text file into Access are separated by a character, such as a comma, which defines the text file as a(n) ____ text file.
A relationship between Access tables that is a relationship between one record in the first table and zero, one, or many records in the second table, and at least one record in the second table matches at most one record in the first table, is defined as a ____ relationship.
Logical operators must be used in order to combine two or more conditions in a query.
Results of a query are narrowed by using the Or logical operator
The query type that gives Access an example of the information being requested and retrieves information based precisely on matching the example is which type of query?
query by example (QBE)
The process of adding, modifying and deleting records in a database to keep the records current and accurate is referred to as ____ a database.
Which view must be used to delete an entire record?
Queries based on more than one table, must have a ____ field.
A field with the Short Text data type sorted in descending order will display the data in which order?
Z to A
A criterion, or rule, that determines which records are selected when a query is run is called a(n) ____.
The comparison operator, < >, is used to insert a condition that means ____.
not equal to
In the criterion, <=250, the operator will return values for the specified field that are ____.
less than or equal to 250
The condition "Seattle" for the field City in a student database is an example of what type of value?
Date criteria are automatically enclosed in ____ when entered in a query design.
The + symbol is an example of a(n) ____ operator.
A calculated field created in a query generates results when ____.
when the query is run
Which aggregate function would be used to calculate the lowest field value for the selected records?
Statistical information such as totals and averages is calculated using ____.
The 7 x 7 rule means you should include no more than seven words per slide
When PowerPoint starts, it displays a blank presentation in ____ view.
The ____ is the first slide in a PowerPoint presentation.
A commonly used layout is the ____ layout.
Title and Content
If photos need to be emailed or uploaded to a Web page, choose the ____ ppi compression setting.
____ handles are the small circles that appear in the corners and in the middle of the sides of the border of a selected object.
____ notes are information you add about slide content to help you remember to bring up specific points during the presentation.
During your presentation, you can easily display a blank black slide by pressing the ____ key(s).
____ view displays the slides so that they almost fill the screen, and a status bar appears identifying the number of the current slide and providing buttons to advance the slide show.
When you print ____, the presentation is printed with one or more slides on each piece of paper.
In PowerPoint terms, shapes include lines, rectangles, stars, and more.
The default transition is for one slide to disappear and the next slide to immediately appear on the screen.
Drag the ____ adjustment handle on a shape to change its proportions without changing the size of the shape.
Like shapes, you can rotate or ____ pictures using the Rotate handle or the Rotate button.
Use the Animation ____ to copy the animation, effects, and duration applied to one object to another object.
If you animate a list, the default is for the first-level items to appear ____.
one at a time
After you insert a video, you can modify it by changing ____ options, changing the length of time the video plays, and applying formats and styles to the video.
If you see a black square when you insert a video, you can override this by setting a ____ frame.
If a video is too long, or if there are parts you don't want to show during the slide show, you can ____ it.
When you choose the ____ compression level for videos the file will be compressed as small as possible.
Usually the date and slide number do not need to appear on the ____.
In common usage, a(n) ____ is any text that appears at the bottom of every page in a document or every slide in a presentation.