CSC 105 Final Exam

Ace your homework & exams now with Quizwiz!

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


Related study sets

MPW Chapter 10: Designing Organization Structure

View Set

Staffing Organizations Chapters 1 - 3

View Set

Hygiene, Skin Integrity, Wound Care, and Activity

View Set