Worksheetsworking with tables
Total questions: 84
Worksheet time: 42mins
A (a) is a database object used to store data in the form of rows and columns.
(a) are used to declare the fields of a table.
How many field types are there?
1
2
3
4
The default length for VARCHAR data type is ....
50
30
10
100
The overall design structure of the database is called (a)
Table can be viewed in (a) ways
How many primary keys can be there in a field?
1
2
3
4
A (a) is a database object used to store data in the form of rows and columns.
(a) are used to declare the fields of a table.
How many field types are there?
1
2
3
4
The default length for VARCHAR data type is ....
50
30
10
100
The overall design structure of the database is called (a)
Table can be viewed in (a) ways
How many primary keys can be there in a field?
1
2
3
4
In the table, identify the cell.
B
C
D
E
A
The number of rows in a table is equal to:
The number of column headers plus one
The number of column headers
The number of row titles plus one
The number of row titles
The number of columns in a table is equal to:
The number of row titles
The number of column headers plus one
The number of column headers
The number of row titles plus one.
What part of the table describes the main categories of information in a table?
Table title
Row titles
Column headers
In the table, identify the column header(s).
E
D
C
A
When planning a table, what step comes first: "define the column headers" or "calculate the number of columns/rows"?
Define the column headers
Calculate the number of columns/rows.
What is the first step in planning a table?
Define the row titles.
Define the column headers.
Determine the table title.
Calculate the number of columns/rows.
Which command would you use to fit columns to the text?
AutoFit Contents
Fixed Column Width
AutoFit Window
Distribute Text
What is the first step in planning a table?
Calculate the number of columns/rows.
Define the column headers.
Determine the table title.
Define the row titles.
What are two ways to move a table in your document?
Space bar and Shift key
Tab key and arrows
Shift key and Escape
Which function would you insert to organize large or complex sets of information that are beyond the capabilities of lists?
Icons
Style
Table
Textbox
What part of the table describes the content of the table using a short phrase?
Row titles
Table title
Column headers
What is the first step in planning a table?
Determine the table title.
Calculate the number of columns/rows.
Define the column headers.
Define the row titles.
In the table, identify the cell.
B
C
D
E
A
The number of rows in a table is equal to:
The number of column headers plus one
The number of column headers
The number of row titles plus one
The number of row titles
The number of columns in a table is equal to:
The number of row titles
The number of column headers plus one
The number of column headers
The number of row titles plus one.
What part of the table describes the main categories of information in a table?
Table title
Row titles
Column headers
In the table, identify the column header(s).
E
D
C
A
When planning a table, what step comes first: "define the column headers" or "calculate the number of columns/rows"?
Define the column headers
Calculate the number of columns/rows.
What is the first step in planning a table?
Define the row titles.
Define the column headers.
Determine the table title.
Calculate the number of columns/rows.
Which command would you use to fit columns to the text?
AutoFit Contents
Fixed Column Width
AutoFit Window
Distribute Text
What is the first step in planning a table?
Calculate the number of columns/rows.
Define the column headers.
Determine the table title.
Define the row titles.
What are two ways to move a table in your document?
Space bar and Shift key
Tab key and arrows
Shift key and Escape
Which function would you insert to organize large or complex sets of information that are beyond the capabilities of lists?
Icons
Style
Table
Textbox
What part of the table describes the content of the table using a short phrase?
Row titles
Table title
Column headers
What is the first step in planning a table?
Determine the table title.
Calculate the number of columns/rows.
Define the column headers.
Define the row titles.
In the table, identify the cell.
B
C
D
E
A
The number of rows in a table is equal to:
The number of column headers plus one
The number of column headers
The number of row titles plus one
The number of row titles
The number of columns in a table is equal to:
The number of row titles
The number of column headers plus one
The number of column headers
The number of row titles plus one.
What part of the table describes the main categories of information in a table?
Table title
Row titles
Column headers
In the table, identify the column header(s).
E
D
C
A
When planning a table, what step comes first: "define the column headers" or "calculate the number of columns/rows"?
Define the column headers
Calculate the number of columns/rows.
What is the first step in planning a table?
Define the row titles.
Define the column headers.
Determine the table title.
Calculate the number of columns/rows.
Which command would you use to fit columns to the text?
AutoFit Contents
Fixed Column Width
AutoFit Window
Distribute Text
What is the first step in planning a table?
Calculate the number of columns/rows.
Define the column headers.
Determine the table title.
Define the row titles.
What are two ways to move a table in your document?
Space bar and Shift key
Tab key and arrows
Shift key and Escape
Which function would you insert to organize large or complex sets of information that are beyond the capabilities of lists?
Icons
Style
Table
Textbox
What part of the table describes the content of the table using a short phrase?
Row titles
Table title
Column headers
What is the first step in planning a table?
Determine the table title.
Calculate the number of columns/rows.
Define the column headers.
Define the row titles.
A (a) is a database object used to store data in the form of rows and columns.
(a) are used to declare the fields of a table.
How many field types are there?
1
2
3
4
The default length for VARCHAR data type is ....
50
30
10
100
The overall design structure of the database is called (a)
Table can be viewed in (a) ways
How many primary keys can be there in a field?
1
2
3
4
Use this icon to insert a table.
Use this icon to combine selected cells into one cell.
Use this icon to arrange a selected column in alphabetical or numerical order.
Use this icon to add a new row directly above the current row.
To insert an Excel spreadsheet into your document, you should:
Use the Table Tools, Layout tab.
Use the Layout tab, Cell Size group.
Use the Insert tab, Tables group, Tables drop‐down menu.
All of these.
Which of the following is not true when working with tables?
Columns and rows can be added after you have already begun entering table data.
Only column headings may be shaded in a table.
The direction of text in a cell can be either horizontal or vertical.
Cells can be merged and split to enhance the readability of your table.
To vertically center a table on your page:
Choose Center Alignment on the Home tab, Paragraph group.
Select your table and hit the Tab key.
Select Center in the Vertical alignment drop‐down menu from the Layout tab in the Page Setup dialog box.
It is not possible to center a table vertically.
The Cell Margins icon is used to insert formulas into a table.
True
False
Merging and splitting cells can both be done in the Merge group.
True
False
There is only one way to adjust row height.
True
False
Use this icon to
delete a cell, column, row, or table.
select the drop-down menu to select the current cell, row, column, or entire table.
add a new row directly above the current row.
add a new row directly below the current row.
Use this drop-down menu to
change the color of the table border.
add or remove borders from the selection.
change the color behind the selection.
change the color of the selected text.
Use this icon to insert a table.
Use this icon to combine selected cells into one cell.
Use this icon to arrange a selected column in alphabetical or numerical order.
Use this icon to add a new row directly above the current row.
To insert an Excel spreadsheet into your document, you should:
Use the Table Tools, Layout tab.
Use the Layout tab, Cell Size group.
Use the Insert tab, Tables group, Tables drop‐down menu.
All of these.
Which of the following is not true when working with tables?
Columns and rows can be added after you have already begun entering table data.
Only column headings may be shaded in a table.
The direction of text in a cell can be either horizontal or vertical.
Cells can be merged and split to enhance the readability of your table.
To vertically center a table on your page:
Choose Center Alignment on the Home tab, Paragraph group.
Select your table and hit the Tab key.
Select Center in the Vertical alignment drop‐down menu from the Layout tab in the Page Setup dialog box.
It is not possible to center a table vertically.
The Cell Margins icon is used to insert formulas into a table.
True
False
Merging and splitting cells can both be done in the Merge group.
True
False
There is only one way to adjust row height.
True
False
Use this icon to
delete a cell, column, row, or table.
select the drop-down menu to select the current cell, row, column, or entire table.
add a new row directly above the current row.
add a new row directly below the current row.
Use this drop-down menu to
change the color of the table border.
add or remove borders from the selection.
change the color behind the selection.
change the color of the selected text.
