Description : The basic unit ofa worksheet into which you enter data in Excel is called a– (A) tab (B) cell (C) box (D) range (E) None of these
Last Answer : cell
Description : In MS-Excel, ______ provide a visual representation of the values in a worksheet. (1) Charts (2) Formulae (3) Templates (4) Views
Last Answer : Charts
Description : Ctrl + Page up (In Ms - Excel) is used for: a) Move to the previous worksheet in the workbook b) Insert a new worksheet into the current workbook c) Select the current worksheet and the next worksheet d) None of These
Last Answer : a) Move to the previous worksheet in the workbook
Description : In MS - Excel, Move to the next worksheet in the workbook can be done through: a) Ctrl + Page Down b) Ctrl + Page Up c) Ctrl + F3 d) None of These
Last Answer : a) Ctrl + Page Down
Description : How can I pull data from one Excel worksheet to another based on matching Part Number?
Last Answer : answer:The Vlookup function is what you seek. Example: Book1 has a list of part numbers 1 2 3 4 5 Book2 has a list of part numbers,with product name 4 tchotchke 2 gizmo 5 trinket 3 thingy 1 doodad ... have to be in any particular order on either sheet. (if you use that FALSE argument at the end).
Description : What do you press so that the cell accept your typing as its contents: a) Enter b) Tab c) Escape d) Enter and Tab e) None of The Above
Last Answer : d) Enter and Tab
Description : Suppose you have columns of data that span more than one printed page. How can you automatically print the column headings on each page? 1) Click Page Setup on the File menu, click the Sheet tab, ... Page Setup on the File menu, click the Sheet tab, and make a selection under the Print heading
Last Answer : 1) Click Page Setup on the File menu, click the Sheet tab, and enter the row that contains these column
Description : What displays the contents of the active cell in Excel: a) Name box b) Row Headings c) Formula bar d) Taskpane e) None of The Above
Last Answer : c) Formula bar
Description : The sample of an Excel worksheet on the screen can be seen by ……………….. -Technology
Last Answer : (a) Print preview enables you to view the sample of worksheet before printing it on a paper.
Description : For selecting the entire worksheet in Excel, you need to press ………………. -Technology
Last Answer : (b) You need to press Ctrl + Shift + Spacebar for selecting the entire worksheet in Excel.
Description : What kind of documentation is allowed by MS - Excel default worksheet ( .xls) ?
Last Answer : MS-Excel allows creation of Worksheet (.xls) documents by default worksheet ( .xls ).
Description : In an Excel worksheet does a column typically contain information that is similar to a list?
Last Answer : Yes it does, like a field in a database.
Description : Which of the following can you print: a) A range of cells by range name b) An entire worksheet c) A single worksheet d) None of The Above
Last Answer : c) A single worksheet
Description : What displays the content of the active cell in Excel? 1) Name box 2) Row Headings 3) Formula bar 4) Taskpane
Last Answer : 3) Formula bar
Description : The _____enables you to simultaneously keep multiple Web pages open in one browser window: a) tab box b) pop - up helper c) tab row d) address bar e) Esc Key
Last Answer : c) tab row
Description : If you enter 15 + 30 in a cell, Excel will display …………….. -Technology
Last Answer : If you enter 15 + 30 in a cell, Excel will display15 + 30.
Description : What displays thecontents of the active cell in Excel ? (A) Name box (B) Row Headings (C) Formula bar (D) Task pane (E) None of these
Last Answer : Name box
Description : Is it true you can't send a single tab from excel in an email?
Last Answer : I really think the easiest way would be to use a PDF printer driver like Cute PDF Writer to print that one sheet. By design, it really isn't any more of a hassle than printing it out ... different printer ), and partly for compatibility, as they work with any program that has a Print option.
Description : How do I set tab order in Excel?
Last Answer : answer:If you can't unlock the protection, then you can't move the tabs. It's as simple as that. That's why Workbook Protection exists. Now, if you would like to bypass Excel's security and ... t think are so simple) then there are any number of downloadable macros that you could find to do that.
Description : Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet? 1) Use CTRL to select all three cells, then click the Paste Button image button ... ) Use Alt to select all three cells, then click the Paste Button image button on the Standard toolbar
Last Answer : 3) Click Format Painter Button image on the Formatting toolbar twice, then click in each cell you want to
Description : Which of the following keys of personal computer is not available in the key board of traditional typewriters? (1) Tab (2) Spacebar (3) Enter (4) Backspace
Last Answer : (3) Enter
Description : In MS-EXCEL, for Moves the current selected range down a row, you will press: a) Shift + Up Arrow Key b) Shift + Down Arrow Key c) Ctrl + Down Arrow Key d) None of These
Last Answer : b) Shift + Down Arrow Key
Description : The window version of Excel supports programming through Microsoft's Visual Basic for Applications (VBA), which is a dialect of _____: a) Visual Support b) Visual Basic c) Visual Format d) None of These
Last Answer : b) Visual Basic
Description : The“““.enables you tosimultaneously keep multiple Web pagesopen in onebrowser window. (A) tab box (B) pop-up helper (C) tab row (D) addressbar (E) Esc key
Last Answer : tab row
Description : How do you enter number 00123 on Excel?
Last Answer : If you type 00123 into a cell it will become 123. If you want toshow the two zeroes, you need to format it as text, with thesimplest way being to put a ' in front of it like this: '00123. Itwill now be a piece of text.
Description : When using a function point estimation worksheet, there are 14 factors that impact the complexity of a project. These factors include _____. a. data communications, time tradeoffs, and ... programming language d. reports printed and PCA e. x-rays, extensibility, and operational conversion
Last Answer : b. end-user efficiency, data communications, and reusability
Description : In Microsoft Word shortcut key Ctrl + F is used for ______: a) Open the search bar b) Start the find utility c) Open the history bar d) Opens the favorite dialog box e) None of The Above
Last Answer : b) Start the find utility
Description : Why is the search icon (magnifying glass) in Google search box on one tab and not the other?
Last Answer : It’s not longer there, right after I posted the question.
Description : Have you ever successfully opened a box of mac & cheese by the "push to open" tab?
Last Answer : I haven't opened one of those boxes in 20 years or more, when I used to make that for the kids when they were much younger. But it always worked then. The trick for me was to align my ... the curved perforation, and to push my thumbnail against the line. That was what tore through the packaging.
Description : Sona wants to add her pictures in a Word document. 1. Which tab she should use? 2. Which command she should use to open Insert Picture dialog box? -Technology
Last Answer : 1. Insert tab2. Picture command in the Illustrations group.3. Yes4. Yes
Description : In PowerPoint 2007 under the Insert tab, there is a button named Text Box. What is the utility of this button? -Technology
Last Answer : Like a title placeholder, a Text Box is used to hold the text information
Description : Which type of file is created by Word Processing Programs? 1) Database File 2) Storage File 3) Worksheet File 4) Document File
Last Answer : 4) Document File
Description : A chart is a graphical representation of worksheet data. -Technology
Last Answer : True A chart is a graphical representation of worksheet data.
Description : On an excel sheet the active cell is indicated by: a) A red border b) A dotted border c) A blinking border d) A dark wide border e) None of The Above
Last Answer : d) A dark wide border
Description : What in a pivot table dialog box can change Excel report to layout mode?
Last Answer : What is the answer ?
Description : Is it possible to prevent someone from copying the cell from your worksheet?
Last Answer : There are several ways to prevent someone from copying cells from your worksheet, depending on the specific software and platform you are using. Some of the most common methods include: Password ... foolproof and determined individuals may still be able to copy the data by using other methods.
Description : Sana has entered 49+30 in a cell. The worksheet is not displaying 79 in the cell. -Technology
Last Answer : In Excel, every formula must start with a = (equal) sign.Since Sana has not put = sign before 49+30, thus she is not able to see the desired result will be displayed if she will use = (49 + 30) formula.
Description : In a worksheet, cell K12 has a value. A formula is to be entered in cell K15, such that if the value in cell K12 -Technology
Last Answer : In cell K15, enter the conditional statement as: = IF (K12 > 300, K12 *1.33, K12 * 1.5). Here, IF condition checks the value at K12, that is, if it is greater than 300, then calculate 1.33 of K12, otherwise 1.5 of K12.
Description : What ence for the cell located in the fourth column and third row of a worksheet?
Last Answer : The cell is D3 (column D, row 3).Don't know what ence in the question means
Description : In MS-Excel, which of the following keys helps you to selects all cells below the current selection, up to the edge of the current data region: a) Ctrl + Shift + Down Arrow Key b) Ctrl + Shift + Right Arrow Key c) Ctrl + Shift + D d) None of These
Last Answer : a) Ctrl + Shift + Down Arrow Key
Description : What do you use to create a chart? 1) Pie Wizard 2) Excel Wizard 3) Data Wizard 4) Chart Wizard
Last Answer : 4) Chart Wizard
Description : In my task manager tab my Disk and Memory usage tends to be high what parts should I upgrade to fix this I have a basic motherboard might that be the problem?
Last Answer : It might not be just a hardware issue. First - see what programs are running in the background - and stop any that are unnecessary. Once that's sorted - look at increasing your hardware's capabilities. The main ... 10 - with an 'emulator' to make it look like Windows 8 (I liked the Win 8 interface).
Description : In Excel,..... contains one or more worksheets. 1) Template 2) Workbook 3) Active cell 4) Label
Last Answer : 2) Workbook
Description : I use tethering on my iPhone to play x-box live and everytime I enter matchmaking it says NAT not open how can I open it?
Last Answer : No matter if it is open or closed you will lag severely playing on an Iphone. To open it though you need to go in to your settings on the Xbox.
Description : Why does the windows 7 run dialog box disappear after I hit enter?
Last Answer : Open run type CMD, hit enter then type ipconfig /all
Description : Which social science is described here Enter the correct number in the answer box. Individuals working in this discipline apply social theories to real life situations.?
Last Answer : Sociology would be the social science that applies social theories to real life situations.
Description : A place through which, data can enter or leave a computer is called (1) bus (2) dock (3) mouse (4) port
Last Answer : port
Description : Convert Excel cell data to a column header?
Last Answer : answer:From your question it's not entirely clear to me what you want to do. Obviously you want to differentiate one product (Product ID) from another. So, do you just want to change a listing that ... the Find text with , leaving you with only the product ID values. Was that what you wanted?
Description : If the data entered in a cell is 546z then, Excel will treat it as a number because it starts with a digit. -Technology
Last Answer : False It will be treated as non-numeric data because it contains letters along with numbers.