Exam (elaborations)
CGS 2518 Exam 2 Questions with correct Answers
- Course
- Institution
CGS 2518 Exam 2 Questions with correct Answers
[Show more]
Content preview
CGS 2518 Exam 2 Questions withcorrect Answers
What is an Excel table? - Answers -A range of related data that is managed
independently from data in other rows and columns in the worksheet
What can you do using excel? - Answers -1) Store and update data
2) Sort data
3) Search for and retrieve subsets of data
4) Summarize data
5) Create reports
Every excel table has a? - Answers -Table name, which you can change to a descriptive
name
Each column represents a? - Answers -Field
Define Field - Answers -Describes some characteristic of a person, place, or thing such
as a last name, address, city, to state
The first row of the range contains field names called? - Answers -Header Row
Often where is Header Row? - Answers -Typically Row 1 but it can begin in any row
Each row represents a? - Answers -Record
What is a record? - Answers -A collection of related fields that are grouped together
Define sort - Answers -Rearrange
What can you do to the records in a table? - Answers -You can sort them based on one
or more fields
What is another name for Field Name? - Answers -Column Header
What is a Field Name? - Answers -A unique label that describes the contents of the
data in a column
The filter arrow changes to ______ when the data is sorted by that field - Answers -Sort
icon
, What does table styles provide? - Answers -A way to quickly format an entire table
using a preset style definition
What do you click to sort the table by data in that column? - Answers -Filter arrow
Define Sort Fields - Answers -The fields that you use to order data
What is a structured range of data commonly referred to as? - Answers -A list or table
What is a Date Definition Table? - Answers -Documentation that lists the fields to be
maintained for each record and a description of the information each field will include
What does "freezing" do? - Answers -Freezing a row or column lets you keep the
headings visible as you work with the data in a large worksheet
When you "freeze" a row, which row are you freezing? - Answers -The first row, which
contains the column headers
After you freeze panes what happens to the to the first option on the Freeze Panes
menu? - Answers -It changes to Unfreeze panes
What happens when you unfreeze panes? - Answers -All the columns and rows in the
worksheet shift when you scroll the worksheet
Excel adds header with what default name? - Answers -Column1 and so on
What things happen when you create an excel table? - Answers -1) Contextual tab
appears on the ribbon
2) Filter arrows appear in the header row
3) Header row replaces the letters in the column headers
What can you use instead of spaces to separate words in a table name? - Answers -
Underscore character
How do you add a record to an Excel table? - Answers -Enter the data in the first blank
row below the last record
If you want to add a record in a specific location in a Excel table what do you do? -
Answers -You insert a row within the table for the new record
What does the button with a lightning bolt represent? - Answers -Autocorrect Options
Button
How can you find a specific record in a table? - Answers -1) Scroll through the record
2) Use the Find command
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 millyphilip. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
62890 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now