Excel Flashcards
When deleting a table
We can keep the data
The buttons AZ/ZA are used to…
Sort
To access Autofilter we need to
Select the option Filtro of the tab Datos
To create a summary of a data table we need to
Select the option Fila de totales of the tab Diseño
To change the format of a table, it is necessary to use the tab…
Diseño
Which functions are valid to work with tables?
DCOUNT
DCOUNTA
DMAX
DMIN
DPRODUCT
DAVERAGE
DSUM
DGET
DVAR
DSTDEV
To be able to create a pivot table…
The cells can be selected in a prior step
When filtering data
The values that we want to display have to be selected
When a row is deleted from a table
Deletes only that row from the table &moves all rows in the table up.
To create a summary of the data table you must
Check the Totals Row option on the Table Layout tab.
When a filter is applied to the data in a table, then:
The values to be displayed must be marked
A pivot table can be placed:
In any cell of the same sheet, of another existing sheet or of a new sheet
Before you create a pivot table in Excel, you need to
The data is organized in the form of a table and records but does not need to be an Excel table.
When a table is created from a range of raw data, then
In the first row of the table, the table header is automatically formatted according to whether we choose (or not) this option
When we define a range of data as a table…
We can indicate whether the table has headers or not
Types of data that can be sorres un a table
Textual, numerical,date/time
The data can be ordered
Alphabetically, by format, by personalized lists.
To calculate average
DAVERAGE
The order of parameters in a database function is
Database; Field; Criteria
With pivot tables you can
Move rows to columns and viceversa
Pivot graphics are a thing
Eso era to
The style of the tables
Can be changed from the design menu and you can create custom styles.
