BUS 110 Midterm Questions with Accurate Answers
_____ rearranges the rows in your worksheet by the data I'm a column or
columns
a. Sorting
b.Filtering
c. Formating
d. Grouping correct answer a
______ apply combinations of fonts, line styles, fills and shape effects to charts
a. Quick Styles
b. Quick Layouts
c. Chart Effects
d. Chart Templates correct answer a
______ are the numbers at he left of the rows and the letters at the top of the
columns
a. Headings
b. Footers
c. Headers
d. Gridlines correct answer a
______ charts represent data as parts of a whole
a. Column
b. Line
c. Pie
,d. Bar correct answer c
_______ is a special report view that summarizes data and calculates the
intersecting totals
a. PivotTable
b. table
c. chart
d. scenario correct answer a
________ represent each data series as an individual graphic within a single cell
a. Sparklines
b. Charts
c. Tables
d. PivotCharts correct answer a
A ____ is a graphic or text that appears as part of the page background as a
usually faded appearance?
a. water mark
b. cover page
c. margin
d. property control correct answer a. watermark
A _____ is a text that appears at the bottom of every page just above the margin
a. header
b.footer
, c.headings
d.sheet tab correct answer b
A _____ is a unified color, font, and effects scheme you apply to a workbook.
a. style
b. theme
c. cell format
d. conditional format correct answer b
a formula to display the value of cell A5 on the inventory worksheet looks like
thing;
a. =Inventory!A5
b. =A5,Inventory!
c. =Inventory, A5
d. =Inventory(A5) correct answer a
A piece of content that is reusable in any document, such as a cover page or a
watermark, is known as ___
a. property control
b. building block
c. field
d. style set correct answer b. building block
A total row can be used to quickly calculate the ____ of all the values in a column.
a. sum
_____ rearranges the rows in your worksheet by the data I'm a column or
columns
a. Sorting
b.Filtering
c. Formating
d. Grouping correct answer a
______ apply combinations of fonts, line styles, fills and shape effects to charts
a. Quick Styles
b. Quick Layouts
c. Chart Effects
d. Chart Templates correct answer a
______ are the numbers at he left of the rows and the letters at the top of the
columns
a. Headings
b. Footers
c. Headers
d. Gridlines correct answer a
______ charts represent data as parts of a whole
a. Column
b. Line
c. Pie
,d. Bar correct answer c
_______ is a special report view that summarizes data and calculates the
intersecting totals
a. PivotTable
b. table
c. chart
d. scenario correct answer a
________ represent each data series as an individual graphic within a single cell
a. Sparklines
b. Charts
c. Tables
d. PivotCharts correct answer a
A ____ is a graphic or text that appears as part of the page background as a
usually faded appearance?
a. water mark
b. cover page
c. margin
d. property control correct answer a. watermark
A _____ is a text that appears at the bottom of every page just above the margin
a. header
b.footer
, c.headings
d.sheet tab correct answer b
A _____ is a unified color, font, and effects scheme you apply to a workbook.
a. style
b. theme
c. cell format
d. conditional format correct answer b
a formula to display the value of cell A5 on the inventory worksheet looks like
thing;
a. =Inventory!A5
b. =A5,Inventory!
c. =Inventory, A5
d. =Inventory(A5) correct answer a
A piece of content that is reusable in any document, such as a cover page or a
watermark, is known as ___
a. property control
b. building block
c. field
d. style set correct answer b. building block
A total row can be used to quickly calculate the ____ of all the values in a column.
a. sum
