1.
When you delete a row or column, the text in the cells is also deleted.
Correct Answer
A. True
Explanation
When you delete a row or column in a spreadsheet, all the text and data within the cells of that row or column are also deleted. This means that any information contained in those cells will be permanently removed from the spreadsheet. Therefore, the statement "When you delete a row or column, the text in the cells is also deleted" is true.
2.
Tables can include text, numbers, or graphics.
Correct Answer
A. True
Explanation
Tables can indeed include text, numbers, or graphics. This is because tables are a way to organize and present data in a structured format. They are commonly used in various contexts such as spreadsheets, databases, and web pages to display information in rows and columns. The cells within a table can contain any type of content, including text, numerical values, and even images or other graphical elements. Therefore, it is accurate to say that tables can include text, numbers, and graphics.
3.
You can merge cells horizontally, but not vertically.
Correct Answer
B. False
Explanation
Cells in a table can be merged both horizontally and vertically. When cells are merged horizontally, the content of multiple cells in the same row is combined into a single cell. Similarly, when cells are merged vertically, the content of multiple cells in the same column is combined into a single cell. Therefore, the statement that only horizontal merging is possible is incorrect.
4.
You can split a table into two separate tables.
Correct Answer
A. True
Explanation
It is possible to split a table into two separate tables. This can be done by selecting the desired rows or columns from the original table and creating a new table with the selected data. This process allows for better organization and management of data, as well as the ability to analyze and manipulate the data independently in each of the separate tables.
5.
When you use the Draw Table tool, you use the mouse to draw the table grid on the screen the same way you would use a pen to draw the grid on a sheet of paper.
Correct Answer
A. True
Explanation
The explanation for the given correct answer is that when using the Draw Table tool, the user is able to draw the table grid on the screen using the mouse, mimicking the action of drawing a grid on a sheet of paper with a pen. This suggests that the statement is true, as the tool allows for this type of interaction.
6.
By default, Word formats a 1 1/2 point single-line border around all cells in a table.
Correct Answer
B. False
Explanation
Word does not format a 1 1/2 point single-line border around all cells in a table by default.
7.
Gridlines show on the screen, but they do not print.
Correct Answer
A. True
Explanation
Gridlines in a document or spreadsheet are used for visual purposes to help organize and align data. They are not intended to be printed, as they are not part of the actual content of the document. Therefore, it is true that gridlines show on the screen but do not print.
8.
Word can convert text separated by paragraph markers, commas, tabs, or other characters into a table with cells.
Correct Answer
A. True
Explanation
Word has the capability to convert text into a table with cells. This means that it can take text that is separated by paragraph markers, commas, tabs, or other characters and transform it into a structured table format. This feature is useful for organizing and presenting data in a more visually appealing and organized manner.
9.
You can use the Cut, Copy, and Paste commands to edit text in tables.
Correct Answer
A. True
Explanation
The statement is true because the Cut, Copy, and Paste commands are commonly used to edit text in tables. These commands allow users to move or duplicate text within a table or between different tables. By cutting or copying selected text, users can then paste it into a different location within the same table or into another table altogether. This functionality is essential for organizing and rearranging information in tables, making the statement true.
10.
Internet fraud is considered a blue-collar crime.
Correct Answer
B. False
Explanation
Internet fraud is not considered a blue-collar crime. Blue-collar crimes typically refer to offenses committed by individuals in lower socioeconomic classes, involving physical labor or manual work. On the other hand, internet fraud is a white-collar crime, often perpetrated by individuals in higher socioeconomic classes, using technology and deception to commit fraudulent activities online. Therefore, the given answer "False" is correct.
11.
To move the insertion point from one cell or another, you can press the arrow keys or ____.
Correct Answer
C. Tab
Explanation
To move the insertion point from one cell to another, you can press the arrow keys or the tab key. The tab key is commonly used to navigate between cells in a spreadsheet or a table. It allows for quick and efficient movement from one cell to the next, either horizontally or vertically.
12.
The Table button is located on the ____ tab.
Correct Answer
A. Insert
Explanation
The Table button is located on the "insert" tab. This tab is typically used for inserting various elements into a document, such as tables, pictures, shapes, or charts. The "insert" tab is commonly found in word processing software and provides users with a range of options for adding and customizing different elements within their document.
13.
The ____ tool is very useful for creating complex tables.
Correct Answer
B. Draw table
Explanation
The draw table tool is very useful for creating complex tables. It allows users to easily create and customize tables by drawing the desired layout and structure. This tool provides flexibility and control over the table design, making it an efficient option for creating complex tables.
14.
The ____ tool enables you to remove cell boundaries.
Correct Answer
B. Eraser
Explanation
The Eraser tool is used to remove cell boundaries in a table. It allows you to selectively erase or remove the borders between cells, resulting in a table without any visible cell boundaries. This can be useful when you want to create a more seamless and visually appealing table layout.
15.
The ____ button toggles to rotate text top to bottom, bottom to top, and horizontal.
Correct Answer
A. Text Direction
Explanation
The Text Direction button is the correct answer because it allows users to toggle the rotation of text. This button can be used to rotate text from top to bottom, bottom to top, and horizontally.
16.
When nonprinting characters are displayed, small squares, called ____ show in the left corner of each table cell.
Correct Answer
C. End of cell markers
Explanation
When nonprinting characters are displayed, small squares called "end of cell markers" show in the left corner of each table cell. These markers indicate the boundaries of each cell and help in visually distinguishing the cells within a table. They are useful for formatting and editing tables, as they allow users to easily identify and manipulate individual cells.
17.
The ____ button converts a cell into multiple cells.
Correct Answer
D. Split cells
Explanation
The split cells button allows a user to divide a single cell into multiple cells. This can be useful when a cell contains a large amount of data that needs to be separated or when creating a table with multiple columns and rows. By splitting cells, the user can organize and structure the data in a more organized and readable format.
18.
You can ____ to create a heading that will span across two or more columns.
Correct Answer
A. Merge cells
Explanation
You can merge cells to create a heading that will span across two or more columns. This means that you can combine multiple cells into one larger cell, allowing you to format and align text or content across a wider area. This is useful when you want to create a header or title that spans multiple columns in a table or spreadsheet.
19.
The numbers 7, 10, 15, and 18 are arranged in ____ order.
Correct Answer
A. Ascending
Explanation
The numbers 7, 10, 15, and 18 are arranged in ascending order because they are listed from smallest to largest.
20.
Built-in table designs that you can apply with a single click are called ____.
Correct Answer
B. Table styles
Explanation
Table styles are built-in designs that can be applied to tables with a single click. These styles provide a consistent and visually appealing look to tables, making them easier to read and understand. They can include various formatting elements such as font styles, colors, borders, and shading. Cell styles, on the other hand, are used to apply formatting to individual cells within a table. Row styles refer to applying formatting to entire rows in a table. "Banana styles" is not a relevant term in the context of table designs.
21.
When a table cell is formatted for ____, Word will automatically adjust the cell width each time the cell contents change.
Correct Answer
B. Autofit Contents
Explanation
When a table cell is formatted for "Autofit Contents," Word will automatically adjust the cell width each time the cell contents change. This means that if the content of the cell gets longer or shorter, Word will automatically resize the cell width to fit the new content. This can be useful when working with tables that have dynamic or changing content, as it ensures that the table remains visually appealing and easy to read.
22.
After you insert a ____, you replace sample data with your own data.
Correct Answer
D. Quick table
Explanation
After you insert a "quick table," you replace sample data with your own data. A quick table is a pre-designed table format that allows you to quickly create a table by selecting a layout and inserting it into your document. Once the table is inserted, you can easily replace the sample data with your own data to customize the table according to your needs.
23.
It is common to add ____ at the top of columns to label the content in the columns.
Correct Answer
B. Headings
Explanation
Headings are commonly added at the top of columns to label the content in the columns. Headings provide a clear and organized structure to the data, making it easier for readers to understand and navigate the information in each column. By using headings, the reader can quickly identify the type of data in each column and make sense of the overall table or spreadsheet.
24.
The ____ appears in the lower-right corner of a table when you point to it.
Correct Answer
B. Resize handle
Explanation
The resize handle appears in the lower-right corner of a table when you point to it. This handle allows you to adjust the size of the table by dragging it in different directions. It is a useful feature when you need to resize or scale the table to fit the content or adjust the layout of the table within a document.
25.
To insert a row at the top of a table, select the top row and click the ___ button.
Correct Answer
A. Insert Rows Above
Explanation
To insert a row at the top of a table, you need to select the top row and click the "Insert Rows Above" button. This option allows you to add a new row above the selected row, shifting the existing rows down. By selecting the top row, you ensure that the new row will be inserted at the beginning of the table.
26.
To delete all the text in a row, select the row and ____.
Correct Answer
C. Press Delete
Explanation
To delete all the text in a row, you can simply press the "Delete" key on your keyboard. This will remove all the content in the selected row.
27.
When you draw a table, the document must be displayed in ____ view.
Correct Answer
D. Print Layout
Explanation
When you draw a table, the document must be displayed in Print Layout view. This view allows you to see the document as it will appear when printed, including any tables or other formatting elements. It provides a more accurate representation of the final layout compared to other views like Outline, Full Screen Reading, or Draft.
28.
Shading is applied to ____.
Correct Answer
A. Cells
Explanation
Shading is applied to cells in a document or spreadsheet. This means that the background color or pattern is added to specific cells to visually differentiate them from the rest of the content. Shading can be used to highlight important information or to create a more organized and visually appealing layout.
29.
What is the arrow pointing to in Figure 15-1 above?
Correct Answer
A. Row
Explanation
The arrow in Figure 15-1 is pointing to a row.
30.
Which button was used to format the word PET in Figure 15-2 above?
Correct Answer
B. Text Direction
Explanation
The button used to format the word PET in Figure 15-2 is Text Direction. This button allows the user to change the direction of the text, such as rotating it vertically or horizontally. By selecting this button and applying it to the word PET, the user can change the orientation of the text in the figure.
31.
Joshua is working on a group project and wants to create a document to help his group get organized. He wants to include a schedule, a calendar, and a contacts list.Which command should Joshua use to create a calendar quickly?
Correct Answer
D. Quick Tables
Explanation
Joshua should use the "Quick Tables" command to create a calendar quickly. This command allows him to choose from a variety of pre-designed table templates, including a calendar template, which he can easily insert into his document. It saves him time and effort in creating a calendar from scratch.
32.
Joshua is working on a group project and wants to create a document to help his group get organized. He wants to include a schedule, a calendar, and a contacts list.Joshua created the contact list with columns of names and telephone numbers aligned with tabs. He decides he would rather have it formatted as a table. Which command should he use?
Correct Answer
A. Convert Text to Table
Explanation
Joshua should use the "Convert Text to Table" command. This command will allow him to convert the contact list, which is currently in a text format with columns and tabs, into a properly formatted table. This will make it easier for his group to read and organize the contact information.
33.
Carmen works for a nonprofit agency that is in the midst of a fundraising campaign. Carmen is responsible for updating a table that displays the updated numbers and major contributors. She wants to format it so that it will be easy to update.Carmen wants the table to adjust automatically to fit the window, no matter how much data is in the table. Which command should she choose?
Correct Answer
C. AutoFit Window
Explanation
Carmen should choose the "AutoFit Window" command because it will automatically adjust the table to fit the window, regardless of the amount of data in the table. This will make it easier for her to update the table and ensure that all the information is visible within the window.
34.
Carmen works for a nonprofit agency that is in the midst of a fundraising campaign. Carmen is responsible for updating a table that displays the updated numbers and major contributors. She wants to format it so that it will be easy to update.Carmen wants to choose a built-in table style to format the table. What can she do to see previews of the styles before choosing one?
Correct Answer
B. Position the mouse pointer over each style
Explanation
To see previews of the built-in table styles before choosing one, Carmen can position the mouse pointer over each style. This will allow her to get a visual preview of how the table will look with each style, helping her make an informed decision on which style to choose.
35.
When you create a table grid, Word makes all the columns the same ____________________ and the rows the same height.
Correct Answer
width
Explanation
When creating a table grid in Word, the software automatically adjusts all the columns to have the same width, ensuring that they are evenly spaced. Additionally, Word also makes all the rows in the table grid the same height, providing a consistent and uniform appearance to the table.
36.
Sorting data in ____________________ order rearranges the data in alphabetical order from Z to A, or numerical order from highest number to lowest number.
Correct Answer
descending
Explanation
Sorting data in descending order rearranges the data in reverse alphabetical order from Z to A, or reverse numerical order from highest number to lowest number.
37.
In a table, ____________________ go across and columns go down.
Correct Answer
rows
Explanation
In a table, rows go across and columns go down. Rows are the horizontal lines in a table that contain data, while columns are the vertical lines that organize the data into categories or attributes. This arrangement allows for easy organization and comparison of data in a structured manner.
38.
Arranging text and numbers in columns using tables is easier than setting ____________________.
Correct Answer
tabs
tab stops
tabs
tab
tab stop
Explanation
Arranging text and numbers in columns using tables is easier than setting tabs. Tabs can be used to align text and numbers in a document, but they can be more difficult to control and adjust compared to using tables. Tables provide a structured and organized layout, allowing for precise positioning and alignment of content. With tables, you can easily adjust column widths, add or remove rows and columns, and apply formatting consistently across the entire table. This makes tables a more efficient and user-friendly option for arranging text and numbers in columns.
39.
You can access commands to insert and delete cells, rows, and columns by right-clicking the selected cell or cells and then choosing a command from the ____________________ menu.
Correct Answer
shortcut
short cut
Explanation
The answer to the question is "shortcut" or "short cut". By right-clicking on a selected cell or cells, the user can access a menu that provides commands to insert and delete cells, rows, and columns. This menu is commonly referred to as the "shortcut" or "short cut" menu.