Create an account
Cell protection is portions of a workbook that lets you show only the parts of the workbook that the user needs to see
The formula checker checks the formulas in a workbook in a manner similar to the way the spell checker checks for misspelled words.
A consolidation is the process of summarizing data included on multiple worksheets on one worksheet.
A name assigned to a cell or cell range on one worksheet ina workbook cannot be used on other sheets in the same workbook to referenc ethe named cell or range.
False, they can
The HLOOKUP function is used when the table direction is vertical or down the worksheet
Conditional formatting allows you to create rules that change the formatting of a cell or rang eof cells based on teh value of a cell
The design tab on the ribbon provides powerful commands that allow you to alter the appearance and contents of a table quickly
When you select a template from the New Workbook or New dialog box to create a new workbook, Excel names the new workbook using the template name with an apppended digit 1
The number of worksheets you can have in a workbook is limited onlly by the amount of memory in your computer
The ____ checks forulas in a workbook in a manner similar to the way the spell checker checks for misspelled words
The process of summarizing data included on multiple worksheets on one worksheet is called___.
A special workbook you can create and then use as a pattern to create new, similar workbooks or worksheets is called____.
What function should be used on formulas that result in more decimal places than the format displays in a given cell?
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
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