630 likes | 761 Views
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.
E N D
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 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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