Semester 2 Study Guide-Foundations of Tech Class
Put your email address in the box below, answer the questions and hit the submit button at the bottom when you are finished.
Sign in to Google to save your progress. Learn more
Email *
1. A common sort is alphabetically by last name. *
1 point
A documentation worksheet describes or annotates the workbook. *
1 point
To insert a new worksheet, click the button to the right of the existing sheet tabs. *
1 point
Using the Spelling check feature allows the user to locate a particular piece of data in a spreadsheet and change it as needed. *
1 point
Excel allows you to add Print Titles as a printing option. *
1 point
All applications within Microsoft Office use Find and Replace and Spelling check in a similar manner. *
1 point
A chart is a range of data created from the data in a spreadsheet. *
1 point
Sheet tabs display at the top of the Excel window. *
1 point
Filtering allows the user to arrange the data rows in the order that displays the data for better analysis. *
1 point
The Convert to Range button is found on the DESIGN tab in the Table Tools. *
1 point
You can freeze a portion of a spreadsheet so that it does not scroll with the rest of the spreadsheet. *
1 point
Once you delete a worksheet, the data is lost forever. *
1 point
Converting a data table back to a range allows you to use the full power of Microsoft Excel. *
1 point
Sorting allows an Excel user to select only those data records specifically needed. *
1 point
A spreadsheet with misspellings can call into question a person's skills. *
1 point
In an Excel workbook with multiple worksheets, worksheets may be grouped to simplify formatting and printing. *
1 point
Double-click in a paragraph to select the entire paragraph. *
1 point
Hiding worksheets is a technique to protect sensitive or classified data. *
1 point
Documentation information is usually added on a separate worksheet in the workbook. *
1 point
One way to combine data from multiple worksheets is to use absolute references. *
1 point
The page break options are found on teh PAGE LAYOUT tab. *
1 point
You can split the worksheet into ________panes. *
1 point
You can split the worksheet into two ______. *
1 point
The Freeze Panes drop-down menu is found on the ______ tab. *
1 point
If you select row 4 and choose Freeze Panes, which rows will be frozen? *
1 point
To preview a page break, click the VIEW tab, and then click the _____ button. *
1 point
To print column titles on each page, click the PAGE LAYOUT tab, click the _____ button, and then enter the letter of the column that contains the title. *
1 point
You can adjust the position of a page break by ________. *
1 point
Moving the ______ allows you to print more or less of the spreadsheet on each page. *
1 point
To remove a page break, select the Page Break location, click the _____ button and then Remove Page Break. *
1 point
Using the ____ feature allows the user to locate a particular piece of data in a spreadsheet and change it as needed. *
1 point
When using the Find and Replace feature, one of you choices is to  _______. *
1 point
The Spelling button is found in the ______ group on the REVIEW tab. *
1 point
The Editing group is found on the  ______ tab. *
1 point
Clicking the Find & Select button and then clicking Find opens the _______ dialog box. *
1 point
A ________ is a range of data created from the data in a spreadsheet. *
1 point
You can _____ data in a table separately from other data in the worksheet. *
1 point
You can create a table using the ______. *
1 point
To format a table, click the HOME tab and then click the ______ button. *
1 point
Sorting in ascending order means to sort from ______. *
1 point
By applying a(n) ______, you can set your data  to only display people who reside in a specific zip code. *
1 point
To add additional sort levels, click the ______ button in the Sort dialog box. *
1 point
To remove a filter, click the column filter arrow then click _____ (column name). *
1 point
To change a data table back to a range, you use the _____ button. *
1 point
You can rename sheets in Excel by _____ on the sheet tab, clicking Rename, and typing the new name. *
1 point
To format sheet tabs, click the sheet tab, and then click the Format button in the _____ group on the HOME tab. *
1 point
To hide a worksheet, click the sheet tab, click the Format button in the Cells group, click _______, and then click Hide Sheet. *
1 point
To unhide a worksheet, click the Format button in the Cells group, click Hide & Unhide, click _______, and then click OK. *
1 point
To delete a sheet tab, _______ the sheet tab and click Delete. *
1 point
Once you delete a sheet tab, ________. *
1 point
To insert a new worksheet, _____ the existing sheet tabs. *
1 point
The first step in creating a summary sheet is to  ______. *
1 point
Creating summary pages with named cell ranges or ________ makes data analysis easier. *
1 point
When creating a summary worksheet, click in the cell where the total will appear and begin by typing _______. *
1 point
When creating a summary sheet using range names, you _______ of the ranges you want to include, separated by commas. *
1 point
When creating a summary sheet using 3-D Reference Formulas, you click the first sheet tab to include and then _____ and select the final sheet tab. *
1 point
You can create ______ in a large workbook to permit users to see what the workbook's purpose is. *
1 point
The documentation page is often _____. *
1 point
The documentation sheet needs to be named _____ so that users can see what the workbook's purpose is and how to use it. *
1 point
Information that might be found on a documentation sheet would be ______. *
1 point
In addition to seeing what a workbook's purpose is, you can create documentation pages in a large workbook to permit users to see ______ workbook. *
1 point
You can use the ______ operation to easily format multi-sheet workbooks. *
1 point
When grouping worksheets, use _____ to select contiguous worksheets. *
1 point
When grouping worksheets, use _____ to select noncontiguous worksheets. *
1 point
You can use the Group operation to easily _____ multi-sheet workbooks. *
1 point
To unfreeze rows that have been frozen, click the VIEW tab, click the Freeze Panes drop-down menu, and click _______. *
1 point
When you type a word in the Find What text box and then click Find Next, what happens? *
1 point
Before column header filter arrows will appear, you need to toggle on the ______ button. *
1 point
How do you navigate from one sheet to another in a workbook? *
1 point
To ungroup worksheets, _____. *
1 point
Once a database is opened, the Effects pane appears along the right-hand border of the application window. *
1 point
Access 2013 database files have the file extension .accbd. *
1 point
The navigation pane provides a categorical listing of the objects contained in the database. *
1 point
The intersection of a row and column in a database is called a record. *
1 point
When you adjust a single row's height in the Record Selection area, only that row is adjusted. *
1 point
A table object stores data in a series of rows and columns called a datasheet. *
1 point
Sorting is often your first step in extracting information from raw data. *
1 point
Constructing a table in Design view affords the greatest power and flexibility in designing and modifying table objects. *
1 point
The table Datasheet view allows you to get down to the nuts and bolts of designing and constructing a table. *
1 point
Access allows for entering a null value into a primary key or index field. *
1 point
A database is a static entity. *
1 point
The AutoNumber data type is one of the best choices for a primary key. *
1 point
Removing an existing field deletes the field entry from the Field Grid pane but also deletes all the data stored in the field. *
1 point
Once a database is designed, it is extremely difficult to modify the table's structure. *
1 point
In Print Preview mode, you can move back and forth through the pages. *
1 point
Access provides a special tool called the Previewer that allows you to preview and print various design characteristics of your database objects. *
1 point
There are database objects for _______. *
1 point
What is the database object for storing data? *
1 point
What is the database object for automating your work flow? *
1 point
A _______________ is a question you ask of your database. *
1 point
Unlike a datasheet's column and row layout, a ________ generally displays one record at a time and is used for adding and editing record data. *
1 point
When working in a datasheet window, the commands for manipulating a table are dynamically added to the Ribbon and displayed under the _____ tab. *
1 point
The Datasheet view mode lets you _____ records from a table. *
1 point
Each row in a datasheet represents a(n) ____. *
1 point
Each column in a datasheet represents a(n) _____. *
1 point
The _____ mode lets you display many records at once. *
1 point
You can select records using the mouse in the _______. *
1 point
Any cell containing a(n) _____ field is incremented automatically by Access when a new record is added to the table. *
1 point
A(n) ______ icon appears in the record selection area to signify that you are working in Edit mode. *
1 point
To save your editing changes without leaving the current record, _______. *
1 point
To move to the bottom of the Datasheet window, ________. *
1 point
To select the contents of the Datasheet window, click the ______ button in the top left-hand corner of the Datasheet window. *
1 point
To adjust the height of rows in a datasheet, drag the _____ to increase or decrease the height of the rows. *
1 point
To adjust the height of rows using the Ribbon, locate the ____ group on the HOME tab, click the More drop-down menu command, and then choose the Row Height command. *
1 point
Formatting options include ______. *
1 point
A field chosen to sort by is referred to as a ______. *
1 point
Access allows you to rearrange records appearing in a datasheet into ____ (A to A; 9 to 0) by the contents of any field. *
1 point
_______ allows you to organize records and makes it easier to scan a datasheet for specific information. *
1 point
To sort records using the Ribbon, select the field column to sort, and locate the _____ group on the HOME tab. *
1 point
To create a new table in Datasheet view, locate the ___ group on the CREATE tab and then click the Table command. *
1 point
To add a new field in Datasheet view, click the FIELDS tab under TABLE TOOLS and locate the _____ group. *
1 point
To rename a field in Datasheet view, _____ a column title in the field header area and type a new name. *
1 point
When you save a datasheet, the name of the datasheet appears in the Tables group of the ______. *
1 point
______ is a field data type. *
1 point
In the ______ of Design view, enter the desired field names, descriptions, and data types for the new table. *
1 point
What is the field data type for logical or Boolean values that have two states that you will toggle either on or off? *
1 point
What is the field data type for long blocks of plain or formatted alphanumeric data, such as descriptions? *
1 point
What is the field data type for composing a text, numeric, or other type of calculated expression? *
1 point
The _____ field is used by Access in searching for data and in establishing relationships between tables. *
1 point
Access will prevent you from entering a(n) ____into a primary key or index field. *
1 point
What field will uniquely identify each and every record in the table? *
1 point
To assign a primary key to a field in Design view, select the field, click the DESIGN tab under TABLE TOOLS, locate the ______ group, and click the Primary Key command. *
1 point
To define an index in Design view, select the field on which to base the new index, click the DESIGN tab under TABLE TOOLS, locate the ____ group, and click the Indexes command. *
1 point
The ______ data type automatically increments sequentially as each new record is added to a table. *
1 point
By setting the _____ property for a Long Text data type field, you can enter and store formatted text in the field. *
1 point
To remove a field from a table, ____ the Row Selector button for the field in the field grid area and choose Delete Rows. *
1 point
Removing an existing field deletes the field entry from the Field Grid pane _____. *
0 points
A database is a(n) _____ entity. *
1 point
The ____ allows you to preview and print various design characteristics of your database objects, including a table's structure and field properties. *
1 point
To open the Database Documenter dialog box, locate the _____ group in the DATABASE TOOLS tab and click the Database Documenter command. *
1 point
To limit the records that display in a datasheet, enter a filter in the "Criteria" row of the query Design grid. *
1 point
You can base a report on a query instead of a table. *
1 point
You can hide the display of unnecessary fields by removing the checkmark from the check box in the "Show" row of the grid. *
1 point
An expression enables you to draw data from other field columns and perform a mathematical calculation on a row-by-row basis. *
1 point
You can perform simple and complex calculations using calculated fields in queries. *
1 point
The Find command can be used to locate a single record. *
1 point
The type of query object created by the wizard is known as a filter query. *
1 point
Save your table layout changes by clicking the Save button on the _______. *
1 point
Press ______ to move to the last field column. *
1 point
What appears in the Unhide Columns dialog box? *
1 point
_______ in a datasheet is useful for temporarily restricting the display of sensitive data. *
1 point
You can use __________ to help locate words for which you are unsure of the spelling or the form of the word. *
1 point
______________ best suited to locate groups of records matching specific criteria. *
1 point
The ________ command lets you perform a global find and replace operation to update the contents of an entire table. *
1 point
You can use the _____________ as a wildcard character in place of a single number when searching. *
1 point
Use the _____________ as a wildcard character to represent a group of characters when searching. *
1 point
Similar to a pasta strainer that lets water through but not the pasta, a __________ allows only some records to pass through for display. *
1 point
Using the ___________ method, you apply a filter based on a selected value from the datasheet. *
1 point
The Sort & Filter button is attached to the ____________. *
1 point
A ____________ is a tool that limits the display of records in a table using a simple matching criterion. *
1 point
Each ___________ in the datasheet is represented in the Filter By Form window. *
1 point
Once you have defined a filter, Access enables you to save it as a __________ in the Database window. *
1 point
To Filter By Form, select Filter By Form under the ___________ command in the Sort & Filter group on the HOME tab. *
1 point
The ________ allows you to select from the unique entries in each field column from a drop-down list. *
1 point
With the Filter By Form method, you can define criteria using ______. *
1 point
The tabs along the bottom of the Filter By Form window are for _____. *
1 point
Queries allow you to _________. *
1 point
The _______ is a step-by-step tool that helps you retrieve data from one or more tables in a database. *
1 point
The Simple Query Wizard is especially useful when you need to ______. *
1 point
The Queries group is found on the _________tab in the Ribbon. *
1 point
In the Simple Query Wizard, you can select the fields you want displayed in the query from the ______ area. *
1 point
To display data from two or more tables correctly, you must first define the ______ between objects. *
1 point
Click the _______ on the DESIGN tab to run a query. *
1 point
Query objects can be ________ from the Navigation pane. *
1 point
Like other database objects, you can ____ query objects. *
1 point
The Query Design window uses a  graphical ________layout. *
1 point
The Query Design grid lets you _________ and perform calculations. *
1 point
The results of the query are displayed in a ________. *
1 point
When sort options are selected, in the query Design view, the leftmost field column becomes the ______. *
1 point
If you choose not to specify a sort order in the query Design window, the resulting records display in the same order ______. *
1 point
To delete a field column in the query Design grid, select the field column and then click the _____ command on the DESIGN tab. *
1 point
Type _____ to retrieve entries that have missing field values. *
1 point
You can use ____ to limit records between a given range of values or dates. *
1 point
You can use the question mark (?) and asterisk (*) wildcard characters to represent one or more ____ in a conditional expression. *
1 point
Enclosing a date with _____ symbols limits results to specific dates. *
1 point
You can perform simple and complex calculations using ____ in queries. *
1 point
To create a calculated field, enter a(n) _____ into the "Field" row of the query Design grid. *
1 point
To execute a query, click the _____ in the Results group on the DESIGN tab. *
1 point
Expressions may contain table and field names, comparison operators, logical operators, and ______. *
1 point
In addition to select queries, Access provides ______ queries. *
1 point
The fields available in the Form Wizard are based on ______. *
1 point
To enter a new record in a table, click the ____ button. *
1 point
Click the _____ button to display the Form Wizard dialog box. *
1 point
When using the Form Wizard to pick the layout of your form, you can ____ to see a preview of the formats. *
1 point
Your goal, when making Form control modifications, is to make the form, _____. *
1 point
Forms generally use the ____ format. *
1 point
To select multiple Control labels, select the first one and then ____ the rest of the Control labels to include. *
1 point
To resize text boxes to an efficient size for data entry, select all the labels, right-click, and choose _______. *
1 point
To modify, align, and size Form controls, you need to be ______. *
1 point
To align multiple controls, select them and then click the Align button on the _____ tab. *
1 point
To print a report, go to _____ view and click Print. *
1 point
In the Report Wizard, select the fields to include by moving them from the Available Fields pane to the ______ pane. *
1 point
An advantage of using the Report Wizard is that you can _____. *
1 point
With the appropriate table selected in the Navigation pane, to create a report, click the ____ tab, and then click the Report button. *
1 point
To resize a control, click the control and use the _____ to resize the control. *
1 point
To move a control, click the control and use the _____ to move the control to the desired location. *
1 point
To align and size Report controls, view the report in ______. *
1 point
Changing the appearance of a report can _____. *
1 point
To change the Report view, ____ the report tab and click the desired view. *
1 point
Selecting the Labels button opens _____. *
1 point
In a report, you resize the fields in the _____. *
1 point
Label types that you can choose from include _____. *
1 point
The Label Wizard allows you to control text appearance by giving tools to adjust the _____. *
1 point
To select multiple placeholder fields in a mailing label report, click each placeholder field while pressing the _____ key(s). *
1 point
When you complete the mailing labels report, it appears in _______. *
1 point
You can adjust ______ of a control in a mailing label report. *
1 point
To format and customize mailing labels, begin, begin by switching to _____. *
1 point
When editing a mailing label report, you can change the font formatting using the Font group on the ____ tab. *
1 point
Database objects include _______________. *
1 point
To rename a database object, ______ the database object in the Navigation pane, click Rename, and type the new name. *
1 point
To delete a database object, right-click the database object in the Navigation pane, click _____, and then click Yes. *
1 point
To copy a database object, right-click the database object in the Navigation pane, click Copy, click anywhere in the _____, click Paste. *
1 point
When you choose to past a copied database object, what dialog box appears? *
1 point
When you click Compact & Repair Database, what will you see? *
1 point
Compacting and repairing an Access database helps you rec ognize parts of the database that _____. *
1 point
You can set an option to compact and repair a database automatically _____. *
1 point
After the database compacts and repairs, the ____ closes. *
1 point
The Compact & Repair Database button is found under the ____ tab. *
1 point
____  is a tab on the Property sheet for a form. *
1 point
The ____ tab appears when selecting either the Layout view or the Design view. *
1 point
After you select the fields to use for your mailing label report, you can choose to _____ one or more fields. *
1 point
To remove a control, click the control and _____. *
1 point
____ is a paste option that appears in the dialog box when you copy and paste a database table. *
1 point
To set the database to compact when you close the database, click ____ on the FILE tab, choose Current Database, and select the Compact on Close check box. *
1 point
Slide shows can use a theme that will tie the design and colors of the slides together throughout the slide show. *
1 point
When it enters the Slide Show mode, PowerPoint fills the entire computer screen to show you exactly what the viewers would see. *
1 point
Zoom buttons reside on the right-hand side of the title bar. *
1 point
Most of the elements in a PowerPoint slide are contained inside placeholders. *
1 point
Slide Sort view allows the presenter to view a split screen while the audience views only the current slide. *
1 point
Clicking the mouse is the least preferred way to advance slides. *
1 point
The Format Painter is the placeholder for text. *
1 point
The Outline view is the same as printing an outline of your slide show *
1 point
The Notes page displays the Print Preview pane so you can see ahead of time exactly what your printing will look like. *
1 point
When you insert an image in a slide, dragging the image activates automatic alignment guides. *
1 point
Set a video to Video Shape to provide the best possible view. *
1 point
You cannot control the volume of a video within PowerPoint, so you need to make sure you get a video with good sound quality or no sound. *
1 point
Even without a specific placeholder layout, PowerPoint provides a simple way to insert video through the Media group. *
1 point
You can control the length of a video through Trim Video. *
1 point
The Audio on My PC command uses a similar search model as online video to find audio clips online to match your search request. *
1 point
The addition of music or background ambience increases the sensory experience of the presentation. *
1 point
To insert a theme into a slide show, click the _________ tab and locate the Themes group. *
1 point
To help you in the design of your slides, PowerPoint provides access to ______ that displays the actual size of the page and elements on it. *
1 point
The ____ allows you to see one slide close up so you can make changes on the slide. *
1 point
Shortcut menus are ____ so that the options displayed are related to the area of the screen that your mouse was in when activated. *
1 point
In addition to the common Office tabs, PowerPoint also has the ____ tab that is specific to PowerPoint. *
1 point
When you are running a show, right-clicking displays a menu _____. *
1 point
What view allows you to see the current slide as well as the next slide--without affecting what audience sees through a projector? *
1 point
Pressing what key (or keys) while the slide show is running will pause the show and turn the screen black? *
1 point
When PowerPoint enters _____, it fills the entire computer screen to show you exactly what the viewers would see. *
1 point
To move directly to a specific slide, _____. *
1 point
The ____ in PowerPoint can provide improved alignment. *
1 point
If you leave a text box too large, it _____. *
1 point
If no text is associated with a bullet, the bullet _____. *
1 point
What print range options prints every slide in the presentation? *
1 point
To change the color of selected text, click the HOME tab, click the Font Color drop-down arrow in the Font group, and then select _____. *
1 point
Press the _____ key to begin the show from slide 1. *
1 point
When in normal view, to move to the first slide, press ______. *
1 point
The names of the buttons on the Print page change to reflect the ______. *
1 point
From the Print page of Backstage view, click *
1 point
If you select the _____ printer option, three copies of the slide show would print pages 1, 1, 1, then 2, 2, and then 3, 3, 3. *
1 point
To save files, find print controls, and set PowerPoint options, use the _______. *
1 point
To show or hide notes, click the Notes button in the _____. *
1 point
Moving text up a level in Outline view is called ______. *
1 point
In the Outline view, if you want to type a second line in the title placeholder, press _____ after typing the first line. *
1 point
While the cursor is still in the last bullet, press _____ to promote the bullet one level. *
1 point
To delete a slide while in Outline view, select the slide and press ______. *
1 point
The Outline view also allows you to instantly _____ the view so just the slide titles show. *
1 point
What predesigned slide layout includes two content placeholders, side by side, with separate subtitle placeholders above each of the content placeholders? *
1 point
While the cursor is still in the last bullet. press _______ once to demote (indent) the bullet one level. *
1 point
The Blank slide layout provides _______. *
1 point
_____________ contain shortcuts to most of the images and media you would want to use in a slide show. *
1 point
 The _______ button allows you to choose from any of the slide layouts to provide the layout that suits your needs. *
1 point
To insert an image from your computer, click the _______ button placeholder, locate the file on your computer, and then double-click on the file. *
1 point
When you insert a new slide, PowerPoint inserts the new slide _______. *
1 point
 What special set of commands allows you to format and size an image accurately? *
1 point
Dragging an image activates _______, which are faint dotted lines that aid in moving the image into obvious positions such as the center of the slide or straight across from another image. *
1 point
To see a larger image of an online picture search result, click the _______ button in the bottom right-hand corner of the picture. *
1 point
 Holding the _______ button while clicking on different images allows you to select more than one image for multiple insertions. *
1 point
To align multiple objects in relation to each other, select the objects, locate the Arrange group on the FORMAT tab, and click the _______ button. *
1 point
Under _______, you can set the video to begin with a mouse click or automatically as the slide appears. *
1 point
Set the video to _______ for a smoother, softer start. *
1 point
You can insert _____ to control how one slide changes into the next slide. *
1 point
What is PowerPoint's default file format? Some features may not be available if opened in earlier formats. *
1 point
Each transition has its own _____ that are dependent upon which transition you choose. *
1 point
While SmartArt is easy to add to a slide, it is difficult to add new shapes to existing SmartArt. *
1 point
Tables do not allow specific animations for each component. *
1 point
Charts are static and cannot be animated. *
1 point
The _______ button can flip images either horizontally or vertically to suit the design and the focal point of your slide. *
1 point
Use the _______ button to center images perfectly on the slide both vertically and horizontally. *
1 point
What control forces PowerPoint to automatically adjust the image to maintain the proportion of height to width? *
1 point
The Picture Border button is located in the _______ group. *
1 point
The Chart button is found in the _______ group on the INSERT tab. *
1 point
You can resize a shape by dragging the _______. *
1 point
To copy and drag a shape to a new location, hold down the _______ key(s) as you click on the shape. *
1 point
_______ contain preset designs to instantly format a shape, picture, table, chart, and even SmartArt. *
1 point
_______ serve many purposes, but some of the more common styles appear as the thought and dialog balloons often used in cartoons. *
1 point
Holding down the Shift key while drawing one of the line shapes will create a straight line that is _______. *
1 point
Under the Line category, the _______ allows you to draw any pattern as long as you hold the mouse button down. *
1 point
What chart type is used to demonstrate the proportion of different categories? *
1 point
To create a symmetrical shape, hold the _______ key(s) as you draw the shape. *
1 point
A copy of your responses will be emailed to the address you provided.
Submit
Clear form
reCAPTCHA
PrivacyTerms
This content is neither created nor endorsed by Google. Report Abuse - Terms of Service - Privacy Policy
Google Forms