Symmes EXCEL CH 1 Test Review

33 terms by RHSComputerApps 

Create a new folder

Advertisement Upgrade to remove ads

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.

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set