NEW
Font size
WorksheetsApplying Advanced Features to Spreadsheets Review
Total questions: 22
Worksheet time: 16mins
On which ribbon would you find the Themes Gallery?
Home
Insert
Page Layout
File
Theme formats are applied to ____________.
The range
The first worksheet
The active cell
The entire workbook
What do you select in order to switch the banded rows and columns in Microsoft Excel?
The entire workbook
The entire worksheet
The cells within the data
The column headings
Banded rows and columns are unique to the __________ in which they are applied.
column
workbook
worksheet
row
In OpenOffice Calc, which tab displays options that allow you to apply number formats to cells?
Alignment
Borders
Numbers
Background
In OpenOffice Calc which tab displays options for applying a font style for your cell?
Numbers
Font Effects
Font
Alignment
In OpenOffice Calc which tab displays options for applying a font effect for your cell?
Numbers
Font Effects
Font
Alignment
In OpenOffice Calc which tab displays options allow you to set the alignment of data in your cell?
Numbers
Font Effects
Font
Alignment
In OpenOffice Calc which tab displays options that allow you to add fill color to your cell?
Borders
Font Effects
Background
Font
In OpenOffice Calc which tab displays options that allow you to restrict another viewer from making updates to a cell?
Alignment
Cell Protection
Password Protection
Restriction
The extension .ots represents a(n) ___________.
OpenOffice Calc template
Microsoft Excel template
Microsoft Access template
Blank document template
What are added in Microsoft Office documents to explain data?
Formulas
Comments
Notes
Fill Color
What command is used to insert information into a worksheet that will display at the top and bottom edges of the printed page?
Margins
Print titles
Header & Footer
Page Setup
What happens when you password protect a worksheet?
It cannot be viewed
It will be filtered
It cannot be tracked
It cannot be sorted
Which of the following is the file extension used for Excel Template files?
.xlsm
.xltx
.xlsx
.xlam
Excel spreadsheets that are already created and ready for you to edit are known as?
spreadsheets
templates
data inputs
pages
In Excel, where do you go to remove conditional formatting?
Home tab, styles group
Page Layout tab, styles group
Page Layout tab, themes group
Home tab, editing group
