BAT Chapter 1 Flashcards Preview

jeremy harmon > BAT Chapter 1 > Flashcards

Flashcards in BAT Chapter 1 Deck (15):
1

How does excel align numeric entries in a cell?

Bottom right corner of a cell

2

Alt+Enter

A key that enters a manual line break in a cell

3

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

Upper Left Cell

4

Ctrl+X

Cuts cells or a cell range

5

What is the same as the Paste option?

Keep Source Formatting Option

6

.xlsx

The default file extension given to Excel 2016 workbook files

7

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

Type an apostrophe before the number

8

Ctrl Key

Used to select non adjacent worksheets

9

Key F12

Opens the Save As dialogue box

10

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

Page Layout

11

Size of a 2016 Excel Worksheet

Over 1 million columns and 16,000 rows

12

Ctrl+1

Keyboard shortcut that opens the Format Cells dialog box

13

What 3 things are true about inserting and deleting columns?

- 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

14

Ctrl+ S Key Shortcut

Used to Save a document

15

Which 2 commands activate edit mode?

Pressing F2
Double Clicking a Cell

Decks in jeremy harmon Class (107):