35 questions
Spreadsheets are used primarily for numerical data.
True
False
When you use a spreadsheet program, your data goes into a special kind of document called a table.
True
False
The status bar appears above the menu bar at the very top of the worksheet.
True
False
Using the keyboard's arrow keys, you can move in any direction in a worksheet.
True
False
A formula is a mathematical expression.
True
False
Although you can format a worksheet in many ways, you cannot add rows or columns.
True
False
If you see a set of symbols such as ##### or ***** in a cell, it means that the cell is too large to display the value you have typed into it.
True
False
In a worksheet, labels are typically used for headings or explanations.
True
False
Linking is a way to export data that keeps objects up-to-date.
True
False
You can move data from one cell to another by dragging it.
True
False
Charts are also called graphs.
True
False
You can use formulas to represent data in different cells.
True
False
In the formula =(7*23)/12, the spreadsheet would perform division first, then multiplication.
True
False
In a spreadsheet formula, operations within parentheses are most important, so they are always done last.
True
False
A formula such as =5*3 uses cell references.
True
False
A spreadsheet is a program that processes information that is set up in these.
Rows
Columns
Forms
Tables
In a spreadsheet program, "C3" would be an example of this.
Worksheet
Cell Address
Row
Column
This forms the top and left borders of a worksheet and includes the column and row headings.
Frame
Cell Indentifier
Formula Bar
Worksheet Tabs
In a worksheet, the cell that is currently in use is called the ________ cell.
Used
Indentified
Active
Inactive
This area of a worksheet displays what you type.
Cell Indentifier
Formula Bar
Status Bar
Scroll Bar
Messages from the program appear in this part of the worksheet.
Active Cell
Formula Bar
Tab
Status Bar
You cannot use this key to move around in a worksheet.
Home
End
Esc
Tab
This is a commonly used formula, which is already built into a spreadsheet program.
Function
Fraction
Format
Frame
This type of data is automatically formatted to align to the right in a cell.
Label
Value
Tab
Function
This can be text alone or a combination of numbers and text.
Value
Cell
Heading
Label
When sharing data the file that contains the original data is called the________.
Destination File
Original File
Source File
Linked File
After you edit a cell's data, you can press this key to place it back in the cell.
Enter
Backspace
Delete
Escape
If you change the appearance of data in a cell, this is called ________.
Formatting
Editing
Deleting
Moving
This type of chart shows how parts relate to the whole.
Bar
Line
Pie
Graph
If you want to print only a specific portion of a worksheet, you can specify this.
Chart
Formula
Print Area
Print Command
When you write a formula, you start it with one of these to identify it as a formula.
Letter
Number
Symbol
Function
In a formula, the symbol ^ represents this operation.
Addition
Subtraction
Division
Exponentiation
Which of these formulas divides 7 by 3?
7^3
7/3
7=3
7:3
Which of the following series of letters can help you remember order of evaluation used by a spreadsheet?
PDEMSA
PDMESA
PEMDAS
PMDEAS
13-3
The term cell reference is another name for this.
Cell Indentifier
Cell Address
Cell Format
Cell Tab