Excel Test, MISY 5325 MS Excel Midterm Exam Study Guide Latest 2024 An Excel ____ allows data to be summarized and charted easily.worksheet
workflow
document
presentation - Correct Answer worksheet The first step in creating an effective worksheet is to make sure you ____.
apply font formatting
understand what is required
insert a chart
enter the data - Correct Answer understand what is required To enter data in a cell, you must first select the ____.
row
worksheet
column 1 / 4
cell - Correct Answer cell ____ is/are used to place worksheet, column, and row titles on a worksheet.
Color
Text
Links
Tabs - Correct Answer text By default, text is ____ in a cell.
left-aligned
centered
justified
right-aligned - Correct Answer left-aligned In Excel, a number can contain the characters ____.
0 1 2 3 4 5 6 7 8 9
+ - ( ) , /
- / 4
. $ % E e
all of the above - Correct Answer all of the above The range of cells receiving copied content is called the ____ area.
fill
range
location
paste - Correct Answer paste You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.
semi-colon (;)
colon (:)
period (.)
none of the above - Correct Answer colon(:)
The ____ is the small black square located in the lower-right corner of the heavy border around the active cell.
selection handle 3 / 4
sizing handle
fill handle
copy handle - Correct Answer fill handle The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.
Copy Options
Replace Options
Formatting Options
Auto Fill Options - Correct Answer Auto Fill Options The ____ preceding a formula alerts Excel that you are entering a formula or function and not text.
quotation mark (")
colon (:)
plus (+)
equal sign (=) - Correct Answer equal sign (=)
- / 4