accounting 2258 exam 2
record
Each row in a table represents an individual _____?
T
T or F: A back-to-back set of quotation marks used in a function means "blank".
T
T or F: AND function and OR functions are often used as functions nested within an IF function.
F
T or F: Advanced filters allow you to apply more complex filter criteria than AutoFilters do.
T
T or F: An HLOOKUP function should be used to look up a value in the top row of a table that has different fields in each row
F
T or F: Filters allow you to increase the number of records being displayed in a table.
T
T or F: Goal seek allows you to work backwards from a desired result to determine the value a certain variable must be in order to get that desired result.
F
T or F: If you enter criteria in two different rows below the column headings in the criteria area for an Advanced Filter, you create an "and" situation, meaning the criteria in both rows must be met.
T
T or F: If your one-way data table is set up so the changing variable values are all in one row, then you must enter the formula or function in the cell located one cell below and one cell to the left of the list of values for the changing variable.
F
T or F: It does not matter whether there are an equal number of open and closed parentheses used in a nested function
F
T or F: It is faster and more efficient to use a trial and error approach rather than to use Goal Seek to determine what value a specified variable must be in order to achieve a desired result.
T
T or F: Nested functions include one or more functions as arguments for another function.
T
T or F: One way to remove all Autofilters that have been applied to a table is to go to the Editing group on the Home tab, click on the Sort and Filter button, and then select Clear
T
T or F: The AND function returns the word TRUE only if none of the logical tests are false
T
T or F: The DAVERAGE function will calculate an average value for all values in a specified field (column) when certain criteria have been met.
F
T or F: The OR function returns the word NO if all the logical tests are false.
F
T or F: The criteria argument in a database function must be entered in quotation marks.
F
T or F: The symbol=/ means "does not equal".
F
T or F: To activate the AutoFilter command, you have to go to the Data tab and click on the Autofilter button in the Filter group.
F
T or F: When creating a one-variable data table, you must enter data into the row input cell text box and the column input cell text box in the data table dialog box
T
T or F: When running on an advanced filter, you can choose to have the results displayed within the table itself or in a separate location outside of the table.
F
T or F: When setting up a database function, the range of cells entered for the database argument should not include the table's column headings.
F
T or F: When text is used in a function argument, the text must be enclosed in brackets.
F
T or F: When using a VLOOKUP function, the leftmost column of the table where the value is being looked up must be sorted in descending order.
F
T or F: You can analyze the results of as many formulas or functions as you want when using a two-variable data table
T
T or F: You can filter a table to view the top 5 values in a field using the Top 10 autofilter option.
outline
To remove all subtotals that have been applied to a table, you should click on the Subtotal button in the _____ group on the Data tab, and then click on Remove All.
subtotal
What excel feature can be added to a table to provide summary information about related data?
Banded rows
What option in the Table Tools Design tab will display the rows of a table in alternating light and dark colors?
descending order
What order are you sorting if you sort from largest to smallest numerical values?
converting the table to a range
What step is necessary in order to be able to activate the Subtotal command?
Insert
What tab do you go to when you want to create a table in Excel?
If you enter a password when protecting a workbook, and then you forget the password, you can contact Microsoft to retrieve or reset the password.
Which of the following is false regarding the protection of a workbook in Excel? Protecting a workbook prevents users from being able to insert, delete, rename, move, copy, or hide worksheets within that workbook. The Protect Workbook command is located in the Changes group on the Review tab on the Ribbon. If you enter a password when protecting a workbook, and then you forget the password, you can contact Microsoft to retrieve or reset the password. You can unprotect a workbook by simply pressing the Protect Workbook button again.
Click on the Sort & Filter button in the Data group on the Page Layout tab.
Which of the following is not an appropriate method for sorting on one field? Click on the Sort & Filter button in the Editing group on the Home tab. Click on a field's filter arrow and select a sort option. Click on a sort button in the Sort & Filter group on the Data tab. Click on the Sort & Filter button in the Data group on the Page Layout tab.
top, middle, and bottom
Which of the following is not one of the categories of Cell Styles available in Excel? Top, Middle, and Bottom Good, Bad, and Neutral Titles and Headings Data and Model
In the Sort Dialog box, you should click on the Add Level button to add another field to sort on.
Which of the following is true about using a Custom Sort? You can only sort on two fields when using Custom Sort. In the Sort Dialog Box, you should click on the Add Level button to add another field to sort on. Once you have created a level in the Sort Dialog Box, you cannot delete it. In the Sort Dialog Box, you should ensure Cell Color is displayed in the Sort On text box.
the first step is to insert the appropriate number of empty columns.
Which of the following is true regarding the Convert Text to Columns feature? It converts text into a number format. The first step is to insert the appropriate number of empty columns. It switches text from multiple rows to text across multiple columns. The Text to Columns button is located on the Home tab on the Ribbon.
cells can be locked and unlocked on the protection tab in the format cells dialog box
Which of the following is true regarding the protection of a worksheet? The Protect Sheet button is located on the View tab on the Ribbon. Cells must be locked first before you can protect a worksheet. Cells can be locked and unlocked on the Protection tab in the Format Cells Dialog Box. The Protect Sheet command limits a user's ability to insert or delete worksheets in a workbook
collapse button
a button with a minus (-) sign in the center that hides detail, or shows less detail when clicked on.
expand button
a button with a plus (+) sign in the center that shows more detail when it is clicked on.
nested function
a complex function created when one or more functions are used as arguments within another function
new rule
a conditional formatting technique that allows you to create a customized conditional formatting rule with customized formatting options
highlight cells rules
a conditional formatting technique that allows you to highlight cells with a selected formatting option if the values in those cells meet specified criteria
top/bottom rules
a conditional formatting technique that applies a selected formatting option to cells that contain values falling above average, below average, in the top percent, in the bottom percent, in the top number of items, or in the bottom number of items.
data bars
a conditional formatting technique that displays a data bar in each of the selected cells, with the length of the data bar representing the value in the cell
clip art
a selection of drawings, movies, sounds, and photography available in Excel that can be added to a worksheet
table
a series of related data that has been organized into rows and columns in an excel spreadsheet.
one-variable data table
a what-if analysis tool that allows you to see how changes to one variable will affect the results of one or more formulas or functions in a worksheet
two-variable data table
a what-if analysis tool that allows you to see how changes to two variables will affect the results of one formula or function in a worksheet.
goal seek
a what-if analysis tool that allows you to work backwards from a desired result to determine what value a specified variable must be in order to achieve that desired result.
freeze panes
an excel command that allows you to freeze part of the worksheet, so it remains visible as you scroll across and/or down the worksheet to view data
split panes
an excel command that allows you to see multiple parts of a worksheet at the same time
arrange all
an excel command that allows you to view multiple workbooks on the screen at the same time
DSUM function
adds together values in one field (column) of a table when specified criteria have been met.
2
after creating subtotals, clicking on what numbered button would hide the records in the table and display only the subtotals and grand totals?
custom sort
allows users to sort data on multiple fields and enter special criteria for a sort.
What-if analysis
allows you to make changes in key variables or assumptions and then assess the effect of those changes on financial results or outcomes
convert text to columns
an excel command that allows you to convert the text from one cell into separate columns
protect workbook
an excel command that can be activated to prevent users from being able to insert, delete, rename, move, copy, or hide worksheets within the workbook
advanced filters
an excel feature similar to autofilter that allows you to specify criteria to limit the records you view in a table. these allow for greater complexity and the ability to apply more criteria than autofilters do.
conditional formatting
an excel feature that allows users to apply special formatting to highlight certain cells, emphasize unusual values, or display a visual representation alongside data
wordart
an excel feature that allows you to display decorative text on a worksheet
Subtotal
an excel feature that can be added to a table to provide summary information about related data.
autofilter
an excel feature that lets you identify specific values you are interested in viewing in one or more fields of the table and hides all records not containing the specified values
record
contains all of the information about an individual object reported in a table. Each row in the table represents an individual _____.
dcount function
counts the number of values in one field (column) of a table when specified criteria have been met
IF function
directs excel to evaluate a condition (or logical test) and return one value in the cell if the condition is true and another value in the cell if the condition is false
AND function
evaluates one or more logical tests and returns the word TRUE if all the logical tests are true or FALSE if at least one of the logical tests is not true.
OR function
evaluates one or more logical tests and returns the word TRUE if at least one of the logical tests is true or FALSE if all of the logical tests are false.
vlookup function
looks for a value in the leftmost column of a table that is closest to the specified value without going over and then returns a corresponding value from the same row in a specified column of the table
hlookup function
looks for a value in the top row of a table that is closest to the specified value without going over and then returns a corresponding value from the same column in a specified row of the table.
cell styles
pre-defined formatting styles provided within excel that can be applied to an individual cell or range of cells on a worksheet
theme
pre-set _____s are provided within excel consisting of specific colors, fonts, and effects that can be applied to an entire worksheet to change the overall design of the worksheet
field
provides one piece of information about each object in a table. each column in the table represents a different ____.
DMAX function
returns the highest value in one field (column) of a table when specified criteria have been met.
DMIN function
returns the lowest value in one field (column) of a table when specified criteria have been met.
ascending order
sorts data from A to Z (if sorting text values) or from the smallest values to the largest values (if sorting numerical values)
descending order
sorts data from Z to A (if sorting text values) or from the largest values to the smallest values (if sorting numerical values).
database functions
special functions used to perform calculations on data in a table dependent on whether specified criteria have been met.
field names
the column headings in a table that identify the fields used in a table
themes
what can be used in excel to apply a collection of colors, fonts, and effects to an entire worksheet?
wordart
what can you insert on a worksheet to display decorative text?
arrange all
what command can be used if you want to view 3 workbooks on your screen at the same time?
a collection of drawings, movies, sounds, and photographs available in Excel.
what is clip art?
to apply special formatting to cells meeting specified criteria
what is the purpose of using conditional formatting?
top/bottom rules
which conditional formatting technique should be used to apply special formatting to cells containing values that are below average?