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