Celia is typing a nested if function to multiply a cell’s value by different percentages depending on the cell’s specific value. however, the function is not working properly.

if(a3> 750,a3*135%,if(a3> 500,a3*110%,if(a3< 100,a3*90%,a3)

what is the most likely reason why excel is not recognizing this nested function?

celia should have used colons instead of commas.
the * symbol is not recognized in microsoft excel.
celia did not use enough parentheses.
percentages must be written as decimals.

Write code using c . (take input from user) calculate the size of a given file in kbs. in this task you will complete the function with the following prototype: float get_file_size(char * filename); the function takes the file name (address to the start of a null terminated character array) as input. the function should then open the file and find the number of bytes it contains till eof. the number of bytes divided by 1024 will give the size in kbs. if the file cannot be opened the function should return -1.

When making changes to optimize part of a processor, it is often the case that speeding up one type of instruction comes at the cost of slowing down something else. for example, if we put in a complicated fast floating-point unit, that takes space, and something might have to be moved farther away from the middle to accommodate it, adding an extra cycle in delay to reach that unit. the basic amdahl's law equation does not take into account this trade-off. a. if the new fast floating-point unit speeds up floating-point operations by, on average, 2ă—, and floating-point operations take 20% of the original program's execution time, what is the overall speedup (ignoring the penalty to any other instructions)? b. now assume that speeding up the floating-point unit slowed down data cache accesses, resulting in a 1.5ă— slowdown (or 2/3 speedup). data cache accesses consume 10% of the execution time. what is the overall speedup now? c. after implementing the new floating-point operations, what percentage of execution time is spent on floating-point operations? what percentage is spent on data cache accesses?

Which type of cell references are locked and not automatically updated when it’s copied a)formula b)relative c)absolute d)worksheet