MIS Lab Final Review (Practice Test),Examprep

MIS Lab Final Review (Practice Test),
MIS Lab Final Review (PS 1-12), mis lab
my problem sets, MIS 111 Lab Final
Questions from Problem Sets, MIS 111
Problem Sets 1-12, MIS111L Final Study
Guide Fall, MIS 111L past problem sets,
MIS111L Practice...Exam prep
Grand Totals in Pivot Tables are used to _____________________. - correct answersdisplay totals for all
cells in column (or row) of a pivot table

Which of the following is TRUE about Pivot tables? - correct answersall of the above

How do you group Pivot Table items manually? - correct answersAfter creating the pivot table, select
the items to be grouped and then choose Options (tab) under PivotTable Tools and select Group (group)
-> Group Selection

Which of the following reviewing features does Excel offer to you? - correct answersA proofing tool to
check spelling

To save a copy of your workbook with a different name, you can click on ____ followed by _____ -
correct answersfile, save as

To create a hyperlink to a specific location in a Microsoft Word document, you must use a bookmark to
define the location you want to jump to in the document. Which of the following is the right option to
create a hyperlink to the bookmark 'QrtlyProfits' in the document 'Annual Report.doc' located at
http://example.microsoft.com? The link text to be displayed is "Quarterly Profit Report". - correct
answers=HYPERLINK("[http://example.microsoft.com/Annual Report.docx]QrtlyProfits", "Quarterly
Profit Report")

What does XML stand for ? - correct answersExtensible Markup Language

Which of the following is a correct syntax for VLOOKUP function? - correct
answersVLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

In context of the MATCH() function, which of the following is FALSE? - correct answersAll of the options
are false

Which of the following is TRUE about a Watermark in Excel? - correct answersAll of the above
statements are TRUE

,With regards to Depreciation Calculation functions in Excel, which of the following are true about the
function SYD()? - correct answersIt allocates a large depreciation in the earlier years of an asset's life

What is a keyboard shortcut for creating a table? (hint: you can test the options in Excel) - correct
answersCtrl+L

What would you do, while creating a table, to display your Table Headers? - correct answersCheck 'My
table has headers'

in Excel, dates are stored as _________. - correct answersnumbers

The ___ function can be used to find the number of characters in a word or text string. - correct
answersLEN()

Consider the phrase: "This is Excel". Which sequence of keyboard shortcuts result in the formatting used
on the words "This is Excel" in the earlier sentence (within Excel, on a Windows PC)? - correct
answers(Control + B) + (Control + 5)

Which rule category under Conditional formatting can be used if you want to apply graphic bars directly
in the cells, proportional to the cell's value? - correct answersData Bars

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? - correct answers4500

This error code tells us that a problem with a value exists; for example, you specified a negative number
where a positive number was expected. - correct answers#NUM!

The Data (tab) -> Data Tools (group)-> Data Validation drop-down list contains an item named Circle
Invalid Data. What will happen if you select this item? - correct answerscircles appear around cells that
contain incorrect entries.

Data validation on a cell or range can do which of the following? - correct answersall of the above

Which of the following statements is true? - correct answersIf I have a worksheet with student names
(First, Middle, Last), you can use the COUNTA() function to find how many student names are on the
worksheet

Consider the following formula: =SUMIFS(Inventory_Cost, Category,"=Beverages", Suppliers,"*4*").
Which of the following statements is true? - correct answersTwo criteria are checked for this formula to
include a value in the total, the product category must be "Beverages", and the supplier must be "4"

Which of the following is NOT a way to add a new worksheet to a workbook? - correct answersPress
Shift + F12

Worksheet names can have up to ______ characters. - correct answers31

,With a single IF() function, how many actions can you ask Excel to carry out? - correct answers2 (i.e., an
action if the criteria is true, or an an action if the criteria is false)

Which of the following is NOT considered a style attribute? - correct answersFormula

How do you copy a Pivot table to a new worksheet? - correct answersselect the entire table and choose
Home (tab) -> Clipboard (group) -> Copy (or, press Ctrl+C). Then select a new worksheet and choose
Home (tab) -> Clipboard (group) -> Paste -> Paste Values

In Excel in order to avoid incomplete calculation errors and to ensure that formulas are fully calculated,
you would press _________ . - correct answersCtrl + Alt + Shift + F9

Which of the following options can be used to quickly remove data validation for a cell? - correct
answersselect the cell and open the Data Validation dialog box (Data (tab) -> Data Tools (group)). On the
Settings tab, click Clear All.

To find an asterisk (i.e., the symbol: * ) within a cell, you enter which of the following in an Excel form
search criteria? - correct answersa tilde followed by an asterisk

There is a type of investment in which you make a stream of fixed payments (e.g., as a series of
investment deposits into an account). What is this type of investment called? - correct answersAnnuity

In Excel, dates are stored as _________. - correct answersNumbers

A single element in a worksheet that can hold a value, some text, or a formula is called a(n) ____? -
correct answersCell

What would you do, while creating a table, to display your Table Headers? - correct answersCheck 'My
table has headers'

What does the following formula return? =FIND("m","Big Mama Thornton",1) - correct answers7

What is the purpose of the function TIME()? - correct answersConverts the input hours, minutes &
seconds to a serial number

The HLOOKUP function searches for data in ______. - correct answersrows

A(n) _________ is an interactive control that makes it easy to filter data in a pivot table? - correct
answersslicer

correct syntax for VLOOKUP function? - correct answersVLOOKUP(lookup_value, table_array,
col_index_num, range_lookup)

Grand Totals in Pivot Tables are used to _____________________ - correct answersdisplay totals for all
cells in column (or row) of a pivot table

Charts are dynamic, i.e., they change as the underlying data changes. Is this an accurate statement? -
correct answersYes, by default they are dynamic

, The easiest way to enter a function into a formula is to use Formula AutoComplete (the drop-down list
that Excel displays while you type a formula). Another way to insert a function is to use the ______ on
the _________ tab. - correct answersFunction Library group (on the) Formulas

The ___ function can be used to find the number of characters in a word or text string. - correct
answersLEN()

The formula: =CHAR(CODE("A")+32) returns which of the following? - correct answersa

To find an asterisk (i.e., the symbol: * ) within a cell, you enter which of the following in an Excel form
search criteria? - correct answersa tilde followed by an asterisk

In the Excel Backstage view, which of the following pieces of information about your workbook are
available? - correct answersDate the workbook was created

Which of the following is true about Web queries? - correct answersPerforming Web queries copies
information from an HTML file into the current workbook

What is the correct syntax for the LOOKUP function? - correct
answersLOOKUP(lookup_value,lookup_vector,result_vector)

How do you copy a Pivot table to a new worksheet? - correct answersselect the entire table and choose
Home (tab) -> Clipboard (group) -> Copy (or, press Ctrl+C). Then select a new worksheet and choose
Home (tab) -> Clipboard (group) -> Paste -> Paste Values

By default, Excel uses __________ font - correct answers11 point (pt) Calibri

Which rule category under Conditional formatting can be used if you want to apply graphic bars directly
in the cells, proportional to the cell's value? - correct answersData bars

Which of the following is *NOT* a type of cell reference? - correct answersDynamic

Which of the following statements is true about the COUNTA() function? - correct answersIf I have a
worksheet with student names (First, Middle, Last), you can use the COUNTA() function to find how
many student names are on the worksheet

Which of the following statements is true? They all relate to the formula: =IF(
OR(Category="Pasta",Category="Soups"), Inventory_Cost,0 ) - correct answersIn this formula, the
second statement in the OR (i.e., checking for the category ="Soups") is only checked/evaluated if the
first part (i.e., checking if category ="Pasta") evaluates to FALSE

With regards to Depreciation Calculation functions in Excel, which of the following are true about the
function SYD()? - correct answersIt allocates a large depreciation in the earlier years of an asset's life

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 does the
following code do: &[SheetTab] ? - correct answersIt is not a valid code