Exam 2: Microsoft Excel Basics

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

FIGURE EX 15-1 FIGURE EX 15-1   In Figure EX 15-1 above, item 2 points to a(n) ____. In Figure EX 15-1 above, item 2 points to a(n) ____.

(Multiple Choice)
4.9/5
(78)
Identify the letter of the choice that best matches the phrase or definition.
Premises:
A group of adjacent worksheets.
Responses:
Source
Worksheet range
Destination
Correct Answer:
Verified
Premises:
Responses:
A group of adjacent worksheets.
Source
(Matching)
4.8/5
(69)

To instantly create a chart in its own chart sheet, simply select the range of data you want in the chart and press ____.

(Multiple Choice)
4.9/5
(83)

A PivotTable lets you twist or rearrange the data.

(True/False)
4.9/5
(79)

The user cannot change the macro security level in Excel.

(True/False)
4.9/5
(62)

The results of the calculation appear in the cell in which the formula is entered.

(True/False)
4.7/5
(70)

You can consolidate data from several worksheets in the same workbook or between several workbooks.

(True/False)
4.8/5
(78)

You must use double brackets to enclose the text you want the IF function to return in the second and third arguments.

(True/False)
4.8/5
(80)

Moving a worksheet does not affect 3-D references in the workbook.

(True/False)
4.9/5
(78)

The formula =SUM(Sheet2:Sheet4!D12), adds the value from cell D12 in the Sheet2, Sheet3, and Sheet4 worksheets.

(True/False)
4.8/5
(82)
Showing 841 - 850 of 850
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)