36387846
Beschreibung
Quiz von Holly Harper, aktualisiert more than 1 year ago
|
Erstellt von Holly Harper
vor mehr als 4 Jahre
|
|
Frage 1
Frage
In an Excel table, which of the following contains descriptive titles or labels?
Antworten
-
header row
-
record
-
field
-
cell
Frage 2
Frage
What type of file can most software applications read?
Antworten
-
Word documents
-
Excel worksheets
-
Access queries
-
Text files
Frage 3
Frage
Which of the following is not true for a calculated field in a PivotTable?
Antworten
-
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.
Frage 4
Frage
How many rows must the criteria range of an Advanced Filter have?
Antworten
-
at least 1
-
at least 2
-
3 or more
-
no more than 5
Frage 5
Frage
Which of the following statements is not true for importing?
Antworten
-
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.
Frage 6
Frage
Which of the following is a list of related pieces of information that is formatted with a title row followed by rows of data?
Antworten
-
table
-
header row
-
record
-
PivotTable
Frage 7
Frage
Which of the following is used for recognizing a pattern in the first cell and suggesting data for the remaining rows in a column?
Antworten
-
AutoFilter
-
Advanced Filter
-
Flash Fill
-
PivotTable
Frage 8
Frage
When you first create an Excel table, how is it named?
Antworten
-
TableA, where A is a letter
-
TableC, where C is a character
-
TableN, where N is a number
-
TableS, where S is a symbol
Frage 9
Frage
Which of the following applies formats to cells only when the cells meet the criteria?
Antworten
-
Format Painter
-
Cell Styles
-
Themes
-
Conditional Formatting
Frage 10
Frage
Which of the following is not a sort option?
Antworten
-
cell icon
-
font color
-
fill color
-
cell style
Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.