Excel Trivia #2 Answers

Here are the answers to yesterday’s Excel trivia questions:

  1. How many nested IF statements can you include in a single formula?
    • 64
  2. What is the maximum amount of decimal places Excel can display?
    • 30
  3. What is the maximum amount of digits Excel can use in its calculations?
    • 15
    • A number can contain more than 15 digits, but Excel only calculates up to 15 significant digits.
  4. Do Excel’s random number generator functions generate pseudo or true random numbers?
    • Pseudo
    • Because Excel’s random number generator is a program not dependent on outside factors, if you have the code and the starting point you can predict what the result will be. Also, after a while the outcomes start to result in a pattern. Therefore, not truly random
  5. What is the difference between the MAX and LARGE functions?
    • MAX returns the maximum value, whereas LARGE can be set to find highest, second highest, etc.
  6. The column width corresponds to the number of characters that can be displayed in a cell formatted with the standard font. What is the maximum column width Excel allows?
    • 255
  7. Row height is measured by “points.” How many points are equal to one (1) inch?
    • 72
    • The Point unit of measurement is a holdover from typography. The standard adopted for computers is 72 points to an inch
  8. What is the maximum number of points a row can be in Excel?
    • 409
  9. What is the maximum amount of undo levels?
    • 100
  10. What is the maximum number of items than can be displayed in a filter drop-down list?
    • 10,000
  11. In billions, what is the maximum number of formulas that can depend on a single cell? Hint: Answer between 0-10
    • 4 billion

Excel Trivia #2

This week’s Excel trivia questions are as follows:

  1. How many nested IF statements can you include in a single formula?
  2. What is the maximum amount of decimal places Excel can display?
  3. What is the maximum amount of digits Excel can use in its calculations?
  4. Do Excel’s random number generator functions generate pseudo or true random numbers?
  5. What is the difference between the MAX and LARGE functions?
  6. The column width corresponds to the number of characters that can be displayed in a cell formatted with the standard font. What is the maximum column width Excel allows?
  7. Row height is measured by “points.” How many points are equal to one (1) inch?
  8. What is the maximum number of points a row can be in Excel?
  9. What is the maximum amount of undo levels?
  10. What is the maximum number of items than can be displayed in a filter drop-down list?
  11. In billions, what is the maximum number of formulas that can depend on a single cell? Hint: Answer between 0-10

Excel Trivia #1 Answers

Here are the answers to yesterday’s Excel trivia questions:

  1. In 1985, the first Microsoft Excel program was released for what operating system?
    • MacIntosh System Software
    • Excel came out for windows in 1987
  2. What tool within Excel allows a user to split a cell’s information into several columns, either based on a fixed point or based on the occurrence of a character, such as a comma or a space?
    • Text to Columns
  3. The music video for the 2002 song “Dilemma,” features one character attempting to message another via Microsoft Excel on a Nokia 9210 Communicator phone. Name the performers. 1 point for main artist; 1 point for featuring artist.
    • Nelly ft. Kelly Rowland
  4. Beginning with Excel 2007, the default filetype for Excel Workbooks (XML-based files) was changed to .xlsx . What was the previous file extension?
    • .xls
  5. What anthropomorphic object was the default “Office Assistant” introduced with Microsoft Office 1997?
    • Clippit aka Clippy
  6. What is the latest in time Excel’s date range extends to?
    • 12/31/9999
  7. As of Excel 2016, how many functions (SUM, VLOOKUP, IF, etc.) does Excel have?   A) 124 B) 360 C) 484 D) 512    C) 484
  8. What competitor of Microsoft Excel has the limitations of i) 200 tabs maximum; ii) limited functionality of shortcuts and function keys; and iii) a specific email extension is required to create a file?
    • Google Sheets
  9. What fictitious date does Excel include in its programming, for the purpose of bug compatibility with earlier programs?
    • 2/29/1900
    • Leap Day is skipped every 100 years except every 400 years. Competing software Lotus 1-2-3 did not program the skipped Leap Day of 1900 in order to save space. The original Excel did the same to maintain consistency and it still lives on today
  10. Which of the following is NOT a Microsoft Office font: Wingdings, Gulim, Dagoosh, Gadugi?
    • Dagoosh

Excel Trivia #1

Wow your employer (current or prospective) or your peers/spouse with your Excel knowledge.  We are going to post a series of Excel Trivia questions for you and your friends to enjoy (at least this is what geeks like our analysts do on their free time)!  Here you go:

  1. In 1985, the first Microsoft Excel program was released for what operating system?
  2. What tool within Excel allows a user to split a cell’s information into several columns, either based on a fixed point or based on the occurrence of a character, such as a comma or a space?
  3. The music video for the 2002 song “Dilemma,” features one character attempting to message another via Microsoft Excel on a Nokia 9210 Communicator phone. Name the performers. 1 point for main artist; 1 point for featuring artist.
  4. Beginning with Excel 2007, the default filetype for Excel Workbooks (XML-based files) was changed to .xlsx . What was the previous file extension?
  5. What anthropomorphic object was the default “Office Assistant” introduced with Microsoft Office 1997?
  6. What is the latest in time Excel’s date range extends to?
  7. As of Excel 2016, how many functions (SUM, VLOOKUP, IF, etc.) does Excel have?
  8. What competitor of Microsoft Excel has the limitations of i) 200 tabs maximum; ii) limited functionality of shortcuts and function keys; and iii) a specific email extension is required to create a file?
  9. What fictitious date does Excel include in its programming, for the purpose of bug compatibility with earlier programs?
  10. Which of the following is NOT a Microsoft Office font: Wingdings, Gulim, Dagoosh, Gadugi?

Answers will be posted tomorrow!

 

 

Quality Internships – Look No Further than ACG

Internships are almost twice as important as one’s major, three times as important as your GPA, and 5 times as important as the college reputation.  This research comes as no surprise to ACG as our internship program is the best program in the industry.  We have had 47 interns over the past 14 years, most of whom have experienced extraordinary success working in asset management, acquisition, development, and brokerage.  There are more than a 15 firms in Atlanta who regularly hire our interns because the interns not only have great academic credentials but have practical software and due diligence experience.

If you are looking to get into the industry and you need the experience of an internship program that trains and prepares you for success, consider applying for our 3-month internship program.  At the conclusion of the program, we place you with one of our clients (or we employ you ourselves).  We are now accepting applicants for our summer 2020 program.  Please send your resume to jobs@acgpro.com.

Resume Tip: Numbers, Numbers and More Numbers

If you are applying for an analyst, acquisitions, asset management, or brokerage position then you should make sure that you add as many numbers to your resume as possible. For example, don’t just state that you were involved with the closing, due diligence and structuring of numerous real estate transactions. Instead, write “involved in $1.2 billion of real estate transactions including 11 strip centers, 6 office buildings and a 1.3 million SF multi-use development.” If you modeled and reviewed cash flows, state that you “built 26 Argus models totaling $165 million including 9 regional malls with complex recovery methodologies.” The more numbers that you include on your resume, the better impression you will make.

My Former Employer Sucks…NOT!

When you interview for a job, you most likely will be asked to describe your former employers. Make sure that you are positive about the job and about the person to whom you reported. I had one candidate tell me recently that his boss was having an affair and his supervisor was an idiot. No way I am hiring that person! Never talk negatively about your prior employer. If you have nothing nice to say, say nothing. Nobody likes a complainer.

How not to describe yourself in an interview

According to an article in Business Insider, there are some words that you should not use to describe yourself when you are interviewing.  These include intelligent (versus quantitative  and analytical), likable (versus high-energy, team-oriented) and successful (versus your specific value that you bring to the table).  You want to be able to articulate why you are a good fit the the position they are looking to fill.  The more that you can tell a story that demonstrates your attributes versus describing your attributes, the greater the likelihood will be that you are well-received.

Best Question to ask at Job Interview

According to Dave Kerpen, CEO of Likeable Local, there comes a time in every job interview when the interviewer asks, “Now do you have any questions forme ?”  This is a terrific opportunity to impress the interviewer.  Kerpen addes that the most important question you can ask is, “How will the work I’ll be doing contribute to the organization’s mission?” 

We further recommend that you couch this question by articulating your value proposition.  For example, you might frame the question as the following: “My Argus and Excel skills are advanced based upon the significant amount of transaction-based work that I have been asked to do over the past couple of years.  How might these skills contribute to your overall mission?”

Entering an interview armed with these types of questions surely will distinguish you from other candidates.

Did you know? Argus Tips and Tricks

Did you know that prior to editing any variable, you likely should select the “In Use” button to identify where else in Argus that variable is being applied.  Any changes made in a variable will filter throughout the entire model.  The use of the “In Use” functionality will prevent you from inadvertently changing a variable.