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
