excel in class assessment 3
what does is in (=INDEX) and what does it do
- (array, row_num, [column_num]) - The index function returns the value at a given position in a range or array. You can use index to retrieve individual values or entire rows and columns.
what does is in( =FIND) and what does it do
- (find_text, within_text, [start_num]) - The FIND function in Excel is used to return the position of a specific character or substring within a text string.
what does is in (=LOOKUP) and what does it do
- (lookup_value, lookup_vector, [result_vector]) - The LOOKUP function in Excel is used to search one column of data and find data in the corresponding row.
The syntax of the COUNTIF function is ____.
=COUNTIF(range,criteria)
A PivotChart report represents source data as a(n) graphic.
true
If a lookup_value is smaller than the smallest value in the first column of table_array, VLOOKUP opens up the Lookup Wizard.
true
A(n) PivotSheet report is an interactive report that lets you summarize and analyze a data set.
False
Placing a field in the Row Labels area of a PivotTable displays data from that field in columns and rows.
False
COUNT COUNTA
SAME THING they determine the number values in a list COUNT ignores blank cells and text COUNTA does not
SUM function
SUM(number 1,[ number 2]) finds sum of number sets
what does fill handle do
copy formulas
where is the option to insert a table and/or a pivot table
in the insert tab
absolute cell referencing
remains. unchanged when copied more than one $$$$
how does the accounting number style display values
with dollar signs
Excel spreadsheets are called what
worksheets
The COUNTIF function accommodates a(n) single contiguous range argument.
True
The Query Wizard lets you choose your data source and select the database table and fields you want to import into a workbook.
True
The easiest way to create a PivotChart report is to use an existing PivotTable report as the source data.
True
You can often use a LOOKUP function instead of a VLOOKUP or HLOOKUP function with a TRUE lookup type.
True
chart types
area line column pie combo stock doughnut XY
what are. function inputs called
arguments
The first row (key values) of the lookup table must be sorted in ____ order to use an HLOOKUP function with a TRUE lookup type.
ascending
what does a What- if analysis do
determine the outcome one of changing input values
You use VLOOKUP when ____ of the lookup table contains the data you are looking up.
the first column
The INDEX function allows you to retrieve data from multidimensional tables.
true
things needed to create a What- if analysis
unite price quantity or unit discount rate
Relative cell referencing
uses general formula over again but with different numbers
what does is in( =RIGHT) and what does it do
- (text, [num_chars]) - RIGHT in excel is used to return the last character or characters in a supplied text string, based on the number of characters specified.
what does is in ( =FIND) in addition with (=CONCATENATE) and what does it do
- =FIND(find_text, within_text, [start_num]) =CONCATENATE(text1, [text2], [text3], ...) - The concatenate function is one of Excel's text functions. It is used to join two or more words or text strings together
what does is in (=VLOOKUP) and what does it do
-(lookup_value, table_array, col_index_num, [range_lookup]) - The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position.
what does is in ( =HLOOKUP) and what does it do
-(lookup_value, table_array, row_index_num, [range_lookup]) - HLOOKUP function performs a horizontal lookup by searching for a value in the top row of the table and returning the value in the same column based on the index_number.
To perform the task of displaying "credit approved" or "credit denied" based on the corresponding Boolean value in column H, you can write a formula in cell I3 containing an IF function, as follows:
=IF(H3,"credit approved","credit denied")
The RANDOM function randomly assigns a number between two specified values.
False
The syntax of the RANK.EQ function is as follows: RANK(number,sort,order).
False
The PivotTable ____ task pane contains a list of fields in the data source you selected for the PivotTable report.
Fields
Choose a(n) ____ function if the problem requires you to make a decision and then generate different values depending on whether the logical test results in a TRUE or FALSE value.
IF
An IF function can be used to evaluate a logical test, such as determining if the 90-days past due balance is greater than 0, with only two resulting values: a value_if_true and a value_if_false.
True
The default field setting in the ____ area is to calculate a sum of the items in this drop area by the categories in the Row Labels area or Column Labels area.
VALUES
You can change the calculation used in the VALUES area by right-clicking a value in the VALUES area to open the shortcut menu, and then clicking Field Settings to open the ____ dialog box.
Value Field Settings
An IF function is a Boolean logical function that returns one value if a specified condition evaluates to TRUE, and the same value if the specified condition evaluates to FALSE.
false
In a one-dimensional table, Excel searches one dimension, such as the columns, and then searches another dimension, such as the rows, to find the value at the intersection of a single row and column.
false
When you use a lookup type of TRUE, the VLOOKUP function looks only for an exact match of the lookup value.
false.
The technique used to fix certain rows while you scroll to other rows in a worksheet is called ____ panes.
freezing
Microsoft Excel allows you to use ____, such as LARGE, SMALL, and RANK.EQ, that help you to structure and analyze data in meaningful ways.
functions
The syntax of the LOOKUP function is as follows: =LOOKUP(____,lookup_vector,result_vector).
lookup_value
Unlike a regular chart, you can change the layout and data displayed in a PivotChart report by ____.
moving fields
mixed cell references
only has one $ in cell used when you need to move a formula down a column and across a row
The syntax of the VLOOKUP function is as follows: =VLOOKUP(lookup_value,table_array,col_index_num,____)
range_lookup
In an INDEX function, the argument ____ refers to the number of the row in the range referenced in the first argument.
row_num
