Exam Review

What is an advantage of storing Excel data in .txt or .csv files?

.txt and .csv files are much smaller in size

* ALL the Cells on a worksheet are locked by default. A true B false

A

*****92 Electoral Votes - Data.docx Refer to the Electoral College data. The average land area (sq. miles) of Oregon and Wyoming is: A. 96,548.60 B. 97,100.40 C. 98,876.13 D. 95,783.45

A

A 'Legacy System' refers to: A. Older technologies B. Patented technologies C. Theoretical technologies D. Branded technologies

A

Converting rows to columns and columns to rows is called: A. Transposing B. Converting C. Row-Column Conversion D. Altpositioning

A

From the options below, choose the Data Validation formula to prevent users from adding a space before or after the text in the entry. No data is presently in the worksheet. The first entry will be made in cell A1. A. " =A1 = TRIM(A1)" B. " =A1 = TRUNCATE(A1)" C. " =A1 = CUT(A1)" D. None of the above

A

How can we copy only the formatting? A. Use Copy-Paste-Specia B. Copy and paste C. Either a or b D. Neither a nor b

A

I have three tables. Each table has 6 rows and 5 columns. I want to multiply each value in one table with the values in the corresponding row and column in each of the other two tables. I then want to sum all of these values. A. I can use the SUMPRODUCT function to do this. B. I cannot use the SUMPRODUCT function because there are more than two sets of data. C. I cannot use the SUMPRODUCT function because the three tables have identical dimensions. D. Both b and c are correct.

A

In the R1C1 format, cell address CQ910 is: A. R910C9 B. R910C432 C. R910C104

A

In the VLookup function, if the Range_Lookup argument is omitted, it is assumed to be: A. True B. False C. Vertical D. Horizontal

A

In the VLookup function, the lookup value will be compared to values in which column in the corresponding table array? A. Column 1 B. Column 2 C. Column 3 D. Any column

A

Information function can test if a cell is blank A. True B. False

A

Switching rows and columns of data is called _______________ A. Transposing B. Tracking C. Formatting D. Querying

A

The format to display 12000 as 12 is: A. #, B. ##,.-#k C. ##.--- D. ##.,--

A

The functionality of SUMIF is A. Sums a range of cells if a condition is met B. Sums a range of cells C. Same as SUMPRODUCT D. None of the above

A

The scope of a range name can be restricted to a single worksheet A. True B. False

A

To what does "active worksheet" refer? A. The worksheet where the cursor is B. The first worksheet C. The worksheet with the most cells with data D. None of the above

A

Tom wants to know if he is now using Excel 2013 or Excel 2010 on his computer. Which argument should he use in INFO function? A. Release B. System C. Version D. Osversion

A

What does an absolute reference do? A. The row and/or column reference will not change if the formula containing the reference is copied to another location B. The cell will always contain the absolute value of any number entered into it C. The cell reference changes if the formula containing the reference is copied to another location D. It is the only formula used to refer to a cell on another spreadsheet

A

What does the TRUNC function do? A. Trims a positive number down(towards zero) B. Rounds a positive number up(to next higher integer) C. Both A and B true D. Neither A nor B true

A

What is the default file extension for a workbook in Excel 2013? A. .xls B. .xlm C. .csv D. .xls

A

What is the symbol used to concatenate text? A. '&' (ampersand) B. '+' (plus) C. '-' (minus) D. '*' (star)

A

What will the minute hand of a clock read when it is 0.38 into a day? A. 7 B. 11 C. 14 D. 17

A

Which of the following options about customizing a ribbon is TRUE? A. We cannot remove a command button from a default command group B. We cannot add a new group to a ribbon C. We cannot rename a customized ribbon D. We cannot add a new ribbon

A

Which of the following returns a non-integer random number? A. RAND B. RANDBETWEEN C. NONINTRAND D. DECIMALRAND

A

You are in cell J10. If you put =R[-5]C[-2]-3+R[6]C[2], this will result in the value: A. -3 B. -2 C. -5 D. 0

A

*****The easiest way to select an entire column is by: A. Clicking the column label (Column A, B etc.) B. Double-clicking any cell in that column C. Either A or B D. Neither A nor B

A ????

The ";QAT"; can be customized by:

A and B only

*****90 Electoral Votes - Data.docx Refer to the Electoral College data. Which of the following state has the least land area (sq. miles)? A. Alabama B. Delaware C. District of Columbia D. Vermont

B

*****91 Electoral Votes - Data.docx Refer to the Electoral College data. The population of Illinois is: A. 1,211,537 B. 12,419,293 C. 1,241,283 D. 13,452,234

B

A number format can have up to four sections of code, but they need to be A. separated by commas B. separated by semicolons C. separated by parentheses D. separated by square brackets

B

A number format can have up to four sections of code, but they need to be: A. separated by commas B. separated by semicolons C. separated by parentheses D. separated by curly brackets

B

Assume cell A1 contains the text string "Emmett Smith" (with no quotation marks). Which of the following will find the position of the THIRD M? A. =FIND("m",A1,1) B. =FIND("m",A1,4) C. both a and b D. neither a and b

B

Cell B3 has a value of 30 and is named LoanPeriod. If we were to enter"=Loan Period" (without quotes) in any other cell, we would get? A. 30 B. An error message C. Loan Period D. None of the above

B

Constants should be: A. Embedded in formulas B. Placed in individual cells C. Placed in separate workbooks D. Entered manually every time a model is solved

B

How many arguments does the INFO function need? A. 0 B. 1 C. 2 D. It differs from function to function

B

I need to extract data into excel from a large external database. In which of the following categories will I find a function to do this: A. Data functions B. Cube functions C. Extract functions D. Statistical functions

B

I type a positive number 99.999 in a cell, and the number 100.00 is shown in red and in parentheses. This means the following number format is used. A. [red](#,###.###);[green](#,###.00); B. [Red](00.00); [Green](#,###.00); C. [red]#,00;[green](0.00; D. [Red](#,#00); [Green](#,###.00)

B

If an apostrophe precedes a number, then: A. The number is entered as a number B. The number is entered as text C. The number is entered in date format D. None of the above

B

If you assign the value 42 to cell E5, the value 11 to cell F5, and cell G5 contains the function =IF(E5>4*F5, "Deductions", "No deductions"), then cell G5 displays the message, ____________. A. Deductions B. No deductions C. #REF! (That is, you get an error message #REF!) D. F5

B

In a .csv file, the values are separated by a _____? A. Space B. Comma C. Tab D. Vertical bar (also known as 'pipe')

B

In cell A1 I have the name "JOHN SMITH". What formula will I use to change "JOHN SMITH" to "JANE SMITH" (in cell A2, or some other cell). A. =Replace("JOHN", "JANE") B. =SUBSTITUTE(A1, "JOHN", "JANE") C. =SUBSTITUTE(A1, "John", "JANE") D. =Change("JOHN", "JANE")

B

Merging serval cells, each of which has data, will: A. Combine all data into one cell B. Retain data only in the left( or upper) most cell C. Retain data only in the right ( or lower) most cell D. Delete data in all cells

B

Merging several cells, each of which contains data, will: A. Combine all data into one cell B. Retain data only in the left (or upper) most cell C. Retain data only in the right (or lower) most cell D. Delete data in all cells

B

Ten students take a quiz. Each student answers 50 questions. I now have a dataset of 500 questions and answer. If the student has answered a question correctly, he gets 1 point.which of the following excel functions will I use to get the average of each student's marks: A. Averageifs B. Subtotal C. Groupby D. Averageif

B

The COUNTA function: A. Counts all of the cells in a range with numeric values B. Counts all nonblank cells in a range C. Counts only values in a range that are both non-numeric and non-blank D. None of the above

B

The NOT function _________ the logic of the argument. A. retains B. reverses

B

The scope of a range name cannot be restricted to a single worksheet. A. True B. False

B

What does "NUMFILE" tell us? A. The number of worksheets in current workbook B. The number of worksheets in all open workbooks C. The number of workbooks D. None of the above

B

What does R8C1 represent in A1 cell referencing? A. A7 B. A8 C. C7 D. C1

B

What does the "Treat consecutive delimiters as one" option do? A. Enables the import of data with different kinds of delimiters B. Ensures Excel ignores consecutive separators C. Aligns the imported text to the right D. Ensures that each value is separated by consecutive blank columns

B

What is one way to prevent spelling errors using data validation? A. Use spell check B. Use a list to select from predetermined options C. Slow typing rate to 20 words per minute D. Use the Validate Spelling command E. B and D

B

What is the minimum number of worksheets in each workbook? A. Three B. One C. Five D. There is no minimum

B

What technique do you use to keep certain cells visible, even when the user scrolls away from those cells? A. Nailing B. Freezing C. Gluing D. Stapling

B

When do error alerts appear in Data Validation? a. A user enters invalid data in the cell by copying another cell b. A formula in the cell calculates a result that is not valid c. Doing either A or B gives an error message d. Doing either A or B does not give an error message

B

Which custom data validation formula will prevent user from adding any space in a text string? The first entry will be entered in cell A1. A. =A1=REPLACE(a1," ","") B. =A1=SUBSTITUTE(A1," ","") C. Both A and B D. None of the above

B

Which of the following gives us the current column number? A. Col( B. Column() C. current() D. None

B

Which of the following is FALSE? A. QAT stands for 'Quick Access Toolbar B. The default buttons on the QAT cannot be removed C. The QAT can be positioned above or below the ribbon D.Adding a command to the QAT does not affect the availability of the command in its original location

B

Which of the following is NOT a valid range name? A. SamCola B. Sam Cola C. Cola_Sam D. Sam_Cola

B

Which of the following is a system of referencing cells? A. 1A B. B2 C. R1C1 D. R10C10

B

Which of the following is considered as a number in Excel? A. Text B. Time C. Formula D. None of the above

B

Which of the following is not a valid rule for naming ranges? A. It can contain a period, numbers, and letters B. It can contain spaces C. It can start with an underscore D. It is case sensitive

B

Which of the following options would allow you to scroll within a pane of rows and columns? A. VIEW ribbon > Window Group > Scroll B. VIEW ribbon > Window Group > Split C. VIEW ribbon > Window Group > Unfreeze D. VIEW ribbon > Window Group > Freeze> Scroll

B

Which of these functions can I use to calculate the cube of a number? A. ABS B. POWER C. MOD D. None of these

B

Which statement is correct A.It is a good idea to use the paste list command before we have created all the required range names B.Once a list is pasted, it does not update to reflect new range names C.A and B are correct D. A and B are wrong

B

Which statement is correct about pasting range names? A. It is a good idea to use the "Paste List" command before we have created all the required range names. B. Once a list is pasted, it does not update to reflect new range names. C. Both A and B are correct D. Both A and B are wrong

B

With regard to the QAT, which of the following options is FALSE? A. You can add a command button (to QAT) by right clicking that command (from the ribbon) B. You can remove a command button (from QAT) by right click that command from the ribbon

B

info("Origin")function will return the relative cell reference of the upper-left cell visible in the current window. A. True B. False

B * will return the absolute cell reference

* I need to convert a number from hexadecimal to decimal. In which of the following categories will I find a function to do this. A. Compatibility functions B. Cube functions C. Engineering functions D.

C

*****Which of the following statements is FALSE with respect to number formats? A. A number format can have up to four sections of code B. All four code sections do not need to be included C. If you specify only one code section, it is used for text D. Text, in a code section, needs to be separated by double quotes

C

12:00 PM in Excel can be represented as: A. 0.5 AM B. 0.5 PM C. 0.5 D. 1

C

A person is classified as a Junior, Adult, Senior depending on his age as follows: 0 to 18 years: Junior 19 to 60 years: Adult 61 and above: Senior What formula can I use to get this classification? (Assume all ages are integer values). A. If(AGE<19,18<AGE<60, AGE>60, "Minor","Adult","Senior") B. If(AGE<18, "Junior",If(And(AGE>18,AGE<61), "Adult", "Senior")) C.If(AGE<19,"Junior",If(And(AGE>18,AGE<61),"Adult","Senior")) D. None of the above

C

A range name can be: a. Used for numbers b. Used for text c. Both a and b d. Neither a nor b

C

Assume cell A1 contains the text string "Naveen Jindal" (with no quotation marks). Which of the following will find the position of the letter J? A. =LEFT("J",A1) B. =LEFT(A1, "J") C. =FIND("J",A1,1) D. =FIND("J",A1,9)

C

By appropriately defining the 'scope' of a range name you can: A. Restrict the range that the name represents B. Establish whether the name refers to text or numbers C. Use the same name in different worksheets in the same workbook D. A and B E. A and B and C

C

Copy and Paste A. ... will not work for data entry B. ... will paste text but not numeric values C. ... overwrite current formatting in a cell D. ... will not work for formulae

C

Excel (2013 and later versions) sorts data by which of the following? A. Text B. Color C. Both a and b D. Neither a nor b

C

Excel information function can provide information about A. A cell or range of cells B. An error C. A and B D. Neither A nor B

C

Excel opens a new workbook with: A. 5 worksheets B. 16 worksheets C. as many sheets as are specified as a default value D. None of the above

C

If a file is read-only it means A. We can make changes to the file and save the file with a different name B. We can make changes to the file but cannot save it with same name in original C. Both a and b are true D. Neither a nor b is true

C

If there is a formula"= Sum ($B$3:$B$8)" in cell B9, what is the formula when we copy it into cell B12? A. =Sum ($C$3:$C$9) B. =Sum ($B6:C$12) C. =Sum ($B$3:$B$8) D. =Sum (C3:C12)

C

If there is a formula"= Sum ($B$3:$B$8)" in cell B9, what is the formula when we copy it into cell B12? a. =Sum ($C$3:$C$9) b. =Sum ($B6:C$12) c. =Sum ($B$3:$B$8) d. =Sum (C3:C12)

C

If you copy the formula D$38 from one cell into another cell: A. Both the row and the column will change B. The column will remain the same, the row may or may not change C. The row will remain the same, the column may or may not change D. The column will remain the same, the row will definitely change

C

In Excel, you can create a data series by using the Fill-Series command. Which of the following types of data can be created? A. Linear series B. Date series C. Both A and B D. Neither A nor B

C

In the VLookup function, the 'range lookup' argument: A. Is optional B. Has a default value of TRUE C. Both a and b D. Neither a nor b

C

LCM returns the A. Highest common factor B. Greatest common divisor C. Least common multiple D. All of the above

C

R1048569C16374 is equivalent to A. XEV1048569 B. XEQ1048572 C. XET1048569 D. XEZ1048569

C

The 'Month' argument in EoMonth(Date, Month) can be: A. A positive number B. A negative number C. Either A or B D. Neither A nor B

C

The VLookup function can be used to find: A. The exact value corresponding to a given number in a lookup table B. The approximate value corresponding to a given number in a lookup table C. Both a and b D. Neither a nor b

C

The VLookup function has how many required arguments? A. 1 B. 2 C. 3 D. 4

C

The date format to display the day as 'Sun' is: A. d B. dddd C. ddd D. dd

C

The number of active worksheets is given by: A. INFO("ACTIVE") B. Worksheet () C. INFO("NUMFILE") D. None of the above

C

The number of rows in a spreadsheet: A. Can be increased by inserting additional rows B. Can be increased by using the EXPANDROW () function C. Cannot be increased D. Can be increased only if number of columns are also increased

C

The scope of a range name: A. Can be restricted to a worksheet B. Can be restricted to a workbook C. Both A and B D. Cannot be restricted

C

Typing "=R4C[-3]" in cell F8 is equivalent to: a. =D$5 b. =G$2 c. =C$4 d. =F$9

C

We can refer to a cell in Excel by using which of the following reference systems? A. A1 referencing B. R1C1 referencing C. Both a and b D. Neither a nor b

C

What are the advantages of using specified lists in data validation? A. Ensures that only permitted names are entered B. Prevents errors in spelling C. Both A and B D. None

C

What is the formula reference of R8C1 in R1C1 format if the formula in A1 format is"=H6+K4"? A. "=RC(3)+R(2)C(5)" B. "=R(-2)C(7)+R(2)C(5) C. "=R(-2)C(7)+R(-4)C(10)" D. "=R(-2)C(6)+R(-4)C(9)"

C

Which function allows for including holidays as one of its arguments? A. Edate B. EoMonth C. NetWorkDays D. WeekNum

C

Which of the following are valid outputs of recalc()? A. Manual B. Automatic C. Both a and b are valid D. Neither a nor is valid

C

Which of the following file formats can be read in Word? A. .xlsx B. .xlsm C. .csv D. All of the above

C

Which of the following is NOT a valid way to get data into Excel? A. Entering data directly from a worksheet B. Copying and pasting data C. Copying and pasting images of data D. Importing data from another file

C

Which of the following is TRUE? A. By default Excel aligns numbers to the right B. By default Excel aligns texts to the left C. Both A and B are true D. Neither A nor B is true

C

Which of the following is a likely benefit from using a range name? A. It can reduce errors in data entry B. It makes entry of formulae easier C. Both A and B are benefits D. Neither A nor B is a benefit

C

Which of the following is not an advantage of using a range name A. Range names can make it easy to read a formula B. Range names are absolute C. Range names are relative D Range names facilitate updating data

C

Which of the following pairs is correct? A. A7; R7C7 B. C23; R3C2 C. J22; R22C10 D. F12; R12C1

C

Which of the following statements about COPY-PASTE-SPECIAL is true? A. You can use COPY-PASTE-SPECIAL to multiply all numbers in a range by a constant B. You can use COPY-PASTE-SPECIAL to divide all numbers in a range by a constant C. Both A and B are true D. Neither A nor B is true

C

Which of the following statements is true about the relationship between formulas and functions? A. A formula can include a function B. A function can include a formula C. Both A and B are true D. Neither A nor B is true

C

Which statement is true about compatibility functions? A. These are designed to facilitate a user's transition from an older version of Excel to a newer version B. Compatibility functions will not be supported at some point in the future C. Both A and B D. Neither A nor B

C

What does the TARUNC function do? A. Rounds a positive number down(towards zero) B. Rounds a negative number up( towards zero) C. Both A and B are true D. Non of above

C The number will not be rounded up.

* What is the formula reference of R8C1 in R1C1 format if the formula in A1 format is "=H6+K4"? A. "=RC(3)+R(2)C(5)" B. "=R(-2)C(7)+R(2)C(5)" C. "=R(-2)C(7)+R(-4)C(10)" D. "=R(-2)C(6)+R(-4)C(9)"

C * if the formula A1 format is "H6+K4", what is the formula is in A8 in R1C1 format?

"Save As" dialog box give us options to: A. Create a password B. Make the file ''Read-Only" C. Make a back-up copy D. All of the above

D

Functions from older version of Excel used in newer versions of Excel are called: A. Database Functions B. Text Functions C. Information Functions D. Compatibility Functions

D

Information functions can tell us all the information below except: A. Memory available B. Type of error in a cell C. Version of excel used D. How many workbooks are currently open

D

Range names are useful, hence: A. It is necessary to have a range name for each variable /cell in our model B. It is advisable to have a range name for each variable /cell in our model C. Both A and B are true D. Neither A nor B is true

D

The 'fill series' functionality is used to create what kind of data? A. Color-coded data B. Graphical representations of data C. Random data D. Patterned data

D

The format to display 1234.59 as 1234.6 is: A. ####.#0 B. ####.-# C. ####.0# D. ####.#

D

The function =MONTH(42000) will return: A. 7 B. 3 C. 9 D. 12

D

To make the VLookup function return an approximate match, for the range-lookup argument: A. The default value can be used B. I can use 'TRUE' C. I can use '1' (one) D. Any of the above

D

To what does the scope of a range name refer? A. The length of a Ange name can only be up to 255 characters B. The rule that range may contain spaces C. The usage of underscore being permissible D. The worksheet/workbook in which the name is recognized

D

What does RC[-2] indicate? A. The cell which is two columns to the right on the current row B. The cell which is two rows up on the current row C. The cell which is two rows down on the current row D. The cell which is two column to the left on the current row

D

What portion of the worksheet remains fixed when you use the "freeze" command? A. The leftmost column B. The top row C. All rows below the active cell and all columns to the left of the active cell D. All row above the active cell and all columns to the left of the active cell

D

What portion of the worksheet shows when you use the "split" command? A. The leftmost column B. The top row C. All rows below the active cell and all columns to the left of the active cell D. All rows above the active cell and all columns to the left of the active cell

D

Which of the following are external data sources to which Excel can be linked? A. Access B. Web C. Text files D. All of the above

D

Which of the following functions requires one or more arguments? A. Today() B.Now() C. Rand() D. Date()

D

Which of the following is FALSE? A. When you protect a worksheet, adding a password is optional B. While protecting multiple worksheets, each worksheet will have to be protected separately C. Back up file obtained from "always create a backup" option is generated in same folder as original file D. Using a password provides a high level of security in protecting a worksheet

D

Which of the following is FALSE? A. When you protect a worksheet, adding a password is optional B. While protecting several - but not all - worksheets, each worksheet will have to be protected separately C. It is a good idea to have back-up copies of important files D. Using a password provides a high level of security in protecting a worksheet

D

Which of the following is False? A. When you protect a worksheet, adding a password is optional B. While protecting several - but not all - worksheets, each worksheet will have to be protected separately C. It is a good idea to have back-up copies of important files D. Using a password provides a high level of security in protecting a worksheet.

D

Which of the following is a valid output for INFO("SYSTEM') function? A. Mac B. Linux C. Windows D. All of the above

D

Which of the following is possible by using Data Validation? A. Limit the number of text characters in a cell B. Restrict numbers outside a specified range in a cell C. Restrict dates outside a certain period in a cell D. All of the above

D

Which of the following options is not a valid error alert in Data Validation? A. Stop B. Warning C. Information D. Suggestion

D

Which of the following statements is FALASE about the ribbon, and groups of funcitons? A. A default button cannot be removed from a default group B. Default group can be removed from a default ribbon C. A custom group can be removed from a custom ribbon D. A custom button cannot be removed from a custom group

D

Which of these functions returns TRUE if any of the arguments is true? A. XOR B. AND C. IF D. OR

D

With regards to the QAT, which of the following options is FALSE? A. You can add a command button (to QAT) by right-clicking that command (from the ribbon) B. You can remove a command button (from QAT) by right-clicking that command from the ribbon C. Adding a command to the QAT does not remove the command from its original location D. Both A and B are FALSE E. A, B, and C are FALSE

D

*****How can we see the first row and/or first column, while scrolling down in a worksheet? a. Freeze the panes b. Split the screen c. Either A or B d. Neither A nor B

D freeze the panes and split the screen

Which of these functions returns the average of all numbers in a range of cells based on multiple criteria: A. COUNTIF B. AVERAGEIF C. COUNTA D. None of these

D * Averageifs not averageif

You can prevent users from inadvertently making changes to an Excel

Doing both A and B

***** Options for specifying data validation rules include ??? A. Kind of data B. Acceptable data values and data ranges C. Suggestions and examples to user indicating acceptable data D. A and B E. A B C

E

I have a table ( four rows by four columns) starting in cell A1 of my spreadsheet. I have another table ( four rows by four columns) starting in cell AA155 of my spreadsheet. To view both table sat the same time I should: A. Use the split worksheet command (with scrolling) B. Use the split worksheet common (without scrolling) C. Freeze pane command ( with scrolling) D Freeze pane common ( without scrolling) E. Either split or freeze, ( with scrolling) will work F. Neither split nor freeze, (without scrolling), will work

E

In Excel, the text data type includes: A. Letters B. Numbers C. Symbols D. Letters and Symbols only E. Letters, numbers and symbols

E

Range names can be given for which of the following: A. A single cell B. A group of cells as long as the selection is rectangular C. A collection of cells even if they are not rectangular D. A and b E. A and b and c

E

Which of the following are excel components that can be customized to make your excel work more efficient?

Ribbon and worksheet

Information functions can test if a cell is blank. True False

T

Passwords for protecting Excel worksheets do not provide a lot of security: True False

T

* A good practice when modifying an existing workbook is to clear the old range names. The default scope of range name is within a _____.

Workbook

The default workbook Book1.xlsx is stored in which folder?

XLSTART

A named range is a. A range of one or more cells defined by a given name b. A range of cells that contain the same text data c. A name for associated formulas d. A range that has column labels

a

The option to format cells is in which ribbon? a. Home b. Insert c. Formulas d. Data

a

The scope of a range name is defined as: a. The location within which the name is recognized b. The range name with maximum number of references c. The range name having maximum length of the name d. The range name with maximum number of formulae

a

Which button, when clicked, will indicate cells that do not match existing data validation settings? a. Circle Invalid Data b. Circle Valid Data c. Circle Data Errors d. Circle Data List

a

Which of the following formats would you use to display '1,000.55' with a dollar sign? a. Currency b. Text c. Number d. Date

a

Which of the following is a valid range name? a. JamesBond007 b. 007JamesBond c. James Bond 007 d. JamesBond 007

a

* When do error alerts appear in data validation?

a formula in the cell calculates a result that is not valid

What are inputs in a function called ____.

arguments

Copy pasting a cell with data and validation rules a. Copies the data but not the rules b. Copies the data and the rules c. Copies the rules but not the data d. Returns an error

b

What is one way to prevent spelling errors using data validation? a. Use spell check b.Use a drop down list to select from predetermined options c. Slow typing rate to 20 words per minute d. Use the Validate Spelling command

b

What is the fastest way to clear Range Names? a. Delete the names one by one b. Use the Name Manager to delete the Range Names c. Create a new workbook d. Select desired cells->delete key

b

When do error alerts appear in Data Validation? a. A user enters invalid data in the cell by copying another cell b. A formula in the cell calculates a result that is not valid c. Doing either A or B gives an error message d. Doing either A or B does not give an error message

b

Which statement is FALSE about range names? a. Range names are absolute references b. Ranges are harder to find after it has been given a range name c. We can update data easily d. It is easy to use a value in a formula

b

How can we identify optional arguments in an Excel function? a. They are enclosed within {} b. They are enclosed within [] c. They are enclosed within () d. Any of the above

bbbb

A range is expressed from starting cell to the ending cell separated by? a. Hash (#) b. Semicolon (') c. Colon (:) d. Asterisk (*)

c

If I want to display 0 (zero) as 0.00, which format should I use? a. #,###.00_); b. (#,###.00); c. 0.00; d. #.##;

c

If a file is 'read-only' it means: a. We can make changes to the file and save the file with a different name b. We can make changes to the file but cannot save it with same name in original folder c. Both A and B are true d. Neither A nor B is true

c

The date format to display the day as 'Sun' is: a. d b. dddd c. ddd d. dd

c

Which of the following cannot be hidden: a. An entire row b. An entire column c. Part of a column d. Worksheet

c

Which of the following is a good and valid range name? a. K9 b. 5% InterestRate c. LoanAmount d. Interest Rate

c

Which of the following is true? a. We need to use the Paste List command before we have created all range names b. Once a list is pasted, it updates to reflect changes c. A good practice when modifying an existing workbook is to clear the old range names d. None of the above

c

Why we use R1C1 notation? a. It is more understandable b. It is the default reference c. It is easier to find errors in our formula notation d. It is convenient

c

In Excel, we can a. lock a cell b. protect a worksheet c. protect the entire workbook d. all above

d

Options for specifying data validation rules include: a. Kind of data (data type) to be entered b. Acceptable data values and data ranges c. Suggestions and examples to user indicating acceptable data d. All of the above

d

Range names are useful, hence: a. It is necessary to have a range name for each variable/cell in our model b. It is advisable to have a range name for each variable/cell in our model c. Both A and B are true d. Neither A nor B is true

d

Range names can be given for which of the following? a. A single cell b. A group of cells as long as the selection is rectangular c. A collection of cells even if they are not rectangular d. All of the above

d

The scope of range names can be set to: a. A worksheet b. A workbook c. Cannot be restricted d. Both A and B

d

We can define a range name from which of the following? a. 'Name box' on the formula bar b. 'Create from selection' c. 'Define Name' d. All of the above

d

Which of the following are categories of functions? a. Cube functions b. Date and time functions c. Lookup and reference functions d. All of the above

d

Which of the following is FALSE about a range name created in one worksheet? a. It can be used in the same worksheet in the same workbook b. It can be used in a different worksheet in the same workbook c. It can be used as an absolute value d. It can be used as a relative value

d

Which of the following is NOT a valid rule for naming ranges? a. A name can start with an underscore character (_) b. A name can start with a backslash character (\) c. A cell reference - such as D4 - cannot be used as a range name d. Spaces are allowed as part of a name

d

Which of the following is TRUE of range names? a. A name can be a minimum of 1 character to a maximum of 255 characters b. The scope of a name can be restricted to a worksheet c. Names are absolute cell references d. All of the above

d

Functions are ____.

dynamic

By appropriately defining the 'scope' of a range name you can: a.Restrict the range that the name represents b. Establish whether the name refers to text or numbers c.Use the same name in different worksheets in the same workbook d. A and B e. A and B and C

e

Which of the following range names is/are valid? a. _NORTH_JUN b. \NORTH\JUN c. TRANSACTION_DAT d. A and B only e. A and B and C

e

Saving a worksheet automatically creates a backup sheet in the local drive. True False

f

* What does a question mark indicate in a number format?

Add spaces for insignificant zeros on either side of the decimal point