excel in class assessment 3

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

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


संबंधित स्टडी सेट्स

Chapter 8 pt. 3 Launchpad questions

View Set

Oral Pathology Exam #1 Chapter 1,2,3

View Set

Course 5: Agile Project Management

View Set

Learning How to Learn: Week 4: Part 1

View Set

Chapter 10 Personality Psychology

View Set

OB: Chapter 20 Nursing Management of the Pregnancy at Risk

View Set

Yellow Fever Course (1.5 hrs) DHA -US086

View Set