Brainscape's Knowledge GenomeTM

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


See full index

11: 1st SEM | EMPTECH > Q2: EXCEL > Flashcards

Q2: EXCEL Flashcards

1
Q

when was excel first released

A

sep 30, 1985

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

is a software program produced by Microsoft that allows users to organize, format and calculate data with formulas using a spreadsheet system.

A

excel

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

is aspreadsheet application developed and published by Microsoft. It is part of theMicrosoft Officesuite of productivity software.

A

excel

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

what was excel’s original name

A

odyssey

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

contain all the information from the worksheets in a workbook, including formatting, formulas, and etc.

A

XLSand XLSXfileformats

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

is a group of cells within a row column.

A

range

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

an expression telling the computer what mathematical operation to perform upon a specific value and allow to quickly make calculations and get totals of multiple cells, rows, or columns in a spreadsheet.

A

formula

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

work with formula in the current cell. Easily pick functions to use and get help on how to fill out the input values.

A

insert function

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

s a predefined formula that performs calculations using specific values in a particular order.

A

function

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

can be a range of data, a specified output, or other parameters, depending on the particular function.

A

argument

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

You can click it to check the Backstage view, where you come to open or save files, create new sheets, print a sheet, and do other file-related operations.

A

file tab

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

You will find this toolbar just above the File tab and its purpose is to provide a convenient resting place for the Excel’s most frequently used commands. You can customize this toolbar based on your comfort.

A

quick access toolbar

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

They appear across the top of the Ribbon and contain groups of related commands. Home, Insert, Page Layout are the examples of ribbon tabs.

A

tabs

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

They organize related commands; each group name appears below the group on the Ribbon.

A

groups

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

appear within each group as mentioned above.

A

commands

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

This lies in the middle and at the top of the window.

A

title bar

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

The group of three buttons located to the left of the Zoom control, near the bottom of the screen, lets you switch among excel’s various sheet views.

A

view buttons

18
Q

This displays the page in normal view.

A

normal layout view

19
Q

This displays pages exactly as they will appear when printed

A

page layout view

20
Q

This gives a full screen look of the document.

A

page layout view

21
Q

This shows a preview of where pages will break when printed.

A

page break view

22
Q

The area where you enter data. The flashing vertical bar is called the insertion point and it represents the location where text will appear when you type.

A

sheet area

23
Q

maximum row

A

1,048,576 rows

24
Q

Rows are numbered from 1 onwards and keeps on increasing as you keep entering data.

A

row bar

25
Q

maximum columns

A

16,384 columns

26
Q

Columns are numbered from A onwards and keeps on increasing as you keep entering data.

A

column bar

27
Q

You can configure the status bar by right-clicking anywhere on it and by selecting or deselecting options from the provided list.

A

status bar

28
Q

This appears as a very small arrow in the lower-right corner of many groups on the Ribbon.

A

dialog box launcher

29
Q

Clicking this button opens a dialog box or task pane that provides more options about the group.

A

dialog box launcher

30
Q

adds all the numbers in a range of cells.

A

sum

31
Q

multiplies all the numbers given as arguments.

A

product

32
Q

returns the integer portion of a division.

A

quotient

33
Q

returns the rank of a number in a list of numbers: its size relative to other values in the list.

A

rank

34
Q

returns the median, or the number in the middle of the set of given numbers.

A

median

35
Q

returns the most frequently occurring, or repetitive value or range of data.

A

mode

36
Q

returns the average (arithmetic mean) of its arguments, which can be numbers or references that contain numbers.

A

average

37
Q

checks whether a condition is met and returns one value if TRUE, and another value if FALSE.

A

if

38
Q

returns the logical value TRUE

A

true

39
Q

joins several text strings into one text string.

A

concatenate

40
Q

returns the average (arithmetic mean) of its arguments, which can be number or references that contain numbers.

A

mean

41
Q

returns a vertical of the most frequently occurring or repetitive values in range of data.

A

mode.mult

42
Q

returns the rank of a number in a list of numbers: its size relative to other values in the list; if more than one value has the same rank, the average rank is returned.

A

rank.abg

11: 1st SEM | EMPTECH (13 decks)

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