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