Dr. L
Name Five Operators_
+ - * / ^
A key feature of Microsoft Excel is the ease with which you can ____.
Organize the data in a worksheet
When you ____________________ columns and/or rows, you lock them so you can keep an area visible as you scroll through the worksheet.
freeze
The operator for performing multiplication is the ____.
*
Name Three Wildcards used in Electronic Searches
* ? ~
The little black box at the bottom of a selected cell is called a/an
Fill Handle
If you enter hte, which feature will automatically change the text to the?
Auto correct
Which feature can Lino use to quickly fill in a series of dates?
Autofill
All shortcuts in Microsoft Word are the same in Excel. (True or False)
False
Contiguous means located at two or more points away from each other.
False
Dynamic means about the same thing as Static
False
Generally, values are used in formulas rather than cell references.
False
Logic is closely associated with Word Processing in the academic World, but not so much Excel.
False
The default currency formats in Excel are fixed and not subject to reformatting or changing.
False
To create an absolute cell reference, you insert an equal sign (=) before the column letter and/or row number of the cell reference you want to stay the same.
False
Using AutoFill is not as fast as copying and pasting.
False
When you add a new row, the data shifts up a row.
False
When you edit the data in a worksheet, you must edit the data in the chart as well
False
When you split a worksheet horizontally, the panes appear side by side on the screen
False
You can only have one Excel workbook open at a time
False
You cannot rename sheet tabs
False
When you ____________________ data, you screen data that matches specified criteria.
filter
You can use multiple fonts in one document
True
Zoom settings allow you to change the magnification.
True
The VLOOKUP AND HLOOKUP functions allow one to access data from spreadsheets other than the one currently
Viewed
Excel refers to a spreadsheet as a ____.
Worksheet
If text doesn't fit on one line, you can use the ____ button to allow all the text to wrap to new lines within the cell.
Wrap text
The ____ shows the cell contents
Formula bar
How can Sam remove the dividing line in the split worksheet?
click the remove split button
____ of the worksheet appear vertically and are identified by letters at the top of the worksheet window.
columns
A/an _________________ is an imaginary product used to teach an academic lesson or provide examples.
widget
Macy sees the error #NULL! in a cell of her worksheet. What is likely the problem?
A space is used where it is not appropriate
The formula =$A1 is an example of a(n) ____ cell reference
Absolute
The Name box shows the ____.
Active cell
When a cell is selected, it is called the ____.
Active cell
When you select a group of cells, the group is called a(n) ____________________.
range
Sections of Cells can be named and processed as individual entities, they are called named
.
____ are often used in summary worksheets to condense and total data from other worksheets.
3D references
All Excel formulas begin with ____.
=
Macy wants to show the organization's total dollar amount of dues collected in the cells B2 to B40. Which is the correct formula?
=SUM(B2:B4)
What is the arrow pointing to in Figure 17-2 above?
Cancel, enter, and insert function buttons
A1 and B4 are examples of ____.
Cell references
The ____ allows you to remove the contents and the formatting in a cell.
Clear button
What should Lino click to select an entire column so that he can change its formatting?
Column heading
Name Five Kinds of Charts
Column, Line, Pie, Bar, Area
A ____ is used to separate cell references that are not adjacent.
Comma
Formulas containing more than one operator are called ____.
Complex formulas
The ____ command scales the worksheet up or down as necessary so it fits on the number of pages you designate.
Fit to
Which button should she use to copy the formatting of a cell without copying the contents of the cell?
Format painter
When you enter text in a cell, it also appears in the ____.
Formula bar
Sam has selected a range of cells he wants to freeze. Which option will allow him to freeze panes based on selected cells?
Freeze panes
Which view hides the Ribbon, the formula bar, and the status bar?
Full screen
A(n) ____ is a special formula that names a function instead of using operators to calculate a result.
Function formula
A ____ contains column headings or field names in a data source, such as a table or spreadsheet.
Header row
Inserting this tools or feature allows for the use of Screen tips
Help Tools
Press the ____ key to move the insertion point to the first cell in a row.
Home
The Excel error ########## means?
The cell cannot fit the number
When you want to add a new category to an Excel workbook, you click the ____ at the bottom of the screen.
Insert worksheet button
____ are computer programs that are so necessary or desirable that they prove the core value of some larger technology, and as a result, they substantially increase the sales of the platform that they run on.
Killer Apps
Where are the sizing buttons that control the application and worksheet windows?
Lower right corner of the status bar
The ____ button spans text across several columns.
Merge and center
Which button is the black arrow pointing to in Figure 18-2 above?
Merge and center
This Man invented Lotus 123, the precursor to MS Excel
Mitch Kapor
Name four types or Categories of Data
Numbers, Text, Functions, Formulas
The sequence used to calculate the value of a formula is called the ____.
Order of evaluation
Which view separates the column and row labels from the worksheet cells?
Page layout
A ____ is identified by the cell in the upper-left corner and the cell in the lower-right corner, separated by a colon.
Range
A1:D4 is an example of a ____.
Range
____ is a mathematical function.
SUM
Kristin wants to insert three new columns. What should she do before executing the Insert Sheet Columns command?
Select three columns
Kristin is entering data in cells. Why does she see ### in some of the cells?
She entered more than can fit into the cell
____ at the bottom of the screen provide quick and easy access to worksheets
Sheet tabs
You can base a sort on as many as six columns.
True
When the header row scrolls out of view, it is difficult to identify the data. Which of the following is not an option to help overcome this problem?
Sort data
An alternative way to freeze rows and columns is to ____ a worksheet, which divides the worksheet into two panes.
Split
When using the AutoComplete feature, you can press ____ to accept a proposed entry
Tab
A + (plus sign) is an example of an operator
True
A formula consists of two components: an operand and an operator
True
AVERAGE is a statistical function.
True
Computer software engineer is one of the fastest growing occupations.
True
Computers evaluate and assess worksheet values.
True
Copying data saves you from having to enter the same data into another location
True
Excel has more than 400 built-in formulas for performing calculations.
True
The arrow keys move the insertion point one cell in any direction
True
The default Currency format has two decimal places and a dollar sign.
True
The way Excel determines data from equations is by the use of Operators.
True
Usually the top row of a worksheet is used for explanatory text or column headings that identify the type of data in each column.
True
Watermarks in excel are never recommended because Excel is not an Art Program
True
When a cell is selected, the column and row headings for the selected cell are highlighted.
True
When you delete the contents of a cell using the Delete key or the Backspace key, the formats for the cell remain in the cell.
True
When you insert or delete a row or a column in Excel, it affects the entire worksheet
True
A(n) ____________________ cell reference does not change when the formula is copied or moved to a new location.
absolute
The ____________________ is a value, a cell reference, a range, or text that acts as an operand in a function formula, and it is enclosed in parentheses after the function name.
argument
You can drag a column ____________________ to change the column width
boundary
A(n) ____________________ style is a set of predefined formats that you can apply to all the worksheet data with a single click.
cell
The intersection of a single row and a single column is called a(n) ____________________.
cell
Pablo decides a bar chart would illustrate the data more effectively. Which button will enable him to choose a new chart?
change chart type
____________________ orientation formats the document sideways with the long edge of the page at the top.
landscape
You can change the order of evaluation by using ____________________.
parenthesis
A(n) ____________________ is a grid of rows and columns into which you enter text data and numerical data.
spreadsheet