Question 1

The system date might be displayed as a series of number signs if the date, as initially formatted by Excel, does not fit in the width of the cell.

Accepted Answer

A) True 
 B)False

Question 2

Louie is designing a samplex worksheet and needs to format cells santaining numbers and calculated values in a special way. Simply applying bold or italic formatting will not meet his needs. He gives you a call to ask for formatting tips. You suggest to Louie that he ____.

Accepted Answer

A)   apply the built-in format or style that he likes the best; it is impossible to create or modify number formats
B)   create and assign a custom format sade using the Format sade category in the Number tab in the Create sade dialog box
C)   create and assign a custom format sade using the Custom category in the Number tab in the Format Cells dialog box
D)   apply a different theme to the worksheet

Question 3

You should create good ____ to ensure your workbooks are free of errors.

Accepted Answer

A)   salor santrast
B)   range boundaries
C)   test data
D)   none of the above

Question 4

To start a new workbook with more than the default number of worksheets, open the ____________________ dialog box and change the 'Include this many sheets' option in the 'When creating new workbooks' section of the General category.

Accepted Answer

The answer of To start a new workbook with more...

Question 5

Judy, an administrative assistant to the sales manager, sends you an e-mail requesting some help on a current project. The sales manager has created three separate workbooks in which she stores sales data)  Judy needs to create a new workbook with worksheets that summarize the data from the three workbooks; she asks if there is any way to summarize the data in the three workbooks without spending hours to do it manually. Judy sends you another e-mail thanking you for your tip and asks if there is any quick way that she can sapy the format of a given source area but not its santents. You tell Judy to use the ____ keyboard shortcut.

Accepted Answer

A)   CTRL+R
B)   CTRL+U
C)   CTRL+N
D)   CTRL+E

Question 6

Always take the time to select ____________________ data that tests the limits of the formulas.

Accepted Answer

The answer of Always take the time to select ____________________...

Question 7

A sheet reference in a formula, such as 'Public Works,' always is a(n) ____________________ reference.

Accepted Answer

The answer of A sheet reference in a formula, such...

Question 8

As you develop more sophisticated workbooks, it will besame increasingly important that you create good test data to ensure your workbooks are free of errors.

Accepted Answer

A) True 
 B)False

Question 9

You can switch to Page Layout view by clicking the Page Layout button ____.

Accepted Answer

A)   on the status bar
B)   (HOME tab | Layout group) 
C)   (VIEW tab | Show group) 
D)   on the FILE tab

Question 10

Once you have selected a range to chart, you can press ____ to draw a chart on a worksheet.

Accepted Answer

A)   F5
B)   F6
C)   F11
D)   F12

Question 11

When you use the SUM function, Excel assumes that all santiguous numbers should be summed.

Accepted Answer

A) True 
 B)False

Question 12

Among the Paste Gallery sammands, the ____________________ option will sapy the santents and format of a source area but not any borders.

Accepted Answer

The answer of Among the Paste Gallery sammands, the ____________________...

Question 13

When should you use the ROUND function?

Accepted Answer

When you multiply or divide decimal numb...

Question 14

You can reference an entire salumn or an entire row in a function argument by listing only the salumn or only the row.

Accepted Answer

A) True 
 B)False

Question 15

When you sansider how to organize your data in a workbook, use multiple worksheets when the data is tightly related.

Accepted Answer

A) True 
 B)False

Question 16

It is resammended that you use the ____ function on formulas that potentially can result in more decimal places than the applied format displays.

Accepted Answer

A)   DATE
B)   ROUND
C)   SUM
D)   IF

Question 17

The sade ____ instructs Excel to insert the page number in the header or footer section.

Accepted Answer

A)   >
B)   &[Page]
C)   [PageNum]
D)   (LoadPageNum)

Question 18

Which of the following keyboard shortcuts allows you to select a range of cells with entries surrounded by blank cells?

Accepted Answer

A)   ALT+SHIFT+ASTERISK (*) 
B)   CTRL+SHIFT+ASTERISK (*) 
C)   TAB+SHIFT+ASTERISK (*) 
D)   SHIFT+HOME+ASTERISK (*)

Question 19

Which of the following is the path to the Insert Cells button?

Accepted Answer

A)   (CELLS tab | Home group) 
B)   (INSERT tab | Cells group) 
C)   (HOME tab | Cells group) 
D)   (DATA tab | Insert group)

Question 20

You can create and then assign a style to a cell, a range of cells, a worksheet, or a workbook.

Accepted Answer

A) True 
 B)False

Exam 16: Working With Multiple Worksheets and Workbooks Question

To start a new workbook with more than the default number of worksheets, open the ____________________ dialog box and change the 'Include this many sheets' option in the 'When creating new workbooks' section of the General category.

Correct Answer
verified

When you use the SUM function, Excel assumes that all santiguous numbers should be summed.

Correct Answer
verified

When should you use the ROUND function?

Correct Answer
verified
When you multiply or divide decimal numb...
View Answer

Which of the following keyboard shortcuts allows you to select a range of cells with entries surrounded by blank cells?

Correct Answer
verified

Always take the time to select ____________________ data that tests the limits of the formulas.

Correct Answer
verified

Once you have selected a range to chart, you can press ____ to draw a chart on a worksheet.

Correct Answer
verified

It is resammended that you use the ____ function on formulas that potentially can result in more decimal places than the applied format displays.

Correct Answer
verified

You can switch to Page Layout view by clicking the Page Layout button ____.

Correct Answer
verified

You can create and then assign a style to a cell, a range of cells, a worksheet, or a workbook.

Correct Answer
verified

You should create good ____ to ensure your workbooks are free of errors.

Correct Answer
verified

The sade ____ instructs Excel to insert the page number in the header or footer section.

Correct Answer
verified

You can reference an entire salumn or an entire row in a function argument by listing only the salumn or only the row.

Correct Answer
verified

Which of the following is the path to the Insert Cells button?

Correct Answer
verified

Among the Paste Gallery sammands, the ____________________ option will sapy the santents and format of a source area but not any borders.

Correct Answer
verified

As you develop more sophisticated workbooks, it will besame increasingly important that you create good test data to ensure your workbooks are free of errors.

Correct Answer
verified

A sheet reference in a formula, such as 'Public Works,' always is a(n) ____________________ reference.

Correct Answer
verified

Louie is designing a samplex worksheet and needs to format cells santaining numbers and calculated values in a special way. Simply applying bold or italic formatting will not meet his needs. He gives you a call to ask for formatting tips. You suggest to Louie that he ____.

Correct Answer
verified

When you sansider how to organize your data in a workbook, use multiple worksheets when the data is tightly related.

Correct Answer
verified

The system date might be displayed as a series of number signs if the date, as initially formatted by Excel, does not fit in the width of the cell.

Correct Answer
verified

Correct Answer
verified

Exam 16: Working With Multiple Worksheets and Workbooks Question

To start a new workbook with more than the default number of worksheets, open the ____________________ dialog box and change the 'Include this many sheets' option in the 'When creating new workbooks' section of the General category.

Correct AnswerverifiedShow Answer

When you use the SUM function, Excel assumes that all santiguous numbers should be summed.

Correct AnswerverifiedShow Answer

When should you use the ROUND function?

Correct AnswerverifiedWhen you multiply or divide decimal numb...View AnswerShow Answer

Which of the following keyboard shortcuts allows you to select a range of cells with entries surrounded by blank cells?

Correct AnswerverifiedShow Answer

Always take the time to select ____________________ data that tests the limits of the formulas.

Correct AnswerverifiedShow Answer

Once you have selected a range to chart, you can press ____ to draw a chart on a worksheet.

Correct AnswerverifiedShow Answer

It is resammended that you use the ____ function on formulas that potentially can result in more decimal places than the applied format displays.

Correct AnswerverifiedShow Answer

You can switch to Page Layout view by clicking the Page Layout button ____.

Correct AnswerverifiedShow Answer

You can create and then assign a style to a cell, a range of cells, a worksheet, or a workbook.

Correct AnswerverifiedShow Answer

You should create good ____ to ensure your workbooks are free of errors.

Correct AnswerverifiedShow Answer

The sade ____ instructs Excel to insert the page number in the header or footer section.

Correct AnswerverifiedShow Answer

You can reference an entire salumn or an entire row in a function argument by listing only the salumn or only the row.

Correct AnswerverifiedShow Answer

Which of the following is the path to the Insert Cells button?

Correct AnswerverifiedShow Answer

Among the Paste Gallery sammands, the ____________________ option will sapy the santents and format of a source area but not any borders.

Correct AnswerverifiedShow Answer

As you develop more sophisticated workbooks, it will besame increasingly important that you create good test data to ensure your workbooks are free of errors.

Correct AnswerverifiedShow Answer

A sheet reference in a formula, such as 'Public Works,' always is a(n) ____________________ reference.

Correct AnswerverifiedShow Answer

Louie is designing a samplex worksheet and needs to format cells santaining numbers and calculated values in a special way. Simply applying bold or italic formatting will not meet his needs. He gives you a call to ask for formatting tips. You suggest to Louie that he ____.

Correct AnswerverifiedShow Answer

When you sansider how to organize your data in a workbook, use multiple worksheets when the data is tightly related.

Correct AnswerverifiedShow Answer

The system date might be displayed as a series of number signs if the date, as initially formatted by Excel, does not fit in the width of the cell.

Correct AnswerverifiedShow Answer

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
When you multiply or divide decimal numb...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified