Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Excel > Excel > Flashcards

Excel Flashcards

1
Q

Initial windows release date

A

19 November 1987

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Language written in

A

C++

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

License Type

A

Trialware

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Initial release date (Mac)

A

30 September 1985

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What does VBA stand for

A

Visual Basic for Applications

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

The introduction of what function made Excel Turing Complete

A

LAMBDA

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

How many functions are in Excel 2016

A

484

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

How many categories of function

A

14

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What object does VBA use to recall functions

A

Worksheetfunction

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What windows are included in VisualBasic Editor

A

Writing code, debugging code, code module organisation environment

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

A common easy way to generate VBA code

A

Macro Recorder

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

VBA code interacts with the spreadsheet using what model

A

Object Model

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What was the default macro Language through Excel 4.0

A

XLM

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Tool for optimisation and equation solving

A

Solver

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

How many rows can the current version of excel handle

A

2^20 (1 048 576) rows

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

How many columns can the current version of excel handle, and how is it labelled

A

2^14 (16 384) columns - XFD

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What year was xlsx added?

A

2007

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Excel Workbook file format

A

xlsx

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Macro enabled workbook file format

A

xlsm

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Binary workbook file format

A

xlsb

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

macro enabled template file format

A

xltm

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

add-in file dormat

A

xlam

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

how did Microsoft publications refer to Dynamic Data Exchange?

A

the protocol from hell

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

what does DDE stand for

A

Dynamic data exchange

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

What are the five types of password protection?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

What is the standard password for document encryption

A

VelvetSweatshop

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

What year did Excel mobile launch?

A

2015

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

how many figures of precision does Excel maintain in computations?

A

15

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

How many figures can Excel display?

A

30

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

Fictional date

A

29 Feb 1900

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

First date in date range

A

December 31 1899 (0)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

Name of originally marketed Microsoft spreadsheet program

A

Multiplan

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

Lotus competitor

A

Lotus 1-2-3 / LotusNotes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

GUI definition

A

Graphical User Interface

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

First version available on Windows and date

A

2.0, 19 nov 1987

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

Excel 4.0 easter egg

A

animation of dancing 1-2-3, crushed by an excel logo

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

Introduction of VBA -excel version

A

5.0

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

Missing version numbers

A

6.0 and 13

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

Easter egg game in excel 95

A

Doom - The Hall of Tortured souls

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q

Easter egg game in excel 97

A

Flight simulator

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q

Easter egg game in Excel 2000

A

Dev Hunter

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
42
Q

Introduction of paper clip office assistant

A

Excel 97

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
43
Q

Year/edition of New ribbon interface

A

Excel 2007

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
44
Q

name for a system able to recognize or decide other data-manipulation rule sets

A

Turing Complete / computationally universal

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
45
Q

Name of person who developed first analytical engine and when

A

Charles Babbage (1830s)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
46
Q

First electronic spreadsheet on a mainframe

A

LANPAR

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
47
Q

First electronic spreadsheet on a microcomputer

A

VisiCalc

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
48
Q

Google equivalent

A

Google Sheets

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
49
Q

Apple equivalent

A

Numbers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
50
Q

Term for contiguous group of cells

A

Range

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
51
Q

what function is missing from a spreadsheet that is required for a database

A

relational structure

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
52
Q

a system in which editing software allows content to be edited in a form that resembles its appearance

A

What You See Is What You Get

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
53
Q

Apache alternative

A

Openoffice Calc

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
54
Q

Gnu Equivanent

A

Gnumeric

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
55
Q

LANPAR definition

A

LANguage for Programming Arrays at Random

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
56
Q

What syntax is used to direct to a different sheet

A

!

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
57
Q

What is a circular reference

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
58
Q

what expressions can a cell contain (5)

A

values, references, relational operators, arithmetic operators, functions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
59
Q

syntax for absolute references

A

$

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
60
Q

Format for unstructured data

A

CSV (comma separated values)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
61
Q

What is a table of grouped values that aggregates the individual items

A

Pivot table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
62
Q

How does excel round 0.5

A

up

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
63
Q

How many stages in the Financial Modelling world cup

A

8

64
Q

Which function would you use to add several numeric values?

A

Sum

65
Q

What tool shows a formula and its results step-by-step.

A

Evaluate Formula” tool

66
Q

What button can you click to automatically add a range of celss

A

autosum

67
Q

Freeze panes tab

A

View

68
Q

name of command line above spreadsheet

A

formula bar

69
Q

Formula automatically capitalising first letter

A

Proper

70
Q

Which feature starts with a desired result, then calculates the input value that will give that result?

A

Goal seek

71
Q

Which option allows you to lock certain rows or columns in place while scrolling through a large worksheet?

A

Freeze Panes

72
Q

How many worksheets open in a new workbook by default

A

3 (old), 1 (new)

73
Q

”######” means

A

The cell is not wide enough

74
Q

Which key do you press to group two or more nonadjacent worksheets?

A

SHIFT

75
Q

What is the default row height of MS Excel?

A

15

76
Q

Greek letter used as sum symbol

A

Sigma

77
Q

Musical artist using Excel to text

A

Kelly Rowland

78
Q

Song and artist where character uses excel to text

A

Dilemma - Nelly ft Kelly Rowland

79
Q

Phone musical artist uses to text

A

Nokia 9210 Communicator

80
Q

Text message in music video

A

Where you at? Holla when you get this

81
Q

Who was being texted in the music video?

A

Nelly

82
Q

What did Kelly Rowland say when asked about texting in Excel?

A

I don’t know what Microsoft Excel is. I don’t have a clue

83
Q

What row do you use to activate Hall of Tortured Souls?

A

95

84
Q

How do you open Flight Sim in excel 97

A
  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
Q

What network broadcasts the excel world championship

A

ESPN

86
Q

Who is the current excel world champion?

A

Laurence Lau

87
Q

What excel issue may have resulted in the loss of covid test results (and how many results)?

A

16000 results, limit to number of rows

88
Q

What issue caused JP Morgan to lose $6bn

A

Cell divided by the sum of two interest rates, rather than the average

89
Q

What issue resulted in the names of Genes being changed?

A

Excel incorrectly assumed the names were dates

90
Q

Outrage for what product was mistakenly directed to Excel in India in 2022

A

Surf Excel (a detergent)

91
Q

What error does Excel return for large results of MODulo functiuon?

A

“#NUM!”

92
Q

What year ranges does Excel support?

A

1900-9999

93
Q

Who described who as an excel spreadsheet come to life

A

Trevor Noah (Daily Show host) dug into Mick Mulvaney, Trump’s Chief of Staff

94
Q

Powerpoint, Office and Word were described as what on Peep show

A

The three amigos

95
Q

What product did Excel replace?

A

Multiplan

96
Q

the set of coordinates where a cell is located

A

Cell reference

97
Q

a combination of two or more tables with data and values linked and related to one another

A

Table Array

98
Q

Functions such as AND, OR, XOR, NOT, NAND, NOR and XNOR are what type

A

Logical Functions

99
Q

Microsoft OS used by Multiplan

A

MS-DOS (Microsoft Disk Operating System)

100
Q

a code that performs multiple calculations simultaneously

A

Array Formula

101
Q

Category of functions that have been replaced with new functions that provide improved accuracy and have names that better reflect their usage

A

Compatibility functions

102
Q

Who developed lotusnotes

A

IBM

103
Q

Category of functions starting with D (e.g. DAVERAGE, DCOUNT, DGET, DSUM)

A

Database functions

104
Q

Category of functions including DAY, MINUTE, MONTH, DATE, WEEKDAY

A

Date and Time functions

105
Q

Category of functions including BESELLI, COMPLEX, CONVERT, BIN2OCT, DELTA

A

Engineering functions

106
Q

Category of functions including DISC, DURATION, EFFECT, FV, IRR

A

Financial functions

107
Q

Category of functions including CELL, ISBLANK, NA

A

Information functions

108
Q

Category of functions including ADDRESS, COLUMN, FILTER

A

Lookup and Reference functions

109
Q

Category of functions including ABS, CEILING, COS, EVEN, SUM

A

Math and Trigonometry functions

110
Q

Category of functions including AVERAGE, COUNT, FORECAST, MIN

A

Statistical functions

111
Q

Category of functions including CONCATENATE, CLEAN, CHAR

A

Text functions

112
Q

Category of functions including CALL, EUROCONVERT

A

User defined functions

113
Q

Category of functions including ENCODEURL

A

Web functions

114
Q

What tab is conditional formatting found on

A

Home tab

115
Q

What tab are tables, charts etc on

A

Insert

116
Q

What tab are page setup, arrange on

A

Page layout

117
Q

What tab are function library, names, calculation on

A

Formulas

118
Q

What tab is sort and filter, group on

A

Data

119
Q

What tab are comments, protect on

A

Review

120
Q

What would you use to show or hide gridlines

A

View tab

121
Q

What function would I use to return one value if a condition is true and another if the condition is false

A

IF function

122
Q

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

A

LOOKUP function

123
Q

What function would I use to find things in a table or range by row

A

VLOOKUP function

124
Q

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

A

MATCH function

125
Q

What function would I use to select a value based in the index number

A

CHOOSE function

126
Q

What function would I use to return the serial number of a particular date

A

DATE function

127
Q

What function would I use to return the number of days between two dates

A

DAYS function

128
Q

What function would I use to locate a text string within a second text string

A

FIND or FINDB function

129
Q

What function would I use to return a value or reference to a value from within a table or range

A

INDEX function

130
Q

Error received when formula, which divides two values and the divisor (the number being divided by) is zero.

A

’ #DIV/0!

131
Q

This error means “no value available” or “not available.” It indicates that the formula cannot find the value that we suppose it may return.

A

– #N/A Error

132
Q

This error is displayed when we misspell a function name

A

– #NAME?

133
Q

This error is displayed when cell references are not specified correctly

A

– #NULL! Error

134
Q

This error is usually displayed when a number for any function argument is found invalid.

A

– #NUM! Error

135
Q

Error when a reference cell in a formula is deleted

A
  • # REF!
136
Q

This error comes when we use the wrong data type for a function or formula

A
  • # VALUE!
137
Q

Total number of characters a cell can display

A

1024

138
Q

total number of characters a cell can contain

A

32,767

139
Q

Maximum length of a formula

A

8,192

140
Q

What are the three wildcard characters in searches?

A

?, *, ~

141
Q

Who are the four founders of Excel?

A

Charles Simonyi; Doug Klunder; Bill Gates; Jabe Blumenthal

142
Q

Why is it called Excel?

A

to give impression of ‘It can do everything Lotus 123 does, but exceptionally better’

143
Q

What is the trophy of the financial modelling world championship

A

Keyboard missing an F1 key

144
Q

Shortcut to Enter the current date.

A

Ctrl + ;

145
Q

Shortcut to select an entire column

A

Ctrl + Space

146
Q

Shortcut to select an entire column

A

Shift + Space

147
Q

Shortcut to Automatically insert the SUM() function

A

ALT + =

148
Q

Shortcut to Autosize columns

A

ALT + H + O + I

149
Q

Shortcut to display formulas

A

CTRL + ` (Backtick)

150
Q

Paste Special Shortcut

A

Control + Alt + V

151
Q

What is the ribbon order on first open

A

File
Home
Insert
Draw
Page Layout
Formulas
Data
Review
View
Help

152
Q

Why can you not name a worksheet “History”

A

It’s a reserved name

153
Q

What other names were considered for Excel

A

Mr Spreadsheet, Master plan

154
Q

Internal MS codename

A

Odyssey

155
Q

First ever desktop application of what feature

A

toolbar

156
Q

How many times can you press undo

A

100

157
Q

How much is excel worth

A

$684b

Excel (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions