Computer Concept Study Questions
The vertical space between lines of text is referred to as:
line spacing
(PowerPoint) To reduce the size of your PowerPoint presentation, you should _____ video clips.
link to
A recorded set of one or more actions that each performs a particular operation, such as opening a form or printing a report. Once recorded, you can execute a ______ to easily repeat the series of actions at any time to assist you in the performance of common tasks.
macro
(Access) With an "Update" query, you can:
make changes to the data in an existing table
If a computer on your network has a shared folder or drive, you can configure a shortcut to that folder or drive in File Explorer by _______ .
mapping a network drive
(Excel) Which of the following choices could be used in creating a named cell range?
monthly expenses
Which of the following is something that would NOT be found by looking through the Performance tab of the Task Manager?
most frequently visited website
(PowerPoint) Which view is most commonly used to edit your presentations slide by slide?
normal
(Excel) Which of the following is a logical operator and not a comparison operator?
not
(PowerPoint) PowerPoint is used to create:
presentations
In Microsoft Word, a gallery of Building blocks that you can create, store, and reuse to add AutoText, fields, and document properties, such as title and author, to a document is called:
quick parts
What do you call the area at the top of Word's window that contains contextually-distinct tabs with groups of buttons to access the application's features that pertain to the document or item?
ribbon
How do you produce a context-sensitive drop-down menu when working with an object (such as a table) in Word?
right-click on it
Which Word screen element allows you to use your mouse to place, move, or even remove tab stops for the selected paragraph(s)?
ruler
Which Word screen element displays the location of margins and indents for the selected paragraph(s)?
ruler
This Word command will save the active file using the same file name by replacing the contents of the existing file with the document as it appears on the screen.
save
To save an Excel workbook using a different format, location, or filename click the File tab from the Excel ribbon and choose:
save as
(Access) In order to use the Form button found in the Forms group of the Create ribbon tab, you must first:
select a table or query to base it on
(Access) With a "Select" query, you can:
select and display records from the database
(Access) This data type is used to store up to 255 alphanumeric characters, spaces, and symbols.
short text
(PowerPoint) Each "page" of a PowerPoint presentation is referred to as a:
slide
(PowerPoint) Which ribbon tab may be used to rehearse and adjust the settings for you presentation delivery?
slide show
(PowerPoint) Which view makes it easy to see all the slides at once and to rearrange the order of the slides in your presentation?
slide sorter
Instead of having to switch between two apps you use often, you can display them side by side. In this mode, an app you snap to either the left or right occupies a third of the screen, and another app occupies the remaining two-thirds. This is referred to as
split-screen mode
(Access) One of the quick and easy ways to format the whole report at once is by utilizing a ____ which gives us some nice combinations of color and font altogether.
theme
(PowerPoint) A slide design that contains matching complementary colors, major and minor fonts, as well as specific effects, like shadows or reflections is referred to as a:
theme
A collection of design elements such as fonts, colors, graphics, and navigation bars, which can be uniformly applied to documents, e-mail messages, and presentations to ensure that all the pages in the document have a consistent appearance is known as a:
theme
A quick way to customize the Windows 8 Desktop is to choose a predefined collection of display options and sounds, known as a
theme
For each open desktop application there will be an icon on the desktop taskbar. Hovering your mouse over one of the icons will produce a small preview of the application called a
thumbnail
Applications (or Apps) in Windows 8 are displayed as ____ on the Start screen.
tiles
In Excel, the program name and name of the open file are displayed in the:
title bar
(PowerPoint) A special effect that marks how one slide moves off and the next slide moves onto the screen is called a(n):
transition
(Access) Formatting the appearance of the table will not change the data, just the way you're looking at it. True or False?
true
(Excel) The ribbon allows the user to easily clear conditional formatting rules from selected cells or the entire worksheet all at once. (True or False)
true
(Excel) What is the result of the Excel formula =OR(8=4, 5<=9)?
true
(PowerPoint) When an Excel spreadsheet has been inserted into a slide from within PowerPoint, you will have access to some of the Excel functions. True or False?
true
An app purchased through the Windows 8 Store may be installed on more than one computer provided that you log onto the other computer using the same Microsoft account that was used when purchasing the app.
true
Email addresses may also be formatted as hyperlinks in Word. True or False?
true
Gridlines can be displayed on the Word document workspace to help properly align text and graphics. True or False?
true
Word 2013 now offers the ability to include screenshots of open windows running in the background without having to leave the Word program. True or False?
true
An Excel file is referred to as a:
workbook
An Excel workbook can consist of multiple _______ or "pages" each referenced by a tab at the bottom of the Excel program window.
worksheets
(PowerPoint) PowerPoint allows you to insert tables into your slides. Tables are organized by columns and rows, the intersection of which is called a:
cell
If you want to accept Word's Spelling and Grammar tool's advice and change a misspelling to their recommendation, what should you choose from the shortcut menu or Spelling and Grammar pane?
change
(Access) A graphical representation of numerical data is called a:
chart
(Excel) What is a visual representation of data used to convey information in an easy-to-understand and attractive manner called?
chart
If you've applied a column setting that you do not like, what is an easy way to reverse the procedure and go back to what you had before?
click the undo button in the Quick Access Toolbar
(PowerPoint) Graphics that are pre-fabricated and shipped with Microsoft Office for use in its applications and presentations.
clip art
In Microsoft Word, the collections of pre-fabricated graphics shipped with Office or downloaded from Microsoft's site for use in documents is called ___.
clip art
In Word, what is the name of a temporary storage area that holds text that has been copied or cut?
clipboard
By pressing Alt+F4 key combination on the keyboard, you can
closing the current application
SkyDrive (later renamed OneDrive by Microsoft) is:
cloud-based storage for documents and pictures
(PowerPoint) Which command group from the Review tab allows us to merge two copies of a presentation so that we may either accept or reject changes that have been made to it by another person?
compare
(Excel) The ability to quickly analyze your workbook data through the use of rules and formatting is known as:
conditional formatting
Because the File Explorer Ribbon displays different tabs depending on the items selected in the Navigation pane and File List, we say that it is
context-sensitive
(PowerPoint) When you click on an object on your slide such as a table or picture, you will be presented with one or more new tabs on the PowerPoint ribbon. These tabs are called _____ because they are specific to the type of item or object you have selected on the slide.
contextual
(Access) Each object such as a label or button that is placed in the report is typically referred to as a(n):
control
(Access) Objects such as Labels, Text boxes, List boxes, and Check boxes that are added to a form are called:
controls
If you wish to DUPLICATE the contents of a range of cells to another portion of the worksheet, which command will you use: Copy or Cut?
copy
(Access) The data type of an item price, such as $10.50 is :
currency
The current location on the page where text is placed when typing is known as the insertion point or the:
cursor
If you wish to MOVE the contents of one cell to another cell, which command will you use: Copy or Cut?
cut
(Access) When creating a report, the user is limited to choosing fields from a single table. If you need fields from multiple tables, then you must use a query to accomplish this. (True or False?)
false
(Excel) Once data has been formatted as a table in Excel, the tabular format cannot be deleted or removed. True or False?
false
(Excel) What is the result of the Excel formula =AND(4=4, 15<=9)?
false
(PowerPoint) Because of possible copyright infringements, PowerPoint does not allow song clips or music to be added to presentations. True or False?
false
(PowerPoint) PowerPoint requires that all inserted pictures come from the local computer, browsing Internet resources for pictures is not allowed. True or False?
false
(PowerPoint) Tables in PowerPoint are limited to alphanumeric content and cannot contain media content such as images or video clips. True or False?
false
Once a set of cell's in Excel have been combined (or merged), they can never be split apart. True or False?
false
Once a table is drawn, you cannot alter its dimensions by inserting/deleting rows or columns. True or False?
false
Word has built in copyright protection and will not allow you to insert pictures found on the Internet. True or False?
false
The File Explorer Ribbon typically contains four main tabs: File, Home, Share, and View. Which of the four ribbon tabs allows you to open frequently used folder locations and to access Help?
file
Which Word feature is used when you want to save, print, or open a document?
file menu
The background of a cell is called the:
fill color
In Excel, a black symbol in the lower right-hand corner of the active cell. Users can click and drag the fill handle to copy cell contents or create a series.
fill handle
an Excel tool that automatically completes the data being inserted, following a pattern it recognizes in the data.
flash fill
(Access) Mary wants to quickly create a form containing all of the fields from a selected Employee Information table. What button from the Forms group of the ribbon will most quickly do this?
form
____________ is used to copy the formatting of one cell to other cells.
format painter
The act of changing a font's color, italicizing it, applying bold, or changing its size is called ______.
formatting
____________ is the process of changing the appearance of cells and the overall layout of the worksheet.
formatting
(Excel) Which Excel ribbon tab contains the Function Library command group?
formulas
When formatting the text of a document into columns, it is important to choose a readable column width as well as the proper spacing in between the columns known as the ____ width.
gutter
A formatting convention whereby the first line of a paragraph aligns with the margin and the body is recessed to the right is called a:
hanging indent
The date and page number of an Excel workbook are commonly placed in a:
header or footer
(Access) If there is important calculated data being stored in a field that you do not want displayed to the user, then you may choose to:
hide the field
The File Explorer Ribbon typically contains four main tabs: File, Home, Share, and View. Which of the four ribbon tabs allows you to copy files, move files, create new folders, delete files, as well as several other common file management tasks?
home
Which Word ribbon tab contains the most commonly used command functions such as copying and pasting, changing fonts, and setting paragraph formatting options?
home
A linked object, such as a word, phrase, symbol, or image, that you can click to move to a different place in the same workbook, another workbook, or a web site; or to open an e-mail message window is known as a:
hyperlink
If you want to exclude a word from the Spelling and Grammar checker for this instance only, what should you choose from the shortcut menu or Spelling and Grammar pane?
ignore
Moving part or all of a paragraph in from the left and/or right margin is called:
indenting
Which page orientation turns the paper on its side and prints as 11 inches wide by 8.5 inches tall?
landscape
Which page orientation prints the worksheet on paper that is wider than it is tall?
landscape orientation
(Access) A graphical, intuitive, and dynamic way of effecting most changes to a form which presents an active preview of data and allows for accurate control sizing and optimal functionality.
layout view
(Excel) Which symbol represents the amperand sign and is used to concatenate two or more values or cell contents?
&
To save a workbook in a format compatible with earlier Excel versions, the file extension should be:
.xls
Excel 2013 files have names that end with a default file extension of ____ .
.xlsx
(PowerPoint) The new default slide layout aspect ratio is _____ which reflects the growing use of widescreen displays and HD formats.
16:9
How many versions of Internet Explorer 10 are provided in Windows 8?
2
(Excel) Which of the following functions could be used in finding the largest value from cells C2 through C25?
=MAX(C2:C25)
(Excel) Which of the following formulas is written in the correct syntax?
=SUM(A1:D1)
Hitting Ctrl + Home keys on the keyboard will bring you back to the upper leftmost cell of the worksheet whose cell reference is given by:
A1
By clicking the ___________ checkbox when inserting the date and/or time into a Word document, the document will display the current date/time each time you open it.
Update automatically
Which of the following is NOT a feature or capability of the Windows 8 Desktop Taskbar?
You can use it to change PC Settings such as the display screen resolution and brightness settings.
In Microsoft Word 2013, the feature that allows you to layer images or areas of color in a document, so images or blocks of color appear as if they are located behind information positioned in the foreground of a document is referred to as a:
background
(Excel) What will you type in the Data Range text box if you would like to create sparklines for the cells ranging from B3 to F7?
B3:F7
Which Windows 8 feature enables you to encrypt your computer's hard drive thus preventing sensitive data from being accessed by unauthorized users?
BitLocker
Which Windows 8 feature enables you to encrypt removable data drives thus preventing sensitive data from being accessed by unauthorized users?
BitLocker To Go
The default name for an Excel file is _______.
Book1
In Windows 8, which area of the File Explorer app displays the file path to the currently selected folder location?
Breadcrumb bar
(Excel) Suppose you highlighted/selected a column of monthly sales totals and created sparklines to provide a visual aid in comparing the monthly sales figures. When you select the sparkline for the lowest month's sales and make a change to it, why does that change typically get applied to the other cells in the column as well?
By default when you setup or create sparklines together, all of the sparklines are grouped together.
The ___ bar is an opaque bar that overlays the right side of the Windows 8 computer screen and gives access to the Search, Share, Start, Devices, and Settings options.
Charms
(PowerPoint) Suppose that you would like to include data in your presentation that comes from an existing Excel spreadsheet. You also want the ability to change data in the PowerPoint presentation table and have it also make the corresponding change in the Excel spreadsheet file. How can you do this?
Choose "Insert Object" in PowerPoint and "Link" the spreadsheet to the slide.
From the Backstage view Print options, select ____________ under Settings to print all sheets in a workbook.
Entire workbook
(Access) Which of the following is a form-creation tool that automatically creates a form based on table fields and other options selected by the user?
Form Wizard button
Which of the following is FALSE about using the Windows 8 HomeGroups feature when sharing file and devices between Windows 8 computers?
HomeGroups provide a safe and secure method for sharing resources for most businesses today.
Which version on Internet Explorer 10 includes tabbed pages, menus, toolbars, and Favorites similar to previous versions of IE?
Internet Explorer 10 for the Desktop
Which version on Internet Explorer 10 integrates use of the Charms bar to print a web page or email a copy to a friend?
Internet Explorer 10 for the Windows UI
Which type of list can be used to show a hierarchical ordering of items and allow for indented list levels?
Multilevel lists.
Which Windows 8 feature enables you to access or change the settings for network connections you've created, set up new network connections, and enable or disable network connections?
Network and Sharing Center
(Access) You've started creating a query, but you want to add a calculated value for new shipping fees to the first available column. These shipping fees are calculated by subtracting 20 from the Shipping Fee. Assuming the label of the calculated field is New Fees, which option is correct?
New Fees:[Shipping Fee]-20
(Access) Which access feature provides a step-by-step guided process for creating simple queries?
Query Wizard
(Access) Which item in the Access program window allows the user to most quickly save a report?
Quick Access Toolbar
(PowerPoint) The very top left portion of the window contains icons representing commonly used commands such as save, undo, or start with the presentation from beginning is known as the:
Quick Access Toolbar
(Access) Which of the following is a special-purpose programming language used for manipulating database information?
SQL
A new Blank Workbook in Excel 2013 contains one worksheet named:
Sheet1
Which Windows 8 feature lets you combine a number of physical hard drives into a single virtual drive, known as a pool?
Storage Spaces
Which tool in Windows 8 allows you to easily terminate non-responsive applications and to view system utilization statistics?
Task Manager
To stop Word from flagging a word as misspelled in all future documents, what should you choose from the shortcut menu?
add
Which button in the Spelling and Grammar pane allows you to add a word to Word's dictionary?
add
(Access) If I sort my report based on Last Name going from A to Z, that is known as:
ascending order
(Access) Reports and tables are typically used for the same purposes.
false
Which of the following is true regarding headers in Word 2013?
The header content does not have to be the same on all pages of a document.
If you share a file with Read/Write permissions, what will Windows do with the folder that contains the file?
The same permissions will be applied to the folder.
(PowerPoint) To find a synonym for a word, use the following tool from the Review tab:
Thesaurus
Table of contents commonly make use of hyperlinks to allow readers to quickly jump to various sections of a large document. True or False?
True
When creating a storage space pool, you need to specify whether or not you wish to include resiliency and how Windows 8 must mirror the data in the storage space. Which resiliency option saves two copies of the data in the storage space? (This means that you'll have a backup if one of the drives fails. You'll need to include at least two drives in the storage pool to support this option.)
Two-way mirror
(PowerPoint) WordArt is:
A range of visually striking, decorative styles and effects including shadows, reflections, and bevelled edges applied to text in PowerPoint presentations.
(Access) Which of the following is a TRUE statement in regards to queries in Access?
A single query can consist of fields from several tables.
Which Windows 8 tool (accessible via the flag in the desktop Taskbar notification area or the Control Panel) provides messages alerting you to potential security and maintenance issues that should be addressed as well as access to options for system troubleshooting and recovery?
Action Center
The Settings charm in Windows 8 allows you to access the Networks pane where you can choose to enable ______ mode. In this mode, Windows 8 temporarily deactivates all connections to prevent radio and other wireless communication signals from interfering with sensitive equipment, for example on an airplane or in a hospital.
Airplane
Suppose you have four open application windows open in the Windows 8 desktop. What happens if you click and hold any part of the title bar of the focused window and move the mouse from side to side?
All other open windows will minimize.
(Access) A(n) ______ is a type of template found on the Create tab of the ribbon that lets you quickly add new objects to an Access database.
Application Part
(Access) Suppose you want to use a field entitled "State" to list only those employees living in Florida, but you do not want the field column displayed in the results after you run the query. What can you do in the query design to achieve this?
Uncheck the "Show" checkbox to hide the State column from displaying in the results.
By default, Excel's _______ feature is saving your workbook every 10 minutes in case your computer loses power or shuts down unexpectedly.
AutoRecovery
What type of connection could you use to securely connect your laptop at home to your corporate network through the public Internet?
VPN
When entering text into a document, the insertion point will move to the beginning of the next line when you press:
enter
By utilizing table design features, you can make a table easier to read and follow. Banding is the formatting technique where:
every other cell in either rows or columns appears white versus filled
(Excel) To automatically add row and column headers and analyze a group of related data independenly from other cells in the worksheet, you can convert a range of cells to a(n):
excel table
You are a stock broker and need to watch several applications at a time. You connected a second monitor to your Windows 8 computer and would like to use it to watch multiple windows simultaneously. Which Project to a second screen option would best fit your needs?
extend
(Access) A single field in a table can have more than one data type defined.
false
(Access) Clicking the Report Wizard button found on the Create tab of the ribbon will automatically add all of the fields of the selected table to the report.
false
(Excel) Conditional formatting can only be applied to numerical data and is not applicable to text. (True or False)
false
(Excel) Suppose you had applied conditional formatting to highlight the top 10 scores on a test and later want to just highlight the top 5 test scores. To do this, you will need to delete the conditional formatting rule and create a brand new one. (True or False)
false
(PowerPoint) Transitions and animations mean the same thing in PowerPoint. True or False?
false
(PowerPoint) When a transition effect is chosen, it must be applied to all slides in the presentation. True or False?
false
All apps in the Windows Store are free.
false
One limitation of the Page Borders feature in Word is that they must be applied to all four sides of the page and to each page of the document identically. True or False?
false
Page numbering is done automatically in Word and there is no way to manually adjust the page number for a given page. True or False?
false
Paragraph spacing settings apply globally to the entire document. You are not allowed to have different line spacing settings for different paragraphs in the same document. True or False?
false
When creating a table in Word, you must use one of pre-formatted table templates and have very few options in customizing the structure and look of the table. True or False?
false
You can use the same process to uninstall a Windows Store app or a Windows 8 desktop application.
false
(Access) Each individual chunk of data that collectively make up a record in a database is called a:
field
(Access) If a relationship is established between two tables they will share a common:
field
(Access) Suppose you want to view only the records in a table that have a value of "FL" in the state field. What can you do to quickly display only those records that meet that criteria?
filter the table on the state field
A typeface variation, such as Times New Roman or Calibri, that defines how text appears is referred to as a _____.
font
The section that appears at the bottom of each page of a document that is often used to display page numbering or author information is called the:
footer
(Access) A field in a table that contains identifiers for records in another table, to whose primary key it is joined is known as a ____ .
foreign key
(Access) Which Access database object is often used as a user interface to the underlying data source to enter and display data quickly and easily?
form
What tool can be used to best apply formatting from one part of a document to another? Correct Answer:
format painter
This bar displays entries as they are made and edited in the Excel workbook window and also shows the actual formula used to calculate the value shown in the worksheet cell.
formula
(Excel) Excel's prewritten formulas such as =SUM() or =AVERAGE() are normally referred to as:
functions
(Excel) In an Excel formula such as =E7+E8, the plus sign for addition is called a(n) _____.
functions
The Windows 8 operating system was designed with touchscreen capabilities in mind. Tapping, double-tapping, swiping, pinching, and rotating finger movements are all forms of ____ used to interact with touchscreen devices.
gestures
Phrases and punctuation that differ from Word's grammar rules are marked with a(n)?
green wavy underline.
The rows and columns of a table are separated by demarcation lines called:
gridlines
Tiles on the Windows 8 Start screen can be organized into
groups
Which Excel ribbon tab contains the Font group which allows you to change the font type, size, and color?
home
Which of the following terms refers to a connection to a location in the current document, another document, or to a Web site?
hyperlink
(Access) A(n) ____ is a combination of literal and mask characters that specifies the format that Access allows users to use when inputting data into a field in a table and is useful for inputting such things as telephone numbers and social security numbers.
input mask
By default, textual data is ____ aligned within Excel cells.
left
Of the three standard paper sizes in the US, which one is 8.5" wide by 11" inches tall in size?
letter size
In Windows 8, you can use the default Documents, Music, Pictures, and Videos "virtual folders" to group related content. What term is used to describe a "virtual folder" that you can use to group other folders and files from a variety of locations in a file system?
library
(Access) When referring to external sources of data, which Microsoft Access method, importing or linking, will allow changes to data from another application to automatically be reflected in the Access database tied to it?
linking
The blank space around the edge of a page is the page
margin
Combining two or more cells into a single cell creates a:
merged cell
In Microsoft Word 2013, the toolbar that appears to the upper right of text that is selected is known as the _____.
mini toolbar
There is a hidden button on the far right edge (just right of the time and date) of the Windows 8 desktop taskbar that allows you to
minimize all open windows
Clicking the "Find" button found on the Home tab of the Word ribbon will display the ____ pane on the left side of the Word screen.
navigation
What Word feature can be used to ensure that a particular sentence will always start on the first line of a page?
next page section break
(Excel) Suppose cell D5 has a value of 17. What will be the value of cell E5 if it contains the formula =IF(D5<=10,"OK","Not Good")?
not good
To display information in a chronological list, sequence of actions, or definite steps, you should use:
numbered lists.
(Excel) Symbols such as +, -, and * that are used to specify the calculations to be performed in a formula are called:
operators
(Excel) The mathematical rule that Excel follows to perform calculations in a formula in the proper order is called the:
order of operations
If you're sharing your data with someone who does not have Excel or any sort of spreadsheet software on their computer, you may want to save your workbook in this format:
(PowerPoint) A PowerPoint compilation, editing, and organizing feature that allows the user to compile groups of pictures for use in presentations or on the Web.
photo album
Which of the following sign-in options is considered to be the LEAST secure?
pin
Which touchscreen gesture allows you to zoom in or out on the screen of a Windows 8 computer?
pinching
(Excel) The area within the X- and Y-axis boundaries where the chart appears is referred to as:
plot area
(Access) If you want to sort a table by the price field with the highest prices coming first, you should sort on the:
price field in descending order
(Access) Since each Social Security Number is unique per person, in the past many companies and organizations used it as a _____ field to uniquely identify their patients, employees, and so on.
primary key
(Access) The field that uniquely identifies each record in a table is called a:
primary key
(Access) To view what the report will look like when printed on paper and to access different print options, use the:
print preview
In Windows 8, the Networks pane allows you to connect to both wireless and wired networks. When connecting to a particular network the first time, you must choose whether it is a Home, Work, or Public network. Which network type doesn't allow any devices or users to access or share information unless they're explicitly granted permission to do so?
public
(Access) Which Access object can be used to update data and is designed to answer questions by retrieving, filtering, assembling, and sorting data from a database?
query
(Excel) A rectangular block of adjoining cells, for example A5:E5, is referred to as a cell ____ .
range
When sharing files and folders in Windows 8, which permission level allows an individual to open files to view them but does not allow them to save any changes?
read
(Access) Each row in a table contains a(n):
record
(Access) Each row in an Access table contains a(n) _____ which consists of multiple fields of information.
record
Which Word ribbon tab is used to create a caption for an inserted picture?
references
(Access) RDBMS is an acronym for:
relational database management system
If you wanted to replace all instances of the word "customer" with "valued customer" in a document, which button from the Find and Replace Dialog box would be most helpful?
replace all
(Access) A ______ can be used to add a custom error message for users when they enter an invalid entry for a data field.
report
(Access) A database object that summarizes the fields and records from a table in an attractive, easy-to-read format is a:
report
(Access) A document within Access that displays and summarizes data from one or more queries or tables for easy interpretation, printing, and sharing with others is known as a:
report
(PowerPoint) Which PowerPoint ribbon tab gives you access to the Comments and Compare command groups which are helpful when collaborating with a group on a presentation?
review
In Windows 8, which area of the File Explorer app organizes commands by grouping them on separate tabs where commands are separated into labeled groups based on the purposes for which you use them?
ribbon
Suppose you have a Word 2013 document and want to send it to a friend in the old Word 97-2003 format. Which File menu option will help you accomplish this?
save as
(Access) With a "Make Table" query, you can:
select records from the database and save them as a new table
What is the easiest way to allow all other users on the network to have access to a file on your computer?
select the Everyone option when sharing the file
(Excel) Prior to creating a chart, it is important to:
select/highlight the data you wish to chart
Which key is used to capitalize an alphabetic character when typing?
shift
(Access) The data type for a telephone number field is:
short text
(PowerPoint) Which view gives you an idea of how your presentation will look when you deliver it?
slide show
(PowerPoint) Which PowerPoint tool could be used to quickly and easily depict a series of steps or levels using a pyramid shape with the ability to add your own text to the diagram?
smartart
In Microsoft Office 2013 applications, a chosen graphic that visually represents your information using one of many preformatted layouts. This collection of easy to use professional graphics is called ______ and includes categories such as List, Process, Cycle, Hierarchy, Relationship, Matrix, Pyramid, Picture, and other options available on Office.com.
smartart
(Access) To quickly rearrange a table's records, you can do this to the table data.
sort
(Excel) A mini chart or trendline that is housed in an individual cell is called a:
sparkline
(Access) By indexing a field, Access can
speed up searching and sorting records in the table
By default when you go past the Lock screen in Windows 8, you will be presented with the ____ screen which displays tiles for the Apps on your computer.
start
The ______ bar in File Explorer lists the number of items in the selected location, as well as the number of items that are currently selected. It also contains shortcuts for changing to the Details view or the Large Icons view.
status
(Excel) To automatically apply several formatting options to a table all at once, choose one of Excel's predefined table:
styles
Cell ________ such as Heading and Title allow you to apply multiple formats to a cell at once.
styles
In Word, predefined groups of formatting options such as font size, family, and color known as ____ can be quickly applied to text to be used for titles, headings, and logos.
styles
Press the ______ key to move the active cell one position to the right on the worksheet.
tab
(Access) When entering data into a form, instead of using the mouse to go from one text box to another, this key on the keyboard can be used to jump to the next text box in the preset order.
tab key
(Access) Information in a database is typically stored in this, which consists of vertical columns and horizontal rows.
table
What is the term for a structure in Word that contains two or more cells, arranged horizontally in columns and vertically in rows?
table
When you create a new document in Word, you can either create a new blank document or you can choose to pick one of the pre-formatted documents, known as______, that may already include headings and titles formatted in particular fonts and colors.
templates
When you start the Excel program, you can choose to start with a new blank workbook or one of many pre-formatted workbooks called _______.
templates
(PowerPoint) PowerPoint automatically adds placeholders called _______ on your slides that enable you to insert text, pictures, tables, charts, or even videos anywhere in your presentation.
text boxes
(Access) You've created a query and you'd like to determine the total for each item in order for any duplicate values to be removed from the query results. Identify the command you use to do this.
total
(Excel) Which of the following terms most closely matches the meaning of a sparkline?
trendline
(Access) Editting a query by adding new column or changing the order of the columns is done easily through Design View.
true
(Access) In order to create a report, you must first select an Access object such as a table or query.
true
(Access) When data is changed using a form, the corresponding data in the table it is based on is automatically updated. (True or False?)
true
(Excel) If you change the data a sparkline is based on, the sparkline will be automatically updated. (True or False)
true
(PowerPoint) After a picture has been inserted into a slide, PowerPoint allows the user to format the picture by changing its brightness, cropping it, or changing its contrast. True or False?
true
(PowerPoint) Animations are always applied to objects; they are not applied to the slide itself. True or False?
true
(PowerPoint) PowerPoint allows you to narrate your presentation for playback at a later time. True or False?
true
(PowerPoint) The ability to translate your presentation into several different languages is built right into the PowerPoint program. You do not have to download any Add-ons to the program to enable this feature. True or False?
true
(PowerPoint) The animation effects are numbered on the slide so you know the order in which they take effect. True or False?
true
(PowerPoint) Transitions may also include audio clips, so that when a slide transition occurs, a sound clip will play. True or False?
true
Excel even allows you to recover previously unsaved files in the event that you accidentally close a file without saving it. True or False?
true
It is possible to merge the cells in an entire row together into a single merged cell. True or False?
true
It is possible to sync your Microsoft account with other services such as Facebook, Linked-In, and domain accounts.
true
It is recommended that you keep the default Word Trust Center settings to disable all macros with notification in order to avoid unknowingly running malicious macro code from an infected Word document that you may receive by email. True or False?
true
Using a Microsoft account, you can access cloud-based Microsoft services and features - including Windows 8 features such as instant messaging and the calendar, inbox, and contact list - from any location and Windows 8 device.
true
Video clips may be embedded into a Word document. True or False?
true
Word 2013 allows you to open and save files in a PDF format. True or False?
true
Word gives your company or organization the ability to save customized themes that can give a greater level of continuity across all your company documents. True or False?
true
Word has the ability to convert existing text into a table format. True or False?
true
Word offers a multitude of picture formatting options that allow you to flip, rotate, and make many other adjustments to inserted pictures in your document. True or False?
true
What is the default formatting that is applied to hyperlinks in Word?
underlined with blue text color
(PowerPoint) PowerPoint identifies a possible misspelled word by:
underlining it with a red wavy line
The File Explorer Ribbon typically contains four main tabs: File, Home, Share, and View. Which of the four ribbon tabs allows you to change how the files and folders are displayed in the file list, say from large icons to small icons or to show file details?
view
(Access) The main purpose of a form is to:
view and enter data into tables.
If you want to mark company documents as "confidential" or "draft" using transparent text on the page background, you can make use of which of the following features?
watermark
Use the ____________ command to display text on two lines within a cell and to keep the contents of a cell from extending beyond the its column width and running over into the cells next to it.
wrap text
Numbered labels for figures, tables, or pictures are called what?
Correct Captions
To display a list of items that can be displayed in any order, you should use:
Correct bulleted lists.
Which Word feature can be exploited by viruses and malware to potentially do harm to your computer or others who open the associated Word document?
Correct macros
If you hover your mouse over a hyperlink in a Word document, Word will notify you that a ______ operation can be used to follow that link.
Ctrl+Click
Suppose I would like to prevent a line break in Word from splitting apart my customer's title and name, "Mr. Jones", should it happen to come at the end of a line. What key combination can be used to enter a non-breaking space between "Mr." and "Jones"?
Ctrl+Shift+Spacebar
The default Word 2013 file format (or file type) is:
DOCX
(Access) An Access view that provides a grid-like environment for precision placement of controls and allows a controlled and deliberate approach to creating forms.
Design view
From the Windows 8 Start screen, you can click on the _______ to go back to the traditional look and feel of previous Windows operating systems.
Desktop tile
Which Windows 8 tool contains a comprehensive list of the devices connected to your computer and displays warning icons next to devices that are misconfigured or disabled?
Device Manager
If your computer has a bunch of old, unused, and temporary files cluttering up your hard drive, you can use the Windows 8 ________ utility to find and remove these files.
Disk Cleanup
In Windows 8, the Networks pane allows you to connect to both wireless and wired networks. When connecting to a particular network the first time, you must choose whether it is a Home, Work, or Public network. Which network type provides only basic security all devices that have access to the network are trusted by default?
Home
How can you open the Windows 8 Charms bar to access the Search, Share, Start, Devices, and Settings options?
Hover the cursor over the top or bottom right of the screen.
The ___ screen is the first screen you will see on a Windows 8 computer, even before you can log in to the computer.
Lock
Which Windows 8 feature can be personalized with a variety of images, is useful for protecting your computer whenever you leave it for short periods during the day, and can also prevent accidental taps on touch devices, for example when you're carrying a tablet in a backpack?
Lock screen
Which of the following Windows 8 tools would be valuable in assisting visually impaired users?
Magnifier
(PowerPoint) If you want to send your presentation to people who don't have Microsoft PowerPoint and you also don't want people to make changes to the presentation, then save your file in this format:
(PowerPoint) If you want to save your presentation so it is backward compatible with versions 97 to 2003, then save your file in this format:
PPT
(PowerPoint) By default, PowerPoint 2013 saves your file in what format?
PPTX
(Access) Which type of query allows us to reuse the same query for multiple criteria for which the user will type in when they are prompted upon running the query?
Parameter query
Which Paste Special option would be best used if you've copied strangely formatted text and wish to paste it in your draft document where it will be formatted at a later time?
Pasting as Unformatted Text
Which Control Panel tool allows you to specify how the system must respond to actions such as pressing the power button or closing the lid on a laptop as well as configuring sleep and hibernate settings?
Power Options
In Windows 8, which feature at the top left of the File Explorer app contains icons for a small set of the most commonly used commands?
Quick Access Toolbar
Which Word screen element found in the upper left corner displays buttons to perform frequently used commands such as "Save", "Undo", and "Repeat" with a single click?
Quick Access Toolbar
(Excel) Rather than using the "Conditional Formatting" tool from the Excel ribbon, a faster approach for applying conditional formats is to use the:
Quick Analysis icon
If you accidentally delete files from your computer's hard drive, they can be "restored" or retrieved from the
Recycle Bin
With a Microsoft account, you have access to free cloud-based storage for documents and pictures. This feature is called
SkyDrive
Which of the following is FALSE about using the SkyDrive feature in Windows 8?
SkyDrive offers free, unlimited capacity cloud-based file storage and management.
Which of the following Windows 8 tools would be valuable in assisting mobility impaired users?
Speech Recognition
This Word feature advises you about misspelled words as you create and edit a document.
Spelling and Grammar Checker
If Windows 8 doesn't automatically detect and install an appropriate printer, one can be manually added through
The Control Panel
Which Windows 8 application can be best used to manage the files and folders on your computer?
File Explorer
Which Windows 8 feature can automatically back up files in the Documents, Music, Video, and Pictures libraries, and in the Contacts, Desktop, and Favorites folders as well as providing a new file versioning feature?
File History
(Access) The 348 exchange has been moved to the 704 area code. To quickly update the telephone number field of all the records in a table, use this feature in Access.
Find and Replace
You want to find information on how to configure a network printer in Windows 8. You move your mouse to a hot corner and bring up the Charms bar. Which charm would help you find the information you need?
Search
The File Explorer Ribbon typically contains four main tabs: File, Home, Share, and View. Which of the four ribbon tabs allows you to email files, zip (or compress) files, as well as burning files to a CD or DVD?
Share
Click the _______ button from the Paragraph group of the Home tab in Word to turn on the display of nonprinting formatting characters such as the Paragraph Mark.
Show/Hide
Which edition of the Windows 8 operating system would be most appropriate for a personal home desktop or laptop computer?
Windows 8 Standard
What is the name of the Windows 8 built-in anti-virus application?
Windows Defender
What is the name of the anti-virus and anti-spyware program that comes with Windows 8?
Windows Defender
Pressing which key on the keyboard will take you to the Windows 8 Start screen?
Windows key
In Windows 8, the Networks pane allows you to connect to both wireless and wired networks. When connecting to a particular network the first time, you must choose whether it is a Home, Work, or Public network. Which network type specifies that devices can't access network files unless the network server explicitly grants them access to the files?
Work
Which keyboard shortcut can be used to copy text in a document?
[Ctrl] + [C]
Which keyboard shortcut is used to copy selected text in a document?
[Ctrl] + [C]
The keyboard shortcut for the Print command is:
[Ctrl] + [P].
Which keyboard shortcut can be used to paste text in a document?
[Ctrl] + [V]
Which keyboard shortcut is used to paste previously copied text in a document?
[Ctrl] + [V]
What key on the keyboard is used to move the cursor to the next tab stop?
[Tab]
Spelling errors are marked with:
a red wavy underline.
If you begin typing, the characters will appear in the cell of the worksheet known as the ______ cell that has its border bolded with a green color.
active cell
(Excel) Which operation in the formula =B5/(C6+C7)*2 will be processed first?
addition
(PowerPoint) A simulation of movement added to graphics or text on a slide is called:
animation
(PowerPoint) A feature that allows the duplication of animation effects between objects.
animation painter
(Access) The purpose of a query is to:
ask questions and display specific data from a table.
(PowerPoint) WMA, MP3, MP4 and WAV are examples of compatible _____ files that may be inserted into PowerPoint presentations.
audio
The ____________ feature can complete a series of values into adjacent cells based on the value of other cells and can also be used as a shortcut to copying and pasting.
auto fill
By clicking the File tab from the Excel ribbon, you have entered the _________ view.
backstage
The Trust Center security settings in Word are found by clicking the File tab and entering _____ view, where you can then access the Word options.
backstage
(PowerPoint) The outer edge or line around a table is referred to as its:
border
The edge of a table or table cell in which different styles and colors can be applied is called a:
border
The edges or lines around a cell are referred to as the cell's:
border
A ____ is referenced by a column letter and row number such as C5.
cell
The intersection of a column and row (or each individual square) in a table is called a:
cell
Copied text is temporarily stored in the ____ so that it may later be pasted to a destination document.
clipboard
If you have a column of data that represents the cost of different items, then you will likely format that data using either an Accounting number format or a ______ number format.
currency
What series of operations would you use if you wanted to move (or relocate) a selected paragraph of text from the top of a page to the middle of the page?
cut, paste
(Access) Each of the following is an Access data type, EXCEPT:
data
(Access) The ______ of a field tells Access what kind of data may be stored in the field.
data type
(Access) When designing a table, each field must have a defined ______ which identifies the kind of data that may be stored in that field.
data type
(Access) In order to restrict the data that is inputted into a field, Access can use
data validation rules
(Access) Which of the following views in Microsoft Access is used for entering actual data into records?
datasheet view
(Access) With a "Delete" query, you can:
delete information from an existing table where the data matches a specified criteria
(Access) Which of the following views in Microsoft Access is used for changing the design and structure of tables?
design view
Which of the following is a Word feature that can be used to support the use of digital documents instead of paper documents to conduct day-to-day transactions by providing assurances about the validity and authenticity of a digital document?
digital signatures
A Word file is usually referred to as a(n) _____.
document
(Excel) To make a cell reference absolute, ____________ are inserted into the cell reference.
dollar signs
(Excel) Which of the following terms most closely represents the nature of a sparkline?
dynamic
(Excel) When using conditional formatting in a spreadsheet, you must first:
elect or "highlight" the respective cells
(Excel) Items such as a chart title, gridlines, data labels, and so on that can be added to a chart are commonly referred to as chart _____.
elements
Applying Excel's Percent Style number format to the decimal value 0.17 will result in which of the following being displayed in the cell?
17%
(Access) The maximum field size for a Short Text field is ___ characters.
255
(Excel) All formulas begin with the ____________ sign.
= (equal)
(Excel) Copying the formula =A1*B1 from cell C1 to cell C2 would yield which of the following formulas in cell C2?
=A2*B2
The Windows 8 accessibility features can be found in the Control Panel or the All Apps screen in a section entitled
Ease of Access
Pressing which keyboard key allows you to quickly access the Windows Help and Support feature?
F1
(Access) Which button from the Reports group would you use if you want a guided approach to creating a report with only the fields that you indicate in the report?
Report Wizard button
(Excel) This function adds all the numbers given in a range of cells.
SUM
Suppose you enter the date 4/12/14 in cell A1 and choose the Long Date number format from the Number group of the Home ribbon tab. What will be displayed in cell A1?
Saturday, April 12, 2014
