MIS LAB Exam

What is a keyboard shortcut for creating a table? (you can test the options in Excel)

Ctrl+L

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.

#NUM!

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)?

(Control + B) + (Control + 5)

By default, Excel uses __________ font

11 point (pt) Calibri

With a single IF() function, how many actions can you ask Excel to carry out?

2 (i.e., an action if the criteria is true, or an an action if the criteria is false)

Worksheet names can have upto ______ characters.

31

Which of the following reviewing features does Excel offer to you?

A proofing tool to check spelling

A Loan amortization schedule in Excel is :

A table of values that shows various types of information for each payment period of a loan

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

Which of the following is TRUE about a Watermark in Excel?

All of the above statements are TRUE.

If you write a lookup formula to look up the text 'education', the formula considers which of the following a match?

All the above

What would you do while creating a table to display your Table Headers?

Check 'My table has headers'

What is the purpose of the function TIME()?

Converts the input hours, minutes & seconds to a serial number

In Excel in order to avoid incomplete calculation errors and to ensure that formulas are fully calculated, you would press _________ .

Ctrl + Alt + Shift + F9

In the Excel Backstage view, which of the following pieces of information about your workbook are available?

Date the workbook was created

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 worksheet's name

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

File, Save As

What does the following Excel keyboard shortcut do: Ctrl+Alt+F9 ?

Forces a complete recalculation of all formulas in all open workbooks.

Which function is used to create a shortcut that opens a document stored on a network server, an intranet, or the Internet?

HYPERLINK()

Which of the following statements is true?

If 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

The ___ function can be used to find the number of characters in a word or text string.

LEN()

What is the correct syntax for the LOOKUP function?

LOOKUP(lookup_value,lookup_vector,result_vector)

Which of the following is true about Web queries?

Performing Web queries copies information from an HTML file into the current workbook

A -> Z (ascending sort) and Z-> A (descending sort) are both called ________ sorts

Quick

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

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

Slicer

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

Yes, by default they are dynamic

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?

circles appear around cells that contain incorrect entries.

Which of the following options can be used to quickly remove data validation for a cell?

select the cell and open the Data Validation dialog box (Data (tab) -> Data Tools (group)). On the Settings tab, click Clear All.

How do you copy a Pivot table to a new worksheet?

select 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

A date filter in Pivot Tables is used to _____________________

specify a time period for which you need the data