Excel Flashcards
A command that joins selected cells in an Excel worksheet into one larger cell and centers the contents in the merged cell:
Merge and Center
An element in the Excel window that displays the value or formula contained in the active cell is the:
Formula Bar
An element of the Excel window that displays the name of the selected cell, table, chart, or object is the:
Name Box
A box in the upper left corner of the worksheet grid that selects all the cells in a worksheet is the:
Select All Box
A cell surrounded by a black border and ready to receive data is the:
Active Cell
The Excel feature that generates and extends values into adjacent cells based on the values of selected cells is:
Auto Fill
The default format that Excel applies to numbers is the:
General Format
The data that displays in the Formula Bar is referred to as the:
Underlying Value
The type of cell reference that refers to cells by their fixed position in a worksheet
Absolute
Tiny charts embedded in a cell that give a visual trend summary alongside your data are:
Sparklines
An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column is:
Auto Fit
The symbols with which you can specify the type of calculation you want to perform in an Excel formula are
Operators
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
The area along the bottom of a chart that identifies the categories of data is the:
Category Axis
A feature that outlines cells in color to indicate which cells are used in a formula is called:
Range Finder
A shaded bar that provides a visual cue about the value of a cell relative to other cells is a:
Data Bar
The function that retrieves and then displays the date and time from your computer is the:
NOW Function
The process of moving within a worksheet or workbook:
Navigate
A series of rows and columns that contains related data and that is managed independently from other data is an Excel:
Table
The process of arranging data in a specific order based on the value in each field is called:
Sorting
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 enables you to specify rows and columns to repeat on each printed page is:
Print Titles
The labels along the lower border of the workbook window that identify each worksheet are the:
Sheet Tabs
A worksheet where totals from other worksheets are displayed and summarized is a:
Summary Sheet
