Computer Study note's
MS-Excel 2007
- Microsoft Excel is a powerful ------Spreadsheet package
- An Excel Workbook is a collection of---------Worksheets and Charts
- Excel files have a default extension of-----Xls
- Maximum rows in worksheet----- 1,048,576 rows
- Maximum columns in worksheet -------- 16,384 columns
- Maximum column width ---- --- 255 characters
- Row height-----609 points
- Maximum page breaks--------- 1,026 horizontal and vertical
- Total number of characters that a cell can contain-------- 32,767 characters
- Maximum Characters in a header or footer------ 255
- Default sheets in workbook------3
- Maximum Unique cell formats/cell styles------- 64,000
- Maximum Unique font types-------- 1,024 global fonts available for use; 512 per workbook
- Maximum Hyperlinks in a worksheet------- 66,530 hyperlinks
- Zoom range ------- 10 percent to 400 percent
- Maximum Fields in a data form---------32
- Maximum Items displayed in filter drop-down lists-----10000
- Maximum Length of formula contents------ 8,192 characters
- Maximum Users who can open and share a shared workbook at the same time---- 256
- What do you mean by a Workspace------Group of Workbooks
- The first cell in EXCEL worksheet is labeled as---A1
- What happens when dollar signs ($) are entered in a cell address----- An absolute cell address is created
- What are the tabs that appear at the bottom of each workbook called-------- Sheet tabs
- What is represented by the small, black square in the lower-right corner of an active cell or range---- Fill handle
- In Excel, a Data Series is defined as what---- A division of results
- The Cancel and Enter buttons appear in the---- Formula bar
- The box on the chart that contains the name of each individual record is called the----- legend
- Where a row and a column meet, what do you call that --------- A cell
- A function inside another function is called----- Nested function
- Formulas in Excel start with----- =
- What is the keyboard shortcut for creating a chart from the selected cell range---- F11
- Which of the following shortcuts can be used to insert a new line in the same cell---- Alt + Enter
- If particular workbook have to open each time Excel started, where that workbook should be placed--- XLSTART Folder
- Worksheet can be renamed by--- Double Click on the Worksheet tab and type new name
- What is the shortcut key to hide entire row---- CTRL + 9
- What is the shortcut key to insert a new comment in a cell---- Shift + F2
- What is the shortcut key to insert new sheet in current workbook--- Shift + F11
- Which one is the last column header in Excel 2007---XFD
- In maximum, how many sheets can be set as default while creating new workbook---255
- In Excel, by default Numeric Values appears in----- Right aligned
- In EXCEL, you can sum a large range of data by simply selecting a tool button called-------Auto sum
- To select an entire column in MS-EXCEL, press--- CTRL+SPACEBAR
- To select the entire row----SHIFT+SPACEBAR
- To select the entire worksheet--------CTRL+A
- To select only the active cell (with multiple cells selected) ----- SHIFT+BACKSPACE
- To return the remainder after a number is divided by a divisor in EXCEL we use the function---MOD ()
- How do you rearrange the data in ascending or descending order-------Data, Sort
- Which Chart can be created in Excel-------Area, Line,pie
- How do you display current date and time in MS Excel----now 0
- How do you display current date only in MS Excel--Today 0
- What does COUNTA() function do-------counts non-empty cells
- In the formula, which symbol specifies the fixed columns or rows----$
- Excel displays the current cell address in the-----Name Box
- Comments put in cells are called------Cell Tip
- Comments can be added to cells using ......Insert -> Comment
- Which menu option can be used to split windows into two--------Window -> Split
- Getting data from a cell located in a different sheet is called.... Referencing
- Which of the following is not a valid data type in Excel---------Character
- be
- protected
- from
- accidental
- Which elements of a worksheet can modification--------Contents, Objects, Scenarios
- A numeric value can be treated as label value if ...... precedes it-------Apostrophe ()
- Concatenation of text can be done using-------Ampersand (&)
- Which area in an Excel window allows entering values and formulas--------Formula Bar
- Multiple calculations can be made in a single formula using--------Array Formula
- How do you delete a column-------- Right click the column heading you want to delete and select delete from the shortcut menu
- You can use the horizontal and vertical scroll bars to-------View different rows and columns edit the contents of a cell
- To Which button do you click to add up a series of numbers-------The autosum button
- Which area in an excel window allows entering values and formulas----Formula bar
- Status indicators are located on the-------Formula bar
- When you insert an excel file into a word document. The data are---Linked
- Which language is used to create macros in Excel--------- Visual Basic
- Which would you choose to create a bar diagram------------ Insert, Chart
- . What do you call the chart that shows the proportions of how one or more data elements relate to another data element---- Pie Chart
- Which key do you press to check spelling----F7
- To record a sequence of keystrokes and mouse actions to play back later we use----- Macro Recorder
Comments
Post a Comment