TIC Etapa 3

TIC Etapa 3

by Roxana Beristain

​Main Elements of the Excel Screen

​

Multiple Choice

Shows through the bakstage view the basic commands.

• File menu

• Quick access toolbar

• Ribbon

• Spreadsheet

Multiple Choice

You can add or remove command buttons by clicking on the arrow on the right side and selecting in the dialog window the buttons you want to add or remove, as well as determining the location of the toolbar.

• File menu

• Quick access toolbar

• Ribbon

• Spreadsheet

Multiple Choice

Here are the differents tabs that contain groups and command buttons.

E: Home, Insert, Page, Layout, Formulas, Data, Review and View.

• File menu

• Quick access toolbar

• Ribbon

• Spreadsheet

Multiple Choice

It is divided into cells, made up of columns labeled by letters, and rows labeled with numbers.

• File menu

• Quick access toolbar

• Ribbon

• Spreadsheet

Multiple Choice

It is where the cell reference in which the cursos is located is mainly observed, it also serves to assign a name to a range of cell.

• Name box

• Formula Bar

• Active Cell

• Labeles sheet:

Multiple Choice

It is where you can see the content of the cell.

• Name box

• Formula Bar

• Active Cell

• Labeles sheet:

Multiple Choice

It is the cell that is selected in the spreadsheet, it is displayed by means of a box that formas its outline and its fill button.

• Name box

• Formula Bar

• Active Cell

• Labeles sheet:

Multiple Choice

Labels are used to identify sheets, in addition to assigning or renaiming different worksheets.

• Name box

• Formula Bar

• Active Cell

• Labeles sheet

Multiple Choice

To assign a spreadsheet, click on sheet and then change name.

• Rename sheet

• Navigation buttons

• Status bar

• Labeles sheet

Multiple Choice

The navigation buttons are used to move to the different spreadsheets that the workbook contains when the space to display the labels of the leaves is insufficient.

• Rename sheet

• Navigation buttons

• Status bar

• Labeles sheet

Multiple Choice

This bar shows the operation carried out in the spreadsheet, in addition to the different view buttons and the zoom slider button.

• Rename sheet

• Navigation buttons

• Status bar

• Labeles sheet

Multiple Choice

With this command button, cells, rows and columns can be inserted into the spreadsheet when a table is being elaborated and some of them need to be added.

• Insert

• Delete

• Format

• Merge and Center

Multiple Choice

With this command button it is possible to delete cells, rows and columns in the spreadsheet when a table is being elaborated and some of them need to be deleted.

• Insert

• Delete

• Format

• Merge and Center

Multiple Choice

With this command button it is possible to modify the height of the rows and the width of the columns in the spreadsheet when a table is being elaborated.

• Insert

• Delete

• Format

• Merge and Center

Multiple Choice

With this command button you can combne several cells into one, with a range of horizontal cells or with a range of vertical cells.

• Insert

• Delete

• Format

• Merge and Center

Data types​

​

Multiple Choice

The main elements are numbers, dates and times, with them we can perform arithmetic operations, use functions, make a report from a database, etc.

• Numerical Data

• Alphanumeric Data

• Boolean

• Null

Multiple Choice

Is all text, combination of letters and numbers, symbols and spaces; they are mainly used the statements, headings, signs, etc.

• Numerical Data

• Alphanumeric Data

• Boolean

• Null

Multiple Choice

Also called a logical value, is a data tyoe derived from the result of a function that can be answered as False / True where Flase takes the value of 0 and true the value of 1.

• Numerical Data

• Alphanumeric Data

• Boolean

• Null

Multiple Choice

it a can also be considered a blank cell, this can affect when the data is plotted; this tyoe of data can be onitted to make that graph show a solid line, or it can be displayed on graphs as dashed lines.

• Numerical Data

• Alphanumeric Data

• Boolean

• Null

Fill in the Blank

Allows previosly copied or cut information to remain.

Basic Tools​

​

Multiple Choice

Is used to give a betrer presentations to the data found in a spreadsheet; numerical data can be ordered from smallest to largest or largest to smallest.

• Sort

• Fill

• Delete

• Comments

Multiple Choice

Is used in a spreadsheet to capture data that has a repeating sequence or a certain format.

• Sort

• Fill

• Delete

• Comments

Multiple Choice

is used to modify or delete the content of cells in the spreadsheet.

• Sort

• Fill

• Delete

• Comments

Multiple Choice

Is used to place a note that serves to document the content of a cell.

• Sort

• Fill

• Delete

• Comments

Multiple Choice

When the capture of the information in a spreadsheet is extensive like that used in a database, it is necessary to leave a series of rows, colums or both fixed, which facilitate the introduction of data.

• Filters

• immobilize / Mobilize Panels

• Sparklines

• Create a Dropdown List

Multiple Choice

This option is used to make a report on a database, that is, that of all records in a range of cells or in a table, only the records that meet the condition of one or more fields will be displayed.

• Filters

• immobilize / Mobilize Panels

• Sparklines

• Create a Dropdown List

Multiple Choice

Is very small graph located in a cell, which provides a greater visual impact of trends whether they are increased or decreased and highlights minimum and maximum values.

• Filters

• immobilize / Mobilize Panels

• Sparklines

• Create a Dropdown List

Multiple Choice

Is a collection of valid that is generated from the calues located in a range of cells , the values of thet range of cells are what shape the options of a list.

• Filters

• immobilize / Mobilize Panels

• Sparklines

• Create a Dropdown List

Multiple Choice

You can insert a functional mini calendar into the spreadsheet.

• Checkboxes

• Conditional Formatting of Cells

• Mini calendar

• Separate text in columns

Multiple Choice

You can insert a functional such as checkboxes or radio button to faciliate data entry.

• Checkboxes

• Conditional Formatting of Cells

• Mini calendar

• Separate text in columns

Multiple Choice

Helps highlight cells that meet certain criteria.

• Checkboxes

• Conditional Formatting of Cells

• Mini calendar

• Separate text in columns

Multiple Choice

You can replace or divide text in multiple cells

• Checkboxes

• Conditional Formatting of Cells

• Mini calendar

• Separate text in columns

Multiple Choice

By means of the concatenate function you can join teo or more columns of text into one.

• Joining Two or More Columns of text into Ones.

• Percentages

• File Password

Multiple Choice

These are different ways to obtain percentges in excel, here we will practice two different and very useful ways.

• Joining Two or More Columns of text into Ones.

• Percentages

• File Password

Multiple Choice

The password protects a file containing confidential information to prevent other isers from accessing that data.

• Joining Two or More Columns of text into Ones.

• Percentages

• File Password

Special Tools​

​

Multiple Choice

The information that is entered in a spreadsheet is normally captured in the form of a table, this structure allows the data to behave like a database and have compatibility with other types of application software that manipulate databases such as Access, Visual Basic, Word, etc.

• Data base

• Pivot tables

• Pivot charts

• Macros

Multiple Choice

Is an advanced tool for calculating, summarizing, and analyzing data that allows you to see comparisons, patterns, and trends in data.

• Data base

• Pivot tables

• Pivot charts

• Macros

Multiple Choice

Information in a database is sometimes difficult to interpret, so ____ are an excellent way to aggregate data visualizations.

• Data base

• Pivot tables

• Pivot charts

• Macros

Multiple Choice

When we constantly need to use the same commands or when it comes to complex or multi-step processes, ____ record a command sequence so that they can be automatically executed by the user at a certain time.

• Data base

• Pivot tables

• Pivot charts

• Macros