Question 1

When you cut or copy a cell, it is cut or copied to which of the following?

Accepted Answer

A)  Neither the Windows or Office Clipboard 
B)  Both the Windows and Office Clipboard 
C)  Only the Office Clipboard 
D)  Only the Windows Clipboard 
A)  Neither the Windows or Office Clipboard 
B)  Both the Windows and Office Clipboard 
C)  Only the Office Clipboard 
D)  Only the Windows Clipboard

Question 2

To open the Power Pivot window from the workbook, click the View tab, then click the Data Tools button.

Accepted Answer

A) True 
 B)False

Question 3

Helga wants to reset page breaks in a worksheet to display only automatic page breaks.Which of these can she select as X and Y in the series of clicks to do so: Worksheet > View tab > Workbook Views group > X > Page Layout tab > Page Setup group > Y > Reset All Page Breaks?

Accepted Answer

A)  X- Normal, Y- Print Area 
B)  X- Page Layout, Y- Print Tiles 
C)  X- Page Break Preview, Y- Breaks 
D)  X- Custom Views, Y- Background 
A)  X- Normal, Y- Print Area 
B)  X- Page Layout, Y- Print Tiles 
C)  X- Page Break Preview, Y- Breaks 
D)  X- Custom Views, Y- Background

Question 4

Which of the following is a way to make a table accessible?

Accepted Answer

A)  Apply a dark table style. 
B)  Hide the header row. 
C)  Enter a descriptive table name. 
D)  Remove table records. 
A)  Apply a dark table style. 
B)  Hide the header row. 
C)  Enter a descriptive table name. 
D)  Remove table records.

Question 5

Boris is displaying two instances of the same workbook and wants to remove one.Which button should he click on the View tab?

Accepted Answer

A)  Hide 
B)  Split 
C)  View Side by Side 
D)  Switch Windows 
A)  Hide 
B)  Split 
C)  View Side by Side 
D)  Switch Windows

Question 6

Dawn wants to make a column chart look three dimensional.How can she do so?

Accepted Answer

A)  Apply a chart style. 
B)  Change the Chart Layout. 
C)  Modify the chart data. 
D)  Change the chart type. 
A)  Apply a chart style. 
B)  Change the Chart Layout. 
C)  Modify the chart data. 
D)  Change the chart type.

Question 7

To list the Product Type field values across the top of a PivotTable, add the Product Type field to the Rows area of the PivotTable Fields pane.

Accepted Answer

A) True 
 B)False

Question 8

Mila wants to specify what data users can enter in a table column.What Excel feature should she use?

Accepted Answer

A)  Table filters 
B)  VLOOKUP function 
C)  Multilevel sort 
D)  Data validation 
A)  Table filters 
B)  VLOOKUP function 
C)  Multilevel sort 
D)  Data validation

Question 9

To move a worksheet, you can drag its sheet tab to the left or right.

Accepted Answer

A) True 
 B)False

Question 10

The score of a student in two subjects are inserted in B2 and C2 cell and the passing score for each subject is 60.which of these functions will you insert in D2 cell to get FALSE as the result if the student has passed and TRUE as the result if the student has failed?

Accepted Answer

A)  =IF(B2>=60, C2>=60) 
B)  =NOT(OR(B2>=60, C2>=60)) 
C)  =OR(B2>=60, "Pass", "Fail") 
D)  =AND(B2>=60, "Pass", "Fail") 
A)  =IF(B2>=60, C2>=60) 
B)  =NOT(OR(B2>=60, C2>=60)) 
C)  =OR(B2>=60, "Pass", "Fail") 
D)  =AND(B2>=60, "Pass", "Fail")

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

You can insert two types of controls in a worksheet: VBA controls and ActiveX controls.

Accepted Answer

A) True 
 B)False

Question 13

You can import a text file that uses a divider such as a space, comma, or semicolon between columns of data.

Accepted Answer

A) True 
 B)False

Question 14

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 15

By default, Excel records absolute cell references in macros.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following statements is true about COUNT functions?

Accepted Answer

A)  The COUNT function returns the number of calls in a range that are not blank. 
B)  The COUNT function returns the number of calls in a range that contain any data at all. 
C)  Using the COUNT function is useful for computing the average of a cell range. 
D)  The COUNT function returns the number of cells in a range that contain numeric data. 
A)  The COUNT function returns the number of calls in a range that are not blank. 
B)  The COUNT function returns the number of calls in a range that contain any data at all. 
C)  Using the COUNT function is useful for computing the average of a cell range. 
D)  The COUNT function returns the number of cells in a range that contain numeric data.

Question 17

Alba wants to display a picture as the worksheet background.Which of the following buttons on the Page Layout tab should she use?

Accepted Answer

A)  Breaks 
B)  Margins 
C)  Orientation 
D)  Background 
A)  Breaks 
B)  Margins 
C)  Orientation 
D)  Background

Question 18

In the formula =A8*$A$1, which of the following describes A8?

Accepted Answer

A)  Relative cell reference 
B)  Absolute cell reference 
C)  Function 
D)  AutoSum 
A)  Relative cell reference 
B)  Absolute cell reference 
C)  Function 
D)  AutoSum

Question 19

Which of the following are statistical functions? Select all the options that apply.

Accepted Answer

A)  TEXTJOIN 
B)  NPER 
C)  COUNTIF 
D)  AVERAGEIF 
A)  TEXTJOIN 
B)  NPER 
C)  COUNTIF 
D)  AVERAGEIF

Question 20

How can you tell if Solver is activated in your version of Excel?

Accepted Answer

A)  The Solver button appears in the Analyze group on the Data tab. 
B)  A Solver tab appears on the ribbon. 
C)  The Solver dialog box opens when you click the Data tab. 
D)  Solver appears as the Add-in document property in Backstage view. 
A)  The Solver button appears in the Analyze group on the Data tab. 
B)  A Solver tab appears on the ribbon. 
C)  The Solver dialog box opens when you click the Data tab. 
D)  Solver appears as the Add-in document property in Backstage view.

When you cut or copy a cell, it is cut or copied to which of the following?

To open the Power Pivot window from the workbook, click the View tab, then click the Data Tools button.

Helga wants to reset page breaks in a worksheet to display only automatic page breaks.Which of these can she select as X and Y in the series of clicks to do so: Worksheet > View tab > Workbook Views group > X > Page Layout tab > Page Setup group > Y > Reset All Page Breaks?

Which of the following is a way to make a table accessible?

Boris is displaying two instances of the same workbook and wants to remove one.Which button should he click on the View tab?

Dawn wants to make a column chart look three dimensional.How can she do so?

To list the Product Type field values across the top of a PivotTable, add the Product Type field to the Rows area of the PivotTable Fields pane.

Mila wants to specify what data users can enter in a table column.What Excel feature should she use?

To move a worksheet, you can drag its sheet tab to the left or right.

The score of a student in two subjects are inserted in B2 and C2 cell and the passing score for each subject is 60.which of these functions will you insert in D2 cell to get FALSE as the result if the student has passed and TRUE as the result if the student has failed?

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

You can insert two types of controls in a worksheet: VBA controls and ActiveX controls.

You can import a text file that uses a divider such as a space, comma, or semicolon between columns of data.

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

By default, Excel records absolute cell references in macros.

Which of the following statements is true about COUNT functions?

Alba wants to display a picture as the worksheet background.Which of the following buttons on the Page Layout tab should she use?

In the formula =A8*$A$1, which of the following describes A8?

Which of the following are statistical functions? Select all the options that apply.

How can you tell if Solver is activated in your version of Excel?

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters

Exam 7: Excel

When you cut or copy a cell, it is cut or copied to which of the following?

To open the Power Pivot window from the workbook, click the View tab, then click the Data Tools button.

Helga wants to reset page breaks in a worksheet to display only automatic page breaks.Which of these can she select as X and Y in the series of clicks to do so: Worksheet > View tab > Workbook Views group > X > Page Layout tab > Page Setup group > Y > Reset All Page Breaks?

Which of the following is a way to make a table accessible?

Boris is displaying two instances of the same workbook and wants to remove one.Which button should he click on the View tab?

Dawn wants to make a column chart look three dimensional.How can she do so?

To list the Product Type field values across the top of a PivotTable, add the Product Type field to the Rows area of the PivotTable Fields pane.

Mila wants to specify what data users can enter in a table column.What Excel feature should she use?

To move a worksheet, you can drag its sheet tab to the left or right.

The score of a student in two subjects are inserted in B2 and C2 cell and the passing score for each subject is 60.which of these functions will you insert in D2 cell to get FALSE as the result if the student has passed and TRUE as the result if the student has failed?

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

You can insert two types of controls in a worksheet: VBA controls and ActiveX controls.

You can import a text file that uses a divider such as a space, comma, or semicolon between columns of data.

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

By default, Excel records absolute cell references in macros.

Which of the following statements is true about COUNT functions?

Alba wants to display a picture as the worksheet background.Which of the following buttons on the Page Layout tab should she use?

In the formula =A8*$A$1, which of the following describes A8?

Which of the following are statistical functions? Select all the options that apply.

How can you tell if Solver is activated in your version of Excel?

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters