Semi-Finals

Question 1

The advantage of an electronic spreadsheet is

Answer 1

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

Question 2

Spreadsheets in Excel are referred to as __.

Answer 2

worksheets

Question 3

It may contain may worksheets.

Answer 3

workbook file

Question 4

Each box is referred to as a “__”.

Answer 4

cell

Question 5

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

Answer 5

Labels, Values or Formulas

Question 6

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

Answer 6

Cell

Question 7

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

Answer 7

Sheetname!Cell-Reference

Question 8

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

Answer 8

input!B1*input!B3 + A1

Question 9

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

Answer 9

Sheets

Order

Question 10

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

Answer 10

File Tabs

Question 11

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

Answer 11

Quick Access Toolbar

Question 12

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

Answer 12

Home Ribbon

Question 13

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.

Answer 13

Ribbons

Question 14

How to make a chart

Answer 14

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

Question 15

The “Power” of using Spreadsheet Applications

Answer 15

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

Question 16

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

Answer 16

formula

Question 17

Formulas always start with _

Answer 17

equal sign =

Question 18

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

Answer 18

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

Question 19

Things you need to know when writing formulas in Excel

Answer 19

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

Question 20

Formulas contain two types of components:

Answer 20

Operators

Operands

Question 21

Operations to be performed

Answer 21

Operators

Question 22

Arithmetic operators:

Relational operators:

Answer 22

• / + - ^

>, =,,=

Question 23

Values to be operated on

Answer 23

Operands

Question 24

Precedence of Operators

Answer 24

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

Question 25

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

Answer 25

( ) Parenthesis

Question 26

(2^3 8)

Answer 26

Exponentiation

Question 27

They have equal precedence and are evaluated from left to right

Answer 27

Arithmetic operators: Multiplication & Division

Question 28

They have equal precedence and are evaluated from left to right

Answer 28

Arithmetic operators: Addition & Subtraction

Question 29

They have a lower precedence than arithmetic operators

Answer 29

Relational operators

Question 30

number of decimal places stored in the computer

Answer 30

Precision

Question 31

number of decimal places that appear in a cell

Answer 31

Formatted Display

Question 32

Formatting affects display not the precise value:

Answer 32

Currency Percent Decimal display Commas

Question 33

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

Answer 33

Dates

Question 34

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

Answer 34

Excel

Question 35

Building a Simple Spreadsheet

Answer 35

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

Question 36

Excel file with one or more sheets or pages

Answer 36

Workbook

Question 37

Page in the workbook

Answer 37

Spreadsheet or Worksheet

Question 38

Tabbed section containing command icons

Answer 38

Ribbon

Question 39

Horizontal

Answer 39

Row (Row Number)

Question 40

Vertical

Answer 40

Column (Column Letter)

Question 41

Column/Row Combination

Answer 41

Cell

Question 42

Numeric entries used in calculations

Answer 42

Values

Question 43

Text that describes the data

Answer 43

Labels

Question 44

Cell currently used (highlighted used)

Answer 44

Active Cells

Question 45

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

Answer 45

Formula Bar

Question 46

Electronic sheet of paper organized by columns & rows

Answer 46

Spreadsheet