Question 1

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.

Accepted Answer

Linked Pictures option in the Paste Options gallery creates a dynamic link between the source area and the destination area. Any changes made in the source area will be reflected in the picture in the destination area.

Question 2

The syntax of the IF function is IF(logical_test), value_if_false, value_if_true).

Accepted Answer

The correct syntax of the IF function is IF(logical_test, value_if_true, value_if_false).

Question 3

The NETWORKDAYS function checks a formula for correctness.

Accepted Answer

The NETWORKDAYS function in Excel is used to calculate the number of working days between two dates. It does not check the correctness of any formula.

Question 4

A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function.

Accepted Answer

A nested IF function contains one or more IF functions as arguments in the true or false case.

Question 5

If you drag the fill handle to the left or up, Excel will increment the series rather than decrement the series.

Accepted Answer

If you drag the fill handle to the left or up, Excel will decrement the series rather than increment the series.

Question 6

The <= comparison operator means less than or equal to.

Accepted Answer

The <= comparison operator is true if the left operand is less than or equal to the right operand.

Question 7

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

Accepted Answer

A date stamp is used to indicate the date or time period that a document was created or represents.

Question 8

A cell reference with only one dollar sign before either the column or the row is called an absolute reference.

Accepted Answer

A cell reference with only one dollar sign before either the column or the row is called a mixed reference. An absolute reference has both dollar signs, one before the column and one before the row (e.g. $A$1).

Question 9

The Increase Indent button indents the contents of a cell to the right by three spaces each time you click it.

Accepted Answer

This is correct, the Increase Indent button in Excel indents cell contents to the right by three spaces with each click.

Question 10

Rotated text allows you to fit more text into a smaller column width.

Accepted Answer

Rotating text can help fit more text into a smaller column width by allowing the text to take up less horizontal space.

Question 11

Text in a cell can be rotated counterclockwise by entering a number in the Alignment sheet in the Format Cells dialog box. Which of the following are valid values for that number?
A) 15
B) 90
C) 145
D) 180

Accepted Answer

The answer of Text in a cell can be rotated...

Question 12

Which of the following are formatting symbols?
A) Dollar sign ($)
B) Comma (,)
C) Pound sign (#)
D) Percent sign (%)

Accepted Answer

The answer of Which of the following are formatting symbols?
A)...

Question 13

Following the insertion of a row, the Insert Options button lets you select from which of the following options?
A) Format Same As Above
B) Undo Formatting
C) Format Same As Below
D) Clear Formatting

Accepted Answer

The Insert Options button in many spreadsheet and table applications, such as Microsoft Excel, allows users to quickly format a newly inserted row. The options typically include formatting the new row the same as the one above (A), formatting it the same as the one below (C), or clearing any specific formatting to revert to a default style (D). "Undo Formatting" is not a standard option directly associated with the Insert Options button's functionality for newly inserted rows.

Question 14

A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area.

Accepted Answer

Relative cell references change based on the position of the formula when it is copied or moved to different locations in the worksheet. They adjust to the new position while staying relative to the original cell reference.

Question 15

Excel allows you to rotate text in a cell counterclockwise by entering a number between -1 degrees and -90 degrees.

Accepted Answer

The answer of Excel allows you to rotate text in...

Question 16

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

Accepted Answer

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

Question 17

If the contents of a cell copied using the fill handle is Sunday and Tuesday, what are the next three values of the extended series?
A) Wednesday
B) Thursday
C) Saturday
D) Monday

Accepted Answer

The answer of If the contents of a cell copied...

Question 18

The path to the Logical button is (FORMULAS tab | Function Library group).

Accepted Answer

The Logical button can be found on the FORMULAS tab, which is located on the ribbon interface. In the Function Library group, you can also access other useful functions such as Statistical, Math & Trig, and Date & Time.

Question 19

The incorrect use of copying, deleting, inserting, and moving ranges of cells has the potential to render a worksheet useless.

Accepted Answer

The incorrect use of these actions can cause data to become misplaced, formulas to break, and disrupt the overall functionality of the worksheet. It is important to use caution and carefully choose which cells to perform these actions on.

Question 20

The arguments in an IF function are ____.
A) logical_test
B) value_if_true
C) value_if_true_false
D) value_if_false

Accepted Answer

The arguments in an IF function are logical_test, value_if_true, and value_if_false. There is no argument called value_if_true_false, so option C is incorrect.

Quiz 4: Working With Large Worksheets, Charting, and What-If Analysis

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.

The syntax of the IF function is IF(logical_test), value_if_false, value_if_true).

The NETWORKDAYS function checks a formula for correctness.

A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function.

If you drag the fill handle to the left or up, Excel will increment the series rather than decrement the series.

The <= comparison operator means less than or equal to.

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

A cell reference with only one dollar sign before either the column or the row is called an absolute reference.

The Increase Indent button indents the contents of a cell to the right by three spaces each time you click it.

Rotated text allows you to fit more text into a smaller column width.

Text in a cell can be rotated counterclockwise by entering a number in the Alignment sheet in the Format Cells dialog box. Which of the following are valid values for that number?

Which of the following are formatting symbols?

Following the insertion of a row, the Insert Options button lets you select from which of the following options?

A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area.

Excel allows you to rotate text in a cell counterclockwise by entering a number between -1 degrees and -90 degrees.

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

If the contents of a cell copied using the fill handle is Sunday and Tuesday, what are the next three values of the extended series?

The path to the Logical button is (FORMULAS tab | Function Library group).

The incorrect use of copying, deleting, inserting, and moving ranges of cells has the potential to render a worksheet useless.

The arguments in an IF function are ____.