Symmes EXCEL CH 1 Test Review


Terms in this set (...)

______ are a collection of worksheets
The intersection of each column and row is called a_________.
The _____ toolbar, which appears automatically based on tasks you perform (such as selecting text), contains commands related to changing the appearance of text in a worksheet.
In Excel, any set of characters containing a letter, hyphen or space is considered _____.
A _______ is a series of two or more adjacent cells in a column or row or a rectangular group of cells.
destination area (paste area)
The cell being copied is called the source aea (or copy area). The range of cells receiving the copy is called the _______.
Changing the font type, changing the font style to bold, increasing the font size, and changing the font color is called ______.
Combinbing two or maore cells together is called ______ cells.
Dividing a cell into more than one cell is called __________.
Causes cells with two decimal places to align vertically correctly
What effect does the Accounting Number Format have on the selected cells?
Causes the cells to display with two decimal places and commas as thousands separators
What effect does the Comma Style format have on the selected cells?
A(n) ____ chart is drawn on the same worksheet at the data.
Excel opens a new workbook with 3 _____ at the bottom left corner of the screeen.
The ____ located near the top of the Excel Window is the control center in Excel.
the ___ tab is called the primary tab of the Ribbon.
Quick Access Toolbar
The ____, located by default above the Ribbon, provies easy access to frequently used commands.
The commands to insert a chart are located on the ___ tab.
By using the _______ area on the status bar, you easily can obtain a total, an average, or other infomration about the numbers in a range.
Microsoft Excel
_____ is a powerful spreadsheet program that allows users to organize data, complete calculations, make decisions, graph data, develop professional looking reports, publish organized data to the Web, and acceess real-time data from Web sites.
A new blank _____ called Book 1 is lake a notebook and is created when Excel starts.
A workbook contains ____, each of which has a name that desplays on a sheet tab at the botoom of the workbook.
The cell into which data is being entered is referred to as the ______ cell.
The horizontal and vertical lines on the worksheet are called ____ and make it easier to see and identify each cell.
status bar
The ___ presents information about the worksheet, the function of the button the mouse pointer is pointing to, or the mode of excel.
formula bar
As you type, Excel displays the entry in the _______, and also displays the active cell reference int he Name box on the left.
You ___ a worksheet to emphasize certain entries, change teh font size, add color to areas, and amke the owrksheet easier to read and understand.
A set of choices, often graphical, arranged in a grid or in a list.
if you lose power, the worksheet could be lost.
Saving the workbook frequently is important because __________.
fill handle
The ___________ is the small black square located in the lower-right corner of the heavy border around the active cell and is used to copy a formula from one cell to an adjacent cell or range of cells.
A ______________ contains a list of commands.
enhanced screen tip
A(n) _________________ is an on-screen note that provides the name of the command, available keyboard shortcuts, a description of the command, and sometimes instructions for how to obtain Help about the command.
The person or persons requesting the worksheet should supply their requirements in a ____________ document.
In Excel, a _______________ can contain the characters 0 1 2 3 4 5 6 7 8 9 + - ( ) , / . $ % E e.