CBA EXCEL - 3RD 9 WEEKS TEST
Terms in this set (33)
A term used to describe how formulas remain constant and do not change when they are copied in Excel.
The cell inside of Excel which is currently selected and ready to receive data. The active cell in Excel is displayed with a black border around it.
An Excel feature which automatically enters contextual numbers and text into a specified cell range.
A preset formula in Excel used to process the average numeric value of a cell range.
Similar to a column chart.
An individual box of an Excel document that is formed by the intersection of a row and a column. Each cell can contain text.
A group of at least two or more cells on an Excel worksheet.
A series of cells arranged vertically within an Excel worksheet.
A chart in Excel which is used to display data in vertical columns.
A type of formatting Excel executes on cells automatically if certain conditions are met.
The cell range a user designates to be copied to a new area in an Excel workbook.
A formula used in Excel to simply display the number of cells there are in a range of cells.
A combination of the COUNT and IF functions. It is used to count the number of cells in a range given specific parameters.
A data presentation method which is used to display data in Excel in a more visual manner.
A Microsoft Office application which acts as a spreadsheet application that provides intricate mathematical formatting and data analysis.
A tool inside of an Excel table which is used to sort columns and rows according to the users needs.
A set of mathematical instructions in Excel which can be used to add.
An area inside of Excel above the column headers which displays the contents of the active cell. The formula bar also displays information such as text or formulas.
An Excel feature which allows all information above or to the left of a specified point to be frozen in place. This allows items such as titles to be viewed even when scrolling. Items can be frozen both vertically and horizontally.
A preset formula used in Excel to prevent common syntax errors.
A conditional function in Excel which is used to test whether a cell meets certain requirements. The formula will return a True or False depending on the outcome.
A function in Excel used to move a number of characters and numbers from one cell to another based on user specifications starting from the left side of the cell.
A function in Excel used to make every character in a cell range lowercase.
A chart often used with data that requires a secondary axis. It displays data in a simple line.
Similar to the MIN function.
Similar to the LEFT function.
A function used in Excel to display the smallest number value in a range of cells.
Merge & Center
A tool used in Excel to merge the contents of one or more cells and place the contents in the center of the merged cells.
A field in the upper-left corner of an Excel worksheet which displays the current name or address of the active cell.
A range of cells in Excel which have been grouped together in order to summarize data within an Excel worksheet.
Page Break Preview
A type of worksheet view which shows the user how a worksheet will be printed.
The default print orientation which allows a worksheet to be printed vertically.
A type of cell range in Excel. It is used to designate a range of cells to be printed when the user does not wish to print the entire worksheet. If there is a print area on a worksheet.
YOU MIGHT ALSO LIKE...
ASCP MLT/MLS Certification Exam (BOC) Preparation
College Computing Exam Excel
College Computing Exam Excel
CST 170 unit 3 Trems
OTHER SETS BY THIS CREATOR
MHS FALL 2018 SEMESTER TEST
Computer Basics - Hardware, Storage, Software, File Management, ICT BLOCK LETTER and MODIFIED BLOCK LETTER, MLA Reports
MHS CBA FALL SEMESTER TEST 2018