CSC Chapter 1 quiz study guide

One point is how big? A) 1/72 of an inch B) 1/36 of an inch C) The same as a pixel D) The same as one character

A) 1/72 of an inch

Which is not a valid range? A) A1:A3, B1:B3 B) A1:A9 C) A1:F1 D) A1:F9

A) A1:A3, B1:B3

Which keyboard shortcut puts the user in cell edit mode? A) F2 B) Shift F2 C) F3 D) Shift F3

A) F2

Where can you find more alignment options? A) Format Cells dialog box B) Format Alignment dialog box C) Format dialog box D) Format Rows and Columns dialog box

A) Format Cells dialog box

What can you not do within the worksheet tabs shortcut menu? A) Format the worksheet B) Add color to the tab C) Insert a worksheet D) Delete a worksheet

A) Format the worksheet

What Paste option would you choose if you wanted to maintain the formatting of the copied cell, but not its contents? A) Formatting B) Keep Source Formatting C) Paste D) Keep Formatting Only

A) Formatting

What is the true about an input area? A) It is used when certain values are used repeatedly throughout the worksheet. B) It is useful when your values change frequently throughout the worksheet. C) It should be located below the rest of your data. D) It should only contain one input cell.

A) It is used when certain values are used repeatedly throughout the worksheet.

How is text aligned by default? A) Left B) Center C) Right D) Decimal

A) Left

What can you not do from the Page Setup, Sheet tab? A) Set margins B) Set a print area C) Print gridlines D) Change the page order

A) Set margins

What can you not do directly from the Backstage, Print screen view? A) Switch to formula view and print formulas B) Select which printer you want to use C) Select how much of the worksheet will be printed D) Set the page orientation

A) Switch to formula view and print formulas

Which Paste option would you choose if you wanted to flip the rows and columns? A) Transpose B) Rotate C) Flip D) Formulas

A) Transpose

The best way to apply Page Setup options to multiple worksheets is to ________. A) group the worksheets B) use the Format Painter C) copy and Paste the formatting codes from one sheet to another D) use the Apply to Selected Sheets formatting command

A) group the worksheets

If you have too many words in a cell, but you cannot allow them to bleed over into the next cell, you would use the ________ feature in Excel. A) wrap text B) truncate text C) shorten text D) merge text

A) wrap text

New workbooks typically contain how many worksheets? A) 0 B) 1 C) 2 D) 3

B) 1

Which of the following is not included when you use a cell style? A) Font B) Cell protection C) Alignment D) Borders

B) Cell protection

Which of the following is not a way to widen a column? A) Drag the line between the column headings to the desired size B) Click on the Column label and drag it to the right. C) Double-click the line between the column headings D) Right-click a column heading and select Column Width

B) Click on the Column label and drag it to the right.

What is the best practice to switch the columns and rows in a range? A) Cut the range, then use the Paste Special option called Values B) Cut the range, then use the Paste Special option called Transpose C) Cut the range, then use the Paste Special option called Switch D) Cut the range, paste it into a blank area, then cut and paste each cell where you want it

B) Cut the range, then use the Paste Special option called Transpose

What is the small green square in the bottom right of a cell called? A) Sizing handle B) Fill handle C) Copy/Paste handle D) Move Cell handle

B) Fill handle

What can the phrase "Please Excuse My Dear Aunt Sally" help you remember? A) How to do date calculations B) Order of operations C) Naming convention for cell ranges D) The various printing options available in Excel

B) Order of operations

In the formula, =1+(2-3)+5/6-6^2, what will Excel evaluate first? A) 5/6 B) 1+ C) (2-3) D) 6^2

C) (2-3)

Which of the following is not true of the Formula bar? A) You can edit cell contents there. B) It is to the right of the Insert Function command. C) It allows you to pick from an assortment of formulas. D) It displays the contents stored in the active cell.

C) It allows you to pick from an assortment of formulas.

Which of the following is not true about a Fill color? A) It is color that displays behind the data in the cell. B) It can help the data stand out. C) It cannot be applied to an entire row or column. D) It should contrast with the font color.

C) It cannot be applied to an entire row or column.

Which of the following names of worksheet tabs would be best? A) Sheet 1 B) Jan C) January Payroll Information D) JPAE

C) January Payroll Information

What would not be a typical item to have in a header or footer? A) The spreadsheet designer's name B) The filename or file path C) The file size D) The page number

C) The file size

What does pressing the Enter key while in a cell, do? A) The value is set, and the active cell remains the active cell B) The value is set, and the cell to the right becomes the active cell C) The value is set, and the cell below becomes the active cell D) The value is set, and the action is the same as pressing the Tab key

C) The value is set, and the cell below becomes the active cell

What is the best practice for centering a title over multiple columns? A) Enter the title in the center column of the range B) Use the Merge Title feature C) Use the Merge and Center alignment D) Use the Combine and Center alignment

C) Use the Merge and Center alignment

17) What does it mean when you see ####### in a cell? A) Your formula is incorrect. B) At least one of the cell references in your formula is pointing to an empty cell. C) Your column is not wide enough. D) Your row is not tall enough.

C) Your column is not wide enough.

Which of the following is not a valid number format? A) $1,000.00 B) $ 1,000.000 C) (1,000.00) D) $ -1,000.00

D) $ -1,000.00

In the formula, =1+(2-3)+5/6-6^2, what will Excel evaluate second? A) 5/6 B) 1+ C) (2-3) D) 6^2

D) 6^2

Which of the following is not a valid formula? A) =D3 B) =2*2 C) =sum(1,2,3,4,5) D) =#12/31/2018#-#12/31/2019#

D) =#12/31/2018#-#12/31/2019#

Which of the following would not be considered text? A) Phone number (111.111.1111) B) Social Security number (111-11-1111) C) Part number (PT111) D) =2*2

D) =2*2

What feature in Excel allows you to begin with a 1 in A1 and a 2 in A2 and complete the sequence through the number 30 in A30 without having to type in the entire sequence? A) Auto Copy B) There is no such feature in Excel. C) Auto Complete D) Auto Fill

D) Auto Fill

The default number format is ________. A) Number B) Left aligned C) Two decimal places D) General

D) General

What should you do if there are columns you need, but do not want to display? A) Delete the columns you do not want to display then undo your action when finished. B) Move the columns you want to see so that they are together then move them back to their original locations with finished. C) Cut and paste the columns you do not want to display to another area of the worksheet. D) Hide the columns you do not want to display, then unhide them when finished.

D) Hide the columns you do not want to display, then unhide them when finished.

What is the best way to make sure your worksheet prints on only one page? A) Limit the amount of data you put on each worksheet B) Make the font sizes smaller C) Make the margins as small as possible D) Use the Fit to option

D) Use the Fit to option

Which Paste option would you choose if you wanted only the computed values to be pasted, but with all formatting intact? A) Paste B) Values C) Values & Number Formatting D) Values & Source Formatting

D) Values & Source Formatting

What do you adjust if you see ###### displayed in a cell? A) number format B) row height C) formula in the cell D) column width

D) column width

A range is specified by its ________. A) top and bottom row and left and right column B) top row and leftmost column C) top right and bottom left cells D) top left and bottom right cells

D) top left and bottom right cells

For the fill handle to work you need to have two cells selected. TRUE FALSE

FALSE

If you do not need a row or column any more it is best to hide it instead of deleting it in case you change your mind. TRUE FALSE

FALSE

If you want to unmerge cells you click the Unmerge alignment option. TRUE FALSE

FALSE

In Excel, columns are identified by numbers and rows by letters. TRUE FALSE

FALSE

Make sure to enter all cell reference in upper case when putting them in formulas. TRUE FALSE

FALSE

The cell at row 4 and column B, would be identified as 4B. TRUE FALSE

FALSE

The contents of a cell can be seen in the Name box. TRUE FALSE

FALSE

The row height should be the same size as the font height. TRUE FALSE

FALSE

The wrap text feature will automatically move any text that does not fit in a cell to the cell directly below it. TRUE FALSE

FALSE

When cells are merged, the merged cell's address becomes the address of the range. TRUE FALSE

FALSE

When you copy and paste a range the relative references do not change. TRUE FALSE

FALSE

When you insert rows or columns all relative references are updated but not any absolute references. TRUE FALSE

FALSE

You cannot hide column A or row 1 because they cannot be unhidden. TRUE FALSE

FALSE

zoom control

Makes the text on the screen smaller or larger

order of operations

PEMDAS

sheet tab

Shows the name of the worksheet

Adding color to cells is considered a professional design strategy. TRUE FALSE

TRUE

Bottom Align is the default vertical alignment. TRUE FALSE

TRUE

Displaying cell formulas can help find errors in formulas more easily. TRUE FALSE

TRUE

It is acceptable to use values in formulas when you know those values will never change. TRUE FALSE

TRUE

It is always a good practice to test each formula you enter for accuracy. TRUE FALSE

TRUE

It is relatively easy to copy Excel cells into other Office programs. TRUE FALSE

TRUE

Right-clicking a column heading, then selecting Insert, will add a new column to the left of the current column. TRUE FALSE

TRUE

The fill handle allows you to copy and paste formulas to adjacent cells. TRUE FALSE

TRUE

Using Alt + Enter is a text wrapping option. TRUE FALSE

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 FALSE

TRUE

You can move a range by using the cut and paste commands. TRUE FALSE

TRUE

You can select a range by using the Name Box. TRUE FALSE

TRUE

cell

The intersection of a column and a row

text

a combination of letters not used in calculations

Range

a group of cells selected at the same time

value

a measurable amount

The current cell is also known as the ________ cell.

active

Cell ________ refers to how data are located within the boundaries of the cell.

alignment

semi-selection

also called pointing

Formula

always begins with an equal sign (=)

The ________ feature displays any values in the column that match what the user has typed so far.

auto complete

The ________ feature helps you complete an incremental series.

autofill

A(n) ________ is a line you can put around a cell or range of cells for emphasis.

border

The intersection between a column and a row is called a(n) ________.

cell

You should use ________ in formulas whenever possible instead of simply typing in numbers.

cell references

A(n) ________ is a collection of format characteristics that provides a consistent appearance within a worksheet and among similar workbooks.

cell style

________ a carefully formatted worksheet can save you a lot of time when you need that formatting on another sheet.

copying

When you do not need the data on a worksheet you should ________ it to make the file smaller.

delete

name box

displays the address of the active cell

The ________ color is what is visible behind the value in a cell.

fill

The ________ feature can pull only part of a cell's value and place it into another cell.

flash fill

Number ________ controls how a value appears in a cell.

formatting

Shifting a cell's contents to the right or left to help it stand out from the row above or below is known as ________.

indenting

The ________ area is where you store the variable you will be using in the worksheet.

input

XFD

last possible column in a worksheet

A(n) ________ range contains multiple ranges that are not positioned in a contiguous cluster in the worksheet.

nonadjacent

The ________ area contains the formulas which are dependent on values found elsewhere in the sheet.

output

The ________ area is designed to contain formulas which are dependent on values in the input area.

output

The ________ feature allows you to see how a document would print before you actually print it.

print preview

A(n) ________ is a group of cells which have been selected at the same time.

range

Using ________ often decreases the amount of time it takes to enter cell references in formulas.

semi-selection, semi selection

A(n) ________ is a type of file that organizes data in rows and columns.

spreadsheet

Workbook

the same as the spreadsheet

________ can be used in calculations, whereas text cannot.

values

A(n) ________ is a collection of one or more related worksheets.

workbook, spreadsheet

The ________ feature allows you to move some text to another line within the same row.

wrap text