Lesson 6: Advanced Spreadsheet Skills Flashcards by Brainy Bees Co.

allows
users to organize data in rows
an columns and perform
calculations on the data

Spreadsheet Software

How well did you know this?

Not at all

Perfectly

It is a software application that enables a user to save, sort and manage data in an arranged form of rows and columns.

Spreadsheet

How well did you know this?

Not at all

Perfectly

Rows and columns on a spreadsheet are collectively called

worksheet

How well did you know this?

Not at all

Perfectly

Seven examples of Spreadsheet Software

LibreOffice Calc, OpenOffice.Org Calc, Google Sheets, Apple iWork Numbers, Kingsoft Office Spreadsheets, StarOffice Calc, Microsoft Excel

How well did you know this?

Not at all

Perfectly

is a spreadsheet developed
by Microsoft for Windows, macOS, Android
and iOS. It features calculation, graphing
tools, pivot tables, and a macro
programming language

Microsoft Excel

How well did you know this?

Not at all

Perfectly

Macro programming language in MS Excel is called

Visual Basic for Applications

How well did you know this?

Not at all

Perfectly

How to open MS Excel

Windows Logo + R, then type excel then enter

How well did you know this?

Not at all

Perfectly

horizontal line of
entries in a table.

Row

How well did you know this?

Not at all

Perfectly

vertical line of
entries in a table.

column

How well did you know this?

Not at all

Perfectly

identified with alphabetic headings

columns

How well did you know this?

Not at all

Perfectly

identified with numeric headings

rows

How well did you know this?

Not at all

Perfectly

the place where info. is
held in a spreadsheet

cell

How well did you know this?

Not at all

Perfectly

the selected cell

active cell

How well did you know this?

Not at all

Perfectly

the currently selected cell in a spreadsheet and is indicated by a bold outline that surrounds the cell

active cell

How well did you know this?

Not at all

Perfectly

the box at
the top of each column
containing a letter

column heading

How well did you know this?

Not at all

Perfectly

the row number

row heading

How well did you know this?

Not at all

Perfectly

the cell address of the cell usually
combine letter and number (ex. A1, B4, C2)

cell reference

How well did you know this?

Not at all

Perfectly

combining or joining two or more cells

merge

How well did you know this?

Not at all

Perfectly

are predefined formulas and are already
available in Excel

functions

How well did you know this?

Not at all

Perfectly

the bar that displays the contents of a cell

formula bar

How well did you know this?

Not at all

Perfectly

returns the sum of x and y or
(all the numbers within the range)

=SUM(x,y) or =SUM(range)

How well did you know this?

Not at all

Perfectly

returns the product of x and y

=PRODUCT(x,y)

How well did you know this?

Not at all

Perfectly

returns the quotient of x divided by y

=QUOTIENT(x,y)

How well did you know this?

Not at all

Perfectly

returns the difference of x subtracted by y

=x-y

How well did you know this?

Not at all

Perfectly

returns the sum of x and y

=x+y

returns the product of x and y

=x*y

returns the quotient of x divided by y

=x/y

returns the difference of x subtracted by y

=x-y

returns the absolute value of x

=ABS(x)

returns the average of x and y

=AVERAGE(x,y)

joins x and y

=CONCATENATE(x,y)

returns x if the condition is true, else it returns y

=IF(Condition, x, y)

returns true if x is an even number

=ISEVEN(x)

returns true if x is an odd number

=ISODD(x)

counts the number of cell containing a number within a range

=COUNT(range)

count the number of cell that fits with the criteria within the range

=COUNTIF(range, criteria)

returns true if x is a number

=ISNUMBER(x)

returns true if x is a text

=ISTEXT(x)

returns the length of characters in x

=LEN(x)

returns the proper casing of x

=PROPER(x)

returns the characters of x specified by y (from the left)

=LEFT(x,y)

returns the characters of x specified by y (from the right)

=RIGHT(x,y)

returns the value of pi

=PI()

returns the smallest number between x and y

=MIN(x,y)

returns the largest number between x and y

=MAX(x,y)

returns the smallest number within the range

=MIN(range)

returns the largest number within the range

=MAX(range)

returns the value of x raised to the power of y

=POWER(x,y)

rounds x to a specified number of digits (y)

=ROUND(x,y)

returns the column number of x

=COLUMN(x)

returns the row number of x

=ROW(x)

returns the square root of x

=SQRT(x)

removes extra spaces in x

=TRIM(x)

returns x in all capital form

=UPPER(x)

returns x in non- capital form

=LOWER(x)

returns the current date

=TODAY()

returns the current date and time

=NOW()

It identifies the purpose of a cell, it can be a brief instruction, a title or caption

text or labels

a value that doesn’t change and is directly inserted into a cell.

number data or constant

an expression that calculates the value of a cell.

formula

MS Excel uses standard operators for formulas.

mathematical operators

pre-defined formulas that are already available in MS Excel.

functions

Adds all the numbers in a range of cells

=SUM(cell range)

Counts the number of cells that contain numbers.

=COUNT(cell range)

Adds the cells specified by a given condition or criteria.

=SUMIF(range, criteria, sum range)

Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.

=AVERAGEIF(range, criteria, average range)

The ___ of cells that you want to evaluate based on a given criteria.

range

t determines which cells will be added.

criteria

Counts the number of cells within a range that meet a single criterion that you specify.

=COUNTIF(range, criteria)

his function is one of the most popular functions in Excel. It can perform a logical test and returns one value if TRUE, and another value if FALSE. The following is the syntax of IF function:

=IF(logical test, value_if_true, value_if_false)