ICS Ch 9-15
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?
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
