BIS 220 Quiz

select all box

A box in the upper left corner of the worksheet grid that selects all the cells in a worksheet is the

active cell

A cell surrounded by a black border and ready to receive data is the

Freeze Panes

A command that enables you to select one or more rows or columns and lock them in place.

Merge & Center

A command that joins selected cells in an Excel worksheet into one larger cell and centers the contents in the merged cell

Date & Time

A command with which you can automatically insert the current date and time into a document

Left alignment

A commonly used alignment of text in which text is aligned at the left margin, leaving the right margin uneven.

All-in-one computer

A compact desktop computer with the system unit integrated into the monitor

SmartArt

A designer-quality graphic used to create a visual representation of information.

Router

A device that connects two or more networks together.

a cover letter

A document that you send with your resume to provide additional information about your skills and experience is:

Mobile application (mobile app

A downloadable program that extends the functionality of a mobile device

Quick Analysis tool

A feature that displays in the lower right corner of a selected range with which you can analyze your data by using Excel tools such as charts, color-coding, and formulas is called:

range finder

A feature that outlines cells in color to indicate which cells are used in a formula is called

Conditional format

A format that changes the appearance of a cell based on a condition.

IF function

A function that uses a logical test to check whether a condition is met, and then returns one value if true and another value if false.

Style

A group of formatting commands, such as font, font size, font color, paragraph alignment, and line spacing can be applied to a paragraph with one command.

Logical functions

A group of functions that test for specific conditions, and which typically use conditional tests to determine whether specified conditions are true or false.

Row

A horizontal group of cells in a worksheet.

Bibliography

A list of cited works in a report or research paper, also referred to as Works Cited, Sources, or References, depending upon the report style.

iOS

A mobile operating system that is a scaled-down version of macOS and that uses direct manipulation and multi-gesture touch such as swipe, tap, and pinch to control it.

Local area network (LAN)

A network that has all connected devices or nodes located in the same physical location.

Citation

A note inserted into the text of a research paper that refers the reader to a source in the bibliography.

Complementary closing

A parting farewell in a letter.

Client

A personal computer, and other devices, that connects to a server

Notebook

A portable personal computer. Also referred to as a laptop.

SUM function

A predefined formula that adds all the numbers in a selected range.

Function

A predefined formula that performs calculations by using specific values in a particular order or structure.

thesaurus

A proofing tool that provides a list of words with similar meanings is the:

table

A series of rows and columns that contains related data and that is managed independently from other data is an Excel:

data bar

A shaded bar that provides a visual cue about the value of a cell relative to other cells is a:

Data breach

A situation in which sensitive data is stolen or viewed by someone who is not authorized to do so.

Personal computer (PC)

A small microprocessor-based computer designed to be used by one person at a time

COUNTIF function

A statistical function that counts the number of cells within a range that meet the given condition and which has two arguments—the range of cells to check and the criteria.

Column

A vertical group of cells in a worksheet.

a synonym

A word with the same or similar meaning as another word is

summary sheet

A worksheet where totals from other worksheets are displayed and summarized is a:

Enclosures

Additional documents included with a business letter.

AutoFit

An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column is:

Workbook

An Excel file that contains one or more worksheets.

AVERAGE function

An Excel function that adds a group of values and then divides the result by the number of values in the group.

MAX function

An Excel function that determines the largest value in a range

MIN function

An Excel function that determines the smallest value in a range.

Justified alignment

An alignment of text in which the text is evenly aligned on both the left and right margins.

formula bar

An element in the Excel window that displays the value or formula contained in the active cell is the

name box

An element of the Excel window that displays the name of the selected cell, table, chart, or object is the

Formula

An equation that performs mathematical calculations on values in a worksheet.

Cell address

Another name for a cell reference.

Value

Another name for a constant value.

Spreadsheet

Another name for a worksheet.

Logical test

Any value or expression that can be evaluated as being true or false.

Cell content

Anything typed into a cell.

Formatting marks

Characters that display on the screen, but do not print, indicating where the Enter key, the Spacebar, and the Tab key were pressed.

Number values

Constant values consisting of only numbers.

Virtual private network (VPN)

Creates a private network through the public network (Internet), allowing remote users to access a local area network (LAN) securely without needing dedicated lines.

Phishing

Email messages and IMs that appear to be from those you do business with, designed to trick you into revealing information, such as usernames and passwords for your accounts.

Statistical functions

Excel functions, such as AVERAGE, that are useful to analyze a group of measurements.

Artistic effects

Formats that make pictures look more like sketches or paintings.

Picture styles

Frames, shapes, shadows, borders, and other special effects can be added to an image to create an overall visual style for the image.

Footnote

In a research paper, a note is placed at the bottom of the page.

Constant value

Numbers, text, dates, or times of day that you type into a cell.

American Psychological Association (APA)

One of two commonly used style guides for formatting research papers.

Ethernet

Standards that define the way data is transmitted over a local area network.

Cloud storage

Storage space on an Internet site that may also display as a drive on your computer

Data

Text or numbers in a cell

Bullets

Text symbols such as small circles or check marks that introduce items in a list.

print titles

The Excel command that enables you to specify rows and columns to repeat on each printed page is

flash fill

The Excel command that recognizes a pattern in your data and then automatically fills in the values when you enter examples of the desired output is:

Auto Fill

The Excel feature that generates and extends values into adjacent cells based on the values of selected cells is

Hacking

The act of gaining unauthorized access to a computer system or network.

paste

The action of placing cell contents that have been copied or moved to the Clipboard into another location is called

category axis

The area along the bottom of a chart that identifies the categories of data is the:

underlying value

The data that displays in the Formula Bar is referred to as the:

general format

The default format that Excel applies to numbers is the

Line spacing

The distance between lines of text in a paragraph.

Dateline

The first line in a business letter that contains the current date, and that is positioned just below the letterhead if a letterhead is used.

NOW function

The function that retrieves and then displays the date and time from your computer is the:

Chart

The graphic representation of data in a worksheet.

Salutation

The greeting line of a letter.

Cell

The intersection of a column and a row.

Sheet tabs

The labels along the lower border of the Excel window identify each worksheet.

sheet tabs

The labels along the lower border of the workbook window that identify each worksheet are the

Text wrapping

The manner in which text displays around an object.

Inside address

The name and address of the person receiving a letter and positioned below the date line.

Writer's identification

The name and title of the author of a letter, placed near the bottom of the letter under the complimentary closing.

Letterhead

The personal or company information that displays at the top of a letter

sorting

The process of arranging data in a specific order based on the value in each field is called:

filtering

The process of displaying only a portion of the data based on matching a specific value to show only the data that meets the criteria that you specify is called:

navigate

The process of moving within a worksheet or workbook:

Protocols

The rules for communication between devices.

Fill handle

The small black square in the lower right corner of a selected cell.

operators

The symbols with which you can specify the type of calculation you want to perform in an Excel formula are:

body

The text of a letter is the:

absolute

The type of cell reference that refers to cells by their fixed position in a worksheet is:

Data

The unprocessed, or raw form, of information

detail sheets

The worksheets that contain the details of the information summarized on a summary sheet are called:

sparklines

Tiny charts embedded in a cell that give a visual trend summary alongside your data are:

double blue underlines

To indicate possible grammar errors, Word flags text with:

Computer network

Two or more computers that share resources