Excel Exam 1

The advantage of an electronic _____ is that the content can be easily edited and updated to reflect changing financial conditions. a. database b. spreadsheet c. expression d. formula

Keyboard ____ can help you work faster and more efficiently because you can keep your hands on the keyboard. a. KeyTips b. ScreenTips c. ShortTips d. shortcuts

In _____, the ribbon increases in height, the buttons are bitter, and more space appears around each button so you can more easily use your finger or a stylus to tap the button you need. a. Touch Mode b. click Mode c. Tap Mode d. Normal mode

"AZ" is an example of a ________. a. column heading b. row heading c. cell reference d. Name box

To go to column A of the current row, press ____. a. Ctrl _ Home b. Home c. Shift + Tab d. Tab + Enter

An excel worksheet can have a maximum of _____ columns in a worksheet. a. 156 b. 256 c. 16,384 d. 17 million

To make A1 the active cell, you should press which of the following keys? a. Page Up b. Page Down c. Home d. Ctrl + Home

You can move to the previous or next sheet by pressing the _______ keys. a. Alt + Page Up or Alt + Page Down b. Ctrl + Page Up or Ctrl + Page Down c. Tab + Page Up or Tab + Page Down d. F4 + Page Up or F4 + Page Down

Each range is identified with a range reference that includes the cell reference of the upper-left cell of the rectangular block and the cell reference of the lower-right cell separated by a _____. a. semi-colon b. period c. colon d. comma

The characters +, -, *, and / are all examples of _____. a. formulas b. values c. arithmetic operators d. calculations

An Excel formula always begins with a(n) _____. a. parentheses b. equals sign c. plus sign d. colon

The formula used to multiply cell A1 by cell C1 is _____. a. =A1*C1 b. C1*A1 c. =A1/C1 d. A1*C1

A(n) _____ is a group of cells in a rectangular block. a. cluster b. adjunct c. selection d. range

When you insert a new column, the existing columns are shifted to the _____ and the new column has the same width as the column directly to its left a. right b. up c. down d. left

If you want to create a new line within a cell, press the ________ keys to move the insertion point to the next line within the cell a. Ctrl + Enter b. Alt + Enter c. Alt + E d. Ctrl + E

What is the result of the expression =50+20/10*5? a. 60 b. 1 c. 25 d. 50

To change the order of operations enclose part of the formula in __________ a. brackets b. italics c. parentheses d. quotation marks

Excel makes reading formulas simpler by ____________ each cell reference in the formula and its corresponding cell in the worksheet. a. color coding b. bolding c. highlighting d. italicizing

to switch to ____ mode, you double-click the cell a. Insert b. Copy c. Edit d. Paste

To change a column width, you can click _______ on the Column submenu to make the column(s) as wide as the longest entry of the cells in the column. a. QuickFit b. AutoFit c. Full Column d. Longest

_____________ makes it easier to enter repetitive text in cells a. Editing mode b. AutoFit c. AutoComplete d. AutoFill

Which of the following takes precedence over multiplication? a. division b. exponentiation c. addition d. subtraction

_______ enters text based on patterns it finds in the data a. AutoComplete b. Flash Fill c. AutoFit d. Fill

In ______ orientation, a page is taller than it is wide. a. natural b. landscape c. portrait d. basic

_____ displays the location of the different page breaks within the worksheet. a. Normal b. Page Preview c. Page Break Preview d. Page Break Layout

You can ______ the width or the height of the printout so that all the columns or all of the rows fit on a single page. a. shrink b. size c. scale d. scroll

According to the order of operation in Excel: a. Excel performs exponentiation, then multiplication and division, then addition, and subtraction. b. Excel performs multiplication, then exponentiation, then division, then addition, and then c. Excel performs exponentiation, then multiplication, then division, then subtraction, and then addition. d. Excel performs multiplication, hen division, then exponentiation, then addition, and then subtraction.

To move the active cell up one row, press _____. a. Shift + Enter b. Ctrl + Tab c. Shift + Tab d. Ctrl + Enter

Which of the following will not change the location of the active cell? a. drag and drop b. scrolling c. clicking another cell d. clicking a column heading

When you copy a selection of cells using drag and drop, which appears before you release the mouse button? a. an outline of the new location of the selected range b. the range c. a cell reference of the old location d. shortcut tip

What is the syntax for a SUM formula adding the values of cell F6 to F9? a. /SUM(F9:F6) b. =SUM(F6/F9) c. =END(F6:F9) d. =SUM(F6:F9)

Ctrl + G is used to access the _____. a. go to next worksheet command b. G column c. go to a location in the worksheet command d. formula view

mm/dd/yyyy is known as ______. a. a text string b. text data c. a date format d. number data

Whenever you click the save button on the Quick Access Toolbar or press the _____ keys, the workbook file is updated to reflect the latest content. a. Ctrl + V b. Ctrl + G c. Ctrl + C d. Ctrl + S

To move or copy a range of cells, select the correct order: 1. move the pointer over the border of the selection until the pointer changes shape. 2. Select the cell or range you want to move or copy. 3. To move the range, click the border and drag the selection to a new location, or to copy the range, hold down the Ctrl key and drag the selection to a new location. a. 1,2,3 b. 3,2,1 c. 1,3,2 d. 2,1,3

The ____ category of Excel functions retrieves data from multidimensional databases involving online analytical processing. a. OLAP b. Cube c. Logical d. Text

The _______ category of Excel functions returns (true-false) values. a. Information b. Statistical c. Logical d Math & Trig

Which of the following is a statistical function? a. INT b. RAND c. ROUND d. AVERAGE

Which of the following is a Math & Trig function? a. INT b. RAND c. ROUND d. AVERAGE

=ROUND(AVERAGE(A1:A100),2) is an example of a(n) ______ function. a. complex b. logical c. absolute d. nested

After you describe a function in the Search for a function box in the Insert Function dialog box, click __. a. Go b. Select c. Insert d. Next

The numbers, text or cell references used by the function to return a value are called _________. a. expressions b. arguments c. data d. values

Which of the following is not a comparison operator? a. = b. <= c. << d. <>

In the following formula: =IF(A1="YES","DONE","RESTART"), what happens if A1="NO"? a. The formula returns the text "Restart". b. The formula returns the text "DONE" c. The formula returns the text "NO" d. The formula returns the text "NO, RESTART"

Which of the following is not a date function? a. YEAR b. NOW c. AND d. TODAY

The ___ function returns the maximum value in the range a. TOP b. FIRST c. MAX d. MOST

One of the greatest advantages of ________ references is that you can quickly generate row and column totals without having to worry about revising the formulas as you copy them to new locations. a. cell b. relative c. absolute d. formula

Absolute references are marked with a _. a. < b. : c. $ d. !

When you copy a formula that contains an absolute reference to a new location, the reference ____ ___ _____. a. is updated automatically b. does not change c. becomes bold d. has a dotted outline in its cell

Use ________ references when you want different formulas to refer to the same cell. a. mixed b. relative c. absolute d. fixed

Another name for the middle value is the ______ value. a. mode b. center c. median d. relative

________ arguments may provide more control over the returned value. a. Relative b. Required c. Optional d. Absolute

FUNCTION(argument1, argument2, ...) is _________________. a. the syntax of writing optional arguments b. an example of a formula c. the general syntax of all functions d. the general syntax of all formulas

If an optional argument is not included, Excel assumes a(n) _______ value for it. a. default b. generic c. static d. absolute

Excel functions are organized into __ categories a. 8 b. 10 c. 11 d. 12

Which of the following is not an Excel function category? a. Math & Trig b. Algebra c. Statistical d. Text

Which function couts how many cells in a range contain numbers, where value1, value2, and so forth are text, numbers, or cell references? a. SUM b. COUNT c. COUNTA d. AUTOSUM

In "SUM(number1,[number2, number3, ...])", number 1, number 2, and number 3 may be numbers or ______________. a. letters b. cell references c. symbols d. operators

Which category of Excel functions returns information about the format, location, or contents of worksheet cells? a. Location b. Information c. Reference d. Description

In the formula =INT(AVERAGE(A1:A100)), which would occur first? a. The average of the values in the range A1:A100 is added to the integer. b. The average of the integer value is calculated c. The average of the values in the range A1:A100 is calculated d. The integer portion of the value is extracted.

When you nest functions, you should have _________________. a. the equal sign b. the same number of left and right parentheses c. at least two functions d. the correct number of brackets

The Insert Function button is in the ___________ group. a. Calculation b. Function Library c. Sort & Filter d. Home

The Insert Function dialog box has a(n) _______ option. a. search b. formatting c. find and replace d. expand/collapse

The fill handle copies __________. a. content only b. formats only c. content and formats d. formats and cell references

Using the AutoFill Options button, the Fill Without Formatting option copies the _______ but not the formatting. a. functions b. content c. cell references d. lift-aligns

Using AutoFill, what would be the extended series of the initial entry Jan? a. uary b. Feb, Mar, Apr c. Kan, Lan, Man, Nan d. Jan1, Jan2, Jan3,

a. A logical function is a function that works with values that are either __________. a. right or wrong b. absolute or relative c. positive or negative d. true or false

In the Formula =IF(A1=B1, C1, C2), the result will be C2 if ________. a. A is equal to B b. A does not equal B c. A1+B1 is equal to C1 d. A1>B1 is equal to C2

_____ references are seldom used other than when creating tables of calculated values such as a multiplication table in which the values of the formula or function can be found in the initial rows and columns of the table. a. Absolute b. Relative c. Mixed d. Matched

=IF(g22="x", SUM(H22:J22), "") with display ______ if G22 is not equal to "x". a. a blank cell b. the result of the SUM c. dashes d. False

______ functions find values in tables of data and insert them in another location in the worksheet such as cells or in formulas. a. Sum b. Average c. Lookup d. Find

If the VLOOKUP function cannot find the lookup value, the ___________ error value is displayed in the cell. a #VALUE b. #N/A c. #ERROR d. #NULL

One way to perform a __________ is by changing one or more of the input values to see how they affect the calculated results. a. goal seek b. function c. search d. what-if-analysis

A worksheet ____ is a collection of two or more selected worksheets. a. index b. roster c. group d. cluster

like cell _____, a worksheet group can contain adjacent or nonadjacent sheets. a. controls b. groups c. tabs d. ranges

To select adjacent worksheets, you use the ______ key. a. Shift b. Alt c. Ctrl d. F1

The _____ caption indicates a worksheet group a. [Worksheets] b. [Selected Sheets] c. [Group] d. [Workgroup]

To ungroup worksheets, you can click a sheet _____ of a sheet not in the group. a. index b. panel c. tab d. pane

When a worksheet group is selected, the _____ includes text to indicate this. a. title bar b. worksheet bar c. status bar d. formula bar

To remove a worksheet group, you can right-click the sheet tab of a sheet in the group and then click _____ on the shortcut menu. a. Remove Group b. No Group c. Exit Group d. Ungroup Sheets

To move a worksheet or worksheet to another location in the same workbook, select the worksheets and then drag and drop them by the selected sheet _____. a. tabs b. indices c. keys d. icons

When you reference a cell or range in a different worksheet, the ____ separates the sheet reference from the cell reference. a. ? b. ! c. " d. ;

When you reference cells and ranges in other worksheets, if the worksheet name contains spaces, you must enclose the sheet name in _____. a. braces b. brackets c. parentheses d. single quotation marks

Which of the following formulas is correct, given a sheet named sales Data? a. (Sales Data)!D10 b. [Sales Data]!D10 c. 'Sales Data'!D10 d. {Sales Data}!D10

The general format of a 3-D cell reference is ______. a. CellRange!WorksheetRange b. WorksheetRange!CellRange c. WorkbookRange!CellRange d. CellRange!WorkbookRange

The worksheet range _____ references the worksheets, "Sheet1," "Sheet2," "Sheet3," and "Sheet4." a. Sheet1_Sheet4 b. Sheet1-Sheet4 c. Sheet1:Sheet4 d. Sheet1/Sheet4

A(n) _____ cell reference specifies not only the rows and columns of a cell range, but also the names of the worksheets on which the cells appear. a. indexed b. relational c. absolute d. 3-D

A link is a connection between two ______ allowing information to be transferred from one to the other. a. cells b. ranges c. columns d. files

If you need to use data located in one workbook in the other workbook, you have to create a(n) _____ between the two workbooks. a. anchor b. source c. link d. index

The general form of an external reference is _____, where Path is the path of the workbook file on the computer or network, Workbook Name is the filename of the workbook, and Sheet Range and Cell Range are worksheets and cells in the workbook, respectively. a. (WorkbookName)WorksheetName!CellRange b. [WorkbookName]WorksheetName!CellRange c. [WorkbookName]WorksheetName!CellRange d. /WorkbookName/WorksheetName/CellRange

If you want to create a cell reference to B6 on the Summary Info worksheet of the Sales.xls workbook, you would use the following external reference: a. '[Sales.xlsx]Summary Info'/B6 b. '(Sales.xlsx)Summary Info'!B6 c. '[Sales.xlsx:Summary Info]'!B6 d. '[Sales.xlsx]Summary Info'!B6

Which of the following is NOT an option for arranging you workbooks? a. tiled b. cascade c. horizontal d. lateral

The _____ arrangement option layers the open workbooks on the screen. a. Cascade b. Horizontal c. Tiled d. Lateral

A formula can include a reference to another workbook (called an ____ reference), which creates a set of linked workbooks. a. internal b. external c. import d. export

You can create a(n) _____ reference by deleting the $ from the row reference in the cell reference $B$6. a. mixed b. absolute c. relative d. indexed

Formulas created using the point-and-click method contain _____ references. a. absolute b. mixed c. relative d. relational

If you receive a destination workbook but the source files are not included, click the ______ link button in the Edit Links dialog box to replace the external references with the existing values. a. fix b. break c. update d. check

If you trust the provider of source files, you can choose to ______ the content, which allows the external reference formulas to function and updates the links in the destination workbook. a. enable b. embed c. concatenate d. consolidate

When you save a workbook that contains external reference formulas Excel stores the most resent results of those formulas in the _____ file. a. source b. destination c. both a. and b. c. neither a. nor b.

If the destination file is closed when you make a change in the _____ file, you can choose whether to update the link to display the current values when you open the destination file. a. target b. origin c. source d. key

If Excel successfully accessed the link and updated the values from the source document, the status in the Edit Links dialog box will be _____. a. Done b. completed c. OK d. Good

____ are usually represented by words with colored letters and underlines or images. a. Indices b. Hyperlinks c. Templates d. Icons

When you click a(n) ____, the computer switches to the file or portion of the file that it references. a. index b. hyperlink c. template d. icon

The default ____ for a hyperlink is the folder location and the name of the file to which you will link. a. title b. alt text c. description d. ScreenTip

To delete the hyperlink but keep the text, right-click the hyperlink cell and then click ____ Hyperlink. a. delete b. erase c. archive d. remove

the default template contains the default formatting you start out with in every new workbook including _____ 11-point font. a. Calibri b. Helvetica c. Geneva d. Times New Roman

A ____ is a workbook that you can open with the text, formats, and formulas already built into is. a. boiler b. summary sheet c. template d. range master

Which of the following is NOT a task-specific template available from the Microsoft Office Online Website? a. Family Budget b. Inventory List c. Team Roster d. Fax Cover Sheet

The _____ template in Excel creates an online time card to track employees' work hours. a. Payroll b. Personnel Statement c. Time Sheet d. Employment Calculator

The default template places the formula results aligned to the ____ of a cell. a. right side b. left side c. top d. bottom

All template files have a(n) _____ extension. a. .xlsx b. .xltx c. .xldx d. .xtpl