BCIS Unit 2 Word Scramble

Category: Answer

Flashcards

Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

Normal Size Small Size show me how

Question	Answer
In a line chart _________ is displayed along the bottom axis	time
When calls are selected and the Copy or Cut command is performed on them, the data is place on the:	Office Clipboard
The Worksheet that contains the totals from other worksheets is called an	summary sheet
From the Save As dialog box, click _______ to see a list of available storage devices.	the save in Arrow
a __ displays trends over time	line chart
Press the ____ key to cancel a moving border and clear a selection from the Office Clipboard.	Esc
the keyboard shortcut for the copy command is	[ctrl]+ [c]
to change the name of a sheet tab, _________ on the tab and type in the new name then press enter.	double-click
If information within a table has been sorted alphabetically A-Z a _____ arrow will display	down
when you start the excel program. a new blank ___ displays	workbook
from anywhere in the worksheet, you can press __ to move to cell A1	[ctrl] + [home]
Use __________ to prepare the spreadsheet for printing	Page Layout view
Sorting and Filtering arrows display _________ on an Excel Table	in the header row
A ____ chart is useful for illustrating comparisons among related numbers.	column
The _______ are the values that an excel function uses to perform calculations or operations	arguments
A workbook sheet that contains only a chart is called a:	chart sheet
the default setting in fow a new Excel workbook to contain ______ worksheets	three
you can create new folders to store files from the ____ dialog box	Save As
the value at the end of the time periods for a loan is called the	future value
______ is used to copy the formatting of one cell to other cell	Format Painter
If you want text to appear on multiple lines within a single cell, you can enter a	manual line break
under date category, if type 3/14 is selected ____ will display in the cell	Only the month and day
to center the contents of the worksheet horizontally on the paper click on the ______ tab from the page setup dialog box	Margins
the keyboard shortcut for the paste command is	ctrl + v
to reopen a workbook once Excel is opened, you can check the _____ for the Office menu to see if the file is there and click on it.	recent documents
in preforming calculations, _____ are processed first	expressions within parentheses
______ is the process of changing the appearance of cells and the overall layout of the worksheet	Formatting
In the Print dialog box under print what, select ___ to print all sheets in a workbook,	Entire Workbook
To create a pie chart you must select ________ range of data	two
_____ identify each worksheet in a workbook and are located along the lower left edge of the workbook window	Sheet Tabs
A ______ displays between columns to indicate page breaks and what will be printed on a page	vertical dotted line
A _________ will display to indicate a cell contains an error message	green triangle in the upper left corner of the cell
____________ function preform common business calculations such as calculating a loan payment or calculating how much to save each month in order to buy something.	Financial
to analyze a group of related data, you can convert a range of cells to a	excel table
_____ charts show the relationship of each part of data in reference to the whole.	pie
from the format cells dialog box, click the _____ tab in order to wrap text	Alignment
The command that enables you to select one or more rows or columns and lock them into place is called:	Freeze Panes
Symbols used to specify the calculations to be preformed in a formula are called	operators
Use the _____ dialog box to insert a footer on a chart sheet	Page Setup
A ___________ surrounds the selected range to be copied.	moving border
A _________ format changes the appearance of a cell range based on certain criteria.	conditional
From the Clipboard group, click the _______ button to copy the format of one cell to another.	Format Copy
New rows are inserted______ the selected row and existing rows shift accordingly	above
the _ of a data bar represents the value in a cell	length
Bold, Italic, and underline are ____________, which means that you can click the button one time to turn the formatting on and click it again to turn it off.	toggle buttons
From the Format Cells dialog box under the Alignment Tab, click and drag the red diamond to change the:	text orientation
the ______ feature will provide a list of available functions if you type = and the first letter of a function in the formula bar	Formula Auto Complete
Formula results that are updated each time a workbook is opened are said to be	volatile
the intersection of a column and row is called a:	cell
By default, text in Excel is:	Left Aligned
Use the ______ command to display text on two lines within a cell	Wrap Text
Pre-Written formulas that analyze a group of measurements are called	statistical functions
the _ function finds the middle value	min
the keyboard shortcut to view print preview is	[ctrl] + [f2]
From the page setup group, click the ___________ button to select the row headings that will repeat at the top of each page.	Print titles
__________ is a method to find a specific value for a cell by adjusting the value of one other cell.	Goal Seek
Press _______ to access Microsoft Help	[f1]
Press ___ to display the underlying formula	ctrl + `
the Keyboard shortcut for the insert function is	[shift] + [f3]
From Preview group, click the _________ button to view each page page of the workbook.	Next page
a __ is a portion of a worksheet window bounded by and separated from outer portions by vertical or horizontal bars.	pane
Commonly used font formats are found on the _________ group on the ribbon	font
all formulas begin with the ____ sign	= equal
to group worksheet right-click on the sheet tab and click:	Select All Sheets
the function key used in Excel to repeat the last action when inserting columns and rows is:	[f4]
Excel's prewritten formulas are called	functions
Pressing ___ pastes the text and removes it from the Office Clipboard	Enter

Created by: lucia1031

time	Question: In a line chart _________ is displayed along the bottom axis	1	1	false
selected	When calls are _____ and the Copy or Cut command is performed on them, the data is place on the:	2	0	true
summary sheet	Question: The Worksheet that contains the totals from other worksheets is called an	3	1	false
the save in Arrow	Question: From the Save As dialog box, click _______ to see a list of available storage devices.	4	1	false
line chart	Question: a __ displays trends over time	5	1	false
command	the keyboard shortcut for the copy _____ is	7	0	true
double-click	Question: to change the name of a sheet tab, _________ on the tab and type in the new name then press enter.	8	1	false
down	Question: If information within a table has been sorted alphabetically A-Z a _____ arrow will display	9	1	false
workbook	Question: when you start the excel program. a new blank ___ displays	10	1	false
[ctrl] + [home]	Question: from anywhere in the worksheet, you can press __ to move to cell A1	11	1	false
Page Layout view	Question: Use __________ to prepare the spreadsheet for printing	12	1	false
in the header row	Question: Sorting and Filtering arrows display _________ on an Excel Table	13	1	false
column	Question: A ____ chart is useful for illustrating comparisons among related numbers.	14	1	false
arguments	Question: The _______ are the values that an excel function uses to perform calculations or operations	15	1	false
chart sheet	Question: A workbook sheet that contains only a chart is called a:	16	1	true
three	Question: the default setting in fow a new Excel workbook to contain ______ worksheets	17	1	false
Save As	Question: you can create new folders to store files from the ____ dialog box	18	1	false
periods	the value at the end of the time _____ for a loan is called the	19	0	true
Format Painter	Question: ______ is used to copy the formatting of one cell to other cell	20	1	false
appear	If you want text to _____ on multiple lines within a single cell, you can enter a	21	0	true