Question

1. Suppose you select cells B4:C5, and then enter =B$3+20 and press CTRL + Enter. What will C5 contain?

A. =C$3+20

B. =B$4+20

C. =B$3+20

2. Imagine that you have two workbooks, called Master and Data. A cell in Master contains a link to a cell in Data, with the formula ='C:\GoSkills\[Data.xlsx]Sheet1'!B5. While the Master workbook was closed, a new row was inserted at A4 in Sheet1 of the Data workbook, then saved and closed. Next time the Master workbook is opened, what does the formula read?

A. ='C:\GoSkills\[Data.xlsx]Sheet1'!B6

B. ='C:\GoSkills\[Data.xlsx]Sheet1'!$B$5

C. ='C:\GoSkills\[Data.xlsx]Sheet1'!B5

3. Which is the best method to sort a data set by multiple columns (i.e. a multi-level sort)?

A. Sort by the first column, then select the second column and sort by that column

B. Go to Data and click Sort and add as many sorting levels as needed

C. Sort the data, then select the range of ties and sort that

4. What is a contiguous data range?

A. A range of data made up of distinct values

B. A range of data with no blank cells

C. A range of data uninterrupted by blank rows or columns

Answer 1

1. Answer 1 >> C$3+20

2. Answer 2 is B

3. B

4. C A contiguous data range means uninterrupted cells adjacent to each other.