Brainscape's Knowledge GenomeTM

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


See full index

CS1101 > Semi-Finals > Flashcards

Semi-Finals Flashcards

1
Q

The advantage of an electronic spreadsheet is

A

allows you to easily change data and have all “related” calculations automatically update.

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

Spreadsheets in Excel are referred to as __.

A

worksheets

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

It may contain may worksheets.

A

workbook file

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

Each box is referred to as a “__”.

A

cell

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

Cells may contain ____ that result in a value or label.

A

Labels, Values or Formulas

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

It is identified first by its column letter and then by its row number

A

Cell

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

One can also write formulas that refer to cells on other worksheets –

A

Sheetname!Cell-Reference

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

When referencing a cell on the same spreadsheet as the active cell the sheet name is not required.

A

input!B1*input!B3 + A1

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

___ may be named and displayed with different colors tabs, The ___ of the worksheets may be modified as well.

A

Sheets

Order

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

It opens menus for opening and saving Files, and modifying Excel Options

A

File Tabs

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

It can be customized to include icons to frequently Used features such as Print Preview

A

Quick Access Toolbar

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

Used to change fonts, justify text, insert rows etc.

A

Home Ribbon

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

They are organized into Groups of similar tasks such as the Font group or the Number group. In addition, thereare other ribbons containing groups/buttons for laying out pages
using the review features etc.

A

Ribbons

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

How to make a chart

A

Highlight your data, select a Chart type and Edit & its done!

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

The “Power” of using Spreadsheet Applications

A

Each entry can be related to other values by including cell referencing in formulas.
Formula values are automatically updated when a referenced value changes
Formulas can be copied
Charts can be easily generated

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

It is a sequence of values, cell references and operators that produce a new value.

A

formula

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

Formulas always start with _

A

equal sign =

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

In addition a formula can also contain built-in functions like -

A

SUM, AVERAGE, IF, COUNTIF, etc. =Sum(A2:A8)*2

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

Things you need to know when writing formulas in Excel

A

Data precision vs. cell display
Types of operators that can be used
Order of precedence of operators

20
Q

Formulas contain two types of components:

A

Operators

Operands

21
Q

Operations to be performed

A

Operators

22
Q

Arithmetic operators:

Relational operators:

A
  • / + - ^

>, =,,=

23
Q

Values to be operated on

A

Operands

24
Q

Precedence of Operators

A

Parenthesis
Exponentiation
Arithmetic operators: Multiplication & Division
Arithmetic operators: Addition & Subtraction
Relational operators

25
Q

It is a special operator that forces evaluation of the expression inside it first

A

( ) Parenthesis

26
Q

(2^3 8)

A

Exponentiation

27
Q

They have equal precedence and are evaluated from left to right

A

Arithmetic operators: Multiplication & Division

28
Q

They have equal precedence and are evaluated from left to right

A

Arithmetic operators: Addition & Subtraction

29
Q

They have a lower precedence than arithmetic operators

A

Relational operators

30
Q

number of decimal places stored in the computer

A

Precision

31
Q

number of decimal places that appear in a cell

A

Formatted Display

32
Q

Formatting affects display not the precise value:

A

Currency
Percent
Decimal display
Commas

33
Q

They are values that can be entered in several formats: January 27, 2013 or 1/27/2013

A

Dates

34
Q

They converts these dates to a numerical representation (1/22/2013  41301)
Thus dates may be used in formulas: =A1–B1 will result in the value 5

A

Excel

35
Q

Building a Simple Spreadsheet

A

Entering labels and values
Formatting cells
font, size, style, color, borders, alignment
Numeric Format, Currency, Decimal Places
text wrap, center titles
Column widths, row height
Inserting/Deleting rows and columns and sheets
Writing a simple formula & modify decimal display
Create a simple chart
Sheet tabs
Creating a new worksheets in a workbook (“new sections in a document”, Naming Sheets

36
Q

Excel file with one or more sheets or pages

A

Workbook

37
Q

Page in the workbook

A

Spreadsheet or Worksheet

38
Q

Tabbed section containing command icons

A

Ribbon

39
Q

Horizontal

A

Row (Row Number)

40
Q

Vertical

A

Column (Column Letter)

41
Q

Column/Row Combination

A

Cell

42
Q

Numeric entries used in calculations

A

Values

43
Q

Text that describes the data

A

Labels

44
Q

Cell currently used (highlighted used)

A

Active Cells

45
Q

Top of spread sheet where Excel displays the values or formula for that cell

A

Formula Bar

46
Q

Electronic sheet of paper organized by columns & rows

A

Spreadsheet

CS1101 (9 decks)

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