MISY 5325 Excel Midterm Ultimate Review

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

A stacked column chart:

places stacks of data in segments on top of each other in one column, with each category in the data series represented by a different color.

A(n) __ defines the range of data from a worksheet to print.

print area

A(n) ___ is an organized formatted structured report that appears int he form of a worksheet outline.

scenario summary report

A pie chart

shows each data point in proportion to the whole data series as a slice in a circular pie.

A(n) __ is a small window containing one button for each unique item in a field so that you can filter the PivotTable quickly.

slicer

A range name cannot include special characters or __

spaces

Understand what is required

the first step in creating an effective website is to make sure you

Ctrl W

the shortcut key to CLOSE A WORKBOOK

Ctrl P

the shortcut key to PRINT a WORKBOOK

Ctrl S & F12

the shortcut key to SAVE a WORKBOOK

Ctrl O

the shortcut key to open WORKBOOK

Ctrl N

the shortcut key to open a NEW WORKBOOK

The IF function in Excel 2013 has __ arguments.

three

You can apply text, value, and date filters to fields based on the data in a particular field.

true

True

when text is longer than the width of a column Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data

Fill Months

which of the following auto fill options menu options is the same as the fill series option?

(Home tab | Alignment group)

which of the following is the path to the increase or decrease indent button

False

you can turn off the bold formatting by selected text by clicking the roman button (Home tab | Font group)

EXCEL: The ______ is the small black square located in the lower-right corner of the heavy border around the active cell. a. selection handle b. sizing handle c. fill handle d. copy handle

c. fill handle

EXCEL: You _______ a worksheet to emphasize certain entries and make the worksheet easier to read and understand. a. save b. print c. format d. clear

c. format

EXCEL: A company or department may standardize with a specific _______ so that all of their documents have a similar appearance. a. scheme b. gallery c. theme d. style

c. theme

A(n) __ is a user-defined field that does not exist in the original dataset.

calculated field

In addition to sorting and filtering cells by content, you can sort and/or filter by __ formatting

conditional

In addition to sorting and filtering cells by content you can sort and/or filter by __.

conditional formatting

___ specify the restrictions or limitations imposed on a spreadsheet mode as Solver determines the optimum value of the objective cell.

constraints

A chart sheet:

contains a single chart and no spreadsheet data.

A nested function:

contains another function embedded inside one or more of its arguments.

To ___ a table into a range, click within the table, click the Table Tools Design tab, and from the Tools group, select Convert to Range.

convert

currency style dollar sign

currency style dollar sign To assign a dollar sign to appear immediately to the left of the first digit with no spaces, use a _______.

EXCEL: The _____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting. a. Copy Options b. Replace Options c. Formatting Options d. Auto Fill Options

d. Auto Fill Options

EXCEL: The ______ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu. a. AutoFormat b. AutoComplete c. AutoFunction d. AutoCalculate

d. AutoCalculate

EXCEL: If you wish to sign out of your Microsoft account, tap or click ______ on the ribbon to open the Backstage view and then tap or click the Account tab to display the Account gallery, and tap or click the Sign out link. a. ACCESS b. TOOLS c. EXIT d. FILE

d. FILE

Freeze Panes only locks columns above the active cell as you scroll through a worksheet.

false

PivotTables automatically refresh data.

false

To print only a chart, select the chart, click the __ tab, and click Print.

file

Table style controls Table Style Options group Sorting Text A to Z Sorting Dates oldest to newest Sorting Values smallest to largest

fill color of the header row, columns and records in a table check boxes to select format actions arranges data in alphabetical order displays data in chronological order arranges numbers in sequential order

A chart__ controls which data series and categories are visible in a chart.

filter

Top/Bottom Rules:

format cells based upon their value in relation to the value of other cells.

The ___ Table Style option displays the field names of a table when checked.

header row

Highlight Cells Rules Top Bottom Rules Data bar Color scale Icon set

highlights cells meeting criteria with a color, font, or border formats cells based on the value in relation to the other cells horizontal gradient of solid fill indicating a cell's relative value conditional format that displays a particular color based on the relative value of a cell conditional format that displays a small image representing a value

Gridlines on a chart in Excel 2013 are:

horizontal and vertical line that span across the chart

An absolute cell reference:

indicates a cell's specific location and the reference does not change when you copy the formula.

The lookup value:

is a reference to a cell containing a value to look up.

A range name:

is a word or string of characters tat represent one or more cells.

Print order:

is the sequence in which pages print.

In excel, a number can contain the character ______

- 0 1 2 3 4 5 6 7 8 9 - + - ( ) , / - . $ % E e

Correct file format of normal Word template

.dotx

1.Add-in 2.Binding constraint 3.Constraint 4.Changing variable cell 5.Solver

1.A program that can be added to Excel to provide enhanced function 2.A constraint that Solver enforces to reach the target value 3.A limitation that imposes restrictions on Solver 4.A cell containing a variable whose value changes until Solver optimizes the value in the objective cell 5. An add-in application that manipulates variables based on constraints to find the optimal solution to a problem.

1.Slicer 2.Filter 3.Calculated Field 4.PivotChart 5.Slicer caption

1.A small window containing one button for each unique item in a field so that you can filter the PivotTable quickly 2.Excludes particular categories or values 3.A user-defined field that does not exist int he original dataset 4.An interactive graphical representation of the data in a PivotTable 5.Text that displays in the header at the top of the slicer window

1.Scenario Manager 2.Scenario Summary Report 3.Scenario 4.Goal seek 5.Optimization model

1.Enables you to define and manage scenarios to compare how they affect results 2.A worksheet that contains scenario results 3.Detailed sets of values that represent different possible situations 4.A tool that identifies the necessary input value to obtain a desired goal 5.Finds that highest, lowest, or exact value for one particular result by adjusting values for selected variables

1.Filtering 2.Top 10 option 3.Custom Filter 4.Duplicate Values 5.Sorting

1.displays only records that meet conditions 2.specify a number or percentage of records to display 3.complex filtering requirements 4.conditional formatting that displays doubled cells 5.arranges records in a table by the value

Range

2 or more cells

What is the maximum number of scenarios supported by Scenario Manager?

Excel enables you to sort data on __ different levels.

Sandra is creating a formula to multiply the values in cells B4 and C4. Which formula should she use? A. =B4+C4 B. =B4*C4 C. =B4xC4 D. =B4-C4

=B4*C4

In cell E15, enter a formula to find the lowest line item cost this month (cells E2:E14).

=MIN(Range)

Match the argument types to their function: (Number1) () (logical_test) (....,table_array,...) (rate,..,...)

=SUM =TODAY =IF =VLOOKUP =PMT

Angie inserted a picture into a Microsoft Word document. She decided there were portions of the picture she wanted to remove. Which command would be most appropriate to use?

Helen wants to have places in her template where users can choose one of several options to fill in a blank. Which tool would she use? A. Content Controls B. Macro C. Placeholder D. Textbox

How are different underline styles selected when applying the underline font format to selected text? A. Choose the Underline drop-down arrow on the Home Ribbon to select various underline styles B. Right-click underlined text and choose underline styles from the Shortcut Menu C. Select the underlined text, then choose Underline Styles from the Insert Ribbon D. Double-click underlined text and choose Underline Styles from the Shortcut Menu

How do you access Microsoft Word Help from the Word Window? A. Click the Microsoft Office Word Help button in the upper right corner of the Word window B. Press the F2 key C. Choose the Help command on the View Ribbon D. Click the Microsoft Office Word Help button in the lower left corner of the Word window

How is a watermark removed from a Microsoft Word document? A. Choose Remove Watermark from the Watermark drop-down on the Page Layout (Design) Ribbon B. Choose Cancel Watermark from the Water drop-down box on the Insert Ribbon C. Choose Delete Watermark from the Watermark drop-down box on the Page Layout (Design) Ribbon D. Choose Erase Watermark from the Watermark drop-down box on the Insert Ribbon

In Microsoft Word, what is the name of the group formatting characteristics called? A. Style B. Effects C. Cluster D. Group

In a Microsoft Word document, what is the amount of space that appears between paragraphs called? A. Paragraph spacing B. Document spacing C. Character spacing D. Line spacing

Johanna wants to navigate across columns to the right in her table. Which option should she choose? A. Tab B. Enter C. Shift+Tab D. Shift+Enter

Jordan wants to e-mail a view of the entire program window to the Technology Department of the error message that he received when logging onto his computer. What command would he use? A. Screenshot B. Screen clipping C. Picture D. Print Screen

Lisa created a table. She wants the text in her rows to start at the top left. Which layout featuyre will she apply? A. Cell Alignment B. Text Direction C. Cell Margins D. Distribute Rows

Lois has created a table in her document. She would like to add a blank row between the table headers and the first row of data. Which option should she choose? A. Insert B. Delete C. Copy D. Cut

Mark created a three column newsletter. He wants to increase more words per line in each column. What should Mark do? A. Adjust column width B. Adjust column spacing C. Insert a column break D. Insert a vertical line between columns

Matt wants to have places in his survey template where users can check "Yes" or "No" about their senior week plans. Which tool would he use? A. Content Controls B. Macro C. Placeholder D. Textbox

Mrs. Perry has assigned the class to type a report. To maximize space, which option would you choose to display the content? A. Read Mode B. Outline C. Print Layout D. Web Layout

Nathan has created a new business letter and wants to use it repeatedly. What file type does he need to select when saving to protect his original letter? A. Template B. Macro C. Document D. Building Block

Sam wants to organize the data for his research paper. Which method would bring up the dialog box so Sam could define the 20 rows and 4 columns that he knows he needs? A. Insert Table B. Draw Table C. Quick Table D. Text to Table

Shameka is a Yearbook Staff member. Every semester she has to create a newsletter. Instead of recreating it each time, what should she create for future use? A. Template B. New Document C. Macro D. Mail Merge

Table styles may be applied to a table in a Microsoft Word document from which ribbon? A. Table Tools Design Ribbon B. Table Tools Format Ribbon C. Table Tools Layout Ribbon D. Table Tools Edit Ribbon

The principal emailed the staff to inform them about new policy changes for cell phone use. Which type of document is the most appropriate to use? A. Memo B. Business Letter C. Newsletter D. Agenda

To increase or decrease the size of the content in a Microsoft Word window, which item on the status bar would you use? A. Zoom slider B. View picker C. Next page control D. Previous page control

To save a new file or an existing file in its same storage location, which commonly used shortcut key or keyboard key combination is used? A. CTRL+S B. ALT+S C. CTRL+V D. Shift+S

Trey wants to use the Black Tie Newsletter template created by Office.com. Which icon would he select to create this document? A. Blank Document B. Sample Templates C. My Templates D. Recent Templates

What area in Microsoft Word enables users to view document properties and update the properties information at any time while creating a document? A. Document Properties Panel B. Advanced Properties C. Word Options dialog box D. File Save as Options Screen

What area is used to provide information about the author, title, subject, keywords, category, and comments that describe the document? A. Document Properties Panel B. Advanced Properties C. Word Options dialog box D. File Save as Options Screen

What is the ghosted graphic that is displayed on top of or behind text in a document called? A. Watermark B. Emblem C. Logo D. Imprint

What is the method for changing the Bullet symbol within a list? A. Select the list and choose the drop-down arrow next to the Bullets button to select from the Bullet Library B. Choose a new bullet from the Bullet Library in the Font dialog box C. Choose a new bullet from the Bullet Library in the Format Paragraph dialog box D. Select the list and choose the drop-down arrow next to the Bullets button to change from the list level

What is the name of the Microsoft Word feature that reviews spelling and grammatical errors as you type and compares them against the Microsoft Word dictionary? A. Spelling & Grammar B. Review & Edit C. Spell Correct D. Dictionary Check

What is the name of the view that provides data about documents and contains a set of commands to help a user manage documents? A. Backstage B. Properties C. Document D. Normal

When comments are inserted into a Microsoft Word document, how can they be removed? A. Review Ribbon, Comments group, Delete command B. Insert Ribbon, Delete Comment command C. Double-click the comment to delete D. Review Ribbon, Comments group, Remove command

Which Microsoft Word tab contains the Print command? A. File B. Home C. Print Layout D. View

Which command on the Home Ribbon applies a shadow, glow, or reflection to selected text or paragraphs? A. Text Effects B. Text Highlight Color C. Shading D. Color

Which feature in Microsoft Word highlights insertions, deletions, or formatting modifications in a document? A. Track Changes B. Reviewer C. Mark Entry D. Compare

Which features of Microsoft Word automatically corrects typing, spelling, capitalization, or grammar errors as they are typed? A. AutoCorrect B. Spell & Grammer Check C. AutoSpell D. AutoCheck

Which of the following actions or commands cannot be undone in Microsoft Word? A. Saving a document B. Borders and shading C. Font color change and font size change D. Paragraph alignment and page orientations

Which of the following chart types are available in Microsoft Word? A. Bar, pie, line, and column B. Column, line, circle, and bubble C. Pie, bar, cone, and mountain D. Cone, bubble, oval, and line

Which of the following hidden formatting symbol represents a single space in a document? A. A small black dot B. A small dash C. A black arrow pointing right D. A single quotation mark

Which option is selected in the Columns dialog box to create multiple columns in only one paragraph of text in a document? A. Apply to: drop-down list B. Line Between C. Column Width D. Create Column

Pic

A (n) ________ chart is a type of chart used to show the relationship or proportion of parts to a whole.

Embedded chart

A (n) __________ _________ is a chart that is drawn on the same worksheet as the data.

A Blank cell always has a value of zero.

Pie Charts

A Graphic representation of data. A circle is divided into sectors which shows a percentage of a whole.

Style

A ___ is named group of formatting characteristics

Lookup

A _____ field allows the user to select from a list of values.

Range

A _________ is a series of two or more adjacent cells in a column, row or rectangular group.

Sparkline Charts

A ______________ ________ provides a simple way to show trends and variations in a range of data within a single cell.

Function

A _______________ is a prewritten formula that is built into excel. Ex. Sum, Max, Min

Condition

A _______________, which is made up of two values with a relational operator, is true or false for each cell in the range.

zero

A blank cell used in a formula has the numeric value of ________.

Cell

A box that you can enter data

Active

A cell is designated the _________ cell because it is the one into which data can be entered.

Cell reference

A cell is referred to by its unique address, or _______ ______________, which is the coordinates of the intersection of a column and a row.

Formula

A combination of cell references, operators, values, and/or functions used to perform a calculation.

Theme

A company or department may standardize with a specific ______ so that all of their documents have a similar appearance.

Workbook

A file containing related worksheets.

Circular Reference

A formula in a cell that contains a reference back to itself is called a __________ ___________.

Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create? A. =$B$1+25 B. =B1+25 C.=1$B$+25 D. =B1:B3

A. =$B$1+25

Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to estimate the grade on her next test? A. AVERAGE B. MAX C. MIN D. SUM

A. AVERAGE

Which Microsoft Excel feature automatically inserts data into a cell that begins with the same characters as a previous entry? A. AutoComplete B. AutoFill C. AutoCorrect D. AutoSpell

A. AutoComplete

David wants to key the numbers 1 to 1,000 in Column A of his spreadsheet. What command should he use to complete this task? A. AutoFill B. Filter C. Find and Replace D. Sort

A. AutoFill

Carl notices the last two lines of text in cell B4 are not showing up in his spreadsheet. How could Carl format the cell to correct this problem? A. AutoFit B. Special Formatting C. Subscript D. Merge

A. AutoFit

Which command on the Home Tab displays the total of the selected cells directly after the selected cells? A. AutoSum B. Add C. Total D. Calculate

A. AutoSum

Carl notices that the data in cell E4 reads #######. What command could Carl choose to correct this problem? A. Autofit B. Special Formatting C. Subscript FormattingD. Wrap Text

A. Autofit

Trey would like to outline the cell range A1:F20. Which formatting style should he select? A. Borders B. Cell Style C. Conditional Formatting D. Format as table

A. Borders

Kenyon would like to apply the Title format to the data in Row 1 of a spreadsheet. Which formatting style should he select? A. Cell style B. Conditional formatting C. Fill color D. Format as table

A. Cell style

Alicia needs to delete the data in cell B5. Which command would she select? A. Clear B. Copy C. Cut D. Format Painter

A. Clear

What type of formatting appears only when the value in a cell meets conditions specified by a user? A. Criterion B. Conditional C. Logical D. Restrictive

A. Criterion

Column D in a spreadsheet contains information about regional sales. Which formatting would be most appropriate for the data in column D? A. Currency B. Date C. Number D. Text

A. Currency

Which command on the "Home Ribbon" allows data to be moved from one worksheet location to another? A. Cut B. Move C. Copy D. Duplicate

A. Cute

Joan has entered her name in the first name field in cell b2 of her table. what does her first name represent in the table? a. Entry b. workbook c. row d. column

A. Entry

What is the name of the small black square in the lower-right corner of the heavy border of an active cell that repeats a cell's value in adjacent cells? A. Fill handle B. Filler C. Copy handle D. Copy box

A. Fill Handle

On the Home Ribbon, what do you use to change the text color of characters in a cell? A. Font Color drop-down list B. Font Size drop-down list C. Fill Color drop-down list D. Cell Styles drop-down list

A. Font Color drop-down list

Where can you find the command to apply a fill color to a cell or range of cells in a worksheet? A. Home Ribbon B. Insert Ribbon C. Page Layout Ribbon D. View Ribbon

A. Home Ribbon

Which command on the Insert Ribbon creates a link to a web page, picture, email address or program in a worksheet? A. Hyperlink B. Web link C. Linkup D. Text Link

A. Hyperlink

Joan is creating a table that will include demographic information about her employees. What is each header in her table considered? A. Label B. Value C. Formula D. Function

A. Label

Which view enables a user to create or modify a worksheet while seeing how it will look in printed format? A.Page Layout B. Print C. Normal D. Web

A. Page Layout

Which Microsoft Office object would you use for quick, convenient, one-click access to frequently used Excel commands? A. Quick Access Toolbar B. Title Bar C. Status Bar D. Formula Bar

A. Quick Access Toolbar

Which function do you use to insert today's date in a worksheet so that it automatically updates each time the worksheet is opened? A. Today B. Weekday C. Date D. CurrentDate

A. Today

Which of the following notebook-like features organizes the sheets for use in Excel? A. Workbook B. Worksheet C. Notepad D. Folder

A. Workbook

Tyler created a monthly sales workbook that contains the formula =SUM(Sales). "Sales" is an example of a(n): A. named range. B. external reference. C. names manager. D. scope.

A. named range

Shadow

Adding a ___ to text adds depth and helps the letters display prominently

+SUM(A12+A13)

Adding two cells

Creates mail merge envelope that places address of each customer in center

Address Block

Hal and Alive have both made changes separately to the Biology lab report that they created together. They need to turn in one final version to their teacher. Which Word tool could they use to easily create a single final report that includes both of their changes? A. Compare B. Combine C. Restrict Editing D. Track Changes

How are columns removed from a document? A. Select One Column in the Page Setup dialog box B. Select the column text and choose One from the Columns drop-down list on the Page Layout Ribbon C. Select No Column in the Paragraph dialog box D. Select the column text and choose the No Column command in the Arrange group on the Page Layout Ribbon

How does a user modify the colors in a selected theme? A. Choose the Theme Effects command on the Page Layout Ribbon B. Choose the Theme Colors command on the Page Layout Ribbon C. Choose the Theme Effects command on the Home Ribbon D. Choose the Theme Design command on the Page Layout Ribbon

In Microsoft Word, what is the name of the group of picture formatting characteristics that includes shadows, reflections, glow, soft edges, bevel, and 3-D rotation? A. Style B. Effects C. Cluster D. Group

In a Microsoft Word document, what are the printable text and graphics at the top of each page called? A. Title B. Header C. Lead Note D. Leader

In a Microsoft Word template, which of the following items indicates the location where information should be typed? A. Field B. Placeholder C. Container D. Marker

In the Print dialog box, which area provides a user with a list of available printers? A. Print B. Printer Status C. Printer List D. Printer Selector List

Jana wants to navigate page 35 of her report. What is the quickest way to navigate? A. Find B. Go To C. Replace All D. Replace

John would like to place a box around the entire document that includes his table. Which option should he choose? A. Border B. Page Border C. Shading D. Styles

Lois has created a table in her document. She would like to divide each cell in the top row of her table into two separate cells. Which option should she choose? A. Merge B. Split Cells C. Split Table D. Autofit

Nathan is designing an FBLA flyer and wants to draw a star. Which command would he use from the Insert Ribbon? A. Picture B. Shape C. WordArt D. SmartArt

Sally wants to select the entire document that she is currently editing. What is the quickest way to select the document? A. Double-Click B. Select All C. Single-Click D. Triple-Click

Sam wants to organize the data for his research paper. Which method would allow him to create a table with rows and columns of varying sizes? A. Insert Table B. Draw Table C. Quick Table D. Text to Table

To specify the exact style of the decorative lines used on a page, which dialog box is used? A. Line Style B. Borders and Shading C. Format Lines D. Format Borders

What is a series of paragraphs, each beginning with a bullet character, called? A. Organized list B. Bulleted list C. Unorganized list D. Symbol list

What is the default paragraph alignment for the Normal Style in Microsoft Word? A. Right B. Left C. Center D. Justified

What is the keyboard shortcut for inserting a manual page break? A. Ctrl+Insert B. Ctrl+Return C. Shift+Return D. Shift+Pause/Break

What is the name of a capital letter that is the first letter in a paragraph but is set in a larger font size than the rest of the characters in the paragraph? A. Paragraph starter B. Drop cap C. Line starter D. Paragraph capital

What is the name of the list of frequently used commands that appears when you right-click an object? A. Mini Toolbar B. Shortcut Menu C. Quick Access Toolbar D. Status bar

What is the process of changing the appearance of a paragraph of text called? A. Text formatting B. Paragraph formatting C. Character formatting D. Document formatting

What type of template is most appropriate for the FBLA Secretary to use to inform FBLA members of monthly club activities? A. Chart B. Newsletter C. Letter D. Fax

Where is the command to insert a new table into a Microsoft Word document? A. Home Ribbon, Table group B. Insert Ribbon, Table group C. Home Ribbon, Paragraph group D. Insert Ribbon, Pages group

Which Track Changes command allows a user to see what a document looked like before any changes were made to it? A. Reject All Changes B. Original C. Remove Edits D. Show Markup

Which automatically appears based on tasks you perform, and contains commands related to changing the appearance of text in a document? a. Dialog Box B. Mini Toolbar C. Shortcut Menu D. Ribbon

Which command on the Home Ribbon allows a user to change the case of selected text to all uppercase, lowercase, sentence case, toggle case, or capitalize each word? A. Modify Case B. Change Case C. Superscript D. Increase Font

Which command on the Picture Tools Format Ribbon is used to change the way text wraps around a selected object? A. Position B. Wrap Text C. Align Text D. Text Direction

Which dialog box allows a user to create a new folder in the desired storage location? A. Options B. Save As C. Close D. Print

Which group on the Home Ribbon contains commands to control the alignment of text in a document? A. Font B. Paragraph C. Editing D. Modify

Which is the shortcut key for accessing Microsoft Office Word Help from the Word window? A. F4 B. F1 C. F5 D. F9

Which of the following are valid placement options for page numbers in a document? A. Left of page or bottom of page B. Top of page or bottom of page C. In the endnote or top of page D. Top of page or in the footnote

Which of the following terms defines the appearance and shape of the letters, numbers, and special characters in a document? A. Print B. Font C. Scheme D. Format

Which tab group within the Insert Ribbon contains the commands that enable a user to insert common mathematical symbols or equations? A. Format B. Symbols C. Text D. Pages

Which term refers to the oblong boxes that appear when formatting changes are made in a document while tracking changes? A. Citations B. Balloons C. Comments D. Captions

Which tool on the Home Ribbon lets a user search for text in a document by keying the word into a search box? A. Select B. Find C. Search D. Locate

Which type of drawing object enables users to create shadowed, rotated, stretched, and wavy text effects? A. SmartArt B. WordArt C. DrawingArt D. EasyArt

Command to cancel recent action

Undo

False

Use the Autocomplete area on the status bar to quickly obtain information on the sum or average of a selected range.

What-if

Using Excel to scrutinize the impact of changing values in cells that are referenced by a formula in another cell is called __________ ____ or sensitivity analysis

Format Painter

Using the ____________ _____________ in the Clipboard Group of the Home Ribbon, a cell can be formatted quickly by copying a cell's format to another cell.

Drag and Drop

Using the mouse to move or copy cells is called ________ _____ ________.

Modify the worksheet so the first row is always visible when you scroll the worksheet down.

View Tab - Freeze Panes

Tab Color

Virgil wants to emphasize the sheet tabs in his workbook. Which command should he choose?

Layout to display document as it would online

Web Layout

Slicers

What are graphical objects that contain buttons a user can click to filter the data in PivotTables and PivotCharts?

Fill color

What command is used to apply a background color to cells in a worksheet?

Font Color

What defines the color of the characters in a Microsoft Excel worksheet?

Display cells with two decimals places that align vertically

What effect does the accounting number format format have on the selected cells?

Display cell content with two decimal places and commas as thousands separators

What effect does the comma style format have on the selected cells?

=B3*C3

What formula is in D3??

Shortcut Menu

What is the name of the list of frequently used Excel commands available when a user right-clicks an item in the worksheet?

Fill Handle

What is the name of the small black square in the lower-right corner of the heavy border of an active cell that repeats a cell's value in adjacent cells?

active cell

What is the part called that has the BLACK BORDER BOX

Ctrl End

What is the shortcut that will lead to the last record on her spreadsheet?

Numeric Data and Titles

What is typically included in the range of data selected to create a chart?

columns

What part of Excel Window is labeled with the ALPHABET

rows

What part of Excel Windows is labeled with NUMBERS

Insert

What ribbon contains the commands for creating charts in Microsoft Excel?

What symbol shows that you are dividing??

What symbol shows that you are inserting a formula??

What symbol shows that you are multiplying??

Exploded

What term refers to an Excel Chart with offset pieces for emphasis?

best fit

When Excel automatically sets the width of a column based on the widest entry in the column, it is called ____________.

Workbook

When Excel opens a new _____________ is created, which is like a notebook.

workbook

When a Microsoft Excel document is saved, what is it called??

Format

When a number is entered with a (n) ___________ symbol, Excel immediately displays the number with an assigned format.

False

When adding a row to a spreadsheet, by default in comes in below the selected range.

Trace Error

When an error occurs in a formula in a cell, Excel displays the _________ ________ button next to the cell with the error by placing a green triangle in the upper left hand corner of the cell.

When an error occurs in a formula in a cell; Excel displays the Trace Error button next to the cell, and places a green triangle in the upper left of the cell.

Relative reference

When cell references are copied, each cell reference that Excel automatically adjusts for the new position is called a (n) ___________ ______________.

Fields

When creating a PivotTable, which are drawn in columns in the worksheet data?

Equal

When creating a column/bar chart with two or more separate ranges, make sure that you select a ________ number of columns or rows in each range.

Backspace Key

When entering data into a cell, which keyboard key is used to remove characters to the left of the insertion point?

False

When entering dollar values in cells, you also must type the dollar sign ($), commas, and any trailing zeros

Above

When proposing the range, the Sum Function first looks for a range of cells with numbers _______ the active cell and then to the left.

ALT

When resizing a chart, you should hold down the ______ key so the edge of the chart snaps to the next gridline.

True

When the Enter Box is used to complete an entry the active cell remains the same.

Marquee

When using the SUM function the proposed range to sum is surrounded by a __________.

True

When using the keyboard to type the correct range for a function a colon (:) is used between cell references.

You can accomplish almost any formatting task by selecting a cell or range of cells, right-clicking on that cell or range of cells, and then selecting Format Cells from the shortcut menu.

Transparency Slider

You can change the transparency of a picture used as a slides background with the ____

CTRL Accent

You can change the view of a worksheet from the values version and formulas version by holding down ________+ ( ).

True

You can clear cell contents and formatting by tapping or clicking Clear Contents on the Clear button menu.

Autocalculate

You can easily obtain a total, an average, maximum or minimum for numbers in a range by using the ___________________ area on the status bar.

You can enter Header and Footer information by switching from Normal View to Page Layout View.

False

You can only best fit columns one at a time.

True

You can press the esc key to cancel a cell entry before entering it into a cell.

Tiling

You can use ____ opinions to repeat a background image many times vertically and horizontally on a slide

#div/0

You need numbers in your cells. You cannot divide by zero

both a & b

You should use Point Mode when entering in formulas because _________.

Data table

You use a(n) _____ to automate data analyses

False

You use the ALT key when trying to select more than one range.

Used to specify size of viewable are and allow users to reduce or enlarge size of window

Zoom

Gradient fill

___ is one color shade gradually progressing to another shade of the same color or to another color

Transparency

____ allows you to see through the background, so that nay text on the slide is visible.

WordArt styles

____ allows you to type new text or convert existing text to WordArt

Brightness

____ determines the overall lightness or darkness of an entire image

Contrast

____ is the difference between the darkest and lighters areas of an image

Pattern fill

_____ adds designs that repeat in rows across a slide

Flash Fill

_______ ____ is an Excel feature that looks for patterns in the data and automatically fills or formats data in the remaining cells.

Best Fit

_______ ______ means that the width of a column or row will be increased or decreased so the widest entry will fit in the column.

Graphics

_______ help clarify and emphasize details, so they appeal to audience members with differing backgrounds, reading levels, attention spans, and motivations

Cell protection

________ ensure that users do not change values inadvertently that are critical to the worksheet.

Point Mode

__________ _________ allows cells to be selected for use in a formula by using the mouse.

Freezing

___________ worksheet titles is a useful technique for viewing large worksheets that extend beyond the window so that Excel displays row and column headings no matter how far down or to the right you scroll.

Hidden

_______________ cells is a technique that can be used to hide data that might not be relevant to a particular report or sensitive data that you do not want others to see.

Debugging

_______________ is the process of finding and correcting errors in a worksheet.

Landscape

________________ orientation is a good choice for large worksheets, because when printed the worksheets width is greater than its height.

Assumption

__________________ are values in cells that can be changed to determine new values for formulas.

Conditional

__________________ formatting offers the ability to automatically change how a cell appears - the font, font color, background fill, and other options - based on the value of the cell.

Parentheses

_____________________ can be used in a formula to override the order of operations.

A chart is:

a visual depiction of numerical data

EXCEL: When you enter a two-digit year that is less than 30, Excel changes the year to ______. a. 20xx b. 30xx c. 18xx d. 19xx

a. 20xx

EXCEL: _______ ensures that users do not change values inadvertently that are critical to the worksheet. a. Cell protection b. Range Finder c. The formula checker d. A data table

a. Cell protection

EXCEL: Which of the following Auto Fill Options menu options i the same as the Fill Series option? a. Fill months b. Fill Without Formatting c. Fill Formatting Only d. Copy Cells

a. Fill months

EXCEL: Which of the following keys moves the insertion point to the beginning of data in a cell? a. HOME b. ENTER c. INSERT d. TAB

a. HOME

EXCEL: The _______ function is useful when you want to assign a value to a cell based on a logical test. a. IF b. NOW c. AND d. OR

a. IF

EXCEL: Clicking the ______ opens the Insert Function dialog box. a. Insert Function box in the formula bar b. Function dialog box launcher (HOME tab | Calculations group) c. Function button (HOME tab | Function group) d. Functions & Formulas button on the status bar

a. Insert Function box in the formula bar

EXCEL: Pressing the_____ key to complete an entry activates the adjacent cell to the right. a. RIGHT ARROW b. LEFT ARROW c. UP ARROW d. DOWN ARROW

a. RIGHT ARROW

EXCEL: ______ is/are used to place worksheet, column, and row titles on a worksheet. a. Color b. Text c. Links d. Tabs

b. Text

EXCEL: A(n) _______ shows the beginning and ending balances and the amount of payment that is applied to the principal and interest during each payment period. a. dialog box b. amortization schedule c. formula checker d. data table

b. amortization schedule

EXCEL: A(n) _______ chart provides a simple way to show trends and variations in a range of data within a single cell. a. section b. sparkline c. special d. sparkle

b. sparkline

EXCEL: The first step in creating an effective worksheet is to make sure you _____. a. apply font formatting b. understand what is required c. insert chart d. enter the data

b. understand what is required

A(n) ___ chart is a derivative of a scatter chart in which both axes are value axes.

bubble

EXCEL: Which of the following is the path to the Increase or Decrease Indent button? a. (HOME tab | Clipboard group) b. (HOME tab | Editing group) c. (HOME tab | Alignment group) d. (HOME tab | Number group)

c. (HOME tab | Alignment group)

Which of the following of cell reference will not change when the formula was copied and pasted in another cell?

B. $A$1 (Absolute Reference)

Which quick-number style button formats numbers to display as currency in the worksheet? A. Precent B. Accounting C. Comma D. Dollar

B. Accounting

Steve would like to print only the worksheet he is currently working on. What print option should he choose? A. Print Area B. Active Sheets C. Entire Workbook D. Quick Print

B. Active Sheets

In an Microsoft Excel worksheet, how do you change the width of a column so that the widest entry will fit? A. Smart Fit B. AutoFit C. Best Fit D. Trust Fit

B. AutoFit

When entering data into a cell, which keyboard key is used to remove characters to the left of the insertion point? A. Delete key B. Backspace Key C. Left arrow key D. Enter key

B. Backspace key

Which command do you use to format a cell or selected cells quickly by choosing from a defined list of styles? A. Format as table B. Cell Style C. Conditional Formatting D. Form

B. Cell style

What method is the MOST EFFICIENT way to copy five separate formulas to adjacent cells simultaneously? A. Copy method from Shortcut Menu B. Copy using the Fill Handle C. Copy from the Home Ribbon D. Copy using the Quick Access Toolbar

B. Copy using the Fill Handle

Joan wants to add a new entry at the bottom, of her spreadsheet. What is the shortcut that will take her to the last record on her spreadsheet? A. Ctrl + Home B. Ctrl+End C. Ctrl+Up Arrow D. Ctrl+1

B. Ctrl+End

Which command do you use to reduce the margin between the border and the text in an indent cell? A. Orientation B. Decrease Indent C. Column Width D. Alignment

B. Decrease Indent

Which group on the Formulas Ribbon contains a command that allows a user to create names for cells to use in a formula? A. Function Library B. Defined Names C. Formula Auditing D. Calculation

B. Defined Names

To help organize and identify Microsoft Excel files by providing details about the files, which of the following would you use? A. File details B. Document Properties C. File facts D. Document options

B. Document Properties

What command do you use to a supply a background color to cells in a worksheet? A. Drawing B. Fill Color C. Borders & Shading D. Highlight

B. Fill Color

Which defines the appearance and shape of the letters, numbers and special characters in Microsoft Excel? A. Alignment B. Font C. Size D. Effects

B. Font

What defines the color of the characters in an Microsoft Excel worksheet? A. Font Size B. Font Color C. Cell Color D. Background

B. Font Color

On the Home Ribbon, what do you use to change the font size of characters in a cell? A. Font drop-down list B. Font Size drop-down list C. Font Style drop-down list D. Cell Styles drop-down list

B. Font Size drop-down list

Which dialog box in Microsoft do you use to set the rotation of text in a cell to a specific degree? A. Orientation B. Format Cells C. Format Text D. Alignment

B. Format Cells

Where can you find the Insert Function button in Microsoft Excel? A. Quick Access Toolbar B. Formula bar C. Status bar D. Shortcut menu

B. Formula bar

Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to find the highest test grade? A. AVERAGE B. MAX C. MIN D. SUM

B. MAX

Kathryn needs the title in cell A1 to align horizontally across cells A1 through D1. Which alignment option should she select? A. Center B. Merge and Center C. Orientation D. Wrap Text

B. Merge and Center

Joyce needs to access a spreadsheet she saved yesterday. Which command would she select? A. Exit B. Open C. Save D. Save As

B. Open

Which command on the Home Ribbon do you use to rotate text to a vertical or diagonal angle in a worksheet? A. Font B. Orientation C. Wrap Text D. Merge & Center

B. Orientation

John wants to print only the Inventory worksheet that he is currently working on in his workbook. Which option should he choose? A. Print Selection B. Print Active Sheet C. Print Entire Workbook D. Fit Sheet on One Page

B. Print Active Sheet

Which group on the View Ribbon enables a user to show or hide the ruler, gridlines, Formula Bar, or headings? A. Workbook views B. Show C. Zoom D. Window

B. Show

John wants to be able to view multiple areas of his spreadsheet at the same time. What would be his best option? A. Freeze Panes B. Split C. Hide D. Unhide

B. Split

What function adds all of the numbers in a range of cells? A. Calculate B. Sum C. Compare D. Add

B. Sum

What occurs when the cursor is moved over a cell and a user clicks? A. The row is selected B. The cell is selected C. The column is selected D. The worksheet is selected

B. The cell is selected

Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel? A. Workbook B. Worksheet C. Notepad D. Folder

B. Worksheet

Joshua created a budget workbook that contains the formula =(Summary!B3). "Summary" is an example of a(n): A. named range. B. external reference. C. names manager. d. scope

B. external reference

Tyler created a monthly sales workbook that contains the formula =(January!B3). "January" is an example of a(n): A. named range. B. external reference. C. names manager. D. scope.

B. external reference.

Jennifer is calculating her GPA. If she uses "=(A1+A2+A3+A4)/4", this is an example of which type of entry? A. values B. formulas C. labels D. functions

B. formulas

View that provides data about documents and contains set of commands to help user manage documents

Backstage

Chart types available

Bar, pie, line and column

Hidden formatting symbol that represents tab stop

Black arrow pointing right

Angie is designing a band flyer and wants a picture of a drum set to appear behind the text. Which command should she use? A. Crop B. Sizing Handles C. Wrap Text D. Position

Ann wants to add her name to the Microsoft dictionary. Which section of Backstage/Options will she use? A. Advanced B. Display C. Proofing D. Save

Joan would like to place the table she has created in her document in another document as well. Which option should she choose? A. Insert B. Delete C. Copy D. Cut

Johanna wants to navigate across columns to the left in her table. Which option should she choose? A. Tab B. Enter C. Left Arrow Key D. Shift+Enter

Jordan inserted an image from his USB Drive into his science report. What did he insert? A. Screenshot B. Screen clipping C. Picture D. Print Screen

Kin inserted a rectangular shape into her Word document. She wanted to fill the shape with a Microsoft Logo. Which shape fill option should she use? A. Texture B. Solid Color C. Picture D. Gradient

Lisa wants to adjust the white space around a cell in her table. Which layout feature will she apply? A. Cell Alignment B. Text Direction C. Cell margins D. Distribute Rows

Mark creating a three column newsletter. He wants to end the first column early to insert a picture below it. What should Mark do? A. Adjust column width B. Adjust column spacing C. Insert a column break D. Insert a vertical line between columns

Mrs. Perry has assigned the class to type a report. To view the report as a hard copy, which view should she use? A. Read Mode B. Outline C. Print Layout D. Web Layout

Nathan is using a business letter template he created earlier and wants to save it with all the customers information. What file type should he select? A. Template B. Macro C. Document D. Building Block

On the View Ribbon, which command allows the document to be viewed as it would appear in a multilevel outline? A. Print Layout B. Draft C. Outline D. Web Layout

Sara inserted a graphic used to visually display her family tree. Which graphic did she use? A. Charts B. Shapes C. SmartArt D. WordArt

Sara inserted an arrow to point out information in a newsletter, which object did she use? A. Charts B. Shapes C. SmartArt D. WordArt

The principal wants to send our a monthly update of school activities. Which type of document is the most appropriate to use? A. Memo B. Business Letter C. Newsletter D. Agenda

To make text appear in a smaller font size below the middle point of the line, which character formatting effect is applied? A. Superscript B. Strikethrough C. Subscript D. Italic

To specify the size of the viewable area and allow users to reduce or enlarge the size of a document window, which command is used? A. Scale B. Resize C. Zoom D. Scope

What are the built-in predefined styles used for formatting text called? A. Auto Styles B. Instant Styles C. Quick Styles D. Normal Styles

What are the decorative lines used to surround a page or the elements on a page called? A. Box B. Outline C. Page Border D. Frame

What are the text and graphics that print at the bottom of every page in a Microsoft Word document called? A. Footnote B. Endnote C. Footer D. Closer

What does Microsoft Word automatically insert when it determines the text has filled one complete page allowed by the page size, margin settings, line spacing, and other settings? A. Line change B. Soft line change C. Page break D. Soft page change

What is the control center located below the title bar at the top of the Microsoft Word window called? A. Task Pane B. Tab C. Ribbon D. Groups

What is the name assigned to a file when it is saved? A. Document name B. Document title C. File name D. File title

What is the name of the note that can be inserted into a Microsoft Word document by a reviewer to communicate suggestions, alerts, or tips to the author? A. Footnote B. Citation C. Comments D. Caption

What is the process of changing the way characters appear, both on screen and in print, to improve document readability? A. Text formatting B. Paragraph formatting C. Character formatting D. Document formatting

What type of break is used to create a new section on the same page as the previous section? A. Text B. Line C. Continuous D. Page

What type of paragraph indention forces the first line into a position to the left of the rest of the paragraph? A. Left indent B. Right indent C. Hanging indent D. Forced indent

Where does Microsoft Word put elements such as text, logos, graphics saved for later use in a document? A. Building Blocks Gallery B. Parts Gallery C. Quick Parts Gallery D. Element Gallery

Where is column width and spacing controlled in a Microsoft Word document? A. Page Setup dialog box on the Page Layout Ribbon B. Paragraph dialog box on the Home Ribbon C. Columns dialog box on the Page Layout Ribbon D. Font dialog box on the Home Ribbon

Which Editing group tool is used to search for and replace specific text in a document? A. Select B. Find C. Replace D. Locate

Which command is used to close the current document without exiting Microsoft Word? A. File tab, choose Exit button B. Close button in upper right corner of the program window C. File tab, choose Close button D. File tab, choose Quit button

Which command is used to find the number of words, characters, paragraphs, or lines in a Microsoft Word document? A. Compare B. Review C. Word Count D. Research

Which command is used to insert a picture file from a storage device into a document? A. Screenshot B. Import C. Picture D. ClipArt

Which of the following hidden formatting symbol represents a tab stop in a document? A. A small black dot B. A small dash C. A black arrow point right D. A single quotation mark

Which of the following refers to text that is arranged in alphabetic, numeric, or date order based upon the first character? A. Filtering B. Alphabetizing C. Sorting D. Ordering

Which of the following software programs is a full-featured word processing program that allows users to create professional-looking documents and revise them easily? A. Microsoft Office B. Windows C. Word D. WordPad

Which of the small, white circles surrounding a graphic allows a user to proportionately realize the graphic? A. Left B. Top C. Corner D. Button

Which option on the Apply Styles dialog box changes the settings for a selected style? A. Change Styles B. Edit C. Modify D. New Style

Which ribbon contains the command to change the preset margin settings in a Microsoft Word document? A. Home B. Insert C. Page Layout D. Review

Which ribbon contains the command to create headers in a document? A. File B. Home C. Insert D. Page Layout

Which ribbon includes the command for inserting charts that illustrate or compare data? A. File B. Home C. Insert D. Draw

Which ribbon is used to insert a new row into a Microsoft Word table? A. Table Tools Format Ribbon B. Table Tools Edit Ribbon C. Table Tools Layout Ribbon D. Table Tools Design Ribbon

Which tool converts words or paragraphs into a different language using the Microsoft Word bilingual dictionaries? A. Spelling & Grammar B. Research C. Translate D. Thesaurus

Which window allows a user to see document pages exactly as they will print? A. Print Outline B. Document C. Print D. Review

To properly move a chart to another worksheet, you should use the function ________ move chart

C. move chart

Linda deposits 200 into a bank every month. The annual interest rate is 6%. She deposits the money for 4 years. Which one of the following is the function to calculate the money she would have at the end of the fourth year?

C. = -FV(6%/12, 4*12, 200) [with a minus - sign before the future value]

Gabriel needs to create a shortcut formula in cell B40 to calculate total sales located in cells B1 through B39. Which function should he create? A. =$B$1+25 B. =B1+25 C. =SUM(B1:B39) D. =B1:B39

C. =SUM(B1:B39)

Which of the following are valid Microsoft Excel functions? A. AVERAGE, MAX, and NUM B. MAX, MIN, and WEEK C. AVERAGE, MAX, and MIN D. WEEKDAY, MAX and CLOSE

C. AVERAGE, MAX, and MIN

What type of formula cell reference instructs Microsoft Excel to keep the cell reference constant in the formula as it copies it to the destination area? A. Relative B. Mixed C. Absolute D. Unconditional

C. Absolute

What Command will arrange Microsoft Excel windows so that they appear side by side on the screen? A. Zoom to selection B. New Window C. Arrange All D. Freeze Panes

C. Arrange All

How is a cell reference in a formula and its corresponding location in a worksheet identified? A. Arrows pointing from the formula to the location B. Cell reference and cell location are circled C. Cell reference and cell location are outlined in matching colors D. Lines connect from the formula to the location

C. Cell reference and cell location are outlined in matching colors

Trey would like to apply a rule to the data in cell range A1:F20 that will highlight greater than 50,000 with a yellow fill color and dark yellow text. Which formatting style should he select? A. Borders B. Cell Style C. Conditional Formatting D. Format as table

C. Conditional Formatting

To display the formula in a worksheet, a user should press ____________

C. Ctrl + Accent

Alicia needs to move the date in cell B5 to cell E5. Which command would she select? A. Clear B. Copy C. Cut D. Format Painter

C. Cut

Which of the following software programs is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data? A. Word B. Publisher C. Excel D. PowerPoint

C. Excel

Which command do you use to close an open file and completely exit the Microsoft Excel program? A. Close B. Save As C. Exit D. Quit

C. Exit

What area contains the command used to customize the print options in Microsoft Excel? A. Home Ribbon B. Page Layout Ribbon C. File Tab D. Quick Access Toolbar

C. File Tab

Which group on the Formulas Ribbon contains the command that checks for common errors found in a formula? A. Function Library B. Defined Names C. Formula Auditing D. Calculation

C. Formula Auditing

What is a prewritten formula that is built into Microsoft Excel called? A. Utility B. Procedure C. Function D. Statement

C. Function

Which ribbon option opens a related dialog box? A. Ellipse B. Drop-down Arrow C. Launcher D. Slider

C. Launcher

Larkeysha has created a spreadsheet containing student grades. Which function would she use to return the current date and time in cell A1? A. COUNT B. IF C. NOW D. TODAY

C. NOW

Which area, on the left side of the formula bar, can you look at to determine the cell address of a selected cell? A. Cell Box B. Address Box C. Name Box D. Formula Box

C. Name Box

Which view is the default view used in Microsoft Excel? A. Page Layout B. Print C. Normal D. Web

C. Normal

Which one of the following statement is NOT true about the function Table?

C. Once the Table function is applied on the data, there is no way to convert it back. (The above statement is FALSE/NOT TRUE)

Kathryn needs the text in cell A1 to be angled at 90 degrees. Which alignment option should she select? A. Center B. Merge and Center C. Orientation D. Wrap Text

C. Orientation

Jim would like to print only the cell range A1:F20. What page setup option should he change? A. Orientation B. Page Break C. Print Area D. Print Titles

C. Print Area

John's workbooks includes 3 worksheets. Which option should he choose to print them? A. Print Selection B. Print Active Sheet C. Print Entire Workbook D. Fit to one page

C. Print Entire Workbook

Sharon's spreadsheet contains information about the number of music downloads in F1:F25.F1:F25 represents a: A. Cell B. Column C. Range D. Row

C. Range

Which term refers to a group of selected cells that may be formatted, moved, copied or deleted as a group? A. Segment B. Set C. Range D. Cluster

C. Range

Joan has a table that includes demographic information about her employees. What does all the information about one employee represent? A. Entry B. Workbook C. Row D. Column

C. Row

Joyce has updated the data in an existing spreadsheet. Which command would she select to preserve the data for future use? A. Exit B. Open C. Save D. Save As

C. Save

Which command enables a user to save an existing worksheet with a new name or save the worksheet in a new location? A. Close B. Save C. Save As D. Exit

C. Save As

What is the name of the list of frequently used Excel commands available when a user right-clicks an item in the worksheet? A. Mini Toolbar B. Quick Access Toolbar C. Shortcut Menu D. Shortcut Toolbar

C. Shortcut Menu

Jennifer needs to identify the values in column B for a sales report. Which type of entry should she use in the column header? A. values B. formulas C. labels D. functions

C. labels

Jennifer needs to identify the values in column B for a statistics report. Which type of entry should she use in the column header? A. values B. formulas C. labels D. functions

C. labels

What is the best option for adding a calculation to a PivotTable that does not already exist?

Calculated field

AVERAGE function

Calculates the arithmetic mean, or average, of values in a range.

PMT Function

Calculates the periodic payment for a loan with a fixed interest rate and fixed term.

SUM Function

Calculates the total of values contained in two or more cells.

Text placed below object

Caption

To enter data in a cell, you must first select the _______

Cell

Layout feature to make text start at top left

Cell Alignment

Layout feature to adjust white space around cell

Cell Margins

Command group in Table Tools that contains command to modify height or width of rows and columns

Cell Size

Relative References

Cell references that Excel adjusts when a formula or function is copied are called __________ ___________

Changes case of selected text

Change Case

Group in Review Ribbon containing command to accept or reject changes made to document

Changes

Changing way characters appear on screen and in print to improve readability

Character Formatting

How different underline styles are selected when applying underline format

Choose Underline drop-down arrow on Home ribbon

Use Format Painter to copy the formatting from cell D1 and apply it to cell E1.

Click Paintbrush Icon on Home Tab (located by Paste/Clipboard) - Click on desired cell

How to access Word Help from Word Window

Click Word Help button in upper right of window

Collapse the entire outline to show just the subtotals.

Click the 2 outline symbol at the left of the column headings.

How do users switch from one ribbon to another?

Click the tab of the ribbon they wish to access

Insert Function box in the formal box

Clicking the ____ opens the insert function dialog box.

compares groups set side by side relationship of individual data points to the whole

Clustered column chart Stacked column chart

Reviews headings in Outline view

Collapse

######

Column is not wide enough

Merging

Combining two or more selected cells into one cell is called ______ cells

AutoFill

Completes previously typed words when you begin to repeat the typing

Mixed Cell Reference

Contains both an absolute and a relative cell reference in a formula; the absolute part does not change but the relative part does when you copy the formula.

Tool to survey users through yes or no questions

Content Controls

Sort

Cooper is creating a spreadsheet for FBLA and wants to be able to put the spreadsheet in alphabetical order by last name. What should Cooper apply to the spreadsheet?

Command to place content from one source to another

Copy

Small white circles surrounding graphic that allows user to resize graphic

Corner

Shortcut for inserting manual page break

Ctrl Enter

Shortcut used to save a new file or an existing one in its same storage location

Ctrl S

Alexis formatted a dot leader in a Table of Contents document. Which tab stop should she use to align page numbers so that it will result in an even right edge? A. Bar Tab B. Decimal Tab C. Left Tab D. Right Tab

In Nathan's parenting class, he has been assigned to diagram his family tree. Which command would be the most appropriate for a quick and easy visual representation? A. Picture B. Shape C. WordArt D. SmartArt

John wants add predefined formatting to his table. Which option should he choose? A. Border B. Page Border C. Shading D. Styles

Kim inserted a rectangular shape into her Word document. She wanted the shape to transition from one color to another. Which shape fill option should she use? A. Texture B. Solid Color C. Picture D. Gradient

Linda is creating a custom template. If it will be quicker to use the template than to recreate the flyer from scratch each time, which important question is she answering? A. Who is the intended audience? B. Is the template easy to use? C. Will the template have correct calculations and functional macros? D. Will the template have correct spelling, grammar, punctuation, and mechanics?

Lois is unable to view all the information in the first column of her table. Which option should she choose? A. Merge B. Split Cells C. Split Table D. Autofit

Mrs. Perry has assigned the class to type a report. To display the report as it would appear online, which view should she use? A. Read Mode B. Outline C. Print Layout D. Web Layout

Sally wants to select an entire paragraph in her word processing document. What is the quickest way to select the paragraph? A. Double-Click B. Select All C. Single-Click D. Triple-Click

Sam has a list of names (Last name, First name) in Word that he needs to put into a table and separate the last name from the first. Which option should he use? A. Insert Table B. Draw Table C. Quick Table D. Text to Table

To save an existing document with a new file name or to save an existing document in a new location, which command is used? A. Save B. Close C. Exit D. Save As

To store a new or existing file with the same name, which button is used? A. Exit B. Close C. Save As D. Save

What command on the Insert Ribbon creates a preformatted placeholder for text in a document? A. WordArt B. Bookmark C. Hyperlink D. Textbox

What group in the Review Ribbon contains the command to accept or reject changes made to a document? A. Proofing B. Compare C. Tracking D. Changes

What is a quick way to close the Header or Footer view in a Microsoft Word document? A. Right-click the footer or header B. Double-click the footer or header C. Double-click the title bar D. Double-click the dimmed document text

What is the amount of vertical space between the lines of text in a paragraph called? A. Paragraph spacing B. Document spacing C. Character spacing D. Line spacing

What is the command on the Insert Ribbon used to capture and insert a picture of any other open program windows? A. Picture B. ClipArt C. Shapes D. Screenshot

What is the correct file format of a normal Microsoft Word template? A. .docx B. .dot C. .tmp D. .dotx

What is the default space between columns? A. 1 inch B. 0.25 inch C. 1.25 inch D. 0.5 inch

What is the descriptive text placed below an object called? A. Footer B. Endnote C. Footnote D. Caption

What is the process of creating a duplicate of an item while leaving the original item in place in the document called? A. Cut B. Move C. Paste D. Copy

Where is the command to divide a Microsoft Word document into multiple columns located? A. Home Ribbon, Paragraph group B. Home Ribbon, Styles group C. Insert Ribbon, Text group D. Page Layout Ribbon, Page Setup group

Which action would Drake take to insert the contents from the Office Clipboard into a document? A. Keep Source Formatting B. Keep Text Only C. Merge Formatting D. Paste

Which alignment option indicates that text in a document is aligned to both the left and right margins? A. Left align B. Right align C. Center align D. Justify align

Which command group in the Table Tools Layout Ribbon contains the command to modify the height or width of rows and columns in a table? A. Editing B. Cell Size C. Rows and Columns D. Table Styles

Which command on the Insert Ribbon is used to select a part of a program window to insert into a file? A. Screen Cutting B. Screenshot Clip C. Screen Clipping D. Screen SnapShot

Which commonly used shortcut keys or keyboard combination is used to apply bold formatting to selected text? A. Tab+B B. Shift+B C. Alt+B D. Ctrl+B

Which dialog box provides the user with the ability to replace text as it is typed? A. AutoFormat B. Find & Replace C. AutoCheck D. AutoCorrect

Which group contains the command to place text at the bottom edge of each printed page of a document? A. Links B. Text C. Format D. Header & Footer

Which of the following refers to how the left and right edges of a paragraph align on a page? A. Indent B. Flow C. Position D. Alignment

Which ribbon contains the commands to apply preset styles to a Microsoft Word table? A. Table Tools Format Ribbon B. Table Tools Edit Ribbon C. Table Tools Layout Ribbon D. Table Tools Design Ribbon

Which term refers to the two page layout positions of a document? A. Direction B. Alignment C. Configuration D. Orientation

Which two ribbons become available when a table is selected in a Microsoft Word document? A. Table Format and Table Tools B. Table Tools and Table Edit C. Table Tools Edit and Table Tools Format D. Table Tools Design and Table Tools Layout

What command do you use to increase or decrease the view of a selected cell or range of cells to fill the Excel Window area for better visibility? A. Magnify Area B. Enlarge Selected Area C. Amplify Range D. Zoom to Selection

D. Zoom to selection

Angie is calculating her average sales for the past four months. If she uses "=AVERAGE(B1:B4)", this is an example of which type of entry? A. values B. formulas C. labels D. functions

D. functions

Which bar presents information about a document, the progress of current tasks, and the status of certain commands and keys, and also provides controls for viewing the document? A. Task B. Scroll C. Tool D. Status

D...

Use the Flash Fill command to autofill the remaining cells in this column with the pattern from cell F2.

Data Tab - Data Tools Group - Flash Fill

Sort the data first alphabetically by the values in the Category column and then by the dates in the Date column with the oldest dates first.

Data Tab - Sort - Catgeory - Add Level - Date

Filter the data in place so that only rows where the Category value is Meals and the Cost value is greater than 20 are shown. The criteria range has been set up for you in cells A1:C2.

Data Tab - Sort and Filter - Advanced

Goal Seek appears in which tab group within Excel?

Data Tools

Where is the Subtotal command located on the Ribbon?

Data tab

Which of the following is Not a number format available in the Number group on the Home tab?

Date Format

Filter

David only wants to view the employees in the Marketing department who earn a salary of more than $25,000. What command should he use to complete this task?

Makes one section less important in Outline view

Demote

What does the Values Area of a PivotTable do?

Displays summary statistics, such as totals or averages.

Formula Bar

Displays the content (text, value, date, or formula) in the active cell.

NOW Function

Displays the current date and time.

TODAY Function

Displays the current date.

MIN Function

Displays the lowest value in a range.

Sheet Tab

Displays the name of a worksheet within a workbook.

Type of document to use letter created earlier to save with all customer's info

Document

Area that enables user to view properties and update info at any time

Document Properties Panel

Area used to provide info about author, title, subject, keywords, category and comments about document

Document Properties Panel

Add a report filter for the Employee field and use it to filter the PivotTable to show only data where the value of the Employee field is Dr. Patella.

Drag Employees to Filter - Go to Employees Cell - Select drop arrow - Dr Patella

Capital letter that is much bigger then the rest of text

Drop Cap

Which of the following is not a method supported by Solver?

Duplex

16,384

Each Excel worksheet has over ___________ possible columns.

1,048,576

Each Excel worksheet has over ___________ possible rows.

Sheet tab

Each worksheet has a name that appears on a _______ ____ at the bottom of the workbook.

Merge option to save merged documents in file or edit contents individually

Edit individual letters

Column

Edward would like to create a chart that uses vertical rectangles to compare iPod and iPad sales. Which chart type would he create?

Auto Fill

Enables you to copy the contents of a cell or cell range or to continue a sequence by dragging the fill handle over an adjacent cell or range of cells.

Reference note displayed at end of document

Endnote

Clicking the _____ box completes an entry

Enter

#name?

Error in your formula

IF Function

Evaluates a condition and returns one value if the condition is true and a different value if the condition is false.

Left-aligned

Excel automatically positions text ____________ in a cell.

Name box

Excel displays the active cell reference in the ________ _______, which can also be used to move to a specific cell or range of cells.

#REF!

Excel displays the error message ____ _____ in cells to indicate a cell reference error as a result of deleting a row or column.

####

Excel displays the error message __________ in cells not wide enough to display the entire entry.

Average

Excel has a function called the _____________ function that sums the numbers in a specified range and then divides the sum by the number of non-zero cells in the range.

Excel has more than 400 functions that perform just about any calculation.

Excel opens a new workbook with ____________ worksheets.

False

Excel remembers the last 500 actions you have completed.

Range Finder

Excel's __________ _____________ can be used to check which cells are being referenced in the formula assigned to the active cell.

Shortcut key for accessing Word Help from Word window

Function key __ accesses to Go To command in Excel.

(Excel) TRUE/FALSE: An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

FALSE

(Excel) TRUE/FALSE: As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations.

FALSE

(Excel) TRUE/FALSE: If you drag the fill handle to the left or up, Excel will increment the series rather than decrement the series.

FALSE

(Excel) TRUE/FALSE: The Increase Indent button indents the contents of a cell to the right by three spaces each time you click it.

FALSE

(Excel) TRUE/FALSE: The arithmetic operator, ^, directs Excel to perform the division operation.

FALSE

(Excel) TRUE/FALSE: To use the AutoCalculate area, select the range of cells containing the numbers for a calculation you want to verify and then press and hold or double-click the AutoCalculate area to display the Customize Status Bar shortcut menu.

FALSE

(Excel) TRUE/FALSE: When entering dollar values in cells, you also must type the dollar sign ($), commas, and any trailing zeros.

FALSE

(Excel) TRUE/FALSE: When you tap or click the Enter box to complete an entry in a cell, the active cell moves down to the next cell in the same column.

FALSE

(Excel) TRUE/FALSE: Worksheet titles and subtitles should be as wordy as possible.

FALSE

(Excel) TRUE/FALSE: You can turn off the Bold formatting for selected text by clicking the Roman button (Home tab | Font group).

FALSE

The function Hide will allow users to hide the column, but not row.

FALSE

A range name contain up to 450 characters and it must begin with a number.

False

An argument is an operator such as an equal sign or a plus sign needed to complete a function.

False

Because the Sum function is a rarely used function it has no button on the Ribbon.

False

Connections are automatically created in PowerPivot.

False

Excel 2013 automatically assigns a different pattern to each column of a clustered column chart.

False

Formatting data makes it difficult to read and tends to obscure meaningful details.

False

In Excel 2013, it is only possible to add a new worksheet when the workbook is created.

False

The Date number format only allows Long Date, for example, march 14, 2016.

False

The IF function only evaluates a condition of the condition is true.

False

To begin a formula in a cell, first type the # symbol.

False

Tab that contains Print command

File

Command used to close document without closing Word

File, Close

The _____ is the small black square located in the lower right corner of heavy border around the active cell

Fill handle

Tool on Home ribbon that lets user search for text by typing it in search box

Find

Appearance of letters

Font

Placeholder

Formatting text in a shape follows the same techniques as formatting text in a ____

Wrap Text

Formatting that enables a label to appear on multiple lines within the current cell.

Show the tracer arrows for the selected cell to display arrows to the cells containing formulas that reference the value or formula in the selected cell.

Formulas Tab - Formula Auditing - Trace Dependents

Hide the formulas in this worksheet and display the values instead.

Formulas Tab - Formula Auditing Group - Show Formulas

Which of the following is False about a function in Excel

Functions are organized into two categories in Excel.

=SUM(B1:B39)

Gabriel needs to create a shortcut formula in cell B40 to calculate total sales located in cells B1 through B39. Which function should he create?

The ___ command is helpful for navigating to a cell that is not visible onscreen

Go to

Column Charts

Graphic representation of data. Vertical charts display vertical bars going across the chart horizontally, with the values axis being displayed on the left side of the chart.

Indentation used for second and succeeding references in reference page

Hanging Indent

Printable text and graphics at top of each page

Header

Click Format in the Cells group o the __ tab to change the color of a worksheet tab.

Home

Cells D1:D6 have been cut. Insert them at the current worksheet location (cell C1).

Home - Insert- Insert Cut Cells

Unlock the selected cells so the user can edit the cells when the worksheet is protected.

Home Tab - Cells - Format (arrow) - Lock Cell

Create and apply a new conditional formatting rule to apply bold font formatting to only cells that are equal to or below the average for the selected range.

Home Tab - Style - Conditional Formatting - New Rule - Format only values above/below avg - Edit Rule Description: (drop-down) equal or below - Format: Bold - OK - OK

Cell reference and cell location are outlined in matching color

How is a cell reference in a formula and its corresponding location in a worksheet identified?

How many chart types does Excel offer?

Name Box

Identifies the address of the current cell.

MAX function

Identifies the highest value in a range.

MEDIAN function

Identifies the midpoint value in a set of values.

cell

Identifies where the column and the row meet??

If the following arithmetic operations all are found in a formula with no parentheses, which one is completed last?

False

If you drag the fill handle to the left or up, Excel will increment the series rather than decrement the series.

Goal Seeking

If you know the result you want a formula to produce, you can use __________ ________ to determine the value of a cell on which the formula depends.

File

If you wish to sign out of your Microsoft account, tap or click ____ on the ribbon to open the Backstage view and then tap or click the Account tab to display the Account gallery, and tap or click the Sign out link.

Import data from the text file StudentGPA into the selected cell in the current worksheet. Data in the file are delimited by commas, and the file does include a header row. Do not modify any of the column data formats.

Import External Data - Text - StudentGPA - Okay - Okay

Debugging

In Excel ____________ is the process of finding and correcting errors in a worksheet.

+ (The Plus Sign)

In Excel it means Add

Text

In Excel, any set of characters containing a letter, hyphen (as in a telephone number), or space is considered __________ and is left-aligned.

Copy

In Microsoft Excel, which feature makes an exact replica of the cell data and format while keeping the original cell intact?

* (The asterisk) (Shift the number 8 key)

In a Formula it means multiply

AutoFit

In a Microsoft Excel worksheet, how do you change the width of a column so that the widest entry will fit?

X axis

In a column/bar chart the horizontal axis is called the ____-_______ or category axis.

Y axis

In a column/bar chart the vertical axis is called the ____-_______ or value axis.

/ (The Forward slash)

In a formula in Excel it means divide

- (The minus sign)

In an Excel Formula, it means subtract

Pivot Table

In order to directly report the data, what must a PivotChart always be associated with?

Y Axis X Axis

In order to have a properly labeled column or pie chart with a proper title, legend and axis labels you must include the __________ and ____________ headings in the ranges selected.

In the formula =4 * 6 - 8, the subtraction operation (-) is completed before the multiplication operation (*).

Text

Includes letters, numbers, symbols, and spaces.

Relative Cell Reference

Indicates a cells location from the cell containing the formula; the cell reference changes when the formula is copied.

Ribbon that contains command to create headers

Insert

To begin creating sparklines on a worksheet, click the __ tab.

Insert

Add Column Sparklines to cells F2:F11 to represent the values in B2:E11.

Insert Tab - Sparklines Group - Column

Method for bringing up dialog box to put 20 rows and 4 columns

Insert Table

Enter a formula in cell B4 using the VLOOKUP function to find the meaning for the medical abbreviation listed in cell A4. Use the name Abbreviation for the lookup table. The item names are located in column 2 of the lookup table. Be sure to require an exact match.

Insert VLOOKUP - 2 in the VLOOKUP Col_index_num field text box - abbreviation in the VLOOKUP Table_array field text box - a4 in the VLOOKUP lookup_value field text box - false

Worksheet

Inside a workbook are ______________, each of which has a name.

Freeze

Jack would like the data in Row 1 to remain stationary on the screen while he scrolls. Which option should he select?

Hide

Jack would like the data in Row 10 not to display on his spreadsheet. Which option should he select?

NOT

James wants his spreadsheet to return true when the logical value is false. What function should he use?

COUNTIF

Jane wants to count the number of cells in a range in her spreadsheet. She would like to count only the cells in that range that contain 100. What function should she use?

Label

Jennifer needs to identify the values in column B for a statistics report. Which type of entry should she use in the column header?

Row

Joan has a table that includes demographic information about her employees. If the demographic information is listed across the top and employee names down the left side of the table, what does all the information about one employee represent?

Entry

Joan has entered her name in the First Name field in cell B2 of her table. What does her First Name represent in the table?

Label

Joan is creating a table that will include demographic information about her employees. What is each header in her table considered?

Format

John wants to add text effects to his PivotChart. Which PivotTable Chart Tools tab would he use?

Embedded Chart

John wants to be able to view his monthly sales chart as well as his data on the same worksheet. What type of chart should he create?

Labels

John wants to identify the exact value that each column in his chart represents. Which option should he choose?

Orientation

Kathryn needs the text in cell A1 to be angled at 90 degrees. Which alignment option should she select?

Merge and Center

Kathryn needs the title in cell A1 to align horizontally across cells A1 through D1. Which alignment option should she select?

Cell Style

Kenyon would like to apply the Title format to the data in Row 1 of a spreadsheet. Which formatting style should he select?

Share Workbook

Lilly is creating a spreadsheet for FBLA and would like all of the advisors at her school to be able to make changes to the spreadsheet at the same time. What command allows her to do this?

Edit Comment

Lilly is making changes to a spreadsheet her FBLA Advisor created. She would like to make a change to the comment she made in the spreadsheet. What option in the comments group should she choose?

Amount of vertical space between lines of text

Line Spacing

Format

Lisa has added WordArt to her spreadsheet. Which tab is now available for her to edit the WordArt?

VLOOKUP

Looks up a value in a vertical lookup table and returns a related result from the lookup table.

Shortcut of key to insert preformatted title page

Macro

Format

Making a change in the default settings

Shapes

Many of the shapes included in the ___ gallery can direct the viewer to important aspects of the presentation

Document that organizes all heading sections

Master Document

Tells Mail merge First is same as First Name

Match Fields

The __ function finds the midpoint value of a list.

Median

Type of document most appropriate to use for a new policy

Memo

Combines letters wrote with customer lists

Merge Documents

Field names linked to data source in mail merge document

Merge Fields

Buttons

Monitor dimensions and resolution affect how ___ display on the ribbon

Most professionals prefer the date format mm/dd/yyyy.

Office theme

New workbooks are formatted in Calibri 11 which is the default font for the __________ _________.

Type of template most appropriate for FBLA Secretary to inform FBLA members of monthly club activities

Newsletter

Contiguous cells

Next to each other

Non contiguous cells

Not next to each other

Themes

PowerPoint displays many _____ that are varied and appealing and give you an excellent start designing a presentation.

Predefined

PowerPoint provides a wide variety of ___ shapes that can add visual interest to a slide

Press CTRL+ENTER to start a new line in a cell.

Window that allows user to see document pages exactly as they will print

View to view document as hard copy

Print Layout

Area that provides list of available printers

Printer Status

Section of Backstage/Options to add word to Dictionary

Proofing

Sort

Putting data in order

PivotTables can be created from the __ gallery.

Quick Analysis

Which of the following is a new feature in Excel 2013?

Quick Analysis

: (The colon)

Range operator: Means inclusive; including all the cells. For example B3:B37 All the cells from B3, B4, B5, B6, B7 all the way until B37

Tool used to replace text in document

Replace

Control center located below title bar at top of Word window

Ribbon

Pressing the ___ key to complete an entry activates the adjacent cell to the right

Right Arrow

Modify the status bar so it displays the results of the MIN function for the selected cells.

Right Click Status Bar (at bottom)

Tab stop used to align page numbers to result in even right edge

Right Tab

Order of Precedence

Rules that control the sequence in which excel performs arithmetic operations.

Icon you select to use a template created by Office.com

Sample Template

Button used for storing new/existing file with same name

Save

Allows user to create new folder in desired storage location

Save As

Command used to save existing document with new file name or in new location

Save As

Action or command that cannot be undone in Word

Saving a document

Command on Insert Ribbon used to select part of program window to insert into file

Screen Clipping

Command on Insert Ribbon to insert picture of any open program

Screenshot

Command to e-mail entire program window

Screenshot

Add the Bonus field to the PivotTable.

Scroll down in Fields - Check Bonus checkbox

Method for changing Bullet symbol within list

Select list and choose down drop-down arrow

Command to draw a star

Shapes

Where do you insert an arrow

Shapes

The list of frequently used commands that appears when you right click an object

Shortcut Menu

Name Bar

Shows the active cell

Formula Bar

Shows the contents of the cell (and is where the cell is edited)

Which tool is best suited for use with PivotTables when the data is based on multiple tables?

Slicers

Command to create quick and easy visual representation

SmartArt

Fill

Solid___ is one color used throughout the entire slide

Which is the best tool for determining the optimal blend of products to produce in order to maximize profit?

Solver

____ has the ability to generate Answer Reports.

Solver

___is the best what-if analysis tool to solve complex linear and nonlinear problems

Solver

the analysis tool has the ability to handle multiple adjustable cells while minimizing, maximizing, or meeting goals.

Solver

Filter

Sorting for items by specific criteria

Add markers for all the data points in this Sparkline group.

Sparkline Tools Design Tab - Show Group - Markers Checkbox

Feature that reviews spelling and grammatical errors

Spelling and Grammar

Command to divide cells in top row of table into two separate cells

Split Cells

Excel

Spreadsheet

Which of the following calculations cannot be completed with subtotal?

Standard Deviation

Presents info about document, progress of tasks, status of commands/keys and controls for viewing document

Status

Option to add predefined formatting to table

Styles

When you open file on a heading

Subdocument

Makes text in smaller font size below text

Subscript

(Excel) TRUE/FALSE: A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet.

TRUE

(Excel) TRUE/FALSE: The AutoCorrect feature can automatically capitalize the first letter in the names of days.

TRUE

(Excel) TRUE/FALSE: The Microsoft Office Specialist (MOS) program provides an opportunity for you to obtain proof that you have the Excel 2013 skills required by employers.

TRUE

(Excel) TRUE/FALSE: The equal sign (=) precedes a formula.

TRUE

(Excel) TRUE/FALSE: The most common error when entering a formula is to reference the wrong cell in the formula.

TRUE

(Excel) TRUE/FALSE: To add a pie chart, first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button (INSERT tab | Charts group).

TRUE

(Excel) TRUE/FALSE: When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data.

TRUE

(Excel) TRUE/FALSE: You can clear cell contents and formatting by tapping or clicking Clear Contents on the Clear button menu.

TRUE

A ctrl key should be pressed if users want to select cells or a range of cells which are not adjacent.

TRUE

If users enter the functions correctly, the functions SUMIF and DSUM should return the same result.

TRUE

The PV function is usually used to calculate the ending balance of the loan in an amortization schedule.

TRUE

Typically, the function Autosum should not be used to find the total for a column containing data in percentage.

TRUE

Option to navigate across colums

Tab

Ribbon that contains commands to apply preset table styles

Table Tools Design Ribbon

Remove duplicate rows where data in all the columns are identical.

Table Tools Design Tab - Tools Group - Remove Duplicates - OK - OK

Gives reader overview of where to find content

Table of Contents

COUNTA function

Tallies the number of cells in a range that contain values.

File type you need to select when saving to protect you original letter

Template

What should you use to create a newsletter multiple times

Template

______ is/are used to place worksheet, column, and row titles on a worksheet.

Text

False

The AutoCorrect feature can automatically capitalize the first letter in the names of days

Accounting Style

The ________________ __________ format that displays a fixed dollar sign to the left of a number, inserts a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent (hundredths place).

Percent

The ________________ style button instructs Excel to display a value as a percentage, which is determined by multiplying the cell entry by 100, rounding the result, and adding a percent sign.

All of the above

The active cell can be identified by?

Paste Options Button

The advantage of copy and paste over other methods of copying or moving information is that following the paste in the destination you are given formatting choices using the ________ _______ _________.

False

The arithmetic operator, ^, directs excel to perform the division operation.

Fill Color

The background color appearing behind data in a cell.

=SUM(_ _)

The basic formula for most computations

Cell Address

The column and the row number of a cell ex: C13; F27

Floating

The currency style format assigns a ___________ dollar sign that appears immediately to the left of the first digit.

Data Service

The data that determines the size of the columns or slices in a pie are called the _______ ________.

8.43

The default column width is _______ characters.

The default row height is ________ points.

Options

The difference between the effects and the styles is that each effect has several ____ providing you with more control over the exact look of the image.

The easiest way to keep the cell reference C4 constant in a formula as it is copied to a destination area is to format it using the ______ key.

Category Names

The entries in the range that identify the major groups for the chart are called __________ _______.

True

The equal sign (=) precedes a formula

Gridlines

The horizontal and vertical lines on the worksheet itself are called ____________ and make it easier to see and identify each cell.

Column Width

The horizontal measurement of a column.

Two

The increase indent button indents the content of a cell to the right by _____ space each time you click it.

Cell

The intersection of a column and row.

Max

The largest number =MAX(C12:C45)

Logical Test

The leftmost entry in the general form of the IF function is the __________ _______ that is made up of two expressions and a comparison operator.

False

The legend identifies the slices of a pie chart or items on the vertical (y) axis of a column chart.

Minimum

The lowest number. =SUM()

True

The most common error when entering a formula is to reference the wrong cell in the formula.

True

The mouse pointer appears as a white block plus sign whenever it is located in a cell on the worksheet.

Median

The number in the middle. =MEDIAN()

Alignment

The position of data between the cell margins.

EXCEL: You use a(n) _______ to automate data analyses. a. data table b. formula checker c. amortization schedule d. IF function

a. data table

EXCEL: A pie chart with one or more slices offset is referred to as a(n) _______ pie chart. a. exploded b. outer c. offset d. rasterized

a. exploded

EXCEL: Combining two or more selected cells into one cell is called ______ cells. a. merging b. mixing c. combining d. spanning

a. merging

Form view

To create a split form select the table in the navigation pane tap or click create on the ribbon, tap or click the _______ button on the create tab to display a menu, and then tap or click Spilt Form on the menu.

To create a validation rule for the State field to restrict entries to TN or TX, enter ____ in the Validation Rule property box.

Update

To create an update query, create a new query and then tap or click the ______ button on the DESIGN tab.

No outline

To delete WordArt text outline, click ___ in the text outline gallery

Design

To delete a field from a table, open the table in ______ view, tap or click the the row selector for the field to be deleted, and then press the DELETE key.

To exit Access, click the ______ button on the right side of the Access title bar.

Totals

To include totals and other statistics at the bottom of a datasheet, click the ____ button on the Home tab to include the Total row in the datasheet.

Replace

To instruct PowerPoint to confirm each change, click the find next button in the____ dialog box

Absolute Cell Reference

To keep a cell reference constant when it copies a formula or function, Excel uses a technique called ____________ ______ _____________.

More Forms

To move from Layout view to Form view, tap or click the ______ button on the Access status bar.

Ascending

To order the records in the Client table by city in alphabetical order, use the _____ button.

Descending

To order the records in the Client table in reverse alphabetical order by City, click the ____ button.

To print the results with the query open, tap or click FILE on the Ribbon, tap or click the _________ tab in the Backstage view, and then tap or click Quick Print.

Format painter

To save time and avoid formatting errors, you can use the ___ to apply custom formatting to other places in your presentation quickly and easily.

Quick Access Toolbar

To save validation rules, default values, and formats, tap or click the Save button on the _____ to save the changes.

Required

To specify that a field is to be required, change the value for the ___________ property from No to Yes.

>=0 and <=30000

To specify that entries in the Returns field must be between $0.00 and $30,000.00, enter _________ in the Validation Rule property box.

ALT Enter

To start a new line in a cell, press ______ + _________ after each line

Run

To update record using an update query, enter the field to be update in the design grid, enter any necessary criterion, and then tap or click the ___________ button to update the records.

Selection

To use Filter by Selection to find all customers located in Greer, click the city field for any record where the city is Greer and then click the ______ button on the home tab.

To use Range Finder to verify that a formula contains the intended cell reference, double-click the cell containing the formula you want to check.

Character Filter

To use a common filter to find only those customers whose city begins with G, tap or click the arrow to the right of field name and point to the ______ command to display the custom text filters.

False

To use the AutoCalculate area, select the range of cells containing the numbers for a calculation you want to verify and then press and hold or double-click the AutoCalculate area to display the Customize Status Bar shortcut menu.

Query Type

To use the shortcut menu to create an update query, press and hold or right-click any open area in the upper pane, point to ______ on the shortcut menu, and then tap or click Update Query on submenu that appears.

EXCEL: The Increase Indent button indents the contents of a cell to the right by ______ spaces each time you click it. a. two b. three c. four d. five

a. two

EXCEL: An Excel _____ allows data to be summarized and charted easily. a. worksheet b. workflow c. document d. presentation

a. worksheet

EXCEL: How many chart types does Excel offer? a. 5 b. 10 c. 29 d. 50

b. 10

EXCEL: The ______ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry. a. AutoComplete b. AutoCorrect c. AutoFormat d. AutoTyping

b. AutoCorrect

EXCEL: What effect does the Accounting Number Format have on the selected cells? a. Converts alphabetic characters to numbers b. Displays cell contents with two decimal places that align vertically c. Performs tax calculations d. Copies the numbers of one cell to another

b. Displays cell contents with two decimal places that align vertically

Option selected in Columns dialog box to create multiple columns in only one paragraph

Apply to: drop-down list

False

As in algebra, you can use the brackets to override the order of operations Excel follows to perform calculations.

False

As you enter amounts, you must enter dollar signs, commas, and trailing zeros.

Formula bar

As you type, Excel displays the entry in the __________ _____.

Formula ___ displays a list of functions and defined name that match the letters that you start typing when creating a formula.

AutoComplete

Dialog box that provides user ability to replace text as it is typed

AutoCorrect

The _____ feature works behind the scenes, fixing common typing or spelling mistake when you complete a text entry

Autocorrect

Alexis is creating a table with numbers. She would like the numbers to be displayed as currency. Which tab stop should she use? A. Bar Tab B. Decimal Tab C. Left Tab D> Right Tab

Fills rectangle shape

Picture

Jordan inserted an image from his USB drive into his science report. What did he insert?

Picture

Which of the following is the best tool for analyzing employee performance over a period of time?

PivotTable

Which of the following is not true about PivotTables?

PivotTables cna Auto Refresh data

Appears at beginning of research paper

Title Page

Rotate

To __________ text in a cell you can use the Alignment Tab of the Format Cells dialog box.

True

To add a pie chart, first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button (INSERT tab | Charts group).

equal sign (=)

To alert Excel that you are entering a formula or function and not text, type a (n) ____________ preceding the formula.

Value

To change a query so that each item in a multivalued field occurs on a different row, use the ____ property

Lookup

To change the list of choices in a single or multivalued lookup field, open the in Design view, select the field to be modified, and tap or click the _______ tab in Field Properties pane.

Which of the following is best suited for comparing the effects of two variables on a formula?

Two-variable data table

Line Chart

A graphic representation of data, you use a line, and the points are called markers

Bar Chart

A graphical representation of data, a horizontal bar chart if for excel

Marquee

A moving border that surrounds a cell selected for a formula or group of cells selected for a function is called a __________.

False

A number can contain only the following characters: 1,2,3,4,5,6,7,8,9,0.

Values

A number that represents a quantity or an amount.

Contrast

A photos color intensity can be modified by changing the brightness and ____

Exploded

A pie chart with one or more slices offset is referred to as a(n) _____ pie chart

True

A pie chart with one or more slices offset is referred to as an exploded pie chart.

Equal Sign

A preceding _____ alerts Excel that you are entering a formula or function and not text

In-cell editing

A procedure called ___ _____ _______allows the contents of a cell to be edited directly in the cell by double-clicking the cell containing an error.

Output Area

A range of cells containing results based on manipulating the variables.

Input Area

A range of cells containing values for variables used in formulas.

Lookup Table

A range that contains data for the basis of the lookup and data to be retrieved.

Range

A rectangular group of cells

True

A requirements document includes a needs statement, a source of data, a summary of calculations, and any other special requirements for the worksheet

Chart-sheet

A separate sheet on which a chart resides is called a (n) __________ __________.

Row

A series of cells that are horizontal

Column

A series of cells that are vertical

Syntax

A set of rules that governs the structure and components for properly entering a function.

Now

A simple way to way to create a date stamp is to use the __________ function to enter the system date tracked the computer.

Fill Handle

A small green square at the bottom-right corner of a cell.

A specified condition for a cell can only be true or false.

Worksheet

A spreadsheet that contains formulas, functions, values, text, and visual aids.

Range Name

A word or string of characters that represents one or more cells.

Synonym

A word with a meaning similar to that of another word is called a ____

Sparkline

A(n) _____ chart provides a simple way to show to show trends and variations in a range of data within a single cell.

Amortization schedule

A(n) _____ shows the beginning and ending balances and the amount of payment that is applied to the principal and interest during each payment period.

Calculated

A(n) ______ field is a field that can be computed from other fields.

Append

A(n) ________ query adds a group of records from one table to the end of another table.

Clear

Alicia needs to delete the data in cell B5. Which command would she select?

Cut

Alicia needs to move the data in cell B5 to cell E5. Which command would she select?

True

An = sign alerts Excel that you are entering a formula or a function.

worksheet

An Excel _____ allows data to be summarized and charted easily.

An argument takes a value or values and performs an operation.

False

An asterick (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

True

An embedded chart is simply a chart on the same worksheet as the data.

An example of a relational operator is *.

Logical Test

An expression that evaluates to true of false.

Arguments

An input, such as a cell reference or value, needed to complete a function.

Sandra is creating a formula to subtract the values in cells B4 and C4. Which formula should she use? A. =B4+C4 B. =B4*C4 C. =B4/C4 D. =B4-C4

D. =B4-C4

Which group on the Formula Ribbon enables a user to specify when a formula is computed? A. Function Library B. Defined Names C. Formula Auditing D. Calculation

D. Calculation

What do you call it when you reference cells in other sheet in a workbook formula using the sheet name as the reference rather than the cell address? A. Calling the Sheet B. Name reference C. Sheet Name D. Worksheet Reference

D. Worksheet Reference

In Microsoft Excel, which feature makes an exact replica of the cell data and format while keeping the original cell intact? A. Paste B. Move C. Cut D. Copy

D. Copy

What is the process of using the mouse to move or copy cells called? A. Click and paste B. Drag and move C. Dragging D. Drag and Drop

D. Drag and Drop

Which tab do you use to display the area that contains the print command? A. Home B. Page Layout C. View D. File

D. File

Which command on the Fill options dialog box is the default option if you enter a month or day? A. Copy Cells B. Fill Formatting Only C. Fill without Formatting D. Fill Series

D. Fill series

Which dialog box contains the commands to specify an exact date and time format to use for a selected cell in a worksheet? A. Number B. Font C. Paragraph D. Format Cells

D. Format Cells

What feature was created for users who prefer to use the keyboard rather than the mouse, and provides keyboard code icons that may be used in conjunction with the ALT key? A. Quick Access Toolbar B. Hot Keys C. Mini Toolbar D. Key Tips

D. Key Tips

Which command on the Home Ribbon joins selected into one and centers that content into larger single cell? A. Wrap Text B. Group Cells C. Cell Styles D. Merge & Center

D. Merge & Center

When copying values in Microsoft Excel, which feature automatically adjusts cell reference for the new copy location? A. Absolute Reference B. Certain Reference C. Variable Reference D. Relative reference

D. Relative reference

Sharon's spreadsheet contains information about the number of music downloads in F25. "25" identifies the: A. Cell B. Column C. Range D. Row

D. Row

Larkeysha has created a spreadsheet containing student grades. Which function would she use to return the current date in cell A1? A. COUNT B. IF C. NOW D. TODAY

D. TODAY

Which is a special workbook a user can create and then use as a pattern to create new, similar workbooks or worksheets? A. Form B. Boilerplate C. Smart Sheet D. Template

D. Template

Column D in a spreadsheet contains employee ID number. Which formatting would be most appropriate for the date in column D? A. Currency B. Date C. Number D. Text

D. Text

Fill

WordArt ___ in the interior of a letter can sons its of a solid color, texture, picture, or gradient.

Circular Reference

Occurs when a formula directly or indirectly refers to itself.

The ___ view displays print options and displays a worksheet in print preview

Office Backstage

The 2016 data point in the Gross Profit data series has been selected. Change the outline width to 2 1/4 pt.

On the Chart Tools Format tab, Shape Styles group, click the Shape Outline button, point to Weight, and select 2 1/4 pt.

The Anne Cole data point has been selected for you. Rotate the pie chart exactly 200° so this data point appears at the left side of the chart near the legend.

On the Chart Tools Format tab, in the Current Selection group, click the Format Selection button to open the Format Data Point task pane. In the Angle of first slice box, type the 200 and press Enter.

Use Goal Seek to find the value for cell D12 that will result in a value of $650,000 for cell B15. Accept the solution.

On the Data tab, in the Data Tools group, click the What-If Analysis button, and click Goal Seek... Enter 650000 in the To value box. Enter D12 in the By changing cell box. Click OK. Click OK.

Manually create groups of rows that can be expanded or collapsed as needed. Start with the group of selected cells.

On the Data tab, in the Outline group, click the Group button. In the Group dialog, Rows is selected by default. Click OK

Font Size Drop Down List

On the Home Ribbon, what is used to change the font size of characters in a cell?

Modify the number format so no decimal places are visible after the decimal point.

On the Home tab, in the Number group, click the Decrease Decimal button twice.

Convert the table to a normal range.

On the Table Tools Design tab, in the Tools group, click the Convert to Range button. Click Yes.

Graphical elements

One method of getting the audiences attention and reinforcing the major concepts being presented is to have____ on the title slide

Formula

One reason Excel is such a valuable tool is that if you enter a ___________ to multiply values, Excel recalculates the product whenever new values are entered.

A(n) ___ is a structured range that contains different values for one variable to compare how these values affect one or more calculated results.

One-variable data table

Term that refers to the two page layout positions

Orientation

Command that allows document to be viewed as if it were a multilayered outline

Outline

Places box around entire document

Page Border

Automatically inserted when determined text has filled one complete page allowed

Page Break

Ribbon containing command to change preset margin settings

Page Layout

Switch to the view that shows all the worksheet elements as they will print, including headers and footers.

Page Layout mini button by Zoom Slider

Group on Home ribbon that contains commands to control text alignment

Paragraph

Amount of space between paragraphs

Paragraph spacing

The Currency style format cannot be used with a floating dollar sign.

True

The Increase Indent Button indents the contents of a cell to the right by three spaces each time you click it

True

The Microsoft Office Specialist (MOS) program provides an opportunity for you to obtain proof that you have the Excel 2013 skills required by employers.

Outline

The WordArt ____ is the exterior border surrounding each letter or symbol

Max

The ___ function display the highest value in a range

Title slide

The ___ introduces the presentation to the audience

AutoCalculate

The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu

Find and replace

The ____ feature automatically locates specific text and then replaces it with desired text.

The _____ function is useful when you want to assign a value to a cell based on a logical test.

The _____ function is useful when you want to assign a value to a cell based on logical test.

Sum function

The _______ __________ in the Editing Group of the Home Ribbon can be used to enter a function that adds the numbers in a range of cells.

Legend

The _______ identifies the columns, bars or slices of a chart by assigning a color to each.

Fill handle

The ________ ________ is the small green square located in the lower right hand corner of the active cell.

Name

The _________ box displays the active cell reference.

Auto fill option

The ____________ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting

Auto fill options

The ____________ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting, without formatting, or copy only the format.

Accounting number

The ____________ format causes the cells to display with a fixed dollar sign, commas, and two decimal places so that decimal places in cells below align vertically.

MIN

The ____________ function is used to determine the lowest number in a given range.

Autocorrect

The _______________ feature of Excel works behind the scenes, correcting common mistakes when a text entry is completed in a cell.

Average

The sum of all the numbers divided by the amount of numbers. =AVERAGE()

Arrangements

The values used with a function are called ______________.

Row Height

The vertical measurement of a row.

How user modifies colors in theme

Theme Colors command on Page Layout

Lower

Tom wants to convert all text to lowercase. Which function should he use?

Valid placement options for page numbers

Top of page or Bottom of page

A Special number format allows characters such as hyphens.

True

Axes, chart tittles, and data tables are examples of chart elements.

True

Comma, Date, Time, and Fraction are all number formats available in Excel 2013.

True

Excel automatically determines the starting, incremental, and stopping values on a chart based on the data selected.

True

Excel data can be copied and pasted into a Word or PowerPoint document.

True

In Excel 2013, the function name describes the purpose of the function.

True

Label filters such as "Does Not Equal" can be applied to a PivotTable.

True

Multiple filters can be applied to a PivotTable.

True

Text in a cell can by angle clockwise

True

When you hide a column or row, the data is not deleted, it is just hidden.

True

Name box

When working with a large worksheet it is faster to enter the cell reference in the ______ ____, then to scroll to it.

Split

When working with a large worksheet, you can ________ the Excel window into two or four panes to view different parts of the worksheet at the same time.

The column references change in the formula

When you copy a formula with relative cell references left to right down a row, ____________.

List of sources used

Works Cited Page

False

Worksheet title and subtitles should be as wordy as possible

Command on Picture Tools Format used to change way text wraps

Wrap Text

Command to put pictures behind text

Wrap Text

20xx

When you enter a two digit year that is less than 30, XL changes the year to

Cell Reference

When you set up a worksheet you should use ______ ___________ in formulas whenever possible, rather than constant values.

False

When you tap or click the Enter box to complete an entry in a cell, the active cell moves down to the next cell in the same column

Home Ribbon

Where is the command to apply a fill color to a cell or range of cells in a worksheet?

Which of the following is NOT one of most commonly used chart types?

X Y chart

Format

You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand?

Quick Access Toolbar

Which Microsoft Office object would you use for quick, convenient, one-click access to frequently used Excel commands?

Name Box

Which area on the left side of the formula bar indicates the cell address of a selected cell?

Which command among the window control buttons is used to close an open file and completely exit the Microsoft Excel program?

Save As

Which command enables a user to save an existing worksheet with a new name or save the worksheet in a new location?

Decrease Indent

Which command is used to reduce the margin between the border and the text in an indented cell?

Select Remove Page Break from the Breaks drop down area

Which command is used to remove manual page breaks from a worksheet area?

Find and Select

Which command on the Home Ribbon do you use to replace information in a selected cell with new information or new formatting?

Sort and Filter

Which command on the Home Ribbon do you use to temporarily hide specific values on a worksheet based on a criterion?

Merge and Center

Which command on the Home Ribbon joins selected cells into one and centers that content into a larger single cell?

Rotate

Which command on the Page Layout Ribbon enables a user to flip objects on a worksheet?

enter/down arrow

Which key makes you go down one cell??

shift tab/left arrow

Which key makes you go one cell to the left??

tab/right arrow

Which key makes you go one cell to the right??

Ctrl Home

Which key makes you go to call A1??

shift enter/up arrow

Which key makes you go up one cell??

Lists

Which of the following is not a major part of Excel?

None of the above

Which of the following is true when working with percentages in Excel ________?

Home

Which of the following keys moves the insertion point to the beginning of data in a cell?

Worksheet

Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel?

Accounting

Which quick-number style button formats numbers to display as currency in the worksheet?

Page Layout

Which ribbon contains the command to apply a theme to a worksheet in Microsoft Excel?

Microsoft Excel

Which software program is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data?

File

Which tab is used to display the area that contains the print command?

Normal

Which view is the default view used in Microsoft Excel?

Document Properties

Which would be used to help organize and identify Microsoft Excel files by providing details about the files?

Someone is creating a custom template. If they use the tools found on the Review tab and proofreads her document, which important question are they answering?

Will the template have correct spelling, grammar and punctuation?

Insert

With a range selected, to initiate drawing a chart click the __________ main tab.

Full-featured word processing program that allows users to create professional-looking documents and revise them easily

Word

Command used to find number of word

Word Count

Type of drawing object enables users to create shadowed, rotated, stretched and wavy text effects

WordArt

EXCEL: What effect does the Comma Style format have on the selected cells? a. Converts decimals to commas within a cell b. Coverts decimals to commas within merged cells c. Displays cell contents with two decimal places and commas as thousands separators d. Allows for substitution of selected characters

c. Displays cell contents with two decimal places and commas as thousands separators

EXCEL: Clicking the _______ box completes an entry. a. Cancel b. Formula c. Enter d. Tab

c. Enter

EXCEL: The _____ function displays the highest value in a range. a. MIN b. SUM c. MAX d. AVERAGE

c. MAX

EXCEL: In Excel, a number can contain the characters _______. a. 0 1 2 3 4 5 6 7 8 9 b. + - ( ) , / c. . $ % E e d. all of the above

d. all of the above

EXCEL: To enter data in a cell, you must first select the _____. a. row b. worksheet c. column d. cell

d. cell

EXCEL: The _______ preceding a formula alerts Excel that you are entering a formula or function and not text. a. quotation mark (") b. colon (:) c. plus (+) d. equal sign (=)

d. equal sign (=)

A(n) __ is a grid that contains the data source values and labels.

data table

The IF function:

evaluates a condition and returns one value if the condition is true, a different if false.

MISY 5325 Excel Midterm Ultimate Review

संबंधित स्टडी सेट्स

Chem Ch. 12

Important cities in France

308 final

(Chapter 24) South and Southeast Asia after 1200

Current Liabilities and Contingencies

week 11 part 2 chapter 19

Auto-evaluation Check-in 8.1

Marketing Chapter 14: Engaging Customers and Communicating Customer Value

micro final exam

Both/And and Either/Or Approaches

BIO chapter 9

Accounting 001 - Study questions chapters 11-14

Los avances tecnológicos

Pediatrics EORE

Chapter 19

Module 4 NCLEX study questions

Simple/compound interest and present/future value

Electrochemistry and Nuclear Chemistry

GI 2-MI

Educational Psychology Exam 1 (Chapters 1-3)