GB 310 Assignments/Quizzes
QUESTION 5 Enter the data provided below into Excel in a column (for example A1:A8). Copy the data and transpose it where the leftmost cell is H1. What is the value in L1? 10, 20, 41, 57, 33, 51, q53, 23 33 41 23 q53
33
QUESTION 2 Complete the series seen below starting with cell A1. What is the value in cell A20? 1, 20, 39 ... 5151 279 100 362
362
QUESTION 4 Why is it important to know how to complete series and use various copy/paste options? Manually entering data is tedious Manually entering data is error prone Manually entering data takes too much time when it can be avoided All of the above
All of the above
QUESTION 1 Which of the following would result in a decreasing series? Drag the fill handle right Drag the fill handle up Drag the fill handle down Excel only does increasing series completion
Drag the fill handle up
Objective One Quiz
Questions
QUESTION 3 If a growth series and a linear series are specified that start at 1 and have a step value of 2, which series has a larger value when the 10th value is reached in each series? The linear series The growth series They are equivalent The growth series is not provided by Excel
The growth series
Please import the "Hterm-2R_data_forQuiz.csv" file. What value is presented in cell H44? a. 1 b. 0 c. Missing d. NA
a. 1
How many columns are in this worksheet? a. 11 b. 1000 c. 1001 d. 12
a. 11
How many employees were not promoted? a. 499 b. 500 c. 1000 d. 501
a. 499
How many missing or blank cells are there in this entire workbook? a. 5 b. 10 c. No way to determine d. 25
a. 5
Which of the following pieces of code does not execute properly in this workbook? a. =average(employeeID) b. =average(satisfaction) c. =average(1,2,3) d. =sum(1,2,3)
a. =average(employeeID)
A delimiter is a character that separates the data field value. a. True b. False
a. True
Excel has a maximum on the number of rows/columns that can be held in a worksheet. a. True b. False
a. True
How many rows are in the worksheet (excluding the column headers)? a. 11 b. 1000 c. 12 d. 1001
b. 1000
Which of the following is a named range in the "HR_data_forQuiz.xlsx" file? a. last evaluation b. monthly hours c. satisfaction d. number of projects
c. satisfaction
How many missing or blank cells are there in the "Time in Company" variable (column F)? a. 5 b. 25 c. 12 d. 1
d. 1