CSC 105 Final Exam
Displays the name of a worksheet within a workbook.
Sheet Tab
The value axis currently shows increments such as 50,000 and 100,000. What option would you select to display the values in increments of 50 and 100?
Show Axis in Thousands
A circle that enables you to adjust the height or width of a selected chart.
Sizing Handle
The most basic element of PowerPoint, analogous to a page in a Word document.
Slide
A slide view where the control of the layouts, background designs, and color combinations for handouts, notes pages, and slides can be set giving a presentation a consistent appearance.
Slide Master
An electronic method to deliver your message using multiple slides.
Slide Show
The view used to deliver a completed presentation full screen to an audience, one slide at a time.
Slide Show View
Displays thumbnails of your presentation slides, allowing you to view multiple slides simultaneously.
Slide Sorter View
What view is the best choice if you want to reorder the slides in a presentation?
Slide Sorter View
Which of the following components are contained in Normal view?
Slides pane and Slide pane
The process of listing records or text in a specific sequence, such as alphabetically by last name.
Sorting
Miniature chart contained in a single cell.
Sparkline
Located at the bottom of the screen n Normal view, this contains the slide number, spelling check, Notes, and Comments buttons, and options that control the view of your presentation.
Status Bar
A visual design that helps you plan the direction of your presentation slides.
Storyboard
A tag or use of a table element, such as a field label, as a reference in a formula.
Structured Reference
A set of rules that governs the structure and components for properly entering a function.
Syntax
Displays the current date.
TODAY Function
A structure that organizes data in a series of records (rows), with each record made up of a number of fields (columns).
Table
Where is data in a database stored?
Table
The rules that control the fill color of the header row, columns, and records in a table.
Table Style
Window of options to format and customize chart elements.
Task Pane
A file that incorporates a theme, a layout, and content that can be modified.
Template
Includes letters, numbers, symbols, and spaces.
Text
The CPU consists of which two parts?
The control unit and the arithmetic logic unit
Which of the following is not true about the VLOOKUP function?
The lookup table must be in descending order.
All of the following statements are true about creating a database except:
The objects provided in a template cannot be modified.
Which of the following is true?
The slide layout can be changed after the template has been chosen.
When entering, or editing input masks:
The table must be in Design view.
A collection of formatting choices that includes colors, fonts, and special effects.
Theme
Which of the following features enable you to change the color of objects in your slide show without changing text?
Themes
A slide miniature.
Thumbnail
Which of the following layouts is most commonly used when introducing the topic of the presentation and the speaker?
Title Slide
Which Conditional Formatting rule is best suited to apply formatting to the top five values in a range of values?
Top 10 Items
A table row that appears below the last row of records in an Excel table and displays summary or aggregate statistics, such as a sum or an average.
Total Row
A specific animation that is applied when a previous slide is replaced by a new slide.
Transition
Which feature will enable you to apply motion as one slide exits and another enters?
Transition
If you would like to set a conditional formatting rule based on the function =AND(G6="Finance",H7<7000), which formatting rule type is needed?
Use a formula to determine which cells to format.
To add pictures to a presentation, you can:
Use any of the above options.
What should you do to ensure that records in a table are unique?
Use the Remove Duplicates Command
Which of the following is not an aggregate function that can be applied in a total row?
VLOOKUP
Looks up a value in a vertical lookup table and returns a related result from the lookup table.
VLOOKUP Function
A number that represents a quantity or an amount.
Value
You just copied a range of data containing formulas. However, you want to preserve the formula results and the original number and text formatting in the pasted range. Which paste option would you select?
Values & Source Formatting
A variation of the theme you have chosen, using different color palettes and font families.
Variant
What is the term for theme alternatives using different color palettes and font families?
Variants
A file containing related worksheets.
Workbook
A spreadsheet that contains formulas, functions, values, text, and visual aids.
Worksheet
Formatting that enables a label to appear on multiple lines within the current cell.
Wrap Text
Chart type that shows the relationship between two variables.
X Y (Scatter) Chart
With respect to importing data into Access, which of the following statements is true?
You can assign a primary key while you are importing Excel data.
In reference to content development, which of the following points is not in active voice and is not parallel to the others?
Your topic should be researched thoroughly.
Computers use ________ language consisting of 0s and 1s.
binary
In binary language, each letter of the alphabet, each number, and each special symbol is made up of a unique combination of eight ________.
bits
A keyboard and mouse are examples of _________ devices.
input
Which of the following is not an argument of the IF function?
lookup_value
A computer ________ is two or more computers connected using software and hardware so that they can communicate with each other.
network
Apple's OS X and Microsoft Windows are examples of ________ software.
operating system
RAM is a ________ storage location.
volatile
Which of the following formats cannot be imported to use as an outline for a presentation?
.jpg
You want to create a single chart that shows the proportion of yearly sales for five divisions for each year for five years. Which type of chart can accommodate your needs?
100% Stacked Column Chart
A widescreen template that can be used for display on most screens and televisions is found in the category:
16:9
A formula containing the entry =$B3 is copied to a cell one column to the right and two rows down. How will the entry appear in its new location?
=$B5
What function would most efficiently accomplish the same thing as =(B5+C5+D5+E5+F5)/5?
=AVERAGE(B5:F5)
Which of the following functions should be used to insert the current date and time in a cell?
=NOW()
Which of the following is not an appropriate use of the SUM function?
=SUM(D15-C15)
Which of the following is an unqualified structured reference?
=[Purchase_Price]-[Down_Payment]
Which of the following characters are wildcards in Excel? (Check all that apply) a. ? b. # c. $ d. *
? and *
Which of the following is not true of sections?
A slide show can be divided into only six logical sections.
Calculates the arithmetic mean, or average, of values in a range.
AVERAGE Function
Indicates a cell's specific location; the cell reference does not change when you copy the formula.
Absolute Cell Reference
The position of data between the cell margins.
Alignment
The movement applied to an object or objects on a slide.
Animations
Which of the following would be matched if you use a Selection filter's exact match option for the name Ann?
Ann, ANN, and ann
A note or drawing added to a slide during a presentation
Annotation
How is formatting affected when reusing slides from an existing presentation?
Any of the above may happen.
To add a predefined table to an existing database, you should use which of the following?
Application Part
What is a fast way to apply several formats at one time?
Apply a cell style
An input, such as a cell reference or value, needed to complete a function.
Argument
Enables you to copy the contents of a cell or cell range or to continue a sequence by dragging the fill handle over an adjacent cell or range of cells.
Auto Fill
All of the following are suggested guidelines for table design except:
Avoid date arithmetic
Label that describes either the category axis or the value axis.
Axis Title
Given the formula =B1*B2+B3/B4^2, what operation is calculated first?
B4^2
Which of the following utilities is used to recover in the event of loss or damage?
Back Up Database
A gallery providing both solid color and background styles for application to a theme.
Background Styles Gallery
Which of the following is not a type of sparkline?
Bar
Chart type that compares categories of data horizontally.
Bar Chart
Which date filter option enables you to restrict the view to only dates that occur in March of 2018?
Between
Look at the stacked bar chart in Figure 3.35. Which of the following is a category on the category axis?
CIS Managers
Tallies the number of cells in a range that contain values.
COUNT Function
Which of the following determines how the field names can be made more readable in table and query datasheets?
Caption Property
The intersection of a column and row.
Cell
You have a large dataset that will print on several pages. You want to ensure that related records print on the same page with column and row labels visible and that confidential information is not printed. You should apply all of the following page setup options except which one to accomplish this?
Change the print page order.
Which of the following is true regarding table views?
Changes made in Datasheet view are automatically saved when you move the insertion point to a different record.
What do you click to remove a data series from a chart so that you can focus on other data series?
Chart Filters
Label that describes the entire chart
Chart Title
Currently, a column chart shows values on the value axis, years on the category axis, and state names in the legend. What should you do if you want to organize data with the states on the category axis and the years shown in the legend?
Click Switch Row/Column in the Data group on the Design tab.
You selected and copied worksheet data containing formulas. However, you want the pasted copy to contain the current formula results rather than formulas. What do you do?
Click the Paste arrow in the Clipboard group and select Values & Source Formatting
Chart that groups columns side by side to compare data points among categories
Clustered Column Chart
An outline view that displays only the slide number, icon, and title of each slide in outline view
Collapsed Outline
A conditional format that displays a particular color based on the relative value of the cell contents to the other selected cells.
Color Scale
A set of colors available for every theme.
Colors Gallery
The horizontal measurement of a column.
Column Width
Chart that contains two chart types, such as column and line, to depict two types of data, such as individual data points and percentages
Combo Chart
A set of rules that applies specific formatting to highlight or emphasize cells that meet specifications.
Conditional Formatting
A conditional format that displays horizontal gradient or solid fill indicating the cell's relative value compared to other selected cells.
Data Bar
If you want to show exact values for a data series in a bar chart, which chart element should you display?
Data Labels
Which of the following does not display automatically when you create a clustered column chart?
Data Labels
Numeric value that decribes a single value on a chart.
Data Point
Group of related data points that display in row(s) or column(s) in a worksheet.
Data Series
Which of the following characteristics is not applicable to the Accounting Number Format?
Dollar sign immediately on the left side of the value
A range of special effects for shapes used in the presentation.
Effects Gallery
Which step is not part of planning a worksheet design?
Enter labels, values, and formulas
Which of the following conditions is available through a Selection filter?
Equal Condition
________ is concerned with the design and arrangement of machines and furniture to avoid uncomfortable or unsafe experiences.
Ergonomics
Which of the following is not true of an Access database?
Every table in a database contains the same number of records as every other table.
An outline view that displays the slide number, icon, title, and content of each slide in outline view
Expanded Outline
What is the keyboard shortcut to create an absolute reference?
F4
The smallest data element contained in a table, such as first name, last name, address, and phone number.
Field
The background color appearing behind data in a cell.
Fill Color
Which of the following is not an alignment option?
Fill Color
A small green square at the bottom-right corner of a cell.
Fill Handle
The process of specifying conditions to display only those records that meet those conditions.
Filtering
A gallery that pairs a title font with a body.
Fonts Gallery
Which of the following is an example of an Access object?
Form
A combination of cell references, operators, values, and/or functions used to perform a calculation.
Formula
When you start to type =AV, what feature displays a list of functions and defined names?
Formula AutoComplete
Displays the content (text, value, date, or formula) in the active cell.
Formula Bar
You are working with a large worksheet. Your row headings are in column A. Which command(s) should be used to see the row headings and the distant information in columns X, Y, and Z?
Freeze Panes Command
The process of keeping rows and/or columns visible onscreen at all times even when you scroll through a large dataset.
Freezing
The amount of RAM storage is measured in ________.
GB
Horizontal or vertical line that extends from the horizontal or vertical axis through the plot area.
Gridline
Which print method provides lined space for note taking by the audience?
Handout, 3 Slides
A method of organizing text into levels of importance in structure.
Hierarchy
Evaluates a condition and returns one value if the condition is true and a different value if the condition is false.
IF Function
Symbols or signs that classify data into three, four, or five categories, based on the values in a range
Icon Set
Which of the following is the easiest method for adding existing content to a presentation?
Import an outline using heading styles created in Word.
What should you do if you see pound signs (###) instead of values or results of formulas?
Increase the column width
Assume that the data on a worksheet consume a whole printed page and a couple of columns on a second page. You can do all of the following except what to force the data to print all on one page?
Increase the left and right margins
A range of cells containing values for variables used in formulas.
Input Area
Defines containers, positioning, and formatting for all of the content that appears on a slide
Layout
Which statement is not recommended guideline for designing and creating an Excel table?
Leave one blank row between records in the table.
Key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart.
Legend
Chart type that shows trends over time in which the value axis indicates quantities and the horizontal axis indicates time.
Line Chart
An expression that evaluates to true or false.
Logical Test
A range that contains data for the basis of the lookup and data to be retrieved.
Lookup Table
Identifies the highest value in a range.
MAX Function
Identifies the midpoint value in a set of values.
MEDIAN Function
Displays the lowest value in a range.
MIN Function
After you create a line type sparkline, what option should you select to display dots for each data point?
Markers
The top slide in a hierarchy of slides based on the master.
Master
Which of the following is the smallest unit of measure? a. Gigabyte b. Terabyte c. Megabyte d. Petabyte
Megabyte
Contains both an absolute and a relative cell reference in a formula; the absolute part does not change but the relative part does when you copy the formula.
Mixed Cell Reference
If cell E15 contains the formula =$C$5*J$15, what type of cell reference is the J$15 in the formula?
Mixed Reference
The rule of thumb that predicts that the number of transistors on a CPU will double every 2 years is called ________ Law.
Moore's
What is the advantage to collapsing the outline so only the slide titles are visible?
More slide titles are displayed at one time, making it easier to rearrange the slides in the presentation.
Displays the current date and time.
NOW Function
Identifies the address of the current cell.
Name Box
The default PowerPoint view, containing two panes that provide maximum flexibility in working with the presentation.
Normal View
Used if the speaker needs to enter and edit large amounts of text for reference in the presentation.
Notes Page View
Rules that control the sequence in which Excel performs arithmetic operations.
Order of Operations
A method of organizing text in a hierarchy to depict relationships.
Outline
A view showing the presentation in an outline format displayed in levels according to the points and any sub-points on each slide.
Outline View
A range of cells containing results based on manipulating the variables.
Output Area
Calculates the periodic payment for a loan with a fixed interest rate and fixed term.
PMT Function
An indication of where data will start on another printed page.
Page Break
Which of the following activities is carried out by the ALU? a. Renders video images b. Moves read/write heads c. Creates virtual memory d. Performs arithmetic calculations
Performs arithmetic calculations
The function =PMT(C5,C7,-C3) is stored in cell C15. What must be stored in cell C5?
Periodic Interest Rate
Chart that shows each data point in proportion to the whole data series.
Pie Chart
Which type of chart is the least appropriate for depicting yearly rainfall totals for five cities for four years?
Pie Chart
A container that holds content.
Placeholder
Which of the following statements is not accurate about placeholders?
Placeholder positions are determined by the slide layout and may not be changed.
A file format that retains only text but no formatting when transferring documents between applications or platforms.
Plain Text Format (.txt)
A presentation saved with a .pptx extension.
PowerPoint Presentation
Uses a .ppsx extension.
PowerPoint Show
A specialty view that delivers a presentation on two monitors simultaneously.
Presenter View
How can you display formulas within the cells instead of the cell results?
Press Ctrl+'
In Outline view, levels of indentation showing the hierarchy of information cannot be created by:
Pressing ALT +TAB to demote a bullet point from the first level to the second level.
The range of cells within a worksheet that will print.
Print Area
The sequence in which the pages are printed.
Print Order
During a slideshow, which of the following would not focus audience attention on a specific object?
Put nothing on the slide but the object.
All of the following are examples of nonvolatile storage EXCEPT _______.
RAM
________ is the abbreviation for the place in the computer where the programs and data the computer is currently using are temporarily stored.
RAM
The area that holds all the startup instructions the computer needs to start is the ________.
ROM
The basic input/output system (BIOS) is stored on a _______ chip.
ROM
Which of the following is NOT a permanent storage option? a. Optical drive b. Memory stick c. Internal hard drive d. Random access memory
Random access memory
A rectangular group of cells.
Range
Used to view a slide show full screen, one slide at a time, for performing a thorough review of the slides without the full interface onscreen.
Reading View
A group of related fields representing on entity, such as data for one person, place, event, or concept.
Record
You edit several records in an Access table. When should you execute the Save command?
Records are saved automatically; the save command is not required.
Indicates a cell's location from the cell containing the formula; the cell reference changes when the formula is copied.
Relative Cell Reference
A Word outline saved in this format can be used when transferring documents between platforms.
Rich Text Format (.rtf)
The vertical measurement of a row.
Row Height
A predefined formula that calculates an aggregate value, such as totals, for values in a range, a table, or a database.
SUBTOTAL Function
Calculates the total of values contained in two or more cells.
SUM Function
You own a small business and decide to institute an Employee of the Month award program. Which of the following would be the fastest way to create the award certificate with a professional look?
Search for online templates and themes and download an Award certificate template.
A division to presentation content that groups slides meaningfully.
Section
