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