CIS 30 Excel - Final Exam prep / MOSTLY TESTED QUESTIONS AND CORRECT DETAILED ANSWERS| 100% CORRECT SOLUTIONS/GRADE A+

CIS 30 Excel - Final Exam prep / MOSTLY TESTED
QUESTIONS AND CORRECT DETAILED ANSWERS| 100%
CORRECT SOLUTIONS/GRADE A+



Terms in this set (111) Original




The __________feature automatically adjusts a column
width or row height to accommodate its widest or tallest AutoFit
entry.



Number data is any number that can be used in a
True
mathematical calculation.




What function would you enter to add the values in
=SUM(B4:B6)
cells B4, B5, and B6?

, What is the result of the expression =50+20/10*5-2? 58




Cell E11 contains the formula = SUM(E1:E10). How is
the formula adjusted when a new row inserted above =SUM(E1:E11)
row 5?



To count cells containing non-numeric data such as text
COUNTA
strings, you need to use the ___________ function.




What is the range reference for the block of cells from
A5:F8
A5 through F8 _________.




________ makes it easier to enter repetitive text in
AutoComplete
cells.




The formula to divide the value in cell C9 by the value
=C9/B9
in cell B9 is ___________.




To change the order of operations, enclose part of the
parentheses
formula in ______________.




Changing the number of decimal places displayed in a
True
cell does not change the value stored in the cell.