FBLA Spreadsheet Applications Questions and Answers correct

FBLA Spreadsheet Applications Questions and Answers correct A specific location within a spreadsheet and is defined by the intersection of a row and column. Cell To print an entire worksheet/workbook use the Print button on the Standard toolbar F Functions do not start with = F Excel always starts spellchecking from the beginning of the worksheet. F When you select a chart the Data menu is replaced by the Chart menu T A grid line is a small line or marker on the category (x) and value (y) axes to help you read the values. F You can use the adjustment handle to rotate an object F To exit Excel: a. Choose Exit from the file menu b. turn off computer c. triple click mouse d. double click the title bar A To use the Redo command you can press: a. [CTRL]+[Z] b. [CTRL]+[Y] or F4 c. [CTRL]+[U] d. [CTRL]+[X] b You can change the font style and font size by using the: a. Edit name b. formatting toolbar c. file menu d. standard toolbar b which alignment is assigned to a value in a cell? a. right b. left c. center d. decimal a to open the format cells dialog box press: a. [CTRL]+[1] b. [CTRL]+[2] c. [CTRL]+[3] d. [CTRL]+[4] a to change the Autocorrect options you would use this menu: a. edit b. format c. insert d. tools d when you insert a new worksheet it is placed: a. in front of the active sheet b. behind the active sheet c. as sheet 1 d. as the last sheet in the worksheet a when you delete cells you are given the following option: a. shift cells right b. shift cells down c. entire row d. all of the above c the office clipboard is a temporary memory area that can hold up to _____ copied items. a. 8 b. 12 c. 24 d. 30 c to delete a cell press the following keys on the numeric keypad: a. [Ctrl]+[/] b. [Ctrl]+[dash] c. [Ctrl]+[+] d. [Ctrl]+[*] b 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 b when you edit a formula you can press ___ to move through the cell reference types. a. [F3] b. [F4] c. [F5] d. [F6] b for the logical_test part of the condition the IF function uses such functions as: a. OR b. NOT c. AND d. all of the above d functions can be entered in a worksheet through the: a. function command in the insert menu b. formula bar c. insert function dialog box d. all of the above d to find the monthly interest rate you must: a. multiply the rate by 12 b. multiply rate by 6 c. divide rate by 12 d. divide rate by 6 c 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 using this function any one of your logical test can be true for the result cell to show TRUE. a. OR b. AND c. IF d. NOT a to remove formatting from a cell or a range use the ___ menu. a. file b. edit c. format d. insert b in page break preview the page breaks inserted by excel appear as: a. blue dashed lines b. solid blue blues c. dashed green lines d. solid green lines a to center a page horizontally choose this tab from the page setup dialog box: a. page b. margins c. header/footer d. sheet b the function INT (9.678) will give you the following result. a. 9.7 b. 9.6 c. 9 d. none of the above c excel stores: a. the full numeral of decimals keyed b. 3 decimals places c. 2 decimals places d. 1 decimal place a the INT function is in the ___ category. a. financial b. logical c. math & trig d. date & time c 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 the chart wizard button is on the: a. formatting toolbar b. standard toolbar c. drawing toolbar d. chart toolbar b Formed by combining the cell's column letter and row number. Cell reference Identifies the location of a cell or a group of cells in a worksheet. Cell reference box A chart that is added to an active worksheet. Embedded chart A built formula that automatically performs calculations for a specified range of data. Function formula A box that identifies the patterns of colors that are assigned to the data series or categories in a chart. Legend A spreadsheet program file that you create in Excel. A workbook contains worksheets of rows and columns in which you can enter and calculate data. Workbook The subtotal feature creates an outline, a hierarchical structure of data. When a data set contains a structured list, you can collapse or expand the categories after using the Subtotal feature. Outline Process of analyzing large volumes of data using advanced statistical techniques and identifying trends and patterns in the data. Data mining