accounting 2258 exam 2

Ace your homework & exams now with Quizwiz!

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?


Related study sets

CompTIA Network+ Exam N10-007 OSI Layers Quiz

View Set

Harry Potter and the Half-Blood Prince Trivia

View Set

Unit 10: Lesson 5 - Fission and Fusion Reactions

View Set

Intro to the fundamentals of law for health information and information management

View Set

Unit 4 Study Guide Business Essentials

View Set