Deck 1: Introduction to Excel

Question 1

Which of the following is not one of the recommendations when first designing a spreadsheet?

A)Decide what your purpose is
B)Decide what inputs you will need
C)Estimate the amount of time required to complete the spreadsheet
D)Decide what outputs you will need

Answer 1

C

Question 2

Which of the following is not a valid keystroke for navigating around a worksheet?

A)Ctrl + Home
B)Ctrl + End
C)Alt + Up arrow
D)Page Down

Answer 2

C

Question 3

New workbooks typically contain how many worksheets?

A)0
B)1
C)2
D)3

Answer 3

B

Question 4

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

Question 5

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

Question 6

How is text aligned by default?

A)Left
B)Center
C)Right
D)Decimal

Question 7

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

Question 8

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

Question 9

Which of the following is not a valid formula?

A)=D3
B)=2*2
C)=sum(1,2,3,4,5)
D)=#12/31/2014#-#12/31/2015#

Question 10

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

Question 11

Which of the following is not considered an Excel element?

A)Formula Bar
B)Name Box
C)Active cell
D)Print Preview

Question 12

What is not one of the tabs in Excel?

A)Formulas
B)Page Layout
C)File
D)Mailings

Question 13

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

Question 14

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

Question 15

Which keyboard shortcut puts the user in cell edit mode?

A)F2
B)Shift F2
C)F3
D)Shift F3

Question 16

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

Question 17

Where is the Show Formulas command found?

A)Formula Auditing group on the Formulas tab
B)Formula Auditing group on the Data tab
C)Formula Auditing group on the Review tab
D)Formula Auditing group on the Developer tab

Question 18

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.

Question 19

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.

Question 20

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)In the Page Layout tab, Scale to Fit group, select Automatic in the Width drop-down box
C)Double-click the line between the column headings
D)Right-click a column heading and select Column Width

Question 21

Which of the following names of worksheet tabs would be best?

A)Sheet 1
B)Jan
C)January Payroll Information
D)JPAE

Question 22

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

Question 23

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

Question 24

Which of the following is not a valid Cell Style?

A)Heading 5
B)Accent 3
C)Input
D)Calculation

Question 25

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 Formating Only

Question 26

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

Question 27

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

Question 28

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

Question 29

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

Question 30

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

Question 31

Which of the following is not included when you use a cell style?

A)Font
B)Cell protection
C)Alignment
D)Borders

Question 32

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

Question 33

The default number format is ________.

A)Number
B)Left aligned
C)Two decimal places
D)General

Question 34

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

Question 35

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

Question 36

Which Paste option would you choose if you wanted to flip the rows and columns?

A)Transpose
B)Rotate
C)Flip
D)Formulas

Question 37

Which is not a valid range?

A)A1:A3, B1:B3
B)A1:A9
C)A1:F1
D)A1:F9

Question 38

Where would you find the command to center the printout both horizontally and vertically on your paper?

A)On the Page Setup, Alignment tab
B)On the Page Setup, Sheet tab
C)On the Page Setup, Margins tab
D)On the Page Setup, Page tab

Question 39

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

Question 40

Besides the Page Setup dialog box, where else can you create headers or footers?

A)Page Layout tab, Text group, Header & Footer
B)Insert tab, Text group, Header & Footer
C)Home tab, Text group, Header & Footer
D)View tab, Text group, Header & Footer

Question 41

A(n)________ range contains several ranges.

Question 42

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

Question 43

You can add ________ color to a cell or range of cells for emphasis.

Question 44

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

Question 45

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

Question 46

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

Question 47

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

Question 48

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

Question 49

You can ________ a cell's contents to the right or left to help it stand out from the row above or below.

Question 50

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

Question 51

________ can be used in calculations, whereas text cannot.

Question 52

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

Question 53

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

Question 54

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

Question 55

The ________ feature helps you complete an incremental series.

Question 56

The current cell is also known as the ________ cell.

Question 57

When you want to format your spreadsheet with a consistent look you should use the ________ feature.

Question 58

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

Question 59

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

Question 60

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

Question 61

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.

Question 62

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

Question 63

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

Question 64

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

Question 65

Adding color to cells is not considered a professional design strategy.

Question 66

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

Question 67

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

Question 68

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

Question 69

Excel stores dates as numbers with 0 being 0 CE according to the Gregorian calendar.

Question 70

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

Question 71

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

Question 72

Use the Find command to jump to a cell that is not currently visible.

Question 73

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

Question 74

The contents of a cell can be seen in the naming box.

Question 75

Number ________ controls how a value appears in a cell.

Question 76

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.

Question 77

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

Question 78

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

Question 79

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

Question 80

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