Microsoft Word 2: Fundamentals, Word Fundamentals, Word II: Fundamentals, Microsoft Word Skills, Introduction to Business Computer Applications Testing Exam Part II, Introduction to Business Computer Applications Testing Exam Part I, Microsoft Office...

Ace your homework & exams now with Quizwiz!

Link

A connection between the files that allows data to be transferred from one file to the other.

Range

A group of worksheet cells, which can be adjacent or nonadjacent. (AKA a cell range)

Cell range

A group of worksheet cells, which can be adjacent or nonadjacent. (Example - A2:G19)

Style Sheet

A guide to ensure consistence throughout a document

Glitch

A hardware problem that causes a computer o malfunction or crash is called___

top of the page

A header is located at the ____

Personal Macro Workbook

A hidden workbook named Personal. xlsb that opens

row

A horizontal arrangement of cells, organised by number

Data bar

A horizontal bar added to the background of a cell whose length reflects the cell's value.

Hyperlink

A is a clickable text or an image that allows you to move from one Web site to another or move to different places within the same Web site.

Shortcut Key

A key combination that chooses a menu option without the need to display a menu is called a ___

Input Devices

A keyboard, mouse, and an Internet video camera are considered forms of ___

Hyperlink

A link in a file, such as a workbook, to information within that file or another file that, when clicked, switches to the file referenced by the hyperlink.

Bibliography

A list of sources used for in-text citations that usually appears at the end of the document.

Works Cited page

A list of sources used for in-text citations that usually appears at the end of the document.

Point

A location in space.

point

A location in space.

IF function

A logical function that returns one value if the statement is true and returns a different value if the statement is false.

Odessey

A long trip

Fop

A male who is too concerned about his looks and clothes

Formula

A mathematical expression that calculates a value; all Excel formulas always begin with an equal sign (=) followed by an expression that describes the calculation to be done.

Formula

A mathematical function that contains cell addresses and mathematical operators

Operator

A mathematical symbol that you use to combine values and then return a single value.

Double spaced

A memorandum should be ___

Error alert

A message that appears if a user tries to enter a value in the cell that does

Editing mode

A mode in which you can edit part of an entry rather than the entire contents of a cell.

Developmental Phases of Writing (5)

1. Role Play Writing 2. Experimental Writing 3. Early Writing 4. Conventional Writing 5. Proficient Writing

Developmental Processes in Writing (3)

1. The Natural Order of Acquisition 2. Interlanguage Development 3. The Monitor

Replace

A command that enables users to replace one word or phrase with another.

Paste

A command that pastes text from the Clipboard to a new location in the original document or new document.

Screen Tip

A note that appears on the screen to provide information about a button, tracked change, or comment, or to display footnote or endnote. Also displays the text that will appear if you choose to insert a date or AutoText entry.

Value

A number entered into a spreadsheet cell that will be used for calculations

Number data

A numerical value that can be used in a mathematical calculation.

Manual page break

A page break that you insert anywhere on a page.

Exploded pie chart

A pie chart with one slice moved away from the pie as if someone were taking the piece out of the pie.

Virus

A piece of code that is capable of copying itself and typically has a detrimental effect, such as corrupting the system or destroying data

Virus

A piece of computer code designed as a prank or malicious act

Function

A predefined formula that performs calculations using specific values called arguments.

Bloatware

A program that used an excessive amount of disk space

Plot area

A rectangular area containing a graphical representation of the values in the data series.

Cell Range

A rectangular group of adjacent cells

Cursor

A representation on the screen of the mouse pointer location

Total row

A row at the end of an Excel table that is used to calculate summary statistics for the columns in the table.

Status Bar

A row of information related to the current program. It is usually located at the bottom of a window. Not all windows will have one.

Printed page

A ruler, often located on the side of a document, shows that document in relation to ___

Style

A saved collection of formatting options - number formats, text alignment, font size and colors, borders, and background fills - that can be applied to cells in a worksheet.

Chart Sheet

A separate sheet in a workbook that stores a chart.

Macro

A series of stored commands that can be run whenever you need to perform that task.

font

A set of characters that have the same design.

Conditional format

A setting that applies formatting only when a cell's value meets a specified condition.

Locked property

A setting that determines whether changes can be made to a cell.

Workbook protection

A setting that limits users' ability to make changes to the

Worksheet protection

A setting that limits users' ability to modify the worksheet's contents, structure, or formatting.

Adjacent range

A single rectangular block that includes a group of contiguous cells.

Fill handle

A small black square in the lower-right corner of a selected cell or cell range that you drag to copy the contents of the selected cells to adjacent cells.

Thumbnail

A small representation of an item, such as an image, a page of content, or a set of formatting, obtained by scaling a snapshot of it. They are typically used to provide visual identifiers for related items.

Port

A socket on a computer into which an external device can be plugged in

Resizing handle

A square or dot on a selection box that lets you change and object's width and height.

Validation rule

A statement that defines criteria for the data that can be stored in a cell or range.

Network

A system of interconnected computers

Default template

A template that creates the blank Book1 workbook that opens when you start Excel, The default template contains no text or formulas, but it includes all the formatting available in every new workbook

Relative Reference

An adjustable/changeable cell reference

Digital signature

An electronic version of a signature that provides a way to authenticate a workbook; also called a digital certificate.

Hex (n)

An evil sprit

Abstract

An executive summary

Column Chart

An image used to compare different groups of data to each other through the use of vertical columns of different lengths

A chip

An integrated circuit used in computers

PivotTable

An interactive table that enables you to group and summarize either a range of data or an Excel table into a concise, tabular format for easier reporting and analysis.

Folder

An object that is used for organizing documents and applications is called a ___

Worksheet

An on-screen spreadsheet is called a ___

5) A __________ is an instruction based on the action that you give to Word by clicking a button or entering information in a dialog box.

Answer: command

22) You must ___ a PDF before you can edit it in Word.

Answer: convert

21) Use this button on the Home tab line up text flush on both the left and right margins, adding extra space between words as necessary for clean look.

Answer: d

2) A ___ is the same as a type face that applies a style to characters.

Answer: font

14) In order to quickly apply color across the selected text area, use the ___ tool in the Font group.

Answer: highlight

3) The blinking __________ in the upper-left corner of a new document is where you begin entering text.

Answer: insertion point

5) Use ___ as you point to each font to see what it will look like before you make a final decision.

Answer: live preview

8) You will click on the drop-down __________ to choose from a list of options associated with that command.

Answer: menu

12) When you select text and press Ctrl + U, a ___ line appears below the selected text.

Answer: single

text

Any set of characters containing letters, hyphens, or spaces

Formula Bar

Appears directly below the toolbar in the worksheet; displays a formula when the cell of a worksheet contains a calculated value.

active cell

Area in which you can enter data, surrounded by a heavy border

Where should the Works Cited page be in your document?

At the end of the document, on a separate page.

Composing

Prewriting - Choose a subject - Identify audience - Decide on purpose/thesis Generating Material - Narrow the topic - Collect ideas from personal experience, observation, interviews, research - Generate details (brainstorm, cluster, outline, list, tree, flow chart) - Select most pertinent ideas and facts

What term describes the process of repairing and removing wasted space from a database? Recovery Backing up Installation Compacting

Compacting

Radar Chart

Compares a collection of values through several data sets.

Surface Chart

Compares three sets of values in a 3-D chart.

Area Chart

Compares values from different categories. Similar to a line chart except the areas under the line contain a fill color.

Which type of operator enables a user to compare two values in a query criterion? Assessment Evaluation Comparison Appraisal

Comparison

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

Conditional

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

Conditional formatting

Criteria filter

Conditions you specify for a filter.

Numbers, text, dates, or times of day that you type into a cell.

Constant Value

In Sam's spreadsheet, Column A has student first and last names. They need to be separated into two different columns. Which tool would he use? Convert Text to Column Wizard Split View Comma Delimited View Side by Sid

Convert Text to Column Wizard

chart

Conveys a visual representation of data

You can use the

Print Selection option to print a specific range in a worksheet.

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

Copy using the Fill Handle

According to the order of operations, which operation is performed first in the following equation: =D1/5+1*D3/(D3-D2)?

D3-D2

Text or numbers in a cell.

Data

Which file type places each record on a separate line and uses a special character to separate fields? Bound Defined Delimited Isolated

Delimited

e-mail

Electronic mail

When saving a microsoft access database as another file type which ribbon contains an area of centralized tasks that are related to file management known as the backstage? Home ribbon File tab External Data ribbon Database Tools ribbon

File tab

Formula AutoComplete

Displays an alphabetical list of functions from which you can choose

Formula Bar

Displays the contents stored in the active cell

Worksheet

Each workbook is made up of individual worksheets, or sheets, containing formulas, functions, values, text, and graphics.

Chad needs to change a members telephone number in the FBLA database. What step should he take? Add New Record Delete Record Move Field Edit Record

Edit Record

True or False: During the editing phase you should not worry about grammar and word usage.

False

When creating a PivotTable which are drawn in columns in the worksheet data? Records Fields Cells Ranges

Fields

You have been asked to develop an address book for the FBLA members. Last name and first name would be examples of: Cells Databases Fields Records

Fields

Which tab do you use to display the area that contains the print command? Home Page Layout View File

File

The Monitor

Editing skills develop as L2 learner's ability to compare own forms to models + conventions Since written language is fixed, writing offers many opportunities to develop monitoring through teacher and peer models + correction

Workbook

File consisting of one or more worksheets

An equation that performs mathematical calculations on values in a worksheet.

Formula

The default format that Excel applies to numbers is the:

General Formet

relative cell reference

Instructs Excel to adjust cell references as it copies to destination area

Cell

Intersection of a column and a row

Yes

Is (=F18+F19/2) a formula that uses cell reference?

Volatile Memory

Is lost when the computer is turned off

What command do you use to insert information into a worksheet that will display at the top and bottom edges of the printed page? Margins Print titles Header & Footer Page Setup

Header & Footer

Which options are not available in the page layout tools

Header and Footer

False

Headers and footers are only placed on special pages in a document (t/f)

Select Column

Highlight an entire column

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

Home Ribbon

Row

Horizontal groups of cells named with a number

Leigh Ann designed a bar chart and would like to add an element to the right of the chart that identifies each bar's color. Which chart feature would she need to include? Axis Chart Title Data Label Legend

Legend

Fill handle

Lets you copy cell contents or continue a series of data into a range of selected cells

Drag-and-Drop method

Lets you move or copy data from one cell to another without using the Clipboard

Edward would like to create a chart that shows the trend in iPod sales over the past 2 years. Which chart type should he create? Bar Column Line Pie

Line

John wants to create a chart that shows trends of sales for 4 quarters. What type of chart should he create? PivotChart Line Chart Embedded Chart Linked Chart

Line Chart

Page break

Location in a worksheet that determines where a new page begins.

Active cell

Location in the worksheet that will displays typed data that will be affected by a command

IF, AND, OR and NOT are all part of which category of functions? Math & Trig Lookup & Reference Logical Text

Logical

Which type of field enables a user to select from a list of values when updating the contents of a field? Calculated Attachment Lookup Hyperlink

Lookup

Tom wants to convert all text to lowercase. Which function she he use? Trim Upper Lower Proper

Lower

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

MAX

Eclectic

Made up from a variety of sources

What action would Donna perform to create a new table named Customer Appreciation from the existing Customer Information table and Order History table? Delete Query Update Query Append Query Make Table Query

Make table Query

False

Monthly Payment!A10 is a cell reference that would not result in an error. (T/F)

Marci has a database of all the planets. She needs to know what planets have moons or rings. Which comparison operator would she use to perform the query? Moons and Rings Moons equal Rings Moons not Rings Moons or Rings

Moons or Rings

Virgil needs to transfer a worksheet in the current workbook to a different workbook. Which command should he choose? Insert Move Rename Tab Color

Move

* (Shift 8)

Multiplication symbol used in an Excel formula

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

NOT

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

NOW

An element of the Excel window that displays the name of the selected cell, table, chart, or object is the:

Name Box

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

Name box

Ranges can be defined by

Naming the upper left cell : lower right cell

What is an advantage of narrow margins?

Narrow margins allow you more room on the page.

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

Open

The symbols with which you can specify the type of calculation you want to perform in an Excel formula are:

Operators

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? Orientation Page break Print area Print titles

Print titles

character formatting

Process of changing the way characters appear

Amanda wants to make it easier for other users to input data. What should she do to help other users understand the fields? Unique Identifier Limit field size Povide a Caption Provide database security

Provide a Caption

3) You are in the middle of editing a large document and only wish to edit text. Which view hides charts, graphics, pictures, and other objects so you can focus on the text?

b) Draft

20) Which tab displays Backstage view?

b) File

44) On which tab will you find the Print options?

b) File

11) In order to quickly navigate sections in a document, which tab in the Navigation Pane would you use?

b) Headings

4) When you place your cursor over the insertion point, to what shape does it change?

b) I-beam

39) In order to keep original format and hyperlinks, which paste option would you choose?

b) Keep source formatting

11) What displays when you point to selected text, allowing you access to popular commands?

b) Mini toolbar

46) Which type of bullets would you use when documenting a process that must be followed in a specific order?

b) Numbered

19) Which option is used with the view Side by Side to arrange both documents equally on the screen?

b) Reset Window Position

11) Choose Ruler from the Show command group on this tab to display a hidden ruler.

b) View

32) Which of the following best describes the Block Style letter format used in professional correspondence?

b) has open or mixed punctuation and is left-aligned

23) Where is the Word 2013 Help button located?

b) in the upper-right corner of the screen

42) You no longer need to share your document with others using an earlier version of Word. Which option in Backstage can you use to deactivate Compatibility Mode and save the file in Word 2013 format?

c) Convert

Juan is creating a worksheet that has each week in the month of January in cells B2-B5. How can he put the Label "January" above the cells and center it

Select the cells above the weeks choose merge and center

To resize a column to fit the data automatically

Select the column and choose home/cells/ format autofit, OR Go between the column to be sized and the next column and double click

Julia would like to rearrange her data so that it is in order by the first column

Select the data, choose sort, select first column

In Datasheet view, how does a user delete a record? Double-click the record Select the record and choose Delete from the Create Ribbon Double-click the record and choose Delete from the Database Tools Ribbon Select the record and choose Delete from the Home Ribbon

Select the record and choose Delete from the Home Ribbon

Print area

Selected portion of a worksheet to be printed.

Which option would you choose to move the selected item to the last layer?

Send to Back

range

Series of two or more adjacent cells in a column or row

Recounts Writing Framework

Setting: tells who, when, where, and why Series of events - written in action verbs in past tense with paragraphs in time order sequence Conclusion: describes result and mood and/or summarizes

When a cell that contains a function is selected the formula bar will display

The formula

Category values

The group or category to which a series value belongs.

PDAs

Small hand-held computers that help you perform simple tasks such as note taking, maintaining a calendar, appointment book, and address book would be classified as ___

Speech Recognition

Software that allows the user to enter spoken words into the system

x-axis

The horizontal line on a graph

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? Macro Sort Filter Formula

Sort

David wants to arrange the employee salaries in Column A of his spreadsheet from lowest to highest. What command should he use to complete this task? AutoFill Filter Find and Replace Sort

Sort

33) You want to apply formatting to non-continuous lines of text throughout a document. In order to select text spread throughout a document, which key do you use?

c) Ctrl

32) Which keyboard shortcuts open the Go To tab in the Find and Replace dialog box?

c) Ctrl + G; F5

28) In order to open Find and Replace, which keyboard shortcut do you use?

c) Ctrl + H

Which command on the Home Ribbon do you use to temporarily hide specific values on a worksheet based on a criterion? Find & Select Format Cell Sort & Filter Organize

Sort & Filter

Virgil wants to emphasize the sheet tabs in his workbook. Which command should he choose? Insert Move Rename Tab Color

Tab Color

Helen is creating a form to gather important information about graduation requirements from her senior homeroom students. What tool would she use to ensure that the sequence in navigating the form fields so data is entered in the order she wants? Tab Order Add Existing Fields View Code Property Sheet

Tab Order

Sheets Tab

Tabs that appear at the bottom of the workbook window,which displays the name of each worksheet

Merge Cells

Takes two or more cells and combines them into one.

Drilling Technique

Taking the content from one sheet and pasting it to multiple sheets at one time.

What can you easily change in Microsoft Word using Styles?

Text appearance

Data label

Text associated with a data value.

left alignment

Text is lined up against the left margin.

Footer

Text that appears at the bottom of every page in a document or at the bottom of every slide in a presentation.

Header

Text that appears at the top of every page in a document or every slide in a presentation.

bold

Text that has a darker appearance than normal text

Footer

Text that you want to appear at the bottom of every page

Label

Text, symbols, dates, or numbers not used in calculations

Theme color

The 12 colors that belong to a workbook's theme.

Sheet tab

The area at the bottom of a worksheet that identifies the worksheet; clicking a sheet tab makes the worksheet active.

Primary value axis

The axis in a column chart that displays the primary values associated with the heights of each column.

Secondary value axis

The axis in a column chart that displays the secondary values associated with the heights of each column.

Name box

The box located on the far left of the Formula bar in which the cell reference to the active cell is also displayed.

Name Box

The box that contains the cell address

Excel Help Button

The button located at the right end of the ribbon and labeled with a question mark (?), that provides access to the Excel Help system

What occurs when the cursor is moved over a cell and a user clicks? The row is selected The cell is selected The Column is selected The Worksheet is selected

The cell is selected

Cell reference

The column letter and the row number. Ex: B12

Cell Reference

The column letter and the row number. Example: B12

Find

The command to locate specific letters and numbers in a workbook.

Chart area

The entire chart and all the elements contained in the chart or graph, such as the title and legend.

AutoComplete

The feature that helps make entering repetitive text easier. As you enter text in a worksheet, text that begins with the same letters as a previous entry in the same column is displayed.

Wordwrap

The feature that moves text from the right edge of a paragraph to the beginning of the next line as necessary to fit within the margins.

Tab Key Twice

The insertion point is in the circled cell. What would you need to press to move the insertion point to the cell indicated by the "A".

Cell

The intersection of a row and a column

What is typically included in the range of data selected to create a chart? Titles only Numeric data and totals only Numeric data, totals, and titles Numeric data and titles

Titles only

Sort

To arrange a list of words or numbers in ascending or descending order

Sort

To arrange data in alphabetical or numerical order.

Hector

To bully

format

To change the appearance or look of text.

Formatting

To change the appearance, not the data, of your workbook.

Scale (v)

To change the size of a graphic to make it fit into a document.

Merge

To combine the main document with a data source.

download

To copy data from one computer system to another or to a disk

Truncate

To cut off, or hide, the part of an entry that does not fit in a cell.

Cleave

To cut or split open; to cling to

False

To delete a comment you can LEFT-CLICK on the comment (t/f)

goal seeking

To determine the value of a cell on which the formula depends

Autofit

To eliminate empty space by matching the column width to the longest cell entry or the row height to the tallest cell entry.

spreadsheet program

a computer application used to create a modify spreadsheets

Filter

a condition that data must meet to be included in a selection - a way of limiting data in a list

color scale

a conditional format that displays a particular color based on the relative value of a cell's contents to other selected cells

icon set

a conditional format that displays an icon representing a value in the top third, quarter, or fifth based on values in the selected range

workbook

a file containing related worksheets

AutoSum

a function that automatically adds selected cells

nested function

a function that contains another function embedded inside one or more of its arguments

Chart

a graphic representation of values used to identify trends and contrasts in data

data series

a group of related data points

7. Headline

a heading at the top of an article or page in a newspaper or magazine.

x axis

a horiztonal line that borders the plot area to provide a frame of reference for measurement

gridline

a horiztonal or vertical line that extends from the horizontal or vertical axis through the plot area

legend

a key that identifies color, gradient, picture, texture, or pattern fill assigned to each series in a chart

chart title

a label that describes a chart

axis title

a label that describes either the category axis or the value axis

Border

a line that indicates a boundary of a cell or range

border

a line that surrounds a cell or range

sparkline

a miniature chart contained in a single cell

33) Line and Paragraph spacing options are available on which of the following tabs?

a) Home c) Design d) Page Layout

10) The Paragraph command group can be found on which of the following tabs?

a) Home c) Review

23) Which of the following are valid vertical alignment options?

a) Justified b) Bottom of page c) Center of page e) Top margin

16) Which of the following are valid alignment options?

a) Justify b) Align left c) Align right d) Center

Marci is searching a Planet Database. She wants to find out how many moons Saturn has and the names. Which comparison operator would she use? and equal not or

and

total row

appears as the last row of a table to display summary statistics, such as a sum

Row

appears horizontally in a worksheet and is identified by numbers on the left side of the worksheet window

Column

appears vertically in a worksheet and is identified by letters at the top of the worksheet window

29) In order to search for a single character, which wildcard would you use?

b) ?

28) Use this command to quickly revert a formatted paragraph back to plain text.

b) Clear Formatting

35) The __________ stores items you copy or cut until they are pasted.

b) Clipboard

35) Which keyboard shortcut is used to start a new document?

b) Ctrl + N

53) Which type of tab is used to align a list of currency values?

b) Decimal

True

True or False: You can use borders to create a group of cells or make specific cells stand out.

Text string

Two or more text characters.

Rename "C1" into "expenses"

Type expenses under C1

Continue to save the workbook

Type in July, then choose save

What is the purpose of a primary key in a database? Unique Identifier Limits field size Provides a description Provides database security

Unique Identifier

splitting

Unmerging a cell

Narrative Writing Framework

Used to tell fictional or nonfictional stories or accounts; may relate to one incident or several Components of Narratives: title, orientation, initiating event, complication, resolution, moral and concluding statement - Orientation: uses past tense and descriptive language to create images - Complication: contains linking words to do with time - Resolution: uses variations in sentence length to provide change of mood + pace

IF function

Used when you want to assign a value to a cell based on a logical test

Custom margins

Used to center the spreadsheet both horizontally and vertically on a printed page.

Persuasive Writing Framework

Used to convince the reader of something

=6

Using the correct order of operations, what does this formula equal? =(4-2)*6/2.

=8

Using the correct order of operations, what is the does this formula equal? =16/4*2.

format painter

Used to quickly copy a cell's format to another cell

Insert Function dialog box

Used to search for a particular function.

Seperate items using commas

What do you do to have the cleanest version of text to a column table?

Page Break

What do you insert when you want the next line of text to start on a new page?

Each rectangle in a spreadsheet.

What is a cell?

Cells that are aligned vertically

What is a column?

Comma

What is a common delimiter for data?

Style guide

What is a set of guidelines for the writing and design of documents called?

Writing

What is done during the drafting phase of the writing process?

F3:F26

What is the argument in this function? =AVERAGE(F3:F26)

F3:F26

What is the argument in this function? =MAX(F3:F26)

B11:H14

What is the argument in this function? =COUNT(B11:H14)

Page Break Preview

What is the best View for planning how your Excel worksheet data fits on a printed page?

=SUM(B2:B5)

What is the best formula for finding the total value for cells B2 through B5?

(Tanner and O'Brian 163)

What is the correct in-text citation referencing a book titled "History of New York", by Kathy O. Tanner and Lawrence O'Brian, page 163.

(Richard 39)

What is the correct in-text citation referencing a book titled "Stepping Up Your Game: Basket Ball Training Tips", by Marcus Richard, page 39.

Pre-writing

What is the first step in the writing process?

Comma

What is the most common type of delimiter?

Page number

What is the most important piece of information to include in a page header or footer?

CTRL-Y

What is the shortcut key that repeats the last task?

CTRL-A

What is the shortcut to select all text?

4

What number would the function "=COUNT(A2:A7)" return?

Formulas

What term refers to mathematical equations used in Excel to perform calculations?

Line

What type of chart best shows how data changes over time?

List

What would be the best option to organize a small amount of information?

Change the text box transparency

What would be the best way to make a sun more visible while minimally affecting the text box within?

Alignment

When data is entered into a cell, the default alignment is labels to the left and values to the right

Goal Seeking

Which What-If Analysis tool would you use to solve the following problem? You want to figure out how to payback a student loan in 10 years.

38) Auto Recover automatically saves your data at scheduled intervals. What is the default interval?

c) 10 minutes

12

Which font size should you use when writing a report for an English class?

=$A$10/100

Which formula uses absolute cell references?

=MAX(A2:B5)

Which function would you enter to return the number 45.1?

The data header information must be bold

Which is NOT necessary for organizing data to make it easier to sort?

Browse in the Function Library group and/or Click Insert Function and enter a search phrase

Which is a way to search for a function?

Joiner, Stephen A., et al.

Which is the correct way on the Works Cited page to format three authors (Stephen D. Joiner, Louis J.Davis, and Sally T. Astle) from a source?

Text file

Which of the following files can be used to import data into Excel?

Insert

Which tab would you click to create a Table?

File

Which tab would you use to access the Print controls?

Relative

Which type of cell references are automatically updated when it is copied?

To group the cells

Why would you add borders to cells?

To make sure all of the information in the column is visible.

Why would you want to change the column width?

True

You can use borders to create a group of cells or make specific cells stand out. (T/F)

False

You can use the Formulas Tab to change the Excel View, to hide Heading, Gridlines and the Ruler.

31) Use this spacing option to set the minimum amount of space needed to fit the largest font on the line.

c) At least

24) Use this alignment option to balance a title in the middle of a title page.

c) Centered

Footer

content appearing at the bottom of each printed page

Header

content appearing at the top of each printed page

40) How many items can the clipboard hold at any given time?

d) 24

29) This spacing option accommodates the largest letter in a line, plus a small amount of extra space.

d) Single

9) You cannot seem to locate a specific command while formatting text using commands in the Font group on the Home tab. Where can you find the dialog box launcher, which is necessary to display the dialog box with all commands?

d) lower right

7) Which type of font has characters which take up the same amount of horizontal space?

d) sans serif

7) The Ribbon contains multiple __________ with common commands grouped on each.

d) tabs

27) Which symbol displays on the Show/Hide button?

d) ¶

Name Box

displays the active cell address

3) Use this type of indent in legal documents and in bibliography pages to start the first full line of text at the left margin; all remaining lines are indented from the left margin.

c) Hanging indent

55) Which type of tab is typically used in a Table of Contents?

c) Leader

20) Which option allows you to determine which document will be the active document and displays the document name on the title bar?

c) Switch Windows

1) What is the name of the first screen you see when Windows 8 is launched?

c) Windows Start screen

34) What type of punctuation requires a colon after the salutation and a comma after the closing?

c) mixed

26) You are having trouble lining up columns of information. In order to troubleshoot hidden formatting commands, what do you display?

c) nonprinting characters

12) What displays when you right-click on selected text?

c) shortcut menu

superficial

concerned with or comprehending only what is apparent or obvious shallow

Common knowledge

does not need an in-text citation when gathering information from another source

43) Which of the following locations can be accessed to create and insert a custom picture bullet?

e) All of the Above

area chart

emphasizes magnitude of changes over time by filling in the space between the lines with a color

wrap text

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

autofill

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

Number of columns in a table

equals the number of column headers

Number of rows in a table

equals the number of row titles, plus one

IIF function

evaluates a condition and returns one value if the condition is true and another value if the condition is false

File Tab

explains the access to the Excel Options dialog box and provides control to create new documents, save and print documents, as well as several other features.

red

expresses danger power or energy nd often is associated with sports or physical exertion

Xlsx

file extension used for Microsoft Excel 2013 documents-identifying the type of program used to create it

To continue a series of dates, you can click and drag the

fill handle

Whenever you format data as a table, it will automatically include

filters

cell address

identifies a cell by column letter and row number

name box

identifies the address of the current cell

D Teams, Wins, Loses, Ties

identify the column header(s).

Conditions Statements

in a formula that can be evaluated as true or false, and then return an appropriate value if true, and another value if false.

headline

in an advertisement, large type designed to draw attention

automatically updated properties

include file system properties, such as the date you create or change a file, and statistics, such as the file size

resizing

includes both enlarging and reducing the size of a graphic

text

includes letters, numbers, symbols, and spaces

sizing handle

indicated by faint dots on the outside border of the selected chart, enables you to adjust the size of the chart

relative cell reference

indicates a cell's relative location from the cell containing the formula; changes when the formula is copied

absolute cell reference

indicates a cell's specific location; does not change when the formula is copied

page break

indicates where data starts on a new printed page

blue

indictates intergrity trust importance confidence and stability

Page Break

inserted when you want the next line of text to start on a new page

synergy

interaction of two or more agents or forces so that their combined effect is greater than any individual part

symbiosis

interdependent relationship

Make a copy

it is good practice "just in case" you forget your password

freezing

keeps rows and/or columns visible as your scroll through a sheet

Portrait

page orientation that has more room up and down the page

Landscape

page orientation that is wider than it is taller

Column headers

part of the table that describes the main categories of information in a table

stacked column chart

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

category axis

provides descriptive group names for subdividing the data series

document protection options

read only, restrict edits, require a password

Function

special formulas that do not use operators to calculate results. A shortcut formula Ex: sum(B6:B9)

100% stacked column chart

stacks data in one column per category, with each column having the same height (100%)

black

suggests authority strength elegance power and prestige

File

tab you would click to find the document protection features

COUNTBLANK function

tallies the number of blank cells in a range

COUNTA function

tallies the number of cells in a range that are not empty

COUNT function

tallies the numbers of cells in a range that contain values

A predesigned workbook you can use to create a new project quickly is called a(n)

template

pre-writing

the first phase of the writing process

Cell Alignment

the position in which text is placed within a cell

filtering

the process of displaying only records that meet specific conditions

succumb

to submit to an overpowering force or yield to an overwhelming desire; give up or give in

Corroborate

to support with evidence

substantiate

to support with proof or evidence; verify

Move Tool

used to place a selection in a new location

Column

vertical group of cells named with a letter

strenuous

very remanding; requiring great exertion

Cell Value

what is typed into a cell-contained with in

Narrow Margins

when two lines of text run onto a second page, but you only want 1 page; helps fit everything on one page

range name

word or string of characters that represents one or more cells

A range of cells is

A collection of individual cells

Record

A collection of related fields that are grouped together, in Excel, each row represents a record.

Orientation

Direction in which contents of page will print

Byte

In terms of data storage, a character is usually the same as a ___

Spam

the electronic equivalent of junk mail

When making an absolute cell reference, you'll need to include at least one

$ (dollar sign)

How does a user define a cell name (A1) as an absolute reference

$A$1

point

1/72 of an inch

color scheme

12 complementary colors for text, background, accents, and links

Browser

A ___ is the software that allows you to surf the Web

Theme

A designed collection of formatting options that include color, graphics, and background images.

Sow (n)

A female pig

fill

A tool in Excel that allows you to copy down or across from an existing cell to enter formulas or data into other cells

Multi-Selection

A word feature that enables users to select multiple items of the text that are not adjacent.

Defined name

A word or string of characters associated with a single cell or a range; also called a range name.

The correct way to display the range from A1 through C5 and formulas is

A1:C5

shade

Adding black to a color

Pox

Bad luck

horizontal split bar

Bar going across the middle of a split screen

What would be the best way to make the sun more visible while minimally affecting the text box?

Change the text box transparency

Use the fill button to copy the formula

Click the arrow sign

merging cells

Creating a single cell by combining two or more cells

Formula prefix

Equal sign preceding a formula

The keyboard shortcut to define a cell as absolute is

F4

They are independent and not related.

How are a cell's content and format related?

=

In Excel, all formulas must begin with what symbol?

Ruler Bar

In the document window, a line that shows appropriate document measurements is called the ___

Dialog box launcher

Item of the Ribbon that opens a dialog box or task pane

Citing three authors: Stephen D. Joiner, Louis J. Davis, and Sally T. Astle

Joiner, Stephen A., et al

Ctrl+c

Keyboard shortcut for copy

SUMIF and SUMIFS are in which category of functions? Lookup & Reference Math & Trig Logical Text

Math & Trig

Juan needs to view and access all parts of his database. Where can these objects be located most efficiently? Design View Form View Layout View Navigation Pane

Navigation Pane

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

Orientation

Which term refers to storing the same field in more than one location in a database? Redundancy Repetition Replication Recurrence

Redundancy

Which protection option would you choose if you wanted people to only review your document?

Restrict editing

Which ribbon contains commands to add a comment about a selected cell in a worksheet? Home Insert Review Data

Review

Which command group on the Page Layout Ribbon controls the presence of gridlines and headings on a worksheet? Theme Page Setup Sheet Options Arrange

Sheet Options

What is a single character, word, or phrase in a cell on a worksheet that is typically used in searches? Text String Thread Key

String

Ape

To imitate someone exactly where the result is negative or laughable

Another name for a constant value.

Value

12 points

When writing a report, the font size should be ___

Which command creates decorative text in a worksheet? SmartArt WordArt Draw Shape

WordArt

Row Heading

a number at the far-left side of a row that can be clicked to select the entire row of cells

value

a number that represents a quantity or amount

data point

a numerical value that describes a single value on a chart

chart

a visual representation of numerical data

27) Which type of border would you apply when designing a one page award certificate?

a) Page

4) What is the default view in Word?

a) Print Layout

Cell Label

ability to use name box to name a range of cells/cell

3-D chart

adds a third dimension to each data series, creating a distorted perspective of the data

If you wanted to filter data to exclude a certain word or phrase, you could use a(n)

advanced text filter

Freeze Panes

allows the user to select specific rows or columns that remain visible when scrolling in the worksheet

Slicers

are basically just filters

Rows on a table

are horizontal; go left and right

Columns on a table

are vertical; go up and down

subjective

based on or influenced by personal feelings, tastes, or opinions.

subordinate

belonging to a lower or inferior class or rank; secondary

SUBTOTAL function

calculates an aggregate for values in a range or a database

AVERAGE function

calculates the arithmetic mean or average of the values contained in two or more cells

surreptitious

clandestine; furtive, secretive

print area

defines the range of data to print

lookup value

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

HLOOKUP function

looks up a value in a horiztonal lookup table where the first row contains the values to compare with the lookup table

pv

present value of the loan

12

the font size you should use when writing a report for an English class

nper

the total number of payment periods

data label

the value or name of a data point

row height

the vertical measurement of a row

One advantage of sparklines is that

you can keep them very close to their source data

The athletic director is looking for swim team purchase orders that are more than $200. What criteria would give her this information? >=200 AND swimming >200 OR swimming >=200 OR swimming >200 AND swimming

>200 AND swimming

Where would click on the image to increase the border thickness for a table?

A

Where would you click to change text to a bulleted list?

A

Where would you click to select the whole table?

A

worksheet

A 'page' of an Excel workbook, accessible by the tabs at the bottom

Style

A basic and distinctive mode of expression.

automatic spell checking

A feature in Word that checks your document for spelling errors as you type, and flags them with a red or blue wavy underline.

Workbook

A file containing multiple spreadsheets

Border

A line or box that frames a cell.

Menu

A list of choices shown on the display screen

Excel table

A range of data you can treat as a distinct object in a worksheet.

Template

A spreadsheet already set up for a specific purpose

italic

A text style that makes text slanted

Field name

A unique label that describes the contents of the data in a column, also called a column header.

Column header

A unique label that describes the contents of the data in a column.

Filename

A unique set of letters and numbers that identifies a file and usually describes its contents is called a

Accounting Number Format button

Adds dollar signs and two decimal places to selected data

Fill Months

Auto Fill option that fills destination area with series of months

Where would you click to delete a comment in the document?

B

the last step when planning a table

Calculate the number of columns/rows

Anything typed into a cell.

Cell Content

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

Cell Style

source area

Cell being copied

Merge & Center button

Centers cell contents over multiple cells

What is the purpose of the -/+ buttons that appear across the categories on a PivotTable? Drecrease/Increase Collapse/Expand Reduce/Add Subtract/Add

Collapse/Expand

A vertical group of cells in a worksheet

Column

catholic

Comprehensive or broad scope

Dennis needs to format his sales amount column to show dollar signs. Which format would he use? Currency Fixed General Number Text

Currency

What answer would Excel give if you typed =3+6*2 into a cell?

D. 15

.014 inch

Font size -one point

10

If D3=30 and D4=20, what is the result of the function IF(D4<D3, D3-D4, "Full")

3

If Microsoft Excel cell A3 contains the value 4 and cell B3 contains the value 2, then the formula = (A3 + B3) / (A3 -B3) results in

Sub procedure

In VBA, all of the actions performed in a macro.

requirements document

Includes a needs statement, source of data, and summary of calculations

Cell

Individual locations on a spreadsheet

What is the default Microsoft Word paper size?

Letter (8.5" x 11")

Tyler created a monthly sales workbook that contains the formula =SUM(Sales). "Sales" is an example of a: Named Range External Reference Names Manager Scope

Named Range

Jackson is starting a new company database to manage his new fall line of products. What form tool could he use to quickly create a set of tabs a user could click to access forms and reports in the database? Form View Layout View Design View Navigation Form

Navigation Form

Which area appears on the left side of Microsoft Access windows and displays a list of objects available in the database? Objects pane Database pane Navigation pane List pane

Navigation pane

Lilly is making changes to a spreadsheet her FBLA Advisor created. She wants to add a note informing her advisor of an incorrect address for a member. What option in the comments group should she use? Show Ink Delete Edit Comment New

New

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? Orientation Page Break Print Area Print Titles

Print Titles

mercurial

Rapid mood changes

F4 key

Rather than retyping a formula, you can switch reference in editing mode by selecting the cell reference and pressing the F4 key.

3-D Reference

Refers to the same cell or range in multiple worksheets in the same workbook. The reference specifies not only the range of rows and columns, but also the range of worksheet names in which the cells appear. (Example: WorksheetRange!CellRange )

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

Scale

Kerning

The space between letters

8 1/2" x 11"

The standard size of paper for a business letter

Title Bar

The title bar text changes to display the name of the active document. Located at the top of the document

Muse, bemuse

To loose yourself in your thoughts

zoom in

To magnify the appearance of a worksheet or chart

select

To make a cell active

AutoFit Window

What AutoFit option is used to adjust columns so that the table spans across the page?

Clear All

What Clear command would you use to make cell A2 look like cell B3?

Format attributes

What are the pieces of information that describe the appearance of a cell's content?

Up and down

What direction does a column go?

Down arrow to expand style choices

Where would you click to see the list of Microsoft Word Styles?

Bar

You want to chart the average summer time temperatures of the 20 hottest cities in the United States. Which type of chart would be best for this purpose?

MLA header

Your Name, Instructor Name, Course, Date

circular reference

occurs when a formula directly or indirectly refers to itself

OneDrive

online "cloud" storage

Office365

online versions of Microsoft Office

cell

the intersection of column and row

publishing

the last phase of the writing process

"et al"

"Et al" means "and others", it is derived from Latin.

What character can be placed in front of data to force excel to treat it as text?

'

Citing a book by Kevin Portman, page 97

(Portman 97)

Citing a book by Holland Rustin, Michael Kline, page 163

(Rustin and Kline 163)

Cells a1:c5 in sheet 1 are created and named sales; how would a cell on sheet 2 reference the range?

(sales)

Unhide Row Tool

-ll-

MLA indent

.5"

MLA header

.5" from the top

Mary needs to export the table of FBLA members from the Southeast Region database to a document that does not allow editing. Which format should she use? .doc .pdf .rtf .txt

.pdf

MLA margins

1" all around

The Writing Process: 4 Steps (Reid)

1. Composing 2. Organizing the Material 3. Drafting 4. Revision Process

What are the four steps for planning a table?

1. Determine the table title 2. Define the column headers 3. Define the row titles 4. Calculate the number of columns/rows

The Five Stages of Spelling

1. Emergent Spelling 2. Letter-Name Spelling 3. Within-Word Spelling 4. Syllables and Affixes Spelling 5. Derivational Relations

Conventions of Written Standard English

1. Mechanics 2. Syntax 3. Grammar 4. Spelling

Types of Writing Frameworks (8)

1. Narrative 2. Recounts 3. Procedures 4. Reports 5. Descriptive 6. Explanations 7. Expository 8. Persuasive

Given the highlighted are in the image, how many rows and columns would be in the resulting table?

3 rows by 6 columns

Sam completed a query on the UNC School system and wants to narrow his search to find which schools have a maximum tuition of $15,000 for in-state students. Which operator would he use? < <= > >=

<=

Delores is doing a search of the bed and breakfasts in Southport, NC. She wants to know which bed and breakfast is less than one mile from the waterfront and allows pets. Which comparison operator would she use? >=,and >,and <=,and <,and

<=,and

What text qualifier tells Excel that the cell contains a formula

=

True

=$A10/B5 uses absolute cell references. (T/F)

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 =B1+25 =1$B$+25 =B1:B3

=$B$1+25

Sam enters a numeric criterion in a query to find out which UNC schools have an enrollement that equals 5,000 or greater. What would he enter? ="5000" 5000 "<5000" =->"5000"

=>"5000"

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

=B4*C4

False

=SUM(A1:A9)/2 is a formula that DOESN'T use cell reference. (T/F)

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? =$B$1+25 =B1+25 =SUM(B1:B39) =B1:B39

=SUM(B1:B39)

Zoom Slider

A bar in the lower-right corner of an Office program window that you can use to increase or decrease the size of the document on screen.

Worksheet

A blank page in a spreadsheet file

Selection box

A box surrounding an object that lets you move or resize the object.

Format painter

A button on the Ribbon that, when selected, copies a format from one cell range to another.

AutoSum

A button that quickly inserts Excel functions that summarize all the values in a column or row using a single statistic - SUM, AVERAGE, COUNT, MIN or MAX

Financial function

A category of Excel functions that calculate values from loans and investments.

Date function

A category of Excel functions that store and calculate dates as numeric values, representing the number of days since January 1, 1900.

Select the cell and edit the formula in the Formula Bar.

A cell has a very long formula that you must edit. What would be the best way to edit the formula.

Pie chart

A chart in the shape of a circle (like a pie) that shows data values as percentage of the whole.

Combination chart

A chart that combines two or more chart types in a single graph.

Line chart

A chart that compares values from several categories with a sequential order, such as dates and times that occur at evenly spaced intervals. The values are indicated by the height of the line.

Embedded chart

A chart that is displayed within a worksheet and one that you can place alongside the data source, giving context to the chart.

XY scatter chart

A chart that shows the patterns or relationship between two or more sets of values.

Pie Chart

A chart used to visually display the parts of a whole as percentages, a circular chart divided into triangular areas proportional to the percentages of the whole

relative cell reference

A code that points to a particular cell, which changes depending where that code is entered; for example, it may point to a cell that is one column to the left and one row above the cell where the formula is entered

absolute cell reference

A code that points to a unique cell, independently of where that code is entered; dollar signs are used to 'lock' the column and row

Group

A collection of buttons for related commands on the Ribbon.

picture style

A collection of formatting options—such as a frame, a rounded shape, and a shadow—that changes a picture's overall appearance.

Worksheet group

A collection of two or more selected worksheets in which everything you do to the active worksheet also affects the other worksheets in the group.

Automatic color

A color option that uses the Windows default text and background color values.

Standard color

A color that is always available regardless of the workbook's theme.

Custom color

A color you specify as a mixture of red, blue, and green color values, which makes available 16.7 million custom colors - more colors than the human eye can distinguish.

Pixel

A colored dot that, when combined with other pixels, forms a picture or graphics display; stands for picture element.

Bar chart

A column chart turned on its side, so each length is based on its value.

Text data

A combination of letter, numbers and some symbols.

Username

A combination of letters and numbers that serve as your "identification" is called a ___

Copy

A command in Word that places a duplicate copy of selected text in the Clipboard.

Cut

A command in Word that removes selected text from the original location and places the deleted text in the Clipboard collection.

Go To

A command in the scroll box that enables users to browse by field, endnote, footnote, comment, section, page, edits, headings, graphics, or tables.

A small red triangle in a cell indicates

A comment associated to the cell

Cookie

A device that permits a Web site to identify and collect information about every user who visits that site

Clipboard

A feature that allows a user to copy and paste text and graphics from multiple sources into a document.

Click and Type

A feature that allows you to double-click a blank area of a document to position the cursor in that location, with the appropriate paragraph alignment already in place.

Scrollbar

A feature that allows you to scroll up and down or left and right in order to view portions of your work area

Object Zoom

A feature that allows you to zoom in and make tables, charts and images in your document fill the screen.

Spelling checker

A feature that check the words in a document against the program's built-in dictionary and helps you avoid typographical errors.

Category field

A field used to group the values in a PivotTable.

Sort field

A field you use to order data.

Workbook

A file that contains one or more spreadsheets

Theme font

A font associated with a particular design theme and used for headings and body text.

Sans serif font

A font that does not have the small horizontal lines (called serifs) at the tops and bottoms of letters.

Serif font

A font that includes small horizontal lines (called serifs) at the tops and bottoms of letters.

=F6/3

A formula that contains a cell reference

Average

A function that identifies the numeric average of a set of values in a column or a row

Autosum

A function to add a set of values in a column or a row

True

A goal during the editing phase is to correct spelling and grammar (t/f)

PivotChart

A graphical representation of the data in a PivotTable in which you can interactively add, remove, filter, and refresh data fields.

HTML (Hypertext Markup Language)

A language used to write Web pages.

Gridlines

A line that extends across the plot area indicating the location of tick marks on the chart's horizontal or vertical axis.

Border

A line that prints along the side of a table cell or around the outside of selected text.

Agenda

A list of items to be considered or acted upon is called ___

Input message

A message that appears when the cell becomes active; can be used to specify the type of data the user should enter in that cell.

Chart sheet

A new sheet that is automatically inserted into the workbook, occupies the entire document window, and provides more space and details for the chart.

Spreadsheet

A program that allows you to use rows and columns of data to manage, predict, and present information.

In-text citation

A reference made in the text of a document. It alerts the reader that the author is using information from another source.

External reference

A reference to a cell or range in a worksheet in another workbook.

Font

A set of characters that uses the same typeface, style, and size.

Style Guides

A set of guidelines for the writing and design of documents.

Order of precedence

A set of predefined rules that Excel follows to unambiguously calculate a formula by determining which operator is applied first, which operator is applied second and so forth.

Data validation

A set of rules that determine what users can enter in a specific cell or range.

Microsoft Excel 2007

A spreadsheet program you use to display, organize, and analyze numerical data.

Excel application

A spreadsheet written or tailored to meet the user's specific needs; typically includes reports and charts, a data entry area, a custom interface, as well as instructions and documentation.

Arithmetic operator

A symbol, such as +, - , *, or /, used in a formula to perform arithmetic calculations.

True

A table of contents makes a document easier to read because it lists the document sections and the pages where they are found

Comment

A text box that is attached to a specific cell in a worksheet in which you can enter notes.

Mini toolbar

A tool bar that appears next to the pointer whenever you select text and contains buttons for the most commonly used formatting commands, such as font, font size, styles, color, alignment, and indents that may appear in different groups or tabs on the Ribbon.

Scroll Bar

A tool that allows the user to move up or down within the document.

Scroll Box

A tool that allows users to move horizontally and vertically through a document more quickly than the scroll buttons, or to see a ScreenTip displaying a user's position in the document.

Navigation Pane

A tool that appears in the left side of the window when you select its command in the Show command group.

Gridlines

A tool that provides a grid of vertical and horizontal lines that help you align graphics and other objects in a document.

Spreadsheet

A tool used in business for budgeting, inventory management, and decision making fir analyzing and reporting information.

picture effect

A tool used to alter the appearance of a picture in a Word 2016 document. It refers specifically to corrections that can be made to the picture itself

Insert Function

A toolbar button that displays functions by category that will assist you in writing the formula.

View short-cuts toolbar

A toolbar located at the right end of the status bar that contains tools for switching between views of document content and changes the display magnification

Quick Access Toolbar

A toolbar located in the upper-left corner of the program window, which displays the Save, Undo, and Repeat buttons by default but can be customized to include any command.

Column chart

A type of chart that displays values in different categories as columns; the height of each column is based on its value.

Portrait orientation

A type of page orientation in which the page is taller than it is wide (like a typical business letter.)

Landscape orientation

A type of page orientation in which the page is wider than it is tall, so that text spans the widest part of the page.

Macro virus

A type of virus that uses a program's own macro programming language to distribute the virus.

Ribbon

A user interface design that organizes commands into logical groups, which appear on separate tabs. The Ribbon includes tabs that have access to various groups and commands according to the task being performed.

Date data

A value in a recognized date format.

Time data

A value in a recognized time format.

Accent

A variation on an Excel theme color.

column

A vertical arrangement of cells, organised by letter

Diagram

A visual representation of data to help readers better understand relationships among data

Custom template

A workbook template you create that is ready to run with the formulas for all calculations included as well as all formatting.

Template

A workbook that you can open with labels, formats, and formulas already built into it from which you create new workbooks.

Planning analysis sheet

A worksheet that includes questions to help you define the purpose and objective of a workbook.

Maggie wants to use a function that will return True when all its arguments are true, and False when one or more arguments are false. What function would she use? AND IF NOT OR

AND

APA Style Guide

APA stand for American Psychological Association. APA is generally used for writing in science and research fields.

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 MAX MIN SUM

AVERAGE

Which of the following are valid Microsoft Excel functions? AVERAGE,MAX, and NUM MAX,MIN, and WEEK AVERAGE,MAX, and MIN WEEKDAY,MAX, and CLOSE

AVERAGE,MAX, and MIN

Jamal wants to average a range of cells in his spreadsheet. He would like Excel to average only the cells in that range that are greater than 100 but less than 500. What function should he use? TOTALIFS SUMIFS COUNTIFS AVERAGEIFS

AVERAGEIFS

The type of cell reference that refers to cells by their fixed position in a worksheet is:

Absolute

What type of formula cell reference instructs Microsoft Excel to keep the cell reference contant in the Formula as it copies it to the destination area? Relative Mixed Absolute Unconditional

Absolute

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

Accounting

A cell surrounded by a black border and ready to receive data is the:

Active Cell

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

Active Sheets

Ann needs to duplicate a field that is used in his customer table in the business database for a new form he is creating for entering customer orders. Which item from the tools group would enable him to perform this operation? Tab Order Add Existing Fields View Code Property Sheet

Add Existing Fields

Cathy needs to duplicate a column that is used in her spring sports table in the athletic database for a new form she is creating for fall sports. Which item from the tools group would enable her to perform this operation? Tab Order Add Existing Fields View Code Property Sheet

Add Existing Fields

Keton created a customer information form from his customer table. He realizes he left email address off the form. What tool would he use to add email address to the existing form? Tab Order Add Existing Fields View Code Property Sheet

Add Existing Fields

The correct syntax to make the contents of cell f23 always match the contents of cell d5 is to

Add the function "=d5" in cell f23

False

Adding borders on the cells is just for decoration, not to group the cells. (T/F)

SUM function

Adds all the numbers in a range of cells

The Natural Order of Acquisition

Affects development of form and accuracy Students' writing will lag one - two levels behind L2 oral skills proficiency level Progression is from words to sentences to paragraphs to complete narratives

Which type of operation performs mathematical functions, such as MAX, MIN, or COUNT, on a group of records? Statistical Geometric Aggregate Algbraic

Aggregate

=

All formulas in an Excel worksheet must begin with this symbol

worksheet

Allows data easily to be summarized and charted

Cell Format

Allows someone to change a cell's appearance; alignment, font, border, patterns, etc. as well as its numerical type; number, text, currency, percentage, etc.

Insert Tab

Allows you to add various items into a document; such as pages, tables, charts, illustrations, links to Internet sites or other documents, headers, footers,text and symbols

Goal Seeking

Allows you to define output results and then shows what input values are needed to generate that result.

Expand Arguments

Allows you to expand the function dialogue box in order to adjust the arguments in your function.

Data Table

Allows you to investigate how changes to one or two input variables in a formula changes output results.

Collapse Arguments

Allows you to shrink the function dialogue box in order to choose cells for your function.

Workspace

An Excel file that saves information about all of the currently opened workbooks, such as their locations, window sizes, zoom magnifications, and other settings.

Table style

An Excel setting that applies styles to four table elements (header row, first column, last column, and totals row).

AutoFill

An Excel tool that enables you to copy the contents of the selected cells by dragging the fill handle over another adjacent cell or range of cells rather than using the copy and past commands.

Live preview

An Office feature that shows the results you would achieve in your file, such as the effects of formatting options on a document's appearance, if you click the option to which you are pointing.

Compound interest

An amount for which the interest paid is calculated on the principal and any previous interest payments that have been added to that principal.

What-if analysis

An approach using an electronic spreadsheet in which you change one or more of the values in the worksheet and then examine the recalculated values to determine the effect of the change.

Ribbon

An area at the top of the Excel 2010 window where almost all the capabilities of Word are available to help you use the program efficiently.

Optional argument

An argument that is not necessary for the function to calculate a value (if an optional argument is not included, Excel assumes a default value for it.)

Field

An attribute or characteristic of a person, place, or thing (such as a last name, address, city, or state); in Excel, each column represents a field.

Spreadsheet

An electronic file used to organize data and perform calculations

46) You have a 20-page document and want to print it in draft form with a reduced number of printed pages to save paper. In order to accomplish this task, you can use the __________ option in the drop-down arrow by 1 Page Per Sheet under Settings.

Answer: 2 Pages Per Sheet

25) You must use the ___ command to highlight every occurrence of a specific word or phrase in your document.

Answer: Advanced Find

44) Use the ___ buttons on the Home tab to justify bulleted text.

Answer: Alignment

19) In order to display KeyTips on the Quick Access Toolbar and Ribbon, press the __________ key.

Answer: Alt

26) Use the ___ button in the Paragraph group on the Home tab to align around a paragraph.

Answer: Border

41) Use the ___ option in the Drop-Down Bullet list to promote selected bullets.

Answer: Change List Level

45) Use the ___ key while you drag to copy text.

Answer: Ctrl

30) Use the ___ dialog box to replace text with formatted text.

Answer: Find and Replace

15) In order to copy attributes and formatting from one selection to another within an open document, use the ___ command in the Clipboard group.

Answer: Format Painter

31) Use the ___ command as a way to navigate through longer documents quickly.

Answer: Go To

15) ___ alignment refers to how text is positioned between the left and right margins.

Answer: Horizontal

2) A/An ___ is a blank space inserted between text and the left or right margin.

Answer: Indent

1) Use ___ to set paragraphs off from other text in your document.

Answer: Indents

6) Access keys, also known as __________, are keyboard shortcuts which appear as small letters on the Ribbon.

Answer: KeyTips

18) Use this button on the Home tab to line up text flush with the left margin, leaving a ragged right edge.

Answer: Left Align

30) ___ is the amount of space between lines of text in a paragraph.

Answer: Line spacing

19) Use this button on the Home tab to center text between the left and right margins, leaving ragged edges on both sides.

Answer: Middle Align

50) Use a ___ list for outlining your research paper.

Answer: Multilevel

51) ___ lists are typically used when subsets of information are needed within the list, such as, agendas, outlines, or exams.

Answer: Multilevel

38) The ___ command takes text from the Clipboard and places it in the designated location.

Answer: Paste

20) Use this button on the Home tab line up text flush with the right margin, leaving a ragged left edge.

Answer: Right Align

24) A __________ is a box which displays the command name and helpful information when you hover over a command on the Ribbon.

Answer: ScreenTip

21) ___ bars allow a user to move up and down or from side to side within a document.

Answer: Scroll

25) Use Word's ___ feature to color the background behind selected text or paragraphs.

Answer: Shading

46) In order to remove extra blank lines between paragraphs, it is important to display hidden characters using the ___ command on the Home tab.

Answer: Show/Hide

48) Use the ___ tab in the Properties dialog box to customize document tracking information.

Answer: Summary

12) To indent the first line of a paragraph, click in front of the line and press ___.

Answer: Tab

58) Use the ___ key to move the insertion point to the next tab setting.

Answer: Tab

22) ___ alignment is used to position text between the top and bottom margins of the page.

Answer: Vertical

42) Choose the ___ font to apply creative graphical bullets.

Answer: Wingdings

30) __________ automatically wraps text to the next line as the cursor reaches the right margin.

Answer: Word Wrap

20) Use ___ to create text with a 3-D rotation.

Answer: WordArt

13) You have accidentally activated the Caps Lock key and typed three paragraphs in uppercase. Which option in the Change Case menu will convert the text back to normal paragraph format?

Answer: a

18) A linked style is one that can be applied to a paragraph and a character. What displays next to this type of style in the list?

Answer: a

3) Which of the following best describes a character's "point size"?

Answer: a

9) Which font type has small lines at the beginning and end of characters?

Answer: a

21) Which file types can be opened, edited, and saved in Word?

Answer: a Answer: c Answer: d

14) Paragraph ___ refers to how text is positioned between a document's margins.

Answer: alignment

16) In order to use the Format Painter to apply the same formats over and over, you must double-click the Format Painter button. Which key on the keyboard can you use to clear the Format Painter?

Answer: b

6) Where is the Font dialog box launcher located in the Font group on the Home tab?

Answer: b

8) Which type of font has characters which take up varying amounts of horizontal space?

Answer: b

11) You want to enhance a heading in a newsletter and wish to use Text Effects to make the title stand out. Which of the following are options within the Text Effects drop-down menu?

Answer: b Answer: c Answer: d Answer: e

38) Use a ___ list to format lists of items that do not have to display in any specific order.

Answer: bulleted

23) Sometimes it is easier to remove all formatting from an imported file before applying custom formatting in Word. In order to remove all formats from selected text, which option in the Font group do you use?

Answer: c

17) Which two types of styles are available in the Styles gallery?

Answer: c Answer: d

1) A ___ is any single letter, number, symbol, or punctuation mark.

Answer: character

47) It is best to __________ a document before exiting Word.

Answer: close

37) When you ___ text, Word places a duplicate copy in memory.

Answer: copy

36) When you ___ text, Word removes it from the original location.

Answer: cut

10) Which type of font does not have small lines at the beginning and end of characters?

Answer: d

19) You are working as a team in the Human Resource department creating company policy documents. In order to ensure all styles update automatically, which Modify Style option would you choose?

Answer: d

39) Use a ___ list to format lists of items that must display in a specific order.

Answer: numbered

17) Use the ___ button on the mouse to display the shortcut menu where you have access to the paragraph dialog box.

Answer: right

22) Use the ___ box to move quickly through a document using click and drag.

Answer: scroll

23) Use the ___ buttons to move up or down one line at a time, or click and hold the button to move quickly through a document.

Answer: scroll

34) You must ___ a paragraph before changing line spacing.

Answer: select

4) You must ___ text before you can apply a new font or point size.

Answer: select

40) You must ___ text before using the Bullets button.

Answer: select

52) You can sort a ___ -level list.

Answer: single

36) You are in a hurry and need to create a new letter. In order to save time, you can use a preformatted __________ in Word.

Answer: template

28) The __________ is the space between pages of a document.

Answer: white space

Data source

Any file that contains the data you want to retrieve.

Table body

Any part of the table under the column headers

Document

Any printed business communication

Asunder

Apart or into pieces

What type of query enables a user to add the results of a query to and existing table in a database? Update Append Action Make table

Append

Matt needs to add his contacts to the Driver Education database. To do this quickly what predefined object can he create? Application Parts Quick Start Sharepoint List Database Object

Application Parts

Row Titles

Are used to further group table information into rows. Row Titles are optional

MLA fonts

Arial or Times New Roman 12pt

What command will arrange Microsoft Excel windows so that they appear side by side on the screen? Zoom to Selection New Window Arrange All Freeze Panes

Arrange All

Joan wants to see her sales representatives in numerical order with the sales person who sold the least at the top. Which sorting option should she choose? Ascending Descending Primary Sort Customer Filter

Ascending

standard properties

Associated with all Microsoft Office files and include author, title, subject

The Excel feature that generates and extends values into adjacent cells based on the values of selected cells is

Auto Fill

Copy Cells

Auto Fill option that fills destination area but does not create a series

Fill Formatting Only

Auto Fill option that fills destination area using format of source area

Fill Without Formatting

Auto Fill option that fills destination area with contents without formatting

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

Auto Fit

Nick wants to design a database and wants Access to automatically assign an ID number to each record. What data type should he use? Auto Number Currency Yes/No Hyperlink

Auto Number

Which Microsoft Excel feature automatically inserts data into a cell that begins with the same characters as a previous enrty? AutoComplete AutoFill AutoCorrect AutoSpell

AutoComplete

David wants to key the numbers 1 to 1000 in column A of his spreadsheet. What command should he use to complete this task? AutoFill Filter Fina and Replace Sort

AutoFill

True

AutoFill automatically adjusts formulas with relative cell references. (T/F)

An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column is:

AutoFit

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

AutoFit

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? AutoFit Special Formatting Subsript Formatting Merge

AutoFit

Which AutoFit option is used to automatically adjust column width based on the data in the cells?

AutoFit Contents

Which command on the Home Tab displays the total of the selected cells directly after the selected cells? AutoSum Add Total Calculate

AutoSum

Carol has created a table from her database to see all information about FBLA chapters in her region. She needs to know the mean number of active members in the region. Which aggregate function should she use? Count Max Min Average

Average

Frank needs an estimated number of services his company performs each month. Using a calculated field ,which total function would he use to answer his question? Average Count Max Sum

Average

Juan is creating a chart graphing attendance at FBLA State Leadership conferences from the past five years which he has in a database. He wants to remove the Y-axis value. Which tab in Chart Options would he select? Titles Axes Data Labels Legend

Axes

Where would you click to indent the first line of a paragraph?

B

You want to add an outside border to a table, at one time. What tool on the ribbon would you use?

B

When you create a formula, you'll always start by typing the ________ sign.

B. = (equals)

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

Backspace key

vertical split bar

Bar going up and down the middle of a split screen

Double space

Based on MLA guidelines, what is the correct line spacing?

Sentences

Basic sentence making Sentence expansion Sentence reduction Sentence transformation Matching sentence parts Sentence completion Sentence comparison

Drafting

Begin writing - don't worry about errors Reread what you have written Reflect, reconsider, evaluate

formula

Beginning with an 'equals sign', a calculation or function that can be entered into a cell

Syntax

Best taught in context As ELLs develop reading skills, exposed to English syntax Introduced to grammar, how words put together to form sentences, mechanics, word forms, and different kinds of sentences (simple, compound, compound-complex)

Amy would like to quickly create a form in layout view so that she can easily modify contents and formatting. Which option uses layout view and gives the user greater control over the form's appearance while displaying the data? Blank Form Form Design Form Wizard Form Tool

Blank Form

Barney would like to create a report in layout view so that he can easily modify contents and formatting. Which option uses layout view and gives the user greater control over the report's appearance while displaying the data? Report Report Design Blank Report Report Wizard

Blank Report

insertion point

Blinking vertical line that indicates where next character typed will display

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

Borders

Trey would like to outline the cell range A1:F20. Which formatting style should he select? Borders Cell style Conditional formatting Former as table

Borders

Pre-writing

Brainstorming ideas is mainly done in which step of the writing process?

splitting

Breaking the Excel window into four panes

Which comman on the Pag Layout Ribbon enables a user to mark where a new page will begin on the printed copy? Print Area Breaks Background Effects

Breaks

Which command on the page layout ribbon enables a user to mark where a new page will begin on the printed copy? Print area Breaks Background Effects

Breaks

Auto Fill Options

Button that allows you to copy values with/without formatting or the format only

Copy button

Button used to copy contents and format of a source area to the Office Clipboard

Decrease Indent

Button used to move the contents of a cell to the left two spaces

Increase Indent

Button used to move the contents of a cell to the right two spaces

Paste button

Button used to paste a copy of the Office Clipboard contents

Scroll Button

Buttons that allow a user to move up or down one line at a time.

Clear Instruction and Teacher Modeling

By explicitly explaining the components and processes involved in completing an academic task and providing models of what a good, completed product should look like, the teacher can provide ELLs with the scaffolds they need to complete an assignment successfully

Where would you click to manually adjust the height of the table's first row?

C

Where would you click to select the first row in the table?

C

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 he use? AVERAGEIF SUMIF COUNTIF TOTALIF

COUNTIF

Preston's form needs to display the tax on an order. Which type of control would allow Preston to display information that would change every day? Bound Unbound Button Calculated

Calculated

Terry's form needs to display the FBLA member's exact age based on today's date and their birth date. Which type of control would allow Terry to display information that would change every day? Bound Unbound Button Calculated

Calculated

On a PivotTable, what is a filed with values not entered as data but determined by a computation involving data in other fields called? Total field AutoSum Calculated Field Analyzed field

Calculated field

Which group on the Formulas Ribbon enables a user to specify when a formula is computed? Function Library Defined Names Formula Auditing Calculation

Calculation

Cancel box

Cancels an entry by tapping or clicking

Citing two authors: Maria S. Castorena, John A. Brown

Castorena, Maria S. and John A. Brown

The area along the bottom of a chart that identifies the categories of data is the:

Category Axis

The intersection of a column and a row.

Cell

Which part of the table is highlighted in the image?

Cell

Another name for a cell reference.

Cell Address

=10+B2

Cell C2 contains the formula "=10+D3". If you copied C2 to A1, what would be the formula in A1?

Nonadjacent range

Cell range that is comprised of two or more separate adjacent ranges.

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

Cell reference and cell location are outlined in matching colors

Mixed reference

Cell reference that contains both relative and absolute references, for example B$4.

Absolute reference

Cell reference that points to a specific cell and does not change when copied; appears with a dollar sign ($) before each column and row designation.

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

Cell style

mixed cell reference

Cell with only one dollar sign before the column or row

Individual entries in the FBLA address book would be entered into a: Cells Database Field Record

Cells

What is the paragraph alignment for the title of the Works Cited page?

Center aligned

Theme

Central idea of a work of literature

All of the FBLA officers have access to the spreadsheet of member contact information. Which feature in Excel allows others to view which officer made changes to the spreadsheet, when the change was made and what changes were made? Track Changes Change History History Names Manager

Change History

Michelle used the property sheet to customize her form in Access. Which task can she complete? Change the background and add captions Enter a new record Move data Switch from Design View to Print Preview

Change the background and add captions

Conditional formatting

Changes formatting of a cell that meets a certain rule

Wildcard

Characters that find words or phrases that contain specific letters, or combinations of letters.

The graphic representation of data in a worksheet.

Chart

Leigh Ann designed a bar chart and would like to add an element above the hart to make the data more meaningful. Which cart feature would she need to include? Axis Chart title Dara Label Legend

Chart Title

surface chart

Chart used to compare data from three columns in a three-dimensional manner

line chart

Chart used to illustrate changes in data over time

pie chart

Chart used to show the contribution of each piece of data to the whole

Spelling button

Checks for apparent misspellings in a worksheet

Role Play Writing

Child assigns message to own symbols - usually in L1 Will talk about or read because of awareness that print carries a message Will dictate to adults Develops growing awareness of features of print First Developmental Phase of Writing

Early Writing

Child uses small range of familiar text forms Chooses topics that are personally significant Begins to use some narrative structure Learns that writing needs to be modified to be read by others Third Developmental Phase of Writing

Experimental Writing

Child writes using simplified oral language structures Sense of sentence and written conventions Aware of one-to-one correspondence between oral and written words Second Developmental Phase of Writing

Select the formula to multiply the quantity and price

Choose "B"

What is the range of the cells?

Choose "D"

Save the workbook "July"

Choose "Save As"

Sort the column from A to Z

Choose "Sort A to Z"

Insert a pie chart

Choose "pie"

Use the fill button to copy the formula

Choose the down arrow, the first one

Sort the column from A to Z

Choose the filter sign

Change the size of the words to 22

Choose the number "22" from the list

You can change the chart type even after it has been created.

Choose the statements about creating charts that is TRUE.

Citing a source

Citing a source means you give a specific quote or idea from someone else's work credit within your writing.

Reports Writing Framework

Classification: generalized participants describing class of things using timeless present tense Description: what attributes does it have? What does it look like? Where it lives- what it does - using linking verbs and action verbs Summarizing components: tell the dynamics of the object of the report - how is it useful? Why is it important?

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

Clear

[Delete]:

Clears the contents of selected cells

Print the highlighted section

Click "Print Area"

Print the highlighted section

Click "Set Print Area"

How would you move sheet tabs to a new position in the workbook? Choose Move on the Home Ribbon Click and drag the sheet tab to the new location Choose Move on the Insert Ribbon Choose Relocate on the Quick Access Toolbar

Click and drag the sheet tab to the new location

Type 1500 for the paycheck for the second half of the month

Click here and type in "1500"

Bold the words highlighted in blue

Click on "B"

Change the page orientation to landscape

Click on "Orientation" then choose "Landscape"

Change the page orientation to landscape

Click on "Page Layout"

Underline the words highlighted in blue

Click on "U"

How do you change the order of the worksheets in a workbook?

Click on a worksheet and drag-and-drop it to the position that you want it in

Copy the highlighted selection

Click on copy sign

To open a new Excel workbook

Click on file (Backstage) tab, select new, choose blank workbook

The steps to build a function in a cell are

Click on formula tab, chose insert function, enter required elements

To select the contents of columns A through C

Click on the column header for A and drag to the column header for C

To select the contents of the entire worksheet

Click on the heading box above row 1 and left of column A, OR Ctrl + A

Change the size of the words to 22

Click on the number 11 first,

Paste "Extra Income" into the active cells

Click on the paste button

Use the autosum button to add up the amounts

Click the "E" button

Save the workbook "July"

Click the "file" button

To create a new worksheet

Click the Insert Worksheet tab, or Right-click on a worksheet tab and select Insert

Enter 230 for health insurance

Click the box after "health insurance" and type in 230

Delete Column A

Click the delete button

Click on column D and make it wider

Click the edge of column D

Which command on the Insert Ribbon inserts a graphic from the Microsoft Office collection into a worksheet? Clip Art Picture SmartArt Instant Art

Clip Art

Curt needs to exit his database in order to work on another database. What action should he take after saving his work? Close Create New Open from Existing Save As

Clse

Dylan is creating an Excel spreadsheet of student schedules for all FBLA members. He would like to show a summary view of all of the first period classes. Which feature would allow him to do this? Group Collapse Subtotal Outline

Collapse

Edward would like to create a chart that uses vertical retangles to compare iPod and iPad sales. Which chart type should he create? Bar Column Line Pie

Column

Which part of the table is highlighted in the image?

Column

Motley

Composed of a variety of sources or having many colors

When using fill down, which is NOT an option

Copy without formatting

Ken has inserted a picture into his spreadsheet that was taken with a low-quality camera. Which tool would allow him to sharpen the image? Picture Styles Artistic Effects Corrections WordArt Styles

Corrections

AutoCorrect feature

Corrects common mistakes when you complete a text entry in a cell

Ashawn has created a table from his database to know which product has the lowest quantity in inventory from his spring catalog. Which aggregate function should he use? Count Max Min Average

Count

Frank needs to know the number of service calls he has received from 123 Walnut Street in one week. Using a calculated field, which total function would he use to answer this question? Average Count Max Sum

Count

Where is the command for creating a new table from Table Design view? File tab Home Ribbon Create Ribbon Database Tools Ribbon

Create Ribbon

The manager of Doggie Donuts needs to group inventory by types of dog food in stock. He needs a subtotal for each group. Which query type will display this information? Select Query Delete Query Crosstab Query Append Query

Crosstab Query

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+Home Ctrl+End Ctrl+Up Arrow Ctrl+1

Ctrl+End

What are three valid methods for saving a database in Microsoft Access? Alt+S, File tab Save command,Quick Access Toolbar Save command Alt+S, Home Ribbon Save command, Quick Access Save command Alt+S, File tab Save command, Shortcut Save command Ctrl+S, File tab Save command, Quick Access Save command

Ctrl+S, File tab Save command, Quick Access Save command

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

Currency

Joan has created a spreadsheet that displays sales of her employees. She would like to view only those employees with sales above $25,000 who are from Region 3. What option will allow her to do that? Ascending Descending Filter Custom Filter

Custom Filter

Alicia needs to move the data in cell B5 to cell E5. Which command would she select? Clear Copy Cut Format Painter

Cut

Which of the following steps are used to MOVE text or an image in a word document?

Cut and Paste

Where would you click to double-space every line in the paragraph?

D

Where would you click to move the text box?

D

Juan is creating a chart graphing attendance at FBLA State Leadership conferences from the past five years which he has in a database. He wants to show individual data values. Which tab in Chart Options would he select? Titles Axes Data Labels Legend

Data Labels

Nick wants to design a database and wants Access to automatically assign an ID number to each record. What is auto numbering an example of? Data Type Description Field Name Properties

Data Type

An address book containing all Fbla members would be an example of a: Cell Database Fields Record

Database

Which command do you use to reduce the margin between the border and the text in an indented cell? Orientation Decrease Indent Column Width Alignment

Decrease Indent

Fill Series

Default Auto Fill option that Excel uses to fill an area

General number format

Default number format that automatically displays number, for the most part, the same way you enter them.

Normal View

Default view in Excel

the second step when planning a table

Define the column headers

Division

Define the following operator: /

the third step when planning a table

Define the row titles

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

Defined Names

font

Defines appearance and shape of letters and numbers

font color

Defines the color of characters

Explanations Writing Framework

Definition of phenomenon: states what the thing or process is Sequenced explanation: timeless present tense Components/ parts: descriptive language about the phenomenon Operations/applications: action verbs describing cause and effect Interesting comments or special features and evaluation - may include passive voice

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

Delete

Which command on the Home Ribbon do you use to remove cells, rows, and columns from a worksheet or table? Delete Remove Format Format as Table

Delete

Which command on the home ribbon do you use to remove cells rows or columns from a worksheet or table? Delete Remove Format Format as table

Delete

Donna's Bakery lost a customer named Doggie Donuts. What action should be taken to remove all records from her database for Doggie Donuts? Delete Query Update Query Append Query Make table Query

Delete Query

Chad needs to remove a student from the FBLA databas. Which option should he choose? Add new Record Delete Record Move Field Edit Record

Delete Record

Tabs

Demonstrate the access to the various groups of commands on the ribbons, Excel includes 8 tabs on the Ribbon.

When the data in a workbook is larger than can be printed on a single page, excel prints:

Depends on the user preference

Table Title

Describes the table's content in a short phrase. Can be either be part of the table or separate. The Table Title is always required.

Nick wants to make notes for future users of his database so they will properly use the field names and types. Where would he make these notes? Data Type Description Field Nae Properties

Descritption

John wantss to change the chart style on his PivotTable. Which PivotTable chart tools tab would he create? Design Layout Format Analyze

Design

Which Chart Tools Ribbon tab enables a user to apply a style to the selected chart? Style Design Layout Format

Design

Which Ribbon is visible when a PivotTable is selected and allows a user to apply various styles to the PivotTable? Layout Options Design Format

Design

Which tab in the PivotChart Tools Ribbon allows a user to apply a chart style to the PivotChart? Design Layout Format Analyze

Design

Which view displays the area used to create a table or to modify the structure of a table? Design Datasheet File Backstage

Design

Riley is using Access to collect data for a science project. He is creating a report and wants to apply predefined color and font scheme formats. Which Report Layout Tools contextual tabs should he select for the theme group? Design tab Format tab Arrange tab Page Setup tab

Design Tab

Ashton needs to add a footer to the data entry form in his gaming database. Which view will allow Aston to add a footer? For View Layout View Design View Navigation Form

Design View

Erin needs to prepare a custom table for her recipe collection. She has to include the ingredient portions. Which is the correct tool to use? Design View Template Sharepoint List Application Parts

Design View

Juan is creating a new database. He wants to assign field names. Which view is BEST to create the new database? Design View Form View Layout View Navigation Pane

Design View

Tanya created a report to show people signed up for a 5K race. She needs to increase the size of the report header so she can add the race logo control. Which view will allow her to resize the header? Report View Print View Design View Layout View

Design View

On which tab can you find the Themes menu?

Design tab

Riley is using Access to collect data for a science project. He is creating a form and wants to apply predefined color and font scheme formats. Which Form Layout Tools contextual tabs should he select for the theme group? Design tab Format tab Arrange tab Page Setup tab

Design tab

document properties

Details about a file such as the project author, title, and subject

the first step when planning a table

Determine the table title

Font size

Determined by point size, which is a unit of measurement equal approximately to 1/72 of an inch.

Conventional Writing

Develops sense of audience and purpose Edits and proofreads own writing after composing Transfers information from reading to writing Senses correct grammar and spelling Reorders elements of text to clarify meaning Fourth Developmental Phase of Writing

Give some examples of information from other sources that need in-text citations.

Direct quotes, rewording of any idea, facts, images

Slide sorter view

Displays PowerPoint slides as miniatures

Fill color list arrow

Displays background color options for a cell

Additions

Document changes that include inserting words and paragraphs

additions

Document changes that include inserting words and paragraphs

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

Document properties

Data definition table

Documentation that lists the fields to be maintained for each record and a description of the information each field will include.

MLA paragraph line spacing

Double space

The steps to create a new file based on a template are

Double-click a template file, and Open Excel, click File, click New, select template to use

Mary has three worksheets that she would like to label as summary, detail and look up. She should

Double-click each tab and type over the highlighted text, or Right-click each one and choose rename, then enter the appropriate name

What is the process of using the mouse to move or copy cells called? Click and Paste Drag and move Dragging Drag and drop

Drag and drop

False

During the editing phase you should not worry about grammar and word usage (t/f)

relative reference

Each adjusted cell reference

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? Edit Comment Show Ink New Delete

Edit Comment

Maria needs to share a form from her database to other members of her work team, but she is not sure everyone has Microsoft Access. She should save the form in which file format to ensure everyone can read the information? PDF XPS Either PDF or XPS DOC

Either PDF or XPS

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? PivotChart Line Chart Embedded chart Linked Chart

Embedded Chart

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 Workbook Row Column

Entry

Formula

Equations with symbols for math operations. Example =B6+B7+B8+B9

Software or Hardware

Everything in a computer system falls into one of two categories:

Which of the following software programs is a powerful spreadsheet program that allows users to organize data, complete calculation, and graph data? Word Publisher Excel Powerpoint

Excel

Insert mode

Excel inserts the character and moves all characters to the right

Overtype mode

Excel replaces the character to the right of the insertion point

Formula view

Excel view in which cell formulas are displayed rather than the values returned by the formulas.

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

Exit

Expository Writing Framework

Explains and clarifies ideas; frequently found in user manuals or textbooks Thesis: overview of topic stating basic position + providing background information Assertions/ arguments: give important points to support stated position with evidence and examples Uses linking words for reasoning, cause and effect

What term refers to an Excel Chart with offset pieces? Exploded Shattered Seperated Detached

Exploded

What is the process of transferring data from an Access database for use in another application called? Exporting Importing Pasting Distributing

Exporting

John wants to create a query that will display the total number of hamburger patties in stock at two different locations. The results should display the sum of the values from each location. Which solution should John use for his query? Crosstab Query Expression Builder Simple Query Totals

Expression Builder

Joshua created a budget workbook that contains the formula =(Summary!B3). "Summary" is an example of a: Named Range External Reference Names Manager Scope

External Reference

Tyler created a monthly sales workbook that contains the formula =(January!B3). "January" is an example of a: Named Range External Reference Names Manager Scope

External Reference

James wants to use an advanced function to search his spreadsheet for a specific string in a text string? REPLACE VLOOKUP SUBSTITUTE FIND

FIND

After reviewing tracked changes, they will no longer appear in your workbook.

False

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

File Tab

Hank wants to add color to the header section if his form. Which formatting option would he use? Fill Color Font Size Font Color Format Painter

Fill Color

What command do you use to apply a background color to cells in a worksheet? Drawing Fill Color Borders & Shading Highlight

Fill Color

The small black square in the lower right corner of a selected cell.

Fill Handle

Which command on the Fill options dialog box is the default option of you enter a month or day? Copy Cells Fill Formatting Only Fill without Formatting Fill Series

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 Filler Copy handle Copy box

Fill handle

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? AutoFill Filter Find and Replace Sort

Filter

Eddie needs to know which employees work in the Southeast District. Which command would he use? Filter Find Sort Ascending Sort Descending

Filter

Kori wants to know how many students in FBLA are seniors, but does not want to save the information. Which operation would she perform? Filter Find Query Sort

Filter

Michelle needs a list of senior National Technical Honor Society members so she can order their tassels for graduation. Which tool would be best to identify only the seniors? Form Filter Controls Theme

Filter

What is the process of viewing a PivotTable report for a subset that meets the criterion only? Filtering Sorting Positioning Arranging

Filtering

Report filter

Filters the PivotTable to display summarized data for one or more field items or all field items in the Report Filter area.

Eddie needs to search for the specific employee that lives on 225 Mayberry Lane. What command would he use? Filter Find Sort Ascending Sort Descending

Find

Mr.Smith needs to know Jennys address. Which command would he use? Find Select Sort Ascending Sort Descending

Find

Which command on the Home Ribbon do you use to replace information in a selected cell with new information or new formatting? Font Format Cell Cell Styles Find & Select

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? AutoFill Filter Find and Replace Sort

Find and Replace

False

Find the five top sales people in a company is an example of what a what-if analysis is. (T/F)

Curt needs to format the numbers in his database to two decimal places. Which number format would he use? Currency Fixed General Number Text

Fixed

Dennis needs to format the numbers in his database to three decimal places. Which number format would he use? Currency Fixed General Number Text

Fixed

Which defines the apprearance and shape of the letters, numbers, and special characters Microsoft Excel? Alignment Font Size Effects

Font

The report Jamie created has a dark background and the page number is not displaying correctly. Which formatting option would he apply to the page number to add contrast between the background and the page number? Fill Color Font Size Font Color Format Painter

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 Font Size drop-down list Fill Color drop-down list Cell Styles drop-down list

Font Color drop-down list

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

Font Size drop-down list

What defines the color of the characters in an Microsoft Excel worksheet? Font size Font color Cell color Background

Font color

Sans Serif

Font with little feet

aphrodisiac

Food or drungs that make men ans women feel more amorous

Kevin created a form to input FBLA membership data. He needs to change the background color of the form so that it displays correctly on mobile devices. Which option provides the tools Kevin will need to modify the form? Blank Form Form Design For Wizard Form Tool

For Design

You are the owner of Ima Graphic Animator, Inc., a graphic design company. You want to quickly create a new blank database object, one which includes one record at a time and a more detailed view of the structure. Which would you use? Table Design Report Design Query Design Form Design

For Design

Michelle needs each National Technical Honor Society member to complete an information sheet. Which tool would be best? Form Filter Controls Theme

Form

Mr. Johnson, the FBLA adviser, is updating the membership database table for the new school year. He wants to define the fields to display and simplify the interface by adding labels and instructions. He would use a? For Table Report Query

Form

Tyler is using Access for a class assignment. Which database object would she use to enter one record at a time? Table Form Macro Report

Form

Jeremy needs to create a quick form based on a single table in his baseball card database. Which option will automatically include all the fields from a single table? Blank Form Form Design Form Wizard Form Tool

Form Tool

Juan wants to view one record at a time in his database. Which view should he be in? Design View Form View Layout View Navigation Pane

Form View

You are employed as an assistant at Doggie Daycare. Your boss asked you to update the new pet patient information. If you opened the form in Design view, which view should you switch to in order to enter patient information? Layout View For View Design View Report View

Form View

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

Format

Linda wants to ensure birthdates are entered as MM/DD/YYYY. Which field property will be used? Look up Format Default Value Field Size

Format

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

Format

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? Insert Form Sort & Filter Format

Format

Which command on the home ribbon do you use to format row height and columns width organize sheets and protect or hide cells in a worksheet? Insert Form Sort and filter Format

Format

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

Format Cells

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

Format Cells

Kenyon would like to convert the cell range A1:F20 to a Medium 19 style. Which formatting style should he select? Cell Style Conditional formatting Fill color Format as table

Format as table

underline

Format that underlines only the characters in a cell, not the entire cell

When a chart is selected, what tabs will appear in the chart tools contextual menu

Format, layout, design

In Microsoft Excel, what do you use to emphasize certain entries and make the worksheet easier to read and understand? Formatting Printing Arranging Configuring

Formatting

In Microsoft excel what do you use to emphasize certain entries and make the worksheet easier to read and understand? Formatting Printing Arranging Configuring

Formatting

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

Formula Auditing

An element in the Excel window that displays the value or formula contained in the active cell is the:

Formula Bar

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

Formula bar

number sign

Formula error messages always begin with this

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

Formulas

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

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 Split Page Break Hide

Freeze

Jenny is entering data to the medication field in the patient database and needs to constantly view patient ID numbers to input medication information. What should she do? Format Freeze Fields Hide Fields Sort

Freeze Fields

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 Split Hide Unhide

Freeze Panes

What feature of Microsoft Excel keeps a portion of a worksheet visible while the other portion scrolls? Zoom Select Freeze Panes Rotate

Freeze Panes

Johns spreadsheet includes multiple pages of records. If John wants to view his headings while scrolling through his spreadsheet what should he do? Freeze panes Split Hide Unhindered

Freeze panes

What is a prewritten formula that is built into Microsoft Excel called? Utility Procedure Function Statement

Function

NOW function

Function that will display the current system date and time

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? Values Formulas Labels Functions

Functions

Johnny has planned his baseball card database and determined a logical arrangement. What is his next step? Determine what information to include Discuess the database with users Gather the information Input data

Gather the Information

Roman numerals

Give one example of something that is NOT a number format in Excel.

Procedures Writing Framework

Goal/aim: describes what is to be done Requirements: explains what is needed to complete the task Steps: first to last telling what is to be done and how Evaluation/testing: was the goal achieved?

Grammar

Grammar begins to have more meaning as students become fluent Use ELLs own papers for mini lessons and relevant points Direct instruction through formal lessons; mini lessons narrow focus (past tense verbs, for example) Students can then look for examples of these forms in their journals or papers - and correct them for practice

Chart

Graph that provides a visual representation of the workbook data.

Dorothy designed a column chart and would like to add an element that will help lead the eye and improve readability of the chart. Which chart feature should she include? Axis Title Chart Title Gridlines Plot Area

Gridlines

Mrs. Wilson needs to create a report that lists students by their homeroom teacher. Each teacher needs a separate list for attendance. Which option would allow Mrs. Wilson to put students together by homeroom on separate sections of the report? Sort Filter Conditional Formatting Grouping

Grouping

Tom wants to search his spreadsheet for a value in the fourth row of his table. What function should he use? HLOOKUPS SEARCH LOOKUP VLOOKUP

HLOOKUPS

Tom would like to show only some rows in his worksheet and would like to choose the row using the data in a column

He should filter the data using the criteria

What are headers and footers?

Headers and footers contain information in the page's margins. The header is at the top and the footer is at the bottom.

document properties

Hidden information such as personal data is added to the document, such as, creator of the document, company name, and keywords.

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

Hide

Joan is showing her spreadsheet to a customer and does not want the customer to be able to see the wholesale prices column, What option should she choose? Freeze Split Page Break Hide

Hide

Select Row

Highlight an entire row

Frank would like to fill a list with the days of the week but wants to leave a blank column between each day. He should

Highlight the first day and a blank cell to the right, use the fill handle to the right

Active Cell

Highlighted worksheet cell that is ready for data entry

Which ribbon includes the commands to apply a quick table style to a range of cells? Home Insert Page Layout Data

Home

Which tab/group combination contains the tool to have text appear at an angle within the cell?

Home/alignment

Right click on the selected cells

How can you access the hide/unhide command for a group of selected cells?

By using parentheses

How can you force a certain order of operations in a formula?

Wrap the text

How can you make a large amount of text visible in a cell without changing the width of the cell?

Double-click the worksheet tab

How can you rename a worksheet?

There is a double line between rows and columns.

How can you tell if the worksheet has hidden rows and columns?

Insert functions, define the name, create the name range, review the formula

How can you use the formulas tab?

Show formulas in a print-out

How could you double-check formulas in a worksheet?

0

How many arguments are used in the following Excel function which returns the current date and time? NOW()

1

How many errors are in the following formula? =(A3+A5+A6)/A5*B1)

2

How many errors are in the following formula? SUM(A2:B10)+(C3/)(E3-E10))

Two

How many errors are in the following formula? SUM(A2:B10)+(C3/)(E3-E10))

4

How many operands are in the following formula? =D4+D13-D15*D13

3

How many operators are in the following formula? =B14+AVERAGE(E1:E50)-D3/D6

format

How you make a worksheet easier to read and understand

Nick wants to immidiately open an employees email from his database.What data type should be used for the email address? Auto Number Currency Yes/No Hyperlink

Hyperlink

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

Hyperlink

nested IF

IF function within an IF function

Range reference

Identification of a cell range using the upper-left and lower-right corners of the rectangular selection of cells.

Rows

Identified by numbers on the left side of the spreadsheet. (Horizontal)

E

Identify the cell.

D Wins

Identify the column.

A Football Standings

Identify the table title

False

If A3=10 and B6=14, what is the result of the logical expression A3=B6

Plagiarizing

If Becky copies a paragraph from a Web site that is not her own and claims that she wrote it, she is ___

True

If a cell has a DARK fill color, then the text color should be: A LIGHT color to create contrast. (T/F)

When copying cells that have formulas with relative references, the formula will work

If the data for the new location is in the same relative location

=F3

If you copied C6 to E3, what would be the resulting cell reference in E3?

True

If you don't want to print out some data on your worksheet, you can hide the rows or columns containing the data. (T/F)

Portrait

If you had a worksheet with 46 rows and 3 columns of data, what would probably be the best page orientation for the worksheet?

Scenario

If you wanted to do an Excel What-If Analysis of a system with eight different inputs which tool would you use?

Paste Options button

Immediately displays when you click the Paste button

What is the process of bringing data containing text fields separated by commas into Excel called? Importing data Data collection Data integration Data migration

Importing data

Non-theme font

In Excel, a font that can be used no matter what theme the workbook has.

Page break preview

In Excel, a view that displays the worksheet as it is divided up into pages. Anything outside of the print area is grayed out.

Page layout view

In Excel, a view that shows how the worksheet will be laid out on the pages sent to the printer.

Print title

In Excel, information that prints on each page.

Row heading

In Excel, the part of a worksheet that identifies each row by a different number.

Column heading

In Excel, the part of the worksheet that identifies each column by a different letter.

Allows you to define input variables in various situations. The output result for each situation is show in a summary table.

In Excel, which statement best describes the What-if Analysis Scenario tool?

Module

In VBA, a collection of sub procedures.

Value field

In a PivotTable, a field that contains summary data.

The left margin

In a block style letter, the lines begin at ___

Relative reference

In a formula, the address of a cell range based on the relative position of the cell that contains the formula and the cell the formula refers to. If you copy the formula, the relative reference is adjusted to reflect the new location of the cell containing the formula.

Leader line

In a pie chart, a line that connects a data label outside of a pie slice to its corresponding label when space limitations force Excel to place a data label far from its slice.

Column

In a spreadsheet grid, each ____is lettered

False

In an Excel table, if you enter a formula in the top cell of a column, the formula would NOT be automatically copied down the column. (T/F)

The formula is automatically copied down the column

In an Excel table, if you enter a formula in the top cell of a column, what would happen next?

Banded rows

In an Excel table, rows of alternating colors that make data easier to read.

True

In an Excel table, to fill a formula down a column, you need to enter the formula in the first cell. Excel will then automatically copy the formula down the other cells in the column.

An operand

In the formula "=D10+15", what part of the formula is the "15"?

An operator

In the formula "=F3+5", what part of the formula is the "+"?

25-13

In this formula, which calculation is performed first? =12*A3*(25-13)

15/3

In this formula, which calculation is performed first? =A2+15/3+100/E4

B4*100

In this formula, which calculation is performed first? =B4*100+15/3

15/3

In this formula, which calculation is performed first? =A2+15/3+100/E4

font style

Indicates how the characters are emphasized

5. A green wavy underline

Indicates the text may be incorrect grammatically

hard copy

Information that exists on a physical medium such as paper

Document Properties

Information that identifies the creator of the document, date the document was created, subject, category, and keywords that can be used to search for the document

Dillano wants to ensure social security numbers are entered in a proper format. Which field property will be used? Input Mask Format Default Field Size

Input Mask

What ribbon contains the commands for creating charts in Microsoft Excel? Home Page Layout Insert Data

Insert

What ribbon tab would you click to insert a shape?

Insert

What ribbon contains the commands used to create a chart in Excel? Home Ribbon Insert Ribbon Formulas Ribbon Data Ribbon

Insert Ribbon

Ashawn has created a table from his database to see his company's income and expenses for the year and now would like to see the totals for each category. Which table feature should he use? Insert a Totals Row Sort by Selection Insert a Chart Create a Relationship

Insert a Totals Row

absolute cell reference

Keeps the same cell reference as it copies a formula from one cell to another

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? Quick Access Toolbar Hot Keys Mini Toolbar Key Tips

Key Tips

enter

Key that can be used in place of the Paste button

HOME

Key that selects the cell at the beginning of a row with the active cell

PAGE DOWN

Key that selects the cell down one worksheet window from the active cell

PAGE UP

Key that selects the cell up one worksheet window from the active cell

Ctrl+v

Keyboard shortcut for paste

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

Label

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

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? Values Formulas Labels Functions

Labels

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

Labels

Legend

Labels that identify the different data series in a chart.

What is an advantage of landscape page orientation?

Landscape lets you put more across the page.

signature line

Last line of text; contact information and call to action

Which ribbon option opens a related dialog box? Ellipse Drop-down Arrow Launcher Slider

Launcher

Which Chart Tools Ribbon tab allows a user to insert various labels on the chart? Style Design Layout Format

Layout

Which tab in the PivotChart Tools Ribbon allows a user to apply chart titles to the PivotChart? Design Layout Format Analyze

Layout

Juan is creating a chart graphing attendance at FBLA State Leadership conferences from the past five years from his database. He wants to display a list of colors, shapes, or patterns used as categories in a chart on the right side. Which tab in Chart Options would he select? Titles Axes Data Labels Legend

Legend

John has created a Pivot chart and would like to include a guide that would display the names of the series of data included on the chart. Which option would allow him to do this? Report Filter Legend Fields Axis Fields Values

Legend Fields

Amanda wants to ensure there are only two charcters for state abbreviation. What should she do? Unique Identifier Limit Field Size Provide a Descritpion Provide Database Security

Limit Field Size

MLA Style Guide

MLA stands for Modern Language Association. MLA is an academic style guide generally used in humanities courses, such as music, art, history and English.

Susie has a relational database for her catering business. She wants to create a form which shows the data in a customer table one record at a time. This type of form is a: Main Form Subform Hierarchical Form Datasheet

Main Form

Which term describes the blank portions of a page that fall outside the main body of the printed document? Borders Edges Frames Margins

Margins

Which term describes the blank portions of a page that fall outside the main body of the printed document? Borders Edges Frames Margins

Margins

Carol has created a table from her database to see all information about FBLA chapters in her region. She needs to know which chapter has the most active members in the region. Which aggregate function should she use? Count Max Min Average

Max

4. A red wavy underline

Means the flagged text is not in Word's dictionary

Rulers

Measuring tools to align text, graphics, and other elements used within a document.

Mnemonic

Memory

Which command on the Home Ribbon joins selected cells into one and centers that content into a larger single cell? Wrap Text Group Cells Cell Styles Merge & Center

Merge & Center

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

Merge and Center

True

Merging cells means to combine 2 or more cells into a single cell. (T/F)

Which software program is used to create a database on a computer, add, change, and delete data in the database and create queries, forms, and reports using the data in the database? Microsoft Access Microsoft Excel Microsoft OneNote Microsoft Outlook

Microsoft Access

True

Microsoft Excel can use Headers & Footers, just like Microsoft Word.

False because Headers and Footers both work on Excel

Microsoft Excel can use Headers but not Footers, just like Microsoft Word.

Which is NOT a file type that may be imported into Microsoft Access? Text files HTML files Microsoft Publisher files Microsoft Excel files

Microsoft Publisher files

Ashawn has created a table from his database to know which product has the lowest quantity in inventory from his spring catalog. Which aggregate function should he use? Count Max Min Average

Min

Frank needs to know which employee has used the least amount of sick leave. Using a calculated field, which total function would he use to answer his question? Average Count Max Min

Min

Admixture

Mixture

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

Move

[Ctrl][Home]

Moves cell pointer to cell A1

Deletions

Mutation involving the removal of one or more nucleotide pairs from a gene

Sally is the National Technical Honor Society president. She is creating a database to manage her membership information. What form tool could she use to quickly create a set of tabs a user could click to access forms and reports in the database? Form View Layout View Design View Navigation Form

Navigation Form

name box

Next to the formula bar, the place a cell's name or cell reference is specified

formula bar

Next to the name box, a cell's data or formula is displayed here when you select the cell

If you are looking at a document with read-only protection, which of the following commands will be enabled?

None of the commands listed are available

Which view is the default view used in Microsoft Excel? Page Layout Print Normal Web

Normal

What group of tools on the home tab allow a user to switch the format of numbers

Number

Constant values consisting of only numbers.

Number Values

How are the number of columns calculated?

Number of columns = Number of column headers

How are the number of rows calculated?

Number of rows = Number of row titles + One.

volatile function

Number that the function returns is not constant

What two types of lists can be created in Microsoft Word?

Numbered and Bulleted are two types of lists that can be created in Microsoft Word.

Horizontal (category) axis

On the horizontal axis, or x-axis, are the data series' category values, or x values.

Which type of relationship means that a record in the first table is related or matches ore than one record in the second table? One to one Many to many One to many One to any

One to many

ScreenTip

Onscreen text that appears when you position the mouse pointer over certain objects, such as the objects on the taskbar or a toolbar button. ScreenTips tell you the purpose or function of the object to which you are pointing.

Curt needs to finish a database project from yesterday. What action should he take in order to start working on the database? Close Create New Open From Existing Save As

Open from Existing

What format is used for in-text citations?

Open parenthesis, author's last name, space, page numbers in source, close parenthesis.

Clicking on the zoom indicator will

Open the zoom dialog box

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

Orientation

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

Orientation

Landscape and portrait are

Orientations

What can you click to start a new page in a document?

Page Break

Which ribbon contains the command to apply a theme to a worksheet in Microsoft Excel? Home Page Layout Data View

Page Layout

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

Page Layout

What layout is similar to the print review

Page layout

When printing pages, to keep the top 2 rows of data on every page

Page layout tab, print titles, and select rows to repeat

Which of the following items is the most important piece of information to include in a page header or footer?

Page number

Change the paragraph alignment or spacing. (2.3)

Paragraph panel

Arguments

Parameters added to a function that help in evaluating data, or performing calculations

Name box

Part of the Excel program window that displays the active cell address

When copying and pasting data, which paste option should be used to insert the data but not the original style

Paste special, paste

Revising

Phase of the writing process is it best to have other people review your document

Ken has inserted a picture into his spreadsheet and would like it to standout with a frame or 3D effect. Which tool would he use to achieve this? Picture Styles Artistic Effects Corrections WordArt Styles

Picture Styles

Which is the name of an interactive graphical representation of data tat allows a user to change the groupings? PivotChart PivotTable PivotDate Rotate Table

PivotChart

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

PivotTable

Which is an interactive view of worksheet data that gives a user the ability to summarize the data by selecting categories in which to group the data? PivotChart PivotTable PivotDate Rotate table

PivotTable

Insert Row/Column

Placing a new, blank row or column in the spreadsheet.

Dorothy designed a column chart and would like to change the background color to yellow. What chart feature should she modify? Axis Title Chart Title Gridlines Plot Area

Plot Area

centered

Positioned horizontally between the left and right margins

Researching information is mainly done in which step of the writing process?

Pre-writing

What is the first step in the writing process?

Pre-writing

Revision Process

Present this as an integral part of writing process, early on Focus on the audience + purpose (make essay memorable and interesting) In Editing, pay attention to: - Coherence - Organization - Development - Mechanics

In a table which is a way of exclusively identifying each record in the database? Unique marker Primary key Primary marker Primary category

Primary Key

Wendy needs to print to the color printer instead of the default printer on her computer. Which option would give her the choice to change the printer? Print Preview Quick Print Print Selected Records

Print

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

Print Area

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

Print Entire Workbook

Wendy wants to be able to see what her database report will look like without producing a hard copy. Which option would she choose? Print Preview Quick Print Print Selected Records

Print Preview

William has created a report. Which view could he use to see exactly how the report will look on paper? Report View Print Preview Design View Layout View

Print Preview

If you are printing a worksheet and want the headings to appear on every page, click the

Print Titles command.

John wants to print only the inventory worksheet that he is currently working on in his workbook. Which option should he choose? Print selection Print active sheet Print entire workbook Fit sheet on one page

Print active sheet

Jessica needs to capitalize the first letter in each word. Which function would she use? Upper Trim Lower Proper

Proper

Nick needs to specify two characters for the student ID field. What area of design view would he access to specify this? Data Type Description Field Name Properties

Properties

automatically updated properties

Properties that include system file properties

What command limits structural changes, such as adding, deleting, or moving sheets, that can be made in a workbook? Protect Workbook Protection Protect Sheet Share

Protect Workbook

Writing Frameworks

Provide structure for guided writing activities Shape and limit linguistic demands of specific writing tasks Support teachers in analyzing language and structure or varieties of text and literary genre

Graph

Provides a visual representation of the workbook data.

Quick Access Toolbar

Provides access to commonly used tasks like saving or printing a document, undo,redo, and new

Descriptive Writing Framework

Provides information about person, place, or thing Descriptive writing may be fictional (story) or non-fictional (newspaper, summary)

Beth needs to determine the seniors with a GPA of 4.0 or higher. Which object would allow her to create a saved search to find this information in the database? Form Table Query Report

Query

Curt wants to search his CD collection database for the names of the albums from his favorite artist that were released after 2010. What object should Curt create and save to obtain this information most efficiently? Filter Table Query Report

Query

Keisha created a database of her music. She wants to locate only the songs by Beyoncé. What tool should she use in order to view this information and save it for later use? Filter Form Query Report

Query

Which is a way to qualify data by specifying a matching condition or asking a question of the data? Insert Sort Query Probe

Query

Joe wants to modify the query he created to incorporate various colors, fonts and styles to create a custom look. Which query would he use? Design View Simple Query Wizard Query Design View Query Wizard

Query Design View

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

Quick Access Toolbar

A feature that displays in the lower right corner of a selected range with which you can analyze your data by using Excel tools such as charts, color-coding, and formulas is called:

Quick Analysis Tool

Wendy wants to send the database report directly to the printer without editing. Which option should she choose? Print Preview Quick Print Print Selected Records

Quick Print

The FBLA Advisor at your school would like to create random ID numbers for FBLA members at your school. Which function would allow her to have Excel pick a random number between 1000 and 5000 for the new member ID numbers? RANDOM(1000,5000) RAND BETWEEN(1000,5000) RAND() BETWEEN(1000,5000)

RAND BETWEEN(1000,5000)

brown

REPRESENT SIMPLICITY HONESTY AND DEPENDABILITY

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

Range

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

Range

A feature that outlines cells in color to indicate which cells are used in a formula is called:

Range Finder

destination area

Range of cells receiving the copy

Ali has worked for years cataloging his comic book collection into a database. Recently his computer crashed, but fortunately he has a backup on his Skydrive. Which method should he use to restore his database on his new computer? Backup Recover from Backup Save to External Locations Previous Version

Recover from Backup

Kirtan has worked for years cataloging his music collection into a database. During a recent storm, Kirtan's computer was damaged, but fortunately he has a backup on his flash drive. Which method should he use to restore his database on his new computer? Backup Recover from Backup Save to Exernal Locations Previous Version

Recover from Backup

Which ribbon tab would you select to insert a table of contents?

References

Revising

Refining and organizing your writing is done in which step of the writing process?

Which type of database consists of a collection of tables, each of which contains information on a specific subject? Relational Interactive Collaborative Independent

Relaitonal

What type of database contains multiple collections of data that are related to one another? Joined Relational Flat Managed

Relatina;

Chthonic

Relating to the underworld

When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location? Absolute reference Certain reference Variable reference Relative reference

Relative reference

Interlanguage Development

Reliance on L1 proficiency visible in L2 writing Errors in syntax and grammar present in oral speech also occur in writing Spelling may reflect L1 letter-sound correspondence

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

Rename

Avery is the president of her FBLA chapter. FBLA keeps all member information in a database. She is often asked by members to pull a detailed summary of all competition participation for scholarship applications. Which report creation tool will automatically pull all the fields from the competition table? Report Report Design Blank Report Report Wizard

Report

Keisha wants to print her completed music databases. Which tool would she use? Filter Form Query Report

Report

Margaret wants to send an address change to all the customers in her current database. She wants to create address labels to accomplish this. Which would she use? Form Report Table Query

Report

Tyler is using Access for a class assignment. Which database object would she use to organize and display data pulled from tables and queries? Table Form Macro Report

Report

Which ribbon displays report printing options? Report Design Tools Design Ribbon Report Design Tools Arrange Ribbon Report Design Tools Format Ribbon Report Design Tools Page Setup Ribbon

Report Design Tools Page Setup Ribbon

You are the owner of Ima Graphic Animator, Inc., a graphic design company. You want to place your logo at the top of the first page on a report. Where would you place the logo in the Report Design View? Report header section Page header section Report footer section Page footer section

Report Header Section

Which ribbon in layout view contains the commands to insert or delete new rows and columns in a report? Report Layout Tools Design Report Layout Tools Arrange Report Layout Tools Format Report Layout Tools Page Setup

Report Layout Tools Arrange

Which protection option would you choose if you wanted to prevent people from viewing your document?

Require a password

Pre-writing

Researching information is mainly done in which step of the writing process?

Where is the spellchecker located? View Ribbon Home Ribbon Review Ribbon Page Layout Ribbon

Review Ribbon

Refining and Organizing your writing is done in which step of the writing process?

Revising

Which phase of the writing process is it best to have other people review your document?

Revising

Which toolbar contains most of the commands that you'll need in Excel 2013?

Ribbon

What alignment options are available?

Right align, Left align, Center, Justify

To insert a comment into a cell

Right-click in the cell select insert comment

How do you quickly modify a table style to meet user preferences? Right-click on a style and choose Modify Right-click on a style and choose Duplicate Double-click a style from the Table Quick Styles Gallery Choose Modify from the Styles Group on the Home Ribbon

Right-click on a style and choose Duplicate

What tab/group combination is used to change the type of chart used

Right-click on the chart and select change chart type, OR Chart tool tab

To change the color of a worksheet tab

Right-click on the tab and choose tab color, or Click on the worksheet tab, click Home, click Format, choose Tab Color

How is an exact copy of a worksheet created within the same workbook? While pointing to the sheet tab, choose Copy from the Shortcut Menu Right-click the sheet tab, then choose Move or Copy from the Shortcut Menu While pointing to the Select All button, choose Move or Copy from the Shortcut Menu Choose Move or Copy from the Quick Access Toolbar

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

Which command on the Page Layout Ribbon enables user to flip objects on a worksheet? Align Arrange Group Rotate

Rotate

A horizontal group of cells in a worksheet

Row

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

Row

Sharon's spreadsheet contains information about the number of music downloads in F25. 25 identifies the Cell Column Rnage Row

Row

After a query is created, which action must take place to display the results of the query? Go Run Get Retrieve

Run

Peter wants to replace a specific text in a text string in his spreadsheet. What function should he use? FIND SUBSTITUTE VLOOKUP SEARCH

SUBSTITUTE

Which function would you use to add the values of several cells?

SUM

Jane wants to add a range of cells in her spreadsheet. She would like Excel to add only the cells in that range that are greater than 1,000. What function should she use? COUNTIF SUMIF AVERAGEIF TOTALIF

SUMIF

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

Save

Curt needs to create a backup to his existing database on an external hard drive. What action should he take? Close Create New Open from Existing Save As

Save As

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

Save As

Marty has spent a lot of time creating a database to track her sales contacts which she has been asked to share with her colleagues. What would be the best method of sharing the structure of a database, including relevant tables, queries, and forms? Save As Save as Database Template Create a Backup Save as PDF

Save as Database Template

Rachel has spent a lot of time creating a database for her FBLA chapter which she has been asked to share with other chapters in her Region. What would be the best method of sharing the structure of a database, including relevant tables, queries, and forms? Save As Save as Database Template Create a Backup Save as PDF

Save as Database Template

Which command on the Insert Ribbon enables a user to insert a picture of a part of a screen into worksheet? Shapes Picture Cropping Screen Clipping Screenshot

Screen Clipping

Which command on the Insert Ribbon enables a user to insert a picture of a program window into a worksheet? Shapes Picture SmartArt Screenshot

Screenshot

sensitivity analysis

Scrutinizing the impact of changing values referenced by a formula in a cell

Disk

Secondary storage medium for random access data storage available in permanently installed or interchangeable formats

Proficient Writing

Seeks precision in word usage and meaning Uses plan to organize ideas Uses variety of simple and complex sentences Develops topic fully Can take reader's point of view Fifth Developmental Phase of Writing

A box in the upper left corner of the worksheet grid that selects all the cells in a worksheet is the:

Select All Box

To move the contents of cell B4 to F10

Select B4, roll over the edge of the cell and drag the cell to F10, OR Select B4, right-click and select Cut, click on F10, right-click Paste

Margo would like to have the contents of cell F12 turn red if the value falls below 12, what steps should she take?

Select Cell F12, choose home tab/cells/conditional formatting

Which command do you use to remove manual page breaks from a worksheet area? Select break, press Delete on keyboard Select Remove Page Break from the Breaks drop-down area Select break, press Backspace on Keyboard Select break, press Remove Page Break from Shortcut Menu

Select Remove Page Break from the Breaks drop-down area

What is the sequence to use to change the format of data in a cell

Select cell, choose home tab, cells grouping, format

Delete column A

Select column A

Frank would like to move the contents of column F in between the A and B columns he should

Select column F, choose cut, click on the column header for B and choose insert cut cells

Creating a chart follows these basic steps

Select data, choose chart, adjust format

John would like to add a banner at the top of his spreadsheet. Which object should he insert? Shapes Picture SmartArt Screenshot

Shapes

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? Tracking Changes Share Workbook Protect Workbook Export

Share Workbook

The labels along the lower border of the Excel window that identify each worksheet.

Sheet Tabs

To reference the data from cell b5 on sheet 1, a different sheet in the same workbook the syntax is

Sheet1!(b5)

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

Shortcut Menu

No

Should you be concerned with grammar and spelling during the Drafting phase of the writing process?

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

Show

Column Header

Show the main categories of information in a table. Are at the top of a table so readers can scan to see what's in the table. Column headers are always required

Bubble Chart

Shows patterns between two or more sets of data. The size of the data marker is determined by the 3rd value.

Doughnut Chart

Shows relative values of different categories to the whole. Displast multiple sets of data.

Stock Chart

Shows stock market data like highs, lows, opening price and closing price.

Name Box

Shows the address of the active cell Ex: A1

date stamp

Shows the date a workbook was created or the time period it represents

sparkline chart

Shows trends and variations in a range of data within a single cell

Insertion Point

Shows various forms based on the function being performed and the location to which the mouse is pointing. When you are inserting text, it is an I-beam.

Taylor wants to query the airline database to find out how many seats are open on Flight 33. What type of query would she use? Crosstab Query Multiple Query Simple Query Find

Simple Query

Jane wants to determine how many FBLA students have registered for the state conference from the Coastal region. Which query view would she use? Design View Simple Query View Query Design View Query Wizard

Simple Query View

Sentence Transformation

Singular to plural Change of tenses Declarative to question Statement to command Positive to negative statement Adjective and adverb changes Phrase order changes

Which group on the Form Tools Arrange Ribbon allows the user to align to grid? Merge/split Move Position Sizing & Ordering

Sizing & Ordering

What can you use to easily filter PivotTables and cube functions interactively in a worksheet? Slicer Cutter Division Sliver

Slicer

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

Slicers

The fill data handle looks like

Small black plus sign

fill handle

Small black square located in the lower-right corner of the active cell

Micro computer

Small computer designed for use by an individual

Mr. Brown's report needs to be arranged by last name and first name. What tool can he use to ensure that students appear in alphabetical order on his report? Sort Filer Conditional Formatting Grouping

Sort

Which command on the Home Ribbon do you use to organize data in ascending or descending order? Find & Select Format Cell Sort & Filter Organize

Sort & Filter

Eddie works for ABC Finance. He needs to view which employees has the lowest sales for the month. Which command should he use? Filter Find Sort Ascending Sort Descending

Sort Ascending

Eddie works for ABC Finance. He needs to view which employees has the highest sales for the month. Which command should he use? Filter Find Sort Ascending Sort Descending

Sort Descending

What ensures that a query result appears in a specific order? Filtering Sorting Ordering Placing

Sorting

Ascending order

Sorts text alphabetically from A to Z, numbers from smallest to largest, and dates from oldest to newest.

Descending order

Sorts text in reverse alphabetically from Z to A, numbers from largest to smallest, and dates from newest to oldest.

False

Source Data!B12 is a cell reference that will not result in an error. (T/F)

Which is a tiny chart that provides a visual representation of data in a worksheet cell? Trendline Sparkline Dataline Flashpoint

Sparkline

Tiny charts embedded in a cell that give a visual trend summary alongside your data are:

Sparklines

Argument

Specifies the numbers, text, or cell references used by a function to calculate a value.

font size

Specifies the size of characters

Mechanics

Spelling, punctuation, capitalization, grammar Teaching mechanics one goal of Language Arts instruction Taught systematically over course of school years

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

Split

Another name for a worksheet.

Spreadsheet

Derivational Relations (Spelling)

Stage Five of Spelling Teach root words and derivational affixes Make word clusters using root words Sort words into roots or language of origin

Syllables and Affixes Spelling

Stage Four of Spelling Teach rules of syllabication and inflectional endings Teach schwa sounds and spelling patterns Teach homophones, contractions, compound words, possessives

Emergent Spelling

Stage One of Spelling Students experiment with spelling Teacher models adult writing, encourages ELLs to talk about their writing, notice environmental words and letters in names

Within-Word Spelling

Stage Three of Spelling Teach long vowel spelling rules, vowel digraphs, r-controlled vowels; use interactive writing Develop visual sense of whether word looks right or not Focus on silent letters in one-syllable words Have students sort words according to patterns

Letter-Name Spelling

Stage Two of Spelling Instruction in how to form letters Encourage listening to pronunciation of words Post a word wall; teach consonants, consonant digraphs, short vowels

Conditions

Statements in a formula that can be evaluated as true or false, and then return an appropriate value if true, and another value if false.

You can enter a cell references in a formula by typing in the reference. You can enter a cell reference in a formula by clicking the cell location on the spreadsheet. Cell references make it easy to use values from other cells in a formula.

Statements that ARE true about cell references.

When a database is created what is defined when names and data types are assigned to all data fields in a table? Structure Definition Design Theme

Struture

Which Chart Tools Ribbon tab allows a user to select from a gallery of chart styles? Style Design Layout Format

Style

What Home Ribbon group contains the command used for quickly converting selected cells to a table by choosing a table style? Styles Alignment Editing Font

Styles

Susie has a relational database for her catering business. She wants to create a form which shows the the customer information at the top and any orders for that customer at the bottom. The orders section of the form is a: Main Form Subform Hierarchiacal form Datasheet

Subform

Dylan is creating an Excel spreadsheet of student schedules for all FBLA members. He would like to know how many members are in the same first period class. Which feature would allow him to do this? Group Collapse Subtotal Outline

Subtotal

What function adds all of the numbers in a range of cells? Calculate Sum Compute Add

Sum

Which of the following is the default method for summarizing data in a PivotTable? Count Average Max Sum

Sum

Comparison operator

Symbol that indicates the relationship between two values.

###

Symbol that represents an Excel numeric field that is too wide to display

format symbol

Symbols that assign a format to numbers as they are entered

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

TODAY

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

Template

Chart title

Term that appears above the plot area and describes the contents of the plot area and the data series.

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

Text

Isabel wants to design a database for her FBLA club to include all the members information. What data type should she use for Last Name? Text Memo Number Date/Time

Text

Jenny is setting the addresses for each patient. Which data type should she use? AutoNumber Currency Number Text

Text

Data

Text or numbers in a cell

True

The Autofill automatically fill cells with information based on other selected cells. (T/F)

Data series

The Chart Wizard organizes data sources into a collection, where each data series is a range of data values that is plotted as a unit on the chart.

workbook

The Excel document that holds all the worksheets

File Tab

The File Tab explains the access to the Excel Options dialog box and provides control to create new documents, save and print documents, as well as several other features.

True

The Margin controls adjust the amount of white space around the outside of the printed page. (T/F)

The amount of white space around the outside of the printed page

The Margin controls adjust what part of the worksheet?

True

The What-if Analysis Scenario tool allows you to define input variables in various situations. The output result for each situation is show in a summary table. (T/F)

Font Style

The ___ defines of letters, numbers, and special characters

Time management

The ability of a computer to execute more than one program at a time

Line Spacing

The ability of a program to automatically change vertical line spacing

drag-and-drop editing

The action of using a mouse to drag a selection from its original location and drop it in a new location.

Series values

The actual data displayed in a chart.

Cell reference

The address of a cell indicating its column and row location.

Principal

The amount of money being loaned.

Formula bar

The bar located above the workbook window in which the contents of a cell are displayed.

Active Cell

The cell ready for data entry

Replace

The command to overwrite letters and numbers in a workbook with another entry.

B-The headings would be pasted, and overwrite the kitchen data.

The data in the dotted box was copied into the clipboard. What would be the result if you did a PASTE command in the selected cell?

Workbook

The file in which Excel stores an electronic spreadsheet.

PMT function

The financial function to calculate the amount paid into an investment or loan during each payment period.

Primary sort field

The first sort field

Data marker

The graphical representation of the values in the data series of a chart, including items such as each column in a column chart, the pie slices in the pie charts, and the points used in XY (scatter) charts.

Row

The horizontal reference in a spreadsheet

Perspective

The illusion that some parts of the 3-D chart are farther away from you than others.

The clipboard

The immediate holding area in internal storage for information en route to another application is called___

Major tick mark

The indication of the major units of increment on the x- or y-axis.

Minor tick mark

The indication of the minor units of increment on the x- or y-axis.

A - Down-arrow key twice and then the left-arrow key

The insertion point is in the circled cell. What would you need to press to move the insertion point to the cell indicated by the "A".

Software

The instructions that a computer needs to perform various functions

Cell

The intersection of a column or row in a worksheet.

Cell

The intersection of a row and a column is a ___

Cell address

The intersection of a row and column

Ctrl

The key presses to select non adjacent cells of data to create a chart

Supercomputers

The largest, fastest, and most powerful of all types of computers are called ___

Ken

The limits of your knowledge, your understanding

ROM

The memory area in which all programs and data must reside before programs can be executed or data manipulated is called ___

Median

The middle value in data.

Mode

The most common value in data.

Cell Address

The name of a cell; contains both the column and row reference

Series name

The name of the data series.

Scroll Bars

The navigation buttons are located on the bottom of the vertical and horizontal scroll bar to move up, down, left or right in the typing area

The number of column headers

The number of columns in a table is equal to:

The number of row titles, plus one

The number of rows in a table is equal to:

Portrait

The orientation of a document where the page is taller than it is wide.

Landscape

The orientation of a document where the width is greater than the height.

cell

The place data is entered; the intersection between a row and a column

Freeze

The process of keeping rows and/or columns you select visible in the workbook window as you scroll the worksheet.

Sort

The process of rearranging data in a certain order, such as ascending or descending.

Filter

The process of temporarily hiding records that do not meet the specific criteria.

True

The quickest way to enter a function in a cell if you already know the name of the function is to directly enter the function in the cell. (T/F)

Scale (n)

The range of values that spans along an axis.

Animation

The rapid repositioning of objects on the display screen

Header row

The row of field names.

Domain Name

The second part of an email address, after the @ symbol

Secondary sort field

The second sort field.

Active cell

The selected cell in the worksheet; indicated with a dark border.

Custom list

The sequence you specify to sort data.

arithmetic operations

The simple mathematical functions: plus, minus, multiplied by, and divided by

Fill handle

The small black square in the bottom right corner of as cell that allows you to fill adjacent cells with a repeated formula

Margin

The space between the page content and the edges of the page.

Typeface

The specific design of a set of printed characters, including letters, numbers, punctuation marks, and symbols.

Chart Title

The title or name of chart usually identifying what data depicts, most often found at center top of chart area

Simple interest

The type of interest in which the interest paid is equal to a percentage of principal for each period that the money had been lent.

Point

The unit used to measure the size of the characters in a font.

Points

The unit used to measure the size of the characters in a font.

y-axis

The vertical line on a graph

Column

The vertical reference in a spreadsheet

Normal view

The view that renders the workbook and worksheets for the computer screen.

Source file

The workbook that contains the data when two files are linked.

Destination file

The workbook that receives the data when two files are linked; sometimes referred to as the dependent file.

Active workbook

The workbook you are currently using.

Active sheet

The worksheet currently displayed in the workbook window.

Vertical (value) axis

The y-axis where, for example, data values, such as sales values, are plotted.

Michelle wants to change the color of her form to make it more attractive. Which should she use? Form Filter Controls Theme

Theme

What feature can you use to easily change the look of the whole document?

Theme

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

Theme

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

Theme

When the mouse pointer turns into 2 parallel lines with arrows in opposite directions it means:

There is a hidden row/column

=5+A1*B1

This formula is a complex formula.

Roman Numerals

This is NOT a number formats in Microsoft Excel?

Thumbnail

Tiny images of your document pages.

Susie wants to locate the file name of her current document.Where should she look? Rename Navigation Pane Title Bar Status Bar

Title Bar

Juan is creating a chart graphing his inventory database. He needs to name the chart August Inventory Report. Which tab in Chart Options would he select? Titles Axes Data Labels Legend

Titles

Dun

To insist on the payment of a debt

Autofit

To make a column or row as it needs to be to fit the data contained in the cell, Determines the best width for a column or the best height for a row, based on its contents.

Merge and Center

To make one cell out of several highlighted cells and then center the content of that cell

Why might you choose to use a Style on your title?

To make the title stand out.

Gad

To move about or travel in a aimless way

Drag and drop

To move an item (either text or a graphic) by selecting it and dragging it with the mouse.

CTRL + END

To move the insertion point to the very end of a Word document

Sow (v)

To plant a seed

Hex (v)

To put an evil spell on someone

Clear

To remove

Delete

To remove a cell or cells from a worksheet, shifting the remaining worksheet cells into the space previously occupied by the deleted cell or cells; also to remove a worksheet entirely from a workbook.

Cut

To remove data from a cell and place it on the Office Clipboard.

Rename sheet

To rename a sheet in a workbook. Right click the sheet tab ,click rename.

Save As on the File Menu

To save a document with a different file name, click

zoom out

To shrink the appearance of a worksheet or chart

Descending order

To sort data in Z>A order

Refresh

To update

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 Weekday Date CurrentDate

Today

Lilly is creating a spreadsheet for FBLA and would like to see the changes advisors have made to the workbook. What command allows her to do this? Export Share Workbook Tracking Changes Protect Workbook

Tracking Changes

Uploading

Transferring information from a client computer to a host computer

What graphically represents trends in plotted data and predicts future values? Sparkline Trendline Chartline Error Bar

Trendline

Dean needs to add the FBLA logo to the top of his membership form. Which type of control should he use? Bound Unbound Button Calculated

Unbound

Keton wants to add a graphic by one of the fields on his form. Which type of control will he add to the form? Bound Unbound Button Calculated

Unbound

Tammy wants to add instructions by one of the fields on her form to ensure that the data is entered correctly. Which type of control will she add to the form? Bound Unbound Button Calculated

Unbound

The data that displays in the Formula Bar is referred to as the:

Underlying Value

John notices that column D is not showing on his spreadsheet. What action does he need to take to view column D? Freeze Panes Split Hide Unhide

Unhide

What type of query enables a user to make the same change to all records satisfying a certain creterion? Update Append Action Make table

Update

Elizabeth needs to convert all text in Column A to uppercase. Which function should she use? Proper Upper Lower Trim

Upper

When should you use a table in a document?

Use tables to organize large or complex sets of information, that are beyond the capabilities of lists.

Telecommunications

Used in the process of sending and receiving information by means of telephones, satellites, and other devices

Letters

Used to identify columns in a spreadsheet

Numbers

Used to identify rows in a spreadsheet

Legend

Used to identify the format of the data marker used for each series in a chart. Used if the chart contains more than one data series.

Equal Sign

Used to indicate the start a formula

drag and drop

Using touch or the mouse to move or copy cells

Jill wants to search her spreadsheet for a value in the first column of her table. What function should she use? HLOOKUP VLOOKUP LOOKUP SEARCH

VLOOKUP

What are the rules that a user should follow when entering data into a table? Text Validation Criterion Properties

Validation

Data label

Value or name assigned to individual data points.

John would like to display the count of employees last name on the y-axis. What area would he drag this information to in order to display correctly? Report Filter Legend Fields Axis Fields Values

Values

assumptions

Values in cells that you can change to determine new values for formulas

Font style

Various ways that fonts can be displayed, such as regular, italic, bold, or bold italic; a special attribute applied to the characters of a font.

Column

Vertical block of cells in a table or spreadsheet

Asiah has created a senior information form from her student table. She wants the parent's home phone text box to have the exact same width as the cell phone text box. What tool would she use to ensure they are exactly the same? Tab Order Add Existing Fields View Code Property Sheet

View Code

Across

What direction does a row go?

Font style

What do you update when you change normal text to a heading?

Internet Service Provider

What does ISP stand for?

Hides data that you do not want to see

What does filtering data in a spreadsheet do?

Combine 2 or more cells into a single cell.

What does it mean to merge cells?

=SUM(B3:B6)

What function should be entered to calculate the TOTAL budget?

=MIN(B3:B7)

What function would you use to find the least expensive item?

The column doesn't appear, but the data is still there.

What happens when you hide a column in Microsoft Excel?

Footer

What is the block of text at the bottom of the page called?

Header

What is the block of text at the top of the page called?

Send to back

What option would you choose to move the selected item, to the last layer?

Portrait

What page orientation has more room up and down the page?

Column headers

What part of the table describes the main categories of information in a table?

Insert

What ribbon tab would you click to insert a text box?

References

What ribbon tab would you select to insert a table of contents?

Ctrl+X then Ctrl+V

What sequence of keyboard shortcuts would you use to MOVE information from one cell to another?

Find the five top sales people in a company

What statement is NOT an example of a what-if analysis?

Cut and paste

What steps are used to MOVE text or an image in a Word document?

$

What symbol is used to designate an absolute cell reference?

Number

What tab group would you use to change the format of cell A2 to match cell A3?

Presentation software

What type of software should you use for computer-generated slide presentations?

The worksheet will be MOVED

What will happen when you drag and drop a worksheet tab into another workbook WITHOUT holding the Ctrl key down?

It will be copied after "Sheet3" in the Sample workbook

What will happen with the selected worksheet when "OK" is clicked in the "Move or Copy" dialog window?

Table

What wold be the best option to organize a large amount of information?

Down-arrow key twice and then the left-arrow key

What would you need to press to move the insertion point to go down and across to another column?

Common knowledge

When gathering information from another source, which of the following does not need an in-text citation?

Define the row titles

When planning a table, what step comes first: "define the row titles" or "calculate the number of columns/rows"?

Alphanumeric

When something consists of numbers, letters, and symbols it is considered ___

Active Cell

When the cell pointer is located in A1 in Excel, then the cell is called an ___

False

When using conditional formatting on a cell, highlighting negative numbers by using red text does not occur. (T/F)

You want to highlight negative numbers by using red text.

When would you use conditional formatting on a cell?

1 inch

When writing a business letter, your left margin should be set at ___

True

When you hide a column in Microsoft Excel, the column doesn't appear, but the data is still there. (T/F)

Page Break

When you want to start a new page in a document, you will use ___

Above the worksheet, the third cell and the longest. (Letter C)

Where is the Formula Bar?

Above the actual table

Where is the table title located?

At the end of the document, on a separate page

Where should the Works Cited page appear in the document?

Font dialogue area, small box showing borders

Where would you click on the Home tab to access controls for adding borders to cells?

Box on lower right border

Where would you click to AutoFill the formula down the rest of the column?

Font dialogue area, paint can

Where would you click to add a fill color to a cell?

Paragraph formatting on ribbon, center align button

Where would you click to change the paragraph alignment to centered?

Plus sign

Where would you click to create a new worksheet?

Line spacing

Where would you click to double-space every line of a paragraph in the paragraph popup?

Specials

Where would you click to indent the first line of a paragraph in the paragraph popup?

AutoFit Contents

Which AutoFit option is used to automatically adjust column width based on the data in the cells?

Page Layout

Which Page View shows how a worksheet will appear on a printout?

Page Break Preview

Which Page View shows where the worksheet is split into separate pages for printing?

Data Table

Which What-If Analysis tool would you use to solve the following problem? You want to determine how your company can stay profitable by varying the commission rates for your 12 sales people.

Goal Seeking

Which What-If Analysis tool would you use to solve the following problem? You want to figure out how to keep a car loan under $400 a month.

Goal Seeking

Which What-If Analysis tool would you use to solve the following problem? You want to figure out how to payback a student loan in 10 years

Data Table

Which What-If Analysis tool would you use to solve the following problem? You want to find out what interest rate you have to get in order to keep your house payment under $1200 a month.

The image that shows ragged both right and left

Which alignment option would you click to center the text in the middle of the selected cell?

Click and drag the column's boundary line to the desired width. Double-click the column's boundary line. Right-click the column header and then click Column Width.

Which are ways to change the column width in Excel?

Monthly Payment!A10

Which cell reference to another worksheet will RESULT in an error?

change case

Which command on the Home Ribbon allows a user to change the case of selected text to all uppercase, lowercase, sentence case, toggle case, or capitalize each word?

Number category, far right tool

Which command would you click to remove the decimal place from the currency in the selected cells?

Insert copied cells

Which command would you use, if you wanted to move row 6 in between row 3 and 4, without overwriting any data.

Text file

Which files can be used to import data into Excel?

=$A10/B5

Which formula uses absolute cell references?

=B3/$B$7

Which formula would you enter into C3, and then AutoFill into C4-C6, to calculate the percent sales (Pct.) for the regions?

Green, Thomas J. and Samuel T. Knight

Which is the correct way on the Works Cited page to format two authors (Thomas J. Green and Samuel T. Knight) from a source?

(McLean)

Which is the correct way to write an in-text citation for an Internet article titled "The Internet at Quantum Speeds", by Mark T. McLean.

Ctrl

Which key should you press if you wanted to select cells that are noncontiguous or not beside one another?

Ctrl+U

Which keyboard shortcut underlines text in a cell?

Ctrl+C

Which keyboard shortcut would you press to copy cells that are selected in a spreadsheet?

Ctrl-C

Which keys would you press to copy worksheet data into the clipboard?

Ctrl-V

Which keys would you press to paste worksheet data into the clipboard?

Ctrl-A

Which keys would you press to select all the data on a worksheet?

Currency

Which number format would you want to apply to a cell showing the total sales for the month?

Currency

Which number formats would you want to apply to a cell showing the total sales for the month?

Formulas

Which of the following DOES NOT have to be considered when looking at the page layout before printing a worksheet?

In the header

Which of the following would be the best location to place your name on a spreadsheet?

Landscape

Which page orientation displays more worksheet columns?

Portrait

Which page orientation displays more worksheet rows?

Row titles

Which part of the table is optional?

Revising

Which phase of the writing process is it best to have other people review your document?

Make it read-only

Which protection option would you choose if you wanted people just to read your document?

Restrict editing

Which protection would you choose ifyou wanted people to only review your document?

Require a password

Which prtection option would you choose if youw anted to prevent people from viewing your document?

horses, ducks, dogs, cats

Which set of data is in descending order?

You can use borders to create a group of cells or make specific cells stand out.

Which statement is true?

Home

Which tab would you click to change text to a bulleted list?

File

Which tab would you click to find the document protection features?

Absolute

Which type of cell references are locked and NOT automatically updated when it is copied?

Bulleted

Which type of list is best suited for items that DO NOT go in any specific order?

Workbook window

Window in which a workbook is displayed; also called worksheet window.

An Excel file that contains one or more worksheets

Workbook

On startup, Excel displays a new blank:

Workbook

Which of the following notebook-like features organizes the sheets for use in Excel? Workbook Worksheet Notepad Folder

Workbook

What is the correct hierarchy?

Workbook, worksheet, cell

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

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? Calling the Sheet Name reference Sheet Name Worksheet Reference

Worksheet Reference

Organizing the Material

Write Main Idea - Statement of opinion and/or intent Develop Supporting Paragraphs - Topic Sentences - Supporting sentences (facts, examples, descriptions, experiences) Decide on Methods of Development to Present - Ideas - Process - Extended definition - Compare/contrast - Classification - Cause/effect

Writing and Culture

Writing must be taught - conventionally bound through culture and geography ELLs often unfamiliar with concepts of planning papers, doing research, organizing the material, developing thesis, deciding on methods of development, drafting, revising, and editing Devise rubrics that consider both the process and the product

What is done during the Drafting phase of the writing process?

Writing the document

False

You access the hide/unhide command for a group of selected cells by left clicking on the selected cells. (T/F)

Press Ctrl+Z

You accidentally delete a large portion of you spreadsheet. How do you get the information back?

True

You can change the chart type even after it has been created. (T/F)

A mouse pointer shaped like a hand when on a cell means

You can grab and move the cell contents

True

You can rename a worksheet by double-clicking the worksheet tab. (T/F)

Describe the two ways, mentioned in this lesson, to move around in a table using the keyboard?

You can then move to different cells using the TAB or arrow keys. Pressing the TAB key moves to the cell to the right.

Make the margins more narrow.

You created a poster, but two lines of text run onto a second page. What could you do to fit everything on one page?

True

You double-check formulas in a worksheet by showing formulas in a print-out. (T/F)

Pie

You have been tracking your home expenses in different categories. You want to see what percentage of the total each category represents. Which type of chart would be best for this purpose?

Changed alignment

You have decided to center the text within a cell. What have you done?

Subject line

You should state what your letter is about in the ___

Border

You want to add an outside border to a table at one time. What tool on the ribbon would you use?

Bar

You want to compare the batting average of every baseball player on the team. Which type of chart would be best for this purpose?

Bar

You want to compare the batting average of every baseball player in the league. Which type of chart would be best for this purpose?

Column

You want to compare the shooting percentage of the five starters on the basketball team. Which type of chart would be best for this purpose?

Autofill

You want to enter a series of dates down a column. What would be the best tool for the job?

Line

You want to show the daily stock price of a company over the last 6 months. What type of chart would be best for this purpose?

Line

You want to show the stock price of a company over the last 6 months. What type of chart would be best for this purpose?

Database software

You would commonly use a query with what type of software

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? Magnify Area Enlarge Selected Area Amplify Range Zoom to Selection

Zoom to Selection

fill color

a background color appearing behind the data in a cell

Column Heading

a column letter above the grid that identifies each column

formula

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

record

a complete set of data for an entity

function

a predefined formular that performs a calculation

Series

a predictable list of sequential numbers, dates, times, or text

bold

a print enhancement used to make characters appear darker than other text to add emphasis

table array

a range containing a lookup table

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 retreived

range

a rectangular group of cells

paragraph

a section of writing that has a topic and concluding sentence

syntax

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

fill handle

a small black square at the bottom-right corner of a cell

function screen tip

a small popup description that displays the arguments for a function as you enter it

worksheet

a spread sheet that contains formulas, functions, values, text, and visual aids

Which of the following would be the best option to organize a large amount of information?

a table

structured reference

a tag or use of a table element as a reference in a formula

category label

a text that describes a collection of data points in a chart

y axis

a vertical line that borders the plot area to provide a frame of reference for measurement

40) Which of the following extensions applies to a Word 2013 document?

a) *.docx

49) What would you select if you wish to change only the numbered bullet and not the text?

a) Any number

16) In order to evenly distribute open Word documents visually, which option in the Window command group do you use?

a) Arrange All

29) What Word feature reduces the amount of time spent typing common content or phrases in a document?

a) AutoComplete

What is the basic format for the following sources:

a) Book: Author(s). Title of Book. Publisher, Publication Date. b) Web Site Page: Author(s). "Title of Article." Name of Site. Publication date, URL (without the "https://"). Date of access. c) Periodical: Author(s). "Title of Article." Title of Periodical, Day Month Year, pages.

22) Which of the following options are available in the Print group on Backstage?

a) Choose number of copies b) Choose default printer c) Set printer properties d) Preview document

42) In order to copy an item and place it on the Clipboard, which keyboard shortcut do you use?

a) Ctrl + C

10) You want to reduce clutter on the screen and hide the Ribbon. Which keyboard shortcut toggles between hide and unhide?

a) Ctrl + F1

35) Use this key to create blank lines between paragraphs.

a) Enter

47) Which key on the keyboard is used to automatically number the next line sequentially in a list?

a) Enter

25) What function key brings up the Help dialog box?

a) F1

21) Which of the following options are available in the Info group on Backstage?

a) Mark document as final c) Password protect document d) Check compatibility

5) Use this type of indent to extent the text into the left margin.

a) Negative indent

8) Which indent is represented by this marker on the ruler?

a) Negative indent

59) Which of the following are valid Tab Leader symbols found in the Tabs dialog box?

a) None c) ........ d) -------- e) ________

Write how each of these authors for a source should be formatted in the Works Cited Page:

a) One author: Mathew R. Hanna Hanna, Mathew R. b) Two authors: Maria S. Castorena, John A. Brown Castorena, Maria S. and John A. Brown c) Three authors: Stephen D. Joiner, Louis J. Davis, and Sally T. Astle Joiner, Stephen A., et al

14) In which View Mode can you use Object Zoom to zoom in on objects such as tables, charts, or images?

a) Read Mode

2) Which of the following are valid Document View options within Word?

a) Read Mode c) Print Layout d) Web Layout e) Outline f) Draft

16) Which button on the Quick Access Toolbar repeats your last action?

a) Redo

10) In order to search and locate instances of a misspelled client's name, which tab in the Navigation Pane would you use?

a) Results

54) Which type of tab is used to align numeric values?

a) Right

60) Which of the following are valid Tab Alignment options found in the Tabs dialog box?

a) Right b) Bar c) Center d) Left

7) Which of the following are valid options in the Show command group on the View tab?

a) Rulers c) Navigation Pane e) Gridlines

14) Which dialog box opens when you click the Save button on the Quick Access Toolbar with a new document displayed?

a) Save As

45) Which option provides an opportunity to print only specific pages or selections of the open document?

a) Settings

44) Which of the following are valid options for displaying the Clipboard?

a) Show Office Clipboard Automatically c) Show Office Clipboard When Ctrl + C Pressed Twice d) Collect Without Showing Office Clipboard e) Show Office Clipboard on Taskbar f) Show Office Near Taskbar When Copied

13) Which of the following locations provide access to Zoom options within Word?

a) Status bar d) View tab e) Backstage Print command

39) Which of the following Word options are available when saving the document as a different file type?

a) Word template b) web page c) Rich Text Format d) PDF

27) You want to use Find and Replace to locate all words beginning with T and ending with M. Which of the following wildcard search criteria would you use?

a) b*m

47) Use Document Properties to include important information which can be used later to perform searches. Which of the following types of information can you track in the Document Properties panel?

a) date the document was created b) subject c) category d) key words

24) Which of the following items will the Find command locate in the Results tab on the Navigation Pane?

a) equations c) text d) graphics e) options

37) What must you specify the first time you save a new document?

a) file name b) file type d) file location

33) What type of punctuation requires no punctuation after the salutation or closing?

a) open

9) Rulers are measuring tools used to align text, graphics, and other elements within your document. In order to perform this task, which of the following markers can you use?

a) right indent b) first-line indent d) hanging indent e) left indent

Conditional formatting

allows you to automatically apply formatting to cells based on their values

wordwrap

allows you to type words in a paragraph continually without pressing the ENTER key at the end of each line

Goal Seek

allows you to work backward to find the desired input value

table

an area in the worksheet that contains rows and columns of related data formatted to enable data management and analysis

spreadsheet

an electronic file that containsa grid of columns and rows containing related data

Workbook

an excel file with one or more worksheets

logical test

an expression that evaluates true or false

field

an individual piece of data, such as a last name

argument

an input, such as a cell reference or value, that i neededto complete a function

trendline

an object used to depict trends and forecast future data

sorting

arranges records in a table by the value in fields within a table

stilted

artificially formal; contrived

Works Cited location in a document

at the end of the document, on a separate page

26) Which keyboard shortcut is used to open the Navigation Pane?

b) Ctrl + F

32) Use this spacing option to prevent Word from adjusting spacing.

b) Exactly

8) You are in the middle of creating a company newsletter and need to turn on Gridlines to align graphics. In order to see the Gridlines, you must be in what View?

b) Print Layout

7) Which indent is represented by this marker on the ruler?

b) Right indent

13) Which action(s) is/are necessary to indent an entire paragraph?

b) Select Paragraph, press Tab

17) In order to divide one document into two so you can view two parts of a single document at one time, which option in the Window command group would you use?

b) Split

48) Which key on the keyboard is used to create a sub-bullet in a list?

b) Tab

15) Which button on the Quick Access Toolbar can you use to cancel your last command or action?

b) Undo

57) By default, at what interval are tabs automatically set?

c) 0.5"

43) In order to paste an item from the Clipboard at the insertion point, which keyboard shortcut do you use?

c) Ctrl + V

9) Which indent is represented by this marker on the ruler?

c) Left indent

12) Which tab in the Navigation Pane gives you a thumbnail graphical view of each page within the document?

c) Pages

45) Which type of bullet would you use to display a company logo?

c) Picture

5) Which view displays the text with a larger font and minimizes many tools in the Word window?

c) Read Mode

61) Which is the correct process to follow when you set a new tab?

c) Select location, select tab type, select ruler location.

18) Where is the Customize Quick Access Toolbar button located?

c) to the far right of the Quick Access Toolbar

MEDIAN function

calculates the midpoint value in a set of values

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

Absolute Reference

cell reference that points to a specific cell and does not change when copied ($B$4)

Absolute Reference

cell refernence that points to a specific cell and does not change when copied ($B$4)

Change the font color,

change the color of the letters

change the font color

change the color of the letters

Resize

change the size of

Read Mode

changes the page layout of the document with a larger font for easier reading.

read mode

changes the page layout of the document with a larger font for easier reading

Text Color

color that the text appears in in a cell

If you want to put your data into alphabetical order by last name, you could use the

command.

radar chart

compares aggregate values of three or more variables represented on axes starting from the same point

multiple data series

compares two or more sets of data in one chart

bar chart

compares values across categories using horiztontal bars

single data series

compares values for one set of data

plot area

contains a graphical representation of values in a data series

mixed cell reference

contains a relative and an absolute cell reference; the absolute part does not change but the relative part does change

nonadjacent range

contains multiple ranges of cells

chart area

contains the entire chart and all of its elements

table style

controls the fill color of the header row, columns, and records in a table

order of precedence

controls the sequence in which Excel performs arithmetic operations

gray

conveys neutrality and thus often is found in backgrounds and other effects

1) You are looking for a document you created earlier in the week and cannot remember the name. Recent Documents displays how many of the last documents you viewed?

d) 25

2) Create a Microsoft account profile to gain access to __________ GB of free Cloud storage space.

d) 7

36) What is the default spacing after a paragraph?

d) 8 points

41) In order to cut an item and place it on the Clipboard, which keyboard shortcut do you use?

d) Ctrl + X

17) Which keyboard shortcut replaces the need for the Undo command on the Quick Access Toolbar?

d) Ctrl + Z

31) In order to force the cursor to the next line or separate paragraphs, what key do you press?

d) Enter

43) In order to save your Word document as a PDF file, which command in Backstage do you use?

d) Export

4) Use this indent to insert the default half inch indent on the top line of a paragraph.

d) First hyphen line indent

6) Which indent is represented by this marker on the ruler? [FirstLineMarker.png]

d) First-line indent

37) Use this button in the Paragraph group on the Home tab to Add Space Before or After Paragraph.

d) Line Spacing

15) In order to open a duplicate copy of an active document on the screen, which option in the Window command group will you use?

d) New Window

13) In order to save time searching for common commands, you can add tools to which toolbar located above the Ribbon?

d) Quick Access Toolbar

41) You want to display hidden file extensions to easily identify file types. In order to set up this feature, which option on the Charms Bar should you choose?

d) Settings

6) Outside of the View tab, where else do you have access to Document View commands?

d) Status bar

56) What happens when you drag a tab down off the ruler?

d) The tab is deleted.

34) In order to quickly select the entire document with your mouse, which of the following options can you use?

d) Triple-click in the left margin.

18) In order to view two documents next to each other using synchronistic scrolling to compare documents, which option in the Window command group would you use?

d) View Side by Side

orange

denotes sucess victory creativity and ethusiam

Orientation

describes the direction of the page or the paper you will print on (landscape or portrait)

formula autocomplete

displays a list of functions and defined names as you enter a function

column chart

displays data comparisons vertically in a chart

value axis

displays incremental values to identify the values of the data series

Status Bar

displays information about the current document

formula bar

displays the content in the active cell

TODAY function

displays the current date

NOW function

displays the current date and time

MAX function

displays the highest value in a range

Page Break

displays the location of the different page breaks within the worksheet

Page Break Preview

displays the location of the different page breaks within the worksheet

MIN function

displays the lowest value in a range

sheet tab

displays the name of a worksheet within a workbook

surface chart

displays trends using two dimensions on a continuous curve

saturnine

gloomy and remote

The Subtotal command will automatically

group, outline, and summarize your data.

clustered column chart

groups or clusters similar data in columns to compare data across categories

conditional formatting

highlights or emphasizes cells that meet certain conditions

stringent

imposing rigorous standards of performance; severe

When reading a chart, you should refer to the

legend to see which color is used to represent each data series.

Teaching the writing process

lengthy, cumulative effort across curriculum Youngest children learn basic story structure Middle-graders develop paragraph with writing skills High schoolers learn intricacies of academic essay Teachers will often need to give mini-lessons in writing process to aid development

Freezing panes allows you to

lock row(s) or column(s) in place

VLOOKUP function

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

strident

loud, harsh, grating, or shrill; discordant

supine

lying on the back or having the face upward

Grouping worksheets allows you to

make changes to multiple worksheets at once

copy and paste

makes a copy of your document

Junoesque

marked by stately beauty

To combine several adjacent cells into one large cell, you will need to

merge cells

subtle

not immediately obvious; abstruse

If you want to display a date in a certain way (such as Friday, March 1, 2013), you can adjust the

number format

range

numbers and/or cell references, separated by commas (discrete) or by a colon (continuous)

horizontal alignment

positions data between the right and left cell margins

vertical alignment

positions data between the top and bottom cell margins

read-only

protection option you would choose if you wanted people just to read your document

Restrict editing

protection option you would choose if you wanted people to only review your document

Require a password

protection option you would choose if you wanted to prevent people from viewing your document

purple

represent wealrth power comfront extravagance magic mystery and spirtuality

=AVERAGE(range)

returns the average (mean) of a range

=SUM(range)

returns the sum total of (adds up) a range

In order to share a workbook online, you must first

save it to your OneDrive

exploded pie chart

separates one or more pie slices from the rest of the pie chart

Style guide

set of guidelines for the writing and design of documents

XY scatter chart

shows a relationship between two variables

pie chart

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

bubble chart

shows relationships among three values by using bubbles

stock chart

shows the high, low, and close prices for individual stocks over time

doughnut chart

shows values as percentages of the whole but may contain more than one data series

supplement

something added to complete a thing, make up for a deficiency, or extend or strengthen the whole

stimulation

something that arouses or causes something to happen

white

stands for purity goodness cleanliness precision and perfection

yellow

suggests sunshine,hope,happiness liveliness, and intelligance

Bulleted list

suited for a list of items that do not go in any specific order

green

symbolizes growth healthiness harmony and healing and often is associated with safety and money

suspension of disbelief

temporarily and willingly setting aside our beliefs about reality in order to enjoy a story

modification

the act of making something different

column index number

the argument in a VLOOKUP function that identifies which lookup table column from which to return a value

Fill Color

the background of the cell

Footer

the block of text at the bottom of the page

Header

the block of text at the top of the page

Double spacing

the correct line spacing based on MLA guidelines

(Crocker)

the correct way to write an in-text citation for an Internet article titled "Cakes that Rock", by Betty Crocker

active cell

the current cell, indicated by a dark border

Diaspora

the dispersion of people beyond their original homeland

font size

the height of characters in points

column width

the horiztonal measurement of a column

Cells on a table

the intersection of a column and a row

breakpoint

the lowest value for a series or specific category of the lookup table

body copy

the main text portion of an ad

Row titles

the part of the table that is optional

rate

the periodic interest rate (ex. monthly)

editing

the phase of the writing process where you correct spelling and grammar

semi selection (pointing)

the process of using the mouse pointer to select cells while building a formula

print order

the sequence in which pages print

CTRL-Y

the shortcut key that repeats the last task

CTRL-A

the shortcut to select all text

Format

the way in which something is arranged or set out

format

the way in which something is arranged or set out

Worksheet

the workspace made up of columns and rows where you enter data to create an electronic spreadsheet

Selection Tool

thick white cross

Fill Handle

this is the name of the small black square that displays in the bottom right corner of the active cell

hermetic

tightly sealed

Vex

to annoy or perplex

surpass

to be or go beyond, as in degree or quality; exceed

stigmatized

to characterize or brand as disgraceful or ignominious

Select

to choose or highlight a row, column, cell or range

amalgamate

to combine into a unified whole

Vie

to compete, contend

Right-click

to delete a comment

stymie

to hinder or obstruct

synthesize

to join, to integrate

increase

to make or become larger; to add to

Read

to read

You can use Document Inspector

to remove personal information from a workbook.

disseminate

to scatter or spread widely

Ascending order

to sort data in A>Z order

True

you would want to change the column width to make sure all of the information in the column is visible. (T/F)

signature

your name written in your own handwriting


Related study sets

Chemistry B: Lesson 8 Quiz Review

View Set

NCLEX Review: Pediatric Growth and Development

View Set