What key or keys are used to change the spreadsheet mode to formula view so that formulas show in the cells?
a. control, alt, delete
b. formula view key on the number keypad
c. control with tilde ~ key
d. this is not possible
C. Control with tilde ~ key
100
What symbol needs to be typed in a cell before beginning a formula?
= sign
100
An intersection of a column and a row is a ______
Cell
100
A number that is entered on a spreadsheet and used for calculations is
a. label
b. value
c. formula
d. text
b. value
100
Vertical groups of cells that are named with a letter are ____
Columns
200
What does it mean when ##### shows up in a cell?
The column isn't wide enough to display the data in the cell.
200
A workbook is also called a
a. template
b. spreadsheet
c. document
B. Spreadsheet
200
A rectangular group of adjacent cells is called a _______
range
200
What symbol is used to divide cells in a formula?
/
200
A spreadsheet already set up for a specific purpose is known as
a. workbook
b. template
c. worksheet
b. template
300
Which shows the address of the active cell?
a. cell
b. name box
c. address bar
d. title bar
B. Name Box
300
What bar displays both the name of the application and the name of the spreadsheet?
Title Bar
300
What tool, located on the right edge of the screen, can be used to move up or down the spreadsheet?
Vertical scroll bar
300
What is used to multiply?
*
300
What is the correct formula for subtracting cell A6 from cell A8?
=A8-A6
400
What is the formula for adding cells A7 and A8?
=Sum(A7:A8)
400
A file that contains one or more spreadsheets is called a ___
Workbook
400
Text, symbols, dates or numbers not used in calculations are called ______
Labels
400
How would you write the cell address for the cell in Row 18 and Column Z
Z18
400
The arrangement of cells in columns and rows used to organize, analyze, calculate and report information, usually in numeric form is a _________
Spreadsheet
500
What happens when you click on the checkmark that appears in the formula bar on a spreadsheet?
Enter
500
The name of the spreadsheet program we are using is ____
Microsoft Excel
500
I want my spreadsheet to fit entirely on 1 page before I print it. What are two things I can do?
change margins, rotate page to landscape
500
List three ways to adjust the column width in a spreadsheet.
1. Get the double arrow between two column letters and double click.
2. Get the double arrow between two column letters and hold and drag.
3. Highlight the column and go to Format menu and choose column width.
500
What answer do you get for the following formula
sum(A6:A10)
when cell A6 = 1, A7 = 2, A8 =3, A9 = 4 and A10 = 5?