Upgrade to remove ads
Only $35.99/year

GB 310 exam 1 review

Terms in this set (50)

Which of the following is not a key component of an information system?
all of the above are a key component
What are three components of information technology?
Hardware, software, and data
What is a delimiter?
a character that separated the data field values.
What are the two most common delimiters used to separate data values?
comma, and tab
How do you multiply in Excel?
Manually enter the symbol. For example, = 12
If a worksheet has 1 column and 10 rows of data, how many rows and columns will its transpose have?
10 columns and 1 row
What is the significance of the total row?
It makes it easy to calculate various statistics for the columns
All versions of excel have the same functionality. For example, all versions of Excel have the Power Query Editor
false
Which of the following functions can be used to count the number of missing cells in a range?
countblank
Excel is an example of computer hardware.
false
Excel is an example of computer software
true
Equations used in this class start with an equal sign. For example, = average (1,2,3)
true
The last active cell is always the last cell with data in it
false
Which series fill option allows you to complete multiplicative series (e.g., 1,2,4,8)?
growth
Generally speaking, what does the fill handle do?
it copies things
Which series fill option allows you to complete additive series (e.g., 22,25,28...)?
Linear
In a typical dataset, variables are on the columns
true
What are the tabs located at the bottom left of an excel file called?
Worksheets
Which Table Style Option allows you to select calculate complex functions?
total row
All color-coded worksheets are formatted as a table.
false
What is the most important reason to avoid hand entering data if possible?
it is error prone
In a typical dataset, records (or observations) are on the rows.
true
What is one of the most important functions in Excel?
undo
What is the file extension for an Excel file?
XIS or XISX
Why is it important to be proficient in Excel?
Excel is a commonly used powerful software tool
Open the "Attitudes Fall 2021 Final.xlsx" file found on Blackboard, what is the learning score for person 20 (person_id = 20)
64
How do you know these data (the Attitudes Fall 2021 data) are formatted as a table?
when you click inside the table, the table design tab becomes available
Which of the following numbers does not appear in this worksheet (Sheet1 in the Attitudes Fall 2021 data
99
Which person (what is the person_id) has the highest rating (column C in the Attitudes Winter 2022 Data)?
29
Filtering the data by department allows you to calculate the average of the complaint's variable separately for a department.
true
What is the name of the table in Sheet1 in the Attitudes Fall 2021 data?
table 2
What is the name of the named range in this worksheet (Sheet1 of the Attitudes Fall 2021 data)?
Sales Complaints
How many people are in this dataset (in the Attitudes Fall 2021 data)?
40
How many people have a learning score above 70 in the Attitudes Winter 2022 data?
5
What is the largest numeric value in the worksheet (Sheet1 of the Attitudes Fall 2021 data)?
92
Which function will easily allow you to create a series of numbers from 1 to 40 as is done in the person_id column?
fill handle
How many worksheets are in this workbook? Please note that the next 7 questions require you to use the Attitudes Fall 2021 data.
1
Which department has the highest average complaint score?
HR
Which variable has the highest average across all of the employees?
Critical
How may columns are in this datafile?
9
How many missing (blank) cells of data are there in this datafile?
4
How many different departments are in this dataset?
4
The Accounting department has 10 people in it.
true
If a filter has been applied to a column, then a filter figure will appear next to the down arrow at the top of the column.
true
What is the way to paste only the numeric values?
paste values
1. The label at the top of a column is always a header.
false
Why is it important to use Excel capabilities as opposed to manually calculating things? For example, why is it better to use the average function than to use a hand calculator?
Excel's functions can be easily used even if you have many data points (for example 100)
Which of the following ways does not calculate an average of the numbers 1,2, and 3?
=mean (1,2,3)
There is typically only a single way to perform a task in Excel.
false
Formatting the data as a table makes it easier to perform calculations.
true
Other sets by this creator