Question 1

When you switch rows and columns in a chart, Excel updates the legend at the same time.

Accepted Answer

A) True 
 B)False

Question 2

Betty wants to display negative percentages in red text with parentheses. What type of number format should she apply?

Accepted Answer

A)  Custom 
B)  Modified Percent 
C)  General 
D)  Negative 
A)  Custom 
B)  Modified Percent 
C)  General 
D)  Negative

Question 3

Objects you can insert into Excel workbooks from other apps include pictures, database objects, and text data.

Accepted Answer

A) True 
 B)False

Question 4

To make your workbooks usable by people with disabilities, you can use the Accessibility Checker in Excel.

Accepted Answer

A) True 
 B)False

Question 5

Caleb created a column chart that lists numbers from $50,000 to $0 on the left. What can he add to the chart to indicate that these are monthly revenue amounts?

Accepted Answer

A)  Vertical axis title 
B)  Horizontal axis 
C)  Data table 
D)  New data series 
A)  Vertical axis title 
B)  Horizontal axis 
C)  Data table 
D)  New data series

Question 6

Which of the following helps you move around a worksheet that is too large to fit on the screen at once?

Accepted Answer

A)  sheet tabs 
B)  arguments 
C)  scroll bars 
D)  operators 
A)  sheet tabs 
B)  arguments 
C)  scroll bars 
D)  operators

Question 7

What is the correct formula to insert the date January 12, 1998 into a cell?

Accepted Answer

A)  =DATE(1998,1,12) 
B)  =DATE(1998,12,1) 
C)  =DATE(12-1-1998) 
D)  =DATE(1/12/1998) 
A)  =DATE(1998,1,12) 
B)  =DATE(1998,12,1) 
C)  =DATE(12-1-1998) 
D)  =DATE(1/12/1998)

Question 8

A worksheet named Income (2) is most likely which of the following?

Accepted Answer

A)  a deleted worksheet 
B)  a worksheet with no calculations 
C)  a repositioned worksheet 
D)  a copy of another worksheet named Income 
A)  a deleted worksheet 
B)  a worksheet with no calculations 
C)  a repositioned worksheet 
D)  a copy of another worksheet named Income

Question 9

Which of the following statements describes tables where the EmployeeID field in the Employees table can be associated with many CustomerID fields in the Customers table?

Accepted Answer

A)  They have a one-to-many relationship. 
B)  They are power tables. 
C)  They are static tables that cannot be updated. 
D)  They are mirror tables. 
A)  They have a one-to-many relationship. 
B)  They are power tables. 
C)  They are static tables that cannot be updated. 
D)  They are mirror tables.

Question 10

To enter your name in the lower right corner of a worksheet page, you can _____.

Accepted Answer

A)  Use a button on the Header and Footer Tools Design tab. 
B)  Type your name in the Header and Footer Elements group. 
C)  Type your name in the lower right cell of the worksheet. 
D)  Select the right footer text box and type your name. 
A)  Use a button on the Header and Footer Tools Design tab. 
B)  Type your name in the Header and Footer Elements group. 
C)  Type your name in the lower right cell of the worksheet. 
D)  Select the right footer text box and type your name.

Question 11

To retrieve summary data from a PivotTable, you need to use the PIVOTSUM function.

Accepted Answer

A) True 
 B)False

Question 12

By default, Excel records absolute cell references in macros.

Accepted Answer

A) True 
 B)False

Question 13

How can you move a picture, chart, or other object on a worksheet?

Accepted Answer

A)  Use the Move Object button. 
B)  Drag a corner handle. 
C)  Click the object and then click a cell. 
D)  Drag the object. 
A)  Use the Move Object button. 
B)  Drag a corner handle. 
C)  Click the object and then click a cell. 
D)  Drag the object.

Question 14

When you enter a formula such as =SUM('Chicago:San Francisco'!A6), which references cell A6 on four worksheets from the Chicago worksheet to the San Francisco worksheet, what type of reference are you using?

Accepted Answer

A)  structured reference 
B)  absolute reference 
C)  3-D reference 
D)  mixed reference 
A)  structured reference 
B)  absolute reference 
C)  3-D reference 
D)  mixed reference

Question 15

To format a cell range so that values between 100 and 500 appear in red, which of the following can you use?

Accepted Answer

A)  icon sets 
B)  themes 
C)  Top/Bottom Rules 
D)  Highlight Cells Rules 
A)  icon sets 
B)  themes 
C)  Top/Bottom Rules 
D)  Highlight Cells Rules

Question 16

Al wants to compare data in two worksheets of two different workbooks quickly by scrolling through both at the same time. Which of these should he click after turning on View Side by Side on the View Tab in the Windows group?

Accepted Answer

A)  Reset Window Position 
B)  Synchronous Scrolling 
C)  Arrange All 
D)  Zoom to Selection 
A)  Reset Window Position 
B)  Synchronous Scrolling 
C)  Arrange All 
D)  Zoom to Selection

Question 17

Why is it necessary to use care when inserting worksheet cells?

Accepted Answer

A)  It might automatically change the functions you are using. 
B)  It can change relative references to absolute references in formulas. 
C)  You will have to manually correct cell references in formulas. 
D)  It may disturb row or column alignment, which can affect worksheet accuracy. 
A)  It might automatically change the functions you are using. 
B)  It can change relative references to absolute references in formulas. 
C)  You will have to manually correct cell references in formulas. 
D)  It may disturb row or column alignment, which can affect worksheet accuracy.

Question 18

How can you change the data displayed in the PivotTable?

Accepted Answer

A)  Edit the PivotTable directly. 
B)  Edit the data source and then refresh the PivotTable. 
C)  Use the Edit in Place feature. 
D)  Edit the data source and then save the workbook. 
A)  Edit the PivotTable directly. 
B)  Edit the data source and then refresh the PivotTable. 
C)  Use the Edit in Place feature. 
D)  Edit the data source and then save the workbook.

Question 19

When you copy cell contents, the data is removed from its original location and placed on the Clipboard.

Accepted Answer

A) True 
 B)False

Question 20

Rukha has created two custom views of a worksheet. In one view, all rows and columns can be seen whereas in the other, specific rows and columns are hidden. What can she do to be able to see the view that she needs to at a given point in time?

Accepted Answer

A)  Click Custom Views and double-click on the display settings she wants to see. 
B)  Under Windows group on the View tab, click on View Side by Side. 
C)  Under Windows group on the View tab, click on Switch Windows and select the View she wants. 
D)  Click Custom View and check the box beside Hidden rows, column and filter settings to see Custom view of all rows and columns shown while uncheck the box to see the Custom view of specific rows and columns hidden. 
A)  Click Custom Views and double-click on the display settings she wants to see. 
B)  Under Windows group on the View tab, click on View Side by Side. 
C)  Under Windows group on the View tab, click on Switch Windows and select the View she wants. 
D)  Click Custom View and check the box beside Hidden rows, column and filter settings to see Custom view of all rows and columns shown while uncheck the box to see the Custom view of specific rows and columns hidden.

When you switch rows and columns in a chart, Excel updates the legend at the same time.

Betty wants to display negative percentages in red text with parentheses. What type of number format should she apply?

Objects you can insert into Excel workbooks from other apps include pictures, database objects, and text data.

To make your workbooks usable by people with disabilities, you can use the Accessibility Checker in Excel.

Caleb created a column chart that lists numbers from $50,000 to $0 on the left. What can he add to the chart to indicate that these are monthly revenue amounts?

Which of the following helps you move around a worksheet that is too large to fit on the screen at once?

What is the correct formula to insert the date January 12, 1998 into a cell?

A worksheet named Income (2) is most likely which of the following?

Which of the following statements describes tables where the EmployeeID field in the Employees table can be associated with many CustomerID fields in the Customers table?

To enter your name in the lower right corner of a worksheet page, you can _____.

To retrieve summary data from a PivotTable, you need to use the PIVOTSUM function.

By default, Excel records absolute cell references in macros.

How can you move a picture, chart, or other object on a worksheet?

When you enter a formula such as =SUM('Chicago:San Francisco'!A6), which references cell A6 on four worksheets from the Chicago worksheet to the San Francisco worksheet, what type of reference are you using?

To format a cell range so that values between 100 and 500 appear in red, which of the following can you use?

Al wants to compare data in two worksheets of two different workbooks quickly by scrolling through both at the same time. Which of these should he click after turning on View Side by Side on the View Tab in the Windows group?

Why is it necessary to use care when inserting worksheet cells?

How can you change the data displayed in the PivotTable?

When you copy cell contents, the data is removed from its original location and placed on the Clipboard.

Rukha has created two custom views of a worksheet. In one view, all rows and columns can be seen whereas in the other, specific rows and columns are hidden. What can she do to be able to see the view that she needs to at a given point in time?

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters

Exam 2: Excel-2019

When you switch rows and columns in a chart, Excel updates the legend at the same time.

Betty wants to display negative percentages in red text with parentheses. What type of number format should she apply?

Objects you can insert into Excel workbooks from other apps include pictures, database objects, and text data.

To make your workbooks usable by people with disabilities, you can use the Accessibility Checker in Excel.

Caleb created a column chart that lists numbers from $50,000 to $0 on the left. What can he add to the chart to indicate that these are monthly revenue amounts?

Which of the following helps you move around a worksheet that is too large to fit on the screen at once?

What is the correct formula to insert the date January 12, 1998 into a cell?

A worksheet named Income (2) is most likely which of the following?

Which of the following statements describes tables where the EmployeeID field in the Employees table can be associated with many CustomerID fields in the Customers table?

To enter your name in the lower right corner of a worksheet page, you can _____.

To retrieve summary data from a PivotTable, you need to use the PIVOTSUM function.

By default, Excel records absolute cell references in macros.

How can you move a picture, chart, or other object on a worksheet?

When you enter a formula such as =SUM('Chicago:San Francisco'!A6), which references cell A6 on four worksheets from the Chicago worksheet to the San Francisco worksheet, what type of reference are you using?

To format a cell range so that values between 100 and 500 appear in red, which of the following can you use?

Al wants to compare data in two worksheets of two different workbooks quickly by scrolling through both at the same time. Which of these should he click after turning on View Side by Side on the View Tab in the Windows group?

Why is it necessary to use care when inserting worksheet cells?

How can you change the data displayed in the PivotTable?

When you copy cell contents, the data is removed from its original location and placed on the Clipboard.

Rukha has created two custom views of a worksheet. In one view, all rows and columns can be seen whereas in the other, specific rows and columns are hidden. What can she do to be able to see the view that she needs to at a given point in time?

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters