36387846
Descrição
Quiz por Holly Harper, atualizado more than 1 year ago
|
Criado por Holly Harper
mais de 4 anos atrás
|
|
Questão 1
Questão
In an Excel table, which of the following contains descriptive titles or labels?
Responda
-
header row
-
record
-
field
-
cell
Questão 2
Questão
What type of file can most software applications read?
Responda
-
Word documents
-
Excel worksheets
-
Access queries
-
Text files
Questão 3
Questão
Which of the following is not true for a calculated field in a PivotTable?
Responda
-
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.
Questão 4
Questão
How many rows must the criteria range of an Advanced Filter have?
Responda
-
at least 1
-
at least 2
-
3 or more
-
no more than 5
Questão 5
Questão
Which of the following statements is not true for importing?
Responda
-
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.
Questão 6
Questão
Which of the following is a list of related pieces of information that is formatted with a title row followed by rows of data?
Responda
-
table
-
header row
-
record
-
PivotTable
Questão 7
Questão
Which of the following is used for recognizing a pattern in the first cell and suggesting data for the remaining rows in a column?
Responda
-
AutoFilter
-
Advanced Filter
-
Flash Fill
-
PivotTable
Questão 8
Questão
When you first create an Excel table, how is it named?
Responda
-
TableA, where A is a letter
-
TableC, where C is a character
-
TableN, where N is a number
-
TableS, where S is a symbol
Questão 9
Questão
Which of the following applies formats to cells only when the cells meet the criteria?
Responda
-
Format Painter
-
Cell Styles
-
Themes
-
Conditional Formatting
Questão 10
Questão
Which of the following is not a sort option?
Responda
-
cell icon
-
font color
-
fill color
-
cell style
Quer criar seus próprios Quizzes gratuitos com a GoConqr? Saiba mais.