click below
click below
Normal Size Small Size show me how
Arkansas CBA 1-7
EOC Review
Question | Answer |
---|---|
computer software created to allow the user to perform specific a job or task Examples: Word processing, Spreadsheets, Database, and Graphics software | Application software |
executes commands from a computer's hardware and software; the principal computer chip that contains several processing components, which determines the computer's operating speed; the "brain" of a computer | Central Processing Unit (CPU) |
A program on a computer that allows the user to create, edit, view, print, rename, copy, or delete files, folders, or an entire file System | File management |
an extension at the end of a file name, indicating which application was used to create a document i.e., Word files end in .doc and Excel files end in .xls | File type |
data entered into the computer through a variety of devices such as a keyboard, microphone, scanner, flash drive, or mouse | Input device |
action of gaining access to a computer or a network by entering a username and password; also called Login/Sign In | Logon |
computer chips that store data and programs while the computer is working; often called RAM or Random Access Memory | Memory |
system software that acts as a "go-between", allowing computer hardware and other software to communicate with each other | Operating system |
allows the user to view or listen to the data a computer processes such as a monitor, printer, headphones, or speakers | Output device |
additional hardware that isn't necessary for a computer to function, but does enhance how the computer can be used Examples: Scanner, Webcam, Computer joystick | Peripheral |
storing data for later use | Save |
a feature that allows the user to change the attributes of a file (such as location, file name, or file type) before saving it | Save As |
external hardware used to store and retrieve data, such as a disk drive, CD/DVD drive, flash drive, or tape drive | Storage device |
software responsible for the general operation of a computer system, including the operation of hardware, running application software, and file management Examples: BIOS, Microsoft Windows, Mac OS X, Linux, or utility software | System software |
a computer case that contains the CPU, power supply, memory, and storage | System unit |
how the edges of a line, paragraph, object, or table are positioned horizontally and vertically between the margins or on a page | Alignment |
sort order arranging text or numbers from A to Z, from smallest to largest, or from earliest to latest | Ascending |
a feature that automatically generates a new page, allowing text to flow to the new page when space runs out on the previous one; also known as a Soft Page Break | Automatic Page Break |
lines around the edge(s) of text, a page, a cell, or a table | Borders |
a feature in a word processing application that allows the user to create outlines or itemized lists with either icons or | Bullets and Numbering |
a feature that includes pre-made illustrations, drawings, pictures, and other graphic that can be inserted into a document | Clip Art |
one of two or more vertical sections of printed material on a page; usually separated by margins | Column |
a feature that allows a user to select text or a graphic, duplicate it and place it in another location within a document | Copy and Paste |
a feature that allows a user to select text or a graphic, remove it from its current location and place it in another location within a document | Cut and paste |
sort order arranging text or numbers from Z to A, largest to smallest, or latest to earliest | Descending |
through the use of a personal computer, combining text and graphics to produce a high-quality documents, such as newsletters, flyers, brochures, etc. | Desktop publishing |
a feature that allows a user to select text using a mouse or pointing device, and quickly move (drag) it to a different location | Drag and Drop |
to make changes by adding, deleting, or modifying text, graphics, or other items in a document | Edit |
a feature that scans a document, searches for occurrences of specific text, symbols or formatting, and allows a user to replace it with new text, symbols or formatting | Find and Replace |
the size, style, and design of text | Font |
text appearing at the bottom of each page, separate from the main body of a text | Footer |
in word processing, to utilize features that enhance the appearance and overall layout of text, graphics, tables within a document | Format |
drawings, pictures, or other illustrations inserted in a document to either explain data or enhance the appearance of text on a page | Graphics |
a break in a line or a paragraph that is forced by the user when the return key is pressed, creating a new paragraph | Hard Return |
text appearing at the top of each page, separate from the main body of text | Header |
to move text horizontally away from the left or right margin, setting it apart from surrounding text | Indent |
a page layout in which documents are printed across the length of a page, making the page wider than it is tall | Landscape orientation |
the amount of space between lines of text | Line spacing |
a page break the end user forces into a document, creating a new page at a specific location; also known as a Hard Page Break | Manual Page Break |
the white space surrounding the content of a page at the top, bottom, left and right sides, defining where a line of text begins and ends | Margins |
a feature that allows the user to view a document onscreen and make necessary formatting changes prior to printing it | Print Preview |
the measurement, or size of a font (text); each point is approximately 1/72 of an inch | Point size |
a page layout in which documents are printed across the width of a page, making the page taller than it is wide | Portrait Orientation |
the background color of a cell, table, or page | Shading/Fill |
to arrange a list alphabetically (text) or numerically (numbers), in ascending or descending order | Sort |
a feature used to automatically locate and correct spelling errors | Spell Check |
a formatting feature that allows the user to control where a line of text will be entered and how the text will be aligned; so that when the tab key is pressed, the insertion point will move to that location | Tab Stop |
a set of data arranged in a grid of rows and columns | Table |
a feature that includes pre-made documents that allow the user to fill-in-the blanks to create new documents, such as calendars, invoices, reports, resumes, etc.; enhances user's efficiency and creativity | Template |
a feature that allows the user to view synonyms and antonyms, and automatically replace words for enhanced writing | Thesaurus |
a feature that allows the user to view the current page of a document onscreen in a different ways Example: Normal view, Page Layout, Web Layout, etc. | View |
the use of software application to create, edit, format, print and save text-based documents, such as letters, reports, and memos | Word processing |
also called a soft return; a feature that automatically moves text to the next line when the previous line is full without the user pressing the enter key | Word Wrap |
text created as a graphic image | Word/Text art |
a feature that allows text to be included with pictures, shapes, or tables without covering or hiding under the image, giving the user control over how the text is position | Wrap Text |
cell reference that does not adjust to the new cell location when copied or moved | Absolute cell reference |
a selected worksheet cell that is ready for data entry | Active cell |
the position of data within a cell | Alignment |
value, cell reference, range, or text that acts as an operand in a function formula | Argument |
sort order arranging text or numbers from A to Z, from smallest to largest, or from earliest to latest | Ascending |
a function that automatically adds the values in the cells directly above or to the left of the active cell | Autosum |
returns the average (arithmetic means) of its arguments | AVERAGE |
the space formed by the intersection of a row and a column; the basic unit of a worksheet | Cell |
a unique identifier for a cell which is formed by combining the cell's column letter and row number | Cell reference |
a graphic representation of values and their relationships: pie, line, column, bar, scattered | Chart/graph |
a vertical group of cells in a worksheet identified by letters | Column |
a chart that uses bars of varying height to illustrate values in a worksheet | Column chart |
returns the number of cells in a range that contains numbers | COUNT |
sort order arranging text or numbers from Z to A, largest to smallest, or latest to earliest | Descending |
to copy a cell's contents and/or formatting into an adjacent cell or range | Fill |
arranging the shape, size, type, and general makeup of a cell or group of cells | Format |
an equation that calculates a new value using values currently on a worksheet | Formula |
keeps selected rows or columns visible on the screen as the rest of the worksheet scrolls | Freeze |
a prewritten formula that makes it easy to perform common calculations | Function |
alphanumeric text that will not be used in calculations | Label |
a chart that uses points connected by a line to illustrate values in a worksheet | Line chart |
returns the largest value in a set of values | MAX |
returns the smallest value in a set of values | MIN |
a cell reference that contains both relative and absolute references | Mixed cell reference |
a number or cell reference used in a formula | Operand |
a symbol that indicates what mathematical operation to perform on the operands: plus (+), minus (-), multiply (*), divide (/) | Operator |
the mathematical rules used for calculating the value of a formula | Order of operation |
a chart that shows the relationship of a part to a whole | Pie chart |
selected group of cells on a worksheet identified by the cell in the upper left corner and the cell in the lower right corner, separated by a colon | Range |
cell reference that adjusts to a new location when copied or moved | Relative cell reference |
a horizontal group of cells in a worksheet identified by numbers | Row |
to arrange a list of words or numbers in ascending or descending order | Sort |
a grid of rows and columns containing numbers, text, and formulas used to perform calculations | Spreadsheet |
adds all the numbers in a range of cells | SUM |
numeric characters that can be used in a calculation | Value |
process of changing values in cells to see how those changes affect the outcome of formulas in the worksheet | What-if analysis |
a collection of related worksheets | Workbook |
the workspace made up of columns and rows where data is entered to create an electronic spreadsheet | Worksheet |
sort order arranging text or numbers from A to Z, from smallest to largest, or from earliest to latest | Ascending |
a collection of organized data that allows access, retrieval, and use of data | Database |
indicates the type of data that can be stored in a field | Data type |
sort order arranging text or numbers from Z to A, from largest to smallest, or from latest to earliest | Descending |
single characteristic of data that appears in a table as a column | Field |
a name that identifies a field | Field name |
a database view that allows the user to see all fields for one record and enter them one at a time | Form |
a field that uniquely identifies a record in a table | Primary key |
a question presented in a way that allows the database to process and generate specific data from one or more tables | Query |
a collection of fields that appear as a row in a database or table | Record |
document that uses data from tables and/or queries; the user controls which items in the database will appear in the report and how it is filtered or sorted | Report |
to arrange a list of words or numbers in ascending or descending order | Sort |
a database view of information arranged in a grid of rows and columns | Table |
the way text and objects move on and off a slide during a slide show | Animation |
prepared designs that can be applied to presentation slides that include patterns, formatting, and color schemes | Design template/theme |
an image or object created or inserted into a document that illustrates the text or makes the page more attractive | Graphic |
a print option that allows you to choose the number of slides displayed per page and places a thumbnail, or small picture, of each slide on the page | Handouts |
the default view in a presentation, which contains the slide pane, the outline pane, the task pane, and the notes pane | Normal view |
printouts that contain the slide image in the top half of the page and the speaker's notes in the lower half of the page | Notes page |
a view that displays text in an outline format | Outline view |
a boxed outline on a slide that can be used to insert text or an object when clicked | Placeholder |
an application that allows the user to create and save slides to use as a slide show | Presentation |
the arrangement of placeholders on a slide | Slide layout |
runs slides as they will appear during a presentation | Slide show view |
a view that displays all slides simultaneously in miniature form | Slide sorter view |
a feature that can be applied in presentations to control the way slides move on and off the screen | Transition |
the file that an object is embedded in or linked to | Destination/source file |
a file that becomes part of the current file but is a separate object that can be edited using the application that created it | Embedded file |
the sharing or combining of data between applications | Integration |
placing a copy of an object or data in a destination file that will update when changes are made to the source file | Linking |
a feature that combines a data document with a main document to mass produce personalized letters or other documents | Merge |
transmission of messages and files using a computer network | Electronic mail (e-mail) |
a document generated by using a facsimile machine | Fax |
a vast network of computers linked to one another | Internet |
a company's private network of computers | Intranet |
a computer network that covers a small area | Local Area Network (LAN) |
computers that are connected to each other | Network |
computers that are connected and ready to receive and/or transmit data | Online |
the rules that must be observed for two electronic devices to communicate with each other | Protocol |
a computer that is not connected to a network | Stand alone |
transmitting information and communicating electronically | Telecommunications |
Internet address that identifies hypertext documents | Uniform Resource Locator ( URL) |
a system of computers that share information by means of links on web pages | World Wide Web (WWW) |