Semester 2 Exam-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 *
A common sort is alphabetically by last name. *
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
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
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
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
To remove a page break, select the Page Break location, click the _____ button and then Remove Page Break. *
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
A ________ is a range of data created from the data in a spreadsheet. *
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 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
Once you delete a sheet tab, ________. *
1 point
You can create ______ in a large workbook to permit users to see what the workbook's purpose is. *
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
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
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
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
The ______ data type automatically increments sequentially as each new record is added to a table. *
1 point
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
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
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
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
The ________ allows you to select from the unique entries in each field column from a drop-down list. *
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
The Query Design window uses a  graphical ________layout. *
1 point
The results of the query are displayed in a ________. *
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
You can use ____ to limit records between a given range of values or 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
Forms generally use the ____ format. *
1 point
To modify, align, and size Form controls, you need to be ______. *
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 move a control, click the control and use the _____ to move the control to the desired location. *
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 click Compact & Repair Database, what will you see? *
1 point
Compacting and repairing an Access database helps you recognize parts of the database that _____. *
1 point
You can set an option to compact and repair a database automatically _____. *
1 point
To remove a control, click the control and _____. *
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
Clicking the mouse is the least preferred way to advance slides. *
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
To insert a theme into a slide show, click the _________ tab and locate the Themes group. *
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 the 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
If you leave a text box too large, it _____. *
1 point
What print range options prints every slide in the presentation? *
1 point
When in normal view, to move to the first slide, press ______. *
1 point
To save files, find print controls, and set PowerPoint options, use 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