MIS 112 MIDTERM EXAM
What is the name of the company that created Excel? a) Microsoft b) Google c) Apple d) Dell
a) Microsoft
The Excel function: ISERR() returns TRUE if the cell contains any error value except which of the following? a) #N/A b) #REF! c) #VALUE! d) #NULL!
a) #N/A
What is the result of the following expressions (formulas), respectively? = (10-6)*10 and = 10-6*10 a) 40 and -50 b) -50 and 40 c) 40 and 50 d) 50 and 40
a) 40 and -50
20130315 represents a date March 15, 2013. To convert this string to an actual date, which of the following formulas can be used? (Assume the data 20130315 is in cell A1). a) =DATE(LEFT(A1,4), MID(A1, 5, 2), RIGHT(A1,2)) b) =DATE(RIGHT(A1,4), MID (A1, 5, 2), LEFT (A1,2)) c) =DATE(LEFT(A1,2), MID(A1, 3, 2), RIGHT(A1,2)) d) =DATE(RIGHT(A1,2), MID(A1, 3, 2), LEFT(A1,2))
a) =DATE(LEFT(A1,4), MID(A1, 5, 2), RIGHT(A1,2))
Suppose you deposit $100 at the beginning of each month (for 12 months) into an account that pays 3.5 percent annual interest compounded monthly. Which formula calculates the future value of your series of deposits? a) =FV(3.5%/12,12,-100,,1) b) =FV(3.5%/12,12,100,,1) c) =FV(3.5%,1,-100,,1) d) None of the above
a) =FV(3.5%/12,12,-100,,1)
Which of the following options, when used as a formula in the custom Data Validation criteria for cell A1, will ensure that the cell entry is a date, and that the date is a Sunday? Hint: Date format: MM/DD/YYYY a) =WEEKDAY(A1)=1 b) =WEEKDAY(A1)=SUNDAY c) =ISSUNDAU(A1)=1 d) =ISWEEKDAY(A1)=SUNDAY
a) =WEEKDAY(A1)=1
A Loan amortization schedule in Excel: a) A table of values that shows various types of information for each payment period of a loan b) A table of values that shows various type of information for any one payment period of a loan c) A table of values that shows only Present Value information for the entire payment period of a loan d) None of the above
a) A table of values that shows various types of information for each payment period of a loan
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? a) Add a comment to the sales figure cell, and explain to your assistant what you want him to do b) Delete the sales figure for Monday (seeing the blank cell will make things clear to the assistant) c) Set a fill color of dark red for the sales figure cell d) 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
a) 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 with respect to charts? a) After you create a chart, you have great deal of flexibility in customizing it b) Data is NOT needed to create a chart c) Plot area contains all the elements of the chart d) A Pie chart is another name for a Column chart
a) After you create a chart, you have great deal of flexibility in customizing it
Which of the following file formats can be opened using Excel 2016? a) All the other options are correct b) XLS c) XLT d) XLA
a) All the other options are correct
The =SUM() function does which of the following in Excel? a) Allows you to total up numbers in a specified range of cells b) Tells you the cumulative sum of interest paid between two time periods c) Shows you the current date and time d) Nothing, it is not a valid Excel function
a) Allows you to total up numbers in a specified range of cells
To view calculated fields and calculated items in a pivot table, which of the following can you do? a) Choose PivotTable Tools -> Analyze -> Calculations -> Field, Items & Sets -> List Formulas b) Choose PivotChart Tools -> Analyze -> Calculations -> Field, Items & Sets -> List Formulas c) Choose Pivot -> Analyze -> Calculations d) Choose Analyze -> Calculations -> Field, Items & Sets -> List Formulas -> PivotTable Tools
a) Choose PivotTable Tools -> Analyze -> Calculations -> Field, Items & Sets -> List Formulas
What does the following formula =A1=C12 do? a) Compares cell A1 with cell C12. If the cells are identical, the formula returns TRUE; otherwise, it returns FALSE b) Copies the value in cell C12 to cell A1 c) Copies the value in cell A1 to cell C12 d) Subtracts the value in the cell C12 from the value in the cell A1
a) Compares cell A1 with cell C12. If the cells are identical, the formula returns TRUE; otherwise, it returns FALSE
To open an HTML file stored on a Web server using Excel, what needs to be done? a) Copy the URL and paste it into the Name Field in the Open dialog box b) Excel cannot open an HTML file stored on a Web server c) Type the name of the HTML file in the Name Field in the Open dialog box d) Choose File --> Open --> Get External Data --> From Web
a) Copy the URL and paste it into the Name Field in the Open dialog box
Which of the following shortcuts allows you to enter the same data into multiple selected cells? Example: In a new Excel worksheet select cells A1:B4 and type "MIS111". The text is initially entered into cell A1. What could you do to replicate the same text "MIS111" in all the selected cells? a) Ctrl + Enter b) Ctrl + Shift c) Ctrl + Backspace d) Ctrl + Insert
a) Ctrl + Enter
Which of the following is the keyboard shortcut that creates a new blank workbook in Excel? a) Ctrl + N b) Ctrl + E c) Ctrl + W d) Ctrl + B
a) Ctrl + N
Which of the following keyboard shortcuts "cuts" the current selection of cells to both the Windows and Office clipboards? a) Ctrl + X b) Ctrl + V c) Ctrl + C d) Ctrl + Z
a) Ctrl + X
When you have imported data from an external data source, you can change properties of the 'external data range' by using the External Data Properties dialog box. How will you open this dialog box? a) Data(tab) -> Connections(group) -> Properties b) Data(tab) -> Connections c) Data(tab) -> Connections(group) -> Connections d) Data(tab) -> Connections(group) -> Refresh
a) Data(tab)-> Connections(group) -> Properties
What command (within Conditional Formatting, Manage Rules) is used to delete a specific rule from a worksheet? a) Delete Rule b) Clear Rule c) Alter Rule d) New Rule
a) Delete Rule
The Analysis Toolpak can be activated through which sequence of steps? a) File -> Options -> Add ins -> Manage Excel Add-ins -> Go b) Data -> Data Validation -> Manage Excel Add-ins -> OK c) Tools -> Options -> Data -> What-if Analysis d) Home -> Ribbon -> Analyze -> Analysis Toolpak
a) File -> Options -> Add ins -> Manage Excel Add-ins -> Go
The HYPERLINK function syntax has two arguments. Which argument has the jump text or numeric value that is displayed in the cell? a) Friendly_name b) Link_location c) Name d) File
a) Friendly_name
Which keyboard shortcuts can be used to move the active cell one column to the left? a) Left arrow or Shift + Tab b) Left arrow or Tab c) Left arrow or Ctrl + Tab d) Left arrow or Alt + Tab
a) Left arrow or Shift + Tab
Which of the following is an object that contains the actual data in the chart? a) Plot area b) Pie area c) Bar area d) Column area
a) Plot area
What does the following formula do? =COUNTIF(Data, TODAY()) a) Returns the number of cells containing the current date in the range named Data b) Returns the number of cells that were last changed on the current date in the range named Data c) "Returns the number of cells containing the text "TODAY()"" in the range named Data." d) Returns the value of the cells containing the current date in the range named Data.
a) Returns the number of cells containing the current date in the range named Data
To avoid printing more pages than necessary in Excel, you can use the following command: ____________. a) Set Print Area b) Reset Page Breaks c) Page Layout: Squashed d) Background Printing
a) Set Print Area
Which formula would you use if you want to accept only text that begins with a specific character 'a' for a given cell 'A1'? a) Use a formula: = LEFT(A1)="a" b) Use a formula: = RIGHT(A1)='a' c) Use a formula: =UPPER(A1)='A' d) None of the options provided is valid
a) Use a formula: =LEFT(A1)="a"
Which of the following options provides correct syntax for the VLOOKUP function? a) VLOOKUP(lookup_value, table_array, col_index_num, range_lookup) b) VLOOKUP(lookup_value, table_array, row_index_num, range_lookup) c) Either of the two previous choices will work d) None of the options provided is valid
a) VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
You can use a data Form to add, find, and edit rows in a range or table. Is this correct? a) Yes, all these are valid form operations b) Incorrect, as adding rows is not supported c) False, Data forms work only with Tables, not with Ranges d) No, Data forms work only with Ranges, not with Tables
a) Yes, all these are valid form operations
In an Excel Form, when finding a row by entering search criteria: Will the question mark symbol "?" find or match any single character? a) Yes, the "?" symbol is used to find/match a single character b) No, the asterisk or "*" symbol is used to match/find a single character c) The symbol for a single character is the tilde: ~ d) One of the limitations of form-based searching is the inability to find/match single characters
a) Yes, the "?" symbol is used to find/match a single character
Which of the following types (chart types) is a VALID option in the Charts ribbon group on the Insert ribbon tab? a) all of the options provided are valid b) area c) scatter d) column
a) all of the options provided are valid
Which of the following function(s) can be used to count error values in a range? a) all of the provided choices are valid b) ISERROR() c) ISERR() d) ISNA()
a) all of the provided choices are valid
In Excel, a parameter query is a query that prompts for _________ every time it is run. a) an input b) a password c) an image d) a fingerprint
a) an input
When you create one or more Sparklines in Excel, by default they all use ________ axis scaling a) automatic b) manual c) batch d) linear
a) automatic
A bar chart is essentially which of the following chart types rotated 90 degrees clockwise? a) column b) line c) area d) surface
a) column
In Step 1 of the Query Wizard, you select database _________ that you want to appear in your query. a) columns b) records c) rows d) sort order
a) columns
In Excel, what does the MODE function in a range return? a) most frequently occurring value in a range b) mean of the values in the range c) most frequently occurring text entry in a range d) middle value of the range
a) most frequently occurring value in a range
For a range called DATA, what does the function =COUNTIF(Data, TODAY()) return? a) number of cells containing the current date b) current date c) cells containing the current date d) cells not containing the current date
a) number of cells containing the current date
A ___________ is a graphical data representation of data displayed in a pivot table. a) pivot chart b) reverse pivot pie chart c) slicer d) sparkline
a) pivot chart
Which of the following is NOT a method of creating frequency distributions? a) use the Review (Proofing) tool of Spelling Error Frequency per Worksheet b) Write your own formula or function c) Use the Pivot table feature d) Use the Analysis ToolPak add-in
a) use the Review (Proofing) tool
What is the file format (file extension) used when you save an Excel workbook as a single file webpage? a) .html b) .mht or .mhtml c) .xlsx d) .txt
b) .mht or .mhtml
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". a) =HYPERLINK("[Example.xlsx]E2", "Quarterly Profit Report") b) =HYPERLINK("[http://example.microsoft.com/Annual Report.docx]QrtlyProfits", "Quarterly Profit Report") c) =HYPERLINK("[Annual Report.docx]QrtlyProfits", "Quarterly Profit Report") d) =HYPERLINK("QrtlyProfits", "Quarterly Profit Report")
b) =HYPERLINK("[http://example.microsoft.com/AnnualReport.docx]QrtlyProfits"',"Quarterly Profit Report")
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? a) =CASE(A1) b) =PROPER(A1) c) =PROPERCASE(A1) d) =LOWER(A1)
b) =PROPER(A1)
Which of the following does the search string ~?NULL~? match when entered in the find and replace dialog box? a) !NULL# b) ?NULL? c) ~?NULL~? d) ~NULL~
b) ?NULL?
There are a few commands that could be used to customize spark lines to highlight parts of data. One of them is Negative Points. What is its purpose? a) Apply a different color to the highest data point in the Sparkline b) Apply a different color to the negative values in the Sparkline c) Apply a different color to the lowest data point in the Sparkline d) Apply a different color to the first data point in the Sparkline
b) Apply a different color to the negative values in the Sparkline
Suppose you have a range of cells with numbers and a few blank entries. If you sort the range in ascending order (smallest to largest), where will the blank cells be located after sorting? a) At the beginning b) At the end c) Excel cannot sort ranges with blank values d) Excel leaves the blank values in their original location
b) At the end
Which of the following functions can be used to count specific types of errors? a) COUNTA b) COUNTIF c) COUNTBLANK d) COUNT
b) COUNTIF
How do you set up a data validations (using the data validation dialog box) that restricts data entry to a text of a specified length? a) Click the Settings tab (in the Data Validation box). In the Allow box, select 'date'. In the Data box, select 'greater than' b) Click the Settings tab (in the Data Validation box). In the Allow box, select 'Text Length', 'equal to', and specify the length c) Click the Settings tab (in the Data Validation box). In the Allow box, select 'Decimal'. In the Data box, select 'between' d) Home (tab) -> Editing (group) -> Find&Select -> Data Validation
b) Click the Settings tab (in the Data Validation box). In the Allow box, select 'Text Length', 'equal to', and specify the length
Which of the following keyboard shortcuts can be used in Excel 2016 to create a table? a) Ctrl + F2 b) Ctrl + L c) Alt + T d) Ctrl + Alt + L
b) Ctrl + L
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 sections. What is the purpose of the following code: &[Path]&[File]? a) Displays the workbooks complete path b) Displays the workbooks complete path and filename c) Displays the workbooks filename d) None of the above
b) Displays the workbooks complete path and filename
The _______ function is used to return a specific number of letters or characters from the start of a text string. a) FROMRIGHT() b) LEFT() c) MID() d) SUM()
b) LEFT()
What statement about the two Hyperlink arguments Hyperlink(link_location,[friendly_name]) is TRUE? a) Link_location is required, Friendly_name is required b) Link_location is required, Friendly_name is optional c) Link_location is optional, Friendly_name is required d) Link_location is optional, Friendly_name is optional
b) Link_location is required, Friendly_name is optional
To view or edit a comment, you can select the cell where a comment has been attached and press the following keyboard shortcut: ___________ a) Ctrl + Alt b) Shift + F2 c) F5 d) Ctrl + A
b) Shift + F2
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? a) The formula will now result in an answer of 0 b) The formula returns an error c) The formula will continue to work whether the "Total Row" option is checked or unchecked d) The formula will return the value "N/A" or be automatically hidden depending on whether you sort data Smallest to Largest or Largest to Smallest
b) 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? a) The word "budget" must appear in the cells surrounded by asterisks (i.e., the * character). b) The word "budget" can appear anywhere within the cell. c) It looks specifically for cells containing budget multiplied by some number. For example, a cell containing the formula: "=budget*0.25". d) Only cells with the text "budget" at the beginning or the end of the cell, are counted. Thus a cell with "budget constraint" is counted, but a cell with "Previous budget estimates" is not counted.
b) The word "budget" can appear anywhere within the cell
To find an asterisk (*) within a cell, you enter which of the following in an Excel form search criteria? a) a tilde followed by a question mark b) a tilde followed by an asterisk c) a tilde by itself d) this is a type of search you cannot do with Excel Forms
b) a tilde followed by an asterisk
To remove a single individual field from a report, _______ the check box beside the field name in the PivotTable Field List. a) check b) clear c) fill d) drag
b) clear
The __________ command is used to display text on multiple lines in a cell. a) shrink to fit b) wrap text c) merge cells d) icon formatting
b) wrap text
How many sort options/commands do we have in Excel under the 'Data' tab? a) 1 b) 2 c) 3 d) 4
c) 3
To extract a student's first name (e.g., "Herbert" from their full name (e.g., "Herbert Smith"), which of the following functions will you typically use? a) A combination of DATE(), FIND() and FIRST() b) A combination of REPT() and CONCATENATE() c) A combination of FIND() and MID() d) The function FIRST()
c) A combination of FIND() and MID()
Which of the following statements is true? a) A workbook can have at most 3 worksheets b) A workbook can have many workbooks c) A workbook can have many worksheets d) A worksheet can have at most 3 workbooks
c) A workbook can have many worksheets
Which of the following is true for printing a worksheet that contains objects/shapes? a) Objects are printed along in the worksheet by default b) You can avoid printing the object by making changes to the properties of the shape c) Both of the above d) None of the above
c) Both of the above
What option in the Table Tools / Design tab removes a table without losing the data in it? a) Remove Duplicates b) Summarize with PivotTable c) Convert to Range d) Delete Table
c) Convert to Range
What is the shortcut to open the Find and Replace dialog box with the "Replace" tab open? a) Ctrl + F b) Ctrl + A c) Ctrl + H d) Ctrl + FIND
c) Ctrl + H
Which of the following command sequences will allow you to save a copy of your workbook with a different name? a) Ctrl, A b) Ribbon, Save c) File, Save As d) Data, Create Copy
c) File, Save As
Which of the following statements is true? They all relate to the formula: =IF ( OR(Category="Pasta",Category="Soups"), Inventory_Cost,0 ) a) This type of IF() functions with an embedded OF() is no longer supported in Excel 2013 b) Such IF() statements are too complicated for use in business. They are only used by NASA c) In 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 d) Using a nested IF() in a formula is not recommended because the formula result is different based on the IQ level of the user
c) In 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 for the category ="Pasta") evaluates to FALSE
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) a) Comma Style b) Format Painter c) Left Align d) Center Align
c) Left Align
Does deleting a cell by pressing the Delete key also delete the conditional formatting on the cell? a) Yes, but only if the data is text b) Yes c) No d) No, it only deletes the cell's style
c) No
Which of the following is TRUE about sorting a table? a) Sorting a table is not possible b) Words cannot be sorted, while numbers can be sorted c) Sorting a table re-arranges the rows based on the contents of a particular column d) Sorting the rows based on the background or text color of the data is not possible
c) Sorting a table re-arranges the rows based on the contents of a particular column
Which of the following does the function =NOW() return? a) current date b) current time c) current date and time d) nothing, it is not a valid Excel function
c) current date and time
While creating a parameterized web query the ampersand character (&) is used to _________. a) delimit the parameter from the prompt b) delimit the name from the value c) delimit each name/ value pair d) begin the URL query string
c) delimit each name/ value pair
What does the Excel keyboard shortcut Ctrl+Alt+F9? a) highlights error codes in the current workbook b) calculates only the formulas in the active worksheet. Other worksheets in the same workbook aren't calculated c) forces a complete recalculation of all formulas in all open workbooks d) Ctrl+Alt+F9 will not do anything in Excel
c) forces a complete recalculation of all formulas in all open workbooks
What best describes the connection between a Pivot Table and a Pivot Chart? a) one-way link (updates from the Pivot Table are reflected in the chart, but not vice versa) b) one-way link (updates from the Pivot Chart are reflected in the Pivot Table, but not vice versa) c) two-way link (updates made in the Pivot Chart are reflected in the PivotTable) d) broken link
c) two-way link (updates made in the Pivot Chart are reflected in the PivotTable)
What result does the following formula display? =DOLLAR(5742.999,2) a) $5,742.99 b) $5742.99 c) $2,999,2475 d) $5,743.00
d) $5,743.00
To display today's date in the format like "Today is Friday April 4, 2014", which formula should you use? a) ="Today is "&TEXT(TODAY(),"dddd, mmmm, yy") b) ="Today is "&TEXT(TODAY(),"dddd, mmmm d, yy") c) ="Today is "&TEXT(TODAY(),"dddd, mmmm, yyyy") d) ="Today is "&TEXT(TODAY(),"dddd, mmmm d, yyyy")
d) ="Today is "&TEXT(TODAY(),"dddd, mmmm d, yyyy")
Which of the following formulas round a time in cell B2 to the closest minutes? (You can assume relevant cells have Excel's Time formatting). a) =ROUND(B2*24,0)/24 b) =ROUND(B2*60,0)/60 c) =ROUND(B2*30,0)/30 d) =ROUND(B2*1440,0)/1440
d) =ROUND(B2*1440.0)/1440
If you write a lookup formula to look up the text 'education', the formula considers which of the following a match? a) EDUCATION b) Education c) education d) All answers provided are correct
d) All answers provided are correct
Which of the following file types can Excel import? a) XML Files (.xml) b) Comma separated values (.csv) c) Microsoft Access (.accdb) d) All of the file types
d) All of the file types
How can you avoid the "#NAME?" error value? a) If the formula uses a label in a formula, make sure labels are allowed b) Enclose any text in double quotation marks c) Make sure all range references in the formula use a colon d) All of the options provided are correct
d) All of the options provided are correct
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? a) Move and Size with cells b) Move but don't Size with cells c) Don't move or Size with cells d) All of the options provided are correct
d) All of the options provided are correct
Which of the following actions can be performed on objects placed on the drawing layer with no effect on any other elements in the worksheet? a) move b) resize c) delete d) All of the options provided are correct
d) All of the options provided are correct
Which of the following is a type of Sparkline in Excel? a) Line b) Column c) Win/Loss d) All of the options provided are correct
d) All of the options provided are correct
Which of the following statements about Trace Precedents are correct? a) It can help point out if a formula has been applied to a wrong cell range b) You can access Trace Precedents on the Formula Auditing toolbar c) By clicking Trace Precedents again, you can identify the next level of cells that provide data to the active cell d) All of the options provided are correct
d) All of the options provided are correct
Which of the following is a VALID sequence of options for selecting a different chart layout? a) Design (from Chart tools) --> Type group b) Design (from Chart tools) --> Chart Styles c) Insert --> Charts --> Other Charts d) Design (from Chart Tools) --> Chart Layouts
d) Design (from Chart tools) --> Chart Layouts
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? a) Average b) Count c) Sum d) Mode
d) Mode
Which of the following is NOT an advantage of using defined range names to work with ranges in Excel? a) Entering a name is less error-prone than entering a range address b) Formulas become more understandable c) Creating formulas is easier d) Moving to areas of the worksheet is controlled
d) Moving to areas of the worksheet is controlled
In Excel, the _________ function calculates the difference between 2 dates excluding weekend days. a) EDATE() b) DATEVALUE() c) EOMONTH() d) NETWORKDAYS()
d) NETWORKDAYS()
Which function is used to calculate depreciation in Excel using the straight line method? a) DB() b) DDB() c) SYD() d) None of the above
d) None of the above
Which of the following is FALSE about Pivot Table Slicers? a) Slicers can be moved and resized b) The effects of filtering by a particular slicer can be removed c) To use a Slicer to filter data in a Pivot Table, you can click one of the slicer value buttons d) None of the answers provided is false
d) None of the answers provided is false
How do you format a valid date serial number as a date? a) Home (tab) -> Number (command group) -> Number Format -> $ b) Home (tab) -> Number (command group) -> Number Format -> Text c) Home (tab) -> Number (command group) -> Number Format -> Fraction d) None of the options provided is correct
d) None of the options provided are correct
When you use the HLOOKUP() function, which of the following parameters represent the row number from which the matching value will be returned? a) range lookup b) lookup_value c) row_care_param d) None of the options provided is correct
d) None of the options provided is correct
_________ cells are by default disregarded when data validation rules are created. These cells can be included in the validation rule by unchecking the: "Ignore blank" checkbox. a) Unchecked b) All c) Checked d) None of the options provided is valid
d) None of the options provided is valid
Which of the following is NOT a summary function for Pivot tables? a) StdDev b) Varp c) Var d) Regression
d) Regression
Adding comments to a cell is available through which tab of the Excel ribbon? a) Home b) Formulas c) Date d) Review
d) Review
What keyboard shortcut can you pass to move to the PREVIOUS field in an Excel data Form? a) Tab b) Ctrl + Tab c) Ctrl +Tab + Enter d) Shift + Tab
d) Shift + Tab
Which of the following is NOT one of the worksheet views offered by Excel? a) Normal b) Page Layout c) Page Break Preview d) Simplified Layout
d) Simplified Layout
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? a) Toggle b) Side View c) None of the (other) options provided is correct d) Synchronous Scrolling
d) Synchronous Scrolling
Regarding the search-and-replace features provided by the "Find and Replace" dialog box, what is NOT true? a) If you're looking for information in the worksheet, click the Find tab b) If you want to replace existing text with new text, use the Replace tab c) You can use the Options button to display additional options d) You cannot replace a type of formatting in a cell with another type of formatting
d) You cannot replace a type of formatting in a cell with another type of formatting
A single element in a worksheet that can hold a value, some text, or a formula is referred to as which of the following? a) entity b) component c) element d) cell
d) cell
Which of the following methods will NOT move or copy a worksheet? a) click the worksheet and drag it to the desired location b) click the worksheet tab and press "Ctrl" while dragging it to the desired location c) right-click the sheet tab and choose Move or Copy from the dialog box d) press keyboard shortcuts Ctrl + C and Ctrl + V in order
d) press keyboard shortcuts Ctrl + C and Ctrl + V in order
Fill in the blank: The COUNTIF() function used for single-criterion counting formula takes two arguments (or parameters) ______ or ______ a) range (and) constant b) expression (and) criteria c) constant (and) expression d) range (and) criteria
d) range (and) criteria
