Office Productivity Tools 1 Prefinal Exam

The given question asks about the objects that can be inserted in a document. The options provided are pictures, charts, sounds, and shapes. The correct answer is "sounds" because while pictures, charts, and shapes can all be inserted into a document to enhance its visual representation, sounds cannot be directly inserted into a document. Sounds can be added to a document by embedding them in a video or audio file, but they cannot be inserted as standalone objects like pictures, charts, and shapes.

Text wrapping is the correct answer because it refers to the feature that allows users to change the way text wraps around an object. This means that users can control how the text flows around an image or any other selected object in a document. The term "data wrapping," "picture wrapping," and "object wrapping" are not commonly used and do not accurately describe this specific feature.

The correct answer is "bitmap." A .bmp file is a common image file format that stands for "bitmap." It is a raster graphics file format that stores images as a grid of pixels, where each pixel represents a specific color or shade.

The correct answer is AVERAGE(). This function is commonly used to calculate the average of a range of cells in a spreadsheet. It takes a range of cells as input and returns the average value of those cells.

This option allows you to enhance the appearance of the picture by adding shadow, glow, reflection, and 3D rotation effects. By selecting this option, you can make the picture stand out and give it a more visually appealing and professional look.

Margins refer to the blank spaces along the edges of a printed page. They are used to create a visual buffer between the text and the edge of the page, making the content easier to read and aesthetically pleasing. Margins also provide space for binding or hole-punching. They can be adjusted to change the layout or fit more content on a page. In the context of the given options, margins are the only choice that directly relates to the amount of whitespace along the edges of a printed page.

The correct answer is SUM(). The SUM() function is commonly used in spreadsheet applications to calculate the total value of a range of cells. It adds up all the numbers within the specified range and returns the sum. This function is particularly useful when dealing with large sets of data or when performing calculations involving multiple cells.

A watermark is a feature that allows you to personalize your document, protect your document, and identify the ownership of the document. It is a faint image or text that is usually placed behind the main content of the document. This helps to signify the authenticity and originality of the document, making it difficult for others to forge or misuse it. By adding a watermark, you can ensure that your document remains confidential and is not easily copied or reproduced without permission. Additionally, a watermark can also serve as a visual deterrent against unauthorized use or distribution of the document.

A footer is a section at the bottom of a page that is typically used to hold information such as page numbers. It appears below the main content of the page and is commonly used in documents, websites, and other forms of media. The footer often includes important details such as copyright information, contact information, and navigation links. It helps to provide additional context and organization to the content on the page.

The correct answer is "by activating the ruler." The ruler in a document is used for adjusting margins, tabs, and indents, but it does not have a direct function for creating tables. Tables can be created by dragging the number of rows and columns from a list, using the "insert table" command, or using the "draw table" command.

This feature refers to the ability to insert various shapes, such as lines, arrows, rectangles, and ovals, into a drawing. These shapes can be used to enhance the visual representation of the information or to highlight specific elements in the drawing. By including this feature, users have the flexibility to create visually appealing and informative drawings by incorporating different shapes.

SmartArt Graphic is the correct answer because it is a new tool in MS Word 2007 that allows users to create graphics easily and quickly. It helps to convey messages or ideas effectively by providing various pre-designed templates and layouts. With SmartArt Graphic, users can easily create professional-looking graphics without the need for advanced design skills. It is a useful feature for enhancing the visual appeal of documents and presentations.

A header is typically used to hold information such as date or draft number that appears at the top of the page. It is a section of the document that is repeated on every page and provides consistent information or branding. It helps to identify the document and provide important details without taking up valuable space in the main content area.

Each row is represented by a number.

The shortcut key ALT + PAGE UP moves the pointer to the topmost cell of the current column. This shortcut is commonly used in spreadsheet programs to quickly navigate to the beginning of a column without scrolling. By pressing ALT + PAGE UP, the user can easily access the first cell in the column, which can be helpful when working with large amounts of data.

The default line spacing refers to the amount of vertical space between lines of text in a document. In this case, the correct answer is "single," which means that there is no additional spacing between lines.

The default setting for paper size is 8.5 x 11 in. This is the standard size for letter-sized paper in the United States. It is commonly used for printing documents, letters, and other types of correspondence. This size is widely accepted and compatible with most printers and copiers, making it the default setting in many software applications and devices.

The correct answer is ALT + END. This shortcut key is used to move the pointer to the last (rightmost) cell of the current row. By pressing ALT + END, the user can quickly navigate to the end of the row without having to manually scroll or use the mouse. This shortcut is useful for efficiently navigating through large spreadsheets or tables.

The correct answer is ALT + HOME. This shortcut key allows the user to quickly move the pointer to the first cell of the current row. It is a convenient way to navigate within a spreadsheet or table without having to manually scroll or use the mouse. By pressing ALT + HOME, the user can easily access the leftmost cell of the current row, saving time and effort.

The shortcut key ALT+ PAGEDOWN moves the pointer to the last (bottom) cell of the current column. This allows the user to quickly navigate to the end of a column without having to manually scroll down.

The correct answer is "chart" because a chart is a type of diagram that is used to illustrate and compare data. It allows users to visually represent information in a clear and organized manner. With this feature, users can easily create and use predefined charts to effectively communicate their data.

In a table, each column is represented by a letter. This is a common convention used in database management systems and spreadsheet programs. The letters are typically assigned in alphabetical order, starting from A for the first column, B for the second column, and so on. This allows for easy referencing and identification of specific columns within the table.

WordArt is a feature that allows users to create special text effects in a document. It provides various styles and formatting options to enhance the appearance of text. With WordArt, users can apply different colors, shadows, gradients, and other effects to make the text stand out. It is a useful tool for designing titles, headings, logos, and other decorative text elements in documents.

The correct answer is "portable network graphics." PNG stands for Portable Network Graphics, which is a file format commonly used for storing images. PNG files are widely supported and can display transparent backgrounds, making them suitable for web design and other graphic applications.

Line numbers are used to number each line in a document. This feature is particularly useful in academic or legal documents where specific lines need to be referenced. It helps readers easily locate and refer to specific lines of text. By enabling line numbers, each line in the document is assigned a unique number, making it easier to navigate and discuss specific points within the text.

The Document Views Group is not part of the Page Layout tab. The Page Layout tab in Microsoft Word contains various groups of commands that allow users to customize the layout and formatting of their document. The Themes Group provides options to change the overall design and color scheme of the document. The Page Setup Group allows users to modify page margins, orientation, and size. The Page Background Group offers options to add watermarks, colors, or borders to the document's background. However, the Document Views Group, which includes commands to switch between different views such as Print Layout, Full Screen Reading, and Web Layout, is not found in the Page Layout tab.

The default settings for margins in this case are that the left and right margins are both 1.25 in. and the top and bottom margins are both 1.0 in.

The paragraph marker is not used to adjust document margins. It is a symbol that represents the end of a paragraph and is used for formatting purposes such as indenting and spacing. Adjusting document margins can be done using the Page-Setup dialog box, ruler, or the margins button in the Page Layout tab.

The correct answer is "text direction." This button allows you to change the direction of text in a cell. By selecting this option, you can change the orientation of the text within the cell, either horizontally or vertically. This feature is useful when you want to display text in a different orientation for better readability or design purposes.

The given correct answer is "hyphenation". Hyphenation refers to the process of automatically adding hyphens to words in order to break them at the end of a line, if necessary. This is commonly used in typesetting and word processing to ensure that lines of text are evenly spaced and to improve readability. The other options, "hyphenated", "hyphenating", and "auto-hyphen" are related terms but do not specifically refer to the process of automatically adding hyphens to words.

A table is a tabular format that allows you to input and work with information in a self-contained grid. It is a useful tool for organizing and presenting data in a structured manner. Tables are commonly used in various applications such as Microsoft Excel and spreadsheets to store and manipulate data. They provide an organized layout with rows and columns, making it easier to input, analyze, and present information. Additionally, tables can be customized with features like gridlines to enhance readability and improve data management.

The correct answer is "graphics interchange format". A .gif picture file stands for graphics interchange format. This file format is commonly used for images and animations on the internet. It supports both static and animated images and uses lossless compression, which means that the image quality is not compromised.

MS Word 2007 does not support the .pic file format. It supports various other image file formats such as .jpeg, .tiff, and .bmp, but not .pic.

Sizing handles are small boxes that appear along the borders of a selected graphic. These handles allow the user to resize the graphic by dragging them inwards or outwards. They provide a convenient way to adjust the dimensions of the graphic according to the user's preference or the requirements of the document. The term "sizing handles" accurately describes their function and distinguishes them from other types of handles like moving handles or compressing handles.

The term "format picture" refers to a dialog box that allows users to control various formatting attributes of an image. This dialog box provides different categories that can be used to adjust the appearance and style of the picture, such as picture style, picture formatting, and picture editing. Users can utilize this feature to modify the size, shape, color, borders, and other visual aspects of the image to suit their preferences or the requirements of the document or presentation they are working on.

The size of a legal paper is 8.5 x 14 in. This is the correct answer because legal paper is standardized to be longer than regular letter-sized paper. While regular letter-sized paper is 8.5 x 11 in, legal paper is 8.5 x 14 in, providing more vertical space for documents such as legal contracts, agreements, and court documents.

Organizational shapes are a category of shapes, so they cannot be the answer to the question. The other options, including basic shapes, block arrows, and flowchart, are all categories of shapes. Therefore, the correct answer is organizational shapes.

The term "drawing canvas" refers to the area where you can insert elements into your SmartArt. It is the designated space within the software where you can create and modify your visual representation. The other options, such as "drawing area," "drawing space," and "drawing tool," do not accurately describe the specific area where elements can be inserted into the SmartArt.

The given question is asking for the border style that is NOT available in the border tab. The options provided are "Box," "Line," "Grid," and "All." The correct answer is "Line" because it is the only option that is not a border style available in the border tab.

This option allows you to change the color of your picture or apply different color effects such as grayscale or sepia. It is different from brightness, sharpness, and contrast, which focus on adjusting the overall appearance of the image rather than specifically changing its color.

The "Page Color" attribute allows you to define a color as your document background.

The table autoformat feature allows you to automatically format your table in a predefined style or design. This feature saves time and effort as it eliminates the need to manually format each element of the table. By selecting this option, the table will be instantly formatted with borders, shading, font styles, and other formatting elements according to the chosen autoformat style.

Cell margins are used to arrange the margins inside the table and the spacing between cells. They define the space between the content of a cell and the cell borders. By adjusting the cell margins, the spacing between cells can be controlled, allowing for better organization and alignment of the table layout.

The picture style group is used for applying styles and effects to the borders of the pictures. This group provides various options to enhance the appearance of the picture by adding different styles and effects to its borders. It allows users to customize the look of the picture by choosing from a range of pre-designed styles or by applying their own custom styles. This group is specifically designed for manipulating the visual aspects of the picture's borders, making it the correct answer for the given question.

The correct answer is "arrange group" because it is used for organizing the images in a document. The "arrange group" typically includes options such as aligning images, grouping them together, and changing their order. This group provides tools to arrange the layout and positioning of pictures within the document, allowing for better organization and presentation of visual content.

There are nine different buttons that are used to align text inside your table.

The given question asks for the option that is not included in the Picture Style group. The options given are picture shape, picture style, picture border, and picture effects. The correct answer is "picture style" because it is already mentioned in the options and is part of the Picture Style group. Therefore, it cannot be the option that is not included in the group.

This option refers to the action of inserting a page or section break in a document. It allows the user to separate content into different pages or sections, helping to organize and structure the document effectively.

A text box is a type of box that allows users to input and insert text inside it. It is commonly used in forms, documents, and applications where users need to provide textual information. The text box provides a designated area for users to type or paste their text, and the entered text can be edited, formatted, or used for further processing as required.

The adjust group is the correct answer because it refers to a set of tools or options that are used to fine-tune or make changes to the colors of a picture. This group typically includes features such as brightness, contrast, saturation, and hue adjustments, which can be used to enhance or modify the overall color balance and appearance of the image.