MIS 112 Module Exam 1
The excel function ISSER() returns true if the cell contains any error value except which of the following?
#N/A
Which operator in excel combines multiple range references into a single reference?
*,* (Comma)
Which of the following is the file format of the Excel 97-2003 workbook? .xls .xlsx .xlsb .xltm
.xls
What are the minimum and maximum zoom ranges that can be displayed in an open Excel worksheet (respectively)? 10%, 400% 10%, 500% 10%, 300% 25%, 200%
10%, 400%
With a single IF() function, how many actions can you ask Excel to carry out?
2
How many sort options/commands do we have in Excel under the 'Data' tab? 1 2 3 4
3
The formula =COUNTIF(range, "???") returns the number of cells in the range containing exactly ______ characters of text
3
What is the maximum number of characters a worksheet name can contain? 31 34 28 32
31
What is the result of the following expressions (formulas) respectively? =(10-6) * 10 and =10-6*10
40 and -50
What will be the result of this formula =IF(A1<100000,A1*5%,A1*7.5%) , if the cell A1 has a value of 90000? 4500 500000 4750 6750
4500
Which of the following formulas will display both the current date and time when entered into a cell in an Excel worksheet?
=NOW()
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 two wildcard characters are supported by the "Find and Replace" dialog box in an Excel Worksheet?
?.*
Which of the following search string ~?NULL~? match when entered in the find and replace dialog box?
?NULL?
Which of the following statements is true? A workbook can have at most 3 worksheets. A worksheet can have many workbooks. A workbook can have many worksheets. A worksheet can have at most 3 workbooks.
A workbook can have many worksheets
You are reviewing a Spreadsheet that records daily sales for Burgers, Hotdogs and Chili. Monday of last week shows exceptionally high sales for Burgers. You want to email the spreadsheet back to your assistant so he can look into whether the data was correctly entered. Which of the following methods should you use to explain your request to your assistant? Add a comment to the sales figure cell, and explain to your assistant what you want him to do Delete the sales figure for Monday (seeing the the blank cell will make things clear to the assistant) Set a fill color of dark red for the sales figure cell Make a pie-chart to explain the ratio of sales of Monday to other days in the week so the assistant sees which day has the highest sale
Add a comment to the sales figure cell, and explain to your assistant what you want him to do
Which of the following is true in respect to charts?
After you create a chart, you have a great deal of flexibility in customizing it
Which of the following types of Cell Formatting can be achieved using the Format Calls feature of Excel?
All the other options are correct
Which of the following options moves the active cell right one screen?
Alt + PgDn
What is the keyboard shortcut to clear the formatting in a cell?
Alt -> h -> e -> f
Which of the following functions can be used to count specific types of errors? COUNTA COUNTIF COUNTBLANK COUNT
COUNTIF
To gain access to the Table Tools / Design tab in the Excel Ribbon when working with tables, you should do the following:
Click anywhere on the table
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 Select the entire Salesperson Column, then Click on the Review tab (in the Excel ribbon), followed by clicking on Group and "Sort" The Salesperson column cannot be sorted Convert the data into a Table, right click on the Table header and select the A-to-Z sort option
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
Which is the shortcut to open the Find and Replace dialog box with the 'Find' tab open?
Ctrl + F
Which of the following is the keyboard shortcut that creates a new blank workbook in Excel? Ctrl + N Ctrl + E Ctrl + W Ctrl + B
Ctrl + N
Which of the following keyboard shortcuts can be used to activate a different sheet?
Ctrl + PageUp
Which of the following procedures will not close your Excel workbook?
Ctrl + S
Which of the following is a VALID sequence of options for selecting a different chart layout?
Design (from chart tools) -> Chart Layouts
While using cell references in Excel, what key is used to change the type of the reference?
F4
Which of the following command sequences will allow you to save a copy of your workbook with a different name?
File, Save as
The easiest way to enter a function into a formula is to use Formula AutoComplete. Another was to insert a function is to use the ___ on the ____ tab.
Function Library group (on the) Formuals
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 Review Insert Formulas
Home
Which of the following is NOT one of the excel functions to determine whether a cell contains an error value?
ISLOGICAL
In the Analysis ToolPak for Excel, which of the following parameters can you specify when creating a Histogram? Filename (to import Data from Access) Ignore duplicates vs. Permit duplicates Simple vs. Compound Interest Input Range and Bin Range
Input Range and Bin Range
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
Which of the following occurs if you select an embedded chart of a sheet and then click on "File" --> "Print"? It prints only the chart on that sheet It prints the whole worksheet including the chart It asks if you want to print all charts on all worksheets in that Excel workbook It prints all worksheets with data linked to the current chart
It prints only the chart on that sheet
Which of the following is NOT a formatting option offered through the Mini Toolbar? (Hint: for more information on the mini-toolbar, you can right-click on an Excel cell) Comma Style Format Painter Left Align Center Align
Left Align
Which keyboard shortcuts can be used to move the active cell one column to the left?
Left arrow or Shift + Tab
To display the Total Row in a Table: choose Table Tools / Design -> Table Style Options (command group) and put a check mark next to Total Row. Selecting a cell in the Total Row and clicking on the drop-down arrow that appears in that cell will NOT allow you to select which of the following summary formulas? Average Count Sum Mode
Mode
The boxed area is called ____. What is displayed in this boxed area when a range of cells is selected? _______ Formula bar. Any formula in the current cell is displayed here. Cell box. The address of a range of cells is displayed here. Column box. The address of the topmost cell in a range is displayed here. Name box. The number of rows and columns in the selection is displayed here.
Name box. The number of rows and columns in the selection is displayed here.
Does deleting a cell by pressing the Delete key also delete the conditional formatting on the cell?
No
If you proceed to remove duplicate values using the "Remove Duplicates" feature in "Table Tools", will Excel remove one of the two table rows? Yes, because Excel can see that the dates in the two cells are the same value. No, because dates that are a duplicate cannot be removed. No, because Excel does not let you remove duplicates when you only have 2 rows in a table (removing a row makes it a 1-row table, which is not really a table). Yes, because the duplicate values are determined by the value displayed in the cell and not necessarily by the value stored in the cell. No, these are not considered duplicates by Excel. To remove the duplicate data you must ensure that the date in the second row is formatted the same way as the date in the first row.
No, these are not considered duplicates by Excel. To remove the duplicate data you must ensure that the date in the second row is formatted the same way as the date in the first row.
How can you add a dollar ($) symbol to values in a column as seen in the "Grand Total" column? The simplest way is to click on the "Wrap text" button in Home tab. From the dialog box that pops up, pick the default $-symbol formatting. This is automatically provided to you when you make an Excel Table 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 The correct way to do this is by going through the "Format Table" menu, and selecting the option of "Number" (with 2 decimal places and a $ symbol)
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
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)
Relative
What command under the Table Tool /Design Tab can you use to add two more rows to the table? Resize table Change rows Add rows Add Record
Resize Table
Which of the following formula do? =COUNTIF(Data, TODAY())
Returns the numbers of cells containing the current data in the range named Data
Adding comments to a cell is available through which tab of the Excel ribbon?
Review
Suppose your worksheet has a comment in cell A1 and a comment in cell B5. Your active cell is B1. Which command can you use to navigate to the comment in cell B5? Review (tab) -> Comments (command group) -> Next Review (tab) -> Comments (command group) -> Previous Home (tab) -> Navigate (command group) -> Next Comment Page Layout (tab) -> Search (command group) -> Jump To Comment
Review (tab) -> Comments (command group) -> Next
Which of the following methods is a VALID way to get into cell edit mode? Clicking the cell one time enables you to edit the cell contents Selecting the cell that you want to edit, and then clicking in the Formula bar Pressing F9, which enables you to edit the cell contents directly in the cell Pressing F4 allows you to the edit the cell contents
Selecting the cell that you want to edit, and then clicking in the Formula bar
What does selecting the option "Current region" within the: Go To Special Dialog Box (Home (tab) -> Editing (command group) -> Find & Select) do? Selects the entire array Selects all graphic objects on the worksheet Selects a rectangular range of cells around the active cell Selects all empty cells
Selects a rectangular range of cells around the active cell
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
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 ? None of the (other) options provided is correct Side View Synchronous Scrolling Toggle
Synchronous Scrolling
Microsoft Office Excel can automatically generate a data form (which allows for convenient data entry, among other things) for your range or _______________. Chart Field Table Record
Table
A formula refers to a value in the Total Row of a table. What will happen to the formula result if the option for "Total Row" (from the Excel ribbon: Table Tools / Design tab) is unchecked? The formula will now result in an answer of "0. The formula returns an error. The formula will continue to work whether the "Total Row" option is checked or unchecked. The formula will return will return the value "N/A" or be automatically hidden depending on whether you sort data Smallest to Largest or Largest to Smallest.
The formula returns an error.
The formula =COUNTIF(range, "*budget*") will count the number of cells in the specified range containing the word "budget" in certain positions within the text. Which of the following best describes the cells counted?
The word "Budget" can appear anywhere within the cell
Which of the following chart types does not support the Data Table chart element?
Treemap
What of the following is FALSE about filtering a table?
When you copy data from a filtered table, both visible data and rows hidden by filtering are copied
Is it possible to convert a cell with text data into a .png format ? This option was available in Excel 2013 but not in Excel 2016 Yes, but only if the cell width is no larger than 72 pixels Yes No
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 ? This option was available in Excel 2013 but not in Excel 2016 Yes, but only if there are no more than 3 sheets in the workbook No Yes
Yes
In an Excel form, when finding a row by entering search criteria: Will the question mark symbol "?" find or match any single character?
Yes the "?" symbol is used to match/ find a single character
You can use a data Form to add, find, and edit rows in a range or table. Is this correct? Yes, all these are valid form operations Incorrect, as adding rows is not supported False, Data forms work only with Tables, not with Ranges No, Data forms work only with Ranges, not with Tables
Yes, all these are valid form operations
Which command changes your view from what's seen in "worksheet_image1.png" to "worksheet_image2.png"? Zoom to Selection View Side by Side Freeze Panes None of the options described will work
Zoom to Selection
What characters are NOT allowed in sheet names ? All options are correct , [] !
[]
Which of the following characters is VALID for use in an Excel workbook file name? _ : " \
_
Which of the following best describes what a Sparkline is? a mini-chart that is displayed in a single cell a blinking line to separate two cells a highlighted cell a dynamic line chart where the lines have metallic color effects
a mini-chart that is displayed in a single cell
Which of the following does the formula autocomplete feature in excel take into account?
all of the options provided
Which of the following function(s) can be used to count error values in a range? all of the provided choices are valid ISERROR() ISERR() ISNA()
all of the provided choices are valid
Consider the function =COUNTIF(A1:A200, ">200"). The information between the parentheses in a function are known as the ____________ . function signature dependent variables cell references arguments
arguments
A single element in a worksheet that can hold a value, some text, or a formula is referred to as which of the following? entity component element cell
cell
Which of the following options is NOT available after clicking right on an Excel worksheet tab?
changing the font color in the worksheet
Which of the following is an object that contains all other elements in an Excel chart?
chart area
A bar chart is essentially which of the following chart types rotated 90 degrees clockwise? column line area surface
column
In excel, the ISNONTEXT () function returns true if its argument refers to which of the following>
content other than text or a blank cell
Which of the following does the function =NOW() return? current date current time current date and time nothing, it is not a valid Excel function
current date and time
A cell in an excel worksheet is identified by its address, which consists of a column ____ and row ___.
letter, number
For a range celled Data, what does the function =COUNTIF(Data, TODAY()) return?
number of cells containing the current data?
For a range called Data, what does the function =COUNTIF(Data, TODAY()) return?
number of cells not equal to 0
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 the contents and formatting of the cell are removed only the formatting of the cell is removed no changes occur
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 NOT case sensitive passwords are case sensitive if you forget your workbook password, you can email the TA to retrieve it for you workbook passwords automatically expire in 360 days
passwords are case sensitive
The COUNTIF() function used fir single-criterion counting formula takes two arguments (for parameters) ______ and _______.
range (and) criteria
In Excel, the Ctrl + Spacebar (keyboard shortcut) is used to ______. select a row select a column select a range select multiple rows or columns
select a column
What is the Skip blanks option used for while copying a range to another area?
to prevent blank cells in the copied range from overwriting existing data
Which of the following chart-related items identifies general trends in your data? trendline timeline chart tools series
trendline
Which of following is not a method of creating frequency distributions?
use the Review tool of Spelling Error Frequency per Worksheet
An Excel workbook can contain one or more of which of the following? worksheets files notebooks filenames
worksheets
Which of the following is NOT a tool in Analysis ToolPak for Excel?
y-Test
