How can we help?

You can also find more resources in our Help Center.

50 terms

Excel Study Guide

STUDY
PLAY
PMT allows you to determine a monthly payment for a loan
True
Cell protection is portions of a workbook that lets you show only the parts of the workbook that the user needs to see
False
The formula checker checks the formulas in a workbook in a manner similar to the way the spell checker checks for misspelled words.
True
Table is also called a database
True
Fields are data items that make up a record
True
A calculated column is a worksheet
False
Templates are special workbooks used to create a pattern
True
Business do not use templates ever.
False
Workbooks always have only two pages
False
A consolidation is the process of summarizing data included on multiple worksheets on one worksheet.
True
An alternative to a one-input table is a two-input table
True
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
Excel does not allow you to format cells before you enter the values
False, it does
The HLOOKUP function is used when the table direction is vertical or down the worksheet
False(horizontal)
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
True
The design tab on the ribbon provides powerful commands that allow you to alter the appearance and contents of a table quickly
True
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
True
A workbook contains two worksheets by default
False
The number of worksheets you can have in a workbook is limited onlly by the amount of memory in your computer
True
Excel copies page setup characteristics when one sheet is copied to another
False, it does not.
To bold the Entire Worksheet, You click Orientation on the Page layout Tab.
False
You can Color a Cell by clicking the Fill button on the Reference Tab.
False
You can Center and Merge cells in an Excel worksheet.
True
To apply the title format to a cell it under cell style on the home tab.
True
Double clicka cell to adjust the font of text to fit in the cell
False
You can color the sheet tabs by the fill button on the home tab
False
Applying a border you can choose a medium or small line
True
=if(g3<=$e$3, PV($e$4), 0) is the PV function
True
After entering in a formula in any cell press the enter key to enter data.
True
The formula for entering a date is =0date
False
You can hide rows, columns, and sheets that contain sensitive data
True
Data is in descending sequence if it is sorted from A to Z
False
You can set up a criteria range and use it to manipulate records
True
Excel has 13 database functions
False
You can have multiple worksheets in Excel.
True
You can add text boxes to graphs using the shapes button
True
A header is printed at the top of every page in a printout
False
Cell protection does not ensure that users do not change values
False
An amortization schedule shows the beginning and ending balances of a loan
True.
The process of filtering activity based on one or more filter criteria is called a query.
True
The ____ checks forulas in a workbook in a manner similar to the way the spell checker checks for misspelled words
Formula checker
A field, or column, that contains formulas or functions is called a ____.
Calculated column
Data that is related to a person is called____.
Record
Data items that make up a record are called____.
Field
A table is also known as a ___.
Database
____ ensures that the data you enter into a cell or range of cells is within limits.
Data limiter
The process of summarizing data included on multiple worksheets on one worksheet is called___.
Consolidation
A special workbook you can create and then use as a pattern to create new, similar workbooks or worksheets is called____.
Template
What function should be used on formulas that result in more decimal places than the format displays in a given cell?
ROUND function
The ___ tool allows you to create shadowed, skewed, rotated, and stretched text on a chart sheet or worksheet and apply other special text formatting effects
WorArt