BAT Chapter 1

Question 1

How does excel align numeric entries in a cell?

Answer 1

Bottom right corner of a cell

Question 2

Alt+Enter

Answer 2

A key that enters a manual line break in a cell

Question 3

Before using the merge and center command, what cell should contain the data?

Answer 3

Upper Left Cell

Question 4

Ctrl+X

Answer 4

Cuts cells or a cell range

Question 5

What is the same as the Paste option?

Answer 5

Keep Source Formatting Option

Question 6

.xlsx

Answer 6

The default file extension given to Excel 2016 workbook files

Question 7

What must you do to enter a number as a label in a cell?

Answer 7

Type an apostrophe before the number

Question 8

Ctrl Key

Answer 8

Used to select non adjacent worksheets

Question 9

Key F12

Answer 9

Opens the Save As dialogue box

Question 10

What Page Setup option lets you change the orientation of a worksheet to Portrait or Landscape?

Answer 10

Page Layout

Question 11

Size of a 2016 Excel Worksheet

Answer 11

Over 1 million columns and 16,000 rows

Question 12

Ctrl+1

Answer 12

Keyboard shortcut that opens the Format Cells dialog box

Question 13

What 3 things are true about inserting and deleting columns?

Answer 13

• Insert a column, Excel moves existing data to make room for new data
• insert a row, functions / formulas are updated
• insert a row or column, functions and formulas reflect deleted rows or columns in the argument or range

Question 14

Ctrl+ S Key Shortcut

Answer 14

Used to Save a document

Question 15

Which 2 commands activate edit mode?

Answer 15

Pressing F2

Double Clicking a Cell