# computer application ch 10 study guide essay

In an electronic spreadsheet, you need to manually recalculate when you change the entries.
False
An Excel workbook has the file extension .xml.
False
Charts are updated automatically in Excel whenever data changes.
True
You are in Edit mode any time you are entering or changing the contents of a cell.
True
Arguments are Excel’s built-in formulas.
False
You use formulas in Excel to perform calculations such as adding, multiplying, and averaging.
True
Page Layout View focuses on how the worksheet will look when printed.
True
When the paper orientation is set on landscape, the contents will print across the width of the page.
False
In Page Layout view, the dotted line indicates the print area.
True
A named range may begin a letter or number.
False
You can use a named range instead of a cell address in a formula.
True
An electronic ____ is an application you use to perform numeric calculations and to analyze and present numeric data.
In Excel, the electronic spreadsheet you work in is called a ____.
worksheet
In Excel, a worksheet is contained in a file called a ____.
workbook
You can use pre-designed, formatted files called ____ to create new worksheets quickly.
templates
You can use a spreadsheet to ____ by using variable values to investigate and sample different outcomes.
create what-if scenarieos
____ below the worksheet grid let you switch from sheet to sheet in a workbook.
sheet tabs
All Excel formulas begin with the ____.
equal sign (=)
The Excel operator for exponent is ____.
carrot (^)
The Excel operator for division is ____
/
A(n) ____ is an entry in a cell that contain text such as “2011 Sales” or “Travel Expenses.”
label
A(n) ____ is a built-in formula that uses arguments to calculate information.
function
Excel recognizes an entry as a value if it is a number or it begins with ____.
\$
You can use the ____ key(s) on the keyboard to navigate a worksheet.
arrow
To quickly jump to the first cell in a worksheet press ____.
[Ctrl][Home]
To quickly jump to the last cell in a worksheet press _____.
[Ctrl][End]
You can edit the contents of the active cell by ____.
just start typing
In a worksheet, the ____ is called the formula prefix.
equal sign (=)
____ operators perform mathematical calculations such as adding and subtracting.
aritmetic
Possible paper orientations for printing a worksheet are landscape and ____.
portrait
The ____ option helps fit the data on a single page without making changes to individual margins.
squeeze
You can use the ______________ slider on the status bar to enlarge your view of specific areas of your worksheet.
zoom
You can change, or ________, the contents of an active cell at any time.
edit
A dark rectangle that outlines the cell in which you are working
cell pointer
Provides a brief description of the active command or task in progress
status bar
Identified by the coordinates of the intersecting column and row