Two or more computers connected together for resource sharing and communication is referred to as a __.
A. Network
__ is the study, design, development, implementation, support and management of computer-based information systems, particulary software and hardware.
B. Information technology
Often referred to simply as a computer, a __ is the least powerful computer in terms of processing and comes in three typical configurations: the desktop, laptop and handheld.
B. Microcomputer
The __, or operating system, is the groundwork for all system software and performs jobs like allocating memory, administrating input and output, and file management.
B. Platform
Email, word processors, spreadsheets and databases are all examples of __, used to perform particular task such as creating a budget or creating a resume.
C. Application Software
Devices that plug into computer systems can be categorized as either an input device or an output device and are often called __ devices.
C. Peripheral
A computer's primary circuit board, which is a complex array of electronics that connects and helps different components communicate with one another, is most commonly reffered to as the __ board.
B. Mother
The __ interprets program instructions and processes data by performing arithmetic and logical operations.
B. Central Processing Unit
The ones and zeroes that comprise the binary system are reffered to as __ and combining eight of these creates a byte.
B. Bits
While extremely fast, __ is volatile memory and does not retain data or information after the computer is turned off.
C. CMOS
When you change a style, __.
B. All text defined by that style will automatically change
A typeface, or __ is a complete set of characters, including upper and lower case letters, punctuation marks, and special symbols.
A. Font
Use the __ to copy exsiting text formats to other text.
D. Format Painter
By clicking the button displaying a paragraph mark in the paragraph group on the home tab, you can __.
C. Display nonprinting formatting marks
__ text, in which the first letters of each line align but the right margin is ragged, is perhaps the easiest to read.
D. Left-aligned
__ allows you to copy the content of a cell or range of cells by dragging the fill handle over an adjacent cell or range of cells. This is especially useful for copying formulas and completing sequences.
D. AutoFill
The cell at the intersection of the first column and the eighth row would have a cell reference of __.
A. A8
Which of the following is entered first when creating a formula?
B. The equal sign
What is the answer to =6+4*3-(3*2)?
B. 12
To make formulas visible in your worksheet, either click Show Formulas in the Formula Auditing group of the Formulas tab or press the Ctrl + __ key.
D. Grave Accent (')
Computers not connected to any other computer are described as __.
D. Stand-Alone
A(n) __ is a collection of computer programs that administer the hardware and software of a computer so they work properly.
A. Operating System
Modern operating systems feature __, which allows an operating system to run more than one process at a time.
C. Multitasking
The most widely used operating systems include Microsoft __, UNIX, Linux and Mac OS.
C. Windows
RAM, or primary storage, is considered volatile memory because __.
A. Its contents are lost if not saved to non-volatile device such as a hard drive
A hard drive, which is a non-volatile __ storage device, records information using a read/write apparatus to record a positive or negative charge on a platter.
B. Secondary
The microsoft platform uses a table of contents referred to as a __, or FAT.
B. File Allocation Table
Operating systems provide a GUI, or __, to allow a user to interact with a computer.
C. Graphical User Interface
Every peripheral device requires a(n) __, which allows the operating system to communicate with that device.
A. Device Driver
Currently, the most widely used microcomputer operating system is __.
A. Microsoft Windows
How should the TODAY function look when entered in the formula bar?
B. =TODAY()
Which of the following is an absolute cell reference?
D. $A$1
Use the __ to toggle through relative, absolute, and mixed references.
D. F4 Key
A relative cell reference within a formula changes relative to the direction in which the formula is being copied, while a(n) __ in a formula is one that stays the same no matter where you copy a formula.
B. Absolute Cell Reference
A function is actually a(n) __ that has already been created by Excel and makes difficult computations less complicated.
D. Formula
The SUM function __.
A. Adds numeric entries within a range of cells
Assume that A1=10, A2=20, B1=5, B2=15
What is the result of the following function?
=IF (A1=A2, MIN(B1:B2), MAX(B1:B2))
A. 15
The VLOOKUP function may use __, which are listed in ascending order in the first column of the lookup table.
A. Breakpoints
The __ function calculates the payment for a loan that is paid off at a fixed amount at a periodic rate.
D. PMT
In Excel, dates are stored as __ which allows you to calculate differences between dates, add or subtract days from a date, etc...
C. Numbers
Data security ensures that data is kept safe from corruption and also ensures __, meaning that only intended users can access it.
D. Privacy
Tangible property differs from __ property in that tangible property includes things and this kind of property includes name, ideas, and inventions.
B. Intellectual
In physical storage media, a negative charge represents a "0" __ and a positive charge represents a "1".
A. Bit
When we finish our work, we save the results in __ storage, which is non-volatile.
C. Secondary
When purchasing storage media, consider __ (how much data can it hold), and __ (how quickly can it read and write data).
D. Capacity, Access Time
Memory cards used in digital cameras and thumb drives use flash memory, a form of non-volatile __ storage.
B. Solid State
Large organizations often use RAID's, a series of hard drives treated as a single hard drive, because they __.
A. Are fast and relatively inexpensive
A file which contains sensitive information should not be stored on a(n) __.
A. Internet Drive
All businesses need to __ information so that it may be accessed at a later date, especially in the case of data loss.
D. Backup
__ storage could lead to incredibly small circuits, but will probably not be available for many years.
D. Molecular
When printing a chart, you can choose to print an entire __ or the active sheet.
B. Workbook
A chart is based on numeric values in cells called __.
B. Data Points
Different types of charts are best suited to different presentations of data. Which type of chart would best display proportional relationships, such as percentages?
A. Pie
Which type of chart shows trends over a period of time?
D. Line
A(n) __ pie chart displays one or more slices separately to add emphasis to that data represented by the separate slice(s).
C. Exploded
Which type of chart displays data vertically in a column formation and is used to compare values across different categories?
B. Column
To avoid presenting a misleading picture, do NOT include __ and individual data points on the same chart.
A. Totals
To select non-adjacent cells or non-adjacent cell ranges, select the first cell or cell range and then hold down the __ key while selecting the other cells and/or ranges.
B. Ctrl
__, which are the values or names of data points, often do much to enhance a chart.
B. Data labels
When you embed a chart in Word without linking it back to Excel, __.
D. You must copy and paste the chart from Excel again to update the chart in Word
