1 / 63

Microsoft® Office 2007

Microsoft® Office 2007 . Excel Chapter 3: MC-Quiz: What-If Analysis, Charting, and Working with Large Worksheets. Question 1. Question 15. Question 8. Multiple Choice Main Menu What-If Analysis, Charting and Working with Large Spreadsheets. Question 2.

marcie
Download Presentation

Microsoft® Office 2007

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Microsoft® Office 2007 • Excel Chapter 3: • MC-Quiz: What-If Analysis, Charting, • and Working with Large Worksheets

  2. Question 1 Question 15 Question 8 Multiple Choice Main MenuWhat-If Analysis, Charting and Working with Large Spreadsheets Question 2 Question 9 Question 16 Question 10 Question 3 Question 17 Question 11 Question 4 Question 18 Question 5 Question 12 Question 19 Question 13 Question 20 Question 6 Question 7 Question 14 Previous Slide End Show MC Quiz

  3. Question 1 ================================================================= __________ is the default option that Excel uses to fill the destination area with a series, using the same formatting as the source area. ================================================================= Click On: A, B, C, or D Error Display A Auto Fill B Fill Effect C Series Option D Textbook: EX 174 Previous Slide Main Menu

  4. Question 1 ================================================================= __________ is the default option that Excel uses to fill the destination area with a series, using the same formatting as the source area. ================================================================= Click On: A, B, C, or D Error Display A Auto Fill B Fill Effect C Series Option D Incorrect Textbook: EX 174 Previous Slide Main Menu

  5. Question 1 ================================================================= __________ is the default option that Excel uses to fill the destination area with a series, using the same formatting as the source area. ================================================================= Click On: A, B, C, or D Error Display A Auto Fill B Fill Effect C Series Option D Click Here For Next Question Correct Textbook: EX 174 Previous Slide Main Menu

  6. Question 2 ================================================================= The __________ is a place in the computer’s memory that allows you to collect text and graphic items from an Office document and then paste them into any Office document. ================================================================= Click On: A, B, C, or D Clipboard A Corkboard B Sign Post C Media Center D Textbook: EX 174 Previous Slide Main Menu

  7. Question 2 ================================================================= The __________ is a place in the computer’s memory that allows you to collect text and graphic items from an Office document and then paste them into any Office document. ================================================================= Click On: A, B, C, or D Clipboard A Corkboard B Sign Post C Media Center D Incorrect Textbook: EX 174 Previous Slide Main Menu

  8. Question 2 ================================================================= The __________ is a place in the computer’s memory that allows you to collect text and graphic items from an Office document and then paste them into any Office document. ================================================================= Click On: A, B, C, or D Clipboard A Corkboard B Sign Post C Media Center D Click Here For Next Question Correct Textbook: EX 174 Previous Slide Main Menu

  9. Question 3 ================================================================= Using the mouse to move or copy cells is called __________. ================================================================= Click On: A, B, C, or D mouse positioning A relocation B trapping C drag and drop D Textbook: EX 177 Previous Slide Main Menu

  10. Question 3 ================================================================= Using the mouse to move or copy cells is called __________. ================================================================= Click On: A, B, C, or D mouse positioning A relocation B trapping C drag and drop D Incorrect Textbook: EX 177 Previous Slide Main Menu

  11. Question 3 ================================================================= Using the mouse to move or copy cells is called __________. ================================================================= Click On: A, B, C, or D mouse positioning A relocation B trapping C drag and drop D Click Here For Next Question Correct Textbook: EX 177 Previous Slide Main Menu

  12. Question 4 ================================================================= Entering numbers with a __________ causes Excel to immediately display it with the assigned format. ================================================================= Click On: A, B, C, or D pointer A subscript B format symbol C factor D Textbook: EX 180 Previous Slide Main Menu

  13. Question 4 ================================================================= Entering numbers with a __________ causes Excel to immediately display it with the assigned format. ================================================================= Click On: A, B, C, or D pointer A subscript B format symbol C factor D Incorrect Textbook: EX 180 Previous Slide Main Menu

  14. Question 4 ================================================================= Entering numbers with a __________ causes Excel to immediately display it with the assigned format. ================================================================= Click On: A, B, C, or D pointer A subscript B format symbol C factor D Click Here For Next Question Correct Textbook: EX 180 Previous Slide Main Menu

  15. Question 5 ================================================================= __________ worksheet titles allows Excel to display the titles on the screen, no matter how far down or to the right you scroll. ================================================================= Click On: A, B, C, or D Freezing A Thawing B Cloning C Highlighting D Textbook: EX 181 Previous Slide Main Menu

  16. Question 5 ================================================================= __________ worksheet titles allows Excel to display the titles on the screen, no matter how far down or to the right you scroll. ================================================================= Click On: A, B, C, or D Freezing A Thawing B Cloning C Highlighting D Incorrect Textbook: EX 181 Previous Slide Main Menu

  17. Question 5 ================================================================= __________ worksheet titles allows Excel to display the titles on the screen, no matter how far down or to the right you scroll. ================================================================= Click On: A, B, C, or D Freezing A Thawing B Cloning C Highlighting D Click Here For Next Question Correct Textbook: EX 181 Previous Slide Main Menu

  18. Question 6 ================================================================= The __________ function is one of 14 date and time functions available in Excel. ================================================================= Click On: A, B, C, or D Rate A NOW B Count C Week D Textbook: EX 183 Previous Slide Main Menu

  19. Question 6 ================================================================= The __________ function is one of 14 date and time functions available in Excel. ================================================================= Click On: A, B, C, or D Rate A NOW B Count C Week D Incorrect Textbook: EX 183 Previous Slide Main Menu

  20. Question 6 ================================================================= The __________ function is one of 14 date and time functions available in Excel. ================================================================= Click On: A, B, C, or D Rate A NOW B Count C Week D Click Here For Next Question Correct Textbook: EX 183 Previous Slide Main Menu

  21. Question 7 ================================================================= A formula using the __________ cell reference instructs Excel to adjust the cell reference as it copies it to the destination area. ================================================================= Click On: A, B, C, or D relative A independent B dependent C balanced D Textbook: EX 186 Previous Slide Main Menu

  22. Question 7 ================================================================= A formula using the __________ cell reference instructs Excel to adjust the cell reference as it copies it to the destination area. ================================================================= Click On: A, B, C, or D relative A independent B dependent C balanced D Incorrect Textbook: EX 186 Previous Slide Main Menu

  23. Question 7 ================================================================= A formula using the __________ cell reference instructs Excel to adjust the cell reference as it copies it to the destination area. ================================================================= Click On: A, B, C, or D relative A independent B dependent C balanced D Click Here For Next Question Correct Textbook: EX 186 Previous Slide Main Menu

  24. Question 8 ================================================================= Using the __________ button on the Ribbon, can format a cell quickly by copying a cell’s format to another cell or a range of cells. ================================================================= Click On: A, B, C, or D Portrait View A Ribbon Painter B Format Printer C Format Painter D Textbook: EX 201 Previous Slide Main Menu

  25. Question 8 ================================================================= Using the __________ button on the Ribbon, can format a cell quickly by copying a cell’s format to another cell or a range of cells. ================================================================= Click On: A, B, C, or D Portrait View A Ribbon Painter B Format Printer C Format Painter D Incorrect Textbook: EX 201 Previous Slide Main Menu

  26. Question 8 ================================================================= Using the __________ button on the Ribbon, can format a cell quickly by copying a cell’s format to another cell or a range of cells. ================================================================= Click On: A, B, C, or D Portrait View A Ribbon Painter B Format Printer C Format Painter D Click Here For Next Question Correct Textbook: EX 201 Previous Slide Main Menu

  27. Question 9 ================================================================= A pie chart with one or more slices offset is called an __________ Pie chart. ================================================================= Click On: A, B, C, or D shallow A terminal B imploded C exploded D Textbook: EX 204 Previous Slide Main Menu

  28. Question 9 ================================================================= A pie chart with one or more slices offset is called an __________ Pie chart. ================================================================= Click On: A, B, C, or D shallow A terminal B imploded C exploded D Incorrect Textbook: EX 204 Previous Slide Main Menu

  29. Question 9 ================================================================= A pie chart with one or more slices offset is called an __________ Pie chart. ================================================================= Click On: A, B, C, or D shallow A terminal B imploded C exploded D Click Here For Next Question Correct Textbook: EX 204 Previous Slide Main Menu

  30. Question 10 ================================================================= Using Excel to scrutinize the impact of changing values in cells that are referenced by a formula in another cell is called _________ analysis or sensitivity analysis. ================================================================= Click On: A, B, C, or D creative A cryptographic B what-if C basic D Textbook: EX 223 Previous Slide Main Menu

  31. Question 10 ================================================================= Using Excel to scrutinize the impact of changing values in cells that are referenced by a formula in another cell is called _________ analysis or sensitivity analysis. ================================================================= Click On: A, B, C, or D creative A cryptographic B what-if C basic D Incorrect Textbook: EX 223 Previous Slide Main Menu

  32. Question 10 ================================================================= Using Excel to scrutinize the impact of changing values in cells that are referenced by a formula in another cell is called _________ analysis or sensitivity analysis. ================================================================= Click On: A, B, C, or D creative A cryptographic B what-if C basic D Click Here For Next Question Correct Textbook: EX 223 Previous Slide Main Menu

  33. Question 11 ================================================================= If you know the result you want a formula to produce, you can use __________ to determine the value of a cell on which the formula depends. ================================================================= Click On: A, B, C, or D posting A grading B zone display C goal seeking D Textbook: EX 225 Previous Slide Main Menu

  34. Question 11 ================================================================= If you know the result you want a formula to produce, you can use __________ to determine the value of a cell on which the formula depends. ================================================================= Click On: A, B, C, or D posting A grading B zone display C goal seeking D Incorrect Textbook: EX 225 Previous Slide Main Menu

  35. Question 11 ================================================================= If you know the result you want a formula to produce, you can use __________ to determine the value of a cell on which the formula depends. ================================================================= Click On: A, B, C, or D posting A grading B zone display C goal seeking D Click Here For Next Question Correct Textbook: EX 225 Previous Slide Main Menu

  36. Question 12 ================================================================= A __________ function is one in which the action to be taken for the true or false case includes yet another IF function. ================================================================= Click On: A, B, C, or D truth A system B nested IF C clustered D Textbook: EX 195 Previous Slide Main Menu

  37. Question 12 ================================================================= A __________ function is one in which the action to be taken for the true or false case includes yet another IF function. ================================================================= Click On: A, B, C, or D truth A system B nested IF C clustered D Incorrect Textbook: EX 195 Previous Slide Main Menu

  38. Question 12 ================================================================= A __________ function is one in which the action to be taken for the true or false case includes yet another IF function. ================================================================= Click On: A, B, C, or D truth A system B nested IF C clustered D Click Here For Next Question Correct Textbook: EX 195 Previous Slide Main Menu

  39. Question 13 ================================================================= A __________ shows the date a workbook, report, or other document was created or the period it represents. ================================================================= Click On: A, B, C, or D date stamp A name stamp B calculator C title D Textbook: EX 183 Previous Slide Main Menu

  40. Question 13 ================================================================= A __________ shows the date a workbook, report, or other document was created or the period it represents.. ================================================================= Click On: A, B, C, or D date stamp A name stamp B calculator C title D Incorrect Textbook: EX 183 Previous Slide Main Menu

  41. Question 13 ================================================================= A __________ shows the date a workbook, report, or other document was created or the period it represents. ================================================================= Click On: A, B, C, or D date stamp A name stamp B calculator C title D Click Here For Next Question Correct Textbook: EX 183 Previous Slide Main Menu

  42. Question 14 ================================================================= When Excel display the message “#REF!” in a cell or cells it means that there is a/n __________. ================================================================= Click On: A, B, C, or D referral A error B formula C graphic D Textbook: EX 180 Previous Slide Main Menu

  43. Question 14 ================================================================= When Excel display the message “#REF!” in a cell or cells it means that there is a/n __________. ================================================================= Click On: A, B, C, or D referral A error B formula C graphic D Incorrect Textbook: EX 180 Previous Slide Main Menu

  44. Question 14 ================================================================= When Excel display the message “#REF!” in a cell or cells it means that there is a/n __________. ================================================================= Click On: A, B, C, or D referral A error B formula C graphic D Click Here For Next Question Correct Textbook: EX 180 Previous Slide Main Menu

  45. Question 15 ================================================================= With __________ you can magnify or shrink the appearance of a worksheet or chart. ================================================================= Click On: A, B, C, or D zoom A minimize B maximize C display D Textbook: EX 220 Previous Slide Main Menu

  46. Question 15 ================================================================= With __________ you can magnify or shrink the appearance of a worksheet or chart. ================================================================= Click On: A, B, C, or D zoom A minimize B maximize C display D Incorrect Textbook: EX 220 Previous Slide Main Menu

  47. Question 15 ================================================================= With __________ you can magnify or shrink the appearance of a worksheet or chart. ================================================================= Click On: A, B, C, or D zoom A minimize B maximize C display D Click Here For Next Question Correct Textbook: EX 220 Previous Slide Main Menu

  48. Question 16 ================================================================= When working with a large worksheet you can divide the window by the use of _________ to display the Excel view into two or four panes. ================================================================= Click On: A, B, C, or D edit A format B insert C split D Textbook: EX 222 Previous Slide Main Menu

  49. Question 16 ================================================================= When working with a large worksheet you can divide the window by the use of _________ to display the Excel view into two or four panes. ================================================================= Click On: A, B, C, or D edit A format B insert C split D Incorrect Textbook: EX 222 Previous Slide Main Menu

  50. Question 16 ================================================================= When working with a large worksheet you can divide the window by the use of _________ to display the Excel view into two or four panes. ================================================================= Click On: A, B, C, or D edit A format B insert C split D Click Here For Next Question Correct Textbook: EX 222 Previous Slide Main Menu

More Related