Brainscape's Knowledge GenomeTM

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


See full index

DA&R--AES > Excel 1 -U1&U2 > Flashcards

Excel 1 -U1&U2 Flashcards

increase comprehension and application of technical vocabulary

1
Q

outlined by a bold rectangle; information is entered here

A

active cell

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

intersection of a row and column

A

cell

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

starts at the top of the sheet and goes to the bottom of the sheet; identified by a letter

A

column

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

indicates the current cell that is active; can change the location of active cell by typing here

A

Name Box

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

starts at the left edge of the sheet and goes to the right edge of the sheet; identified by a number

A

row

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

spreadsheet file; contains many sheets or pages

A

workbook

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

one sheet or page in a file; where information is entered

A

worksheet

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

default view–how worksheet opens up

A

Normal view

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

automatically divides worksheet into pages

A

Page Layout view

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

see an overview of worksheet; helps separate worksheet into different pages

A

Page Break view

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

Click the column heading (Letter name); selects the entire column

A

Selecting a column

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

Click the row heading (number name); selects the entire row

A

Selecting a row

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

select multiple cells with mouse

A

Click and drag method

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

select multiple cells by clicking first cell, hold shift button and click last cell

A

Shift key method

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

select multiple cells by clicking on first cell, hold control key, click on cells you want to select

A

Control key method

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

keyboard shortcut for Copy

A

Ctrl + C

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

keyboard shortcut for Bold

A

Ctrl + B

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

keyboard shortcut for Italics

A

Ctrl + I

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

keyboard shortcut for Paste

A

Ctrl + V

20
Q

keyboard shortcut for Cut

A

Ctrl + X

21
Q

keyboard shortcut for Undo

A

Ctrl + Z

22
Q

how text is positioned in cell; left, center, right

A

alignment

23
Q

forces text too wide for cell to fit inside cell and be readable

A

wrap text

24
Q

information contained in a cell

A

cell content

25
Q

pieces of info that describe appearance of cell content; examples–font size, font color

A

format attributes

26
Q

line between rows or columns; mouse changes to line with 2 arrows

A

boundary

27
Q

left to right measurement of column

A

column width

28
Q

top to bottom measurement of row

A

row height

29
Q

blinking cursor inside cell; changes can be made to cell content

A

edit mode

30
Q

deletes format from selected cell

A

Clear Formats

31
Q

deletes cell content

A

Clear Contents

32
Q

deletes content and format; button looks like an eraser

A

Clear All

33
Q

insert

A

add

34
Q

delete

A

remove

35
Q

cancels the current command

A

Escape button

36
Q

equation that is entered into a cell

A

equation

37
Q

first character in a cell that tells Excel there is a calculation, formula or function to perform

A

equal sign, =

38
Q

values or data used in a formula; numbers

A

operands

39
Q

symbols used to tell what type of calculation to perform

A

operators

40
Q

uses the cell name (A2) in the formula; tells Excel to use the value in the cell in the formula/function

A

cell reference

41
Q

predefined formula

A

function

42
Q

cell information to be used in function calculation; contained in parentheses

A

arguments

43
Q

adds all values in a range of cells

A

SUM function

44
Q

sums cells in a range then dividing by number of cells in the range

A

AVERAGE function

45
Q

counts the cells with numerical values in a range of cells; blank cells are ignored

A

COUNT function

46
Q

finds the largest value in a range of cells

A

MAX function

47
Q

finds the smallest value in a range of cells

A

MIN function

DA&R--AES (4 decks)

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