Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. 1. suppose you select cells b4:c5, and then enter

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

60.1K

Verified Solution

Question

Accounting

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 & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students