Excel Exam 1

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

a. 60

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

a. =A1*C1

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. Calibri

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

c. $

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

c. 'Sales Data'!D10

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

b #N/A

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

b. .xltx

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

b. Cube

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

b. Function Library

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

b. Hyperlinks

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

b. Information

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

b. hyperlink

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

b. scrolling

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

a. INT

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

a. right side

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

c. OK

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

c. Optional

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

c. Time Sheet

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

c. template

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

d. 12

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

d. Fax Cover Sheet

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

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

d. remove

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

a. Cascade

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.

a. Excel performs exponentiation, then multiplication and division, then addition, and subtraction

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

a. Go

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

a. Shift + Enter

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"

a. The formula returns the text "RESTART"

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

a. Touch Mode

=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

a. a blank cell

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

a. absolute

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

a. an outline of the new location of the selected range

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

a. color coding

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

a. column heading

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

a. default

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

a. enable

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

a. mixed

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

a. right

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

a. search

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

a. shift

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

a. tabs

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

a. title bar

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

b. !

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

b. A does not eqaul B

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

b. Algebra

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

b. Alt + Enter

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

b. AutoFit

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

b. COUNT

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

b. Ctrl + Page Up or Ctrl + Page Down

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,

b. Feb, Mar, Apr

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

b. Flash Fill

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

b. Home

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

b. WorksheetRange!CellRange

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

b. arguments

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

b. break

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

b. 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

b. content

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.

b. destination

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

b. does not change

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

b. equals sign

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

b. exponentiation

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

b. external

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

b. relative

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

b. spreadsheet

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

b. the same number of left and right parentheses

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

c. 16,384

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

c. <<

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

c. AND

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

c. AutoComplete

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

c. Edit

______ 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

c. Lookup

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

c. MAX

_____ 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

c. Mixed

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

c. Page Break Preview

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

c. Sheet1:Sheet4

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.

c. The average of the values in the range A1:A100 is calculated

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

c. [Group]

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

c. [WorkbookName]WorksheetName!CellRange

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

c. a date format

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

c. absolute

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

c. arithmetic operators

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

c. colon

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

c. content and formats

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

c. go to a location in the worksheet command

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

c. group

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

c. link

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

c. logical

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

c. median

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

c. parentheses

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

c. portrait

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

c. scale

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

c. source

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

c. tab

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

c. the general syntax of all functions

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

d. '[Sales.xlsx]Summary Info'!B6

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

d. 2,1,3

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

d. 3-D

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)

d. =SUM(F6:F9)

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

d. AVERAGE

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

d. Ctrl + Home

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

d. Ctrl + S

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

d. Ungroup Sheets

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

d. files

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

d. lateral

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

d. nested

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

d. range

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

d. ranges

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

d. shortcuts

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

d. single quotation marks

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

d. true or false

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

d. what-if-analysis