36387846
Descripción
Test por Holly Harper, actualizado hace más de 1 año
|
Creado por Holly Harper
hace más de 4 años
|
|
Pregunta 1
Pregunta
In an Excel table, which of the following contains descriptive titles or labels?
Respuesta
-
header row
-
record
-
field
-
cell
Pregunta 2
Pregunta
What type of file can most software applications read?
Respuesta
-
Word documents
-
Excel worksheets
-
Access queries
-
Text files
Pregunta 3
Pregunta
Which of the following is not true for a calculated field in a PivotTable?
Respuesta
-
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.
Pregunta 4
Pregunta
How many rows must the criteria range of an Advanced Filter have?
Respuesta
-
at least 1
-
at least 2
-
3 or more
-
no more than 5
Pregunta 5
Pregunta
Which of the following statements is not true for importing?
Respuesta
-
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.
Pregunta 6
Pregunta
Which of the following is a list of related pieces of information that is formatted with a title row followed by rows of data?
Respuesta
-
table
-
header row
-
record
-
PivotTable
Pregunta 7
Pregunta
Which of the following is used for recognizing a pattern in the first cell and suggesting data for the remaining rows in a column?
Respuesta
-
AutoFilter
-
Advanced Filter
-
Flash Fill
-
PivotTable
Pregunta 8
Pregunta
When you first create an Excel table, how is it named?
Respuesta
-
TableA, where A is a letter
-
TableC, where C is a character
-
TableN, where N is a number
-
TableS, where S is a symbol
Pregunta 9
Pregunta
Which of the following applies formats to cells only when the cells meet the criteria?
Respuesta
-
Format Painter
-
Cell Styles
-
Themes
-
Conditional Formatting
Pregunta 10
Pregunta
Which of the following is not a sort option?
Respuesta
-
cell icon
-
font color
-
fill color
-
cell style
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.