Excel Flashcards
Initial windows release date
19 November 1987
Language written in
C++
License Type
Trialware
Initial release date (Mac)
30 September 1985
What does VBA stand for
Visual Basic for Applications
The introduction of what function made Excel Turing Complete
LAMBDA
How many functions are in Excel 2016
484
How many categories of function
14
What object does VBA use to recall functions
Worksheetfunction
What windows are included in VisualBasic Editor
Writing code, debugging code, code module organisation environment
A common easy way to generate VBA code
Macro Recorder
VBA code interacts with the spreadsheet using what model
Object Model
What was the default macro Language through Excel 4.0
XLM
Tool for optimisation and equation solving
Solver
How many rows can the current version of excel handle
2^20 (1 048 576) rows
How many columns can the current version of excel handle, and how is it labelled
2^14 (16 384) columns - XFD
What year was xlsx added?
2007
Excel Workbook file format
xlsx
Macro enabled workbook file format
xlsm
Binary workbook file format
xlsb
macro enabled template file format
xltm
add-in file dormat
xlam
how did Microsoft publications refer to Dynamic Data Exchange?
the protocol from hell
what does DDE stand for
Dynamic data exchange
What are the five types of password protection?
Password to open a document
Password to modify a document
Password to unprotect the worksheet
Password to protect workbook
Password to protect the sharing workbook
What is the standard password for document encryption
VelvetSweatshop
What year did Excel mobile launch?
2015
how many figures of precision does Excel maintain in computations?
15
How many figures can Excel display?
30
Fictional date
29 Feb 1900
First date in date range
December 31 1899 (0)
Name of originally marketed Microsoft spreadsheet program
Multiplan
Lotus competitor
Lotus 1-2-3 / LotusNotes
GUI definition
Graphical User Interface
First version available on Windows and date
2.0, 19 nov 1987
Excel 4.0 easter egg
animation of dancing 1-2-3, crushed by an excel logo
Introduction of VBA -excel version
5.0
Missing version numbers
6.0 and 13
Easter egg game in excel 95
Doom - The Hall of Tortured souls
Easter egg game in excel 97
Flight simulator
Easter egg game in Excel 2000
Dev Hunter
Introduction of paper clip office assistant
Excel 97
Year/edition of New ribbon interface
Excel 2007
name for a system able to recognize or decide other data-manipulation rule sets
Turing Complete / computationally universal
Name of person who developed first analytical engine and when
Charles Babbage (1830s)
First electronic spreadsheet on a mainframe
LANPAR
First electronic spreadsheet on a microcomputer
VisiCalc
Google equivalent
Google Sheets
Apple equivalent
Numbers
Term for contiguous group of cells
Range
what function is missing from a spreadsheet that is required for a database
relational structure
a system in which editing software allows content to be edited in a form that resembles its appearance
What You See Is What You Get
Apache alternative
Openoffice Calc
Gnu Equivanent
Gnumeric
LANPAR definition
LANguage for Programming Arrays at Random
What syntax is used to direct to a different sheet
!
What is a circular reference
when the formula in one cell refers—directly, or indirectly through a chain of cell references—to another cell that refers back to the first cell
what expressions can a cell contain (5)
values, references, relational operators, arithmetic operators, functions
syntax for absolute references
$
Format for unstructured data
CSV (comma separated values)
What is a table of grouped values that aggregates the individual items
Pivot table
How does excel round 0.5
up
How many stages in the Financial Modelling world cup
8
Which function would you use to add several numeric values?
Sum
What tool shows a formula and its results step-by-step.
Evaluate Formula” tool
What button can you click to automatically add a range of celss
autosum
Freeze panes tab
View
name of command line above spreadsheet
formula bar
Formula automatically capitalising first letter
Proper
Which feature starts with a desired result, then calculates the input value that will give that result?
Goal seek
Which option allows you to lock certain rows or columns in place while scrolling through a large worksheet?
Freeze Panes
How many worksheets open in a new workbook by default
3 (old), 1 (new)
”######” means
The cell is not wide enough
Which key do you press to group two or more nonadjacent worksheets?
SHIFT
What is the default row height of MS Excel?
15
Greek letter used as sum symbol
Sigma
Musical artist using Excel to text
Kelly Rowland
Song and artist where character uses excel to text
Dilemma - Nelly ft Kelly Rowland
Phone musical artist uses to text
Nokia 9210 Communicator
Text message in music video
Where you at? Holla when you get this
Who was being texted in the music video?
Nelly
What did Kelly Rowland say when asked about texting in Excel?
I don’t know what Microsoft Excel is. I don’t have a clue
What row do you use to activate Hall of Tortured Souls?
95
How do you open Flight Sim in excel 97
- On a new Worksheet, Press F5
- Type X97:L97 and hit enter
- Press the tab key
- Hold Ctrl-Shift
- Click on the Chart Wizard toolbar button
What network broadcasts the excel world championship
ESPN
Who is the current excel world champion?
Laurence Lau
What excel issue may have resulted in the loss of covid test results (and how many results)?
16000 results, limit to number of rows
What issue caused JP Morgan to lose $6bn
Cell divided by the sum of two interest rates, rather than the average
What issue resulted in the names of Genes being changed?
Excel incorrectly assumed the names were dates
Outrage for what product was mistakenly directed to Excel in India in 2022
Surf Excel (a detergent)
What error does Excel return for large results of MODulo functiuon?
“#NUM!”
What year ranges does Excel support?
1900-9999
Who described who as an excel spreadsheet come to life
Trevor Noah (Daily Show host) dug into Mick Mulvaney, Trump’s Chief of Staff
Powerpoint, Office and Word were described as what on Peep show
The three amigos
What product did Excel replace?
Multiplan
the set of coordinates where a cell is located
Cell reference
a combination of two or more tables with data and values linked and related to one another
Table Array
Functions such as AND, OR, XOR, NOT, NAND, NOR and XNOR are what type
Logical Functions
Microsoft OS used by Multiplan
MS-DOS (Microsoft Disk Operating System)
a code that performs multiple calculations simultaneously
Array Formula
Category of functions that have been replaced with new functions that provide improved accuracy and have names that better reflect their usage
Compatibility functions
Who developed lotusnotes
IBM
Category of functions starting with D (e.g. DAVERAGE, DCOUNT, DGET, DSUM)
Database functions
Category of functions including DAY, MINUTE, MONTH, DATE, WEEKDAY
Date and Time functions
Category of functions including BESELLI, COMPLEX, CONVERT, BIN2OCT, DELTA
Engineering functions
Category of functions including DISC, DURATION, EFFECT, FV, IRR
Financial functions
Category of functions including CELL, ISBLANK, NA
Information functions
Category of functions including ADDRESS, COLUMN, FILTER
Lookup and Reference functions
Category of functions including ABS, CEILING, COS, EVEN, SUM
Math and Trigonometry functions
Category of functions including AVERAGE, COUNT, FORECAST, MIN
Statistical functions
Category of functions including CONCATENATE, CLEAN, CHAR
Text functions
Category of functions including CALL, EUROCONVERT
User defined functions
Category of functions including ENCODEURL
Web functions
What tab is conditional formatting found on
Home tab
What tab are tables, charts etc on
Insert
What tab are page setup, arrange on
Page layout
What tab are function library, names, calculation on
Formulas
What tab is sort and filter, group on
Data
What tab are comments, protect on
Review
What would you use to show or hide gridlines
View tab
What function would I use to return one value if a condition is true and another if the condition is false
IF function
What function would I use when I need to look in a single row and column and find a value from the same position in a second row or column
LOOKUP function
What function would I use to find things in a table or range by row
VLOOKUP function
What function would I use to search for an item in a range of cells, then return the relative position of that item in the range
MATCH function
What function would I use to select a value based in the index number
CHOOSE function
What function would I use to return the serial number of a particular date
DATE function
What function would I use to return the number of days between two dates
DAYS function
What function would I use to locate a text string within a second text string
FIND or FINDB function
What function would I use to return a value or reference to a value from within a table or range
INDEX function
Error received when formula, which divides two values and the divisor (the number being divided by) is zero.
’ #DIV/0!
This error means “no value available” or “not available.” It indicates that the formula cannot find the value that we suppose it may return.
– #N/A Error
This error is displayed when we misspell a function name
– #NAME?
This error is displayed when cell references are not specified correctly
– #NULL! Error
This error is usually displayed when a number for any function argument is found invalid.
– #NUM! Error
Error when a reference cell in a formula is deleted
- # REF!
This error comes when we use the wrong data type for a function or formula
- # VALUE!
Total number of characters a cell can display
1024
total number of characters a cell can contain
32,767
Maximum length of a formula
8,192
What are the three wildcard characters in searches?
?, *, ~
Who are the four founders of Excel?
Charles Simonyi; Doug Klunder; Bill Gates; Jabe Blumenthal
Why is it called Excel?
to give impression of ‘It can do everything Lotus 123 does, but exceptionally better’
What is the trophy of the financial modelling world championship
Keyboard missing an F1 key
Shortcut to Enter the current date.
Ctrl + ;
Shortcut to select an entire column
Ctrl + Space
Shortcut to select an entire column
Shift + Space
Shortcut to Automatically insert the SUM() function
ALT + =
Shortcut to Autosize columns
ALT + H + O + I
Shortcut to display formulas
CTRL + ` (Backtick)
Paste Special Shortcut
Control + Alt + V
What is the ribbon order on first open
File
Home
Insert
Draw
Page Layout
Formulas
Data
Review
View
Help
Why can you not name a worksheet “History”
It’s a reserved name
What other names were considered for Excel
Mr Spreadsheet, Master plan
Internal MS codename
Odyssey
First ever desktop application of what feature
toolbar
How many times can you press undo
100
How much is excel worth
$684b
