Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

TIC > Stage 4 > Flashcards

Stage 4 Flashcards

1
Q

Microsoft Excel

A

It is used to collect and organize data in rows and columns that contain the spreadsheets, the way in which they are shown tables, graphs, and databases.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Main elements of the Excel screen

A

File menu: Backstage view
Quick access toolbar: The most used command buttons and above or below the ribbon
Ribbon: Start, Insert, Layout, Formulas, Data, Review, View
Spreadsheet: Divided in cells columns (16384) and rows (1048576). Cell references is the name of each cell A1
Name box: It is observed mainly the Cell Reference where the cursor is located.
Formula bar: It is where it is observed the content of the cell.
Active cell: Selected cell that has the filling control
Label sheets: They are used to identify the sheets nad to add more.
Navigation buttons: They are used to move different sheets.
Status bar: Operations performed in the spreadsheet, view buttons and zoom button

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Files of Microsoft Excel

A

Book1, Sheet 1

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Visualize many opened books

A

View tab
Group window, switch windows
Click on the file

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Insert sheet

A

Home tab
Group cells, button insert
Insert sheet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Delete sheet

A

Home tab
Group cells, button delete
Delete sheet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Rename sheet

A

Home tab
Group cells, button format
Organize sheets, rename sheet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Numerical data

A

Numbers, dates and hours

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Numbers

A

Whole
Positive and negative
Comma style
Indicators of the number $ or %

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Alphanumerical data

A

All texts, combination of letters and numbers, symbols and space (String)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Formulas with cell reference

A

Relative reference: Relative position of the cells
Absolute reference: Refers to the position of the cell that remains fixed when being copied or moved. $
Mixed reference: Relative position and absolute.
External reference: Cells in other spreadsheets or wordbook.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Formulas with cell reference

A

Formulas that use the name of the cell references to perform the operations with their content.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Functions

A

Predefined formulas that Excel has to perform operations with the numerial and alphanumerical data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Syntax

A

= Name of the function (Arguments)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Insert function

A 
Click on the cell
Click on the formula tab
Select the button insert function
Choose the category
Select a function
Write the arguments
Click on OK
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Examples of functions

A

SUM Sums the content of a range of cells
AVERAGE Calculates the arithmetic means of the arguments
MAX Finds the maximum value
MIN Finds the minimum value of a range of cells
NOW () Shows the current date and time
IF Evaluates if a condition is fulfilled and returns a value if it is ture and other if it is false
COUNT Counts the numer of cells that contains numerical data.
COUNTIF Counts the number of cells that contain
numerical data and fullfill with a condition
VLOOKUP Finds a numerical or alphanumerical value in a table and returns the value that is indicated.

17
Q

Data selection (Range of cells)

A

The cursor is placed over a cell and the mouse pointer is dragged to the last cell.
Give a click on a cell, SHIFT key and click on the last cell.
It is selected a range of cells and press Ctrl key and select other range of cells

18
Q

Data selection (Rows / Columns)

A

Click on the header of the row/column and drag the mouse pointer
A range of rows /columns is selected and press Ctrl key and select other rows or columns.

19
Q

Undo button

A

It is used to correct errors.

20
Q

Redo button

A

It is used to restore the action performed with the Undo button.

21
Q

Groups in the home tab

A 
Cells
Font
Alignment
Number
Clipboard
Editing
22
Q

Group Cells

A

Insert (Rows, cells, columns)
Delete
Format (Height o rows and with of the columns)

23
Q

Group Font

A 
Type of font (Calibri)
Font size (11)
Font style (Bold, italic, underline)
Borders (Borders of the cells)
Fill color (Red)
Font color (Yellow)
24
Q

Group Alignment

A

Vertical (Upper, middle, inferior)
Horizontal (Left, center, right)
Merge and center (Combine)

25
Q

Group number

A 
Increase decimals (4.12322)
Decrease decilmals (4.12)
Percentage (%)
Accounting number ($)
26
Q

Group clipboard

A

Copy
Cut (Move)
Paste

27
Q

Group editing

A

Sort (Order numerical and alphanumerical data)
Fill (Capture data that have repetitive sequence or in a determined format)
Clear (Modify or delete the content of the cells)

28
Q

Page layout tab - Page setup group

A

Page: Orientation, size and scaling
Margins: Top, bottom, right, left, header and footer, center on page, print
Sheet: Establish the area desired to print

29
Q

Preview

A

Permits to confirm that is fulfilled all the characteristics of the design.

30
Q

Review tab Comments group

A

A comment is used to place a note in a cell to document its content.
Cell-Review-New comment

31
Q

Charts

A

They are used to visualize in a clearest way the data contained in a spreadsheet

32
Q

Types of charts

A

Column: Comparatives of the series of data in vertical form.
Line: More than one series of data and shows tendencies.
Pie: Proportions of the graphed parts
Bar: Comparatives of the series of data in horizontal form

33
Q

Components of chart

A

Chart area: Area that surrounds all the components of the chart.
Plot area: Area that contains only the used kind of chart.
Chart title
Horizontal Axis Title (Category)
Vertical Axis Title (Value)
Horizontal Axis
Vertical Axis
Series: Columns of data that are being graphed.
Legend: Labels that define the name of the series that are being graphed.
Division lines: Horizontal lines that help to visualize the values in the Y axis
Data labels: They are the data that represent the columns of data to graph.

34
Q

Freeze / Unfreeze

A

View tab, window group, Freeze panes, select the top row / first column / freeze panes

35
Q

Databases concepts

A

Row header: First row, name of the fields
Record: Each one of the rows that conform the table
Field: Each one of the columns that forms the table.

36
Q

Filters (Data tab, Sort&Filter group)

A 
Numerical data
-Font color
-Exact value
-From a value
-Range of values
Alphanumerical data
-An exact text
-That begins with and finishes with
- A range of texts

TIC (4 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions