excel 1

Pratyasha Acharya · 15問 · 1年前

通報

問題一覧

How many users can open Excel file at same time

256

Excel was introduced in the year

1985

Founder of MS Excel

Charles simonyi

What is the default height of row

Maximum height of row

409 points

Alphabetical letters

columns

Numbers

rows

Workbook is a

collection of worksheets and chart

Excel files are called

workbook

Create a new workbook

ctrl+n

Create a new worksheet

shift +f11

To check formula and cell range/active formula

To know MS Excel version

file>help> check version now

To open run dialog box

win+R

To copy the value from the cell above the active cell into the cell

ctrl+shift+"

Wrap text feature in MS Excel 2019

home

Cell address is represented as

A25

First cell in excel labeled as

Last column of an Excel 2003 worksheet is

IV (256 Columns)

Last column of an Excel 2007 worksheet is

XFD(16384 columns)

Rows in ms Excel 2003

65536

Columns in 2003

256

Rows in ms Excel 2007

10,48,576

Columns in excel 2007

16,384

Shortcut to create names from the row or columns labels for the selected cell

ctrl+shift+ f3

Extension of MS Excel file

.xls

Keyboard shortcut to navigate between different worksheet

ctrl+page up

By default MS Excel display sheet?

Shortcut to create chart in MS Excel

f11

The component the displays the contents of an active cell

formula bar

The component of MS Excel displace the address of the active cell

name box

To select the entire row of the active cell

shift+space bar

To select the entire column

ctrl+space bar

Cell boundary that specifies which cell active

cell pointer

The graphical and pictorial representation of worksheet data

charts

To insert new worksheet

alt+shift +f1

Macros are executed from the

view menu

Comments put in cells are called

cell tip

Concatenation of text can be done using

Rearrange the data in ascending or descending order

data,sort

To enter the current time in a worksheet

ctrl+shift+;

Enter the current date in a worksheet

ctrl+;

Default view for a worksheet

normal view

To move up previous worksheet

ctrl+pg up

To access the go to dialogue box

ctrl+G

To close the workbook

ctrl+W

To close Excel/close the selected workbook window

ctrl+ F4

Command from run window to open a new XL file

excel

Total number of characters that are cell can contain

32767

Not a function in MS Excel

avg

Close the window of Excel/close all work books that are open as well as Excel itself

alt+f4

Used to describe information in your spreadsheet

label

What returns the current date formatted as a date

today()

What returns the current time formatted as a time

now()

To convert existing Excel worksheet data and charge to HTML documents by using the

internet assistant wizard

Maximum zoom percentage in Excel

400

Minimum zoom percentage

Default zoom Percentage

100

V look up function used to

find related records

To edit the selected cell

To create macros in Excel

visual basic

Maximum column with in MS Excel

255

Default column width in MS Excel

8.43

Popular DOS based spredsheet package

lotus 123

Files created with Lotus 123 have an extension

.123

Oldest spredsheet package

visicalc

Greater than sign is an example of

logical operator

Ctrl+ D used to

to fill down in the selection

Create pivot chart

Create chart

f11

Expand or collapse formula bar

ctrl+shift+u

Insert auto sum formula

alt+=

Show or hide all formula

ctrl+~

Apply the time format

ctrl+shift+@

Display the control menu

alt+space bar

To hide selected columns

ctrl+0

To hide selected rows

ctrl+9

To go to the last cell

ctrl+end

To go to the first cell

ctrl+home

Left one cell

shift+tab

Right one cell

tab

Create an absolute

Calculate worksheet

Go to dialogue box

all

Strikethrough

ctrl+s

How many tabs are in Excel

Default tab in MS Excel

home

Twin tower New comment in a cell

shift+f2

Insert auto sum formula

alt+=

Show all hide all formula

ctrl+~

To apply the date format

ctrl+shift+#

To apply the percentile format without decimal

ctrl+shift+%

Start a new line in the same cell

alt+enter

Extend the selection of the cell

ctrl+shift+home

Create pivtot Chart in the same worksheet

alt+f1

To bring up search box

shift+f5

While selecting multiple worksheets in excel what key must be used when clicking the sheet tag

ctrl

Open workbooks can be switched using

ctrl+tab

Excel file cannot be directly exported as

ppt

100

Work space mean

group of workbooks

maths formula

maths formula

15問 • 1年前

Pratyasha Acharya · 77問 · 1年前

imp CA jan (lisha)

imp CA jan (lisha)

77問 • 1年前

Pratyasha Acharya · 88問 · 1年前

feb CA

feb CA

88問 • 1年前

Pratyasha Acharya · 39問 · 1年前

international ca

international ca

39問 • 1年前

Pratyasha Acharya · 16問 · 1年前

summits

summits

16問 • 1年前

Pratyasha Acharya · 30問 · 1年前

defence

defence

30問 • 1年前

Pratyasha Acharya · 65問 · 1年前

orbituaries

orbituaries

65問 • 1年前

Pratyasha Acharya · 99問 · 1年前

awards and honours 1

awards and honours 1

99問 • 1年前

Pratyasha Acharya · 37問 · 1年前

awards and honours 2

awards and honours 2

37問 • 1年前

Pratyasha Acharya · 8問 · 1年前

UT lok sabha seats

UT lok sabha seats

8問 • 1年前

Pratyasha Acharya · 38問 · 1年前

states lok sabha seats

states lok sabha seats

38問 • 1年前

Pratyasha Acharya · 75問 · 1年前

modi cabinet

modi cabinet

75問 • 1年前

Pratyasha Acharya · 36問 · 1年前

odisha cabinet

odisha cabinet

36問 • 1年前

Pratyasha Acharya · 21問 · 2年前

books and authors 2023

books and authors 2023

21問 • 2年前

Pratyasha Acharya · 20問 · 1年前

CM and governor

CM and governor

20問 • 1年前

april 1

april 1

April 2

April 2

Pratyasha Acharya · 41問 · 1年前

agriculture revolution

agriculture revolution

41問 • 1年前

Pratyasha Acharya · 42問 · 1年前

april 3

april 3

42問 • 1年前

Pratyasha Acharya · 64問 · 1年前

5 yr plans

5 yr plans

64問 • 1年前

June 1

June 1

Pratyasha Acharya · 12問 · 1年前

border name

border name

12問 • 1年前

Pratyasha Acharya · 99問 · 1年前

pm and president

pm and president

99問 • 1年前

Pratyasha Acharya · 87問 · 1年前

imp organisation

imp organisation

87問 • 1年前

june 2

june 2

June 3

June 3

LISA odisha rivers

LISA odisha rivers

Pratyasha Acharya · 53問 · 1年前

wars and treaties

wars and treaties

53問 • 1年前

Pratyasha Acharya · 63問 · 1年前

odisha rivers 2

odisha rivers 2

63問 • 1年前

Pratyasha Acharya · 13問 · 1年前

june 4

june 4

13問 • 1年前

Pratyasha Acharya · 25問 · 1年前

wars 2

wars 2

25問 • 1年前

July 1

July 1

Pratyasha Acharya · 30問 · 1年前

lakes of odisha

lakes of odisha

30問 • 1年前

wildlife sanctuaries 1

wildlife sanctuaries 1

July 2

July 2

Pratyasha Acharya · 66問 · 1年前

gov gen of Bengal (lisha)

gov gen of Bengal (lisha)

66問 • 1年前

Pratyasha Acharya · 88問 · 1年前

paris olympics

paris olympics

88問 • 1年前

July 3

July 3

Pratyasha Acharya · 53問 · 1年前

governor general of India

governor general of India

53問 • 1年前

important appointment

important appointment

viceroys

viceroys

Pratyasha Acharya · 30問 · 1年前

Paris paralympics 2024

Paris paralympics 2024

30問 • 1年前

Pratyasha Acharya · 93問 · 1年前

index 2024

index 2024

93問 • 1年前

Pratyasha Acharya · 48問 · 1年前

straits and canals

straits and canals

48問 • 1年前

Pratyasha Acharya · 91問 · 1年前

medeival hist(Arab invasion)

medeival hist(Arab invasion)

91問 • 1年前

sports 1

sports 1

Pratyasha Acharya · 89問 · 1年前

solar system

solar system

89問 • 1年前

Pratyasha Acharya · 62問 · 1年前

2024 T20 world cup

2024 T20 world cup

62問 • 1年前

social and cultural movement 1

social and cultural movement 1

Pratyasha Acharya · 38問 · 1年前

ICC odi men's cricket 2023

ICC odi men's cricket 2023

38問 • 1年前

Pratyasha Acharya · 24問 · 1年前

nicknames of river

nicknames of river

24問 • 1年前

Pratyasha Acharya · 86問 · 1年前

social and cultural movement 2

social and cultural movement 2

86問 • 1年前

Pratyasha Acharya · 91問 · 1年前

sports 2

sports 2

91問 • 1年前

Pratyasha Acharya · 74問 · 1年前

sports host countries

sports host countries

74問 • 1年前

Pratyasha Acharya · 76問 · 1年前

sources of medieval history

sources of medieval history

76問 • 1年前

mountains

mountains

physiography division of India

physiography division of India

August 1

August 1

Pratyasha Acharya · 71問 · 1年前

mamluk dynasty

mamluk dynasty

71問 • 1年前

aug 2

aug 2

Pratyasha Acharya · 53問 · 1年前

khilji dynasty

khilji dynasty

53問 • 1年前

Pratyasha Acharya · 87問 · 1年前

India's neighbouring countries

India's neighbouring countries

87問 • 1年前

Pratyasha Acharya · 38問 · 1年前

tughluq dynasty

tughluq dynasty

38問 • 1年前

Pratyasha Acharya · 28問 · 1年前

aug 3

aug 3

28問 • 1年前

Pratyasha Acharya · 67問 · 1年前

latitude and longitude

latitude and longitude

67問 • 1年前

Pratyasha Acharya · 23問 · 1年前

sayyid and lodhi dynasty

sayyid and lodhi dynasty

23問 • 1年前

Pratyasha Acharya · 84問 · 1年前

comp networking

comp networking

84問 • 1年前

odisha 1

odisha 1

Pratyasha Acharya · 81問 · 1年前

mughal empire

mughal empire

81問 • 1年前

Pratyasha Acharya · 88問 · 1年前

odisha2

odisha2

88問 • 1年前

Pratyasha Acharya · 54問 · 1年前

CPU

CPU

54問 • 1年前

sept 1

sept 1

sept 2

sept 2

sept 3

sept 3

Pratyasha Acharya · 85問 · 1年前

sept 4

sept 4

85問 • 1年前

Pratyasha Acharya · 99問 · 1年前

facts 1

facts 1

99問 • 1年前

oct 1

oct 1

oct 2

oct 2

oct 3

oct 3

Pratyasha Acharya · 49問 · 1年前

days

days

49問 • 1年前

Pratyasha Acharya · 82問 · 1年前

OSI

OSI

82問 • 1年前

nov 1

nov 1

nov 2

nov 2

nov 3

nov 3

Pratyasha Acharya · 96問 · 1年前

dance forms

dance forms

96問 • 1年前

Pratyasha Acharya · 39問 · 1年前

odisha hist

odisha hist

39問 • 1年前

Pratyasha Acharya · 68問 · 1年前

ppt

ppt

68問 • 1年前

Pratyasha Acharya · 23問 · 1年前

fairs and festivals of Odisha

fairs and festivals of Odisha

23問 • 1年前

Pratyasha Acharya · 44問 · 1年前

44問 • 1年前

Pratyasha Acharya · 43問 · 1年前

Ms windows

Ms windows

43問 • 1年前

Pratyasha Acharya · 86問 · 1年前

generation of computer

generation of computer

86問 • 1年前

Pratyasha Acharya · 32問 · 1年前

mensuration

mensuration

32問 • 1年前