1.
The
best way to get started in Excel 2007 is to click the _____.
Correct Answer
C. Microsoft Office Button
Explanation
The Microsoft Office Button is the best way to get started in Excel 2007 because it provides access to various functions and options such as creating a new workbook, opening an existing workbook, saving a workbook, and printing. It serves as a central hub for managing files and performing common tasks in Excel.
2.
In order to save an existing document with a different name you need to:
Correct Answer
B. Use the Save as.. command
Explanation
To save an existing document with a different name, you can use the "Save as.." command. This command allows you to create a duplicate copy of the document and save it with a new name, without altering the original document. By selecting "Save as..", you can specify the desired name and location for the new file, ensuring that it is saved separately from the original document. This method is efficient and convenient, as it eliminates the need to retype the entire document or copy and paste it to a new file manually.
3.
What would you see while spell checking the phrase "My father was write"?
Correct Answer
B. No errors
Explanation
If there are no errors in the phrase "My father was write", it means that all the words are spelled correctly and there are no grammatical mistakes. Therefore, while spell checking the phrase, you would not find any errors.
4.
Suddenly Word does not display your favorite toolbar. What has happened?
Correct Answer
D. Your toolbar has been unchecked under the View/Toolbars menu
Explanation
The most likely explanation for the given correct answer is that the toolbar has been unchecked under the View/Toolbars menu. This means that the toolbar is still present in Word, but it is not being displayed because it has been manually unchecked. To resolve the issue, the user can simply go to the View menu, select Toolbars, and then check the box next to the toolbar they want to display.
5.
Why the document you created at home displays with a different font at
school?
Correct Answer
C. Because the font you used at home is not installed on your school computer
Explanation
The correct answer is because the font you used at home is not installed on your school computer. Different computers may have different fonts installed, so if you use a font that is not available on the computer you are viewing the document on, it will display with a different font.
6.
What is the default file extension for all Word documents?
Correct Answer
C. DOC
Explanation
The default file extension for all Word documents is DOC. This is the standard format used by Microsoft Word to save documents. TXT is a file extension used for plain text files, WRD and FIL are not commonly used file extensions for Word documents.
7.
What is the default file extension for all Excel documents?
Correct Answer
A. XLS
Explanation
The default file extension for all Excel documents is XLS. This file extension is used to identify and open Excel files. TXT is a file extension for plain text files, CSV is a file extension for comma-separated values files, and COM is a file extension for executable files. However, XLS is the standard and default file extension for Excel documents.
8.
How many margins are on a page?
Correct Answer
B. Four (top, bottom, right, left)
Explanation
The correct answer is four (top, bottom, right, left) because margins are the blank spaces surrounding the content on a page. They are used to create space between the content and the edge of the page, and there are typically four margins on a page - one at the top, one at the bottom, one on the right side, and one on the left side.
9.
Which
command reverses the last action performed in the worksheet?
Correct Answer
B. Undo
Explanation
The "Undo" command is used to reverse the last action performed in the worksheet. This means that if any changes were made, such as deleting or modifying data, the "Undo" command can be used to revert those changes back to their previous state. It is a helpful feature that allows users to correct any mistakes or unintended actions in their worksheet.
10.
Which
function automatically totals a column or row of values?
Correct Answer
A. SUM
Explanation
The SUM function automatically totals a column or row of values. It adds up all the numbers in the specified range and returns the sum as the result. This function is commonly used in spreadsheet programs like Microsoft Excel or Google Sheets to quickly calculate the total of a set of numbers.
11.
Charts
that display data as slices of a circle and show the relationship of each value
in a data series to the series as a whole are called..
Correct Answer
B. Pie charts
Explanation
Pie charts are charts that display data as slices of a circle and show the relationship of each value in a data series to the series as a whole. In a pie chart, each slice represents a proportionate part of the whole, with the size of each slice corresponding to the value it represents. This type of chart is particularly useful for comparing the distribution of different categories within a dataset and understanding their relative proportions. Therefore, the correct answer is pie charts.
12.
Pie
charts are commonly used to show trends over time.
Correct Answer
B. False
Explanation
Pie charts are not commonly used to show trends over time. Pie charts are typically used to show the composition or distribution of a whole, where each slice represents a different category or proportion. Line charts or bar charts are more commonly used to show trends over time as they can display changes in data over a continuous period.
13.
Use ________________ to make
entering long or complicated headings easier by logically repeating and
extending the series.
Correct Answer
C. AutoFill handle
Explanation
The correct answer is AutoFill handle because it allows users to easily enter long or complicated headings by logically repeating and extending the series. This feature automatically fills in the cells with a series of numbers, dates, or other data based on the pattern established by the user. It saves time and effort by eliminating the need to manually enter each value in the series.
14.
Charts from Excel can be pasted into
which program:
Correct Answer
C. Charts can be pasted into both PowerPoint and Word.
Explanation
Charts from Excel can be pasted into both PowerPoint and Word. This means that users have the option to insert charts from Excel into either PowerPoint or Word, depending on their needs and preferences. This flexibility allows for seamless integration of data and visuals into presentations or documents, enhancing the overall quality and effectiveness of the content being created.
15.
How can you create a custom color scheme?
Correct Answer
A. In the Color Schemes task pane, click Custom color scheme.
Explanation
To create a custom color scheme, you need to click on the "Custom color scheme" option in the Color Schemes task pane. This will allow you to select and customize colors according to your preferences.
16.
How do you replace placeholder graphics (clip art) with your own graphics (clip art or picture) ?
Correct Answer
A. Right-click a placeholder grapHic, and then click Change Picture.
Explanation
To replace a placeholder graphic with your own graphics, you can right-click on the placeholder graphic and select "Change Picture." This option allows you to browse and select your own graphic or clip art to replace the existing one.
17.
Publisher provides templates.
Correct Answer
A. True
Explanation
The statement "Publisher provides templates" is true. Publisher, a desktop publishing software, does provide templates that users can use as a starting point for creating various types of documents such as brochures, flyers, newsletters, and more. These templates offer pre-designed layouts, fonts, and graphics that users can customize according to their needs. This feature saves time and effort for users who may not have design skills or prefer not to start from scratch.
18.
You
can create bulleted lists by using the _____ tab and the _____ group.
Correct Answer
B. Home tab, ParagrapH group.
Explanation
The correct answer is "Home tab, Paragraph group." The Home tab in Microsoft Word contains various formatting options for text, including the Paragraph group. This group includes tools such as indenting, line spacing, and alignment, which are commonly used when creating bulleted lists. Therefore, to create bulleted lists, you would need to access the Home tab and use the tools in the Paragraph group.