The ___ function will go to a table located in another place in excel and utilize a database quality feature to return a value based on an approximate or exact match to what it is we are looking for.
a. FINDVALUE
b. VLOOKUP
c. VFIND
d. RETRIEVE
Answer: B
Computer Science
- What should I do before creating a report to gather the information that I will put on the report?
- Which type of sorting will sort my data from largest number to smallest?
- Which type of sorting will sort my data alphabetically?
- Which of the following is not a method for entering data?
- What type of query do we usually create in access?
- What does SLQ stand for?
- Which of the following would we create using a wizard?
- You have used filtering to display only certain rows. The other rows are not displayed. What has happened to them?
- The ___ command lets you specify the order in which rows in a table appear.
- A line that "fits" a set of data is called a ____.
- If I want to create a visual display of how my COM104 students performed on the last exam (compared to each other), a ___ chart would be a good choice.
- If I want to create a visual display of a particular student's progress in a course over time, a ____ chart would be a good choice.
- If I want to write an explanation for a particular formula that I've entered into a cell, but I don't want the explanation to be printed, I can insert a ___>
- If I have data in cell G4 of a worksheet named "customer" (without the quotes), that I want to copy into cell A5 of another worksheet named "sales", I type ___ into cell A5 of the sales worksheet.
- If cell D5 contains the expression =$C$5, this is an example of ___ referencing. If I then copy the contents of cell D5 into cell D6, cell D6 will contain ____.
- If cell C3 contains the expression =B3, this is an example of ___ referencing. If I then copy the contents of cell C3 into cell C4, cell C4 will contain ___.
- What will 14-8/4 display on the screen when I press enter?
- What will the formula =3+2*(6-3) return (what will display when I push enter)?
- What operation would occur first in the formula =2+3*(2-1)
- Formulas in excel always begin with which character?
- A formula already programmed into excel is a:
- To see which cell is currently active, I would either look for the active cell pointer or look at the reference in the ___ box.
- To use the autofill feature, we use the ___ handle.
- If i type "quiz1" into cell A5, then apply the autofill feature from this cell to fill cells A6 and A7, what will be the contents of cells A6 and A7?