Brainscape's Knowledge GenomeTM

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


See full index

comp apps 2 > Excel Test 1 > Flashcards

Excel Test 1 Flashcards

1
Q

Spreadsheet

A

a grouping of text and numbers in a rectangular grid or table

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

Backstage view

A

the File tab of the ribbon, contains various screens with commands that allow you to manage files and options for the Excel

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

template

A

a preformatted workbook with many design features and some content already filled in

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

Getting help- what button

A

if you are unsure about a function, press the F1 key

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

Go to - button

A

F5

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

Save the current workbook with a new name - button

A

F12

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

New workbook - button

A

Ctrl + N

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

Repeat the last action

A

Ctrl + Y

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

Undo

A

Ctrl + Z

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

Save

A

Ctrl + S

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

Screen tip

A

a label that appears next to an object, providing information about that object or giving a link to associated help topic

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

Chart sheet

A

a sheet that contains only a chart that is linked to data within the workbook

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

Cell reference

A

indicates the column and row in which the cell is located

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

you can include a ____ sheet that contains a description of the workbook, etc.

A

requirement/documentation

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

Shortcut to move up one row

A

Shift + Enter

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

Range reference

A

includes the cell reference of the upper-left cell of the rectangular block and the cell reference of the lower right cell separated by a colon

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

How do you rename a Sheet tab at the bottom of the Excel window

A

double click (or right click) the Sheet1 tab to select the text of the sheet name

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

text data

A

any combination of letters, numbers, and symbols

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

numeric data

A

any number that can be used in a mathematical operation

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

Text is ___ aligned

A

left aligned. includes postal codes

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

Values/numbers, dates, and times, are _____ aligned

A

right

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

Edit mode

A

if you want to replace only part of a cell’s content, you can switch to Edit Mode to make the changes directly in the cell. Double click cell

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

a postal code is ____

A

text. begin with apostrophe ‘

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

AutoComplete

A

displays text that begins with same letters as previous entry in same column to make entering repetitive text easier and reduce data entry errors

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

Shortcut to wrap text

A

Alt + Enter

23
Q

What button do you press to select non-adjacent text

A

Ctrl

24
Q

Numeric data

A

any number that can be used in a math calculation. commonly recognized formats for date and time values.

25
Q

Button to edit data

A

F2 or double click

26
Q

Autocomplete

A

when you type Jan and computer automatically fills in remainder of January

27
Q

What color is triangle for zipcode

A

Green

28
Q

How many views in Excel

A

Three

29
Q

Function

A

=SUM(A1:A10) named operation that replaces arithmetic expression

30
Q

Formula

A

=A1+A2 - mathematical expression

31
Q

Arithmetic operators

A

Addition, =B1+B2+B3, - / * exponents

32
Q

A ____ is a named operation that replaces action of arithmetic expression

A

function (avg, max, min, count, sum)

33
Q

Page Break Preview

A

shows location of page breaks in the printed worksheet

34
Q

Page Layout View

A

shows how the worksheet will appear when printed

35
Q

The order of operations

A

set of predefined rules - the sequence in which operators are applied in a calculation

36
Q

Clipboard

A

temporary storage location for text and graphics

37
Q

drag and drop

A

select text and drag the text to a new location - dra by its bottom border to new location

38
Q

Clearing

A

removes the data from the selected cells, leaving those cells blank but preserving the current worksheet structure

39
Q

formatting

A

enhances the appearance of the worksheet data by changing its font, size, color, or alignment

40
Q

Scaling

A

resizes the worksheet to fit within a single page or set of pages

41
Q

AutoSum

A

the button that inserts functions (sum,avg,max,etc)

42
Q

border

A

aline you can add along an edge of cell that prints

43
Q

cell

A

intersection of a row and a column

44
Q

cell range

A

group of cells in rectangular block

45
Q

cell reference

A

the column and row location that identifies a cell within a worksheet

46
Q

*chart sheet

A

a sheet that contains only a chart that provides visual representation of worksheet data

47
Q

column headings

A

the letters along the top of the worksheet window that identify the different columns in the worksheet

48
Q

flash fill

A

the feature that enters text based on patterns it finds in the data

49
Q

formula bar

A

bar located below the ribbon that displays value or formula entered in active cell

50
Q

name box

A

box located at left side of formula bar that displays cell reference of active cell

50
Q

normal view

A

the Excel view that shows the contents of the active sheet in the workbook window

51
Q

operator

A

a mathematical symbol used in formula to combine diff values, resulting in single value displayed in cell

52
Q

row headings

A

the numbers along the left side of the workbook window that identify the diff rows of ws

52
Q

ribbon

A

the main set of commands organized into tabs and groups with buttons that you click to execute commands

53
Q

scale

A

to change size of worksheet on printed page

54
Q

ScreenTip

A

a box with descriptive text about a command that appears when you point to a button the ribbon - tip

55
Q

sheet tab

A

the area at the bottom of ws that identifies the sheet by name

56
Q

syntax

A

a set of rules that specifies how a function should be written

comp apps 2 (7 decks)

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