The following are the four main columns in the Keyword view
A) Item, Operation, Value, Comments
B) Item, Operation, Value, Documentation
C) Item, Operation, Property, Documentation
D) Number, Operation, Value, Documentation
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.
- 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.
- 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?