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 spreadsheet software, the formula =A1 +$2 was entered in cell A3 and then copied into cell B3. What is the formula copied into B3? -Technology
Last Answer : Need Answer
Description : If = 6 _5 *2 is entered in a cell, then what will be the cell content? -Technology
Last Answer : -4 will be contained in the cell as a result.
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.
Description : Are Kimel kamper k12 parts available anywhere?
Last Answer : If you have lead a good life and are REAL lucky- maybe. That gundates to 1982, It was made by Invest Arms of Italy- and is stillmade by them as their Model 70. Depends on what part you need,
Description : What is the difference between a workbook and a worksheet? -Technology
Last Answer : Differences between the workbook and worksheet are as follows:WorkbookWorksheetA workbook is an Excel file with one ormore worksheets.A worksheet is a single spreadsheet of data.A workbook would be the entire binder,with everything in it.A worksheet would be like one section inthat binder.
Description : Is it possible to remove a worksheet? State the process of doing it. -Technology
Last Answer : Yes, it is possible to remove a worksheet. To remove a worksheet right-click on the Sheets tab of the sheet that you want to delete and choose Delete from the popup menu, or choose Delete Sheet from the pop-up menu of Delete option on cells group under Home tab.
Description : Explain any five functions that can be used in a worksheet. -Technology
Last Answer : 1. SUM FunctionThis function, as clear from the name, is used to add all the values provided as an argument and to display the result in the cell containing the function.Argument Type All ... 0 (zero).Arguments that are error values or text that cannot be translated into numbers cause errors.
Description : A worksheet is a ………………. (a) collection of workbooks -Technology
Last Answer : (c) A worksheet is a combination of rows and columns.
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 : A chart is a graphical representation of worksheet data. -Technology
Last Answer : True A chart is a graphical representation of worksheet data.
Description : What happens when text is entered in a Number type field? -Technology
Last Answer : When we enter text in a Number field and press Enter or press Tab key, MS-Access displays a message that “The value you entered does not match the Number data type in this column.”
Description : Which field property sets limits on the data that is entered? -Technology
Last Answer : Fixed Field Length or Field Size property sets the limits on the data entered.
Description : In Marks column of ‘Student’ table, for Rollnumber 2, the Class Teacher entered the marks as 45. -Technology
Last Answer : UPDATE Student SET Marks = 50 WHERE Roll number = 2;
Description : When a cell containing a formula is moved, the cells referring the moved cell show an error value. -Technology
Last Answer : False When a cell containing a formula is moved, the cells referring to the moved cell does not show an error value.
Description : You entered a Formula 1 race and are starting last of the 20 cars. By the final lap, you are in first place, passing all 20 cars. But this is actually not possible. Why? -Riddles
Last Answer : There are 20 cars including yourself. You can’t pass yourself.
Description : Cell address $5 in a formula means (a) it is a mixed reference -Technology
Last Answer : (b) $ sign in a formula need to add before row number and column letter for absolute referencing.
Description : While entering a formula, cell address B$5 represents (a) Absolute Referencing -Technology
Last Answer : (b) It represents mixed reference because we are using $ sign before 5 only. Hence, as we will drag this only B will change but 5 will remain the same.
Description : …………. are text, number cell references enclosed within parenthesis in a formula. -Technology
Last Answer : Argumentsare text, number cell references enclosed within parenthesis in a formula.
Description : A cell entry can be edited either in the cell or in the formula bar. -Technology
Last Answer : True There are two ways to edit the data which has entered in the cell, i.e. in the cell or in the formula bar.
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 : 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 : 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 : The basic unit of a worksheet into which you enter data in excel is called a ______: a) Tab b) Cell c) Box d) Range e) None of The Above
Last Answer : b) Cell
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 : The term noncompliance as used in PSA 250 refers to acts of omission or commission by the entity being audited, either intentional or unintentional, which are contrary to the prevailing laws ... misconduct (unrelated to the business activities of the entity) by the entity's management or employees
Last Answer : Personal misconduct (unrelated to the business activities of the entity) by the entity’s management or employees
Description : What technology from Formula 1 has made it into mainstream cars?
Last Answer : what i heard: tyre technology traction control electronic engine management paddle shifters turbochargers high performance carbon ceramic brakes carbonfibre bodies CAD car design use of wind tunnels ... suspension improvements direct fuel injection (AUDI, Le Mans) BMW Active Steering rear diffusers
Description : In a MS_Access database, which component is not present? (a) Formula Bar (b) Tables -Technology
Last Answer : (a) MS-Access contains various components, i.e. Tables, Queries, Forms, Reports, Macros and Modules.
Description : What is the default alignment of number, text and formula in a spreadsheet? -Technology
Last Answer : Default alignment of text or label entry is left alignment and for numbers and formula, it is right alignment.
Description : Write down the formula for adding values of cells A1 to A5. -Technology
Last Answer : Formula for adding values of cells A1 to A5 would be =SUM(A1 : A5).
Description : Define the meaning of formula. -Technology
Last Answer : Formula plays a major role in spreadsheet making. If we all needed to do is to put text and numbers in rows and columns, just about any Word processing program would fill the bill. Formula allows us to perform calculations using values from any cells to have the result appear in the formula cell.
Description : Any formula in Excel starts with an …………….. -Technology
Last Answer : Any formula in Excel starts with anequal (=) sign.
Description : For absolute referencing, ……………. sign is used before the parts of formula. -Technology
Last Answer : For absolute referencing, is used before the parts of the formula.
Description : If there is a discrepancy of Rs. 5/- in the value of MO as written in the MO form by the remitter and as advised by the office of payment a) The payment should be withheld and a ... paid and irregularity reported to office of issue d) The case is referred to HO/divisional supdt. for advice
Last Answer : c) The amount entered by the remitter may be paid and irregularity reported to office of issue
Description : If there is a discrepancy of less than Rs 10/- between the amount entered by the remitter and by the office of issue a) MO issue returned to the office of issue for necessary correction b) ... The amount written by the remitter is paid and irregularity reported to office of issue d) None of these
Last Answer : d) None of these
Description : Payment on account of pensions and commuted value of pensions made by Head and Sub Post offices will be entered in a separate schedule The above said statement is a. True b. False
Last Answer : a. True
Description : If the value of a number (N) is entered through keyboard. Write a program using recursion to calculate and display factorial of number (N).
Last Answer : #include<stdio.h> #include<conio.h> int factorial(int N); void main() { int N,fact; clrscr(); printf("Enter number:"); scanf("%d",&N); fact=factorial(N); printf( ... N) { if(N==1) return(1); else return(N*factorial(N-1)); }
Description : When synapsis is complete all along the chromosomes, the cell is said to have entered a stage called
Last Answer : When synapsis is complete all along the chromosomes, the cell is said to have entered a stage ... . Zygotene B. Pachytene C. Diplotene D. Diakinesis
Description : Bacteria develop tetracycline resistance by the following mechanisms except: A. Losing tetracycline concentrating mechanisms B. Elaborating tetracycline inactivating enzyme C. Synthesizing a protection protein' ... the target site D. Actively pumping out tetracycline that has entered the cell
Last Answer : B. Elaborating tetracycline inactivating enzym
Description : The cell A1 has value Monday. If you are asked to click and drag the Fill handle of A1 -Technology
Last Answer : Cells A2, A3, A4, and A5 will contain Tuesday, Wednesday, Thursday and Friday respectively.
Description : If you type =2 * (6_4) in cell Al, what value will be display? -Technology
Last Answer : (b) = 2*(6-4) = 2*(2) = 4
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 : The intersection of a worksheet column and row is a?
Last Answer : a "spread"
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 : where can i find a sequence worksheet?
Description : What is the quickest way to remove all the Filters that have been applied to a worksheet and nbsp and nbsp?
Last Answer : Need answer
Description : How do you add date in a worksheet?
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 : What do you do when your teacher gives you a worksheet that has nothing to do with what you learned?
Last Answer : Not doing it isn't really the appropriate option.If you believe the teacher handed out the wrong worksheet, askthem. If you didn't look at the worksheet until you got home, readit and try to figure ... starting a new unit.Put in an honest effort. Don't shrug the shoulders and give upso quickly.