Q2: EXCEL

Question 1

when was excel first released

Answer 1

sep 30, 1985

Question 2

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

Answer 2

excel

Question 3

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

Answer 3

excel

Question 4

what was excel’s original name

Answer 4

odyssey

Question 5

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

Answer 5

XLSand XLSXfileformats

Question 6

is a group of cells within a row column.

Answer 6

range

Question 7

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.

Answer 7

formula

Question 8

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

Answer 8

insert function

Question 9

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

Answer 9

function

Question 10

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

Answer 10

argument

Question 11

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.

Answer 11

file tab

Question 12

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.

Answer 12

quick access toolbar

Question 13

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

Answer 13

tabs

Question 14

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

Answer 14

groups

Question 15

appear within each group as mentioned above.

Answer 15

commands

Question 16

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

Answer 16

title bar

Question 17

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.

Answer 17

view buttons

Question 18

This displays the page in normal view.

Answer 18

normal layout view

Question 19

This displays pages exactly as they will appear when printed

Answer 19

page layout view

Question 20

This gives a full screen look of the document.

Answer 20

page layout view

Question 21

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

Answer 21

page break view

Question 22

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.

Answer 22

sheet area

Question 23

maximum row

Answer 23

1,048,576 rows

Question 24

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

Answer 24

row bar

Question 25

maximum columns

Answer 25

16,384 columns

Question 26

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

Answer 26

column bar

Question 27

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

Answer 27

status bar

Question 28

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

Answer 28

dialog box launcher

Question 29

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

Answer 29

dialog box launcher

Question 30

adds all the numbers in a range of cells.

Answer 30

sum

Question 31

multiplies all the numbers given as arguments.

Answer 31

product

Question 32

returns the integer portion of a division.

Answer 32

quotient

Question 33

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

Answer 33

rank

Question 34

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

Answer 34

median

Question 35

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

Answer 35

mode

Question 36

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

Answer 36

average

Question 37

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

Answer 37

if

Question 38

returns the logical value TRUE

Answer 38

true

Question 39

joins several text strings into one text string.

Answer 39

concatenate

Question 40

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

Answer 40

mean

Question 41

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

Answer 41

mode.mult

Question 42

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.

Answer 42

rank.abg