FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: Working With Large Worksheets,Charting,and What-If Analysis

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Multiple Choice

Review LaterAdd Note

Review Later

When assigned to a cell,the ____ function returns a number that corresponds to the system date and time beginning with December 31,1899.

A) SYSDATE
B) NOW
C) DATETIME
D) CURRENT

E) A) and C)
F) A) and B)

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Pastes the contents,format,and styles of the source area.

A) NOW function
B) Fill Formatting Only
C) goal seeking
D) what-if analysis
E) NUM!
F) #NAME?
G) Keep Source Formatting
H) Fill Series
I) IF function
J) absolute cell referencing

K) B) and E)
L) A) and F)

Correct Answer

verified

Show Answer

Question 43

True/False

Review LaterAdd Note

When Excel cannot calculate a formula,it displays an error message in a cell.

____________________ are values in cells that can be changed to determine new values for formulas.

The ____________________ at the bottom of the Fill Color and Font Color buttons changes to the most recently selected color.

Which of the following formulas contains an absolute cell reference?

The ____ function is useful when you want to assign a value to a cell based on a logical test.

You should use a ____ chart to compare values side by side,broken down by category.

You can nest IF functions as deep as you want,but after you get beyond a nest of three IF functions,the logic becomes difficult to follow.

When the Paste Options button is visible,you can use ____________________ to access the paste commands available in the Paste Options gallery.

After shrinking entries to fit in cells,consider using the ____ slider on the status bar to make the entries more readable.

In the context of copying a range of cells to a nonadjacent location,an alternative to clicking the Paste button is to press the ____ key.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Assigns a value to a cell based on a logical test.

You can press the ____ keys to open the Format Cells dialog box.

You can replace a formula with its function so it remains constant._________________________

A date stamp shows the date a workbook,report,or other document was created or the time period it represents.

The Linked Pictures option in the Paste Options gallery copies an image of the source area as a picture so that a change to the cells in the source area updates the picture in the destination area.

George runs a mid-size accounting practice and recently upgraded to Excel 2013. He expects sales to grow in the next few months during tax season. After that, he would like to begin upgrading some of the equipment and furniture for the employees in his office. He will start with the Reception area, which has the most visibility. -If sales reach a certain amount by the end of April,George will purchase a desk,chair,computer,and software upgrade for the receptionist.Otherwise,George will just purchase the desk and chair.How can George determine the best action to take using a Sales Data worksheet?

The ____________________ function is useful when you want to assign a value to a cell based on a logical test.

You can create your own ____________________ fill sequences for use with the fill handle.