ITSCM 280 Midterm Linda
Questions with Accurate
Answers
A cell contains a number displaying ######. Why does this occur?
correct answer The number of digits could not fit within the width of
the cell
A fast and efficient way of copying and pasting only the formats of a cell
would be use... correct answer Format Painter
A font is a set of characters that employ the same typeface, such as
Arial, Times New Roman and are measured the sizes in ... correct
answer Points
Assume that cell R10 contains the formula =$R1+R$2. What formula is
entered if this formula is copied and pasted in cell S20? correct answer
=$R11+S$2
Assume that R10 contains the formula =R1+R2. What formula is
entered if this formula is copied and pasted in cell S10? correct answer
=S1+S2
By default, Excel displays text in a _______ color font. correct answer
Black
, Deleting a row... correct answer Removes the content and the row
Each intersection of a row and column is a ___. Worksheet data is
placed within separate cells. correct answer Cell
Flash fill enter text based on patterns that it finds in the data. correct
answer True
How are page breaks indicated in Page Break Preview? correct answer
As dotted blue border
How do you enter a number so that Excel sees it as text? correct
answer Type an apostrophe (') before it
If cell A11 contains the formula =SUME(A1:A10), the error value of
#NAME? will appear in the cell. correct answer True
In a function, Excel uses numbers, text or cell reference to return a
value. They are always separated by a comma. What are these? correct
answer Argument
In an equation, what is a constant? correct answer Terms in a formula
that don't change their value
Questions with Accurate
Answers
A cell contains a number displaying ######. Why does this occur?
correct answer The number of digits could not fit within the width of
the cell
A fast and efficient way of copying and pasting only the formats of a cell
would be use... correct answer Format Painter
A font is a set of characters that employ the same typeface, such as
Arial, Times New Roman and are measured the sizes in ... correct
answer Points
Assume that cell R10 contains the formula =$R1+R$2. What formula is
entered if this formula is copied and pasted in cell S20? correct answer
=$R11+S$2
Assume that R10 contains the formula =R1+R2. What formula is
entered if this formula is copied and pasted in cell S10? correct answer
=S1+S2
By default, Excel displays text in a _______ color font. correct answer
Black
, Deleting a row... correct answer Removes the content and the row
Each intersection of a row and column is a ___. Worksheet data is
placed within separate cells. correct answer Cell
Flash fill enter text based on patterns that it finds in the data. correct
answer True
How are page breaks indicated in Page Break Preview? correct answer
As dotted blue border
How do you enter a number so that Excel sees it as text? correct
answer Type an apostrophe (') before it
If cell A11 contains the formula =SUME(A1:A10), the error value of
#NAME? will appear in the cell. correct answer True
In a function, Excel uses numbers, text or cell reference to return a
value. They are always separated by a comma. What are these? correct
answer Argument
In an equation, what is a constant? correct answer Terms in a formula
that don't change their value
