Excel Flashcards
(157 cards)
1
Q
Initial windows release date
A
19 November 1987
2
Q
Language written in
A
C++
3
Q
License Type
A
Trialware
4
Q
Initial release date (Mac)
A
30 September 1985
5
Q
What does VBA stand for
A
Visual Basic for Applications
6
Q
The introduction of what function made Excel Turing Complete
A
LAMBDA
7
Q
How many functions are in Excel 2016
A
484
8
Q
How many categories of function
A
14
9
Q
What object does VBA use to recall functions
A
Worksheetfunction
10
Q
What windows are included in VisualBasic Editor
A
Writing code, debugging code, code module organisation environment
11
Q
A common easy way to generate VBA code
A
Macro Recorder
12
Q
VBA code interacts with the spreadsheet using what model
A
Object Model
13
Q
What was the default macro Language through Excel 4.0
A
XLM
14
Q
Tool for optimisation and equation solving
A
Solver
15
Q
How many rows can the current version of excel handle
A
2^20 (1 048 576) rows
16
Q
How many columns can the current version of excel handle, and how is it labelled
A
2^14 (16 384) columns - XFD
17
Q
What year was xlsx added?
A
2007
18
Q
Excel Workbook file format
A
xlsx
19
Q
Macro enabled workbook file format
A
xlsm
20
Q
Binary workbook file format
A
xlsb
21
Q
macro enabled template file format
A
xltm
22
Q
add-in file dormat
A
xlam
23
Q
how did Microsoft publications refer to Dynamic Data Exchange?
A
the protocol from hell
24
Q
what does DDE stand for
A
Dynamic data exchange
25
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
26
What is the standard password for document encryption
VelvetSweatshop
27
What year did Excel mobile launch?
2015
28
how many figures of precision does Excel maintain in computations?
15
29
How many figures can Excel display?
30
30
Fictional date
29 Feb 1900
31
First date in date range
December 31 1899 (0)
32
Name of originally marketed Microsoft spreadsheet program
Multiplan
33
Lotus competitor
Lotus 1-2-3 / LotusNotes
34
GUI definition
Graphical User Interface
35
First version available on Windows and date
2.0, 19 nov 1987
36
Excel 4.0 easter egg
animation of dancing 1-2-3, crushed by an excel logo
37
Introduction of VBA -excel version
5.0
38
Missing version numbers
6.0 and 13
39
Easter egg game in excel 95
Doom - The Hall of Tortured souls
40
Easter egg game in excel 97
Flight simulator
41
Easter egg game in Excel 2000
Dev Hunter
42
Introduction of paper clip office assistant
Excel 97
43
Year/edition of New ribbon interface
Excel 2007
44
name for a system able to recognize or decide other data-manipulation rule sets
Turing Complete / computationally universal
45
Name of person who developed first analytical engine and when
Charles Babbage (1830s)
46
First electronic spreadsheet on a mainframe
LANPAR
47
First electronic spreadsheet on a microcomputer
VisiCalc
48
Google equivalent
Google Sheets
49
Apple equivalent
Numbers
50
Term for contiguous group of cells
Range
51
what function is missing from a spreadsheet that is required for a database
relational structure
52
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
53
Apache alternative
Openoffice Calc
54
Gnu Equivanent
Gnumeric
55
LANPAR definition
LANguage for Programming Arrays at Random
56
What syntax is used to direct to a different sheet
!
57
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
58
what expressions can a cell contain (5)
values, references, relational operators, arithmetic operators, functions
59
syntax for absolute references
$
60
Format for unstructured data
CSV (comma separated values)
61
What is a table of grouped values that aggregates the individual items
Pivot table
62
How does excel round 0.5
up
63
How many stages in the Financial Modelling world cup
8
64
Which function would you use to add several numeric values?
Sum
65
What tool shows a formula and its results step-by-step.
Evaluate Formula" tool
66
What button can you click to automatically add a range of celss
autosum
67
Freeze panes tab
View
68
name of command line above spreadsheet
formula bar
69
Formula automatically capitalising first letter
Proper
70
Which feature starts with a desired result, then calculates the input value that will give that result?
Goal seek
71
Which option allows you to lock certain rows or columns in place while scrolling through a large worksheet?
Freeze Panes
72
How many worksheets open in a new workbook by default
3 (old), 1 (new)
73
"######" means
The cell is not wide enough
74
Which key do you press to group two or more nonadjacent worksheets?
SHIFT
75
What is the default row height of MS Excel?
15
76
Greek letter used as sum symbol
Sigma
77
Musical artist using Excel to text
Kelly Rowland
78
Song and artist where character uses excel to text
Dilemma - Nelly ft Kelly Rowland
79
Phone musical artist uses to text
Nokia 9210 Communicator
80
Text message in music video
Where you at? Holla when you get this
81
Who was being texted in the music video?
Nelly
82
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
83
What row do you use to activate Hall of Tortured Souls?
95
84
How do you open Flight Sim in excel 97
1. On a new Worksheet, Press F5
2. Type X97:L97 and hit enter
3. Press the tab key
4. Hold Ctrl-Shift
5. Click on the Chart Wizard toolbar button
85
What network broadcasts the excel world championship
ESPN
86
Who is the current excel world champion?
Laurence Lau
87
What excel issue may have resulted in the loss of covid test results (and how many results)?
16000 results, limit to number of rows
88
What issue caused JP Morgan to lose $6bn
Cell divided by the sum of two interest rates, rather than the average
89
What issue resulted in the names of Genes being changed?
Excel incorrectly assumed the names were dates
90
Outrage for what product was mistakenly directed to Excel in India in 2022
Surf Excel (a detergent)
91
What error does Excel return for large results of MODulo functiuon?
"#NUM!"
92
What year ranges does Excel support?
1900-9999
93
Who described who as an excel spreadsheet come to life
Trevor Noah (Daily Show host) dug into Mick Mulvaney, Trump’s Chief of Staff
94
Powerpoint, Office and Word were described as what on Peep show
The three amigos
95
What product did Excel replace?
Multiplan
96
the set of coordinates where a cell is located
Cell reference
97
a combination of two or more tables with data and values linked and related to one another
Table Array
98
Functions such as AND, OR, XOR, NOT, NAND, NOR and XNOR are what type
Logical Functions
99
Microsoft OS used by Multiplan
MS-DOS (Microsoft Disk Operating System)
100
a code that performs multiple calculations simultaneously
Array Formula
101
Category of functions that have been replaced with new functions that provide improved accuracy and have names that better reflect their usage
Compatibility functions
102
Who developed lotusnotes
IBM
103
Category of functions starting with D (e.g. DAVERAGE, DCOUNT, DGET, DSUM)
Database functions
104
Category of functions including DAY, MINUTE, MONTH, DATE, WEEKDAY
Date and Time functions
105
Category of functions including BESELLI, COMPLEX, CONVERT, BIN2OCT, DELTA
Engineering functions
106
Category of functions including DISC, DURATION, EFFECT, FV, IRR
Financial functions
107
Category of functions including CELL, ISBLANK, NA
Information functions
108
Category of functions including ADDRESS, COLUMN, FILTER
Lookup and Reference functions
109
Category of functions including ABS, CEILING, COS, EVEN, SUM
Math and Trigonometry functions
110
Category of functions including AVERAGE, COUNT, FORECAST, MIN
Statistical functions
111
Category of functions including CONCATENATE, CLEAN, CHAR
Text functions
112
Category of functions including CALL, EUROCONVERT
User defined functions
113
Category of functions including ENCODEURL
Web functions
114
What tab is conditional formatting found on
Home tab
115
What tab are tables, charts etc on
Insert
116
What tab are page setup, arrange on
Page layout
117
What tab are function library, names, calculation on
Formulas
118
What tab is sort and filter, group on
Data
119
What tab are comments, protect on
Review
120
What would you use to show or hide gridlines
View tab
121
What function would I use to return one value if a condition is true and another if the condition is false
IF function
122
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
123
What function would I use to find things in a table or range by row
VLOOKUP function
124
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
125
What function would I use to select a value based in the index number
CHOOSE function
126
What function would I use to return the serial number of a particular date
DATE function
127
What function would I use to return the number of days between two dates
DAYS function
128
What function would I use to locate a text string within a second text string
FIND or FINDB function
129
What function would I use to return a value or reference to a value from within a table or range
INDEX function
130
Error received when formula, which divides two values and the divisor (the number being divided by) is zero.
' #DIV/0!
131
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
132
This error is displayed when we misspell a function name
– #NAME?
133
This error is displayed when cell references are not specified correctly
– #NULL! Error
134
This error is usually displayed when a number for any function argument is found invalid.
– #NUM! Error
135
Error when a reference cell in a formula is deleted
- #REF!
136
This error comes when we use the wrong data type for a function or formula
- #VALUE!
137
Total number of characters a cell can display
1024
138
total number of characters a cell can contain
32,767
139
Maximum length of a formula
8,192
140
What are the three wildcard characters in searches?
?, *, ~
141
Who are the four founders of Excel?
Charles Simonyi; Doug Klunder; Bill Gates; Jabe Blumenthal
142
Why is it called Excel?
to give impression of 'It can do everything Lotus 123 does, but exceptionally better'
143
What is the trophy of the financial modelling world championship
Keyboard missing an F1 key
144
Shortcut to Enter the current date.
Ctrl + ;
145
Shortcut to select an entire column
Ctrl + Space
146
Shortcut to select an entire column
Shift + Space
147
Shortcut to Automatically insert the SUM() function
ALT + =
148
Shortcut to Autosize columns
ALT + H + O + I
149
Shortcut to display formulas
CTRL + ` (Backtick)
150
Paste Special Shortcut
Control + Alt + V
151
What is the ribbon order on first open
File
Home
Insert
Draw
Page Layout
Formulas
Data
Review
View
Help
152
Why can you not name a worksheet "History"
It's a reserved name
153
What other names were considered for Excel
Mr Spreadsheet, Master plan
154
Internal MS codename
Odyssey
155
First ever desktop application of what feature
toolbar
156
How many times can you press undo
100
157
How much is excel worth
$684b
