Create an account
An ___ shows the beginning and ending balances and the amount of payment that is applied to the principal and interest over a period.
___ ensures that users do not change the values inadvertently that are critical to the worksheet.
the formula checker
___ examines the formulas in a workbook in a manner similar to the way the spell checker examines a workbook for misspelled words.
When considering which cells another worksheet user should be able to manipulate, leave the cells ___.
You can deselect multiple selected sheets beginning with the Sheet 1 tab by pressing the ___ key and clicking the Sheet1 tab.
You can add and format a range border by right-clicking the selected range and clicking ___ on the shortcut menu.
Formulas tab | Function Library group
Which of the following is the path to the Financial button and the PMT function?
As many as you want
Which of the following is the maximum number off active data tables per worksheet?
You can select a worksheet so that it will fit on one page with an option on the ___ tab in the Page Setup dialog box.
You can set up a worksheet to print in black and white with an option on the ___ tab in the Page Setup dialog box.
A check mark in the ___ check box speeds up printing by ignoring formatting and not printing most graphics.
When building a worksheet for novice users, you should ___ the cells in that worksheet that you do not want changed, such as cells that contain text or formulas.
You should create a ___ when you want to keep others from changing the worksheet from protected to unprotected
To prevent sensitive data from being seen in a worksheet, you can hide the worksheet by clicking ___ on the shortcut menu.
View tab | Window group
To hide an entire workbook on an unattended computer, click the Hide button on the ___.
background formula checking
In a process called ___, Excel continually reviews the workbook for errors in formulas as you create or manipulate it.
Similar to the spell checker, Excel has a ___ that check formulas in a worksheet for rule violations.
When a formula fails to pass one of the rules and background formula checking is enabled, Excel displays a small ___ in the upper-left corner of the cell assigned the formula.
You can choose which rules you want Excel to use by enabling and disabling them in the ___area in the Excel Options dialog box, as shown in the accompanying figure.
Please allow access to your computer’s microphone to use Voice Recording.
Having trouble? Click here for help.
We can’t access your microphone!
Click the icon above to update your browser permissions and try again
Reload the page to try again!Reload
Press Cmd-0 to reset your zoom
Press Ctrl-0 to reset your zoom
It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.
Please upgrade Flash or install Chrome
to use Voice Recording.
For more help, see our troubleshooting page.
Your microphone is muted
For help fixing this issue, see this FAQ.
Star this term
You can study starred terms together