Multiple calculations can be made in a single formula using
Home | Discussion ForumFree Online Test
Multiple calculations can be made in a single formula using
standard formulas
array formula
complex formulas
smart formula
Answer : B
Free Online Test
View More Related Question
1) Rounding errors can occur
When you use multiplication, division, or exponentiation in a formula
When you use addition and subtraction in a formula
Because excel uses hidden decimal places in computation
When you show the results of formulas with different decimal places that the calculated results
View Answer
2) Which function in excel counts the numbers of characters in a cell ?
3) When a row of data is to be converted into columns
Copy the cells in row, select the same number of cells in row and paste
Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK
Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK
Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK
View Answer
4) 3-D reference in a formula ?
Spans worksheets
Can not be modified
Only appears on summary worksheets
Limits the formatting options
View Answer
5) What excel feature can you use if you want to work with one record at a time ?
