Brainscape's Knowledge GenomeTM

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


See full index

Quarter 1: Empowerment Technologies > Lesson 6: Advanced Spreadsheet Skills > Flashcards

Lesson 6: Advanced Spreadsheet Skills Flashcards

1
Q

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

A

Spreadsheet Software

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

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

A

Spreadsheet

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

Rows and columns on a spreadsheet are collectively called

A

worksheet

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

Seven examples of Spreadsheet Software

A

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

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

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

A

Microsoft Excel

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

Macro programming language in MS Excel is called

A

Visual Basic for Applications

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

How to open MS Excel

A

Windows Logo + R, then type excel then enter

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

horizontal line of
entries in a table.

A

Row

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

vertical line of
entries in a table.

A

column

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

identified with alphabetic headings

A

columns

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

identified with numeric headings

A

rows

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

the place where info. is
held in a spreadsheet

A

cell

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

the selected cell

A

active cell

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

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

A

active cell

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

the box at
the top of each column
containing a letter

A

column heading

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

the row number

A

row heading

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

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

A

cell reference

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

combining or joining two or more cells

A

merge

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

are predefined formulas and are already
available in Excel

A

functions

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

the bar that displays the contents of a cell

A

formula bar

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

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

A

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

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

returns the product of x and y

A

=PRODUCT(x,y)

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

returns the quotient of x divided by y

A

=QUOTIENT(x,y)

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

returns the difference of x subtracted by y

A

=x-y

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

returns the sum of x and y

A

=x+y

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

returns the product of x and y

A

=x*y

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

returns the quotient of x divided by y

A

=x/y

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

returns the difference of x subtracted by y

A

=x-y

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

returns the absolute value of x

A

=ABS(x)

30
Q

returns the average of x and y

A

=AVERAGE(x,y)

31
Q

joins x and y

A

=CONCATENATE(x,y)

32
Q

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

A

=IF(Condition, x, y)

33
Q

returns true if x is an even number

A

=ISEVEN(x)

34
Q

returns true if x is an odd number

A

=ISODD(x)

35
Q

counts the number of cell containing a
number within a range

A

=COUNT(range)

36
Q

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

A

=COUNTIF(range, criteria)

37
Q

returns true if x is a number

A

=ISNUMBER(x)

38
Q

returns true if x is a text

A

=ISTEXT(x)

39
Q

returns the length of characters in x

A

=LEN(x)

40
Q

returns the proper casing of x

A

=PROPER(x)

41
Q

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

A

=LEFT(x,y)

42
Q

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

A

=RIGHT(x,y)

43
Q

returns the value of pi

A

=PI()

44
Q

returns the smallest number between x and y

A

=MIN(x,y)

45
Q

returns the largest number between x and y

A

=MAX(x,y)

46
Q

returns the smallest number within the range

A

=MIN(range)

47
Q

returns the largest number within the range

A

=MAX(range)

48
Q

returns the value of x raised to the power of y

A

=POWER(x,y)

49
Q

rounds x to a specified number of digits (y)

A

=ROUND(x,y)

50
Q

returns the column number of x

A

=COLUMN(x)

51
Q

returns the row number of x

A

=ROW(x)

52
Q

returns the square root of x

A

=SQRT(x)

53
Q

removes extra spaces in x

A

=TRIM(x)

54
Q

returns x in all capital form

A

=UPPER(x)

55
Q

returns x in non- capital form

A

=LOWER(x)

56
Q

returns the current date

A

=TODAY()

57
Q

returns the current date and time

A

=NOW()

58
Q

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

A

text or labels

59
Q

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

A

number data or constant

60
Q

an expression that calculates the value of a cell.

A

formula

61
Q

MS Excel uses standard operators for formulas.

A

mathematical operators

62
Q

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

A

functions

63
Q

Adds all the numbers in a range of cells

A

=SUM(cell range)

64
Q

Counts the number of cells that contain numbers.

A

=COUNT(cell range)

65
Q

Adds the cells specified by a given condition or criteria.

A

=SUMIF(range, criteria, sum range)

66
Q

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

A

=AVERAGEIF(range, criteria, average range)

67
Q

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

A

range

68
Q

t determines which cells will be added.

A

criteria

69
Q

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

A

=COUNTIF(range, criteria)

70
Q

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:

A

=IF(logical test, value_if_true, value_if_false)

Quarter 1: Empowerment Technologies (9 decks)

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