How can we help?

You can also find more resources in our Help Center.

71 terms

gg cis-120

week 6 test
STUDY
PLAY
an alternative to clicking the paste button is to press the._BLANK._ key
enter
the insert option button list formatting options
TRUE
exel includes._BLANK._ database functions that allow you to evaluate numeric data in a table
12
path --fill button
home/editing
point mode allows you to._BLANK._
select cell for use in a formula using the mouse pointer
formatting that appears only when the value in a cell meets conditions that you specify is called coditional formatinng
TRUE
the ammortization schedule summarizes loan info over the life of the loan
TRUE
excel is case sensative wih respect to names of cells
FALSE
the standard accounting format for a table or numbers contains floating dollar signs in the first row and the title row
TRUE
the equal sign = precedes a formula
TRUE
when you change a value on which a chart is dependent, excell immediately redraws the chart bsed on the new value
TRUE
to clear the entire worksheet clickthe clear all button on the worksheet
FALSE
using the mouse to move or copy cells is called
drag and drop
ecels capability of drilling data through worksheets is an inefficient way to enter data that is common among worksheet
FALSE
data tables must be built in an ._BLANK._ area of a worksheet
unused
when selecting worksheet titles and subtitles follow the more is less guideline
FALSE
excel derives the chart scale based on the value in theworksheet along the vertical axis also called the y-axis of the chart
TRUE
excel derives the chart scale based on the value in theworksheet along the vertical axis also called the y-axis of the chart
TRUE
which comparison operator means not equal to
< >
to enter a number such as 6000000000 you can type 6000000000000 or
6.00E+15
the ._BLANK._function is used when the table direction is horizonal
hlookup
the <= comparison operator means less than or equal to
TRUE
to cancel an entire entry before entering it into cell-press the ._BLANK._key
...
a requirements document includes a needs statement soucre of data summary of calculations and any other requiements for a wooksheet
TRUE
as shown in the accompanying figure excel automatically selects the left column check box in the create names from selection dialog box
TRUE
the sum button menu allows you to enter one of five often-used functions easilt into a cell
TRUE
the increase indent button indents the contents of a cell to the right by._BLANK._spaces each time you click it
three
excel uses the default Oriel theme for all new workbooks
FALSE
excel can display characters in only three font colors--- black,red,blue
FALSE
a cell ._BLANK._often is created from column or row titles
name
the copy button copies the content and format of the source area to the office._BLANK._,a reserved place in the computers memory
clipboard
to paste copied cell content, you can press the ._BLANK._keys
ctrl+v
to copy cell content, you can select the cell and then press the ._BLANK._keys
ctrl+c
data that include years both before and after the year 2000 should be formatted with a two-digit year
FALSE
excel remembers the last._BLANK._actions you have completed
100
the DAVERAGE function counts the number of numric entries in a table field that pass a test
FALSE
it is recommended that you use the ._BLANK._funstion on formulas that potentially can result in more decimal places than the applied format displays
round
path---logical button-------formula/function library group
TRUE
._BLANK._format codes allow you to specify how a cell enty assigned a format will appear
custom
the first step in creating a consolidation workbook is to create the consolidated worksheet,
TRUE
how many chart tpes do excel offer
11
if you do not assign a format to a cell or cells in a column, the column width remain._BLANK._characters
8.43
when building a worksheet for novice user, you should ._BLANK._the cells in the worksheet that you do not want changed such as cells that contain text or formulas
protect
to fill a linear series using the fill handle, hold down the ._BLANK._key as you drag through the range
ctrl
path-----insert cell button
home/cell
rather than setting a print area each time you want to print a range, you can._BLANK._the range
name
like the autofilter querytechnique, the._BLANK._command displays a subset of the table
advanced filter
excel Is a true true database management system
FALSE
a._BLANK._is a refernce to a cell or range of cells in another workbook
link
the following sequec, jan,feb,mar,etc. is an example of a._BLANK._series
date
an organization ma keep data from various departments or regions in different worksheets in the same workbook
TRUE
placing more than one table on the same worksheet is recommended
FALSE
data tables have multiple purposes
FALSE
path---total row check box
table tool design/table style
to enter a number as text, precede it with a
apostrophe (')
you should press the spacebar to clear a cell
FALSE
the most popular background color is._BLANK._
blue
you can use the round function to determine how much the borrower of the loan still owes at the end of the year
FALSE
when a series of @@@@signs or symbols appears in a cell that should contain a date, the formatted data does not fit in the width of the cell
FALSE
when you decrease the row height to ._BLANK._ the row is hidden
0
if columns contain sensitive information, such as salary information, you can._BLANK._ the column
hide
you._BLANK._a worksheet to emphasize certain entries and make the worksheet easier to read and understand
format
the print area box accepts a name or a ._BLANK._to print
range
you should hold down the ._BLANK._key to select the nonadjacent cells
CTRL
you can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in cell editing
TRUE
HLOOKUP uses the same arguments as VLOOKUP
TRUE
names are ._BLANK._to the workbook
global
which of the following are steps to create a table
pick four
you can choose which rules you want excel to use by enabling and disabling them in the ______area in the excel options dialog box
formulas
when you set up a worksheet you should use cell reference in formulas whenever possible rather than._BLANK._values
constant
which of the following is not a valid format symbol
semi-colon (;)