MIS 111 Lab Final
Terms in this set (97)
Which of the following procedures will NOT close your Excel workbook?
Ctrl + S
Which Excel tab is not visible by default?
how many worksheets does an new excel workbook have by default?
you select B30 in your excel worksheet and press Enter to select B31, which of the following shortcuts will select B30 once more?
shift + enter
You can add a title to a vertical axis of a chart by using Layout (Chart tools menu tab)-->
If you want to remove chart labels, where do you find the options to do so within the Layout (chart) tab?
A bar chart is essentially which of the following chart types rotated 90 degrees clockwise?
Which of the following is a valid sequence of options for selecting a different chart layout?
Design (from Chart tools) --> Chart Layouts
which of the following chart types is a valid option in the charts ribbon group on the insert ribbon tab?
all of the options provided are valid...
which of the following options is not available after right clicking an Excel worksheet tab?
changing the font color in the worksheet
which of the following is not a state an Excel workbook can be in?
How do you address cells in Excel?
column letter, row number
which of the following methods will keep a heading at the top of a table visible while scrolling through the rolls?
use Freeze panes
what are the maximum and minimum zoom ranges that can be displayed in an open excel worksheet (respectively)?
10% and 400%
which of the following error codes indicates that a formula refers to a cell that is invalid? This type of error can occur if a referenced cell is deleted from the worksheet
Which of the following is a shortcut key used to calculate the formulas in the active worksheet?
Which operator in Excel combines multiple range references into a single reference?
The easiest way to enter a function into a formula is to use Formula AutoComplete (drop down list that Excel displays when you enter a formula). another way to insert a function is to use the ___ on the ___ tab.
Function Library group, Formulas
What will be the result of this formula =IF(A1<100000, A1
7.5%, if the cell A1 has a value of 90000?
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
What is the result of the following expressions (formulas) respectively?
40 and -50
While using cell references in Excel, what key is used to change the type of the reference?
Which of the following statements is true about the formula =IF(OR(Category="Pasta, Category="Soups"), Inventory_Cost,0)
In this formula, the second statement in the OR ("Soups"), is only checked/evaluated if the first part ("Pasta") evaluates to FALSE
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
What does a small red triangle in the upper right corner of a cell denote?
a comment exists for that cell
Adding comments to cells is available through which tab of the Excel ribbon?
Consider the following formula: =SUMIFS(Inventory_Cost, Category, "Beverages", Suppliers, "
"). Which of the following statements is true?
Two criteria are checked in this formula to include a value in the total:
a) the product category must be "Beverages"
b) the supplier must be "4"
In the Analysis ToolPak for Excel, which of the following parameters can you specify when creating a Histogram?
Input Range and Bin Range
the excel function ISERR() returns TRUE if the cell contains any error value except which of the following?
the COUNTIF() function used for single-criterion counting formula takes two arguments (or parameters) ____ and ___.
range and criteria
You can use a data form to add, find, and edit rows in a range or table. is this correct?
how many sort/options do we have in Excel under the 'Data' tab?
How can you add a dollar ($) symbol to values in a column?
one way to do this is by going through the "format cells" dialog", and selecting "currency" (with a $ symbol and two decimal places) as your formatting option from within the Number tab
Excel can automatically generate a data form (which allows for convenient data entry) for your range or ____.
What sequence of steps will allow you to format the data into a table?
select the data, then click "table" under the "Insert" tab of the Excel ribbon
when you apply currency formatting to a table column and then add a new row to the table, what happens to the data entered in the new cell?
Excel applies currency formatting to the new value in that column cell
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 TRUE about sorting a table?
sorting a table rearranges the rows based on the contents of the particular column
which of the following is true about table renaming?
a table can be renamed to better reflect its contents (e.g. PARTS or PRODUCTS)
To add rows or columns within the table, right click and choose insert from the shortcut menu. which of the following commands is NOT displayed in this menu?
Table Column Above
You can apply your own style through which of the following steps?
Home (tab) -> Styles (command group) -> Cell styles
which of the following do theme effects operate on?
charts and shapes
how are some icons hidden in Icon Set conditional formatting?
by choosing "no cell icon" in the Edit the Rule description box
which of the following is FALS about using the conditional formatting option to display an icon in the cell?
Icon set rules cannot be modified
when using icon sets (conditional formatting), excel formats each cell with ____ depending on the cell value.
a distint icon
The background color of a cell can be changed by choosing
Home (tab)->Font (command group)->Fill color
when the value of a cell is changed (after conditional formatting is applied), the cell formatting ___ based on the conditions set.
Which of the following options provides correct syntax for the VLOOKUP function?
VLOOKUP(value_to_be_looked_up, table_array, column_index_num, [range_lookup])
which of the following is the most compelling motivation for using HLOOKUP()?
it usually reduces duplicate data storage
for VLOOKUP() and HLOOKUP(), the lookup_value argument can include wildcard characters if the lookup_value argument is _____ and the range_lookup argument is _____.
which function returns the relative position (in a range/table) of a cell corresponding to a specified value?
_____ lookup search look for a value in a top row of a table. once a match is found in some column, it returns a value from that table and column, where the row is chosen based on a parameter you specify.
What is the result of using the spell checker when the word is hidden?
spell checker will be able to check the spelling of the word because the contents of the hidden rows and columns are checked
By pressing the space bar, the contents of a cell seem to erase because pressing the space bar inserts a ________
non visible space character
Regarding the search and replace features provided by the "Find and Replace" dialog box, what is not true?
You cannot replace a type of formatting inside a cell with a different type of formatting
which of the following is NOT one of the buttons in the spelling dialog box in Excel?
which of the following is a way of accessing the "Evaluate Formula" dialog box that helps debug a formula?
choose formula -> formula auditing -> evaluate formula
what does it mean when the error #DIV/0 is displayed?
a number is being divided by zero
which icon (in data validation error alerts) is used to prevent users from entering invalid data into a cell?
how do you set up a data validation (using the data validation dialog box) that restricts data entry to a date greater than a specified date?
click the settings tab (in the Data Validation box), in the allow box, select 'date'. in the data box, select 'greater than'
the real power of data validation becomes apparent when you use data validation formulas. the formula that you specify must be a logical formula that returns either TRUE or FALSE. if the formula evaluates to TRUE, what does it mean?
the data is considered valid and remains in the cell
Which of the following options must be chosen to import a table from Microsoft Access directly into an Excel worksheet?
data (tab) -> get external data (command group) ->from access
which of the following is NOT one of the ways to get external data into excel?
from the library
in the share tab of the backstage view, which of the options is NOT available?
publish to word services
when you specify which rows should be included in your query (selection criteria), you are satisfying which step of the Query wizard?
how will you refresh the query after moving the cell pointer anywhere within the external data table in the worksheet?
all the options in this question are valid...
the HYPERLINK function has two arguments. which argument has the path and file name to the document to be opened?
which function is used to create a shortcut that opens a document stored on a network server, an intranet, or the internet?
while importing data from a web page into Excel, created a refreshable Web Query is used to ____.
keep data dynamic or updateble
While creating a parameterized web query the question mark (?) is used to ____.
begin the URL query string
A date filter in Pivot tables is used to
specify a time period for which you need the data
which of the following is one of the ways to create a pivot chart?
insert (tab) -> tables (group) -> Pivot table -> Pivot chart
which of the following statements is FALSE?
a pivot chart is always based on a pivot table, i.e. changes to the pivot chart must be made by changing the underlying table
the data source for a pivot table can reside in a ____ or in a _____.
worksheet, external data file
which of the following is NOT a summary for pivot tables?
To add one or more Slicers to a worksheet, start by selecting any cell in a pivot table and then choose _______.
Insert (tab) -> filter (group) -> slicer. the insert slicers dialog box appears
How do you group Pivot Table items manually?
after creating the pivot table, select the items to be grouped and then choose options (tab) under PivotTable tools and select Group (group) -> Group Selection
what is an advantage of using formulas instead of autofill to create a series of dates? (ex work week schedule)
when the first date is changed, the others update automatically
the =TODAY() function is used
to insert the current date which is updated each time a workbook is open or recalculated
which of the following formulas can be used to determine the quarter in the calendar for a date in cell P5?
To display today's date in the format like "Friday April 5, 2013", which formula should you use?
="Today is "&TEXT(TODAY(), "dddd, mmmm d, yyyy")
Which excel function returns the serial number of current date and time?
the formula to calculate the value of one minute, that can be added to a date serial number is:
The ________ function is used to return a specified number of letters or characters from the end of a text string
If you need to display lots of text in a worksheet, you can consider using a text box. How will you insert a text box?
Insert (tab) -> Text (command group) -> Text Box
The ___ is a function that will allow you to display a value (after conversion to a string) in a specific format, for example with a thousands comma separator and a currency ($) symbol.
To eliminate redundant blank space from the start or end of a string (e.g. "Tucson "), which excel function will you use?
______ can be used to check whether all of the columns fit on one page before printing an Excel worksheet.
To print a worksheet in Landscape orientation, you:
Go to the page layout tab, in the page setup group, click orientation, and then click Landscape
which function is used to calculate depreciation in Excel using the straight line method?
none of the above..
You use Page Break Preview to:
all of the above..
to calculate the cumulative interest paid between any two payment periods, use the ______ financial function.
what is the syntax for the RATE() function?
when a header or footer section is activated, you can insert any of several element codes from the Header & Footer Elements group. Each button inserts a code into the selected section. what is the purpose of the following code: &[Tab] ?
Displays the sheets name
The basic formula for computing simple interest is:
Interest = Principal
To calculate the cumulative interest paid between any two payment periods, use the _________ financial function.
When specifying what to print, a user is NOT able to choose the following option: ___.
OTHER SETS BY THIS CREATOR
ASL 3 Unit 14
World Geography Chapter 3 & 4
chp 6 - homework questions
Physics 100-Chapter 5