2.
To select a sentence, hold down this key and then click anywhere in the sentence.
Explanation
The correct answer is control, ctrl, Control, Ctrl. These are the different ways to refer to the control key on a computer keyboard. The control key is used in combination with other keys to perform various functions, such as copying and pasting text, undoing actions, or opening new tabs in a web browser. It is an essential key for navigating and controlling actions on a computer.
3.
Click this button in the font group and then click the UPPERCASE option to change selected text to uppercase letters
Correct Answer
A. Change case button
Explanation
The correct answer is "change case button" because it accurately describes the button that needs to be clicked in order to change the selected text to uppercase letters. The other options, "capitol button" and "C button," do not provide the same level of clarity and specificity as the correct answer.
4.
Press these keys on the keyboard to italicize selected text.
Explanation
Pressing Ctrl+I on the keyboard is the correct way to italicize selected text. The Ctrl key, also known as the control key, is commonly used in combination with other keys to perform various functions. In this case, pressing Ctrl+I simultaneously triggers the command to apply the italic formatting to the selected text.
5.
Click this button in the paragraph group in the Home tab to align text at the right margin.
Correct Answer
A. Align right text button
Explanation
The correct answer is "align right text button" because in the given question, it is stated that you need to align text at the right margin. The "align right text button" in the paragraph group in the Home tab is specifically designed for this purpose, allowing you to align text to the right margin of the page.
6.
The Line Spacing button displays in this group in the Home tab.
Correct Answer
paragraph
Explanation
The Line Spacing button is displayed in the paragraph group in the Home tab.
7.
Click this button in the font group in the Home tab to remove paragraph formatting form selected text.
Correct Answer
A. Clear formatting button
Explanation
The clear formatting button in the font group in the Home tab is used to remove paragraph formatting from selected text. This button allows users to easily remove any formatting such as font style, size, color, and alignment that has been applied to the selected text. It helps in restoring the text to its default formatting settings.
8.
Insert a page border with options at this dialog box with the page border tab selected.
Correct Answer
A. Borders & shading
Explanation
In order to insert a page border with options, you need to go to the page border tab. The correct option for this is "borders & shading". This option allows you to add borders to your page and customize them according to your preferences. The "shadowing & borders" and "shading & themes" options do not specifically mention the ability to insert page borders with options, making them incorrect choices.
9.
Click this button at the Find and Replace dialog box to replace all occurrences of the text.
Correct Answer
replace
replace all
Explanation
The correct answer is "replace, replace all". In the Find and Replace dialog box, there is a button that allows you to replace all occurrences of the specified text. This button is labeled as "replace" and "replace all". By clicking on this button, you can easily replace all instances of the text with the desired replacement.
10.
This is the keyboard shortcut to display the Reveal Formatting task pane.
Correct Answer
A. Shift+F1
Explanation
The correct answer is Shift+F1. This keyboard shortcut is used to display the Reveal Formatting task pane. By pressing Shift+F1, users can quickly access the Reveal Formatting feature, which allows them to view and modify the formatting applied to selected text or the current document. This shortcut is commonly used in word processing applications to assist with formatting tasks and ensure consistency in the document's appearance.
11.
This is the default page size.
Correct Answer
A. 8.5 X 11
Explanation
The correct answer is 8.5 X 11. This is the standard page size commonly used in documents and printing. It is also known as letter size and is widely used in North America. The dimensions of 8.5 X 11 inches provide a balanced and easily readable layout for text and graphics, making it a popular choice for various purposes such as letters, reports, and presentations.
12.
A document theme is a set of formatting choices that includes a font theme, an effects theme,and a _______
Correct Answer
color theme
Explanation
A document theme is a set of formatting choices that includes a font theme, an effects theme, and a color theme. The color theme refers to the specific set of colors that are used throughout the document, including for text, backgrounds, and other elements. This helps to create a cohesive and visually appealing design by ensuring that the colors used are consistent and complementary.
13.
This is the keyboard shortcut to insert a page break.
Correct Answer
A. Ctrl+Enter
Explanation
Ctrl+Enter is the correct keyboard shortcut to insert a page break. This shortcut is commonly used in word processing programs like Microsoft Word. When you press Ctrl+Enter, it forces a new page to start at that point in the document, allowing for better formatting and organization. This shortcut is useful when you want to start a new section or chapter on a fresh page, or when you want to separate content into different pages for printing purposes.
14.
Insert a footer by clicking the Footer button in this group in the Insert tab.
Correct Answer
A. Header & footer group
Explanation
The correct answer is "header & footer group" because the question asks for the action of inserting a footer, and the header & footer group is the specific group in the Insert tab that contains the button for inserting a footer. This group is likely to have other options and features related to headers and footers, making it the most appropriate choice for this action.
15.
Use this feature to position the mouse pointer at the left margin, center of the page, or right margin.
Correct Answer
i beam
I beam
I-beam
i-beam
Explanation
This question is asking for the correct way to write the term for the type of beam being described. The correct answer is "i beam," "I beam," "I-beam," and "i-beam." These variations are all acceptable and commonly used ways to write the term.
16.
Change page alignment with the Vertical Alignment option at this dialog box
Correct Answer
A. Page setup dialog box
Explanation
The correct answer is "page setup dialog box" because this is the dialog box where you can change the alignment of the page. The other options mentioned are not relevant to changing the page alignment.
17.
The Clip Art button displays in this group in the Insert tab.
Correct Answer
A. Illustrations group
Explanation
The correct answer is "Illustrations group" because it is the group where the Clip Art button is displayed in the Insert tab. The Illustrations group typically contains various options for inserting visual elements such as pictures, shapes, charts, and clip art into a document or presentation.
18.
Click the ______ button in the Insert tab to display the Insert picture dialog box.
Correct Answer
picture
Explanation
To display the Insert picture dialog box, the user needs to click the "picture" button in the Insert tab. This button is specifically designed to allow the user to insert pictures into their document or presentation. By clicking this button, a dialog box will appear, providing the user with options to select and insert the desired picture.
19.
When changing the size of an image, maintain image proportions by holding down this key (while dragging a corner sizing handle)
Correct Answer
shift
Explanation
When changing the size of an image, holding down the shift key while dragging a corner sizing handle helps maintain the image proportions. By doing so, the image will be resized uniformly, preventing distortion and ensuring that the width and height of the image are scaled proportionally.
20.
This term is used to refer to the values identified within parenthesis in the SUM function.
Correct Answer
argument
Explanation
The term "argument" is used to refer to the values identified within parenthesis in the SUM function. In this context, an argument is a value or a range of values that are provided to a function to perform a calculation or operation. In the case of the SUM function, the arguments are the numbers that are being added together. By specifying the arguments within the parenthesis of the SUM function, the function knows which values to include in the calculation.
21.
This is the term for the formulas entered beside or below a worksheet that are designed to verify the worksheet's accuracy.
Correct Answer
proof formula
Explanation
A proof formula refers to the formulas entered beside or below a worksheet that are specifically designed to verify the accuracy of the worksheet. These formulas are used to check if the calculations and data entered in the worksheet are correct. By comparing the results of the proof formulas with the expected values, any errors or discrepancies can be identified and corrected, ensuring the accuracy of the worksheet.
22.
This keyboard shortcut will open the Excel help window when pointing to a button.
Correct Answer
F1
f1
Explanation
Pressing the F1 key or the lowercase f1 key on the keyboard will open the Excel help window when the cursor is pointing to a button. This shortcut allows users to quickly access the Excel help feature without having to navigate through menus or search for specific topics. By pressing F1 or f1, users can easily find information and assistance related to the button or feature they are currently working with in Excel.
23.
To insert a new row between 11 & 12, you have to make row number __ active. basically, rows are inserted above.
Correct Answer
12
Explanation
To insert a new row between 11 and 12, the row number 12 needs to be made active. This means that the new row will be inserted above row 12, pushing row 12 down to become row 13. This is because when inserting rows, they are typically added above the selected row. Therefore, in order to maintain the sequence and insert a new row between 11 and 12, row number 12 must be made active.
24.
Columns are inserted to the left. so to insert a new column between E and F, you have to ake column ____ active.
Correct Answer
F
f
Explanation
To insert a new column between E and F, the column F needs to be active. This means that the cursor or selection should be positioned in the column F cell. By making column F active, any new column inserted will be placed to the left of column F, shifting the existing columns to the right. The lowercase "f" in the answer choice is likely included to provide an alternative option for selecting column F, as both uppercase and lowercase letters are commonly used to represent columns in spreadsheet programs.
25.
This date and time function inserts the current date (without the time) in the active cell.
Correct Answer
DATE
date
Explanation
The function "DATE" is used to insert the current date in the active cell. It does not include the time, only the date. The parameter "date" is not specified in the question, but it is likely referring to the input format for the date.
26.
The IF function returns one of two values based on this criterion. (true/false)
Correct Answer
"logical test"
logical test
logic test
Explanation
The correct answer is "logical test". In the context of the IF function, a "logical test" refers to the condition or criterion that is evaluated to either true or false. It is the expression or statement that determines which value will be returned by the IF function. "logical test", logical test, and logic test all refer to the same concept in this context.
27.
When a chat is selected, 3 contextual chart tools appear.
Correct Answer
A. Design, layout, format
Explanation
The correct answer is design, layout, format. When a chat is selected, these three contextual chart tools appear. This suggests that users have the option to modify the design elements of the chart, such as its appearance and style, the layout of the chart elements, and the format of the data being displayed.
28.
This button appears after copied cells are pasted into the destination range.
Correct Answer
A. Paste options button
Explanation
The "paste options button" appears after copied cells are pasted into the destination range. This button provides various paste options such as pasting values only, formatting only, or formulas only. It allows the user to choose how the copied data should be pasted in order to maintain the desired formatting and functionality.
29.
This format adds a dollar sign, a comma in the thousandths place, and 2 decimal places to each value in the selected range.
Correct Answer
A. Accounting number format
Explanation
The accounting number format is the correct answer because it adds a dollar sign, a comma in the thousandths place, and 2 decimal places to each value in the selected range. This format is commonly used in accounting to represent monetary values in a standardized and easily readable format.
30.
This toolbar contains buttons for commonly used commands.
Correct Answer
A. Quick access toolbar
Explanation
The quick access toolbar is the correct answer because it is a toolbar that contains buttons for commonly used commands. This toolbar is customizable, allowing users to add or remove buttons based on their preferences and frequently used functions. It provides easy access to commands such as saving, printing, and undoing actions, making it a convenient tool for users to quickly perform common tasks without navigating through multiple menus.
31.
Use this feature to find synonyms for a word.
Correct Answer
A. Thesaurus
Explanation
This answer is correct because a thesaurus is a tool that provides synonyms for words. It is commonly used to expand vocabulary and find alternative words with similar meanings. The given options, "merium webster," "dictionary," and "autocorrect," do not specifically offer synonyms for words, making them incorrect choices.
32.
Create multiple-level bulleted or numbered paragraphs with options from this button.
Correct Answer
A. Multilevel list button
Explanation
The correct answer is the "multilevel list button" because it allows users to create lists with multiple levels of indentation. This feature is commonly used in documents, presentations, and spreadsheets to organize information in a hierarchical structure. By using the multilevel list button, users can easily create and manage lists with different levels of importance or hierarchy, making it a useful tool for organizing and presenting complex information in a clear and structured manner.
33.
Set tabs at the Tabs dialog box or using this.
Correct Answer
A. Alignment button
Explanation
The alignment button is the correct answer because it is the option that allows users to set tabs at the Tabs dialog box. This button is specifically designed to control the alignment of text or objects in a document, making it the most appropriate choice for setting tabs. The bullet/dashes button and the tabs button do not have the same functionality and therefore cannot be used to set tabs.
34.
To display the envelopes and label dialog box, click this tab and then click the envelopes or the labels button.
Correct Answer
A. Mailings
Explanation
To display the envelopes and label dialog box, you need to click on the "Mailings" tab. This tab contains options and tools related to mailing and printing. Once you have clicked on the "Mailings" tab, you can then click on either the "Envelopes" or the "Labels" button to access the dialog box specifically for envelopes and labels. This dialog box allows you to customize and set up the printing of envelopes and labels according to your needs.
35.
The SUM function button is located in this group in the Home tab
Correct Answer
A. Editing
Explanation
The correct answer is "Editing" because the SUM function is a feature that allows users to add up a range of numbers in a spreadsheet. Since the SUM function is a tool used for editing and manipulating data, it makes sense for the SUM function button to be located in the "Editing" group in the Home tab. This group typically contains various tools and functions that are used for editing and formatting data in a spreadsheet.
36.
Use this feature to remove everything from a cell including text and formats.
Correct Answer
A. Clear all feature
Explanation
The correct answer is "clear all feature". This feature allows users to remove everything from a cell, including both text and formatting. It is a convenient way to reset a cell to its default state.
37.
Perform this action with the mouse on a column boundary to adjust the width to the length of the longest entry.
Correct Answer
A. Drag the boundary line
Explanation
To adjust the width of a column to the length of the longest entry, the user needs to drag the boundary line of the column. This action allows the user to manually resize the column width by dragging the line to the desired width, ensuring that it matches the length of the longest entry in the column. The other options mentioned, such as dragging the margin or moving the margin, do not specifically address adjusting the width of a column to the length of the longest entry. Going to page setup is also unrelated to this specific action.
38.
Click this button in the Clipboard group of the Home tab to copy the formats of the active cell.
Correct Answer
A. Format painter button
Explanation
The format painter button in the Clipboard group of the Home tab is used to copy the formats of the active cell. This button allows users to easily apply the same formatting to other cells or ranges in the worksheet. By clicking on the format painter button, users can quickly copy and apply formatting such as font style, size, color, cell borders, and more, without having to manually adjust each cell individually.
39.
This button displays as a Microsoft Office logo.
Correct Answer
A. The office button
Explanation
The correct answer is "The office button". The office button is a button that displays as a Microsoft Office logo. This button is typically found in older versions of Microsoft Office applications, such as Microsoft Word 2007. It is used to access various functions and options within the application, including opening and saving documents, printing, and accessing program settings.
40.
Do this action if Excel suggest the wrong range after clicking the sum button.
Correct Answer
A. Highlight a different range
Explanation
If Excel suggests the wrong range after clicking the sum button, the action to take is to highlight a different range. This means selecting a different set of cells that you want to include in the sum calculation. By choosing a different range, you can ensure that Excel calculates the sum correctly.
41.
To begin checking the spelling and grammar in a document, click this tab and then click the spelling & grammar button in the proofing group.
Correct Answer
A. Review tab
Explanation
To begin checking the spelling and grammar in a document, you need to click on the "review tab" and then click the "spelling & grammar" button in the proofing group. This tab contains various tools and options for reviewing and editing the document, including spell check and grammar check. The proofing group specifically focuses on proofreading and correcting errors in the document. Therefore, the "review tab" is the correct answer in this context.
42.
The print layout button is located in this group in the view tab.
Correct Answer
A. Document views group
Explanation
The correct answer is "document views group" because the question is asking for the location of the print layout button in the view tab. Among the given options, the "document views group" is the most logical choice as it is related to viewing the document and the print layout button would be found in this group.
43.
Predesigned cover pages and watermarks are located in this dialog box.
Correct Answer
A. Building blocks organizer dialog box
Explanation
The correct answer is the building blocks organizer dialog box. This dialog box contains predesigned cover pages and watermarks, allowing users to easily access and apply these elements to their documents. This feature is helpful for creating professional and visually appealing documents without the need for extensive design skills.
44.
FIIndent text from the left margin by dragging the Left Indent marker on this.
Correct Answer
A. The 0.5in. mark
Explanation
The correct answer is the 0.5in. mark. This is because the left indent marker is used to indent text from the left margin, and the 0.5in. mark represents a half-inch indentation. This means that when the left indent marker is dragged to the 0.5in. mark, the text will be indented by half an inch from the left margin.
45.
Click this button in the Paragraph group in the Home tab to number selected paragraphs.
Correct Answer
A. Numbering button
Explanation
The correct answer is the "numbering button." This button, located in the Paragraph group in the Home tab, is used to apply numbering to selected paragraphs. It allows users to organize and structure their text by automatically adding numbers to each paragraph, making it easier to follow and understand.
46.
This is the name of the button that displays at the left side of the ruler.
Correct Answer
A. Left tab symbol
Explanation
The left tab symbol is the correct answer because it refers to the button that appears on the left side of the ruler. This button is used to set a specific tab stop at the left margin of the document. By clicking on this symbol, users can align text or objects to the left side of the page. The other options, such as tab symbol, left margin symbol, and left alignment symbol, do not accurately describe the button that is specifically located on the left side of the ruler.
47.
The Cut button is located in this group in the Home tab.
Correct Answer
A. Clipboard group
Explanation
The Cut button is located in the clipboard group in the Home tab. This group is specifically designed for functions related to copying, cutting, and pasting content. The clipboard group typically contains buttons for Copy, Cut, and Paste operations, allowing users to easily manipulate and transfer data within a document or application. Therefore, it is logical for the Cut button to be located in the clipboard group as it is directly related to the copying and pasting functionality.
48.
Click this to display the clipboard task pane.
Correct Answer
A. Clipboard group dialog box launcher
Explanation
The correct answer is "Clipboard group dialog box launcher" because it is referring to a specific feature or button within a software application. The clipboard is a temporary storage area where copied or cut items are stored before being pasted elsewhere. The group dialog box launcher is a small icon or button that opens a dialog box containing additional options or settings related to a specific group of features. Therefore, the "Clipboard group dialog box launcher" is most likely a button or icon that opens a dialog box with additional options or settings related to the clipboard functionality within the software application.
49.
This is the default page alignment.
Correct Answer
A. The top of the page
Explanation
The correct answer is "the top of the page" because the question is asking for the default page alignment, which refers to the position where the content is initially placed on the page. In most cases, the default alignment is set to the top of the page, meaning that the content will start from the uppermost part of the page.