MIS 112 EXAM 1

With a single IF() function, how many actions can you ask Excel to carry out?

2 (i.e., an action if the criteria is true, or an an action if the criteria is false)

Which of the following formulae must be entered in cell "C8" aded in blue) to get the total widget sales for Quarter 2?

=SUM(C4:C7)

Which formula can be used to find: How many songs were sung by either Eminem or Spears?

=SUM(COUNTIF(B2:B23,{"Eminem","Spears"}))

Which of the following does the search string - ?NULL-? match when entered in the find and replace dialog box?

?NULL?

Examine the image in the question. Which of the following is true for the new name being defined?

A name is being applied to a range B4:E4. This name "UA", can be used in formulas anywhere in the current workbook.

Which of the following statements is true?

A workbook can have many worksheets.

Examine the attached Excel file PS1 formatting.xlsx In Row 2 (Col B), which of the following formatting types has been applied to "3419.25041" to make it appear as "$3,419.25" ? ormatting.xlsx

Currency

What is the result of the formula =2^3 * (,10*10

Excel tells you that the formula contains an error

Which of the following command sequences will allow you to save a copy of your workbook with a different name?

File, Save As

After you have selected the data to create a chart, which of the following is the correct sequence of options needed to create a clustered column chart?

Insert --> Charts --> Column --> Clustered Column

When a column is sorted within a table, which of the following is true about the drop-down list in the header row?

It displays a different graphic to remind you that the table is sorted by that column

Fill in the blank: Every chart type has a set of that you can choose from (with settings for chart elements such as a title, data labels, axes, and so on).

Layouts

Please examine the attached workbook. The chart was created based on data in cells A1 through C6. If new data is added in cells A7 through C7, will the chart include the new data automatically?

No

Can you print data in an Excel Form attached to a table?

No. you cannot

Which type of chart does not allow format changes to the Plot area?

None of the (other) options provided is correct

Please refer to the attached Excel workbook, How can you add a dollar ($) symbol to values in a column as seen in the "Grand Total" column?

One way to do this is by going through the "Format Cells" dialog, and selecting "Accounting" (with a $ symbol and 2 decimal places) as your formatting option from within the Number tab

Examine the survey results in the attached workbook (in Sheet2). What type of chart would be most suitable to represent the survey response data?

Pie

For this question, please download the attached Excel workbook. Convert the data on Sheet1 into a table. Next answer the following question: What keys do you need to press to select the newly created table so that it can be copied or moved to a different worksheet?

Press Crtl+A

What is the primary purpose of "Protected View?"

Protect you from malware

Please refer to the figure. What Excel element is shown in the red box?

Quick Access toolbar

Which of the following is TRUE about sorting a table?

Sorting a table re-arranges the rows based on the contents of a particular column.

While comparing two sheets using the "View Side by Side" feature, there is an option which lets you scroll the two sheets in sync. What is that option called ?

Synchronous Scrolling

Microsoft Office Excel can automatically generate a data form (which allows for convenient data entry, among other things) for your range or ____ .

Table

Examine the attached Excel file. In row 4, we have two different ways of displaying the August 25 date. Which of the following is TRUE about these dates? formatting.xlsx

The data stored in the two cells A4 and B4 are identical

What part(s) of a table can be selected?

The entire table, an entire row, or an entire column from a table can be selected

If the formula =ROWS (Asset) * COLUMNS (Asset) that is used to calculate the number of cells in a range named Asset doesn't work, what does it imply?

The range Asset consists of non-contiguous cells

Please see the attached workbook. What does the small red triangle on the upper right corner of cell B1 denote?

a comment exists for that cell

What type of cell reference does the formula in E2 use? (refer to the attached image, the formula is highlighted)

absolute

Which of the following does the Formula Autocomplete feature in Excel take into account?

all of the options provided for this answer are valid

Which of the following function(s) can be used to count error values in a range?

all of the provided choices are valid

For a range called Data, what does the function =COUNTIF(Data, "<>0") return?

number of cells not equal to 0

Which of the following types of data may NOT be contained in a cell in an Excel worksheet?

objects

A group of cells is referred to as which of the following?

range

The COUNTIF() function used for single-criterion counting formula takes two arguments (or parameters) ____ and ____ .

range (and) criteria

In Excel, Shift + Spacebar (keyboard shortcut) is used to _____ .

select a row

Please see the attached workbook. What is the scope of the range name 'months'?

sheet 1

Examine the attached worksheet. Which of the following formulas, when entered in cell B12, will give the total number of items for which there was no discount offered (i.e. discount is 0)?

=COUNTIF(E2:E8, 0)

The -sUM () function does which of the following in Excel?

Allows you to total up numbers in a specified range of cells

In the Top Salespersons list, which feature can be used to populate the numbers "3," "4," and "5" in cells "A17," "A18," and "A19," respectively?

Autofill

Please select the Excel function which allows us to answer the question: "How many days of stock data do I have?" You may refer to the image in the question.

COUNT( )

What does the following formula =A1=C12 do?

Compares cell A1 with cell C12. If the cells are identical, the formula returns TRUE; otherwise, it returns FALSE

What option in the Table Tools / Design tab removes a table without losing the data in it?

Convert to Range

Which of the following is the keyboard shortcut that creates a new blank workbook in Excel?

Ctrl + N

Which of the following procedures will NOT close your Excel workbook?

Ctrl + S

What is the shortcut to open the Find and Replace dialog box with the "Find" tab open?

Ctrl+F

After pressing "Alt + H" while in an open Excel worksheet, a number of Key Tips are displayed. Which ribbon tab do these Key Tips relate to?

Home

In the Analysis ToolPak for Excel, which of the following parameters can you specify when creating a Histogram?

Input Range and Bin Range

Fill in the blanks: The boxed area is called _____ . What is displayed in this boxed area when a range of cells is selected? _____

Name box. The number of rows and columns in the selection is displayed here.

Please refer to the figure. What Excel element is shown in the long red box?

Ribbon

Please examine the attached workbook. Given the data in Sheet1, which of the following steps should be followed to obtain the data in Sheet2?

Select cells A1 through D3 in Sheet1 -> Copy -> Go to Sheet2 -> Paste -> Transpose

Which of the following methods is a VALID way to get into cell edit mode?

Selecting the cell that you want to edit, and then clicking in the Formula bar

To view or edit a comment, you can select the cell where a comment has been attached and press the following keyboard shortcut:

Shift+F2

Which of the following is an advantage of using Excel tables?

Using table and column names in formulas provides greater flexibility as extending a table does not require re-writing of formulas

If you copy the whole cell "B8" (not only its formula) and paste it into cell "D8" (shaded in green), will it produce the correct total sales value for Quarter 3?

Yes

Is it possible to get the data back after deleting it using keyboard ?

Yes

Would you be able to apply the "watch window" option in multiple sheets at the same time ?

Yes

What characters are NOT allowed in sheet names ?

[ ]

In Excel, the ISNONTEXT (0 function returns TRUE if its argument refers to which of the following?

content other than text (e.g., a date or a number) or a blank cell

Which of the following does the function =NOW () return?

current date and time

What does the Excel keyboard shortcut Ctrl+Alt+F9 do?

forces a complete recalculation of all formulas in all open workbooks.

Fill in the blanks: A cell in an Excel worksheet is identified by its address, which consists of a column ____ and row _____ .

letter, number

You select a cell with data "120" in an Excel worksheet and press the "Delete" key on your keyboard. Which of the following holds TRUE?

only the contents of the cell are removed

You can protect your Excel workbook with a password. Which of the following is TRUE about password protected workbooks?

passwords are case sensitive

What is the result of the following expressions (formulas), respectively? = (10 - 6) * 10 and = 10 - 6* 10

40 and -50

Please refer to the attached workbook. What is the width of Column D?

45

Please refer to the figure. How many worksheets are contained in the workbook shown?

5

To calculate the percentage of the total widget sales made by the top 5 employees, which of the following formulae would you enter in cell "C22" (shaded purple)

=C20/F8

Which operator in Excel combines multiple range references into a single reference le.g., if I want to sum up the values in non-contiguous cell-ranges across the worksheet)?

"," (comma)

The Excel function: ISERR() returns TRUE if the cell contains anylerror value except which of the following?

#N/A

What is total widget sales for the West Region for the year?

$5,129

Which of the following is the file format of the Excel 97-2003 workbook?

.xls

By default, what is the extension used when you save a workbook in Excel 2016?

.xlsx

Examine the àttached worksheet. Using the Correlation Data Analysis Tool (available through the Analysis ToolPak Add-in) on A1:C6, which of the following options is the approximate value of the correlation coefficient for Relaxation Therapy and Music Therapy?

0.56

If cell "A1" contains JOHN F. SMITH and you want this value to be changed into a proper case like John F. Smith, what Excel function would you use?

=PROPER(A1)

Which of the following formulas will display both the current date and time when entered into a cell in an Excel worksheet?

= NOW()

Examine the attached Excel file. When you copy the formula in cell "C3" to "F7", the cell in "F7" contains which of the following formulas?

=$B7*F$2

Examine the attached worksheet. Which of the following formulas, when entered in cell E6, will give the Discount percentage for Pick Axe?

=(1-(F6/D6))*100

Which of the following functions can be used to count specific types of errors?

COUNTIF

Which of the following icons/buttons will you click to add or remove gridlines in a chart?

Chart Elements

Please see the attached Excel workbook image in answering this question. In order to sort the 'Salesperson' column in a descending order, which of the following steps is correct?

Click on any cell containing Salespersons data, from the Ribbon pick the Data tab, and then click on the "Sort Z to A" command button