Excell 2010 Ch.2 Multiple Choice

6 terms by azarate

Create a new folder

Advertisement Upgrade to remove ads

If cell D15 contains the formula =$C$5*D15, what is the D15 in the formula?

circular reference

What function would most appropriately accomplish the same thing as =(B5+C5+E5+F5)/5?

=AVERAGE(B5:F5)

When you type a function, what appears after you type the opening parenthesis?

Function Screen Tip

A formula containing the entry=$B3 is copied to a cell one column to the right and two rows down. How will the entry appear in its new location?

=$B5

Cell B10 conatins a date, such as 1/1/2012. which formula will determince how many days are between that date and the current date, given that the cell containing the formula is formatted with Number Format?

=TODAY()-B10

Which of the following is not at appropriate use of the SUM function?

=SUM(D15-C15)

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