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