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