Archive for the ‘Excel Tips’ Category

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!

 

 

Excel Tips: Name versus Amount

To input data beginning with zero (for a Suite number, for example), first input an apostrophe like so: ‘00724.  Otherwise, Excel will automatically delete the zero prior to the other numbers.

Excel Tips: Selecting Multiple Cells

To quickly select multiple cells in a row or column, hit “F8” to activate Extend and then use one of the four arrow keys for whichever direction in the table that you would like to highlight.  You can then perform a host of functions on the selected cells.  This is especially useful when formatting cells.

Excel Tips: Control + Tab

Use “Control + Tab” to quickly jump to a different excel spreadsheet.  This comes in handy when you are working in multiple spreadsheets.  Similarly, you can use “Alt + Tab” to jump to a different window altogether.

Excel Tips: Grouping vs Hiding Celling

Grouping rows and/or columns can be preferable to hiding them.   When rows or columns are grouped, Excel creates a small “+” button along with a header column or row with a little “1” and “2” header.   Clicking on these “+” buttons will quickly expand or contract the selection or header columns/rows.   Try it…it is pretty cool.

Excel Tips: Tracing Formulas

“Trace Dependents” and “Trace Precedents” are terrific ways to audit a large workbook.  We use these frequently when we inherit complicated spreadsheets from others.  These tools allow you to quickly view which cells and formulas in the entire workbook pull from the target cell in question.

Excel Tips: Quick Way to Format Cells

Did you know that you can hit Ctrl + 1 to create a quick short cut to the menu item of Format Cells.  From here you can change the Category, the Alignment, the Font, the Border, the Fill or the Protection on any given cell.

Excel Tips: Automatically Fill a Row or Column with a Custom List of Names

Excel automatically fills a row with the names of months or weekdays when you type in the first few items in the row, then select the cells and drag the “fill handle” at the lower right corner of the selection to extend the series. If you have a series of words or names that you frequently enter by hand, create a custom autofill list. Click on File, then Options, and then Advanced. Scroll down almost to the foot of the Advanced menu. Under the General heading, click Edit Custom Lists…, and in the Customs List dialog, click New List and enter your list of words.

Excel Tips: Removing Existing Hyperlinks

To remove a hyperlink from a cell (but keep the cell’s contents), right-click the cell and choose Remove Hyperlink from the shortcut menu. To remove all hyperlinks in a range, select the range, right-click, and choose Remove Hyperlinks. This command works even if the selection includes cells that don’t contain a hyperlink. To remove all hyperlinks on a worksheet, press Ctrl+A to select all cells. Then right-click any cell and choose Remove Hyperlinks. Depending on the location of the cell pointer, you may need to press Ctrl+A twice to select all cells.