Question 1

Alicia created a chart that shows months in rows and prices in columns. She can switch the rows and columns to show prices in rows and months in columns.

Accepted Answer

A) True 
 B)False

Question 2

The default worksheet text is _____-point Calibri.

Accepted Answer

A)  10 
B)  11 
C)  12 
D)  14 
A)  10 
B)  11 
C)  12 
D)  14

Question 3

How can you drill down a PivotTable to display detailed data?

Accepted Answer

A)  Double-click a cell in the PivotTable. 
B)  Right-click a cell in the PivotTable, and then click Details. 
C)  Add a field to the Drill area of the PivotTable. 
D)  Click the minus button next to a field in the PivotTable. 
A)  Double-click a cell in the PivotTable. 
B)  Right-click a cell in the PivotTable, and then click Details. 
C)  Add a field to the Drill area of the PivotTable. 
D)  Click the minus button next to a field in the PivotTable.

Question 4

The NPV function calculates a loan's interest rate.

Accepted Answer

A) True 
 B)False

Question 5

If you want to rename a worksheet in a protected workbook, you must first unprotect the workbook.

Accepted Answer

A) True 
 B)False

Question 6

Which of these series of clicks will you select to add text to a SmartArt?

Accepted Answer

A)  Insert tab > Illustrations group > Online Pictures > Insert pictures > Select from menu > [Text] in Text pane > Type text 
B)  Insert tab > Illustrations group > SmartArt > Choose a SmartArt Graphic dialog box > Select type and layout >[Text] in Text pane > Type text 
C)  Insert tab > Illustrations group > Shapes > Recently used shapes > Select type and layout > [Text] in Text pane > Type text 
D)  Insert tab > Illustrations group > Take a Screenshot > Available Windows > Select from the menu > [Text] in Text pane > Type text 
A)  Insert tab > Illustrations group > Online Pictures > Insert pictures > Select from menu > [Text] in Text pane > Type text 
B)  Insert tab > Illustrations group > SmartArt > Choose a SmartArt Graphic dialog box > Select type and layout >[Text] in Text pane > Type text 
C)  Insert tab > Illustrations group > Shapes > Recently used shapes > Select type and layout > [Text] in Text pane > Type text 
D)  Insert tab > Illustrations group > Take a Screenshot > Available Windows > Select from the menu > [Text] in Text pane > Type text

Question 7

Nicole has a PivotTable that groups Order dates by quarters, months, and years. She wants to group the data by year only. To do so, she can use the Grouping dialog box to regroup the dates.

Accepted Answer

A) True 
 B)False

Question 8

If you discover an error immediately after you have confirmed a cell entry, what of the following would you use next?

Accepted Answer

A)  The Undo button on the Quick Access toolbar 
B)  The Cancel button on the Formula bar 
C)  The Enter button on the Formula bar 
D)  The Save button on the Quick Access toolbar 
A)  The Undo button on the Quick Access toolbar 
B)  The Cancel button on the Formula bar 
C)  The Enter button on the Formula bar 
D)  The Save button on the Quick Access toolbar

Question 9

If you click Existing File or Web Page in the Insert Hyperlink dialog box, select a workbook, click the Bookmark button, enter a cell reference, and then click OK, what are you linking to?

Accepted Answer

A)  A hidden location in another workbook 
B)  A cell in another workbook 
C)  Another workbook file 
D)  A worksheet in another workbook 
A)  A hidden location in another workbook 
B)  A cell in another workbook 
C)  Another workbook file 
D)  A worksheet in another workbook

Question 10

A workbook template has which of the following file extensions?

Accepted Answer

A)  .xltx 
B)  .xls 
C)  .xlsx 
D) .xlst 
A)  .xltx 
B)  .xls 
C)  .xlsx 
D) .xlst

Question 11

Which of the following methods copies an existing worksheet within the same workbook?

Accepted Answer

A)  Drag its sheet tab to a new location. 
B)  Press and hold CTRL and drag its sheet tab to a new location. 
C)  Press and hold SHIFT and drag its sheet tab to a new location. 
D)  Press and hold ALT and drag its sheet tab to a new location. 
A)  Drag its sheet tab to a new location. 
B)  Press and hold CTRL and drag its sheet tab to a new location. 
C)  Press and hold SHIFT and drag its sheet tab to a new location. 
D)  Press and hold ALT and drag its sheet tab to a new location.

Question 12

When you are using the default security settings and open a workbook containing VBA , you must click the Enable Content button to use the disabled content.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following type of data can you wrap within a cell?

Accepted Answer

A)  text 
B)  numbers 
C)  dates 
D)  times 
A)  text 
B)  numbers 
C)  dates 
D)  times

Question 14

You can create a query to retrieve data values into a table from which of the following types of files?

Accepted Answer

A)  CSV 
B)  Word document 
C)  Outlook address book 
D)  Word mail merge 
A)  CSV 
B)  Word document 
C)  Outlook address book 
D)  Word mail merge

Question 15

Which of the following functions do you often use with the INDEX function to find data from a specified row and column of data?

Accepted Answer

A)  MATCH 
B)  OR 
C)  HLOOKUP 
D)  RANGE 
A)  MATCH 
B)  OR 
C)  HLOOKUP 
D)  RANGE

Question 16

To combine the results of four separate scenarios, you create an Answer report.

Accepted Answer

A) True 
 B)False

Question 17

What appears next to a cell with data validation to indicate the type of data to enter in the cell?

Accepted Answer

A)  Title 
B)  Heading 
C)  Input message 
D)  Insert message 
A)  Title 
B)  Heading 
C)  Input message 
D)  Insert message

Question 18

When you import data by creating a query, Excel names the query using the name of the data source. You can rename the query in the _____.

Accepted Answer

A)  data source 
B)  Query Settings pane 
C)  Preview grid 
D)  Navigator window 
A)  data source 
B)  Query Settings pane 
C)  Preview grid 
D)  Navigator window

Question 19

Excel limits you to one calculated field per PivotTable.

Accepted Answer

A) True 
 B)False

Question 20

Applying conditional formatting is the best way to locate records with duplicates in more than one field.

Accepted Answer

A) True 
 B)False

Alicia created a chart that shows months in rows and prices in columns. She can switch the rows and columns to show prices in rows and months in columns.

The default worksheet text is _____-point Calibri.

How can you drill down a PivotTable to display detailed data?

The NPV function calculates a loan's interest rate.

If you want to rename a worksheet in a protected workbook, you must first unprotect the workbook.

Which of these series of clicks will you select to add text to a SmartArt?

Nicole has a PivotTable that groups Order dates by quarters, months, and years. She wants to group the data by year only. To do so, she can use the Grouping dialog box to regroup the dates.

If you discover an error immediately after you have confirmed a cell entry, what of the following would you use next?

If you click Existing File or Web Page in the Insert Hyperlink dialog box, select a workbook, click the Bookmark button, enter a cell reference, and then click OK, what are you linking to?

A workbook template has which of the following file extensions?

Which of the following methods copies an existing worksheet within the same workbook?

When you are using the default security settings and open a workbook containing VBA , you must click the Enable Content button to use the disabled content.

Which of the following type of data can you wrap within a cell?

You can create a query to retrieve data values into a table from which of the following types of files?

Which of the following functions do you often use with the INDEX function to find data from a specified row and column of data?

To combine the results of four separate scenarios, you create an Answer report.

What appears next to a cell with data validation to indicate the type of data to enter in the cell?

When you import data by creating a query, Excel names the query using the name of the data source. You can rename the query in the _____.

Excel limits you to one calculated field per PivotTable.

Applying conditional formatting is the best way to locate records with duplicates in more than one field.

Access 2019

Outlook 2019

Powerpoint 2019

Windows 10 - 2019

Word 2019

Computer History and Components

Filters

Exam 2: Excel 2019

Alicia created a chart that shows months in rows and prices in columns. She can switch the rows and columns to show prices in rows and months in columns.

The default worksheet text is _____-point Calibri.

How can you drill down a PivotTable to display detailed data?

The NPV function calculates a loan's interest rate.

If you want to rename a worksheet in a protected workbook, you must first unprotect the workbook.

Which of these series of clicks will you select to add text to a SmartArt?

Nicole has a PivotTable that groups Order dates by quarters, months, and years. She wants to group the data by year only. To do so, she can use the Grouping dialog box to regroup the dates.

If you discover an error immediately after you have confirmed a cell entry, what of the following would you use next?

If you click Existing File or Web Page in the Insert Hyperlink dialog box, select a workbook, click the Bookmark button, enter a cell reference, and then click OK, what are you linking to?

A workbook template has which of the following file extensions?

Which of the following methods copies an existing worksheet within the same workbook?

When you are using the default security settings and open a workbook containing VBA , you must click the Enable Content button to use the disabled content.

Which of the following type of data can you wrap within a cell?

You can create a query to retrieve data values into a table from which of the following types of files?

Which of the following functions do you often use with the INDEX function to find data from a specified row and column of data?

To combine the results of four separate scenarios, you create an Answer report.

What appears next to a cell with data validation to indicate the type of data to enter in the cell?

When you import data by creating a query, Excel names the query using the name of the data source. You can rename the query in the _____.

Excel limits you to one calculated field per PivotTable.

Applying conditional formatting is the best way to locate records with duplicates in more than one field.

Access 2019

Outlook 2019

Powerpoint 2019

Windows 10 - 2019

Word 2019

Computer History and Components

Filters