Font size
WorksheetsEnhancing the display of workbooks in Excel
Total questions: 81
Worksheet time: 46mins
Excel spreadsheets that are already created and ready for you to edit are known as?
spreadsheets
templates
data inputs
pages
Where is the zoom function located in Excel?
Bottom right of spreadsheet document
Bottom left of spreadsheet document
Top right of spreadsheet document
Top left of spreadsheet document
The Ribbon contains multiple (a) , each with a group of commands.
Excel files are called (a) .
Each workbook holds one or more (a) .
An Excel file format extension is
doc
xls
txt
mp3
Text in Excel is automatically aligned _____________.
Right
Left
Center
Justify
Numbers in Excel are automatically aligned ____________?
Left
Right
Center
Justified
The ability to quickly add a formula, set of number, months or day of the week down a column or across a row.
Autofill
Copy and Paste
Drag and Drop
Typing
These items allow you to move up & down or left & right in a worksheet that is to large to fit on the screen at once.
Row Bars
Column Bars
Scroll Bars
Home Bars
What icon do you choose to align the text at the top, middle, or bottom of a cell?
What is this icon?
Zoom
Sort and Filter
Symbol
Merge and Center
The cell address of the highlighted cell is
C
4
A4
C4
Which of the following statements describes how to increase or decrease a column's width?
Right-click anywhere in the column and select Format Cells
Use the Page Setup dialog box
Drag the boundary next to the column heading
Select a Width setting in the Scale to Fit group on the Page Layout tab
Which of the following dialog boxes is used to transpose rows and columns?
Page Setup
Paste Special
Column Width
Row Height
In which of the following locations are check boxes that you can select to view or print gridlines?
In Print Preview
On the Home tab, in the Cells group
On the Page Layout tab, in the Sheet Options group
On the Page Layout tab, in the Page Setup group
A(n) __________ is a line of text that appears at the top of each page of a printed worksheet.
Header
Footer
Headnote
Footnote
__________ is the top-to-bottom measurement of a row, measured in points.
Row height
Row size
Row dimension
Row margin
__________ refers to shrinking or stretching printed output to a percentage of its actual size.
Zoom out
Shrink page
Make fit
Scaling
A(n) __________ is a predefined set of colors, fonts, and effects that can be applied to an entire workbook
theme
styles
template
design
What option allows you to force rows or columns to be printed on each page of a multi-page worksheet?
Print rows/columns
Print area
Print titles
Print headings
When Excel follows the order of operations, the formula, 8* 3 + 2, equals _____.
40
26
48
13
The adjusted cell references in a copied and pasted formula are called _____ references.
related
relative
pasted
alternative
The _____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.
MIN
SUM
AVERAGE
MAX
Rules that determine the order in which operations are performed within a formula containing more than one arithmetic operation.
Auto Fill
Complex Formula
Functions
Order of Precedence
A formula that uses more than one arithmetic operator.
Functions
Mixed Reference
Complex Formula
Absolute Cell Reference
A cell address that refers to a specific cell and does not change when you copy the formula; indicated by a dollar sign before the column letter and/or row number.
Function
Mixed Cell Reference
Absolute Cell Reference
Relative Cell Reference
Cell reference that combines both absolute and relative cell addressing.
Relative
Absolute
Mixed Reference
Sharon's spreadheet contains information about the number of music downloads in F1:F25. F1:F25 represents a:
Cell
Column
Range
Row
In a Microsoft Excel worksheet, how do you change the width of a column so that the widest entry will fit?
Smart Fit
AutoFit
Best Fit
True Fit
Which command on the Fill options dialog box is the default option if a month or day is entered?
Copy Cells
Fill Formatting Only
Fill without Formatting
Fill Series
Use this drop-down menu to select a different font for your text.
Use these to make the text closer or farther away from the cell walls.
Use this icon to combine and center contents of selected cells in a new larger cell.
The lines on your worksheet that separate the columns and rows.
Sheet Tabs
Functions
Formula Bar
Cell Grid
When you move the mouse while holding down the mouse button (usually the left) to select a range of cells.
Drag
File
Cell Grid
Function
When you open Excel you are viewing Excel in the ____ View?
Backstage
Frontstage
Spreadsheet
Template
What does this tool do?
Add a table
Add a border
Add a Pie chart
Add an image
What is the tool used for?
Change colour of Text
Change colour of the Cell (Box)
Fill the whole sheet
The shortcut key to “undo” an action in Excel
ctrl + z
ctrl + c
ctrl + home
ctrl + page up
What keyboard shortcut moves you “up” a spreadsheet?
shift + enter
shift + control
alt + enter
alt + control
Title Bar
Name box
Active cell
Ribbon
Title Bar
Ribbon
Active Cell
File Tab
Name Box
Title Bar
Ribbon
Active Cell
Cell
Cell Pointer
Worksheet Area
Blank Page
Formula bar
Name box
Cell
Quick Acess toolbar
The __________ is the line between rows or columns.
Border line
Boundary
Header
Move line
Kathryn needs to text in cell A1 to be angled at 90 degrees. Which alignment option should she select?
Center
Merge and Center
Orientation
Wrap Text
Column D in a spreadsheet contains employee ID Numbers. Which formatting would be most appropriate for the data in column D?
Currency
Date
Number
Text
Which command is used to reduce the margin between the border and the text in an indented cell?
Alignment
Column Width
Decrease Indent
Orientation
On the Home Ribbon, what is used to change the font size of characters in a cell?
Cell Styles drop-down list
Font drop-down list
Font Size drop-down list
Font Style drop-down list
Where is the command to apply a fill color to a cell or range of cells in a worksheet?
Home Ribbon
Insert Ribbon
Page Layout Ribbon
View Ribbon
Kenyon would like to apply the Title format to the data in Row 1 of a spreadsheet. Which formatting style should he select?
Cell Style
Conditional Formatting
Fill Color
Format as Table
Where is the command to apply a fill color to a cell or range of cells in a worksheet?
Home Ribbon
Insert Ribbon
Page Layout Ribbon
View Ribbon
Which dialog box in Microsoft Excel is used to set the rotation of text in a cell to a specific degree?
Alignment
Format Cells
Format Text
Orientation
What command is used to apply a background color to cells in a worksheet?
Borders & Shading
Drawing
Highlight
Fill Color
Carl notices the last two lines of text in cell B4 are not showing up in his spreadsheet. How could Carl format the cell to correct this problem?
Special Formatting
Subscript Formatting
Merge
AutoFit
Which command on the Home Ribbon can be used to rotate text to a vertical or diagonal angle in a worksheet?
Font
Merge & Center
Orientation
Wrap Text
Which defines the appearance and shape of the letters, numbers, and special characters in Microsoft Excel?
Alignment
Font
Size
Effects
Trey would like to outline the cell range A1:F20. Which formatting style should he select?
Borders
Cell Style
Conditional Formattting
Format as Table
Column D in a spreadsheet contains information about regional Sales. Which formatting would be most appropriate for the data in column D?
Currency
Date
Number
Text
Which command on the Insert Ribbon creates a link to a web page, picture, email address, or program in a worksheet?
Linkup
Hyperlink
Text Link
Web Link
On the Home Ribbon, what can be used to change the text color of characters in a cell?
Font Color drop-down list
Font Size drop-down list
Fill Color drop-down list
Cell Styles drop-down list
Kathryn needs the title in cell A1 to align horizontally across cells A1 through D1. Which alignment option should she select?
Center
Merge and Center
Orientation
Wrap Text
The ____________ function displays the highest value in a range.
MAX
SUM
AVERAGE
MIN
