Word- autoformat controls the formatting of items such as numbered and bulleted lists, fractions, ordinal numbers, hyphens and dashes, quotes, indents and hyperlinks. Ex: ¾
question
Autofit
answer
Excel- resizes column width or row height to accommodate the width or height or the largest entry.
question
Wrap Text
answer
Excel- enables you to display the contents of a cell on multiple lines
question
Merge & center
answer
Excel- combines two or more cells into one cell and centers the text. Useful for centering worksheet titles over multiple columns.
question
What must you do to enter a number as a label in a cell?
Press spacebar before typing the number.
Type an open parenthesis before the number.
Type an apostrophe before the number.
Format the number as a label.
answer
Type an apostrophe before the number.
question
Which of the following simplifies the process of entering the months of the year in a worksheet?
Fill Handle tool
AutoSum button
Headings option
Freeze Panes option
answer
Fill Handle tool
question
What is selected when you point to and click a column heading?
the entire column
The entire row
The entire worksheet
the 20 cells adjacent to the top of the column
answer
the entire column
question
Which of the following features enables you to display the contents of a cell on multiple lines?
Autoformat
Autofit
Merge & center
Wrap text
answer
Wrap text
question
Which of the following paste options copies the contents, format, and styles of the source cell?
Paste
Formulas
Formulas & Number Formatting
Keep Source Formatting
answer
Keep Source Formatting
question
Which of the following activates edit mode?
pressing F2
pressing F4
double-clicking a cell
both pressing F2 and double-clicking a cell
answer
both pressing F2 and double-clicking a cell
question
For what is the Switch Windows feature helpful?
for viewing or editing multiple open workbooks
for viewing sheets from the same workbook
for switching between sheets in a workbook
all of the other answers are correct.
answer
for viewing or editing multiple open workbooks
question
Which of the following views displays worksheet data without the Ribbon and other screen elements?
Normal view
Page Layout view
Page Break Preview
Full Screen view
answer
Full Screen view
question
Normal view
answer
default view. Use to create and modify spreadsheets.
question
Page layout
answer
view and apply headers and footers and to view the layout of the spreadsheet prior to distribution
question
Page break preview
answer
adjust page breaks within your workbook using the drag and drop technique
question
Full screen
answer
view to display worksheet data without the ribbon and other screen elements.
question
By default, how does Excel align text in a cell?
-top left corner of a cell
-top right corner of a cell
-bottom left corner of a cell
-bottom right corner of a cell
answer
bottom left corner of a cell
question
Which of the following increases the distance between the cell contents and the left boundary of a cell?
-column width
-row height
-gridline
-indent
answer
indent
question
Which of the following statements is not true?
-Hidden worksheets do not appear in a printout.
-You can hide a worksheet using the Ribbon.
-You can hide a worksheet by right-clicking a sheet tab.
-You can hide a worksheet even if there is only one sheet in the workbook.
answer
You can hide a worksheet even if there is only one sheet in the workbook.
question
Which of the following statements is not true?
Right-click a sheet tab and choose Select All Sheets to format an entire workbook.
- The top and bottom margin settings must be less than the header and footer values or the worksheet data prints over the header and footer text.
-The default print orientation is portrait.
-The default header and footer margins are 0.3â ³.
answer
The top and bottom margin settings must be less than the header and footer values or the worksheet data
question
Which of the following keyboard shortcuts lets you undo single or multiple actions?
Ctrl+U
Ctrl+X
Ctrl+Y
Ctrl+Z
answer
Ctrl+Z
question
1. To select non-adjacent worksheets, which key must you press?
Ctrl
Alt
Shift
Tab
answer
Ctrl
question
To select adjacent worksheets, which key must you press?
answer
Shift
question
Which of the following statements is false?
-Sheet tab names cannot be more than 15 characters.
-You can apply a color to a sheet tab.
-There is no default color to sheet tabs.
-The default sheet names within a workbook are Sheet1, Sheet2, and so on.
answer
Sheet tab names cannot be more than 15 characters.
question
Which of the following must you press to enter a manual line break in a cell?
Ctrl+Enter
Ctrl+F4
Alt+Enter
Ctrl+F5
answer
Alt+Enter
question
Which of the following features expands or reduces a worksheet to print on a specific number of pages?
Scale to Fit
Zoom
Advanced Properties
Print Area
answer
Scale to Fit
question
** After selecting a column, what keyboard shortcut inserts a column to the left?
Ctrl+C
Ctrl+I
Ctrl and the plus sign (+) ??
Ctrl and the minus sign (-)
answer
Ctrl and the plus sign (+) ??
question
** Which of the following commands should you use to prevent column and row headings from scrolling off the screen?
Zoom options
Freeze Panes command ?
Status bar view buttons
Merge & Center command
answer
Freeze Panes command ?
question
Which of the following is a set of predefined formatting you can apply to titles, subtitles, column headings, row totals, and other areas of your worksheet?
cell style
range style
worksheet style
Format Painter
answer
Cell style
question
In Excel, which of the following keys opens the Save As dialog box?
F2
F8
F10
F12
answer
F12
question
Before using the Merge & Center command, what cell should contain the data?
upper-left cell
bottom-left cell
upper-right cell
bottom-right cell
answer
upper-left cell
question
Which of the following Page Setup options lets you set the Print area by selecting a specified range of cells?
Page
Margins
Header/Footer
Sheet
answer
Sheet
question
Which of the following keyboard shortcuts hides selected rows?
Ctrl+6
Ctrl+7
Ctrl+8
Ctrl+9
answer
Ctrl+9
question
Which of the following keyboard shortcuts opens the Format Cells dialog box?
Ctrl+1
Ctrl+2
Ctrl+3
Ctrl+4
answer
Ctrl+1
question
Autosum:
answer
a formula displays in the cell followed by the suggested range of cells
question
Fill handle:
answer
copy functions and formulas, such as Sum, into adjacent cells.
question
Format painter
answer
allows you to copy formatting attributes and styles from one cell to another cell or group of cells.
question
Freeze panes
answer
column and row headings display weather you are at the top, bottom, left, or right of a spreadsheet. When applied, excel is split into one or more panes, and displays multiple areas of the spreadsheet.
question
Document properties
answer
details that you can add to any office file. Also called metadata, you can use them to organize pr to gather basic info about workbooks.
question
Formulas
answer
copy formulas from the source but not the contents or formats.
question
Formulas & number formatting
answer
copy formulas and format for numbers and formulas of course area but not the contents.
question
Keep source formatting
answer
copy contents, format, and styles of source cell.
question
Formatting
answer
copy format of source cell without the contents.
question
Which of the following features would you want to use to center worksheet titles over multiple cells?
- AutoFormat
- AutoFit
- Merge & Center
- Wrap Text
answer
Merge & Center
question
Which of the following is the default paste option?
- Paste
- Formulas
- Formulas & Number Formatting
- Keep Source Formatting
answer
Keep Source Formatting
question
Which of the following options allows you to copy formatting attributes and styles from once cell to another cell or group of cells?
- Fill Handle
- Format Painter
- Paste Special
- Format Cells
answer
Format Painter
question
Which of the following statements is true?
- Workbooks can hold a maximum of 29 sheets.
- There is no limit to the number of sheets you can insert in a workbook.
- The number of sheets you can insert in a workbook is limited by the amount of memory available on your computer.
- By default, a workbook contains five sheets.
answer
The number of sheets you can insert in a workbook is limited by the amount of memory available on your computer.
question
Which of the following keyboard shortcuts opens a new blank workbook?
- Ctrl+A
- Ctrl+N
- Ctrl+O
- Ctrl+W
answer
Ctrl+N
question
Which of the following should you use to insert formulas and edit data?
- gridlines
- Formula bar
- Name box
- cell reference
answer
Formula Bar
question
Which of the following features enables you to display the contents of a cell on multiple lines?
- AutoFormat
- AutoFit
- Merge & Center
- Wrap Text
answer
Wrap Text
question
How should you save a file if you want it to be compatible with older versions of Microsoft Excel?
answer
Excel 97-2003 Workbook
question
Which of the following can you add to every Office file?
- document properties
- metadata
- timing
- both document properties and metadata
answer
both document properties and metadata
question
Which of the following displays when place your pointer on the border of an active cell or cells?
- selection pointer
- fill pointer
- move pointer
- resize pointer
answer
move pointer
question
Which of the following is the name used to describe a group of cells?
- columns
- rows
- range
- none of the other answers is correct
answer
range
question
Which of the following is included in calculations?
- labels
- values
- columns
- rows
answer
values
question
Which of the following views allows you to adjust page breaks?
Normal view
Page Layout view
Page Break Preview
Full Screen view
answer
Page Break Preview
question
Which of the following Spelling dialog box options skips all occurrences of the word in the worksheet?
Ignore Once
Ignore All
Change
Change All
answer
Ignore All
question
How many items can the Clipboard hold?
answer
24
question
Which of the following statements is false about hiding rows?
- Hiding a row deletes the data from the row.
- Hiding a row does not delete the data from the column.
- Hiding a row does not affect the results of calculations.
- After hiding a row, you can unhide it.
answer
Hiding a row deletes the data from the row.
question
Which of the following views lets you apply headers and footers and view the layout of the spreadsheet prior to distribution?
Normal view
Page Layout view
Page Break Preview
Full Screen view
answer
Page Layout view
question
Which of the following Page Setup options lets you change the orientation of a worksheet to Portrait or Landscape?
Page
Margins
Header/Footer
Sheet
answer
Page
question
When printing, what are Excel's default top and bottom margin settings
answer
0.75
question
Which of the following keyboard shortcuts moves cells or a cell range?
Ctrl+C
Ctrl+S
Ctrl+V
Ctrl+X
answer
Ctrl+X
question
Which of the following features resizes column width or row height to accommodate the width or height of the largest entry?
AutoFormat
AutoFit
Fill Handle
Wrap Text
answer
AutoFit
question
Which of the following paste options copies the formulas from the source cell(s) but not contents or formats?
Paste
Formulas
Formulas & Number Formatting
Keep Source Formatting
answer
Formulas
question
Which of the following displays the result of a formula?
cell
range
Formula bar
Fill Handle
answer
cell
question
Which of the following best describes the size of an Excel 2013 worksheet?
over 8,000 columns and 500,000 rows
over 500,000 rows and 8,000 columns
over 16,000 columns and 1 million rows
over 1 million columns and 16,000 rows
answer
over 16,000 columns and 1 million rows
question
Which of the following describes the section of the worksheet that prints?
gridline area
zoom area
fill area
print area
answer
print area
question
Once you have saved a workbook for the first time, which of the following keyboard shortcuts can you use to save it again?
Ctrl+F
Ctrl+K
Ctrl+R
Ctrl+S
answer
Ctrl+S
Haven't found what you need?
Search for quizzes and test answers now
Quizzes.studymoose.com uses cookies. By continuing you agree to our cookie policy
