COM S WEEk 1 QUIZ 1
Which of the following would not be considered text?
= 2*2
The position of data between the cell margins.
Alignment.
Which of the following is not a valid keystroke for navigating around a worksheet?
Alt + Up arrow
What is a fast way to apply several formats at one time?
Apply a cell style.
Helps complete a logical sequence
Auto Fill
Enables you to copy the contents of a cell or cell range or to continue a sequence by dragging the fill handle over an adjacent cell or range of cells.
Auto Fill.
Matches the letters you type to another value in the column if the letters match
AutoComplete
Given the formula =B1*B2+B3/B4^2, what operation is calculated first?
B4^2
Reverts back to previous data
Cancel
The intersection of a column and a row.
Cell.
You selected and copied worksheet data containing formulas. However, you want the pasted copy to contain the current formula results rather than formulas. What do you do?
Click the Paste arrow in the Clipboard group and select Values & Source Formatting
The letter in the cell reference "F4"
Column heading
The horizontal measurement of a column.
Column width.
Moves active cell to column A, row 1
Ctrl + Home
Which of the following characteristics is not applicable to the Accounting Number Format?
Dollar sign immediately on the left side of the value
This does nothing by itself
End
Accepts the data
Enter
Looks like a check mark next to the formula bar
Enter icon
Which step is not part of planning a worksheet design?
Enter labels, values, and formulas
In Excel, columns are identified by numbers and rows by letters.
False
The cell at row 4 and column B, would be identified as 4B.
False
The contents of a cell can be seen in the naming box.
False
You cannot hide column A or row 1 because they cannot be unhidden.
False
Which of the following is not an alignment option?
Fill Color
The background color appearing behind data in a cell.
Fill color.
Small green square used to perform various actions
Fill handle
A small green square at the bottom-right corner of a cell.
Fill handle.
Displays the content (text, value, date, or formula) in the active cell.
Formula Bar.
Shows the contents of the active cell
Formula bar
A combination of cell references, operators, values, and/or functions used to perform a calculation.
Formula.
Always begins with an equals sign (=)
Formulas
Moves active cell to column A in that row
Home
What should you do if you see pound signs (###) instead of values or results of formulas?
Increase the column width
Assume that the data on a worksheet consume a whole printed page and a couple of columns on a second page. You can do all of the following except what to force the data to print all on one page?
Increase the left and right margins
A range of cells containing values for variables used in formulas.
Input area.
Besides the Page Setup dialog box, where else can you create headers or footers?
Insert tab, Text group, Header & Footer
What is not one of the tabs in Excel?
Mailings
Displays the address of the active cell
Name Box
Identifies the address of the current cell.
Name Box.
Does not display margins or page breaks.
Normal view
Rules that control the sequence in which Excel performs arithmetic operations.
Order of operations.
A range of cells containing results based on manipulating the variables.
Output area.
Displays data and page breaks
Page Break Preview
Moves active cell down one screen
Page Down
Displays data and margins
Page Layout view
Also known as semi-selection
Pointing
How can you display formulas within the cells instead of the cell results?
Press Ctrl + `
A group of cells selected at the same time.
Range
A rectangular group of cells.
Range.
Moves right one cell in the same row
Right arrow
The number in the cell reference "F4"
Row heading
The vertical measurement of a row.
Row height.
Also called pointing.
Semi-selection
Allows you to go to the first, previous, next, or last sheet in a workbook
Sheet tab navigation
Displays the name of a worksheet within a workbook.
Sheet tab.
Displays information about a command or operation as it is being performed
Status bar
A combination of letters not used in calculations.
Text
Includes letters, numbers, symbols, and spaces.
Text.
What does pressing the Enter key while in a cell, do?
The value is set, and the cell below becomes the active cell
The fill handle allows you to copy and paste formulas to adjacent cells.
True
Using Alt + Enter is a text wrapping option.
True
You can hide or delete multiple rows or columns by using the Ctrl or Shift key and then selecting the rows or columns you want to hide or delete.
True
A measurable amount.
Value
A number that represents a quantity or an amount.
Value.
You just copied a range of data containing formulas. However, you want to preserve the formula results and the original number and text formatting in the pasted range. Which paste option would you select?
Values & Source Formatting
Icons that let you change views
View controls
A file containing related worksheets.
Workbook.
A spreadsheet that contains formulas, functions, values, text, and visual aids.
Worksheet.
Formatting that enables a label to appear on multiple lines within the current cell.
Wrap text.
The last possible column in a worksheet.
XFD
Allows you to see more or less on the screen at one time
Zoom control
The best way to apply Page Setup options to multiple worksheets is to ...
group worksheets
A range is specified by its ...
top left and bottom right cells