Final exam computer applications
(Excel) Which symbol represents the amperand sign and is used to concatenate two or more values or cell contents?
&
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:
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
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
(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)
(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 table
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
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) 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) If I sort my report based on Last Name going from A to Z, that is known as:
Ascending order
(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 default, Excel's _______ feature is saving your workbook every 10 minutes in case your computer loses power or shuts down unexpectedly.
AutoRecovery
(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
By clicking the File tab from the Excel ribbon, you have entered the _________ view.
Backstage
The default name for an Excel file is _______.
Book1
(PowerPoint) The outer edge or line around a table is referred to as its:
Border
The edges or lines around a cell are referred to as the cell's:
Border
(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.
(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
A ____ is referenced by a column letter and row number such as C5.
Cell
(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
(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
(PowerPoint) Graphics that are pre-fabricated and shipped with Microsoft Office for use in its applications and presentations.
Clip Art
(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
(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
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
If you wish to MOVE the contents of one cell to another cell, which command will you use: Copy or Cut?
Cut
(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) 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
(Access) Which of the following views in Microsoft Access is used for changing the design and structure of tables?
Design view
(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) 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
From the Backstage view Print options, select ____________ under Settings to print all sheets in a workbook.
Entire workbook
(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
(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
(Access) Reports and tables are typically used for the same purposes.
False
(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) Conditional formatting can only be applied to numerical data and is not applicable to text. (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) 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
(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
(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
Once a set of cell's in Excel have been combined (or merged), they can never be split apart. True or False?
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
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
(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
(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
(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) 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
(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
(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
____________ is used to copy the formatting of one cell to other cells.
Format painter
____________ is the process of changing the appearance of cells and the overall layout of the worksheet.
Formatting
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) Which Excel ribbon tab contains the Function Library command group?
Formulas
(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 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
Which Excel ribbon tab contains the Font group which allows you to change the font type, size, and color?
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
(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
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
By default, textual data is ____ aligned within Excel cells.
Left
(PowerPoint) To reduce the size of your PowerPoint presentation, you should _____ video clips.
Link to
(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
(Access) With an "Update" query, you can:
Make changes to the data in an existing table
Combining two or more cells into a single cell creates a:
Merged cell
(Excel) Which of the following choices could be used in creating a named cell range?
MonthlyExpenses
(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
(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
(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
(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
(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
(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
(Excel) The area within the X- and Y-axis boundaries where the chart appears is referred to as:
Plot area
(PowerPoint) PowerPoint is used to create:
Presetations
(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
(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
(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
(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
(Excel) A rectangular block of adjoining cells, for example A5:E5, is referred to as a cell ____ .
Range
(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
(Access) RDBMS is an acronym for:
Relational Database Management System
(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
(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
(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
(Access) Which of the following is a special-purpose programming language used for manipulating database information?
SQL
(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
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) With a "Make Table" query, you can:
Select records from the database and save them as a new table
A new Blank Workbook in Excel 2013 contains one worksheet named:
Sheet1
(Access) The data type for a telephone number field is:
Short Text
(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 gives you an idea of how your presentation will look when you deliver it?
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
(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
(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
(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
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
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) 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
(PowerPoint) To find a synonym for a word, use the following tool from the Review tab:
Thesaurus
In Excel, the program name and name of the open file are displayed in the:
Title bar
(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
(PowerPoint) A special effect that marks how one slide moves off and the next slide moves onto the screen is called a(n):
Transition
(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) Formatting the appearance of the table will not change the data, just the way you're looking at it. True or False?
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
(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) 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
(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
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
(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
(PowerPoint) PowerPoint identifies a possible misspelled word by:
Underlining it with a red wavy line
(Access) The main purpose of a form is to:
View and enter data into tables.
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
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
The keyboard shortcut for the Print command is:
[Ctrl] + [P]
Flash Fill is:
an Excel tool that automatically completes the data being inserted, following a pattern it recognizes in the data.
(Access) The purpose of a query is to:
ask questions and display specific data from a table.
(Excel) When using conditional formatting in a spreadsheet, you must first:
select or "highlight" the respective cells
(Excel) Prior to creating a chart, it is important to:
select/highlight the data you wish to chart