How can we help?

You can also find more resources in our Help Center.

Symmes EXCEL CH 1 Test Review

STUDY
PLAY
Workbooks
______ are a collection of worksheets
Cell
The intersection of each column and row is called a_________.
Mini
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.
text
In Excel, any set of characters containing a letter, hyphen or space is considered _____.
range
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 _______.
formatting
Changing the font type, changing the font style to bold, increasing the font size, and changing the font color is called ______.
merging
Combinbing two or maore cells together is called ______ cells.
splitting
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?
embedded
A(n) ____ chart is drawn on the same worksheet at the data.
worksheets
Excel opens a new workbook with 3 _____ at the bottom left corner of the screeen.
Ribbon
The ____ located near the top of the Excel Window is the control center in Excel.
Home
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.
Insert
The commands to insert a chart are located on the ___ tab.
AutoCalculate
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.
Workbook
A new blank _____ called Book 1 is lake a notebook and is created when Excel starts.
Worksheets
A workbook contains ____, each of which has a name that desplays on a sheet tab at the botoom of the workbook.
active
The cell into which data is being entered is referred to as the ______ cell.
gridlines
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.
Format
You ___ a worksheet to emphasize certain entries, change teh font size, add color to areas, and amke the owrksheet easier to read and understand.
gallery
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.
menu
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.
requirements
The person or persons requesting the worksheet should supply their requirements in a ____________ document.
number
In Excel, a _______________ can contain the characters 0 1 2 3 4 5 6 7 8 9 + - ( ) , / . $ % E e.