Excel Spreadsheet

Question 1

is the spreadsheet component of the Microsoft Office Suite

Answer 1

Microsoft Excel

Question 2

is a file that contains one or more worksheets

Answer 2

workbook

Question 3

Excel’s main screen consists of cells in which you can enter and calculate data

Answer 3

worksheets/spreadsheets

Question 4

This comprises the worksheet with many boxes and is the intersection between a column and a row

Answer 4

cells

Question 5

How to Data Entry

Answer 5

1. Open Excel (Start,All Programs, MS Office, Excel).
2. Enter the following information into your spreadsheet

Question 6

displays the information in the selected cell

Answer 6

formula bar

Question 7

shows the the name of the currently selected cell

Answer 7

name box

Question 8

are equations that perform calculations in your spreadsheet

Answer 8

formula

Question 9

A rectangular box of cells

Answer 9

range

Question 10

common error where cell is too narrow to display the results of the formula

Answer 10

#######

Question 11

You used a cell reference in the formula that is not formed correctly

Answer 11

NAME?

Question 12

Usually the result of trying to do math with a textual value

Answer 12

VALUE!

Question 13

Trying to divide by zero. Example: =3/A1 where A1 contains 0

Answer 13

DIV/0!

Question 14

Using a formula that contains a reference to the cell that the formula “lives in”.

Answer 14

circular reference

Question 15

order of operation in excel

Answer 15

all parentheses
exponents
all multiplication (*) and division (/).
all addition (+) and subtraction (-).