Microsoft Excel
When you run the Spell Checker in a workbook, Excel automatically checks in all worksheets at once. T or F
False
To change the name of a worksheet, you rename the ____.
Sheet tab
Which function inserts the total of a range
Sum
Cell protection
Techniques that ensure users do not inadvertently change values that are critical to the worksheet
How can you remove data labels from a chart?
Uncheck the box beside Data Labels in Chart Elements
When you select a cell range, the cells must be adjacent to each other. T or F
False
PMT Function
The financial function that calculates the payment schedule required to repay a loan based on constant payments and constant interest rates
Logical test
The first part of an IF function, if the logical test is true, then the seconds part of the function is applies; if it is false, then the third part of the function is applied.
What formula totals cells B6, B7, B8, B9, and B10 most efficiently
The formula =SUM(B6:B10)
merge
To combine, such as several cells into one cell
A student wants to insert a column sparkline in Excel. To do this, she can click on the cell she wants to insert a Sparkline, then click insert tab, select sparkline type of choice from the sparklines group and then select ok. T or F
True
Data table
A range of cells that shows the resulting values when one or more input values are varied in a formula; in a chart, a grid containing the chart data.
chart sheet
A separate sheet in a workbook that contains only a chart, which is lined to the workbook data.
worksheet
A single sheet in a workbook file that is laid out in in a grid of rows and columns
In the formula =b6*$B$2, which of the following describes $b$2?
Absolute cell reference
To align currency symbols and decimal points in a column of numbers, you can apply the ___ number format.
Accounting
What should you select as X in the following series of clicks to change the chart type to a clustered column chart: Chart > Chart tools ? Design tab > Type group > Change Chart Type > All Charts > X . Clustered column > ok?
Column
You double-click the format painter button when you want to ___
Copy a cell's format to more than one cell
Bertie wants to show data labels inside a text bubble shape. What option can she click on after clicking on the arrow next to data labels under chart elements?
Data Callout
data series
Data from a column or row in a sheet the set of values represented in a chart.
What is true about inserting cells in a worksheet?
Excel automatically adjusts cell references to reflect new formulas locations
Bart needs to apply a sparkline style to a sparkline chart. To do so, he can click on the following: Sparkline chart > Design > Style (choose a style). T or F
False
Changing a worksheet window to Normal View changes the contexts of the worksheet
False
Decreasing a cell's indent moves its contents to the right one space.
False
In formulas, Calculations in square brackets are calculated first. T or F
False
The Comma Style format adds a comma and a dollar sign to a cell value. T or F
False
To preserve an exact cell address in a copied formula, you can use a relative cell reference. T or F
False
To print a worksheet contents at cross the portrait orientation. T or F
False
When you change cell contents to italics, you are changing the cell's alignment. T or F
False
When you enter a value in cell, it is automatically left-aligned. T or F
False
You can use the I-beam pointer to copy cell contents into adjacent cells. T or F
False
You have selected a cell with a formula. What can you use to copy that formula to an adjacent cell?
Fill handle
formula bar
The area above the worksheet grid where you enter or edit data in the active cell.
active cell
The cell currently selected in the active sheet.
cell
The column letter and row number location that identifies a cell within a worksheet or table such as A1.
edit mode
The mode in which you can make changed to a cell's content directly in the cell.
destination area
The range of cells to which you are pasting.
If you discover an error immediately after you have confirmed a cell entry, what can you do?
The undo button on the Quick Access toolbar
Currency is an example of a number format. T or F
True
to enter data in a cell using examples already in your workbook, you can use the flash fill feature. T or F
True
Arlo wants to use goal seek to answer "what if" questions in a file. To do this, he clicks the cell in the spreadsheet that he wants to change, then selects the "X" button from the Data tab and selects Goal seek.. from the drop down menu. What is the X procedure.
What-IF analysis
What is true when you delete a cell?
When you delete cells using the Delete list arrow, you can choose which way to move adjacent cells
when should you use relative cell references?
When you want to preserve the relationship tot eh formula location
How can you remove split panes in a worksheet you are working on?
Click the View tab in the Ribbon, then click the split button in the Window group
in-cell editing
Editing the contents of a cell directly in the cell.
To enter a range of text based on examples that are already in your worksheet, what can you use?
Flash Fill
Relative cell reference
In a formula, a cell address that automatically changes to reflect the new location when the formula is copies or moves; the default type of referencing use in Excel worksheets; also called a relative reference.
Absolute cell reference
In a formula, a cell address that refers to a specific cell and does not change when you copy the formula.
SUM function
In excel, a function that adds all the numbers in a range of cells.
What would you select as X in the given series of clicks to insert a pie chart: Insert > Charts group > X?
Insert Pie or doughnut chart
Your worksheet appears with a reduced view of each page and blue dividers where new pages begin. What view are you in?
Page Break Preview
copy area
The cell(s) being copied.
Niki wants to insert a Line sparkline in Excel. To do this, she can click on the cell she wants to insert a Sparkline, then click insert tab, select Line Sparkline from the Sparklines group and then OK . T or F
True
The easiest way to insert the SUM function is to use the AUTOSUM button on the home tab. T or F
True
To Move a worksheet, you can drag its sheet tab to the left or right
True
To apply formats to data when it meets criteria you can specified you can use conditional formatting. T or F
True
To format the cell value 44.54 as 44.540, you can use the increase decimal button
True
To insert the current date in cell B1, type CURRENT DATE in cell A1 and NOW() in cell B1 and press ENTER. T or F
True
To rotate cell contents, you use the Alignment tab in the Format cells dialog box. T or F
True
Ursula wants to freeze the header row so that it remains visible while she scrolls down the worksheet. To do so, she can click the View tab and then click Freeze top row. T or F
True
Your worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in a formula?
$A$5
The default worksheet text is __ -ping calibri
11
These score of students in a subject in inserted in B2 cell and the passing score for the subject is 60. What function will you insert in C3 cell to check if the student has passed or failed?
=IF(B2>=60, "Pass", "Fail")
fill handle
A black square that appears in the lower-right corner of a selected cell or range; used to fill adjacent cell with duplicate or similar data.
name box
A box to the left of the formula bar that shows the cell reference or name of the active cell.
relative reference
A cell reference that changes when the formula containing that reference is moved to a new location.
Mixed cell reference
A cell reference that changes when the formula containing that reference is moves to a new location.
source area
A chance of cells you are cutting or copying.
Two-input data table
A data table in which you can vary the value in two cells and then see the recalculated results
Goal seek
A feature that reverses the trial-and-error process by allowing you to specify an output value and then working backwards to find the input value needed to reach that goal
PV function
A function that returns the present value of an annuity.
FV Function
A function that reuters the future values of an investment based on scheduled payments and an unchanging interest rate.
range
A group of cells in a rectangular block in a worksheet, also called a cell range.
Cell name
A name assigned to a cell or cell range that can be used in formulas
function
A named operation that replaces the action of an arithmetic expression.
One-input data table
A range of cells that shows resulting values when one input value in a formula is changed
Amortization schedule
A schedule that shows loan balances and the payment amounts applies to principal and interest for each payment period.
What-if analysis
A way to explore the impact that changing input values has on calculated values and output values.
AutoCalculate area
An area on the Excel status bar where you can view a total, an average, or other information about a selected range.
In the Formula =SUM(A6:A9), what describes A6
Argument
What inserts a function into a cell?
AutoSum button
What feature inserts a function that totals the cells above or to the left of the selected cell?
AutoSum function
What function would you use to calculate the arithmetic mean of a price list?
Average
You have cut the range A1:A5, and want to paste it to C1:C5. what do you do?
Before you paste it, you only need to select c1 and After you paste it, the information is deleted from the original location.
To select nonadjacent cells or ranges on a worksheet, you can press and hold ___ while selecting each one
CTRL
To accept a suggested spelling for that instance only, what would you click?
Change
To return to cell contents to its default font and style, you can use the ___ command
Clear formats
To help you easily identify sheets in a workbook, you can add ___ to the sheet tab.
Color
To format a range so that all values greater than $500 appear in red, what can you use?
Conditional formatting
To copy a cell's formatting to another cell, what can you use?
Format Painter
To apply a cell style, you would use the cell styles command on the ___ tab
Home
You've copied a cell containing formula to the rows below it, and the results in the copied cells are all zeros. To find the problem, what should you check for in your original formula?
If it needs an absolute cell reference
The spell checker flags your company's name is misspelling. What can you do to stop the spell checker from flagging later occurrence in the documents?
Ignore all
IF function
In Excel, a function that assigns a value to a cell based on a logical test
NOW function
In Excel, a function that returns a number that corresponds to the system date and time. Beginning with December 31, 1899.
Format symbols
In Excel, a symbol that assigns a format to numbers as they are entered.
Where can you see a brief description of a selected function?
Insert function dialogue box
In a complex formula, how does Excel determine which calculation to perform first?
It follows the order of operations
To combine multiple cells into one combines cell, what would you do?
Merge and Center button
To rotate cell contents to an exact value, you change its ___
Orientation
What type of chart can you not add axis titles on?
Pie Chart
Where can you see a preview of how your worksheet will look when printed, including headers?
Print tab in backstage View
In the formula = A8*$A$1, which the following describes A8
Relative cell Reference
Nisha wants to freeze all rows above row 4 in worksheet she is working on to keep them visible while scrolling though the rest of the worksheet. What clicks does she need to make
Row 4 > View tab > Windows group > freeze panes > freeze panes
Steffie wants to change the margins of a worksheet to normal to align it better on a printed page. to do this, what can she do after selecting the worksheet for this purpose.
Set width and height to automatic and scale to 100% in the scale to fit group on the page layout tab
You can edit cell contents in the Formula bar or in the cell itself. T or F
True
You can use the Delete key to clear cell contents. T or F
True
