tech exam 1
absolute cell references are indicated by using what symbol in the cell address
$
which is the excel operator for multiplication
*
which Is the excel operator for division
/
all excel formulas begin with which symbol
=
which is the excel operator for exponentiation
^
a group of items that come one after another in succession is called
a series
the ___ inserts a thousand comma separator when appropriate, inserts a fixed US dollar sign aligned at the left edge of the cell, applies two decimal places, and provides space for negative numbers to be displayed inside of parentheses
accounting number format
the ___ when outlined in black, indicates it is ready to accept data
active cell
excel uses ___ to perform basic mathematical operations
arithmetic operators
the ___ feature fills in the remaining characters of a word if what is typed matches an exisiting entry in the column
auto complete
generates and extends a series of values into adjacent cells based on the values of other cells
auto fill
to widen a column to fit the cell content of the widest cell in the column use
auto fit
labels that display along the bottom of a chart to identify the category of the data are called
category labels
a ___ is created when a row and column intersect
cell
anything you type into a cell is referred to as
cell content
____ are defined as sets of formatting characteristics, such as font, font size, font color, cell borders, and cell shading
cell style
to make data easier to understand, use a ___ instead of a table of numbers
chart
a data marker, such as a column, dot, or pie slice on a chart represents a single
data point
charted values that orginals in a worksheet are called
data points
in an excel chart, a ___ is made up of related data points
data series
the data you see if a cell is called the
displayed value
by default, text values entered into a cell are right justified
false
in excel, column headings are made up of a letter and a digit, such as A2
false
in excel, numbers are used as column headings
false
the only kinds of values that can be entered into a cell are text values and numbers values
false
the small black square in the lower right corner of a selected cell is called the
fill handle
the process of specifying the appearance of cells and the overall layout of a worksheet is called
formatting
the result of a formula displays in the active cell, and the ___ itself displays in the formula bar
formula
in the ___ you can enter a value or a fomula or edit a value or formula in the active cell
formula bar
a prewritten formula known as a ___ looks at one or more values, performs an operation, and returns a value
function
a text value is also referred to as a
label
on an excel chart, the ___ identifies the patterns or colors that are assigned to all the categories in the chart
legend
excel's ____ command creates one cell from the selected cells and centers the contents within the new cell
merge and center
displays the name of the selected cell, table, chart, or object
name box
to center worksheet data horizontally and vertically on a page, use he ___ dialog box
page set up
two or more cells that excel treats as a single unit is called
range
in a cell that contains a formula the ___ visually indicates which workbook cells are included in a formula calculation
range finder
shrinks the width and height of the printed worksheet to fit a maximum number of pages
scaling
identifies a worksheet in a workbook
sheet tab
tiny charts embedded in cells that show a visual trend alongside the data are called
sparklines
the current cell mode, the page number and view and zoom button displated on the
status bar
cell contents are either values or formulas
true
number values are often called labels
true
text values usually are used to provide information about the numbers displayed in worksheet cells
true
the cell of the worksheet that is ready to accept data is known as the active cell
true
the term worksheet and spreadsheet are interchangeable
true
the formula bar displayed the data known as the
underlying value
an excel document is called
workbook
___ is formatted as a pattern of uniformly spaced horizontal rows and vertical columns
worksheet
the individual pages of an excel document are called
worksheets
