Brainscape's Knowledge GenomeTM

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


See full index

Computer app. > google sheets > Flashcards

google sheets Flashcards

1
Q

what can google sheets be used for

A

perform calculation, analyze, present numeric data

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

a work sheet

A

a grid of column and rows used to enter and manipulate data, perform calculations, and analyze data

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

a workbook

A

a collection of related worksheets contained within a single file; a google sheets file

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

sheets tab

A

located below the worksheet grid; allow you to switch between sheets in a workbook

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

what is a spread sheet similar to

A

word processing table

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

what is the sheet tab default

A

1

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

what is identified by the coordinates of the intersecting column and ;row identifies the location of the cell

A

cell reference (cell address)

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

a series of two or more adjacent cells in a column ,row, or rectangular group of cells, notated using the cells reference of the upper left and lower-right corners

A

range

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

how are ranges identified or named

A

First cell : last cell ex- B8:C12

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

arrow keys

A

up, down, left, right one cell at a time

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

HOME

A

column A of the current row

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

CTRL + HOME

A

cell A1

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

CTRL + END

A

cell Z 1000

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

TAB

A

next cell to the right

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

descriptive text or other information that identifies data in rows, columns, or charts

A

labels

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

anything not used for calculation

A

labels

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

what are necessary components of a basic spreadsheet formula

A

operands, equal sign, operator(s)

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

what does a simple formula look like

A

=B6+B7 =B15^2

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

what does a complex formula look like

A

=B6+B7-18 (B6*4)^2

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

a series of numbers or text; pattern that can be continued to adjacent cells

A

sequences

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

what are 3 methods of moving or copying data

A

clipboard, Drag to move, paste special

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

what are basics of clipboard

A

cut,copy, and paste
shorts-cut
buttons on tool bar
keyboard shortcuts

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

drag to move

A

position the mouse pointer over a cell, when you see a hand, click and drag to new location

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

fill handle

A

located in the lower right corner of the active cell; allows cell contents to be copied to adjacent cells

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

signals the program that a formula has been entered

A

equal sign

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

cell references or values that represent values to be calculated

A

operands

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

symbols that represent mathematical operations

A

operator

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

formulas using only one mathematical operation

A

Simple Formula

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

formulas using two or more mathematical operations

A

Complex formulas:

26
Q

how can cell references be entered

A

upper or lower case

26
Q

what do cell references allow

A

automatic recalculation when values change in a worksheet

27
Q

when a cell reference are used as operands, formulas what may they do

A

may be copied to other locations

27
Q

what is a function formula

A

a special kind of formula that performs a mathematical operations

27
Q

what is the structure of a Function Formula

A

=SUN(D5:D10)

28
Q

identify mathematical operation(s) to be performed

A

Function name

29
Q

what doe the function name replace

A

operator

30
Q

ranges, cell references or values that represent values to be calculated: separated by commas

A

arguments

31
Q

what do arguments replace

A

operands

32
Q

what do you not have to use when doing function formulas

A

order of operations

33
Q

what are function arguments surrounded by

A

parentheses

34
Q

what are function arguments separated by

A

commas

35
Q

what are methods of entering function formulas

A

functions button
insert, function
formulas autocomplete
type function/ select range

36
Q

what do u use when finding the lowest value

A

MIN

37
Q

what to use when finding the largest value

A

MAX

38
Q

what to use when finding average value

A

average

39
Q

what to use when you want the sum

A

SUM

40
Q

what do cell references allow

A

automatic recalculation when values change in worksheet

41
Q

what happens when cell references are used

A

formulas may be copied to other locations

42
Q

what do relative cell references do

A

change relative to location

43
Q

what do absolute cell references do regardless of location

A

stay the same

44
Q

what symbol represents parts of the cell reference to stay the same

A

$

45
Q

what key do you used to make a cell reference absolute

A

F4

46
Q

what do you do in a basic formula to find percentages

A

dived

47
Q

what do you divide when finding percentages

A

=part/whole

48
Q

what happed with percentages

A

the part will change but the whole stays the same

49
Q

where to find the PAGE LAYOUT commands

A

print menu

50
Q

what are the page layout commands

A

page orientation
scaling
margins
set custom page breaks
page formatting
headers/footers

51
Q

the direction a worksheet prints on the page

A

page orientation

52
Q

adjustment to the overall size of the worksheet- makes it larger or smaller to fit page when printing

A

scaling

53
Q

white space around the top, bottom, left ,right edges of the paper

A

margins

54
Q

Allows the movement of automatic page breaks to more convenient or attractive locations, automatically applying scaling to worksheets

A

set custom page breaks

55
Q

Controls the appearance of gridlines, page print order, horizontal and vertical alignment of worksheet on the page; found in formatting section of print menu

A

Page formatting;

56
Q

Text that appears on the top and bottom of each worksheet

A

Header and Footers;

57
Q

what searches the workbook for potential spelling errors

A

spell check

58
Q

where can I find spell check

A

tool> spelling> spell check

59
Q

what is an example of absolute cell references

A

=$A$3+B3

60
Q

move down 3
=B6+D9

A

=B9+D12

61
Q

move down 3
=g7 + $F$5

A

= G10+$F$5

62
Q

move to the right
=B6 + D9

A

D6 + F9

63
Q

move to the right
$F$14 - D1 4TH

A

$F$14 - F14

Computer app. (2 decks)

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