暗記メーカー

お問い合わせ
ログイン
excel 1
  • Pratyasha Acharya

  • 問題数 100 • 10/17/2024

    問題一覧

  • 1

    How many users can open Excel file at same time

    256

  • 2

    Excel was introduced in the year

    1985

  • 3

    Founder of MS Excel

    Charles simonyi

  • 4

    What is the default height of row

    15

  • 5

    Maximum height of row

    409 points

  • 6

    Alphabetical letters

    columns

  • 7

    Numbers

    rows

  • 8

    Workbook is a

    collection of worksheets and chart

  • 9

    Excel files are called

    workbook

  • 10

    Create a new workbook

    ctrl+n

  • 11

    Create a new worksheet

    shift +f11

  • 12

    To check formula and cell range/active formula

    f2

  • 13

    To know MS Excel version

    file>help> check version now

  • 14

    To open run dialog box

    win+R

  • 15

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

    ctrl+shift+"

  • 16

    Wrap text feature in MS Excel 2019

    home

  • 17

    Cell address is represented as

    A25

  • 18

    First cell in excel labeled as

    A1

  • 19

    Last column of an Excel 2003 worksheet is

    IV (256 Columns)

  • 20

    Last column of an Excel 2007 worksheet is

    XFD(16384 columns)

  • 21

    Rows in ms Excel 2003

    65536

  • 22

    Columns in 2003

    256

  • 23

    Rows in ms Excel 2007

    10,48,576

  • 24

    Columns in excel 2007

    16,384

  • 25

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

    ctrl+shift+ f3

  • 26

    Extension of MS Excel file

    .xls

  • 27

    Keyboard shortcut to navigate between different worksheet

    ctrl+page up

  • 28

    By default MS Excel display sheet?

    3

  • 29

    Shortcut to create chart in MS Excel

    f11

  • 30

    The component the displays the contents of an active cell

    formula bar

  • 31

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

    name box

  • 32

    To select the entire row of the active cell

    shift+space bar

  • 33

    To select the entire column

    ctrl+space bar

  • 34

    Cell boundary that specifies which cell active

    cell pointer

  • 35

    The graphical and pictorial representation of worksheet data

    charts

  • 36

    To insert new worksheet

    alt+shift +f1

  • 37

    Macros are executed from the

    view menu

  • 38

    Comments put in cells are called

    cell tip

  • 39

    Concatenation of text can be done using

    &

  • 40

    Rearrange the data in ascending or descending order

    data,sort

  • 41

    To enter the current time in a worksheet

    ctrl+shift+;

  • 42

    Enter the current date in a worksheet

    ctrl+;

  • 43

    Default view for a worksheet

    normal view

  • 44

    To move up previous worksheet

    ctrl+pg up

  • 45

    To access the go to dialogue box

    ctrl+G

  • 46

    To close the workbook

    ctrl+W

  • 47

    To close Excel/close the selected workbook window

    ctrl+ F4

  • 48

    Command from run window to open a new XL file

    excel

  • 49

    Total number of characters that are cell can contain

    32767

  • 50

    Not a function in MS Excel

    avg

  • 51

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

    alt+f4

  • 52

    Used to describe information in your spreadsheet

    label

  • 53

    What returns the current date formatted as a date

    today()

  • 54

    What returns the current time formatted as a time

    now()

  • 55

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

    internet assistant wizard

  • 56

    Maximum zoom percentage in Excel

    400

  • 57

    Minimum zoom percentage

    10

  • 58

    Default zoom Percentage

    100

  • 59

    V look up function used to

    find related records

  • 60

    To edit the selected cell

    f2

  • 61

    To create macros in Excel

    visual basic

  • 62

    Maximum column with in MS Excel

    255

  • 63

    Default column width in MS Excel

    8.43

  • 64

    Popular DOS based spredsheet package

    lotus 123

  • 65

    Files created with Lotus 123 have an extension

    .123

  • 66

    Oldest spredsheet package

    visicalc

  • 67

    Greater than sign is an example of

    logical operator

  • 68

    Ctrl+ D used to

    to fill down in the selection

  • 69

    Create pivot chart

    f1

  • 70

    Create chart

    f11

  • 71

    Expand or collapse formula bar

    ctrl+shift+u

  • 72

    Insert auto sum formula

    alt+=

  • 73

    Show or hide all formula

    ctrl+~

  • 74

    Apply the time format

    ctrl+shift+@

  • 75

    Display the control menu

    alt+space bar

  • 76

    To hide selected columns

    ctrl+0

  • 77

    To hide selected rows

    ctrl+9

  • 78

    To go to the last cell

    ctrl+end

  • 79

    To go to the first cell

    ctrl+home

  • 80

    Left one cell

    shift+tab

  • 81

    Right one cell

    tab

  • 82

    Create an absolute

    f4

  • 83

    Calculate worksheet

    f9

  • 84

    Go to dialogue box

    all

  • 85

    Strikethrough

    ctrl+s

  • 86

    How many tabs are in Excel

    9

  • 87

    Default tab in MS Excel

    home

  • 88

    Twin tower New comment in a cell

    shift+f2

  • 89

    Insert auto sum formula

    alt+=

  • 90

    Show all hide all formula

    ctrl+~

  • 91

    To apply the date format

    ctrl+shift+#

  • 92

    To apply the percentile format without decimal

    ctrl+shift+%

  • 93

    Start a new line in the same cell

    alt+enter

  • 94

    Extend the selection of the cell

    ctrl+shift+home

  • 95

    Create pivtot Chart in the same worksheet

    alt+f1

  • 96

    To bring up search box

    shift+f5

  • 97

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

    ctrl

  • 98

    Open workbooks can be switched using

    ctrl+tab

  • 99

    Excel file cannot be directly exported as

    ppt

  • 100

    Work space mean

    group of workbooks