EXCEL MIDTERM Beta
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
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