Holly Harper
Quiz by , created more than 1 year ago

Excel 4 final review

1
0
0
Holly Harper
Created by Holly Harper almost 4 years ago
Close

Excel 4

Excel 4

Question 1 of 10

1

In an Excel table, which of the following contains descriptive titles or labels?

Select one of the following:

  • header row

  • record

  • field

  • cell

Explanation

Question 2 of 10

1

What type of file can most software applications read?

Select one of the following:

  • Word documents

  • Excel worksheets

  • Access queries

  • Text files

Explanation

Question 3 of 10

1

Which of the following is not true for a calculated field in a PivotTable?

Select one of the following:

  • The name for a calculated field must be unique.

  • A calculated field is a field in the PivotTable that is not a field in the source data.

  • A calculated field uses a value field from the PivotTable's underlying data in a formula.

  • After you insert a calculated field, it cannot be moved.

Explanation

Question 4 of 10

1

How many rows must the criteria range of an Advanced Filter have?

Select one of the following:

  • at least 1

  • at least 2

  • 3 or more

  • no more than 5

Explanation

Question 5 of 10

1

Which of the following statements is not true for importing?

Select one of the following:

  • You can import a Word document into Excel.

  • You can copy and paste data from Word into an Excel worksheet.

  • It is possible to import text files directly into Excel.

  • It is possible to save a Word document as a text file.

Explanation

Question 6 of 10

1

Which of the following is a list of related pieces of information that is formatted with a title row followed by rows of data?

Select one of the following:

  • table

  • header row

  • record

  • PivotTable

Explanation

Question 7 of 10

1

Which of the following is used for recognizing a pattern in the first cell and suggesting data for the remaining rows in a column?

Select one of the following:

  • AutoFilter

  • Advanced Filter

  • Flash Fill

  • PivotTable

Explanation

Question 8 of 10

1

When you first create an Excel table, how is it named?

Select one of the following:

  • TableA, where A is a letter

  • TableC, where C is a character

  • TableN, where N is a number

  • TableS, where S is a symbol

Explanation

Question 9 of 10

1

Which of the following applies formats to cells only when the cells meet the criteria?

Select one of the following:

  • Format Painter

  • Cell Styles

  • Themes

  • Conditional Formatting

Explanation

Question 10 of 10

1

Which of the following is not a sort option?

Select one of the following:

  • cell icon

  • font color

  • fill color

  • cell style

Explanation

Previous
Next