Which type of software is used to organize data into rows and columns of cells?

Upgrade to remove ads

Only ₩37,125/year

  • Flashcards

  • Learn

  • Test

  • Match

  • Flashcards

  • Learn

  • Test

  • Match

Technology Now Chapter 4: Application Software

Terms in this set (83)

Absolute reference

Refers to a fixed cell location in a spreadsheet that never changes when moved or copied in the workbook.

Alignment

The location of text or graphics relative to the margins on a page, in a text box, or in a cell. Alignment also determines how a line or paragraph is placed between the two margins on the page: right, center, or along both edges.

Animation

The appearance of movement or motion added to an object or text by displaying a sequence of still images, each with small changes from the previous image.

App

Short for application software, a program that lets you perform specific tasks, such as writing a document, analyzing a set of numbers, or preparing a presentation.

App store

An online Web site where you can buy and download apps for a computer or for mobile device such as a tablet or smartphone.

Application software program

A program you use when you listen to music, edit photos, go to Web sites, check and send email, or perform a task as you are using a computer or smartphone. Also called app or software application.

Argument

In a formula, a value or function involved in the calculation.

Bitmap

An image based on pixels in which a color value is assigned to each pixel to give the illusion of continuity and to create a realistic-looking image.

Bullet

The character placed before a line of text to create a list.

Cell

In spreadsheet software, the intersection of a row and column in a worksheet.

Cell address

The location of a cell in a worksheet using the column header letter and row number to identify the cell in the grid, such as A12 or C75. Also called cell reference.

Cell range

A group of cells in a worksheet; the cells can be adjacent, with all cells touching, or nonadjacent, where not all cells are touching.

Cell reference

The location of a cell in a worksheet using the column header letter and row number to identify the cell in the grid, such as A12 or C75. Also called cell address.

Chart

A graphical representation of data that visually illustrates relationships and patterns.

Column chart

A type of graph that compares categories of data to one another.

Convergence

The blending of technologies that blurs the distinction between categories of software and hardware.

Cropping

To remove parts of an image or delete unwanted objects from a graphic or photo.

Data type

In a database, used to defined fields, such as text, date, or number.

Database

A type of application software used to create and manage data, such as customer names and addresses. Also, a collection of data, often organized and stored electronically.

Desktop publishing (DTP) software

Application software that combines word processing with advanced graphics capabilities to create documents such as flyers and newsletters.

Document

A file created by a word processor.

Document management tool

A program that helps protect and organize files; also used to collaborate with others.

Field

An object that stores the smallest part of a record, such as first name or last name, in a database.

Field name

A unique description assigned to a field in a table in the database so it can be identified.

Filter

In a Web search, a way to narrow a search to include only certain types of results, such as images or news, or pages posted in a certain date range, such as within the last 24 hours. In a database, a feature that selects a subset of records containing criteria you specify.

Font color

A characteristic of text that determines the color of each character.

Font size

A characteristic of text that determines the size of a character, measured in points; each point is 1/72 of an inch.

Font style

A characteristic of text that determines the visual effects of characters such as bold or italics.

Font type

A characteristic of text that defines that shape and form of characters; examples include Arial and Times New Roman.

Form

A database object used to enter and navigate records in a database.

Format

To change the way an object, text, or image appears on the screen.

Formula

In a worksheet, an entry that includes data such as values, functions, and mathematical operators to perform a calculation.

Function

In a worksheet, a predefined calculation such as SUM or AVERAGE.

Graphics

A type of application software used to create, view, manipulate, and print digital images such as photos, drawings, clip art, and diagrams.

Indent

A set point to determine where paragraph text begins on a line and where the next line begins after the wrapped text.

Insertion point

The blinking vertical bar displayed onscreen to mark your place and indicate where any typing will be inserted in a document.

Label

A key term associated with a blog post; in a worksheet, the descriptive text.

Line chart

A type of chart that uses lines to tracks trends over time.

Line spacing

A paragraph setting that determine how much white space to display between each line of text; can set before and after spacing; can be measured in points.

Local application

A software application installed on your computer's hard drive.

Macro

A mini program that performs a predefined action.

Margin

An area in a document between text and the edge of the page.

Mobile application

A program written specifically for mobile devices such as smartphones and tablets. Also called mobile app and Web app.

Native application

A program that has been designed to run on a specific operating system such as Android, IOs, or Windows. Also called native app.

Operator

In a formula, the mathematical symbol such as "+" or "−" or "*" or "/" for addition, subtraction, multiplication, or division

Page break

To specify a specific location for a new page to begin in a document regardless of the amount of text on the page.

Page orientation

The page layout of text on the page; can be portrait or landscape, vertical or horizontal.

Paragraph spacing

A paragraph setting that determines how much white space to display between each paragraph; can set before and after spacing; measured in points; affects document length.

Pivot table

A worksheet tool used to create meaningful data summaries to analyze worksheets containing large volumes of data.

Pixel

Short for picture element; a dot of light or color in an image or screen display.

Point

Measurement used to determine the height and size of a character; a point is 1/72 of an inch.

Portable application

Software that is stored on and run from portable removable storage devices such as CDs, DVDs, or flash drives; you connect the storage device to a computer to run the application.

Presentation

An electronic slide show.

Presentation software

Software used to create electronic slides for presentations and can include pictures, charts, audio, video, and animation.

Property

A characteristic of an object.

Query

In a database, a database object used to specify criteria that extract data based on criteria that the query creator specifies. Criteria are conditions for a field.

Record

A database object used to organize data in a database; consists of fields and is stored in tables.

Red eye

An effect that can happen when the flash from a camera is used to take a photo and results in a person appearing to have red eyes; you can use graphics tools to remove red eye.

Relational database

A database in which two or more tables are related (connected) with linked tables with common fields so that data doesn't have to be repeated, making it more prone to error.

Relative reference

In a worksheet, identifies a cell by its location relative to other cells and changes when a formula is moved or copied.

Report

In a database, a user-designed layout of data in a database.

Server

On a client/server network, a computer that controls the access of client computers to hardware, software, and other resources; the clients request services from the server.

Slide master

In presentation software, a slide that determines themes or formatting for all slides in a presentation based on that master.

Software application

A program you use to listen to music, edit photos, go to Web sites, check and send email, or perform another task when you are using a computer or smartphone. Also called application software program or app.

Sort

To arrange data or records using specific criteria, such as alphabetical or numerical in ascending or descending order.

Speech recognition software

A program that analyzes speech sounds and converts them into phonemes, which are then matched to words in a digital dictionary and written as text on a computer screen or accepted as voice input and interpreted as computer commands. Also called speech-to-text.

Spreadsheet

A grid of columns and rows used to store values and labels and formulas in a workbook. Also called worksheet.

Tab

A set point in a document to determine where text begins on a line in relation to the left margin.

Table

A database object used to organize and store data in a database; consists of fields and records organized in a grid of rows and columns, much like a worksheet.

Template

A document that contains formatting such as margins, fonts, and page layouts that you use to create new documents.

Thumbnail

In presentation software, a small version of each slide used to change the order of slides in the presentation. In graphics, a small version of an image; in operating systems, a view that displays a small version of a file.

Transition

A graphic that helps a person viewing a video or presentation know when one scene or slide ends and another begins.

Value

In a worksheet, a number, or the result of a formula that performs a numeric calculation.

Vector

A graphics format that uses mathematical formulas instead of pixels to define their appearance; tend to be simple images such as shapes, lines, and diagrams.

View

In a database, the way you display data such as Design view. In a word processor, the way you display the document such as Page view or Print preview; in a presentation application, the way you display slides in a presentation, such as Slide show view or Normal view.

Web application (Web app)

A program that resides on a server on the Internet, rather than a user's device, and is run through a Web browser. See also Native app.

Web-based application

Program that you access over the Internet in a browser on your computer or as an app on your mobile device that runs off the Internet, and often offer collaboration features that installed apps can't handle.

Web development software

A program that allows nontechnical users to create Web pages by automatically coding text with HTML tags.

What-if analysis

Software tools to test multiple scenarios by temporarily changing one or more variables to see the effect on related calculations.

Word processing

Creating, editing, formatting, viewing, printing, and publishing documents.

Word processing software

A program used to create, edit, format, view, print, and publish documents.

Workbook

A collection of worksheets in spreadsheet software.

Worksheet

The grid of columns and rows used to store values and labels and formulas in a workbook. Also called spreadsheet.

Students also viewed

CIS test 4

21 terms

mmarks12

TKT 1273 Computer Applications Chapter 4 Test

61 terms

Stephanie_Schisler

Computer Concepts Exam #12

5 terms

paolavelez-

Chapter 11 & 12 Quiz

49 terms

ben_stapleton2

Sets found in the same folder

Technology Now Chapter 2

111 terms

cis110atjcc

Technology Now Chapter 3

118 terms

cis110atjcc

Technology Now Chapter 5

113 terms

cis110atjcc

Technology Now Chapter 6

53 terms

cis110atjcc

Other sets by this creator

Technology Now Chapter 12

54 terms

cis110atjcc

Technology Now Chapter 10

36 terms

cis110atjcc

Technology Now Chapter 9

81 terms

cis110atjcc

Technology Now Chapter 8

64 terms

cis110atjcc

Verified questions

other

Which of the following statements about private club guests is CORRECT? Guests must pay for any service of alcoholic beverages. Guests own the alcoholic beverages of a private club. Guests are not permitted to pay for any service of alcoholic beverages. Guests must pay for any alcoholic beverages they consume.

Verified answer

other

What is the key to preventing accidents in a welding shop?

Verified answer

other

When is a wrecker considered to be an emergency vehicle? When they are loading along a roadway All of the answers are correct When their amber light is rotating or on When they performing a recovery along a roadway

Verified answer

other

Which of the following is part of the highway transportation system (HTS)? (a) vehicles (b) roadways (c) people (d) all of these

Verified answer

Other Quizlet sets

3-Vitamins and Minerals

179 terms

Fady2050

POR vs PARA

31 terms

Michael_Broderick

MHN Review 2

37 terms

AimeeLove87Plus

Federal Government

30 terms

jnance_32

What software is used to organize data into rows and columns?

Spreadsheet software is used to organize and manipulate numerical data. Numbers are organized on a grid of lettered columns and numbered rows.

Which software program organizes data in columns?

A spreadsheet is a computer program that can capture, display and manipulate data arranged in rows and columns.