Brainscape's Knowledge GenomeTM

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


See full index

Intro to Computer Science (Paul Version) > Lesson on Excel > Flashcards

Lesson on Excel Flashcards

You may prefer our related Brainscape-certified flashcards:
Biology 101 flashcards
1
Q

What is an “What if Analysis”

A

lets you change one or more values in a spreadsheet and then assess the effect those changes have on the calculated values

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

Where is the ribbon located on Excel?

A

On the top

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

What group exists only on Excel and not Word?

A

Numbers Group

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

What does the Namebox show?

A

The Current Cell

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

By default you start with one Sheet, you click the ___ to add more

A

the + button

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

What is another name for a Spreadsheet?

A

Worksheet

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

What is a Chartsheet

A

a chartsheet is a worksheet that only contains a chart.

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

What is a workbook?

A

A collection of worksheets/spreadsheets.

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

How can you tell which is the active sheet?

A

The one that is highlighted and shown in the number box

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

What does Ctrl + Home do in Excel?

A

Brings you to Cell A1

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

What does Ctrl + End do in Excel?

A

Brings you to last cell in worksheet containing data

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

What does Shift + Enter in Excel

A

Goes up a row

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

What does Tab do?

A

Goes a column to the right

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

What does Shift + Tab do?

A

Goes a column to the left

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

What does Page Up/Down do?

A

Up or Down One Screen

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

What does Ctrl + Page Up/Down do?

A

Moves the active cell to the previous or next sheet in the workbook

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

What does Enter on Excel?

A

Moves the active cell down one row or to the start of the next row of data

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

What does Home do?

A

To column A of the current row?

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

What does Alt + Enter do?

A

Allows you enter another line within same cell

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

How do you re-fit row or column of cells?

A

To fit the cell, expand the cell then double click in between the column/row headings

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

What are three types of data in Excel?

A

Text Data, Number Data, Date and Time Data

22
Q

What is Text Data?

A
  1. A text string

2. A combination of alphanumeric characters of words and string

23
Q

A group of cells is called a

A

cell range

24
Q

An adjacent range is a

A

single rectangular block of cells

25
Q

A non-adjacent range consists of

A

2+ distinct adjacent ranges

26
Q

A range reference indicates the

A

location and size of a cell range (ie. F3:I5;J4:J5)

27
Q

An adjacent block is highlighted using ____ and the non-adjacent nearby can be added with ____.

A

Shift, Ctrl

28
Q

____ is an expression that returns a value

A

Formula

29
Q

Use F2 to enter ____

A

Edit Mode

30
Q

____ are used to simply formulas

A

Functions

31
Q

You can reverse things by clicking the ___

A

undo button

32
Q

Ctrl + ` goes to

A

Formula View

33
Q

What is a benefit of a properly formatted workbook?

A

Easier to read

34
Q

The default theme of Excel is ____.

A

Office Theme

35
Q

Live preview allows you to: ___________

A

Live preview allows you to preview changes to your document before you commit to finalizing those changes.

Live Preview comes into effect when, for example, you highlight text and open the font drop-down menu.

36
Q

Why is (32) more preferred than -32, at least for accountants?

A

When going down with a pencil, it is harder to turn -‘s into +’s with brackets.

37
Q

To format a cell, first do what?

A

Select

38
Q

Dates and times in Excel appear as _____:

A

Text

39
Q

T/F: Combining different cells is called aligning?

A

False it is merging

40
Q

T/F: Text is oriented from left to right horizontally by default?

A

True

41
Q

T/F: A style is a collection of formatting?

A

True

42
Q

T/F: Excel has built-in styles?

A

True

43
Q

What is the difference between a serif font and a sans serif?

A

A Serif Font has Serifs (Edges)

44
Q

What is the general number format?

A

The default number format

45
Q

Why are dates right aligned within a worksheet by default?

A

Excel store dates and times as Numeric Values.

46
Q

The range A1:C5 is merged into a single cell, what is it’s reference?

A

A1

47
Q

Where can you access all of the stored font options for cells?

A

Cells > Format Cells > Font

48
Q

T/F: A relative ref is a cell ref that changes when it is copy and pasted in a new location?

A

True

49
Q

T/F: Functions are organized in the function library list?

A

True

50
Q

__ allows you to change things into absolute with the $ signs.

A

F4

Intro to Computer Science (Paul Version) (10 decks)

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