mis 112 problem set 1-4 and 13

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

= NOW()

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

Examine the image in the question. In "C3," we have the supplier address "Tucson, AZ 85721" appearing in a single cell (the formula combines data from cells "E3," "F3," "G3"). Which of the following formulas will achieve this result?

=E3 &", " &F3 &" " &G3

Which of the following is NOT a reason to name a range of cells?

A named range (e.g., 'Order_Total'), works across operating systems (e.g., works on both Macs & Windows), while using the cell references (e.g., H2:H100) does not work on different operating systems

When you right-click a graphic object and choose Size and Properties from shortcut menu, Format Shape pane opens. If you expand the Properties section which of the following choices you get?

All of the options provided are correct

The =SUM() function does which of the following in Excel?

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

Please see the attached workbook. Which of the following options can you choose with a Sparkline if you want to highlight the budget for the third year?

Highlight the: Low point

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

If there are negative values in your data, you can emphasize this by showing a(n) __________ axis in your sparkline.

Horizontal

Which of the following is NOT one of the Excel functions to determine whether a cell contains an error value?

ISLOGICAL

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

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

Please see the attached workbook. If you copy cell "B6" and paste it as a formula in cell "C6," will it produce the correct total for Year 2?

Yes, the formula range will be adjusted automatically

What characters are NOT allowed in sheet names ?

[]

Which of the following best describes what a Sparkline is?

a mini-chart that is displayed in a single cell

You enter "(500)" into an unformatted cell in an Excel worksheet (without quotation marks). Which of the following will be generated by your entry?

a negative number

If you copy a formula down a column, and need a cell reference to stay the same (for example, you don't want B2 to change to B3), what type of cell reference do you need? (Example: Use of F4 key)

absolute

A formula in Excel can consist of which of the following?

all of the choices provided are valid

Consider the function =COUNTIF(A1:A200, ">200"). The information between the parentheses in a function are known as the ____________ .

arguments

After you create a chart, which of the following actions can you perform on it?

change the chart type, formatting, and data series

In Excel, the Ctrl + Spacebar (keyboard shortcut) is used to ______.

select a column

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

select a row

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

"," (comma)

Calculate the total yearly sales for the West Region and the South Region in cells "F5" and "F7" (shaded in orange). What is the total widget sales for all regions for the year?

$24,914

When you have several drawings on a worksheet, you may want to align or evenly space these objects. What is the best way to do it?

Select the appropriate command from: Drawing tools -> Format (tab) -> Arrange (command group) -> Align (drop-down list)

Please refer to the figure. Within the "Number" tab, how many categories are available for displaying numbers?

12

When customizing a sparkline, which of the following is NOT one of the options?

Change the width or height of a cell

Which keyboard shortcut is used to select all cells in an open Excel worksheet?

Ctrl + A

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

Which of the following options scrolls the screen so that the active cell is visible?

Ctrl+Backspace

Which of the following is a VALID sequence of options for selecting a different chart layout?

Design (from Chart Tools) --> Chart Layouts

Please refer to the figure. Which of the following Excel tabs is NOT visible in a worksheet by default?

Developer

Examine the attached workbook. If you format a chart element with the font seen in Chart 2, how can you reset it to its original state?

Either of the previous options (resetting through the menu or the right-click options work)

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

Excel tells you that the formula contains an error

While formatting Shapes in Excel, which command is used to change the overall style of a Shape?

Shape Styles

Which of the following is NOT one of the types of Sparkline graphics?

Slicer

After you create a Sparkline, changing color is easy. Use the controls in the _______________.

Sparkline Tools -> Design (tab) -> Style (group)

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

With respect to Sparklines, what is FALSE?

The Create Sparklines dialog box does NOT allow users to specify a different sheet for the Data Range.

Which option provided in the View ribbon tab is best to compare two open Excel workbooks simultaneously in Excel 2016?

View Side by Side

In Excel, data displayed in a Sparkline is assumed to be at ________.

equal intervals

Which of the following is NOT a state an Excel workbook can be in?

expanded

Does deleting a cell by pressing the Delete key also delete the conditional formatting on the cell?

no

Examine the image provided. What does the middle button (circled in red) in the row of "Paste Value" do?

pastes values and number formatting

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

yes