BIS 220 Quiz
An Excel function that adds a group of values and then divides the result by the number of values in the group.
AVERAGE function
A compact desktop computer with the system unit integrated into the monitor.
All-in-one computer
A self-contained program usually designed for a single purpose and that runs on smartphones and other mobile devices.
App
Formats that make pictures look more like sketches or paintings.
Artistic effects
The Excel feature that generates and extends values into adjacent cells based on the values of selected cells is:
Auto Fill
An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column is:
AutoFit
Text symbols such as small circles or check marks that introduce items in a list.
Bullets
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.
COUNTIF function
The intersection of a column and a row.
Cell
Another name for a cell reference.
Cell address
Anything typed into a cell.
Cell content
The graphic representation of data in a worksheet.
Chart
A personal computer, and other devices, that connects to a server.
Client
Storage space on an Internet site that may also display as a drive on your computer.
Cloud storage
A vertical group of cells in a worksheet.
Column
A parting farewell in a letter.
Complementary closing
Two or more computers that share resources.
Computer network
A format that changes the appearance of a cell based on a condition.
Conditional format
Numbers, text, dates, or times of day that you type into a cell.
Constant value
Legal protection for literary and artistic works.
Copyright
Conditions that you specify in a logical function.
Criteria
Text or numbers in a cell.
Data
The unprocessed, or raw form, of information.
Data
A situation in which sensitive data is stolen or viewed by someone who is not authorized to do so.
Data breach
A command with which you can automatically insert the current date and time into a document is:
Date & Time
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.
Dateline
Conducting business on the web.
E-commerce
Additional documents included with a business letter.
Enclosures
Standards that define the way data is transmitted over a local area network.
Ethernet
The small black square in the lower right corner of a selected cell.
Fill handle
Characters that display on the screen, but do not print, indicating where the Enter key, the Spacebar, and the Tab key were pressed
Formatting marks
An equation that performs mathematical calculations on values in a worksheet.
Formula
A command that enables you to select one or more rows or columns and lock them in place.
Freeze Panes
A predefined formula that performs calculations by using specific values in a particular order or structure.
Function
The act of gaining unauthorized access to a computer system or network.
Hacking
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.
If Function
The name and address of the person receiving a letter and positioned below the date line.
Inside address
An alignment of text in which the text is evenly aligned on both the left and right margins.
Justified alignment
A commonly used alignment of text in which text is aligned at the left margin, leaving the right margin uneven.
Left alignment
The personal or company information that displays at the top of a letter.
Letterhead
The distance between lines of text in a paragraph.
Line spacing
A professional social networking site.
A network that has all connected devices or nodes located in the same physical location.
Local area network (LAN)
A group of functions that test for specific conditions, and which typically use conditional tests to determine whether specified conditions are true or false.
Logical functions
Any value or expression that can be evaluated as being true or false.
Logical test
An Excel function that determines the largest value in a range.
MAX function
An Excel function that determines the smallest value in a range.
MIN function
A command that joins selected cells in an Excel worksheet into one larger cell and centers the contents in the merged cell:
Merge & Center
A downloadable program that extends the functionality of a mobile device.
Mobile application (mobile app)
The function that retrieves and then displays the date and time from your computer is the:
NOW function
A portable personal computer. Also referred to as a laptop.
Notebook
Constant values consisting of only numbers.
Number values
Legal protection for inventions.
Patent
A small microprocessor-based computer designed to be used by one person at a time.
Personal computer (PC)
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.
Phishing
Frames, shapes, shadows, borders, and other special effects that can be added to an image to create an overall visual style for the image.
Picture styles
The rules for communication between devices.
Protocols
Works not restricted by copyright.
Public domain
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:
Quick Analysis tool
device that connects two or more networks together.
Router
A horizontal group of cells in a worksheet.
Row
A predefined formula that adds all the numbers in a selected range.
SUM function
The greeting line of a letter.
Salutation
A computer program that searches for specific words and returns a list of documents in which the search term was found.
Search engine
The labels along the lower border of the Excel window that identify each worksheet.
Sheet tabs
A designer-quality graphic used to create a visual representation of information.
SmartArt
Another name for a worksheet
Spreadsheet
Excel functions, such as AVERAGE, that are useful to analyze a group of measurements.
Statistical functions
The manner in which text displays around an object.
Text wrapping
Another name for a constant value.
Value
Creates a private network through the public network (Internet), allowing remote users to access a local area network (LAN) securely without needing dedicated lines.
Virtual private network (VPN)
An Excel file that contains one or more worksheets
Workbook
The name and title of the author of a letter, placed near the bottom of the letter under the complimentary closing.
Writer's identification
The type of cell reference that refers to cells by their fixed position in a worksheet is:
absolute
A cell surrounded by a black border and ready to receive data is the:
active cell
The text of a letter is the:
body
The area along the bottom of a chart that identifies the categories of data is the:
category axis
A shaded bar that provides a visual cue about the value of a cell relative to other cells is a:
data bar
The worksheets that contain the details of the information summarized on a summary sheet are called:
detail sheets
To indicate possible grammar errors, Word flags text with:
double blue underlines
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:
filtering
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:
flash fill
An element in the Excel window that displays the value or formula contained in the active cell is the:
formula bar
The default format that Excel applies to numbers is the:
general format
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.
iOS
An element of the Excel window that displays the name of the selected cell, table, chart, or object is the:
name box
The process of moving within a worksheet or workbook:
navigate
The symbols with which you can specify the type of calculation you want to perform in an Excel formula are:
operators
The action of placing cell contents that have been copied or moved to the Clipboard into another location is called:
paste
The Excel command that enables you to specify rows and columns to repeat on each printed page is:
print titles
A feature that outlines cells in color to indicate which cells are used in a formula is called:
range finder
box in the upper left corner of the worksheet grid that selects all the cells in a worksheet is the:
select all box
The labels along the lower border of the workbook window that identify each worksheet are the:
sheet tabs
The process of arranging data in a specific order based on the value in each field is called:
sorting
Tiny charts embedded in a cell that give a visual trend summary alongside your data are:
sparklines
A worksheet where totals from other worksheets are displayed and summarized is a:
summary sheet
A word with the same or similar meaning as another word is:
synonym
A series of rows and columns that contains related data and that is managed independently from other data is an Excel:
table
A proofing tool that provides a list of words with similar meanings is the:
thesaurus
The data that displays in the Formula Bar is referred to as the:
underlying value
