EXCEL MIDTERM Beta

¡Supera tus tareas y exámenes ahora con Quizwiz!

Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create?

+$B$1+25

Correct file format of normal Word template

.dotx

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

Sandra is creating a formula to subtract the values in cells B4 and C$. Which formula should she use?

=B4-C4

Wendy has created a spreadsheet to keep track of company sales. Sales for the East region are located in cells D1 through D13. Which function would she use to find the highest sales for the East region?

=MAX(D1:D13)

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?

=SUM(B1:B39)

Wendy has created a spreadsheet to keep track of company sales. Sales for the East region are located in cells D1 through D13. Which function would she use to calculate total sales for the East region?

=SUM(D1:D13)

Pie Charts

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

Relative

A ____ reference is an adjusted cell reference in a copied and pasted formula.

Cell

A box that you can enter data

Formula

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

Workbook

A file containing related worksheets.

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

Values

A number that represents a quantity or an amount.

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

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.

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.

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

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?

AVERAGE

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

Accounting

+SUM(A12+A13)

Adding two cells

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

Address Block

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?

worksheet

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

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.

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

Apply to: drop-down list

What command will arrange Microsoft Excel windows so that they appear side by side on the screen?

Arrange all

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

AutoCorrect

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?

AutoFill

Carl notices that the data in cell E4 reads ######. What command could Carl choose to correct this problem?

AutoFit

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

AutoFit

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

Sandra is creating a formula to multiply the values in cells B4 and C4. Which formula should she use?

B4*C4

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

Trey would like to outline the cell range A1:F20. Which formatting style should he select?

Borders

Which command on the Page Layout Ribbon enables a user to mark where a new page will begin on the printed copy?

Breaks

enter

By clicking the _____ box completes an entry

Left aligned

By default text is ____ in a cell

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

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

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

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.

Which group on the Formulas Ribbon enables a user to specify when a formula is computed?

Calculation

Text placed below object

Caption

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

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

Cell Style

Which command do you use to format a cell or selected cells quickly by choosing from a defined list of styles?

Cell Style

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

Cell reference and cell location are outlined in matching colors

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

On which short-cut menu can a user hide a row or column fro view without permanently deleted the information?

Choose the Hide command on the Shortcut menu

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

Clear

How to access Word Help from Word Window

Click Word Help button in upper right of window

How would you move sheet tabs to a new position in the worksheet?

Click and drag the sheet tab to the new location

How do users switch from one ribbon to another?

Click the tab of the ribbon they wish to access

Reviews headings in Outline view

Collapse

######

Column is not wide enough

AutoFill

Completes previously typed words when you begin to repeat the typing

Which of the following is made up of two relational operator, and is true or false for each cell in the range?

Condition

What type of formatting appears only when the value in a cell meets conditions specified by a user?

Conditional

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

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

Copy

What method is the MOST EFFICIENT way to copy five separate formulas to adjacent cells simultaneously?

Copy using the Fill Handle

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

Joan wants to format the cells in her spreadsheet. What is the shortcut that will open the format dialog box?

Ctrl+1

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?

Ctrl+End

Column D in a spreadsheet contains information about regional sales. Which formatting would be most appropriate for the data in column D?

Currency

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

Cut

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

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

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

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

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?

Which command do you use to reduce the margin between the border and the text in an indented cell?

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?

Defined Names

John would like to remove a worksheet from his workbook. Which option would he choose?

Delete

Which command on the Home Ribbon do you use to remove cells, rows, or columns, from a worksheet or table?

Delete

Makes one section less important in Outline view

Demote

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

To help organize and identify Microsoft Excel files by providing details about the files, which of the following would you use?

Document properties

What is the process of using the mouse to move or copy cells called?

Drag and drop

Capital letter that is much bigger then the rest of text

Drop Cap

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

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?

Entry

#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.

Which of the following software programs in a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data?

Excel 2010

100

Excel remembers the last ____ actions you have colmpeted

Which command do you use to close an open file and completely exit the Microsoft Excel program?

Exit

Shortcut key for accessing Word Help from Word window

F1

Tab that contains Print command

File

Which tab do you use to display the area that contains the print command?

File

What area contains the command used to print a worksheet in Microsoft Excel?

File Tab

Command used to close document without closing Word

File, Close

What command do you use to apply a background color to cells in a worksheet?

Fill Color

Which command on the Fill options dialog box is the default option?

Fill Series

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?

Fill handle

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

Find

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

Find & Select

David wants to change all occurrences of "North Carolina" to "NC" in his spreadsheet. What command should he use to complete this task?

Find and Replace

Appearance of letters

Font

Which defines the appearance and shape of the letters, numbers, and special characters in Microsoft Excel?

Font

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

Font Color

On the Home Ribbon, what do you use to change the text color of characters in a cell?

Font Color drop-down list

On the Home Ribbon, what do you use to change the font size of characters in a cell?

Font Size drop-down list

Which command on the Home Ribbon do you use to format row height and column width, organize sheets, and protect or hide cells in a worksheet?

Format

Which dialog box contains the commands to specify an exact date and time format to use for a selected cell in a worksheet?

Format Cells

Which dialog box in Microsoft Excel do you use to set the rotation of text in a cell to specific degree?

Format Cells

Keyon would like to convert the cell range A1:F20 to a Medium 19 style. Which formatting style should he select?

Format as Table

In Microsoft Excel, what do you use to emphasize certain entries and male the worksheet easier to read and understand?

Formatting

Wrap Text

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

Where can you find the Insert Function button in Microsoft Excel?

Formula bar

Jennifer is calculating her GPA. If she uses "=A1+A2+A3+A4)/4", this is an example of which type of entry?

Formulas

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

Freeze

Joan wants to be able to view row 1 as well as column A while scrolling through her worksheet. Which option should she choose?

Freeze

John's spreadsheet includes multiple pages of records. If John wants to view his headings while scrolling through his spreadsheet what should he do?

Freeze Panes

What feature of Microsoft Excel keeps a portion of a worksheet visible while the other portion scrolls?

Freeze Panes

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?

Function

Which command group on the Formulas Ribbon allows a user to choose from various categories of functions to use in a worksheet?

Function Library

=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?

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

What command do you use to insert information into a worksheet that will dispaly at the top and bottom edges of the printed page?

Header and Footer

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

Hide

Joan is showing her spreadsheet to a customer and does not want the customer to be able to see the wholesale price column. What option should she choose?

Hide

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

Home Ribbon

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?

Hot Keys

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?

Which command on the Insert Ribbon creates a link to a web page, picture, email address, or program in a worksheet?

Hyperlink

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??

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 that account tab to display the account gallery, and then tap or click sign out

+ (The Plus Sign)

In Excel it means Add

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?

/ (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?

Text

Includes letters, numbers, symbols, and spaces.

Absolute Cell Reference

Indicates a cell's specific location; the cell reference does not change when you copy the formula

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

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

Insert Table

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?

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

Label

Which ribbon option opens a related dialog box?

Launcher

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.

Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to find the highest test grade?

MAX

Shortcut of key to insert preformatted title page

Macro

Which term describes the blank portion of a page that fall outside the main body of the printed document?

Margins

Document that organizes all heading sections

Master Document

Tells Mail merge First is same as First Name

Match Fields

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

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

Merge and Center

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

Merge and Center

John would like to change the order of the worksheets in his workbook. Which option would he choose?

Mive

Virgil needs to transfer a worksheet in the current workbook to a different workbook. Which command should he choose?

Move

Larkeysha has created a spreadsheet containing student grades. Which function would she use to return the current date and time in cell A1?

NOW

Which area, on the left side of the formula bar, can you look at to determine the cell address of a selected cell?

Name box

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

Newsletter

Contiguous cells

Next to each other

Which view is the default view used in Microsoft Excel?

Normal

Non contiguous cells

Not next to each other

Circular Reference

Occurs when a formula directly or indirectly refers to itself.

Font Size Drop Down List

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

Joyce needs to access a spreadsheet she saved yesterday. Which command would she select?

Open

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

Orientation

Term that refers to the two page layout positions

Orientation

Which command on the Home Ribbon do you use to rotate text to a vertical or diagonal?

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

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

Page Layout

Group on Home ribbon that contains commands to control text alignment

Paragraph

Amount of space between paragraphs

Paragraph spacing

Fills rectangle shape

Picture

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

Picture

right arrow

Pressing the ____ key to complete an entry activates the adjacent cell to the right.

CTRL+HOME

Pressing the ____ keyboard shortcut key(s) selects cell A1.

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

Print

John wants to print only the Inventory worksheet that he is currently working on in his workbook. Which option should he choose?

Print Active Sheet

Jim would like to print only the cell range A1:F20. What page setup option should he change?

Print Area

View to view document as hard copy

Print Layout

Which view enables a user to create or modify a worksheet while seeing how it will look in printed format?

Print Preview

John has highlighted the data he would like to print. Which print option should he choose?

Print Selection

Jim would like the data in Row 1 of his spreadsheet to repeat on every page of his printout. What page setup option should he change?

Print Titles

John's workbook includes 3 workbooks. Which option should he choose to print them?

Print entire workbook

Area that provides list of available printers

Printer Status

Section of Backstage/Options to add word to Dictionary

Proofing

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

Quick Access Toolbar

Sharon's spreadsheet contains information about the number of music downloads in F1:F25. F1:F25 represents a:

Range

: (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

Virgil wants to customize the sheet tabs in his workbook with the names June, July, and August. Which command should he choose?

Rename

Tool used to replace text in document

Replace

Control center located below title bar at top of Word window

Ribbon

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

Right Tab

How is is an exact copy of a worksheet created within the same workbook?

Right-click the sheet tab, then choose Move or Copy from the Shortcut menu

Joan has a table that includes demographic information about her employees. What does all the information about one employee represent?

Row

Sharon's spreadsheet contains information about the number of music downloads in F25. "25"" identifies the:

Row

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

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

Save as

Action or command that cannot be undone in Word

Saving a document

Jack, would like to force the data in his spreadsheet to fit on one page when printed. Which option should he select?

Scale

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

Which command do you use to remove manual page breaks from a worksheet area?

Select Remove Page Break from the Breaks drop-down area

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

Which command group in the Page Layout Ribbon controls the presence of gridlines and headings on a worksheet?

Sheet Options.

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

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?

Shortcut Menu

Which group on the View Ribbon enables a user to show or hide the ruler, gridlines, Formula Bar, or headings?

Show

Name Bar

Shows the active cell

Command to create quick and easy visual representation

SmartArt

Feature that reviews spelling and grammatical errors

Spelling and Grammar

John wants to be able to view multiple areas of his spreadsheet at the same time. What would be his best option?

Split

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

Split Cells

Excel

Spreadsheet

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

Status

What is a single character, word, phrase, in a cell on worksheet that is typically used in searches?

String

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

Larkeysha has created a spreadsheet containing student grades. Which function would she use to return the current data in cell A1?

TODAY

Option to navigate across colums

Tab

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

Tab Color

Ribbon that contains commands to apply preset table styles

Table Tools Design Ribbon

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

Which is a special workbook a user can create and then use a pattern to create new, similar workbooks or worksheets?

Template

Column D in a spreadsheet contains employee ID Number. Which formatting would be most appropriate for the data in column D?

Text

Auto calculate

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.

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.

undo

The ____ button allows you to erase recent cell entries.

Auto correct

The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.

insertion point

The ____ is a blinking vertical line that indicates where the next typed character will appear.

fill handle

The ____ is the small black square located in the lowerright corner of the heavy border around the active cell.

Equal Sign (=)

The ____ preceding a formula alerts Excel that you are entering a formula or function and not text.

Fill Color

The background color appearing behind data in a cell.

=SUM(_ _)

The basic formula for most computations

What occurs when the cursor is moved over a cell and a user clicks?

The cell is selected

Cell Address

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

Automatically Updated

The date you change a file is an example of a(n) ____ property.

understand what is required

The first step in creating an effective worksheet is to make sure you ____.

Column Width

The horizontal measurement of a column.

Max

The largest number =MAX(C12:C45)

Minimum

The lowest number. =SUM()

Median

The number in the middle. =MEDIAN()

Requirments

The person or persons requesting the worksheet should supply their requirements in a ____ document.

Alignment

The position of data between the cell margins.

Paste

The range of cells receiving copied content is called the ____ area.

Destination area

The range of cells receiving the content of copied cells is called the

Average

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

Row Height

The vertical measurement of a row.

Which set of formatting choices includes a set of colors, fonts, and effects that you can apply to a worksheet to enhance its appearance?

Theme

How user modifies colors in theme

Theme Colors command on Page Layout

Appears at beginning of research paper

Title Page

ESC

To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key.

Which function do you use to insert today's date in a worksheet so that it automatically updates each time the worksheet is opened?

Today

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

Command to cancel recent action

Undo

John notices that column D is not showing in his spreadsheet. What action does he need to take to view column D?

Unhide

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?

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

What effect does the Comma Style format have on the selected cells?

Displays cell contents with two decimal places that align vertically

What effect does theAccounting Number 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?

workbook

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

Fields

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

Backspace Key

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

Home Ribbon

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

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?

Close

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??

(HOME tab/ Styles Group)

Which of the following is the Ribbon path to the Cell Styles button?

Home

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

end

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

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?

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

Which of the following notebook- like features organizes the sheets for use in Excel?

Workbook

List of sources used

Works Cited Page

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

Worksheet

What do you call it when you reference cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address?

Worksheet Reference

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?

Wrap Text

Command on Picture Tools Format used to change way text wraps

Wrap Text

Command to put pictures behind text

Wrap Text

format

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

#div/0

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

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

Zoom

What command do you use to increase or decrease the view of a selected cell or range of cells to fill the Excel Window are for better visibility?

Zoom to selection

standard

____ Properties are associated with all Microsoft Office files and include author, title, and subject

text

____ is/are used to place worksheet, column, and row tiles on a worksheet

merging

combining two or more selected cells into one cell called ____ cells

10

how many charts does Microsoft offer

all the above

in excel a number can contain the characters

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

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?

labels

CTRL+A

press ___ to select the entire work sheet

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

CTRL+B

you can apply the bold font by pressing _______

Colon (:)

you can enter the correct range in a function by typing the beginning and ending cell references separated by a

XPS Viewer

you can use a _____ to view an XPS file


Conjuntos de estudio relacionados

PrepU 24: Asepsis and Infection Control

View Set

HLTH 1100 | HILLMAN | CHAPTER 1 QUIZ

View Set

Medical Office Term I (Mid-Term Exam Study Guide)

View Set

Practice Questions 3 (Study.com Chapters 21-28)

View Set

BUSI 1301 - BUSINESS PRINCIPALS - UNIT 3 MASTERY ASSESSMENT

View Set

Quadrilateral Questions (Yes/No)

View Set