CSCI 2

Which of the following may be used as a wildcard character when searching for a value in Access?

#

If the VLOOKUP function cannot find the lookup value, the ____ error value is displayed in the cell.

#N/A

Susan is in charge of the inventory reports for her company. She will need to find specific inventory items as well as project increases in inventory costs. To get ready she will create a worksheet and use the Microsoft Excel 2016 Analysis tools. Susan use VLOOKUP to retrieve the return value from a vertical lookup table. When she enters the VLOOKUP function, specifying the lookup value and other criteria, the lookup value cannot be found. It displays ____ error value in the cell.

#N/A

Absolute references are marked with a ____.

$

A wildcard character used as the first and/or the last character in a character string to match any number of characters is the ____ character.

*

Which of the following is the file extension used for Access 2016 database files?

.accdb

Put the following five steps in the order in which you would perform them to use the Paste Special function.1. Select and copy a range.2. Click the Paste button arrow in the Clipboard group on the HOME Tab.3. Specify exactly what you want to paste.4. Click Paste Special to open the dialog box.5. Select the range where you want to paste the Clipboard contents.

1,5,2,4,3

The default character length for the Short Text data type is ____ characters.

255

How many characters may a field name in Access contain including numbers, letters, spaces, and special characters?

64

Which Access feature provides information about Access commands and features and instructions about how to use them?

Access help

Click the "Return to the previous slide" and "____ to the next slide" buttons to move from slide to slide in Slide Show view.

Advance

Which of the following is not an Excel function category?

Algebra

The data type that allows both sequential and random numbering is the ____ data type.

AutoNumber

Which data type allows the designer to define the Field Size property?

AutoNumber

Case 2-2Antoinette is part of a college department creating a number of student files with Microsoft Excel. She is working on a student retention project and wants to produce a worksheet that can alert faculty of student progress and current grade status. Each worksheet will contain a specific class with the students' grades for the entire term. In order to determine the current student grade, Antoinette would have to use the _____ function.

Average

During your presentation, you can easily display a blank black slide by pressing the ____ key(s).

B

To design a form using the Form Wizard, begin by clicking on the ____ tab on the Access Ribbon.

CREATE

You already created a line chart, but now decide that you want to change this chart to a pie chart. To do this, you click ____ from the Type group in the Chart Tools Design tab.

Change Chart Type

____ is one of the options available from the Page Layout group on the PRINT PREVIEW tab when previewing how a report will print.

Changing Page orientation

Formatting used in a report that is applied to certain field values depending on the conditions set for the values is ____ formatting.

Conditional

To format an individual sparkline, select the sparkline you want to format, and then click the Ungroup button in the Group group on the SPARKLINE TOOLS ___ tab.

DESIGN

The ____ CHART TOOLS contextual tabs appear on the Ribbon when you select a chart.

DESIGN and FORMAT

______ provide descriptive text for the individual data markers, such as pie slices

Data Labels

Case 1-2Kamilla is creating a presentation about her family for a homework assignment. Her friend Ivan, a PowerPoint 2016 expert, is helping her. When Kamilla clicks in the Title placeholder a contextual tab, the ____ tab, appears on the ribbon.

Drawing tools format

Antoinette wants to be sure that her worksheet does not contain any duplicates. She will use the highlight cells rule _____ to check for this.

Duplicate values

Case 2-2Merlia is creating a presentation about her ethnic heritage for a homework assignment. Her friend John, a PowerPoint 2016 expert, is helping her add transitions. Merlia wants all of her slides to come "From Right" except the last slide. She can change the last slide to come "From Top" by clicking the ____ button. (479127)

Effect Options

To begin importing data from an Excel spreadsheet, click on the ____ tab on the ribbon.

External Data

Ellen is a recent college graduate. She has decided to open a T-shirt business and would like to create budget worksheet using Microsoft Excel 2016. She need to keep track of her expenses and income for the year. Ellen is expect to get a 3% raise next year. She enters .03 in cell D1 so that she can predict her monhtly income for the next year. What function key will make D2 an absolute reference?

F4

Susan is in charge of the inventory reports for her company. She will need to find specific inventory items as well as project increases in inventory costs. To get ready she will create a worksheet and use the Microsoft Excel 2016 Analysis tools. Susan needs to use a lookup function to find an exact match of an inventory item, so she will set the range-lookup value to _____

FALSE

Using AutoFill, what would be the extended series of the initial entry Jan? ___

Feb, March, APR

Another term used for the column selector feature is ____.

Field selector

In common usage, a(n) ____ is any text that appears at the bottom of every page in a document or every slide in a presentation.

Footer

Simon has just started a job with the police department. His director has given him the last six months of test results from four local precincts. Simon has organized the results as four data series and needs to display the trends in a graphic format. Simon wants to change the charts border. To do this, he should select the CHART TOOLS ____ tab.

Format

Susan is in charge of the inventory reports for her company. She will need to find specific inventory items as well as project increases in inventory costs. To get ready she will create a worksheet and use the Microsoft Excel 2016 Analysis tools. Susan wants to automate the trial-and-error process by allowing her to specify a value for a calculated items, which Excel uses to determine the input value needed to reach that goal. She can use _______.

Goal Seek

When you print ____, the presentation is printed with one or more slides on each piece of paper.

Handouts

The Add or Remove Columns button in the Paragraph group on the ____ tab allows you to create multiple columns in a text box.

Home

You can use the Picture button in the Images group on the ____ tab to add photos to slides.

INSERT

Which category of Excel functions returns information about the format, location, or contents of worksheet cells?

Information

_____ is the amount added to the principle of a loan by the lender.

Interest

The common field between two tables in the Relationship window is indicated by a(n) ____.

Join Line

A custom date format set for a Date/Time field that contains the symbols mmm/dd/yy would display the date as ____.

Jul/04/16

Which of the following is the most logical data type to use if a field will contain long comments or explanations?

Long Text

Susan is in charge of the inventory reports for her company. She will need to find specific inventory items as well as project increases in inventory costs. To get ready she will create a worksheet and use the Microsoft Excel 2016 Analysis tools. Susan designs a worksheet with the inventory number, description, quantity, unit cost, reorder point and value. To find another location in the worksheet such as cells or in formulas, she will use_____.

Lookup function

To avoid splitting a worksheet in awkward places, you can insert a _____ to specify a specific breaking point. (478566)

Manual page break

Ellen is a recent college graduate. She has decided to open a T-shirt business and would like to create budget worksheet using Microsoft Excel 2016. She need to keep track of her expenses and income for the year. Ellen's spending varies from month to month. She wants to calculate the total expense for each month. She wants to see all the arguments associated with the SUM function so she clicks the _____then clicks SUM to open the Function Arguments dialog box.

Math & Trig button in the function library group

To compress the videos in a presentation, click the Compress ____ button.

Media

A database management system is a useful tool only if it meets which of the following criteria?

Meets the needs of the users

____ references are seldom used other than when creating tables of calculated values such as a multiplication table in which the values of the formula or function can be found in the initial rows and columns of the table.

Mixed

After a conditional formatting rule is created using the ____ dialog box, the rule is then available for use in the database from the Conditional Formatting Rules Manager dialog box.

New Formatting Rule

Case 1-1Using PowerPoint 2016, Ethan develops a short five-slide presentation for his marketing project. When Ethan first creates a new presentation it is displayed in ____ view.

Normal

To duplicate, rearrange, or delete slides, you select the slides in the Slides tab in ____ view or switch to Slide Sorter view.

Normal

Which data type allows both positive and negative numbers as field values?

Number

If you don't choose a theme, the default ____ theme is applied.

Office

If you need to use a custom theme frequently, you can save a presentation file as a(n) ____ Theme file.

Office

Case 1-2Kamilla is creating a presentation about her family for a homework assignment. Her friend Ivan, a PowerPoint 2016 expert, is helping her. Kamilla has run out of room on her computer's hard drive, so Ivan helps her upload the file to her account on ____, Microsoft's free online storage area.

OneDrive

Simon has just started a job with the police department. His director has given him the last six months of tests results from four local precincts. Simon has organized the results as four data series and needs to display the trends in graphic format.. Simon has finished his chart but needs to save some space. What's the most effective way for Andy to reduce space without losing importnat data?

Overlay the legend in areas without data.

Mya has just surveyed 100 students to get their reaction to a new textbook she is reviewing. She has one data series that she wants to represent graphically, and she need to display her data in a way that lets her visually compate the data values and see how much contributes to the whole. Mya has asked for your advice. A colleague told her to remove the legend from her pie chart because it takes up too much space. What would be a better piece of advice to give Mya.

Overlay the legend on a part of the chart that's empty.

Jorge has created a database for the herb garden he is planting this spring. Fields in the database include: Plant Name, When to Plant, Amount of Sun, Annual, and Perennial. He needs to answer the following questions using his database.Which plants need full sun?Which plants are Perennials? When creating a query to determine which plants need full sun, which fields must be included in the query?

Plant name and amount of sun

Case 1-1Using PowerPoint 2016, Ethan develops a short five-slide presentation for his marketing project. Ethan has not saved his PowerPoint file yet, and it appears with a temporary filename "____" followed by a number.

Presentation

Case 2-2Merlia is creating a presentation about her ethnic heritage for a homework assignment. Her friend John, a PowerPoint 2016 expert, is helping her add transitions. After working for a while, Merlia wants to see how the transitions look. John shows her that there is a ____ button on the TRANSITIONS tab to preview transitions.

Preview

A calculated field is formatted using the ____ for the field.

Property Sheet

The query type that gives Access an example of the information being requested and retrieves information based precisely on matching the example is which type of query?

Query by Example (QBE)

Because Antoinette is familiar with conditional formatting, she can use the _____, which provides access to the most common tools for data analysis and formatting.

Quick Analysis Tools

Use the ____ Picture button to undo formatting and sizing changes you made to a picture.

Reset

Case 1-1Using PowerPoint 2016, Ethan develops a short five-slide presentation for his marketing project. After opening PowerPoint, Ethan sees buttons to execute commands in the ____ area.

Ribbon

Case 2-1Using PowerPoint 2016, Kyle develops a presentation on the geography of Asia. His presentation includes several shapes. To open a menu of Rotate and Flip commands, Kyle clicks the ____ button.

Rotate

Results of a query may be viewed at any time by clicking the ____ button in the Results group on the Ribbon.

Run

Mya has just surveyed 100 students to get their reaction to a new textbook she is reviewing. She has one data series that she wants to represent graphically, and she need to display her data in a way that lets her visually compate the data values and see how much contributes to the whole. Mya has decided she needs to move her chart so that it appears below her data source. Before she can move or resize her chart, she must

Select the chart

Ellen is a recent college graduate. She has decided to open a T-shirt business and would like to create budget worksheet using Microsoft Excel 2016. She need to keep track of her expenses and income for the year. Ellen wants to find out what her median monthly spending is. The monthly totals for her spending appear in the range A10:L10. Which of the following is not a way to enter the MEDIAN functions into her database?

Select the range A10:L10, click the Quick Analysis button, click TOTALS and then click Median.

Which data type allows field values to contain letters, digits, and other characters?

Short text

____ handles are the small circles that appear in the corners and in the middle of the sides of the border of a selected object.

Sizing

Case 1-1Using PowerPoint 2016, Ethan develops a short five-slide presentation for his marketing project. PowerPoint files consist of what looks like pages in a document. Ethan correctly calls these buttons ____.

Slides

Case 2-1Using PowerPoint 2016, Kyle develops a presentation on the geography of Asia. His presentation includes several shapes. To add visual interest, Kyle changes the ____ of the shape's border by changing the solid outline to a dashed line.

Style

____ is the default name for a new table in an Access database.

Table1

To insert a table, in a content placeholder, click the INSERT tab on the ribbon, click the Table button in the ____ group, and then click Insert Table.

Tables

Case 2-2Antoinette is part of a college department creating a number of student files with Microsoft Excel. She is working on a student retention project and wants to produce a worksheet that can alert faculty of student progress and current grade status. Antoinette wants all her worksheets to have the same formatting for text, colors, and graphical effects applied to create a specific look and feel. Antoinette needs to apply a _____.

Theme

Case 1-2Kamilla is creating a presentation about her family for a homework assignment. Her friend Ivan, a PowerPoint 2016 expert, is helping her. Ivan tells Kamilla that the first slide of her presentation will be the ____ slide.

Title

Ellen is a recent college graduate. She has decided to open a T-shirt business and would like to create budget worksheet using Microsoft Excel 2016. She need to keep track of her expenses and income for the year. Ellen opens Excel 2016 and enters her monthly income for one year beginning with January. To create a series of months, she can ____

Type January in cell A1 and then drag the fill handle

When you are finished working with a presentation, you can exit PowerPoint. If there is only one presentation open, you click the Close button in the ____ corner of the program window to exit the program.

Upper-Right

Harold has been working as a real estate agent. He has a lot of housing data to report and needs help organizing his data sheet for an effective presentation. Harold needs to format several cells with 11pt Calibri font, two decimal places, right-aligned, and a blue font color. The most efficient way to accomplish this would be to _____.

Use format painter

Susan is in charge of the inventory reports for her company. She will need to find specific inventory items as well as project increases in inventory costs. To get ready she will create a worksheet and use the Microsoft Excel 2016 Analysis tools. Susan wants to make some changes to the worksheet to explore the impact that changing input values has on the calculated values in the worksheet. She can use ____.

What-If Analysis

Interns Leah and Santana are organizing a summer camp for children ages 5-10 for their local recreation and parks agency. Participant and payment information is stored in an Excel spreadsheet as children are registered for activities. An Access database contains information about children (participants), parents, employees, as well as activity sessions and schedules. The database contains the following tables:· Participant Information· Parent Information· Employees· Activities Leah and Santana have been requested to print a daily report of scheduled activities. Their supervisor needs to know if each participant has paid for the activity. The ParticipantPD field will be included in the report. Which data type will allow the report to display a true/f

Yes/No

The ____ data type only allows a field length of 1 character and is used to indicate the presence or absence of a condition.

Yes/No

A field with the Short Text data type sorted in descending order will display the data in which order?

Z to A

Ellen is a recent college graduate. She has decided to open a T-shirt business and would like to create budget worksheet using Microsoft Excel 2016. She need to keep track of her expenses and income for the year. Ellen has entered all of her monthly expenses. She needs to create a formula that will deduct her monthly expenses from her monthly income. Since her monthly income is the same amount each month, she uses a(n) ____ to identify the cell containing the income values.

absolute reference

To resize an image without changing its proportions, simply drag ____ of the image.

any corner

Case 2-2Merlia is creating a presentation about her ethnic heritage for a homework assignment. Her friend John, a PowerPoint 2016 expert, is helping her add transitions. John tells Merlia that it is often best to use the same slide transition consistently. He shows her the ____ button which applies the transition to all the slides in the presentation.

apply to all

The + symbol is an example of a(n) ____ operator.

arithmetic

The ____ ratio is the ratio of an object's height to its width.

aspect

Case 1-1Using PowerPoint 2016, Ethan develops a short five-slide presentation for his marketing project. When Ethan first opens PowerPoint, he has two ____ view options: 1) to open an existing presentation or 2) to create a new file.

backstage

Case 1-2Kamilla is creating a presentation about her family for a homework assignment. Her friend Ivan, a PowerPoint 2016 expert, is helping her. When Kamilla clicks in the Title placeholder, the insertion point appears as a ____ line in the center of the placeholder.

blinking

In ''SUM(number1 [, number2, number3, ...])", number 1, number 2, and number3 may be numbers or _____

cell references

As a general rule, you should _____.

center column titles, left-align text, and right-align numbers

Harold has been working as a real estate agent. He has a lot of housing data to report and needs help organizing his data sheet for an effective presentation. Harold cannot increase the width of his worksheet because, if he does, he will not be able to print it on one sheet. However, his columns are truncating his content. What solution would be the best for Harold to use to make all his text visible without losing data?

choose Wrap text for the columns

When copying and pasting records from one table to another, the records must first be copied to the ____.

clipboard

A field used to connect one table logically with another table is called a ____ field.

common

Queries based on more than one table, must have a ____ field.

common

Which term identifies a field that appears in two separate tables and may be used to connect records in the separate tables?

common field

Case 2-2Antoinette is part of a college department creating a number of student files with Microsoft Excel. She is working on a student retention project and wants to produce a worksheet that can alert faculty of student progress and current grade status. Antoinette's workbook has all the data entered and students' current grades displayed. She would like the current grade cells to display the value in red if it is less than 60. Antoinette needs to add _____ to the cell.

conditional formtting

_____ are an example of conditional formats in Excel.

data bars

Which view must be used to delete an entire record?

datasheet

Which Access 2016 view shows the contents of a table as a datasheet?

datasheet view

A value set in the Field Properties pane that appears in a field automatically is the ____ for the field.

default value

When choosing field names, it is best to choose names that ____.

describe the content or purpose of the field

The ____ property allows the database designer to explain the purpose of a field or how a field is used.

description

A ____ is a set of field values for a record that is found in a table related to the primary table on which a report is based.

detail record

Mya has just surveyed 100 students to get their reaction to a new textbook she is reviewing. She has one data series that she wants to represent graphically, and she need to display her data in a way that lets her visually compate the data values and see how much contributes to the whole. Since Mya is still reviewing her data, she wants to make sure that her chart reflects any changes she makes in her data source. She should

do nothin since charts in Excel remain linked to data sources

The less precise way to move objects in report Layout view is to ____.

drag objects

When combination charts have data series with vastly different values, you can create ____ charts.

dual axis

Case 2-2Merlia is creating a presentation about her ethnic heritage for a homework assignment. Her friend John, a PowerPoint 2016 expert, is helping her add transitions. To change the speed of a transition, John shows Merlia how to change the ____.

duration

Which record modification mode is used to insert or delete characters in a field value based on the location of the insertion point?

editing mode

Case 2-1Using PowerPoint 2016, Kyle develops a presentation on the geography of Asia. His presentation includes several shapes. Kyle wants to add a 3D rotation to highlight one of the mountain ranges. To do this he clicks the Shape ____ button.

effects

Mya has just surveyed 100 students to get their reaction to a new textbook she is reviewing. She has one data series that she wants to represent graphically, and she need to display her data in a way that lets her visually compate the data values and see how much contributes to the whole. Mya needs to call attention to one category above all others. For this purpose, she should use a(n)

exploded pie chart

To move one slice of a pie chart away from the pie creates a(n) ____.

exploded pie chart

Each column in an Access table datasheet represents a ____.

field

A database system determines how to store, display, and process field values based on which of the following?

field properties

Before applying a conditional format in a report, the ____ box must be selected.

field value

The specific content of a field is referred to as the ____.

field value

In a relational DBMS, a user may create a database structure that contains which of the following?

fields, tables, and table relationships

To add a _____ to a sheet tab, right-click a sheet tab, point to Tab Color on the shortcut menu, and then click a color.

fill color

Mya has just surveyed 100 students to get their reaction to a new textbook she is reviewing. She has one data series that she wants to represent graphically, and she need to display her data in a way that lets her visually compate the data values and see how much contributes to the whole. Sometimes Mya might want to see information on only specific slices. Rather than creating a new chart that includes only those selections, she can ___ an existing chart.

filter

The _____ command searches through the current worksheet or workbook for the content or formatting you want to locate.

find

Data in a form may only be modified in ____ view.

form

Which Access database object(s) might be used to enter, edit, and view records in a database?

forms

The FV function stands for

future value

Case 2-1Using PowerPoint 2016, Kyle develops a presentation on the geography of Asia. His presentation includes several shapes. Kyle easily adds new shapes to a timeline. He simply clicks the shape he needs in the Shapes ____.

gallery

A ____ is shading in which one color blends into another or varies from one shade to another.

gradient

To draw a shape, click the Shapes button in the Illustrations group on the _____ tab, click a shape in the gallery, and then click and drag to draw the shape in the size you want.

insert

Edward Tufte was concerned with what he termed as "chart ____," in which a proliferation of chart elements—chosen because they look "nice"—confuse and distract the reader.

junk

Which view is used to make design changes to a form while the form is displaying data?

layout view

Case 2-2Antoinette is part of a college department creating a number of student files with Microsoft Excel. She is working on a student retention project and wants to produce a worksheet that can alert faculty of student progress and current grade status. When Antoinette shares her worksheet with other colleagues, she wants to ensure that everyone knows why certain cells are highlighted. To accomplish this, she will create a _____.

legend

Which symbols would be used to create a custom date format that would display July 4, 2016 as 7/04/16?

m/dd/yy

The process of adding, modifying and deleting records in a database to keep the records current and accurate is referred to as ____ a database.

maintaining

Simon has just started a job with the police department. His director has given him the last six months of tests results from four local precincts. Simon has organized the results as four data series and needs to display the trends in graphic format. It's difficult to read the exact scale on some of Simon's data. Adding ___ would make it easier to read.

major tick marks.

Another name for the middle value is the ____ value

median

A query based on more than one table is a(n) ____query.

multiple

Harold wants to print ranges E6:F12 and E16:F22 of his worksheet. These are referred to as _____ cell ranges.

nonadjacent

The comparison operator, < >, is used to insert a condition that means ____.

not equal to

Date criteria are automatically enclosed in ____ when entered in a query design.

number signs

A relationship between Access tables that is a relationship between one record in the first table and zero, one, or many records in the second table, and at least one record in the second table matches at most one record in the first table, is defined as a ____ relationship.

one-to-many

A chart sheet can contain ____.

only one chart

Mya has just surveyed 100 students to get their reaction to a new textbook she is reviewing. She has one data series that she wants to represent graphically, and she need to display her data in a way that lets her visually compate the data values and see how much contributes to the whole. Since it's important for Mya to keep percentages of her whole reviewer base in mind, she wants to represent data as parts of a whole. What chart type would you suggest to Mya?

pie

After you insert a video, you can modify it by changing ____ options, changing the length of time the video plays, and applying formats and styles to the video.

playback

Text is measured in ____.

points

A report formatted where the page is taller than it is wide is formatted in ____.

portrait orientation

The primary key of a table must be unique for each record; however, the ____ sort field does not have to be unique.

primary

Viewing and printing options for forms and records are available on the ____ tab.

print preview

Experienced database developers avoid using spaces in field names and object names because names with spaces might cause errors if the objects are involved in ____.

programming tools

Which Access database object asks a question about the data stored in a database and displays specific fields and records that answer the question? (478780)

query

Data may be sorted in a table datasheet, a form, and a ____.

query datasheet

The Expression Builder dialog box is available from which group on the Query DESIGN tab on the Ribbon? (

query setup

Each row in an Access table datasheet displays which of the following?

record

Harold has been working as a real estate agent. He has a lot of housing data to report and needs help organizing his data sheet for an effective presentation. Harold has chosen green as the background color for his workbook. He should not use _____ for any of the font or highlight colors.

red

When creating an Excel document, you should avoid using _____ text and background together, since this is the most common form of color blindness.

red and green

Data organized as a collection of tables creates this type of data system.

relational database management system

What function does compacting an Access database perform other than reducing the file size?

repairing the database

Data in Date/Time fields are automatically ____-aligned.

right

One ____ available for specifying conditional formatting in a report is "Check values in the current record or use an expression."

rule type

To save a table in Access with a name that relates to the database (a name other than the Access default name), it is necessary to complete which process?

save the table object

The Insert Function dialog box has a(n) ____ option

search

To resize an embedded chart, ____

select the chart and drag the corner sizing handle of the selection box.

To print two records from a form, select the ____ option in the Print dialog box.

selected record(s)

The AutoFilter sort method works on a(n)____ field(s).

single

It is often easier to maintain data in a datasheet using a form because all changes for a ____ are the focus at one time.

single record

A _____ indicates a manual page break.

solid blue line

Changing the order of fields in a database table is an example of changing a table's ____.

structure

Case 1-2Kamilla is creating a presentation about her family for a homework assignment. Her friend Ivan, a PowerPoint 2016 expert, is helping her. Once Kamilla decides to work with the Title slide she sees that it has two ____.

text placeholders

The condition "Seattle" for the field City in a student database is an example of what type of value?

text value

FUNCTION(argument1, argument2, ....) is ____.

the general syntax of all functions

The appearance of fields in a report that is created using the Report Wizard is determined by ____.

the order the fields are selected in the Report Wizard

In addition to standard colors, the font color gallery displays ____ colors.

theme

Usually the date and slide number do not need to appear on the ____.

title slide

What is the purpose of the primary key?

to uniquely identify each record in a table

If a video is too long, or if there are parts you don't want to show during the slide show, you can ____ it.

trims

Harold has been working as a real estate agent. He has a lot of housing data to report and needs help organizing his data sheet for an effective presentation. Harold would like to center a title across the top of his data. His data runs across five columns, from column A to column E. One way he could accomplish this is to _____. (478578)

type the data in A1 and Merge cells A1:E1

When the sort field data for each record in a database is different, the sort field is ____.

unique

Harold has been working as a real estate agent. He has a lot of housing data to report and needs help organizing his data sheet for an effective presentation. In one of Harold's columns there are too many numbers after the decimal place. Harold does not need this level of detail. It is distracting from the data and he really only needs two numbers after the decimal. How could Harold make the data appear cleaner in the most efficient way?

use the Number group to decrease number of digits displayed

Case 2-1Using PowerPoint 2016, Kyle develops a presentation on the geography of Asia. His presentation includes several shapes. Kyle wants to change the thickness of one of the shape outlines. Thickness is another word for ____.

weight

A calculated field created in a query generates results when ____.

when the query is run

A ____ is a placeholder used in a search when the search should start or end with a specific character or match a particular pattern. (

wildcard character