ICS Ch 9-15

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

Which of the following characters are wildcards in Excel? (Check all that apply.)

*

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

Which of the following is a fully qualified structured reference?

=[Purchase_Price]-[Down_Payment]

Which of the following is considered copyright infringement?

A copyrighted poem used without the permission of the author

When you press Tab in the last cell of a table, what happens?

A new row is inserted below the current row

What can you use in a presentation that must demonstrate a task that has several steps?

A screen recording

You are working with a complex animation, so you decide to use the:

Animation pane

To add a predefined table to an existing database, you should use which of the following?

Application part

Which of the following is false about headers and footers?

As a default, information is displayed in the header and footer.

Which of the following utilities is used to recover in the event of loss or damage?

Back Up Database

Which date filter option enables you to restrict the view to only dates between April 1, 2021, and April 30, 2021?

Between

Authentication techniques that rely on personal biological traits are called

Biometrics

Viruses that load from USB drives left connected to computers when computers are turned on are known as

Boot-Sector viruses

You recently printed a handout using a slide with an image; now you want to project the slide during the presentation. Which image characteristic should you check?

Brightness

You applied a chart style to a clustered column chart. However, you want to experiment with other settings to change the colors used in the chart without individually changing colors. Which of the following does not apply changes to the entire chart?

Change colors in the Format Data Series task pane

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.

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 in the Design Tab

Why would Series 1 and Series 2 display in a chart legend?

Column headings were not selected when creating a chart.

Which of the following would help you manage large image files by permanently deleting any cropped areas of a selected picture and by changing the resolution of the pictures?

Compress Pictures

A professional-looking presentation includes:

Consistent use of color and images

You want to add a video from the Internet to your presentation, so you check that the copyright is cleared through:

Creative Commons

A query's specifications as to which records to include must be entered on the:

Criteria row of the query design grid.

If you want to show exact values for a data series in a bar chart, which chart element should you display?

Data Levels

You moved a chart to its own chart sheet. What chart element can you add to provide a grid that contains a copy of the data source at the bottom of the chart?

Data Table

Which is not a way to reduce bullet points on your slides?

Display 10 lines of bullet points

A PowerPoint slide displaying a table object that is a copy or representation of a file stored in Excel that does not get updated represents what type of object?

Embedded Object

Which of the following conditions is available through a Selection filter?

Equal Condition

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.

You want to match a color from a picture with other parts of your presentation, so you use the:

Eyedropper

14. System restore points can only be created by Windows automatically on a regular schedule.

False

A 32-character password is an example of using biometrics.

False

Actual data throughput is usually higher on wireless networks than on wired networks.

False

Conventional hard drives are preferable to SSD drives because they transfer data more quickly.

False

Copying a music CD and giving it to a friend is "fair use."

False

Copyright lasts for only 50 years in the United States.

False

Encrypting data is not an appropriate measure for mobile devices such as smartphones.

False

Modern desktop operating systems are considered single-user multitasking operating systems.

False

Moore's Law describes the pace at which RAM modules improve.

False

Once files are placed in the Recycle Bin they cannot be recovered.

False

P2P networks require specialized network operating system software.

False

There is no limit to how much RAM you can add to modern computers.

False

Which type of broadband Internet offers connections nearing the speed of light?

Fiber-optic

Which of the following determines the amount of space a field uses in the database?

Field Size

A backup of all the data files on your computer can be managed easily using the Windows 10 _______ utility.

File History

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

A special processing chip found on video cards is the

GPU

Which Conditional Formatting rule is best suited to highlight sales value greater than $5,000?

Greater Than

Which print method provides lined space for note taking by the audience?

Handout, 3 Slides

When someone uses your personal information to pose as you, this is

Identity Theft

Which of the following is not a category of intellectual property?

Imprint

Which of the following is not a layout available from the SmartArt gallery?

Information table

Antivirus software prevents infection by recording key attributes about your files and checking to see if they change over time in a process called

Innoculation

When a printer receives a command, it generates a unique signal to the OS, which is called a(n)

Interrupt

A packet analyzer is called a sniffer because

It captures and reads data inside each packet

Reducing the sampling rate when digitizing a file has which effect on the file?

It decreases the file size

Which of the following describes fiber-optic broadband?

It uses strands of pure glass or plastic

Which of the following should you not do to secure a wireless network?

Keep the default network name and router password

What is used to measure the tone of a color in pictures?

Kelvin Unit

Which statement is not a recommended guideline for designing and creating an Excel table?

Leave one blank row between records in the table.

An example of an open source OS is

Linux

Which type of compression reduces a file by permanently eliminating certain data?

Lossy

If you want to use your computer for recording your band, you would benefit most from a(n)

MIDI interface

Which of the following would be matched if you use a Selection filter's exact match option for the title "Manager"?

Manager and MANAGER

What two devices are often combined into one device to connect the network to the Internet and to share the connection between devices on the network?

Modem and router

You are creating a presentation about the solar system. What can be used to depict the orbit of the moon around Earth?

Morph

Which of the following is true for the Query Wizard?No criteria can be added as you step through the Wizard.

No criteria can be added as you step through the Wizard.

Bethany is in her home, watching a video she took on vacation, while her brother is playing FIFA Soccer on his Xbox, and her dad is checking stock quotes on his iPad. What kind of network does this family most likely have?

P2P network

Which of the following is not a digital video file format?

PDF

Which of the following tools would you use to control a 3D image on a slide?

Pan & Zoom

To show the portions of each pet type to total pet sales for a pet store, which type of chart should you use?

Pie

Which type of chart is the least appropriate for depicting yearly rainfall totals for five cities for four years?

Pie Chart

Which of the following statements is not accurate about placeholders?

Placeholder positions are determined by the slide layout and may not be changed.

_______ is a set of strategies for using more than one drive in a system.

RAID

All of the following are examples of an Access object except?

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

Which of the following SmartArt graphic layouts is used to illustrate connections?

Relationship

Before donating your Windows computer, you should perform a Windows

Reset

Which of the following devices would use a real-time operating system?

Roomba Vacuum

Which of the following would NOT be a benefit of networking computers?

Sharing software licsenses

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

What view is the best choice if you want to reorder the slides in a presentation?

Slide Sorter view

Aligning shapes on a slide is made easier by using a:

Smart Guide.

Which of the following displays information as a graphic?

SmartArt

Which of the following terms describes a visual planning tool that is used to map out the direction of a presentation?

Storyboard

Which of the following is not considered an accessibility utility?

System Restore

Where are data stored in a database?

Table

Enhancing the appearance of a table is made possible by which of the following features?

Table styles

Which of the following would you NOT see on a Windows 10 Start menu?

Task View

Which of the following would you use to provide space for text anywhere on a slide?

Text box

A combo chart displays the number of new jobs on the primary value axis, percentage growth on the secondary value axis, job titles in the category axis, "New Job Growth by 2026" as the chart title, but no legend. Which is the least important title to include in the chart?

Th category axis Job Titles

It is more efficient to make a copy of an existing query rather than to create a new query when which of the following is true?

The existing query and the new query use the same tables and fields.

Which of the following does not determine the quality of a digital image?

The number of pixels in the camera lens

All of the following statements are true about creating a database except:

The objects provided in a template cannot be modified.

While working on a presentation, you are not getting any Designer suggestions, so you check:

The slide layout

Which of the following components are contained in Normal view?

Thumbnails, Slide pane, and Notes pane

Which of the following layouts is most commonly used when introducing the topic of the presentation and the speaker?

Title Slide

Desktop systems are invariably a better value than lighter, more mobile computers.

True

Different versions of Linux are known as distros.

True

Digital rights management (DRM) is a system of access control that allows only limited use of the material.

True

In Windows, if you experience unreliable behavior, try a System Restore before doing a Windows Reset. OptionTrueCorrect Answer OptionFalse

True

Plagiarism is technically not illegal in the United States.

True

Sending e-mails to lure people into revealing personal information is a technique known as phishing.

True

Virtual private networks make it just as secure to send information across a public network as it is on a secure private network.

True

You can attach more than four wired devices to a network by using a switch.

True

Your social security number should never be shared on a website, in an email, or through messaging.

True

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 format.

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

Which of the following are images that are created by mathematics?

Vector Graphics

A feature in Windows 10 that is used to organize open windows into task-specific groups is called

Virtual Desktops

The type of network that would be necessary to connect the networks of two college campuses would be:

WAN

Which of the following is the most secure security protocol used with routers?

WPA2

You created a worksheet that tracks data for a basketball team. The range B10:F10 contains the difference in final points between your team and the other team. What is the recommended sparkline to create to represent this data?

Win/ Loss

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

Which of the following is a true statement regarding creating charts for display in PowerPoint presentations?

You can paste a copy of an Excel chart into a Power-Point slide by using the Paste Special command.

An illustration of a one-to-many relationship would be:

a customer may have more than one account in an accounts table.

You decide to test an audio clip that you have inserted into your presentation, but before you do that you make sure that the computer has:

a speaker

Which of the following would not cause interference or poor connectivity between nodes on a wireless network?

a wireless extender

It is important to maintain your online reputation

all of the above: because of the persistence of information, because employers often review social media before hiring employees, to ensure information about you is accurate.

Which of the following is used to access the Internet when Wi-Fi is not available?

all of the above: mobile hotspot, 4G LTE internet access, 3G Internet access

Computer viruses can be spread by

all the above : sharing flash drives, downloading a song from a peer-to-peer sharing site

To utilize the design principle of alignment, the shapes in the presentation must have:

an organized placement with other objects on a slide.

All of the following are suggested guidelines for table design except:

avoid date arithmatic

A heading that describes the chart information is a:

chart title

A good way to assess your CPU usage is to

check the Performance tab of the Task Manager

SmartArt is used to:

create a visual representation of information.

You want to create an animation path freehand, so you use a(n):

custom path

When using object linking and embedding, the file that contains an inserted object is the:

destination file

The combination of media, Internet, entertainment, and phone services into a single device illustrates the principal of

digital convergence

When analog data is measured and converted to a stream of numerical values, this is referred to as __________ the data.

digitizing

Which of the following is an open electronic publishing format?

ePub

A type of journalism where stories are invented and intended to spread misinformation rather than being factual is known as

fake news

When the binary code is retrieved from RAM and moved to the CPU, this stage is known as

fetch

Using copyrighted works without permission of the copyright holder

is possible under the "fair use" doctrine

The main reason to set a validation rule in Access is to:

limit the entry of incorrect values in the table

Firewalls use a process of _____________ to assign IP addresses to the devices internal to the network so hackers will not know what they are.

network address translation (NAT)

Device drivers are

often bundled with the operating system

Moore's Law refers to the

pace at which CPUs improve.

When adding date criteria to the Query Design view, the dates you enter will be delimited by:

pound signs (#)

When an OS processes tasks in a priority order, it is known as

preemptive multitasking

Data can be retrieved fastest from

registers

Windows creates "restore points" so that you can

return your system to the way it was before you installed new software

The C: drive on a Windows PC is like a large filing cabinet, and is referred to as the

root directory

A ______ is a program that takes complete control of your computer without your knowledge.

rootkit

A surge protector may look like just another power strip but it also can

save your device if a voltage spike is sent through the electrical system.

You corrected a picture but now it looks grainy. This is due to the over-application of:

sharpening

When entering, deleting, or editing data:

the table must be in Datasheet view

A GUI user interface is special because

there is a set of icon that represent the OS tasks

You are using a picture as a background on your slide but now you cannot read the words. This is because you did not adjust the:

transparency

A network-attached storage device is like a network-connected hard drive.

true

Analog signals are continuous

true

Cat 5e and Cat 6 are types of twisted-pair cable

true

The power-on self-test ensures all peripheral devices are attached and operational.

true

RAM is

volatile memory


Set pelajaran terkait

Finance 341, Chapter 5, Exam practice/ Study guide

View Set

新航道‧雅思真詞彙 - Level 1 (yet)

View Set

California Driver's Handbook Driving Rules

View Set

Psych Midterm Pre-Lecture Questions

View Set

Pth 201710 Baidu, 1111 Singles Day

View Set

EOC31: End of Chapter Problems - Ch. 31: Inflation, Disinflation, and Deflation

View Set

Shipp Vocabulary 1-4 Barb-Bestow

View Set