Excel Test, Microsoft Word Midterm Practice, Excel Study Guide, Microsoft Excel 2013 Test, Excel
2016, CISM Practice Exam 1, EXCEL MIDTERM with 100% correct answers already graded A+
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
cell - correct answer cell
,Excel Test, Microsoft Word Midterm Practice, Excel Study Guide, Microsoft Excel 2013 Test, Excel
2016, CISM Practice Exam 1, EXCEL MIDTERM with 100% correct answers already graded A+
____ 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 ____.
0123456789
+-(),/
.$%Ee
all of the above - correct answer all of the above
,Excel Test, Microsoft Word Midterm Practice, Excel Study Guide, Microsoft Excel 2013 Test, Excel
2016, CISM Practice Exam 1, EXCEL MIDTERM with 100% correct answers already graded A+
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
sizing handle
fill handle
, Excel Test, Microsoft Word Midterm Practice, Excel Study Guide, Microsoft Excel 2013 Test, Excel
2016, CISM Practice Exam 1, EXCEL MIDTERM with 100% correct answers already graded A+
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 (=)
You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and
understand.
save
print
2016, CISM Practice Exam 1, EXCEL MIDTERM with 100% correct answers already graded A+
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
cell - correct answer cell
,Excel Test, Microsoft Word Midterm Practice, Excel Study Guide, Microsoft Excel 2013 Test, Excel
2016, CISM Practice Exam 1, EXCEL MIDTERM with 100% correct answers already graded A+
____ 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 ____.
0123456789
+-(),/
.$%Ee
all of the above - correct answer all of the above
,Excel Test, Microsoft Word Midterm Practice, Excel Study Guide, Microsoft Excel 2013 Test, Excel
2016, CISM Practice Exam 1, EXCEL MIDTERM with 100% correct answers already graded A+
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
sizing handle
fill handle
, Excel Test, Microsoft Word Midterm Practice, Excel Study Guide, Microsoft Excel 2013 Test, Excel
2016, CISM Practice Exam 1, EXCEL MIDTERM with 100% correct answers already graded A+
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 (=)
You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and
understand.
save
