Spreadsheet Applications
What will be displayed if 30/3 is keyed into a cell?
30/3
A chart sheet can contain this, enabling you to display several charts at once within a single sheet. a. embedded charts b. only one data set c. only a single chart d. multiple graphics
A
A document that includes a needs statement for a new worksheet, source of data, summary of calculations, and chart requirements, is called a: a. worksheet template b. page setup document c. requirements document d. task pane
A
A table view of ___ data that allows the data to be summarized and compared in multiple ways is known as a PivotTable. a. row and column b. height and width c. chart and graphic d. label and value
A
Assume number of laps is in a column A, length is in column B, and width is in column C. Which one of the following formulas would compute the distance traveled around a rectangular field for state in row 5? a. =A5*(2*B5+2*C5) b. =A5+2*(B5+C5) c. =2*(B5+C5) d. =(A5+B5+C5)*2
A
Changing the color mode of an inserted image to Washout or otherwise lowering the image transparency results in: a. making the image appear lighter b. the image being moved into the background c. a black and white image d. changing the colors to a brighter version
A
Combining two or more cells together is called ___________ cells. a. merging b. spanning c. combining d. mixing
A
The Goal Seeker function lets users select ___ for a cell that contains a formula, such as setting a goal payment amount by changing the cell that contains the interest rate. a. goals b. payment functions c. FV functions d. loan amounts
A
The PivotTable automatically ___ with the addition or removal of fields of data. a. reconfigures b. saves c. filters d. prints
A
The process of finding and correcting errors in a worksheet is: a. Debugging b. Editing c. Checking d. Fixing
A
This data tool would be ideal to use in order to find the magic number one cell that contains a total fro expenses needs to be in balance a budget. a. goal seek b. filter c. consolidate d. trace dependents
A
This feature causes adjacent rows to have different formatting so that each record in the table is distinguished from surrounding rows a. row banding b. searching validation c. centering and merging d. filtering
A
To create a named rage, simply highlight the range and type the desired name in the: a. Name box b. Header c. Formula bar d. Column heading
A
To move one slice of a pie chart away from the pie creates a(n): a. exploded pie chart b. exponential pie chart c. spontaneous pie chart d. perfect pie chart
A
What does the NPER function calculate? a. the number of periods for an investment based on periodic payments and a constant interest rate b. the net payments made over a set period of time c. the net present value based on a discount rate d. the net percent rate of return on an investment
A
Which one of the following best describes a type for cells in which you can change values at any time? a. unprotected b. protected c. hidden d. locked
A
Which one of the following math functions CANNNOT be performed using Auto Calculator: a. sum b. count c. multiply d. average
A
Which one of the following math functions cannot be performed using AutoCalculate? a. multiply b. sum c. count d. average
A
What does the pivot table do?
Allows you to extract the significants from a large data set
If Bruce specifies Jan? as the search criteria, it will locate all the following records except: a. Jane b. Jamie c. Jany d. Jani
B
In Excel, it is not possible to filter on ___ column. a. an indented b. a reverse c. only one d. more than one
B
The _____ of the worksheet shows the actual formulas you have entered, rather than the resulting values. a. actual symbol b. formulas version c. formulas Print symbol d. current version
B
The procedure to update a PivotTable with changes in the numerical figures is to: a. make changes to the PivotTable with changes in the numerical figures is to: b. make changes to the list first, and then use the Refresh Data command c. make changes directly to the PivotTable d. use the Refresh Data command
B
This is a small black dot in the right corner of the active cell has a number of uses including copying a cell's contents to adjacent cells or creating series. a. Auto filler b. Fill handle c. Paste options button d. Filter list arrow
B
What must a data range have before subtotals can be inserted? a. enough records to show multiple subtotals b. sorted data c. formatted cells with banded rows d. grand totals
B
What will be displayed if 30/3 is keyed in a cell? a. 10/1 b. 30/3 c. 27 d. 10
B
Which one o the following is NOT an acceptable spreadsheet file extension? a. ODS b. OLE c. XLSX d. XLS
B
Which one of the following is best presented using a spreadsheet? a. a memo b. a trial balance c. an address list d. a presentation
B
Which one of these is NOT one of the three parts of an IF function? a. logical test b. a what-if analysis c. an action to take if the condition is false d. an action to take if the condition is true
B
Which would be a logical secondary sort field for an address list if the primary sort field is Last Name? a. State b. First Name c. Zip code d. Age
B
In the formula =VLOOKUP(F12, Theory, 4), the F12 represents the: a. lookup table b. the IF Statement results c. search argument d. column number
C
To keep proportions of a chart the same as you resize it, press and hold the ____ key as you drag one of the corner selection handles. a. Alt b. Ctrl c. Shift d. Esc
C
To select several cells or ranges that are not touching each other, you would: a. hold down CTRL + SHIFT b. hold down the ALT key c. hold down the CTRL key d. hold down the SHIFT key
C
Typically, new templates should be saved: a. as HTML documents b. to a CD-ROM for distribution c. to the program's templates folder d. to an external storage device, such as a USB drive
C
Utilizing pivot tables in a spreadsheet is much like utilizing these in a database: a. Forms b. Data tables c. Queries d. Macros
C
What type of function should be used to compute the present value of a recent investment? a. engineering function b. logical function c. financial function d. information function
C
Which formatting tool helps users by formatting values that fall into a certain range? a. Google Search b. Natural Language c. Conditional d. Scenario
C
Which of the following is NOT a general purpose for using spreadsheet? a. to interpret data using charts and graphs b. to keep track of personal budgets c. to present graphical findings with extensive narrative d. to analyze financial scenarios
C
Which one of the following is NOT an example of spreadsheet software? a. Open Office Calc b. Microsoft Excel c. Oracle Fusion d. Microsoft Works Spreadsheet
C
Which one of the following is a tool that helps users with data entry 'protection' by forcing values inputted into a cell to fall within a certain range? a. Data Search b. Chart c. Data Validation d. Scenario Manager
C
Which one of the following tasks CANNOT be completed in the Print Preview page setup/format page dialog boxes? a. add footer/header b. change paper size c. insert comments/notes d. set to print gridlines
C
You can easily add formatting to a spreadsheet table by using: a. Print areas b. Calculated columns c. Table styles d. Print titles
C
A macro can be stored in which one of the following? a. a 'global' workbook b. a single workbook c. a single worksheet d. a single worksheet or 'global' workbook
D
A(n) _____ takes a value or values, performs an operation, and returns a result to the cell. a. cell b. argument c. operation d. function
D
If a value of w is stored in cell C5, and 5 is stored in cell D5, what will be displayed if = C5*D5 is keyed in cell E5? a. 7 b. C5*D5 c. E5 d. 10
D
Line charts could be helpful in viewing: a. your family's height b. a single list of data c. percentages of a whole d. company revenue vs. time
D
The operation of making a cell turn red or old automatically if it exceeds a certain value is called: a. integration b. absolute formatting c. exponentiation d. conditional formatting
D
The rectangular area that labels the markers or symbols used in a chart. a. x-axis b. chart area c. y-axis d. legend
D
To put a stored macro into action: a. open the macro b. print the macro c. insert the macro d. run the macro
D
Where can a macro button be created? a. on the bottom of the workbook b. in the middle of the workbook c. at the top of the workbook d. anywhere in a workbook
D
Which one of the following is NOT an option for the shape of the bars in a column chart? a. cylinder b. cone c. pyramid d. trapezoid
D
Which one of the following would not be a practical use of a spreadsheet application? a. predicting the amount that you will spend on clothing in a year b. keeping track of grades in a class c. planning a budget d. printing out envelopes
D
In excel, it is not possible to filter on ______column
a reverse
Where can a macro button be created?
anywhere in the workbook
What is the keybaord shortcut to scroll to the bottom?
ctrl (down arrow)
The key F2 puts a cell into?
edit mode
What does Alt+ = do?
figure the sum
What type of function should be used to compute the present value of a recent investment?
financial function
The _______ of a worksheet shows the actual formuals you have entered rather than the resulting values
formulas version
Control + shift +down arrow, does what?
highlights the entire column
Combining two or more cells togehter is called,
merging the cells
When copy pasting a table, ctrl W will do what?
paste the table with keeping the source cell widths
The Piviot Table automatically __________ with the addition or removal of fields of data
reconfigures
To keep proportions of a chart the same as you resize it, press and hold the ______ key as you drag one cornor of the section corner
shift
Printing envalopes would not be a good use of ____
spreadsheet applications
What is transposing a table?
switching the coloum and row headers
What does the NPER function calculate?
the number of periods for an invetment based on periodic payments and a constant intrest rate
A file in excel is a
workbook
Within a workbook, there are
worksheets
