Question 1

Kylie has a table with a Skill Number column that contains values from 400 to 500.What type of filter can she use to select records with skill numbers less than 450?

Accepted Answer

A)  Advanced filter 
B)  Text filter 
C)  Number filter 
D)  AutoText Filter 
A)  Advanced filter 
B)  Text filter 
C)  Number filter 
D)  AutoText Filter

Question 2

Which of the following types of sorts can you apply to worksheet data? Select all the options that apply.

Accepted Answer

A)  single-column ascending sort in a table 
B)  multilevel descending sort in a table 
C)  single-column descending sort in a range of worksheet data 
D)  multilevel ascending sort in a range of worksheet data 
A)  single-column ascending sort in a table 
B)  multilevel descending sort in a table 
C)  single-column descending sort in a range of worksheet data 
D)  multilevel ascending sort in a range of worksheet data

Question 3

Which of these is the default layout for a newly created Pivot table?

Accepted Answer

A)  Compact Form 
B)  Outline Form 
C)  Tabular Form 
D)  Chart Form 
A)  Compact Form 
B)  Outline Form 
C)  Tabular Form 
D)  Chart Form

Question 4

You can create conditional cell formats using either the Home tab or the _____.

Accepted Answer

A)  Quick Analysis tool 
B)  Cell Styles dialog box 
C)  Font formatting buttons on the Home tab 
D)  Number formatting buttons on the Home tab 
A)  Quick Analysis tool 
B)  Cell Styles dialog box 
C)  Font formatting buttons on the Home tab 
D)  Number formatting buttons on the Home tab

Question 5

After adding data to a table where a filter is applied, what should you do to filter the new data?

Accepted Answer

A)  Sort the table. 
B)  Reapply the filter. 
C)  Refresh the data in the table. 
D)  Clear the filter. 
A)  Sort the table. 
B)  Reapply the filter. 
C)  Refresh the data in the table. 
D)  Clear the filter.

Question 6

When you copy and paste a formula with absolute cell references, Excel substitutes new references to reflect the new formula location.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following functions can you use to display the middle characters in specified text?

Accepted Answer

A)  MIDDLE 
B)  MID 
C)  TEXT 
D)  CENTER 
A)  MIDDLE 
B)  MID 
C)  TEXT 
D)  CENTER

Question 8

Adding a table to the data model is also called adding a _____.

Accepted Answer

A)  pivot 
B)  query 
C)  relationship 
D)  transformation 
A)  pivot 
B)  query 
C)  relationship 
D)  transformation

Question 9

To use the Track Changes feature, you can add the Track Changes button to the ribbon using the Track changes (Legacy) command.

Accepted Answer

A) True 
 B)False

Question 10

You should not move a PivotChart because it must be on the same worksheet as its PivotTable.

Accepted Answer

A) True 
 B)False

Question 11

Elise is preparing to print a worksheet that displays the worksheet name centered at the bottom of every page.She also wants to display the current date next to the worksheet name.Which of the following should she do?

Accepted Answer

A)  Edit the footer to add the date. 
B)  Add a header to display the date. 
C)  Add the date to a worksheet cell. 
D)  Add a document property showing the current date. 
A)  Edit the footer to add the date. 
B)  Add a header to display the date. 
C)  Add the date to a worksheet cell. 
D)  Add a document property showing the current date.

Question 12

You can use the DELETE key to clear cell contents.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following is true about pasting copied text? Select all the options that apply.

Accepted Answer

A)  You can only paste one cell of the copied text at a time. 
B)  You can use the Paste button in the Clipboard group to paste the copied text. 
C)  Copied text is deleted from the clipboard after you paste it once. 
D)  You can view the copied text on the Office Clipboard. 
A)  You can only paste one cell of the copied text at a time. 
B)  You can use the Paste button in the Clipboard group to paste the copied text. 
C)  Copied text is deleted from the clipboard after you paste it once. 
D)  You can view the copied text on the Office Clipboard.

Question 14

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 15

To remove conditional formatting from a selected range, you can select the rule in the Conditional Formatting Rules Manager dialog box, then click the Delete Rule button.

Accepted Answer

A) True 
 B)False

Question 16

Haley needs to delete an out-of-date column in a table.How can she do so?

Accepted Answer

A)  Click the worksheet column heading and then press DEL 
B)  Right-click the table column and then click Delete. 
C)  lick the Delete arrow in the Cells group and then click Delete Field. 
D)  Click the Remove Old button in the Tools group. 
A)  Click the worksheet column heading and then press DEL 
B)  Right-click the table column and then click Delete. 
C)  lick the Delete arrow in the Cells group and then click Delete Field. 
D)  Click the Remove Old button in the Tools group.

Question 17

Dante uses a worksheet to list sales data from five stores he manages.The worksheet includes a column named Product Type, and Dante wants to calculate subtotals for each product type.What must he do before using the Subtotal feature?

Accepted Answer

A)  Sort the data in the Product Type column., 
B)  Convert the range to a table. 
C)  Outline the data. 
D)  Remove calculated columns. 
A)  Sort the data in the Product Type column., 
B)  Convert the range to a table. 
C)  Outline the data. 
D)  Remove calculated columns.

Question 18

Eleanor wants to print the titles that appear in rows 2 and 3 of her worksheet.What does she need to specify in the Page Setup dialog box?

Accepted Answer

A)  Rows to repeat at the top of the worksheet 
B)  Print area to select 
C)  Columns to repeat at the left of the worksheet 
D)  Amount to rotate the titles so they fit on the page 
A)  Rows to repeat at the top of the worksheet 
B)  Print area to select 
C)  Columns to repeat at the left of the worksheet 
D)  Amount to rotate the titles so they fit on the page

Question 19

Stuart inserts the formula '=YEAR ('23-Aug-2012)' into cell B12.When he presses ENTER, 23/08/2012 will appear in B12.

Accepted Answer

A) True 
 B)False

Question 20

Tracing formula _____ shows which formulas are affected by an error in another cell.

Accepted Answer

A)  name 
B)  scope 
C)  dependents 
D)  arguments 
A)  name 
B)  scope 
C)  dependents 
D)  arguments

Kylie has a table with a Skill Number column that contains values from 400 to 500.What type of filter can she use to select records with skill numbers less than 450?

Which of the following types of sorts can you apply to worksheet data? Select all the options that apply.

Which of these is the default layout for a newly created Pivot table?

You can create conditional cell formats using either the Home tab or the _____.

After adding data to a table where a filter is applied, what should you do to filter the new data?

When you copy and paste a formula with absolute cell references, Excel substitutes new references to reflect the new formula location.

Which of the following functions can you use to display the middle characters in specified text?

Adding a table to the data model is also called adding a _____.

To use the Track Changes feature, you can add the Track Changes button to the ribbon using the Track changes (Legacy) command.

You should not move a PivotChart because it must be on the same worksheet as its PivotTable.

Elise is preparing to print a worksheet that displays the worksheet name centered at the bottom of every page.She also wants to display the current date next to the worksheet name.Which of the following should she do?

You can use the DELETE key to clear cell contents.

Which of the following is true about pasting copied text? Select all the options that apply.

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

To remove conditional formatting from a selected range, you can select the rule in the Conditional Formatting Rules Manager dialog box, then click the Delete Rule button.

Haley needs to delete an out-of-date column in a table.How can she do so?

Dante uses a worksheet to list sales data from five stores he manages.The worksheet includes a column named Product Type, and Dante wants to calculate subtotals for each product type.What must he do before using the Subtotal feature?

Eleanor wants to print the titles that appear in rows 2 and 3 of her worksheet.What does she need to specify in the Page Setup dialog box?

Stuart inserts the formula '=YEAR ('23-Aug-2012)' into cell B12.When he presses ENTER, 23/08/2012 will appear in B12.

Tracing formula _____ shows which formulas are affected by an error in another cell.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters

Exam 7: Excel

Kylie has a table with a Skill Number column that contains values from 400 to 500.What type of filter can she use to select records with skill numbers less than 450?

Which of the following types of sorts can you apply to worksheet data? Select all the options that apply.

Which of these is the default layout for a newly created Pivot table?

You can create conditional cell formats using either the Home tab or the _____.

After adding data to a table where a filter is applied, what should you do to filter the new data?

When you copy and paste a formula with absolute cell references, Excel substitutes new references to reflect the new formula location.

Which of the following functions can you use to display the middle characters in specified text?

Adding a table to the data model is also called adding a _____.

To use the Track Changes feature, you can add the Track Changes button to the ribbon using the Track changes (Legacy) command.

You should not move a PivotChart because it must be on the same worksheet as its PivotTable.

Elise is preparing to print a worksheet that displays the worksheet name centered at the bottom of every page.She also wants to display the current date next to the worksheet name.Which of the following should she do?

You can use the DELETE key to clear cell contents.

Which of the following is true about pasting copied text? Select all the options that apply.

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

To remove conditional formatting from a selected range, you can select the rule in the Conditional Formatting Rules Manager dialog box, then click the Delete Rule button.

Haley needs to delete an out-of-date column in a table.How can she do so?

Dante uses a worksheet to list sales data from five stores he manages.The worksheet includes a column named Product Type, and Dante wants to calculate subtotals for each product type.What must he do before using the Subtotal feature?

Eleanor wants to print the titles that appear in rows 2 and 3 of her worksheet.What does she need to specify in the Page Setup dialog box?

Stuart inserts the formula '=YEAR ('23-Aug-2012)' into cell B12.When he presses ENTER, 23/08/2012 will appear in B12.

Tracing formula _____ shows which formulas are affected by an error in another cell.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters