Excel Exam #1 Study Guide
Speed Fill enters text based on patterns it finds in the data. correct
answersFalse
If you want to create a new line within a cell, press the keys to move
the insertion
point to the next line within the cell. correct
answersAlt+Enter
The formula used to multiply cell A1 by cell C1 is . correct
answers=A1*C1
An Excel worksheet can have a maximum of columns in a worksheet.
answers16,3
correct
84
In the above figure, which box displays the formula in the formula bar?
(Refer to Excel
1) correct
answers2
Conditional formats are dynamic, so a cell's appearance will change to
reflect correct
value. its current
answersTrue
Information that prints on each page, like a company name or logo, may
be set. as a
correct answersPrint
Title
Italic, bold, bold italic, and underline are examples of . correct answersFont
Styles
To avoid splitting a worksheet in awkward places, you can insert a to
specify abreaking point. correct answersManual Page
specific
Break
In the accompanying figure, it shows that is the theme font used for
headings.
(Refer to Excel 2) correct answersCalibri
Light
When you insert a new row, the existing rows are shifted down and the new
row has
same width
the as the row above it. correct
answersFalse
Whenever you click the Save button on the Quick Access Toolbar or press
the
keys, the workbook file is updated to reflect the latest content. correct
In the figure above, which box displays the range references? (Refer to Excel
answersCtrl+S
answers
3) correct
6
In the above figure, which box displays the ScreenTip displaying the syntax
of the SUM
function? (Refer to Excel 4) correct
answers5
To switch to mode, you double-click the cell. correct
answersEdit
, Excel organizes fonts into theme and non-theme fonts. correct
answersTrue
Setting the to A1:L10 will print only data in those cells. correct
answersPrint Area
When using the Format Painter, double-click the Format Painter button to
paste format
same the multiple times and click the Format Painter again to .
correct
answersTurn it
off
Because Excel stores dates and times as , you can apply different
without
formats affecting the date and time value. correct
answersNumbers
In the accompanying figure, the number 3 displays . (Refer to Excel 5)
correct
answersIndented
Text
A keyboard shortcut is a key or combination of keys that you press to
access
or perform
a feature
a command. correct
answersTrue
In the figure above, which box displays the highlighted cells used in the
function?
to Excel 5)(Refer
correct
answers3
mm/dd/yyyy is known as . correct answersDate
Format
An Excel formula always begins with a(n) . correct answersEquals
Sign
By default, Excel sets the page margins to 0.5 on the left and right margins
and top
the 0.75and
on bottom margin. correct
answersFalse
In the accompanying figure, the font in Live Preview is . (Refer to Excel
2) correct
answersAlgeri
an
Antoinette wants to be sure that her worksheet does not contain any
duplicates.
use the highlight
She will
cells rule to check for this. correct answersDuplicate
Values
In Excel, to merge cells A1, B1, C1, D1, and E1, is the correct reference for
the
merged cell. correct
answersA1
To add a to a sheet tab, right-click a sheet tab, point to Tab Color on the
menu, and then click a color. correct
shortcut
answersFill Color
Ctrl + G is used to access the . correct answersGo to a location in the
worksheet
comman
d
Excel makes reading formulas simpler by each cell reference in the
its corresponding
formula and cell in the worksheet. correct
answersColor Coding
Speed Fill enters text based on patterns it finds in the data. correct
answersFalse
If you want to create a new line within a cell, press the keys to move
the insertion
point to the next line within the cell. correct
answersAlt+Enter
The formula used to multiply cell A1 by cell C1 is . correct
answers=A1*C1
An Excel worksheet can have a maximum of columns in a worksheet.
answers16,3
correct
84
In the above figure, which box displays the formula in the formula bar?
(Refer to Excel
1) correct
answers2
Conditional formats are dynamic, so a cell's appearance will change to
reflect correct
value. its current
answersTrue
Information that prints on each page, like a company name or logo, may
be set. as a
correct answersPrint
Title
Italic, bold, bold italic, and underline are examples of . correct answersFont
Styles
To avoid splitting a worksheet in awkward places, you can insert a to
specify abreaking point. correct answersManual Page
specific
Break
In the accompanying figure, it shows that is the theme font used for
headings.
(Refer to Excel 2) correct answersCalibri
Light
When you insert a new row, the existing rows are shifted down and the new
row has
same width
the as the row above it. correct
answersFalse
Whenever you click the Save button on the Quick Access Toolbar or press
the
keys, the workbook file is updated to reflect the latest content. correct
In the figure above, which box displays the range references? (Refer to Excel
answersCtrl+S
answers
3) correct
6
In the above figure, which box displays the ScreenTip displaying the syntax
of the SUM
function? (Refer to Excel 4) correct
answers5
To switch to mode, you double-click the cell. correct
answersEdit
, Excel organizes fonts into theme and non-theme fonts. correct
answersTrue
Setting the to A1:L10 will print only data in those cells. correct
answersPrint Area
When using the Format Painter, double-click the Format Painter button to
paste format
same the multiple times and click the Format Painter again to .
correct
answersTurn it
off
Because Excel stores dates and times as , you can apply different
without
formats affecting the date and time value. correct
answersNumbers
In the accompanying figure, the number 3 displays . (Refer to Excel 5)
correct
answersIndented
Text
A keyboard shortcut is a key or combination of keys that you press to
access
or perform
a feature
a command. correct
answersTrue
In the figure above, which box displays the highlighted cells used in the
function?
to Excel 5)(Refer
correct
answers3
mm/dd/yyyy is known as . correct answersDate
Format
An Excel formula always begins with a(n) . correct answersEquals
Sign
By default, Excel sets the page margins to 0.5 on the left and right margins
and top
the 0.75and
on bottom margin. correct
answersFalse
In the accompanying figure, the font in Live Preview is . (Refer to Excel
2) correct
answersAlgeri
an
Antoinette wants to be sure that her worksheet does not contain any
duplicates.
use the highlight
She will
cells rule to check for this. correct answersDuplicate
Values
In Excel, to merge cells A1, B1, C1, D1, and E1, is the correct reference for
the
merged cell. correct
answersA1
To add a to a sheet tab, right-click a sheet tab, point to Tab Color on the
menu, and then click a color. correct
shortcut
answersFill Color
Ctrl + G is used to access the . correct answersGo to a location in the
worksheet
comman
d
Excel makes reading formulas simpler by each cell reference in the
its corresponding
formula and cell in the worksheet. correct
answersColor Coding
