mgsc 290 exam 1 Questions and Answers
100% Correct
Correct Answ_Which of the following occurs when a formula includes the cell address of a
formula?
Correct Answ_In the Excel window, which of the following continuously displays the
buttons for switching worksheet views?
Correct Answ_Which of the following functions counts the number of cells in a range that
contain any data type, text, or numbers?
Fill Handle Tool Correct Answ_Which of the following simplifies the process of entering the
months of the year in a worksheet?
Correct Answ_Which of the following best describes the size of an Excel 2016 worksheet?
Correct Answ_Which of the following is a color-coded editing tool that applies different
colors to each cell or cell range within a formula?
, = D21 + E21 Correct Answ_Which of the following formulas includes only relative
references?
They have no arguments Correct Answ_Which of the following is true about the TODAY
and NOW functions?
COUNTIF Correct Answ_Which of the following functions counts the number of cells in a
range based on specified criteria?
3+2*4 Correct Answ_Which of the following has an answer of 11?
Correct Answ_Which of the following statements about circular references is false?
Correct Answ_Which of the following statements is not True?
Merge & Center Correct Answ_Which of the following features would you want to use to
center worksheet titles over multiple cells?
100% Correct
Correct Answ_Which of the following occurs when a formula includes the cell address of a
formula?
Correct Answ_In the Excel window, which of the following continuously displays the
buttons for switching worksheet views?
Correct Answ_Which of the following functions counts the number of cells in a range that
contain any data type, text, or numbers?
Fill Handle Tool Correct Answ_Which of the following simplifies the process of entering the
months of the year in a worksheet?
Correct Answ_Which of the following best describes the size of an Excel 2016 worksheet?
Correct Answ_Which of the following is a color-coded editing tool that applies different
colors to each cell or cell range within a formula?
, = D21 + E21 Correct Answ_Which of the following formulas includes only relative
references?
They have no arguments Correct Answ_Which of the following is true about the TODAY
and NOW functions?
COUNTIF Correct Answ_Which of the following functions counts the number of cells in a
range based on specified criteria?
3+2*4 Correct Answ_Which of the following has an answer of 11?
Correct Answ_Which of the following statements about circular references is false?
Correct Answ_Which of the following statements is not True?
Merge & Center Correct Answ_Which of the following features would you want to use to
center worksheet titles over multiple cells?
