MSIS 2103 Glancy Final Questions And Answers With Verified 2024 Quiz
1 view 0 purchase
Course
MSIS 2103
Institution
MSIS 2103
MSIS 2103 Glancy Final Questions And Answers With Verified 2024 Quiz
If you want to paste a formula result, but not the underlying formula, to another cell, you would copy the cell with the formula, then place the insertion point in the cell you want to copy to. What next?
Click the Paste b...
MSIS 2103 Glancy Final Questions And Answers With
Verified 2024 Quiz
If you want to paste a formula result, but not the underlying formula, to another cell, you would copy the cell with
the formula, then place the insertion point in the cell you want to copy to. What next?
Click the Paste button on the Standard toolbar.
Click the arrow on the Paste button on the Standard toolbar, then click Formulas.
Click the arrow on the Paste button on the Standard toolbar, then click Values.
Right click on the cell and select Paste from the dropdown menu. ANS Click the arrow on the Paste button on
the Standard toolbar, then click Values.
In a VLOOKUP formula, what does the argument "column_index_number" mean?
This is the secret INDEX number that each column in an Excel worksheet has.
This is the number of the column within the selected table_array where the lookup result is located.
This is a numerical representation of the letters at the top of a worksheet. For example, A = 1, B = 2, etc.
This is numbers that you assign to columns in your worksheet. ANS This is the number of the column within the
selected table_array where the lookup result is located.
,If you have columns that are truncating your content (not showing all the content), but you cannot increase the
width of the worksheet and be able to print on one page, a solution for making the text visible without losing data
would be to:
Abbreviate all text
Reduce the font size to 8 pt
Click Wrap text
Delete one column ANS Click Wrap text
What is the first step for creating a Pivot Table?
Clicking on the Insert Tab and inserting a Pivot Table.
Create or select data that needs to be analyzed.
Deciding on which fields (column and row labels) to use to analyze the data.
None of the above options are correct. ANS Create or select data that needs to be analyzed.
Which is the part of the Excel screen where you can find all the commands or buttons, depending on the tab you
selected before?
,Ribbon
Formula Bar
Tab
Backstage ANS Ribbon
Your Internet Service Provider (ISP) says that your network runs at 50 gigabit per second. This is the _______.
Latency
Bandwidth
Throughput
Processing Power ANS Bandwidth
A URL has two parts. The first part is the protocol identifier, and the second is the domain name. A URL does not
need to have an IP address associated with it.
True
False ANS False
, To select several cells or ranges that are not touching each other, you would _____ while selecting
Hold down the CTRL key
Hold down the SHIFT key
Hold down the ALT key
None of these. You cannot select cells that are not touching each other. ANS Hold down the CTRL key
When you post a review on a business you are _______.
Interfacing with a business system
Providing content
Using an ebusiness-facing information system
Using a social relationship system ANS Providing content
How do businesses make money on the Internet?
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Labtech. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $14.49. You're not tied to anything after your purchase.
