Advertisement Upgrade to remove ads

week 6 test

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 (;)

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set