HomeworkLib
Question

Excel questions: What is the cell reference for the cell located in the second column and...

Excel questions:

  1. What is the cell reference for the cell located in the second column and fifth row of a worksheet:
  2. What is the reference for the nonadjacent block of cells B5 through C10 and cells B15 through D20?
  3. How do you enter a number so that Excel sees it as text
  4. Cell B2 contains the entry May 3, 2017. Why doesn’t Excel consider this a text entry?
engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

1) B5

In Excel, rows are represented as 1,2,3 ...and colums are represented by letters A, B, C...Then for a cell reference, we can type the column and row coordinates manually. So, here B column and fifth row that is B5.

2) B5:C10,B15:D20

A non adjascent cells consists of two or more block of cells. These blocks can be separated by rows or columns as shown by the ranges B5 to C10 and B15 to D20.

3) We should specify an apostrophe before the numbers
Eg: '012348

4) Enter it as text but it is stored as a number entry. and also fraction of the 24 hour ( means a day). It stores as a number equal to the number of days between the specified date and January 0, 1900.

0 0
Add a comment
Know the answer?
Add Answer to:
Excel questions: What is the cell reference for the cell located in the second column and...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • In reference to working with Microsoft Excel, what problems could you run into when using a...

    In reference to working with Microsoft Excel, what problems could you run into when using a large worksheet? How can you prevent these problems? When is it appropriate to delete an entire row or column, as opposed to deleting data in the row or column?

  • Please Answer all these. Those questions are from New Perspectives Microsoft Office 365 & Excel 2016...

    Please Answer all these. Those questions are from New Perspectives Microsoft Office 365 & Excel 2016 . Need answers from Excel concern : 1. What formula would you enter to add the values in cells C1, C2, and C3? What function would you enter to achieve the same result? 2. What formula would you enter to count how many numeric values are in the range D21:D72? 3. If you insert cells into the range C1:D10, shifting the cells to the...

  • s) For the questions below, you must write out exactly what you would need to type into Excel (starting with the equal sign) in order to have Excel perform the correct calculation. Be mindful of...

    s) For the questions below, you must write out exactly what you would need to type into Excel (starting with the equal sign) in order to have Excel perform the correct calculation. Be mindful of writing the parenthesis correctlyl a) (4 points) What formula would need to be typed in cell B2 in order to have Excel perform the correct calculation? Your formula needs to reference cell A2 so that it could be dragged down to the entire input-output table....

  • In this project, you will work with sales data from Top’t Corn, a popcorn company with...

    In this project, you will work with sales data from Top’t Corn, a popcorn company with an online store, multiple food trucks, and two retail stores. You will begin by inserting a new worksheet and entering sales data for the four food truck locations, formatting the data, and calculating totals. You will create a pie chart to represent the total units sold by location and a column chart to represent sales by popcorn type. You will format the charts, and...

  • For the questions below, you must write out exactly what you sign) in order to have Excel perform the correct calculation. Be mindful of writing the parenthesis correctlyl would need to type into...

    For the questions below, you must write out exactly what you sign) in order to have Excel perform the correct calculation. Be mindful of writing the parenthesis correctlyl would need to type into Excel(starting with the equal a) (4 points) What formula would need to be typed in cell B2 in order to have Excel perform the correct calculation? Your formula needs to reference cell A2 so that it could be dragged down to the entire input-output table. f(x) =...

  • The Chestnut Street Company plans to issue a bond semiannually on March 31st and September 30th....

    The Chestnut Street Company plans to issue a bond semiannually on March 31st and September 30th. The Controller has asked you to calculate Information about the bond assuming two different market interest rates in the Excel Simulation below. The present value factor tables are Included in the first four tabs of the Excel Simulation. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer to...

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

    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...

  • Please show formula !!! Preparing a Cash Budget with Supporting Schedules using Excel's Multi-Tab Cell Referencing...

    Please show formula !!! Preparing a Cash Budget with Supporting Schedules using Excel's Multi-Tab Cell Referencing and Basic Math Functions S&P Enterprises has provided data from the first three months of the year. The Controller has asked you to prepare the Cash Budget and the related Schedules for Expected cash collections and Payments to suppliers. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer...

  • Excel is allowed! For this lab, we will create a spreadsheet that allows somebody to type...

    Excel is allowed! For this lab, we will create a spreadsheet that allows somebody to type in a loan amount, interest rate, and length of the loan in years. The spreadsheet will then calculate the monthly payment required and the actual amount paid on the loan. First, setup your spreadsheet: • In Cell A1, put the label Loan Amount:. The corresponding value would be input in Cell B1. • In Cell A2, put the label Interest Rate:. The corresponding value...

  • Chapter 12 Information Systems, Read this book Computer Science Illuminated, Sixth Edition by Dale and Lewis...

    Chapter 12 Information Systems, Read this book Computer Science Illuminated, Sixth Edition by Dale and Lewis p. 395-406 & 417-418 and answer the questions. Do not use direct quotes from the text, but make it clear that you have read the text to answer the questions. 1. What is an information system? 2. In figure 12.2, what would displayed in spreadsheet cell C11 if it contained the formula: =D10+C10 ? 3. Is the internet helping or hurting the democratic process?...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT