Question 1

To provide suggestions to other people using a worksheet, select the cell you want to comment on, then click New Comment on the Review tab and type your comment.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following is not a way to move cell contents?

Accepted Answer

A)  clicking the Cut and Paste buttons on the Home tab 
B)  pressing the CTRL+X keys 
C)  holding the CTRL key while dragging the selected cells 
D)  using drag-and-drop 
A)  clicking the Cut and Paste buttons on the Home tab 
B)  pressing the CTRL+X keys 
C)  holding the CTRL key while dragging the selected cells 
D)  using drag-and-drop

Question 3

The value in cell B2 cell is 65. In cell C2, the value is 75. Which of the following formulas returns FALSE if any of the conditions are false for the values in cells B2 and C2?

Accepted Answer

A)  =IF(B2>=70, C2>=80) 
B)  =OR(B2>=70, C2>=80) 
C)  =AND(B2>=70, C2>=80) 
D)  =NOT(OR(B2>=70, C2>=80)) 
A)  =IF(B2>=70, C2>=80) 
B)  =OR(B2>=70, C2>=80) 
C)  =AND(B2>=70, C2>=80) 
D)  =NOT(OR(B2>=70, C2>=80))

Question 4

To have Excel enter the lowest price from a range of prices, which of the following would you use?

Accepted Answer

A)  MAX function 
B)  COUNT function 
C)  MIN function 
D)  COUNTA function 
A)  MAX function 
B)  COUNT function 
C)  MIN function 
D)  COUNTA function

Question 5

Which of the following lets you resize a selected picture on your worksheet?

Accepted Answer

A)  Drag it to a new location. 
B)  Drag any corner handle. 
C)  Drag its top border. 
D)  Double-click the picture. 
A)  Drag it to a new location. 
B)  Drag any corner handle. 
C)  Drag its top border. 
D)  Double-click the picture.

Question 6

To combine multiple cells into one combined cell, which of the following do you use?

Accepted Answer

A)  Column Width command 
B)  Center button 
C)  Merge and Center button 
D)  Increase Indent button 
A)  Column Width command 
B)  Center button 
C)  Merge and Center button 
D)  Increase Indent button

Question 7

ActiveX is a named set of instructions, written in the Visual Basic programming language, that perform tasks automatically in a specified order.

Accepted Answer

A) True 
 B)False

Question 8

Joyce wants to calculate the monthly payment for a $16,000 car loan at 5.5% interest over 5 years. She should create a formula using the NPER function.

Accepted Answer

A) True 
 B)False

Question 9

When should you use relative cell references?

Accepted Answer

A)  When you want to preserve the exact cell address in a formula. 
B)  When you want to preserve the relationship to the formula location. 
C)  When you want to insert a function. 
D)  When you want to enter sequential values in a range of cells. 
A)  When you want to preserve the exact cell address in a formula. 
B)  When you want to preserve the relationship to the formula location. 
C)  When you want to insert a function. 
D)  When you want to enter sequential values in a range of cells.

Question 10

When you click a chart element such as a legend, it displays sizing handles to indicate it is selected.

Accepted Answer

A) True 
 B)False

Question 11

When would you explode a slice in a pie chart?

Accepted Answer

A)  to show trends over time 
B)  to highlight the general direction of the data series 
C)  to identify the value the slice represents 
D)  to emphasize one data point 
A)  to show trends over time 
B)  to highlight the general direction of the data series 
C)  to identify the value the slice represents 
D)  to emphasize one data point

Question 12

Tracing dependents indicates which cells are affected by a formula error.

Accepted Answer

A) True 
 B)False

Question 13

Melanie inserted a Clustered Column PivotChart, but a Clustered Bar PivotChart would work better for the data. What should she do?

Accepted Answer

A)  Change the PivotChart style. 
B)  Apply a Quick Layout. 
C)  Expand the PivotChart data. 
D)  Change the PivotChart type. 
A)  Change the PivotChart style. 
B)  Apply a Quick Layout. 
C)  Expand the PivotChart data. 
D)  Change the PivotChart type.

Question 14

The Clipboard task pane shows the contents of the _____.

Accepted Answer

A)  Office Clipboard 
B)  Table Styles gallery 
C)  Quick Analysis tool 
D)  Recently-Used Add-Ins 
A)  Office Clipboard 
B)  Table Styles gallery 
C)  Quick Analysis tool 
D)  Recently-Used Add-Ins

Question 15

Darnell wants to verify whether a workbook he created is compatible with Excel 2007 2010, or 2013. To do so, he can click File > Info > Check for Issues > Check Compatibility > OK.

Accepted Answer

A) True 
 B)False

Question 16

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 17

To move cell contents one space to the right, you can use the Increase Space button.

Accepted Answer

A) True 
 B)False

Question 18

A _____ is a calculated named field in Power Pivot.

Accepted Answer

A)  measure 
B)  relationship 
C)  group 
D)  3D map 
A)  measure 
B)  relationship 
C)  group 
D)  3D map

Question 19

Richard retired recently and is receiving $400 per month from an investment at a rate of 7% for 20 years. Which of the following functions can he use to calculate the current value of the investment?

Accepted Answer

A)  PMT 
B)  NPER 
C)  PV 
D)  RATE 
A)  PMT 
B)  NPER 
C)  PV 
D)  RATE

Question 20

When you import an Access database table, you can use the Power Query Editor to remove a column or row from the table.

Accepted Answer

A) True 
 B)False

To provide suggestions to other people using a worksheet, select the cell you want to comment on, then click New Comment on the Review tab and type your comment.

Which of the following is not a way to move cell contents?

The value in cell B2 cell is 65. In cell C2, the value is 75. Which of the following formulas returns FALSE if any of the conditions are false for the values in cells B2 and C2?

To have Excel enter the lowest price from a range of prices, which of the following would you use?

Which of the following lets you resize a selected picture on your worksheet?

To combine multiple cells into one combined cell, which of the following do you use?

ActiveX is a named set of instructions, written in the Visual Basic programming language, that perform tasks automatically in a specified order.

Joyce wants to calculate the monthly payment for a $16,000 car loan at 5.5% interest over 5 years. She should create a formula using the NPER function.

When should you use relative cell references?

When you click a chart element such as a legend, it displays sizing handles to indicate it is selected.

When would you explode a slice in a pie chart?

Tracing dependents indicates which cells are affected by a formula error.

Melanie inserted a Clustered Column PivotChart, but a Clustered Bar PivotChart would work better for the data. What should she do?

The Clipboard task pane shows the contents of the _____.

Darnell wants to verify whether a workbook he created is compatible with Excel 2007 2010, or 2013. To do so, he can click File > Info > Check for Issues > Check Compatibility > OK.

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

To move cell contents one space to the right, you can use the Increase Space button.

A _____ is a calculated named field in Power Pivot.

Richard retired recently and is receiving $400 per month from an investment at a rate of 7% for 20 years. Which of the following functions can he use to calculate the current value of the investment?

When you import an Access database table, you can use the Power Query Editor to remove a column or row from the table.

Access 2019

Powerpoint 2019

Word 2019

Outlook 2019

Windows 10 2019

Technology and IT: From CAM to IoT and Digital Citizenship

Filters

Exam 2: Excel 2019

To provide suggestions to other people using a worksheet, select the cell you want to comment on, then click New Comment on the Review tab and type your comment.

Which of the following is not a way to move cell contents?

The value in cell B2 cell is 65. In cell C2, the value is 75. Which of the following formulas returns FALSE if any of the conditions are false for the values in cells B2 and C2?

To have Excel enter the lowest price from a range of prices, which of the following would you use?

Which of the following lets you resize a selected picture on your worksheet?

To combine multiple cells into one combined cell, which of the following do you use?

ActiveX is a named set of instructions, written in the Visual Basic programming language, that perform tasks automatically in a specified order.

Joyce wants to calculate the monthly payment for a $16,000 car loan at 5.5% interest over 5 years. She should create a formula using the NPER function.

When should you use relative cell references?

When you click a chart element such as a legend, it displays sizing handles to indicate it is selected.

When would you explode a slice in a pie chart?

Tracing dependents indicates which cells are affected by a formula error.

Melanie inserted a Clustered Column PivotChart, but a Clustered Bar PivotChart would work better for the data. What should she do?

The Clipboard task pane shows the contents of the _____.

Darnell wants to verify whether a workbook he created is compatible with Excel 2007 2010, or 2013. To do so, he can click File > Info > Check for Issues > Check Compatibility > OK.

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

To move cell contents one space to the right, you can use the Increase Space button.

A _____ is a calculated named field in Power Pivot.

Richard retired recently and is receiving $400 per month from an investment at a rate of 7% for 20 years. Which of the following functions can he use to calculate the current value of the investment?

When you import an Access database table, you can use the Power Query Editor to remove a column or row from the table.

Access 2019

Powerpoint 2019

Word 2019

Outlook 2019

Windows 10 2019

Technology and IT: From CAM to IoT and Digital Citizenship

Filters