Cfa 3 Corrections/flashcards

Front 1

3. Footers will be printed immediately below the last line of data on the worksheet.

Back 1

False

Front 2

9. Chart pages are entire sheets that contain only chart information.

Back 2

False

Front 3

12. The If function is considered a financial function.

Back 3

False

Front 4

14. The only way to copy a worksheet in a workbook is to use the copy command on the
shortcut menu.

Back 4

False

Front 5

20. Formatting a worksheet could possibly change the data on the sheet.

Back 5

False

Front 6

24. The basic Microsoft Office Excel 2010 window includes seven Ribbon tabs that maybe
selected to view various command groupings.

Back 6

False

Front 7

25. To identify a cell, specify the row number first, followed by the column letter.

Back 7

False

Front 8

26. The quickest method to hide a
column or row in a worksheet is to
select the column or row and choose
hide from ____________.

Back 8

C. Shortcut menu

Front 9

28. An entire worksheet may be hidden
by choosing hide on the _________.

Back 9

A. Sheet tab shortcut menu

Front 10

29. The data in a PivotTable is ______
directly to worksheet cells.

Back 10

B. Not linked

Front 11

3. Footers will be printed immediately below the last line of data on the worksheet.

Back 11

False

Front 12

9. Chart pages are entire sheets that contain only chart information.

Back 12

False

Front 13

12. The If function is considered a financial function.

Back 13

False

Front 14

14. The only way to copy a worksheet in a workbook is to use the copy command on the
shortcut menu.

Back 14

False

Front 15

20. Formatting a worksheet could possibly change the data on the sheet.

Back 15

False

Front 16

24. The basic Microsoft Office Excel 2010 window includes seven Ribbon tabs that maybe
selected to view various command groupings.

Back 16

False

Front 17

25. To identify a cell, specify the row number first, followed by the column letter.

Back 17

False

Front 18

26. The quickest method to hide a
column or row in a worksheet is to
select the column or row and choose
hide from ____________.

Back 18

C. Shortcut menu

Front 19

28. An entire worksheet may be hidden
by choosing hide on the _________.

Back 19

A. Sheet tab shortcut menu

Front 20

29. The data in a PivotTable is ______
directly to worksheet cells.

Back 20

B. Not linked

Front 21

3. Footers will be printed immediately below the last line of data on the worksheet.

Back 21

False

Front 22

9. Chart pages are entire sheets that contain only chart information.

Back 22

False

Front 23

12. The If function is considered a financial function.

Back 23

False

Front 24

3. Footers will be printed immediately below the last line of data on the worksheet.

Back 24

False

Front 25

14. The only way to copy a worksheet in a workbook is to use the copy command on the
shortcut menu.

Back 25

False

Front 26

9. Chart pages are entire sheets that contain only chart information.

Back 26

False

Front 27

20. Formatting a worksheet could possibly change the data on the sheet.

Back 27

False

Front 28

12. The If function is considered a financial function.

Back 28

False

Front 29

14. The only way to copy a worksheet in a workbook is to use the copy command on the
shortcut menu.

Back 29

False

Front 30

24. The basic Microsoft Office Excel 2010 window includes seven Ribbon tabs that maybe
selected to view various command groupings.

Back 30

False

Front 31

20. Formatting a worksheet could possibly change the data on the sheet.

Back 31

False

Front 32

25. To identify a cell, specify the row number first, followed by the column letter.

Back 32

False

Front 33

24. The basic Microsoft Office Excel 2010 window includes seven Ribbon tabs that maybe
selected to view various command groupings.

Back 33

False

Front 34

26. The quickest method to hide a
column or row in a worksheet is to
select the column or row and choose
hide from ____________.

Back 34

C. Shortcut menu

Front 35

25. To identify a cell, specify the row number first, followed by the column letter.

Back 35

False

Front 36

28. An entire worksheet may be hidden
by choosing hide on the _________.

Back 36

A. Sheet tab shortcut menu

Front 37

29. The data in a PivotTable is ______
directly to worksheet cells.

Back 37

B. Not linked

Front 38

26. The quickest method to hide a
column or row in a worksheet is to
select the column or row and choose
hide from ____________.

Back 38

C. Shortcut menu

Front 39

28. An entire worksheet may be hidden
by choosing hide on the _________.

Back 39

A. Sheet tab shortcut menu

Front 40

29. The data in a PivotTable is ______
directly to worksheet cells.

Back 40

B. Not linked

Front 41

30. Which button will update the
PivotTable and Pivot Chart
information?

Back 41

C. Refresh

Front 42

31. Which of the following is not a
component of a data series?

Back 42

B. Series label

Front 43

33. ______ is an area that labels the data
used in a chart.

Back 43

A. Legend

Front 44

36. All of the following are Excel
arithmetic operators except
__________.

Back 44

D. >

Front 45

39. Which of the following is NOT an
appropriate worksheet tab name?

Back 45

C. Employee and Staff

Front 46

41. ________ temporarily hides records
that do not meet a specific criterion.

Back 46

C. Conditional Formatting

Front 47

44. By default, there are _______ date
formats that may be applied to a cell.

Back 47

A. 17

Front 48

49. Information on each ribbon is an
organized collection called a

Back 48

B. Group