SPREADSHEET APPLICATIONS A

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

Email *

What is your name? *

What is the password? This password is time sensitive. Your FBLA Adviser will be able to provide it to you. *

1) What value will be displayed in the cell if the action is false from the given formula? =IF(C14<29,"No","Winner")

1 point

A) 29

B) Winner

C) IF

D) C14

Clear selection

2) Which of the following could be an operand?

1 point

A) =

B) SUM

C) :

D) B20

Clear selection

3) Which math function is calculated first in the formula: =(B3*B5)*1/C3

1 point

A) B3*B5

B) B5*1

C) BC/C3

D) 1/C3

Clear selection

4) The formulas version verifies that you entered formulas rather than what?

1 point

A) dollar signs

B) functions

C) numbers

D) text

Clear selection

5) Which of the following functions checks whether a condition is met and returns one value if true and another if false?

1 point

A) CHITEST

B) IF

C) LOOKUP

D) AND

Clear selection

6) In which example would it be best to use the AVERAGE function?

1 point

A) To find a common denominator in a fraction

B) To calculate student grades for a report card

C) To create a pie chart from survey results

D) To determine which number is most common

Clear selection

7) Which function will test whether a condition is true or false and make logical comparisons between expressions?

1 point

A) IF

B) WHATIF

C) VALUE

D) IFHOW

Clear selection

8) What would you be calculating if the following function was used?
NPER(rate, pmt, pv [fv=0], [type=0])

1 point

A) the percentage rate of a loan or investment based on periodic constant payments

B) the interest rate of a loan or investment based on periodic, constant payments

C) the number of periods required to pay off a loan or investment

D) the present value of a loan or investment based on periodic, constant payments

Clear selection

9) What type of operator is used in a formula to join one or more text entries to form a single entry?

1 point

A) boolean operator

B) comparison operator

C) concatenation operator

D) additive operator

Clear selection

10) Using the function =PMT(C5,C7,-C3), why does C3 contain a minus sign?

1 point

A) to reflect the function as a present value

B) to reflect the function as a negative

C) to reflect the payment as a positive number

D) to show a payment is being taken out of your account

Clear selection

11) If you copy a formula containing the relative reference C8 to another cell, the reference to C8:

1 point

A) changes

B) becomes absolute

C) becomes mixed

D) stays the same

Clear selection

12) If the formula =D1*$C$1 is copied from cell D2 to cell D3, what formula will appear in cell D3?

1 point

A) =D2*$D$1

B) =D2*$C$1

C) =D1*$C$1

D) =D2*$C$2

Clear selection

13) What is the result of the expression =50/(10*5) in a worksheet application?

1 point

A) 50

B) 25

C) 1

D) 1/5

Clear selection

14) Adrienne has been asked to create an invoice template for the construction repair company she works for after school. Which functions will she most likely use in the template?

1 point

A) Addition and Time

B) Sum and Totals

C) Sum and Date

D) Sum and Min

Clear selection

15) Which type of formula can perform multiple calculations and give either a single result or multiple results?

1 point

A) Addition and Time

B) Sum and Totals

C) Sum and Date

D) Sum and Min

Clear selection

16) Which function is used when the lookup table direction is horizontal?

1 point

A) Addition and Time

B) Sum and Totals

C) Sum and Date

D) Sum and Min

Clear selection

17) If a range is nonadjacent, a/an ___ separates the rectangular blocks.

1 point

A) semicolon

B) period

C) comma

D) ampersand

Clear selection

18) Which error message will appear in a cell if the formula in that cell refers to a cell that contains text rather than a number?

1 point

A) #NUM!

B) #VALUE!

C) #DIV/0

D) ######

Clear selection

19) If the value 69.5 is in cell A1, and the formula =IF (A1>69.5, "Pass, "Fail") what result will cell A1 display?

1 point

A) #NUM!

B) #VALUE!

C) #DIV/0

D) ######

Clear selection

20) Which one of the following is used to copy data and formulas to adjacent cells in a worksheet?

1 point

A) Data

B) Worksheet

C) Advanced options

D) Fill handle

Clear selection

21) Which view is most convenient to create Headers and Footers?

1 point

A) Normal view

B) HTTP:// view

C) Page Layout view

D) Web Design view

Clear selection

22) When track changes is switched off the change history is:

1 point

A) Erased

B) Approved

C) Saved

D) Viewed

Clear selection

23) You need to convert the number 5.663 to 5.7; what function should you use?

1 point

A) MEDIAN()

B) SUM()

C) TRUNCATE()

D) ROUND()

Clear selection

24) If the amounts in cells that affect a calculation may change after entering a function, what should you do?

1 point

A) Re-enter the function each time you change the data.

B) Key the answer instead of using a function.

C) Use a hyperlink function.

D) Use cell references in the function.

Clear selection

25) The first row of a table that contains field names is called a:

1 point

A) major record

B) header row

C) database record

D) primary record

Clear selection

26) A series of two or more adjacent cells in a column or row is called a:

1 point

A) nearby cell

B) neighbor

C) range

D) bunch

Clear selection

27) What is the term used to describe dividing a cell?

1 point

A) Splitting

B) Uncoupling

C) Demerging

D) Separating

Clear selection

28) How are cells identified?

1 point

A) By the name of the column and the row

B) By the name given to them by a user

C) According to the column they are under

D) By the row number

Clear selection

29) How can data in a spreadsheet be arranged so it can be used as a database?

1 point

A) Make a Pivot Table

B) Use a Data Function

C) Make it as SmartArt

D) Use a Data Formula

Clear selection

30) If data entered into a spreadsheet may need to be used by another program or uploaded to a web program what format should the spreadsheet be saved in?

1 point

A) HTML

B) XLS

C) SLS

D) CSV

Clear selection

31) Which of the following would not automatically convert a number to a currency format?

1 point

A) PMT function

B) Format cells as currency

C) DOLLAR function

D) Format cells as accounting

Clear selection

32) Which of the following functions can apply to multiple non-contiguous areas?

1 point

A) INDEX

B) CELL

C) COLUMN

D) AREAS

Clear selection

34) After Stuart created a spreadsheet he realized that he entered 80 instead of 89 in more than 15 cells. How can he quickly change the number 80 to 89?

1 point

A) Use GoTo

B) Use the Format command

C) Use Find and Replace

D) Use the Edit command

Clear selection

35) To enter data in a cell, you must first select or activate the:

1 point

A) column

B) cell

C) worksheet

D) row

Clear selection

36) What is the shortcut key to highlight the entire column?

1 point

A) Ctrl + space bar

B) Ctrl + C

C) Ctrl + Page Up

D) Shift + Enter

Clear selection

37) By selecting rows 5 & 6 then choosing Insert Row. What will happen?

1 point

A) two rows will be inserted after row 6

B) two rows will be inserted after row 7

C) two rows will be inserted after row 4

D) two rows will be inserted after row 5

Clear selection

38) The Freeze Panes command is used to:

1 point

A) freeze the Task Pane so that it remains displayed as you bring up various dialog boxes

B) freeze the window so you can scroll up a page at a time instead of one row at a time

C) split a spreadsheet into four panes

D) display titles no matter how far down or to the right you scroll

Clear selection

39) What ensures that users cannot unprotect a worksheet simply by clicking the Unprotect Sheet button?

1 point

A) password

B) formula

C) dependent

D) precedent

Clear selection

40) Which menu option can be used to split windows into two?

1 point

A) Format

B) File

C) Window

D) View

Clear selection

42) The horizontal line that forms the base of a line chart is called the category axis and would logically display units such as:

1 point

A) days, months, and quarters

B) currency units such as dollars

C) percentages of a whole

D) test scores

Clear selection

43) When choosing data for a chart that is in ____ ranges, the control key is used.

1 point

A) broad based

B) date

C) nonadjacent

D) formula

Clear selection

44) When creating multiple column Sparklines in Excel, what would you need to change to show the same vertical axis value for all Sparklines?

1 point

A) Axis, Show Axis

B) Axis, Vertical Axis Minimum, Same for all Sparklines and Vertical Axis Maximum, same for all Sparklines

C) Axis, Vertical Axis Minimum, Automatic for each Sparkline and Vertical Axis Maximum, Automatic for each Sparkline

D) Axis, Vertical Axis Minimum and Vertical Axis Maximum

Clear selection

45) Which one of the following charts is used to compare relative values from different categories to the whole?

1 point

A) Area

B) Pie

C) Column

D) Line

Clear selection

46) What is a small chart called that fits within individual cells in a spreadsheet?

1 point

A) Guidelines

B) Graphics

C) Sparklines

D) Chartlines

Clear selection

47) What is the advantage of using a table feature for a series of rows and columns?

1 point

A) It automatically creates a data table that is part of the what-if analysis

B) It can automatically calculate the data in the series and the data rows increase.

C) It provides a quick way to make the data in the series look attractive.

D) The data in the series can be managed independent of other rows and columns.

Clear selection

48) Currently, a column chart shows the values on the value axis, years on the category axis, and the state names in the legend. What should you do if you want to organize data with the states on the category axis and the years shown in the legend?

1 point

A) click Legend in the Labels group on the Layout tab, and then select Show Legend at bottom

B) click Layout 2 in the Chart Layouts group on the Design tab, then apply a different chart style

C) click Switch Row/Column in the Data group on the Design tab

D) change the chart type to a clustered column chart on the Design tab

Clear selection

49) What displays charted data in a grid at the bottom of the chart?

1 point

A) sheet tab

B) worksheet

C) data table

D) data series

Clear selection

50) Which chart sub-type presents multiple data series as side-by-side columns?

1 point

A) Stacked column chart

B) 3-D column chart

C) Clustered column chart

D) Sized column chart

Clear selection

Send me a copy of my responses.

Submit

Clear form

Never submit passwords through Google Forms.

reCAPTCHA

Privacy Terms

This content is neither created nor endorsed by Google. Report Abuse - Terms of Service - Privacy Policy

Forms