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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started