NEW
Font size
WorksheetsMicrosoft Excel Review Part 2
Total questions: 20
Worksheet time: 10mins
Identify this icon.
Use this icon to give your page a Portrait or Landscape layout.
Use this icon to specify the data you would like to print.
To change the height of your printout, use this icon.
Use this icon to stretch or shrink your printout to a percentageof its actual size.
Identify this icon.
Use this icon to give your page a Portrait or Landscape layout.
Use this icon to specify the data you would like to print.
To change the height of your printout, use this icon.
Use this icon to stretch or shrink your printout to a percentageof its actual size.
Identify this icon.
Use this icon to give your page a Portrait or Landscape layout.
Use this icon to specify the data you would like to print.
To change the height of your printout, use this icon.
Use this icon to stretch or shrink your printout to a percentageof its actual size.
Identify this icon.
Use this icon to give your page a Portrait or Landscape layout.
Use this icon to specify the data you would like to print.
To change the height of your printout, use this icon.
Use this icon to stretch or shrink your printout to a percentageof its actual size.
Which of the following sizes are available to adjust the margins?
Normal
Wide
Custom
All of these
Which of the following is found in the Page Layout tab, Sheet Options group?
Print Gridlines
Width
Height
Scale
Which of the following can be done through the Print Area icon?
Set the Print Area
Clear the Print Area
Set the Print Area and Clear the Print Area
None of these
Row and column data, such as titles and headings, can be set to print on each page.
TRUE
FALSE
The only orientation options available are portrait and landscape.
TRUE
FALSE
Worksheet data can be scaled to fit on one page when printed, regardless of the size of thefonts, widths of the columns, and height of the rows.
TRUE
FALSE
Identify this icon.
Use this icon to organize data from smallest to largest or largestto smallest.
This icon allows you to format numbers as currency.
To increase the number of decimals, use this icon.
All formulas must begin with this symbol.
Identify this icon.
Use this icon to organize data from smallest to largest or largestto smallest.
This icon allows you to format numbers as currency.
To increase the number of decimals, use this icon.
All formulas must begin with this symbol.
Identify this icon.
Use this icon to organize data from smallest to largest or largestto smallest.
This icon allows you to format numbers as currency.
To increase the number of decimals, use this icon.
All formulas must begin with this symbol.
Identify this icon.
Use this icon to organize data from smallest to largest or largestto smallest.
This icon allows you to format numbers as currency.
To increase the number of decimals, use this icon.
All formulas must begin with this symbol.
Which of the following can be found by clicking the AutoSum drop‐down?
Average
Min
Sum
All of these
Which option is used to prevent a cell reference from changing when a formula is copied toanother location?
Named ranges
Absolute cell reference
Cell reference
General format
An advantage to defining range names is:
Selections can be larger
Selections can be any format
Name ranges are easy to remember
Name ranges clear cell contents
You can increase or decrease the decimal places by two.
TRUE
FALSE
The comma style allows you to format with a thousands separator.
TRUE
FALSE
Excel allows you to copy and paste formulas with AutoFill.
TRUE
FALSE
