intro comp for exam 3
database
A ________ is an organized collection of data.
left aligned
When you type text in a cell it is ________.
validation rule
is a rule about the type of data that can appear in that field.
relational
A ________ database is one where multiple collections of data are linked to one another.
query
A ________ is a database object that retrieves specific data from one or more database objects.
b
A cell address is also referred to as a(n) ________. active cell cell reference label value
chart area
A chart and all of its elements are known as the
workbooks
A collection of worksheets (like a notebook)
true
A legend is a chart element that identifies the patterns or colors assigned to each category of a chart.
range
A series of two or more adjacent cells in a column or row or a rectangular group of cells
Excel
A spreadsheet program that allows users to organize data, complete calculations, make decisions and graph data
t
A user can change the sort order of a query from the Datasheet view.
t
A user can sort on more than field within a table
function
A(n) ________ is prewritten in Excel 2016 to look at one or more values, perform an operation, and then return a value.
sum function
Adds all of the numbers in a range of cells
t
After creating a new database from Blank desktop database, Access opens a blank table named Table1.
flow chart
All of the following are accurate MS Excel charts, EXCEPT:
workbooks s
Allows users to enter, calculate, manipulate and analyze data such as numbers and text
formula
An equation that calculates a new value from values currently in a worksheet
t
An outlined cell in a worksheet is the active cell. True False
source area
Cell or range of cells being copied
false
Ctrl + = is a keyboard shortcut that starts the Sum function in a worksheet.
t
Each table should have a field that contains a unique value for each record in the table.
true
Each worksheet in a workbook can have different formatting.
number format
Formatting option that changes the way data looks in a cell
green plus sign
How can you identify the Chart Elements button when you select a chart
f
If users delete a field from the Design view by accident, they can click Undo to correct the error.
b
In Excel 2016, row headings are identified by _
numbers
In Excel 2016, row headings are identified by ________. numbers uppercase letters Roman numerals lowercase letters
record
In a table, a ________ contains all of the categories of data pertaining to one person, place, event, thing, or idea.
field
In a table, a ________ is used for each single piece of information for every record, such as a first or last name.
t
In order to save changes to a database, you must save the objects individually.
formula bar
Located below the Ribbon. As you type, Excel displays the entry in the formula bar
name box
Located on the left side of the formula bar, Excel displays the active cell reference in the name box
t
Normal view maximizes the number of cells visible on your screen.
false
Once users select a data type for a field and enter data, they cannot change the data type.
active cell
One cell on a worksheet that is "active". You can enter data into this active cell.
d
Pixels are measured in ________ per square inch. dashes characters spaces dots
sheet tab
Place where each worksheet name is displayed
in-cell editing
Procedure where the contents of a cell are edited directly in the cell - you double click into cell to edit
destination area
Range of cells receiving a copy
fill handel
Small black square at the lower corner of an active cel
table
Text or graphics organized in columns and rows
d
The MEDIAN function finds ________. all numbers that correspond to an argument in the function the average value in a range of cells the one number that corresponds to an argument in the function the middle value in a range of cells
d
The MEDIAN function finds ________. all numbers that correspond to an argument in the function the one number that corresponds to an argument in the function the average value in a range of cells the middle value in a range of cells
properties grid-wrong
The Query window is broken into two parts, the table area and the ________.
false
The Short Text data type will allow a user to store up to 512 characters in that field.
false
The Sum function is so frequently used that it has its own button on the Quick Access Toolbar.
false
The Unfreeze command locks columns and rows into place.
worksheet grid area
The ________ displays the columns and rows that intersect to form the worksheet's cells. Name Box Quick Access Toolbar worksheet grid area
primary
The ________ key refers to the unique field that identifies each record.
navigation pane
The _________ displays all of the objects contained in your database. The objects are grouped by type.
record navigation bar
The __________ allows you to navigate records one at a time.
false
The category axis is also known as the y-axis. True False
gridlines
The horizontal and vertical lines on a worksheet
one-to-many
The most common type of relationship in Access is _
a
The most commonly used values in a worksheet are ________. text values and number values date values and labels date values and time values text values and time values
worksheet window
The portion of the worksheet displayed on the computer screen
f
The status bar displays the ribbon as well as the Quick Access Toolbar directly above it.
range reference
The unique identifier for a range, which is the cell in its upper left corner and the cell in its lower right corner, separated by a colon
merge
To combine multiple cells into one cell
relationship
To connect two or more tables that have common fields, a user will need to establish and define the table _
a
To create a MS Excel formula, one will always start with: a. Equal Sign (=) b. Plus Sign (+) c. Slash/divide Sign (/) d. Minus Sign (-)
truncate
To hide text that does not fit in a cell from view (##### displays in the cell)
field size
To improve accuracy during user input, a designer can limit the number of characters a user can enter by adjusting the ________ under Field Properties.
f
To minimize the Navigation pane, click the single arrow in the upper-right corner.
wrap text
To move data to a new line when the cell is not wide enough to display all of the contents
ctrl
Use the ________ key to select A5:A8 and D5:D8.
format and design
What are the two contextual tabs that display under Chart Tools when a chart is selected?
.xlsx
What is the default file extension, format type, for MS Excel 2013/2016/365?
c
When a cell is part of an active formula, it is surrounded with ________. a colored background with small circles on each corner a bold, black border with small circles on each side a colored border with small boxes on each corner a white border with small boxes on each corner
id
When creating a new table, Access creates the first field and names it ________ which Access assigns a unique sequential number.
item(wrong)
When creating a new table, Access creates the first field and names it ________ which Access assigns a unique sequential number.
outermost
When creating a table sort on two or more fields, the first level of sorting is referred to as the ________ sort field.
What questions should this database be able to answer?
When designing a new database, the first question users should ask themselves is
vertical or horizontal bars
When using the Freeze Panes feature, what is a pane bounded by?
vertical and horizontal bars
When using the Freeze Panes feature, what is a pane bounded by? A solid red line The ribbon Vertical or horizontal bars The status bar
b
When you type data in a cell and press Enter, what cell becomes the active cell? The cell above The cell below The cell to the right The insertion point does not move.
b
Where is the fill handle located? On the Home tab In the lower right corner of a selected cell On the Quick Access Toolbar In the top right corner of an active cell
sum
Which MS Excel function would one use to add values of several cells? a. Min b. Max c. Sum d. Average
alphabetize(wrong) sort?
Which of the following MS Excel commands will sort data into alphabetical order?
web app(wrong) blank desktop database(wrong)
Which of the following is NOT a method to create a new database?
max
Which of the following is NOT one of the default calculations displayed by AutoCalculate?
b
Which of the following is the default number format in Excel 2016? General format, Cambria, 12 pt General format, Calibri, 11 pt Decimal format, Calibri, 11 pt General format, Times New Roman, 12 pt
d
Which of the following statements is FALSE about a workbook? The default zoom level is set to 100%. It contains pages called worksheets. It contains one or more worksheets. It can contain only one worksheet.
b
Which symbols does Excel use to indicate that a cell is not wide enough to display a formula or function result?
f
Within an Access table, each row is a field and each column is called a record.
t
You can open, rename, and delete objects using the Navigation pane.
record search box
You can use the __________ to search for any term in the current object.
sorting
_ is the process of arranging data in a specific order based on the value in a field.
Which of the following is FALSE about worksheet tabs? The active worksheet tab displays in red font. A worksheet tab can be copied. You can change the color of worksheet tabs. You can rename a tab by double-clicking on it.
a
embedded chart
a column chart or graph that represents data from the worksheet; Located on the same worksheet as the data.
chart
a graphical representation of data
cell reference
a unique "address" defined by coordinates of the intersection of a column and a row. Example: D11 refers to the cell located at the intersection of column D and row 11
column heading
identifies each column with a letter above the grid
row heading
identifies each row with a number on the left side of the grid
cell
the basic unit of a worksheet into which you enter data