FBLA Spreadsheet multiple choice
Multiplication formulas use: a. * b. / c. + d. -
a. *
The wildcard character that represents any number of a character is: a. * b. ! c. ? d. &
a. *
Save your workbook in this format so it can be viewed on the world wide web: a. .html b. .xlt c. .xls d. .txt
a. .html
If you see a range address of A1:B3, the range would include: a. 6 cells on 3 rows and 2 columns b. 6 cells on 2 rows and 3 columns c. 4 cells on 6 rows and 3 columns d. 4 cells on 3 rows and 6 columns
a. 6 cells on 3 rows and 2 columns
To exit Excel: a. Choose Exit from the File menu b. Turn off your computer c. Triple-click the mouse d. Double-click the title bar
a. Choose Exit from the File Menu
The Ignore Once option in the Spell-Checking dialog box provides the following action: a. Does not change the spelling of this occurrence b. Does not change the spelling of any occurrence c. Adds this word to the dictionary d. Replaces the current spelling with the highlighted alternative
a. Does not change the spelling of this occurrence
To start in Edit mode: a. Double-click in a cell b. Triple-click in a cell c. Click in a cell d. None of above
a. Double-click in a cell
To change the AutoCorrect Options, you would use this menu: a. Edit b. Format c. Insert d. Tools
a. Edit
As you key data, it appears in the active cell and in the: a. Formula bar b. Status Bar c. Menu bar d. Name box
a. Formula bar
Which three alignments buttons appear in the Formatting toolbar? a. Left,Right,Center b. Left, Bottom, Justify c. Left, Right, Justify d. Left, Right, Distributed
a. Left, Right, Center
Using this function, any one of your logical tests can be true for the result cell to show TRUE. a. OR b. AND c. IF d. NOT
a. OR
If you want Excel to use the value as shown in the cell, use the ______ function. a. ROUND b. IF c. PMT d. AND
a. ROUND
To open the Format cells dialog box, press: a. [Ctrl]+[1] b. [Ctrl]+[2] c. [Ctrl]+[3] d. [Ctrl]+[4]
a. [Ctrl]+[1]
A chart sheet shows a: a. Chart in a sheet by itself b. chart in a sheet with a worksheet c. Chart in a Word document d. None of above
a. a chart in a sheet by itself
This type of alignment aligns contents in the middle of the cell: a. Center b. left c. right d. general
a. center
In the Page Break Preview, the page breaks inserted by Excel appear as: a. dashed blue lines b. solid blue lines c. dashed green lines d. solid green lines
a. dashed blue lines
To format a picture: a. double click the background b. triple click the background c. click the background d. none of above
a. double click the background
When you insert a new worksheet, it is placed: a. In front of the active sheet b. behind the active sheet c. as sheet one d. as the last sheet in the workbook
a. in front of the active sheet CHECK THIS
A guide that explains the symbols, patterns, or colors used to differentiate data series is a: a. Legend b. plot area c. value axis d. data series
a. legend
Excel stores: a. The full number of decimals keyed b. 3 decimal places c. 2 decimal places d. 1 decimal place
a. the full number of decimals keyed
An example of an absolute cell reference is: a. @B210 b. $A$1 c. "C6" d. *G7
b. $A$1
Division formulas use: a.* b. / c. + d. -
b. /
When payments are to be made at the beginning of a period, the Type argument in a financial function is specified as: a. 0 b. 1 c. 2 d. 3
b. 1
To remove formatting from a cell or a range of cells, use the _______ menu. a. File b. Edit c. Format d. Insert
b. Edit
You can change the font style and the font size by using the: a. Edit menu b. Formatting toolbar c. File menu d. Standard toolbar
b. Formatting toolbar
To center a page horizontally, choose this tab from Page Setup dialog box: a. Page b. Margin c. Header/Footer d. Sheet
b. Margin
A serial number is a date shown as a: a. Label b. Value c. Formula d. Function
b. Value
If you key label Week 1 in A1 and use the AutoFill handle to fill the series, what label would be in A5? a. Week 3 b. Week 5 c. Week 7 d. Week 8
b. Week 5
To delete a cell, press the following keys on the numeric keypad: a. [Ctrl]+[/] b. [Ctrl]+[-] c. [Ctrl]+[+] d. [Ctrl]+[*]
b. [Ctrl]+[-]
When you edit a formula, you can press _______ to move through the cell reference types. a. [F3] b. [F4] c. [F5] d. [F6]
b. [F4]
To change a column width: a. drag the row border to a different size b. Double-click a column's right border to auto fit c. double-slick the row's bottom border to Auto fit d. None of above
b. double click the columns right border to autofit
Which alignment is assigned to a value in a cell? a. right b. left c. center d. decimal
b. left
To combine a range of cells into one cell that occupies the same amount of space, use the _________ button on the Formatting Toolbar. a. Align Left b. Merge and Center c. Align Right d. Center
b. merge and center
Because Excel stores data as numbers, date calculations are: a. Not possible b. possible c. necessary d. None of above
b. possible
The MIN function calculates the _______ value in a range. a. largest b. smallest c. average d. none of above
b. smallest
The Chart Wizard button is on the: a. Formatting toolbar b. standard toolbar c. drawing toolbar d. chart toolbar
b. standard toolbar
The file extension that excel automatically uses for workbook is: a. .xlw b. .exl c. xls d. .mxl
c. .xsl
Formatting January 1, 2003 with a custom format of DD MMMM Y would result in the following: a. 01 Jan 03 b. 01 Jan 2003 c. 01 January 03 d. 01January 2003
c. 01 January 03
You can choose from ____ 3-D styles. a. 10 b. 15 c. 20 d. 25
c. 20
The Office Clipboard is a temporary memory area that can hold up to ___ copied items. a. 8 b. 12 c. 24 d. 30
c. 24
The function INT(9.678) will give you the following result: a. 9.7 b. 9.6 c. 9 d. None of above
c. 9
A cell reference that does not change when a formula is copied: a. Actual b. Simple c. Absolute d. Relative
c. Absolute
A/an _______ reference does not change when a formula is copied. a.Relative b. Mixed c. Absolute d. None of above
c. Absolute
To add text in an IF function, you enclose the text in: a. Parentheses b. Brackets c. Quotation marks d. None of Above
c. Quotation marks
To move a screen down one page, press: a. [Enter] b. [Delete] c. [PgDn] d. [Spacebar]
c. [PgDn]
While using the Format Painter, the pointer is: a. a double headed arrow b. a four headed arrow c. a white cross with a small paintbrush d. a cross-hair
c. a white cross with a small paintbrush
To show percentage on a slice of a pie chart, use this tab in the Format Data Series dialog box: a. Axes b. Grid lines c. data labels d. data tables
c. data labels
To find the monthly interest rate you must: a. multiply the rate by 12 b. multiply the rate by 6 c. divide the rate by 12 d. divide the rate by 6
c. divide the rate by 12
When you delete cells, you are given the following options: a. Shift cells right b. Shift cells down c. Entire row d. All of above
c. entire row
Which type of vertical alignment positions the text at an equal distance from the top and bottom edges? a. top b. distributed c. justify d. center
c. justify
Charts that show trends in data over a period of time are: a. bar charts b. column charts c. lines charts d. pie charts
c. line charts
You can use the AutoShape button: a. to draw an object b. to draw a text box c. to display a list of preset objects d. to draw an arrow
c. to displays a list of preset objects
For the logical_test part of the condition, the IF function uses such functions as: a. OR b. NOT c. AND d. All of above
d. All of above
To print a worksheet: a. Click the Print button b. Choose Print from the File menu c. Press [Ctrl]+[P] d. all of above
d. All of above
Functions can be entered in a worksheet through the: a. Function command in the Insert menu b. Formula bar c. Inert Function dialog box d. All of the above
d. All of the above
To hide a column heading, select the column and choose Column, Hide from the ________ menu. a. File b. Edit c. Insert d. Format
d. Format
Use the ______ dialog box to make several changes at once to an AutoShape. a. format text box b. format object c. format picture d. format AutoShape
d. Format AutoShape
You can create a formula using the IF function that displays text based on whether a condition is: a. Old or new b. Greater or less than c. First or last d. True or false
d. True or false
The horizontal axis is generally the: a. Y axis b. Z axis c. T axis d. X axis
d. X axis
To paste a range of cells, press: a. [Ctrl]+[X] b. [Ctrl]+[C] c. [Ctrl]+[P] d. [Ctrl]+[V]
d. [Ctrl]+[V]
To use Redo command, you can press: a. [Ctrl]+[Z] b. [Ctrl]+[X] c. [Ctrl]+[U] d. [Ctrl]+[Y]
d. [Ctrl]+[Y]
To accept an AutoComplete suggestion, press: a. [Esc] b. [Tab] c. [Space] d. [Enter]
d. [Enter]
You can use the Find command to locate: a. words b. sequence of characters c. formats d. all of above
d. all of above
When you select a chart, the Data is replaced by the: a. Insert menu b. Tools menu c. Format menu d. Chart menu
d. chart menu
