MS Excel English

Question. With which of the following all formulas in excel starts ?

Ans: =

Question. On an excel sheet the active cell in indicated by ?

Ans: A dark wide border

Question. What term describes explanatory text attached to a cell ?

Ans: Comment

Question. How we can view a cell comment ?

Ans: position the mouse pointer over the cell

Question. Which of these will not select all the cells in a document ?

Ans: Clicking three times with the right mouse button in the spreadsheet

Question. The default style for new data keyed in a new workbook is ?

Ans: Normal

Question. If you press ___, the cell accepts your typing as its contents ?

Ans: Enter

Question. Which of the following keyboard shortcut can be used for creating a chart from the selected cells ?\

Ans: F11

Question. A value used in a formula that does not change is called a ?

Ans: Constant

Question. Formula palette is used to ?

Ans: create and edit formulas containing functions

Question. A Spreadsheet contains ?

Ans: rows and columns

Question. To open an existing workbook, click the Open button on the ___ toolbar ?

Ans: Standard

Question. Which among following is not associated with spelling dialogue box ?

Ans: Edit

Question. what term describes a background that appears as a grainy, non smooth surface ?

Ans: Gradient

Question. Which among following is associated with excel ?

Ans: Spreadsheet

Question. The cell reference for a range of cells that starts in cell C1 and goes over to column H and down to row 10 is ?

Ans: C1:H10

Question. You can convert existing Excel worksheet data and charts to HTML document by using the ?

Ans: Internet Assistant Wizard

Question. To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called ?

Ans: Pivot Table Report

Question. What function displays row data in a column or column data in a row ?

Ans: Transpose

Question. Except which of the following function, a formula with a logical function shows the word \"TRUE\" or \"FALSE\" as a result ?

Ans: IF

Question. Edit the selected cell.

Ans: F2

Question. Go to a specific e.g.,

Ans: F5

Question. Spell chech selected text and/or document

Ans: F7

Question. Create chart

Ans: F11

Question. Enter the current time

Ans: Ctrl + Shift + ;

Question. Enter the current date

Ans: Ctrl + ;

Question. Insert new worksheet.

Ans: Alt + Shift + F1

Question. Open the Excel formula window

Ans: Shift + F3

Question. Bring up search box.

Ans: Shift + F5

Question. Select all contents of the worksheet

Ans: Ctrl + A

Question. Bold highlighted selection

Ans: Ctrl + B

Question. Italic highlighted selection

Ans: Ctrl + I

Question. Insert link

Ans: Ctrl + K

Question. Underline highlighted selection.

Ans: Ctrl + U

Question. Strike through highlighted selection

Ans: Ctrl + 5

Question. Bring up the print dialog box to begin printing

Ans: Ctrl + P

Question. Undo last action

Ans: Ctrl + Z

Question. Minimise current workbook

Ans: Ctrl + F9

Question. Maximise currently selected workbook

Ans: Ctrl + F10

Question. Switch between open workbooks/windows

Ans: Ctrl + F6

Question. str,

Ans: Ctrl + Page up

Question. str,

Ans: Ctrl + Page down

Question. Move between two or more open Excel files

Ans: Ctrl + Tab

Question. Create a formula to sum all of the above cells

Ans: Alt + ="

Question. Insert the value of the above cell into cell currently selected.

Ans: Ctrl + '

Question. Format number in currency format.

Ans: Ctrl + Shift + $

Question. Format number in date format

Ans: Ctrl + Shift + #

Question. Format number in percentage format

Ans: Ctrl + Shift + %

Question. Format number in time format.

Ans: Ctrl + Shift + @

Question. Move to next section of text.

Ans: Ctrl + Arrow key

Question. Select entire column

Ans: Ctrl + Space

Question. Select entire row

Ans: Shift + Space

Comments

Post a Comment

Popular posts from this blog

জন্ম নিবন্ধন যাচাই

  Privacy Policy ting tong. built the জন্ম নিবন্ধন যাচাই app as a Free app. This SERVICE is provided by ting tong. at no cost and is intended for use as is. This page is used to inform visitors regarding my policies with the collection, use, and disclosure of Personal Information if anyone decided to use my Service. If you choose to use my Service, then you agree to the collection and use of information in relation to this policy. The Personal Information that I collect is used for providing and improving the Service. I will not use or share your information with anyone except as described in this Privacy Policy. The terms used in this Privacy Policy have the same meanings as in our Terms and Conditions, which are accessible at জন্ম নিবন্ধন যাচাই unless otherwise defined in this Privacy Policy. Information Collection and Use For a better experience, while using our Service, I may require you to provide us with certain personally identifiable information. The information that I requ...
Read more

জন্ম নিবন্ধন সংশোধন

  Privacy Policy Ting Tong. built the জন্ম নিবন্ধন সংশোধন app as a Free app. This SERVICE is provided by Ting Tong. at no cost and is intended for use as is. This page is used to inform visitors regarding my policies with the collection, use, and disclosure of Personal Information if anyone decided to use my Service. If you choose to use my Service, then you agree to the collection and use of information in relation to this policy. The Personal Information that I collect is used for providing and improving the Service. I will not use or share your information with anyone except as described in this Privacy Policy. The terms used in this Privacy Policy have the same meanings as in our Terms and Conditions, which are accessible at জন্ম নিবন্ধন সংশোধন unless otherwise defined in this Privacy Policy. Information Collection and Use For a better experience, while using our Service, I may require you to provide us with certain personally identifiable information. The information that I re...
Read more

জন্ম নিবন্ধন

  Privacy Policy built the জন্ম নিবন্ধন app as a Free app. This SERVICE is provided by at no cost and is intended for use as is. This page is used to inform visitors regarding my policies with the collection, use, and disclosure of Personal Information if anyone decided to use my Service. If you choose to use my Service, then you agree to the collection and use of information in relation to this policy. The Personal Information that I collect is used for providing and improving the Service. I will not use or share your information with anyone except as described in this Privacy Policy. The terms used in this Privacy Policy have the same meanings as in our Terms and Conditions, which are accessible at জন্ম নিবন্ধন unless otherwise defined in this Privacy Policy. Information Collection and Use For a better experience, while using our Service, I may require you to provide us with certain personally identifiable information. The information that I request will be retained on your devic...
Read more