Copy and Edit

Excel 4

Description

Excel 4 final review
Holly Harper
Quiz by Holly Harper, updated more than 1 year ago
Holly Harper
Created by Holly Harper over 4 years ago
1
0
0

Resource summary

Question 1

Question
In an Excel table, which of the following contains descriptive titles or labels?
Answer
  • header row
  • record
  • field
  • cell

Question 2

Question
What type of file can most software applications read?
Answer
  • Word documents
  • Excel worksheets
  • Access queries
  • Text files

Question 3

Question
Which of the following is not true for a calculated field in a PivotTable?
Answer
  • 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.

Question 4

Question
How many rows must the criteria range of an Advanced Filter have?
Answer
  • at least 1
  • at least 2
  • 3 or more
  • no more than 5

Question 5

Question
Which of the following statements is not true for importing?
Answer
  • 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.

Question 6

Question
Which of the following is a list of related pieces of information that is formatted with a title row followed by rows of data?
Answer
  • table
  • header row
  • record
  • PivotTable

Question 7

Question
Which of the following is used for recognizing a pattern in the first cell and suggesting data for the remaining rows in a column?
Answer
  • AutoFilter
  • Advanced Filter
  • Flash Fill
  • PivotTable

Question 8

Question
When you first create an Excel table, how is it named?
Answer
  • TableA, where A is a letter
  • TableC, where C is a character
  • TableN, where N is a number
  • TableS, where S is a symbol

Question 9

Question
Which of the following applies formats to cells only when the cells meet the criteria?
Answer
  • Format Painter
  • Cell Styles
  • Themes
  • Conditional Formatting

Question 10

Question
Which of the following is not a sort option?
Answer
  • cell icon
  • font color
  • fill color
  • cell style
Show full summary Hide full summary

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

Browse Library