Foundations of Technology Semester 1 Study Guide
You may submit this study guide as many times as you want.
Sign in to Google to save your progress. Learn more
Email *
Pressing Ctrl + S selects all the text in a document. *
1 point
Save files in different formats using the Format As command. (p. O-9) *
1 point
When creating folders, they automatically file alphabetically. (p. O-4) *
1 point
When you copy something, it is sent to the Recycle Bin. (p. O-14) *
1 point
Because the clipboard exists in the Windows operating system, you can retrieve it from any running program indefinitely.  (p. O-14) *
1 point
You can copy an image from Word and paste it into PowerPoint. (p. O-14) *
1 point
The Quick Access toolbar is in a fixed position above the Ribbon. (p. O-24) *
1 point
While you can add commands to the Quick Access toolbar, they cannot be rearranged.  (p. O-24) *
1 point
The Hide Ribbon option hides the Ribbon, but leaves the tabs visible. (p. O-28) *
1 point
The File tab takes you to the Backstage view. (p. O-32) *
1 point
The Autosave function automatically saves your work every five minutes and cannot be adjusted.  (p. O-32) *
1 point
A template is a model of a document you can adjust for your use. (p. O-32) *
1 point
You can open or save documents quickly from the SAVE tab. (p. O-32) *
1 point
When you right-click on a folder, a _______ opens. (p. O-4) *
1 point
Your computer stores the material you "delete" in the _______ just in case you need it later.  (p. O-4) *
1 point
Inside the folder for a major project, you can have _______ for the various project components.  (p. O-4) *
1 point
You can display your list of folders in different views such as _______. (p. O-4) *
1 point
You can see the current folder in the _______ near the top of the window.  (p. O-6) *
1 point
Another name for the context-sensitive menu is _______. (p. O-7) *
1 point
Deleting folders files from your computer and actually sends them to the _______. (p. O-7) *
1 point
To delete a folder, click the folder, locate the _______ group on the HOME tab, and click the Delete button. (p. O-5) *
1 point
To create a new folder, click the HOME tab, locate the New group, and click _______. (p. O-4) *
1 point
_______ is a storage capability that allows you create an account so you can access the file from another computer or device by logging into your account. (p. O-9) *
1 point
A file could be _______. (p. O-9) *
1 point
Saving to Computer places the files on _______. (p. O-10) *
1 point
Saving to SkyDrive saves your files to _______. (p. O-10) *
1 point
When saving a file, by default, the file has a name based on the _______. (p. O-9) *
0 points
Move files from folder to folder by _______ them from one place to another. (p. O-9) *
1 point
One way to rename a file is to _______ on the file, choose Rename, and type the new file name. (p. O-9) *
1 point
When you _______ something, it copies it into the clipboard but removes it from its original location. (p. O-14) *
1 point
Without even opening a file, you can copy it and _______ it into another folder. (p. O-14) *
1 point
The actual Clipboard, while available in almost any application, _______. (p. O-15) *
1 point
Click the _______ button in the Clipboard group to launch the Clipboard pane. (p. O-17) *
1 point
Pressing _______ will paste the last thing copied or cut to the Clipboard. (p. O-17) *
1 point
As you hover over each Paste shortcut menu option, _______ is displayed. (p. O-17) *
1 point
The Quick Access toolbar is located at the _______ corner of the screen. (p. O-24) *
1 point
By clicking _______, the Quick Access toolbar immediately sends you to the Customize window so you can see all the possible commands you can add. (p. O-24) *
1 point
To change the location of the Quick Access toolbar from the default position, click the drop-down arrow to the right of the Quick Access toolbar and choose _______. (p. O-24) *
1 point
In the _______, you can change the order of the commands on the Quick Access toolbar. (p. O-24) *
1 point
In addition to Minimize, Maximize, and Close, the System menu's two other commands are ________. (p. O-29) *
1 point
When you minimize a window, it moves to the _______ at the bottom of the screen. (p. O-28) *
1 point
You can change the _______ to make the document larger or smaller. (p. O-28) *
1 point
To move a window, _______ and hold the mouse on the Title bar and drag the window to the new location. (p. O-28) *
1 point
One of the greatest things about the Office applications is that they _______. (p. O-32) *
1 point
From the Backstage view, you can _______. (p. O-32) *
1 point
From Backstage view, you can decide how often the _______ backs up your work. (p. O-32) *
1 point
Double-click in a paragraph to select the entire paragraph. (p. W-4) *
1 point
Pressing the keys Ctrl + V will paste text that has been copied. (p. W-8) *
1 point
Ctrl+ C cuts selected text. (p. W-8) *
1 point
The Find command in Word allows you to both find text and to replace found text with new text. (p. W-39) *
1 point
Alignment options are found in the Paragraph group on the HOME tab. (p. W-12) *
1 point
To select a single word in a Word document, you can double-click on the desired word. (p. W-4) *
0 points
One way to bold selected text is to press Ctrl + B. (p. W-12) *
1 point
For paragraph commands (found in the Paragraph group), you simply need to click anywhere in the paragraph you want to format before applying a command. (p. W-17) *
1 point
Pressing Ctrl + S selects all the text in a document. (p. W-4) *
1 point
The Drop Cap command removes the capital letters from a sentence. (p. W-32) *
1 point
Justifying aligns the text in a paragraph against the left margin. (p. W-16) *
1 point
When you select a font color, the Font Color button retains the last color change made, so you do not need to use the drop-down menu to choose the same color again. (p. W-33) *
1 point
When Word suspects a grammar error, it underlines it with a wavy red line. (p. W-43) *
1 point
The Text Effects button is located in the Font group on the HOME tab. (p. W-31) *
1 point
Pressing Ctrl + Z is the only way to undo a previous action. (p. W-8) *
1 point
While Word has a wide variety of options for bulleted lists, it does not allow you to create bullets from images. (p. W-35) *
1 point
Word can offer spelling and grammar suggestions as you type. (p. W-43) *
1 point
It is possible to print specific, nonconsecutive pages. (p. W-48) *
1 point
Which is the preferred method for moving text long distances within a document? (p. W-9) *
1 point
Rather than switching to the Document Views group on the VIEW tab, you can select a View mode using the buttons _______.  (p. W-22) *
1 point
If you just want to move text from one place to another, without leaving the copied text in its original place, use the ____________ method.     (p. W-10) *
1 point
To move the curser to the end of the document, press _________. (p. W-4) *
1 point
The Paste command places text _________. (p. W-10) *
1 point
The italic formatting command can be applied from a button in the ____ group on the HOME tab. (p. W-12) *
1 point
Which of the following is used to undo a previous action? (p. W-9) *
1 point
Selecting portions of text that are not next to one another is called _________ selection. (p. W-14) *
1 point
Line spacing is set from the ___________ group on the HOME tab. (p. W-16) *
1 point
After typing an entry into a dialog box window, you can move to the next window by pressing the _________ key. (p. W-17) *
1 point
Text aligned against both margins, left and right, is _________. (p. W-16) *
1 point
To open the Font dialog box, click the HOME tab, locate the Font group, and click the _________ button. (p. W-12) *
1 point
Clicking on the ______ command in the Paragraph group provides quick access to many of the common line and paragraph settings. (p. W-18) *
1 point
To view more than one page of your document at the same time, what selection would you make in the Zoom panel of the VIEW tab? (p. W-24) *
1 point
___________ will instantly intensify the visual interest of a document title or heading. (p. W-31) *
1 point
The Zoom In command increases the zoom _________ percent each time it is clicked. (p. W-23) *
1 point
By default, the Drop Cap command drops the letter down ____ lines and wraps the text around it. (p. W-32) *
1 point
A letter, in a font larger than the rest of the document text, at the beginning of the first paragraph is known as a ___________. (p. W-32) *
1 point
You can change the drop cap settings using the ___________. (p. W-32) *
1 point
You can change the color of selected text by using the ________ button in the Font group on the HOME tab. (p. W-33) *
1 point
If you click on the Symbol button when defining a new bullet, you access the ___________. (p. W-37) *
0 points
The Increase Indentation and Decrease Indentation buttons are found in the __________ group of the HOME tab. (p. W-36) *
1 point
The _______ button allows you to replace each occurrence of the word one at a time. (p. W-40) *
1 point
To add formatting to your search and replace criteria, click the ___________ button and then click the Format or Special buttons and select from the options available. (p. W-39) *
1 point
To access the print options, click the ________ tab and then select Print from the menu. (p. W-48) *
1 point
The __________ button lets you replace all occurrences of a word (or string of characters) within a document. (p. W-40) *
1 point
When Word suspects the wrong word may have been used (contextual spelling), it underlines it with a wavy _________ line. (p. W-43) *
1 point
In the Find and Replace dialog box, type the word(s) you want to be replaced in the _________ window. (p. W-40) *
1 point
The ______ the Flesch Reading Ease index is, the easier the document is to read. (p. W-46) *
1 point
The print option ________ will only print areas that you have selected with your mouse. (p. W-50) *
1 point
To view the print options, first click the FILE tab to display the _________. (p. W-49) *
1 point
Word uses a Date Picker to insert a date on a cover page. (p. W-62) *
1 point
Placeholders are empty by default and you need to fill them with information like that found in the properties of the document. (p. W-62) *
1 point
The spell checking process can be started by clicking the "Proofing errors were found" button in the Status bar. (p. W-63) *
1 point
From the Header & Footer view, you can insert, delete, and format page numbers without affecting the main body of the text. (p. W-68) *
1 point
Word will automatically number the pages for you. If, however, you later add or delete pages anywhere in the document, you need to right-click in the header or footer area and choose Update. (p. W-68) *
1 point
When you use soft page breaks, Word can adjust and re-create new breaks as needed when you add or delete material. (p. W-73) *
1 point
A page break will separate the previous part of the document from the following part by creating a new section that can be controlled and formatted (including page numbers) without having any effect on the other sections. (p. W-73) *
1 point
Creating sections allows you to treat each section of the document separately from the other sections. (p. W-75) *
1 point
The title of the document, the author, and the date are the most common elements found in headers and footers. (p. W-79) *
1 point
The elements of a header or footer cannot be modified to different font styles and sizes because Word provides predesigned header and footer layouts. (p. W-79) *
1 point
Headers and footers have three built-in tab positions to make aligning easy. (p. W-81) *
1 point
You can set the Date & Time field to update automatically. (p. W-83) *
0 points
A character style heading will format the entire paragraph in which it is included. (p. W-93) *
1 point
By default Word uses three levels of headings. (p. W-93) *
1 point
A paragraph style heading will only affect the actual characters you have selected. (p. W-93) *
1 point
Word creates a table of contents by using text that you bookmark within the document. (p. W-98) *
1 point
Footnotes are used to add information or clarification to a document without interrupting the flow of the writing. (p. W-103) *
1 point
It is difficult to convert footnotes or endnotes from one form to the other. (p. W-103) *
1 point
Each source type of information has its own set of fields that you fill in so that Word can create the proper formatting when producing a citation or bibliography. (p. W-107) *
1 point
Word uses the APA writing style to format all reference data. (p. W-107) *
0 points
A citation is a list of the actual documents and sources used in the research of the document. (p. W-113) *
1 point
Citations and bibliographies have specific formats based on the writing style of the document. (p. W-113) *
1 point
Word's preset cover page provides ________ to allow you to format and control each element separately. (p. W-62) *
1 point
This feature allows you to pick the date from a calendar to reduce the chance of error. (p. W-62) *
1 point
You can insert an automatic cover page by selecting Cover Page from the Pages group on the __________ tab. (p. W-62) *
1 point
To insert a placeholder, click the INSERT tab, locate the Text group, click ______, choose Document Property, and then choose the desired placeholder. (p. W-62) *
1 point
Both inserting and removing page numbers is done from the _______ tab. (p. W-68) *
1 point
When page numbers are inserted from the Header & Footer group, the view of the document changes to _______ view. (p. W-69) *
1 point
The page numbering on the Status bar _______.  (p. W-69) *
1 point
If you add a page of content in the middle of your document, what will happen to the inserted page numbering? (p. W-71) *
1 point
When you turn off the Headers & Footers view you return to the __________ view. (p. W-69) *
1 point
The _________ function allows you to choose from numbers, letters, or Roman numeral formats. (p. W-73) *
1 point
What would you need to insert if you wanted one part of your document to be single column and another part to be two columns? (p. W-75) *
1 point
A ___________ will force a new page to begin and allow you to control what will appear at the top of a certain page. (p. W-73) *
1 point
The ______ creates a page break along with a section break. (p. W-75) *
1 point
This command allows you to omit headers and footers from the first page of a document while maintaining them on other pages of a document.  (p. W-76) *
1 point
If your cursor is in the footer and you want to edit something in the header, what is the fastest way to move to the header? (p. W-81) *
1 point
The number format used in page numbering is set in the __________ dialog box. (p. W-85) *
1 point
A date inserted into the document will be static unless the __________ option is selected. (p. W-86) *
1 point
By default, headers and footers start _________ inches from the edge of the paper. (p. W-85) *
1 point
Which of the following is the long date format? (p. W-86) *
1 point
The Date & Time button is found in the Insert group when in _______ view. (p. W-83) *
1 point
Once a heading style is changed _____________. (p. W-93) *
1 point
You can easily create your own style using the _________ button. (p. W-93) *
1 point
The body text of a document is assigned a style called _______.  (p. W-93) *
1 point
The formatting of a  heading uses a _________; this means it will format the entire paragraph it is in, not just the character that is selected. (p. W-95) *
1 point
Where are the most common styles displayed? (p. W-96) *
1 point
By selecting the ________ button, you can access Word's built-in styles for tables of contents. (p. W-99) *
1 point
It is easy to remove a table of contents by clicking the Table of Contents button and choosing ___________. (p. W-98) *
1 point
Word scans the document for ______ and builds the table based on what it finds. (p. W-98) *
1 point
When you insert a(an) ________, a superscript marker is created and Word opens a related note area at the end of the document. (p. W-103) *
1 point
When you insert a(an) ___________, a superscript marked is created and Word opens a related note area at the bottom of the page. (p. W-103) *
1 point
To convert footnotes to endnotes, click the Footnotes Launch button, click the _______ button, and then choose Convert all footnotes to endnotes. (p. W-106) *
1 point
Endnotes can appear in two locations--at the end of the document or ___________. (p. W-105) *
1 point
By default, Word sorts the list of sources by the _________. (p. W-112) *
1 point
If you change from one writing style to another, _______. (p. W-111) *
1 point
What is the style of punctuation and writing that is commonly used by writers within the liberal arts and humanities? (p. W-111) *
1 point
What is the style of punctuation and writing that is chosen by many academic and business organizations? (p. W-111) *
1 point
In the ____________ field of the Source Manager you choose whether your source is a book, website, article, and so on. (p. W-110) *
1 point
If you enter information in the Source Manager that is required for APA style and then changed to MLA style and the information is no longer needed, what will happen to the information? (p. W-111) *
1 point
A ______ is an in-line reference indicating from where the specific information was taken. (p. W-113) *
1 point
A(n) ___________ is a list of the actual documents and sources used in the research of the document. (p. W-113) *
1 point
The Citations & Bibliography group is located on the _____________ tab. (p. W-113) *
1 point
When you make changes to the Source Manager (edit an entry or create new entries), the generated bibliography ____________. (p. W-117) *
1 point
You can use the Crop to Shape feature to crop the picture inside a shape.  (p. W-130) *
1 point
If the text does not fit in the text box properly, you can drag the sizing handles on the text box until it does. (p. W-137) *
1 point
Once drawn, shapes are static and cannot be moved or flipped. (p. W-143) *
1 point
When drawing a shape, you can force Word to make the shape symmetrical. (p. W-145) *
1 point
Word's Bubbles are shapes similar to the dialog and thought balloons seen in comic strips and comic books. (p. W-160) *
1 point
Word's automatic alignment guides make the positioning fast and accurate. (p. W-163) *
1 point
Once ungrouping is done, objects cannot be grouped again.(p. W-166) *
1 point
Grouped objects copied and pasted into other graphic programs can be used as corporate logos and trademarks. (p. W-166) *
1 point
The _______ feature allows you to decide how the text and other elements should wrap around the image.(p. W-130) *
1 point
You can control the color inside a text box using _____ to change the default color of white to any color. (p. W-135) *
1 point
When you change the outline to _________, the text in the text box appears to hover on its own. (p. W-135) *
1 point
To adjust the text box settings, you need to access the ______ tab under the Drawing Tools. (p. W-135) *
1 point
If text does not fit in a text box properly, what can you do to correct it? (p. W-137) *
1 point
To set the precise position of a text box, select the text box, locate the Size group, click the ___________tab, and then set the Horizontal or Vertical alignment. (p. W-136) *
1 point
__________ allow(s) you to add a color or pattern to a block of text. (p. W-139) *
1 point
When you apply ___________ to blocks of text, your options include single lines, double lines, dotted lines, and fancy lines. (p. W-139) *
1 point
The __________ dialog box provides access to setting text borders, page borders, and shading. (p. W-141) *
1 point
To remove an existing page border, locate the Setting controls and then click ___________. (p. W-140) *
1 point
To insert a page border, click the DESIGN tab and locate the __________ group. (p. W-139) *
1 point
Drawing a rectangle while holding the Shift button would produce a(n) ______. (p. W-145) *
1 point
When a shape is selected, what tab becomes visible?  (p. W-145) *
1 point
While drawing an oval, holding the _________ button would create a perfect circle. (p. W-145) *
1 point
The Shape Outline button is found in which group on the FORMAT tab under the Drawing Tools? (p. W-145) *
1 point
You can use the __________ dialog box to ensure precise positioning and size of all shapes. (p. W-144) *
1 point
The drop-down palette of shapes is located in which group on the INSERT tab? (p. W-144) *
1 point
Which tab under the Drawing Tools would you go to if you were looking for the tools to adjust the color of a shape, to change the fill of a shape, or set the weight of a shape outline? (p. W-143) *
1 point
By clicking the ___________ of the crop button, you activate the simple crop tool without the other options. (p. W-158) *
1 point
Which of the Layer commands sends the selected image all the way to the back layer no matter how many layers exist? (p. W-158) *
1 point
Which of the Layer commands brings the selected image forward one layer? (p. W-158) *
1 point
You can use ____ to nudge objects. (p. W-159) *
1 point
The Layer Objects are found in the ________ group on the FORMAT tab under Picture Tools. (p. W-156) *
1 point
The clip art used in Word is part of the Office.com Clip Art Library and it ____________. (p. W-160) *
1 point
Text inside Word's callouts _________. (p. W-160) *
1 point
The higher the ___________, the more precise the automatic alignment guides become. (p. W-161) *
1 point
____ is (are) generally regarded as illustrations such as cartoons and drawings.  (p. W-160) *
1 point
What shapes are similar to the dialog and thought balloons seen in comic strips and comic books? (p. W-160) *
1 point
What does the yellow handle in a callout allow you to do? (p. W-160) *
1 point
Due to their nature, callouts automatically __________. (p. W-160) *
1 point
The _________ make positioning fast and accurate. (p. W-163) *
1 point
To insert bullets into a text box, click in the text box, click the _______ tab and locate the Paragraph group, and then click Bullets. (p. W-163) *
1 point
The Bing Image Search in Word warns you about copyright issues and attempts to restrict images to those licensed under ______________. (p. W-164) *
1 point
____________ objects allows you to adjust and edit individual objects again. (p. W-166) *
1 point
To adjust the internal margins of a text box, you would use the _____ button in the Format Shape pane. (p. W-166) *
1 point
__________ objects allow you to move them around a document as if they were one object.(p. W-166) *
1 point
When you group objects and then move them around, they ______. (p. W-166) *
1 point
With a text box selected, what key sequence could you use to copy the text box? (p. W-166) *
1 point
If you have copied a text box, what key sequence could you use to paste the copied text box?  (p. W-166) *
1 point
Where would you find the Group Objects button on the Ribbon? (p. W-166) *
1 point
To insert a picture, click the INSERT tab, locate the _____ group, and then click Pictures. (p. W-156) *
1 point
The callout shapes can be found in the ______ group on the INSERT tab. (p. W-160) *
1 point
To group multiple objects, you must first select one object and then select the additional objects to be grouped while holding the ________ key. (p. W-166) *
1 point
A template is a predesigned document that includes the most common elements of the document. (p. W-183) *
1 point
You can customize a template, but you cannot save the changes made as a template document. (p. W-182) *
1 point
Placeholders are "holding places" into which you can type text. (p. W-184) *
1 point
A watermark was, at one time, actually woven into the paper itself. (p. W-188) *
1 point
Adding watermark to a document using Word is quite expensive. (p. W-188) *
1 point
Once inserted, you cannot resize or reposition a watermark.  (p. W-188) *
1 point
When you start Word without opening an existing file, the _______ view displays the most recently opened files and a choice of templates. (p. W-183) *
1 point
To look for a template online, click in the _______ window and enter a keyword to search for.  (p. W-183) *
1 point
A _______ is a predesigned document that includes the most common elements of the document. (p. W-182) *
1 point
_______ contain hints and directions to what type of information should be typed into them.  (p. W-182) *
1 point
A _______ is an image that appears to be woven into the paper itself.  (p. W-188) *
0 points
The first step to resize or move a watermark is to click the INSERT tab and locate the _______ group.  (p. W-189) *
1 point
To create your own watermark, click the DESIGN tab, locate the Page Background group, click Watermark, and then click _______.  (p. W-188) *
1 point
Word has default tabs set at every _______ across the page.  (p. W-194) *
1 point
Each time you press the Tab button, the cursor moves 0.5" _______.  (p. W-194) *
1 point
This type of tab aligns numbers vertically by the decimal point. (p. W-201) *
1 point
This type of tab indents the rest of the paragraph but leaves the first sentence at the margin.  (p. W-201) *
1 point
The ruler offers a quick way to insert, move, and remove tabs, but much more control is available from the _______.  (p. W-199) *
1 point
A _______ can consist of dots, dashes, or underlines. (p. W-199) *
1 point
To access the Tab dialog box, click the HOME tab and locate the _______ group. (p. W-199) *
1 point
The Tab Selector button is located in the _______ of the document window.  (p. W-201) *
1 point
_______ on a table border automatically resizes the column to fit the largest text in the column.  (p. W-201) *
1 point
The _______ allows you to select one column or more than one adjacent column for formatting separately from the rest of the table. (p. W-218) *
1 point
You can use the _______ to apply the changes to just the borders you wish. (p. W-218) *
1 point
Clicking the row header on the far left side of the worksheet selects ______________. (p. W-219) *
1 point
If the ______ check box is checked, the rows of the table will have alternated colors in them. (p. W-220) *
1 point
When you hover the mouse at the top of the line between two columns of a table, the _______ button appears. (p. W-223) *
1 point
If you are sorting a table from A to Z, this is said to be which order? (p. W-225) *
1 point
What button would you click if you want to see where a section break begins and ends?  (p. W-230) *
1 point
A cell range can be a single cell or rectangular block of cells. (p. E-4) *
1 point
The contents of the selected cell are displayed in the Name box. (p. E-4) *
1 point
You use formulas to perform calculations, such as adding a column of numbers or calculating a mortgage payment. (p. E-11) *
1 point
With the AutoCalculate feature, Excel reviews the surrounding cells, guesses at the range you want to sum, and then places a SUM function (described in the next chapter) into the active cell. (p. E-11) *
1 point
Number formats improve the appearance and readability of values in a worksheet by inserting dollar signs, commas, percentage symbols, and decimal places. (p. E-43) *
1 point
The gridlines that appear in the worksheet window are nonprinting lines. (p. E-49) *
1 point
Excel displays the current cell address in the _______, directly above column A. (p. E-4) *
1 point
If you want to select a long range of columns or rows, you can use the mouse to do so by clicking the first cell in the top left-hand corner of the range and then _______ the last (bottom right-hand) cell.  (p. E-7) *
1 point
You will know that a column is too narrow if you see the cell _______. (p. E-8) *
1 point
By default, numeric values are entered _______. (p. E-9) *
1 point
If a cell set to display numbers as currency is displaying $47.50, what will be in the Formula bar for that cell? (p. E-9) *
1 point
Using Excel's _______ feature, you can view the calculated results of a selected range of values in the Status bar. (p. E-11) *
1 point
When you select a cell in building a formula, _______. (p. E-11) *
1 point
Rather than entering the same formula in each cell in a column, you can use the _______ to copy the formula from one cell downward. (p. E-11) *
1 point
When you double-click in a cell, Excel displays _______ within the cell contents. (p. E-16) *
1 point
Whether a numerical progression (1, 2, 3…) or a row of date headings (Jan, Feb, Mar…), a(n) _______ is any sequence of data that follows a pattern that may be extrapolated and extended.  (p. E-19) *
1 point
To display the cell formulas, click the FORMULAS tab, locate the _______ group, and click Show Formulas. (p. E-22) *
1 point
How does Excel store dates? (p. E-22) *
1 point
Number format options include ________. (p. E-43) *
1 point
Double-clicking the Format Painter button _________________. (p. E-47) *
1 point
If you Merge & Center cells C3 and C4, what would the new cell be referred to as? (p. E-47) *
1 point
You can create range names automatically from the row and column headings appearing in a worksheet. (p. E-66) *
1 point
You can enter two types of cell references into formulas: relative and absolute. (p. E-69) *
1 point
To name a selected cell range, you click in the _______, located to the left of the Formula bar, and type a unique name with no spaces. (p. E-66) *
1 point
A(n) ______ locks only a portion of a cell address by inserting a dollar sign ($) before either the address's column letter or row number. (p. E-69) *
1 point
A(n) _______ always refers to an exact cell location in the worksheet. (p. E-69) *
1 point
When copied, a(n) _______ appearing in a formula will adjust itself automatically.  (p. E-69) *
1 point
What type of cell reference is the Excel default?  (p. E-69) *
1 point
With the insertion point in the Formula bar or dialog box entry for the desired cell address, which key would you press to toggle dollar signs before the column letter and row number? (p. E-69) *
1 point
The precise order in which arguments need to be entered is called __________.  (p. E-72) *
1 point
What built-in function saves you from having to enter long addition formulas?  (p. E-72) *
1 point
Use the _______ function to extract the lowest value in a range. (p. E-78) *
1 point
What function returns the current date and time as provided by your computer's internal clock?  (p. E-81) *
1 point
What function returns only the current date, not the time? (p. E-81) *
1 point
The NOW function has what syntax?  (p. E-81) *
1 point
When you need to employ conditional logic in your worksheets, use the _______ function. (p. E-83) *
1 point
A copy of your responses will be emailed to the address you provided.
Submit
Clear form
reCAPTCHA
PrivacyTerms
This content is neither created nor endorsed by Google. Report Abuse - Terms of Service - Privacy Policy
Google Forms